Week 7a ( Spreadsheet)

Week 7a (Spreadsheet)
Learning about Spreadsheet by doing Assignment 8 (8a & 8b)


Learning by doing Assignment 8a
Plan, create and edit a simple one year personal financial management (income and spending) spreadsheet using OpenOffice.org Calc.
Name the sheet according to the month ie Aug11, Sept11 …. Jul12
Create a formula to calculate a balance for each month (ie. balance of august – will be added to the balance of sept). Link the formula between the sheets.
Upload the file to google docs (spreadsheet) and edit it if necessary. Share with your lecturers.
Openoffice Calc
- Set formula ( use of “=”)
- ∑
- Function wizard
- Link between sheets

Learning by doing Assignment 8b
Microsoft Excel
Plan, create and edit a spreadsheet of students score and grade analysis (use function: define name for table of grade and score; VLOOKUP to refer to the grade of the score, STDEV and AVERAGE or the score; COUNTIF to calculate how many students for each grade; create suitable and meaningful graph Graph; sort to rank the highest to the lowest score for each subject; filter to select based on certain queries:
>> Microsoft Excel
o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter


While finishing this assignment, i learn that there are a lot of new things for me to discover about program especially OSS because they are full of functions which can make thelesson become more interesting. I also learn that some data are very easy to organize using this kind of program in a short period of time.