• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

Extracts from this document...

Introduction

Year 10 ICT Spreadsheet Report 1.0 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. 2.0 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. ...read more.

Middle

the tickets, pupils that have bought them, their form, quantity, whether they have paid, how many tickets sold altogether, the total income from the tickets and if there are still tickets available. After inputting all of my data I formatted my ticketsales sheet. I added colour to my sheet by clicking these buttons. Although on this particular sheet I only used this button This is because I didn't wont to colour my text in. I also used formatting to determin wheather the pupils have paid or not. I also put all of forms in order numericly by year group then alphabetically by form. 4.2 The Graph Data Worksheet To create the graph data table I used the pupils' forms from the my ticket sales sheet to help my calculate how many tickets were bought in total for each form. ...read more.

Conclusion

Until u reach the end and have a graph like this 4.4 How I created my Summary Data sheet I created a summary data sheet and named it ' Head Teachers Summary' 5.0 The Formulas and Functions I Used The formulas I used are detailed above in the following points 3.2 and 3.3. 6.0 The Graphs I created and Why I Created them I created the graphs to show my findings and make a comparison to the amount of tickets sold in each form and each year. I used bar chart graphs to compare the tickets sold in each year. But for the comparison of all the tickets sold together. 7.0 Explanation of How My Spreadsheet Answers 'IF' Queries I have used the 'IF' function to tell me if there are any seats available. To do this I entered the following formula: =IF(H2<300,"yes","no"). 8.0 How I used the SORT Function 9.0 How I Ensured My Work Was Accurate And Safe ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE DH Lawrence section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE DH Lawrence essays

  1. The aim of the financial report is to supply information on the costs and ...

    This was because the children tickets was so affordable so no matter how many they come in their numbers the adults will take the lead. As can be seen from the label above, 100% tickets sales were achieved. However adult tickets sales dropped to only 60%, which children increased to 33%.

  2. Financial report for school production

    The children ticket was 27% higher than the adult ticket. The OAP ticket was 7% as compared to those two nights as it was 10% and the second night 6%. The percentage tickets sold was 100%. This means that all seats were filled up.

  1. The aim of the financial report is to supply information on the costs and ...

    2nd Night Tickets Types Total tickets Total Revenue Adult tickets 205 *6.00 �1230 Children ticket 35 *2.50 �87.50 OAP tickets 15 *3.00 �45 Total tickets and Amount 255 �1362.50 2a ii Second night On the second day of the school production, the adult tickets was increased from 65% to 80%

  2. D(avid) H(erbert) Lawrence (1885-1930)

    and APOCALPSE (1931). "When it comes to living, we live through our instincts and our intuitions. Instinct makes me run from little over-earnest ladies; instinct makes me sniff the lime blossom and reach for the darkest cherry. But it is intuition which makes me feel the uncanny glassiness of the lake this afternoon,

  1. Compare the female characters in DH Lawrence&amp;amp;#146;s &amp;amp;#145;Tickets, Please&amp;amp;#146; and Thomas Hardy&amp;amp;#146;s &amp;amp;#145;Tony Kytes, ...

    Both John Thomas and Tony Kytes are popular with the ladies and have had many different partners. Tony Kytes has a weak character, as he is indecisive on who to marry, whereas, John Thomas, 'a fine cock-of-the-walk', is in complete control of the relationships he has.

  2. Compare the behaviour of the men and women in the two stories, one written ...

    "You should keep it in your pocket," replied Miss Stone," This quote shows how she resists and stops it going any further than flirting. She is said to be a "sharp tongued" girl this quote shows us how she replies back and this is where she is sharp tongued.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work