spreadsheet

this week we were required to plan, create and edit a simple one year personal financial management (income and spending) spreadsheet using calc.

then we were needed to name the sheet according to the month ie Aug11, Sept11, ... July11

after that, create a formula to calculate the a balance for each month. balance of August for example will be added to the next month.

again, the file is to be uploaded to google doc.


after that, we are needed to do a second task which is to plan, create and edit spreadsheet of students score and grade analysis.

i've learnt a  lot of new things in this assignment as we were needed to use;

• define name
• fill series
• VLOOKUP
• STDEV
• AVERAGE 
• COUNTIF
• graph
• sort
• filter

those stated above are the formula use in the spreadsheet.

after that, base on the data collected, we were needed to create graph to represent the data.

being as a teacher in the making, this knowledge is very useful to be use in the future.