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

____________________________________________________________________________________

Upon completion of this week's assignment, I did not encounter any problems as I have learnt about spreadsheet before taking this course. However, I have learnt to create spreadsheet by using OpenOffice.org Calc which is my first time using it whereby normally I use Microsoft Office's software. It is a new experience and a good exposure for me to learn various OSS and always update with the latest invention.

~Happy Distance Learning~

~Microsoft Office VS. OpenOffice.org~
Which one do you prefer?
(image retrieved from http://technobuffalo.technobuffalo.netdna-cdn.com/files/2010/10/microsoftoffice-vs-openoffice.jpg)

~Chew~