|Spreadsheets & Charts
- Expenses Spreadsheet (G Martin)
Spreadsheet to calculate the mileage expenses of employees and create a bar chart to display the information.
- Alton Towers Spreadsheet (G Cartlidge)
A short, neat task using a spreadsheet to calculate the cost of students going on a school trip. Simple data/formula entry and replication of cell contents.
- Disco Costs Spreadsheet (G Cartlidge)
In this task students calculate profit from the disco and find the number of tickets it is necessary to sell in order to break even. They can then examine the result of changing costs and how it affects the profit margin they could achieve.
- Spreadsheets Homework 1 (iwChameleon)
This is a tasksheet to follow an initial introduction/revision of basic spreadsheets. Questions cover data types, the sum function, cell references and effects of changing one cell.
- Spreadsheets Homework 2 (iwChameleon)
This is a tasksheet following on from initial introduction/revision of basic spreadsheets. Questions cover data types, the sum function, average and percentage.
- Tuck Shop Treats (F Stanbridge)
Create a spreadsheet of Tuck Shop sales. Insert/delete rows/columns. Perform calculations. Create bar, line and pie charts. Includes extension work.
