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

[LIM GEK TENG]

EXCEL

I learnt something new today which I think its gonna be useful in the future. 

Auto sum eases the process of summing up just in one click. Also, same goes to  the formulas used in order to calculate average, min and max.

The interesting part is plotting the graph by selecting the column data which I had added. 

[Emily Ong Hui Xian]

I have learnt something new using microsoft excel today.This helps me a lot when i want to do statistics.

Everything can be calculated by either the formulas or auto sum just in one click.

The graph of the data can be show clearly.

[Kong Wee Lee]

Today's lesson we have learnt how to use Microsoft Excel to create worksheet which includes the "what-if" analysis.

1. Type in all the variables required ( Name, Subject, Mark, Average...)

2. Complete the details and fill in all the required values

3. To sum up the total mark, apply the formula, eg.  =sum(E2:B2) as well as for other variables ( =average(B2:B2))

4. We can check the formula by pressing the show formula button

5. We can insert a graph using insert>graph

[Alyea binti Abdul Aziz]

Our task today was to create a worksheet using Microsoft Excel

1. Insert the details in the column (Name, Marks for 4 Subjects, Total, Average, Min, Max)

2. To find the total marks for each student, highlight all the marks of the student and click 'AutoSum' or type the formula eg. =sumb2:e2 and then press enter

3. Same thing can be done to calculate the average, min and max of the data

4. Click Insert bar to choose the graph that you want to present your data

[Saw Ran Sing]

Today we learnt how to use the "formulas" feature of Microsoft Excel.

1. Type in the details  (eg. Name,mark of each subject)

2. Sum up the marks by typing the formula --> =sum(b2:e2)

3. To apply the same formula to the column, click the workspace n hover your mouse to the right hand corner of the box then drag it down the entire column.

4. Same steps can be used to find average, min and max

5. To add graph, go to Insert > Column

[QURRATA AINI MOHAMMAD TINGGAL]

We have learn a new useful skill today on how to create and perform 'what-if' analysis using Excel.

1. insert the details - (name,subjects-history,math,chemistry & physics,total,average,min and max)

2. fill in the numbers in each column.

3. use the formula (sum,average,max and min) to gain the value.

4. drag the items needed to be included and click the insert (column) to create a colourful graph.

Done!

[Nurul Jannah bt Mohd Jailani]

I've always been in the dark as to how to properly use Excel. Today's lesson helped me a lot in terms of giving me a general idea of what it can be used for. Just now we learned how to generate a graph on Excel based on the data we keyed into each cell.

Step 1: In each cell on the top row, fill in criteria like name, subject name, marks, total, average, minimum and maximum. 

Step 2: Fill in all the marks for all subjects corresponding to the names listed. 

Step 3: In the first cell directly underneath "Total", fill in the formula for calculating the total marks across 4 subjects for the first name on the list. (=TOTAL b2:e2) 

Step 4: When you drag the corner of that cell down all four "Total marks" cells, Excel will automatically calculate the totals for the other rows too. 

Step 5: You can also use this trick to replicate the min/max and the averaging function across all four cells. (=MIN b2:e2) (=AVERAGE b2:e2)

Step 6: Drag your cursor from the first cell (Name) up to the bottommost cell in the "Total" collumn. 

Step 7:Press the Insert tab at the top of the page and click the graph button. A graph based on all the information that has been typed in will be generated.

[Afeeq Shaszwan Bin Zambre]

Today we learned how to make use of the Excel's powerful formula mechanism. The steps for doing so are typed below:

1) Run Excel and put in data on the worksheet. Headings (Name, marks, etc...) on the topmost row and the details (Steve, 360, etc...) in the columns.

2) To total up the marks type in =SUM(E2:B2) and enter. This is to calculate the sum of data from clocks E2 to B2. The same can be replicated to find the average, maximum value, minimum value and many other things. Or if you are lazy you can always press the Autosum. To each his own.

3) 'Highlight' all the data you would like to appear visually and click on charts under the insert tab. Congratulations on finally figuring out Excel. Give yourself a pat on the back. 

[Debra Tang Choi Yin]

Today we got to explore Microsoft Excel, which to me is a systematic and useful way of organizing data. We learned to post numerical data and organize it into separate columns. Additionally, we also learned to construct grafts or diagrams based on the numerical information posted beforehand. In short, it was a valuable lesson for me. 

[Nor Syahira Khusni]

Today we learnt about how to use the Excel properly and Dr Ravi introduced to us the easiest way to calculate our data and the most important thing is that we can turn it into graphs, which is impossible to do in Words unless you bring in the graphs form the Excel itself. excel is a spreadsheet used to create and perform "what-if analysis" of interrelated column in a worksheet.

to enter the formula, we must put a = sign first

when you have completed all the calculations, click insert and choose charts and create your own graphs, and right-clicking the graphs will able you to change the details displayed on the graphs.

for example =sum(a2:d2) and press enter and highlight the columns or rows in which you want the answers to be summed for you and wallah! you'll get the total even though you only entered the formula once.

 

[Faizah Abdullah]

today i have learned how to calculate data quickly and efficiently using microsoft excel.it is a very systematic and useful tool to use for everyday life. i also learned how to create a graph and analyse data from it.

[Chong Xue Mei]

I learnt how to make the full use of Microsoft Office Excel today. It was insightful as Excel can help me to organise my data in a systematic way. By writing a formula in the formula box, it makes my task easier! Besides, we can also represent the data using graphs and charts. :)