Week 7(a) : Spreadsheet

In week 7(a), we are entitled to the task named Assignment 8(a) and 8(b). The first task would be for us to plan, create and edit a simple one year personal financial management which includes my income and spending throughout the year. The spreadsheet is done using Open Office Calc. Among the steps that need to followed to create a perfect spreadsheet is by naming the sheet according to the month. (Aug11, Sept11 …. Jul12). Our next job upon completion of the first step is to create a formula to calculate a balance for each month which brings a simple calculation as an example (the balance of August will be added to the balance of September to accumulate total balance/saving at the end of the year). The formula should be linked between the sheets.

Assignment 8(b) also instructs us to plan, create and edit a spreadsheet of students score and grade analysis. we should use of all the function to define name for table of grade and score, VLOOKUP is used to refer to the grade of the score, STDEV and AVERAGE or the score while COUNTIF to calculate how many students for each grade. Finally, we need to create suitable and meaningful graph and sort to rank the highest to the lowest score for each subject after filtering to select based on certain queries.




Microsoft office Excel
o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter