ICT August 2013 batch

[Ravichandran]

Dear ICT students of AUG 2013 batch under Dr.Ravichandran, I welcome you all this Web portal, which you will be using for your entire course. This http://as-computing.ning portal is were you will have to upload / post all the classroom based activities.

The CIE ICT task will have to be handed to be in person at the end of each CIE task class and the question paper/ CIE folder should not be take with you under any circumstances. That is, the folder should be given to me after your use in class once you complete your Cie task for that particular class.

For further doubts and queries please contact me or you can even send a message using this Web portal.

FROM NOW ON YOU WILL USE THIS WEB PORTAL. AND REMEMBER TO POST ONLY IN THE FORUM NAMED ICT JAN 2013 BATCH. NOT ON OTHER FORUMS WHICH IS MEANT FOR OTHER BATCHES.

WE WILL DO 5 TASKS OF CIE , WHICH MEANS YOU NEED TO COMPLETE, WORD, EXCEL, POWERPOINT, DATABASE AND HTML TO GET QUALIFIED FOR A DIPLOMA.

Regards,

Dr.Ravi

[Chong Xue Mei]

The use of Excel especially for the accountants is fantastic! Just by putting in some formula, it makes the analysis way easier. I was glad to have the opportunity to learn this. :)

[Faizah Abdullah]

Today our task was to use Microsoft Excel again and we were taught how to insert a new formula for the table. This class was helpful as I now know how to save time calculating data.

[Nor Syahira Khusni]

learnt how to use the "if" formula(conditional statement)in class today. It was something new as i have never really make use of excel in completing my task before

[Faiz Zakwan Bin Che Abdullah]

I've learned how to classify numbers in a very practical way by using Excel ! Thanks Dr Ravi ! how lucky I am to have a teacher like u :))))))))

[Ida Sahira binti Ideris]

Today I have learned how to use excel formula for true and false statement. It will be very useful when we need to analyse numerous statistical data.

Example of the formula :

=IF(B2>65,"OLDER ADULT",IF(B2>29,"ADULT",IF(B2>19,"YOUNG ADULT",IF(B2>12,"TEEN",IF(B2>5,"CHILD",IF(B2>1,"SMALL CHILD"))))))

 

[Nurhannani]

=IF(F2>350,"excellent",IF(F2>300,"good",IF(F2>250,"pass")))

this was the formula that i used today. I've learnt how to use excel and the formula box to determine for me the grades or levels of my data

[Izzatul Iman Binti Hanafi]

We continued to learn the usage of formulas in Excel. Today, we constructed a formula of conditions. An example is this.  =IF(B2>80,"A",IF(B2>60,"B",IF(B2>50,"C",IF(B2>40,"D")))) This may be useful in the future for statistical reasons.

[hani hamizah bt nor hashim]

today we learnt a little bit more on excell which is using the 'conditional statement'

the formula is basically --->  =IF(B2>50,"pass","fail")  etc

to use multiple conditionioning, we do something like this ---> =IF(B2<30,"D", IF(B2<70,"C", IF(B2<80,"B", IF(B2<101,"A"))))

[Chan Hooi Mui]

Okay, my class today have learned to categorize data according to a set of ranges we set. What's awesome is that we just key in the necessary format. For eg, [    =IF(B2<50,"fail",IF(B2<70,"B",IF(B2<90,"A",IF(B2<100,"A*"))))     ]  and the excel will do the rest for us. Life is made easy with Excel =D

[Chong Xue Mei]

Class task:

A:MORTGAGE.XLS 

[Emily Neoh Gaik Kin]

EXCEL EXERCISE

[Faizah Abdullah]

Today's class assignment. Very useful for future Accountants.