Week 7a- Spreadsheet

"It is the spreadsheet."

This week, as responsibility mounts, we have a spreadsheet that needs thinking and programming.
The task is like this.


Plan, create and edit a simple  one year  personal financial management
(income and spending)  spreadsheet using 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.

As the spreadsheet finished, the amount of spending can be seen clearly.

The other one, is by using Mic 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"

This one is tough, believe me.


:DD

Till then,
Zira.