This spreadsheet is going to be used to total up the number of tickets sold for the Sweet Charity production.

Authors Avatar

Year 10 ICT

Spreadsheet Report

  1. The Needs of the User

This spreadsheet is going to be used to total up the number of tickets sold for the Sweet Charity production. It will include the pupils, the number of tickets that they have bought, the cost of each ticket and the over all price to pay. This spreadsheet will help when additional invoices need to be sent out to people who still haven’t paid or finished paying.

  1. The Data That Will be Needed

There are lots of different types of data that I will enter into the spreadsheet. Some of these are: pupils names, pupils forms, costs, pupils who have paid and more. All of this data will need to be collected beforehand. It is important that there are no errors.

Join now!

  1. The Work Sheets, Formulas and Functions I plan to

Use

  1. The Worksheets I Will Create

I will create several worksheets these include ticket sales, graph data, year 7 8 and 9 graphs, a pie chart and a head teachers summary.

  1. The Functions That I Will Use  

I will use two functions on my ticket sales sheet and graph data sheet, these are ‘if’ and ‘sum’ functions. I will only use the ‘if’ function once this is when I am trying to find out how many ...

This is a preview of the whole essay