Over the past month the year 5 and 6 students have been developing their skills with using a spreadsheet as part of our financial unit in Digitech. One part of this unit involved us students having to apply for a job by completing a letter of application and personal resume. All students who completed their job application got a job although there were a few students that had to go on a job seeker allowance because they did not finish their application. Once jobs were assigned the students had to calculate how much they would get paid then take away deductions such as tax, superannuation as well as other expenses such as insurance, food and transport. We kept a record of all of this using our spreadsheets which was much easier when we learnt to use the different formulas.

Here is a picture of my spreadsheet calculating the earnings of a computer programmer.