|Spreadsheets & Charts
- Burger Bar Spreadsheet & Charts (Higher) (N Williams / iwChameleon)
Spreadsheet showing sales in a burger bar. Work out total income from sales & unit prices. Multiplying cell contents, adding/inserting columns, print out formulae, create bar chart.
- Meter Readings Spreadsheet & Charts (Foundation) (N Williams / iwChameleon)
Spreadsheet showing meter readings ready for preparation of electricity bills. Work out total amount payable from usage, standing charge & unit cost. Multiplying/adding cell contents, print out formulae, create bar chart.
- Mail Order Spreadsheet & Charts (Foundation) (N Williams / iwChameleon)
Spreadsheet showing the stock for a mail order company. Work out the mark-up, retail price & total from sales. Multiplying/adding cell contents, print out formulae, create bar chart.
- Record Shop Spreadsheet & Charts (Foundation) (N Williams / iwChameleon)
Spreadsheet showing sales in a record shop. Calculate total income from sales. Multiplying cell contents, formatting cell contents, insert row, print out formulae, create bar/pie charts.
- Wages Spreadsheet (Foundation) (A Atkins)
Spreadsheet showing wage calculations for factory employees. Calculate basic pay plus overtime. Multiply cell contents, format cell contents, delete row, print out formulae.
- Spreadsheet Formulae: Help Sheet (M Smith)
Two-page handout that gives simple reminders about the syntax of the most common formulae that students will need to know.
- Spreadsheet Formulae: Task Sheet (E Endersby)
This worksheet gives a step-by-step walk-through of a spreadsheet task including multiplication, autosum, percentage and reminders about formatting.
- The Grape Vine Inn (iwChameleon)
Calculate the weekly income from meals sold in the pub and the profit made on those meals. There is space on the sheet for students to make notes about how some tasks were completed.
- Structure of an Excel Spreadsheet (C Browne)
This is a simple screenshot of an Excel spreadsheet for students to complete by creating labels, as indicated, using text boxes. Give it as a short activity in a lesson or print it out and distribute for homework.
- Sports Spreadsheet (D Machin)
This task requires some thought. Create a scoring record system for a sport of your choice. Student must create spreadsheet from scratch.
