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

[tan yu yin]

It's a useful lesson as we can present complicated numerical data in a very systematic way.Presenting it in the form of graph allows us to interpret and analyse the data.

[Nisa binti Ali Hasan]

Today we learnt more of the Microsoft Excel - I finally clicked buttons which I never knew the use of! We learnt how to use formulas, and to synchronize it with graphs.

I'm really sure there is more to explore from the Excel.

[Salsabila Khuzairi]

I had fun in ICT class today exploring the wonderful tools in Excel, especially its ability to calculate data from a given formula, and the instant generation of statistical graphs :D

1. Type the details on the worksheet on Excel. Eg.(Name, mark for each subjet: Chemistry, History, Biology)
2. To total up the mark, type the formula, eg: =sum(b2:d2) and then press enter. Even easier, for the next rows, we can just drag from the edge of the first cell, and everything will be calculated immediately!! (yeah, it's better than our calculator XD ) We can do the same for average, min and max mark too.
3. To generate graph, select all the cells with involved data. Go to 'insert>graph.

I just fell in love with Excel :P   Thanks Dr. Ravi!

[Emily Neoh Gaik Kin]

Excel is a powerful tool indeed :)

I thought the most important thing I learnt today is the use of "what-if" analysis.

Thanks for an enlightening lesson, Dr. Ravi! :)

[Nur Ain binti Jelas]

Today, we have learnt how to use microsoft Excel more efficiently. Dr Ravi introduced us to the 'formula' features in Excel which makes the calculation mush easier. Also, it turned out that producing a graph based on data in Excel is such an easy task. we can also choose what type of graph we want to produce since there are a lot of different type of graph we can choose from.

[Izzatul Iman Binti Hanafi]

Today, we were guided on how to use the 'formula' features on Excel. After keying some data on the spreadsheet, we can type in the formula in the formula bar for automatic calculation. Then, by only dragging the box, we can copy the formulas to be used on other cells. Excel also enables us to create a graph from the data we have inserted, with a variety of designs to choose from.

[Chan Hooi Mui]

Today, my classmates and I have learned how to make use of Excel when it comes to drawing graph. It is simple just by adding some data and the tedious part will be inserting the formula i guess? Okay, I'm not going to explain the steps because i think most of us here have precisely stated the steps (so you can just review others's reply xP)

[Nurhannani]

Today I learnt how to use formulas in excel to caluculate my data and how to compile them into graphs :D

[hani hamizah bt nor hashim]

today i finally learnt the basics of using excell after agessss of pondering HOWWW haha. so excell is basically defined as a spreadsheet used to perform 'what if analysis' of inter-related column in a worksheet. i would say the 'autosum' icon greatly aids us in our calculations. Another alternative is to TYPE the desired formula.

go to the formula bar {fx} and type; =sum/average/min/max(eg b2:d2)

then if we drag the box down to other columns, the formula will repeat itself.

if we want to convert our data into a graph etc, go to the insert tab and choose the required way to present our data ^^

 

[Emily Neoh Gaik Kin]

Learning how to generate alternatives in the Excel spreadsheet was enlightening! :)

It's immense benefits to accountants and statisticians should never be undervalued...

[tan yu yin]

Now i know how to tabulate data in a systematic way,it's very useful.

[Nisa binti Ali Hasan]

Learnt how to do condition statement in Excel today - such a useful tool to classify information.

Much more to learn soon!