|Spreadsheets & Charts
- Spreadsheet Basics (L McCormack)
A handout that can be used by students as a reminder of the basic facilities in Excel and how to apply them.
- Expenses Spreadsheet (iwChameleon)
This is an expenses spreadsheet showing the cost of meals provided for people on a course. Inserting formulae and replicating, editing data, deleting data and more.
- Test Score Spreadsheet (A Atkins)
This spreadsheet requires a formula for calculating AVERAGE test scores, inserting columns, deleting rows and producing a graph from the data. As a learning tool I've also provided 'boxes' on the worksheet so that the students can write down how they performed various functions.
- ASA Factory Spreadsheet (A Atkins)
ASA Factory is a small business making wooden toys. You are a wages clerk in the business and it is your job to calculate the pay of all employees.
- Formulae Reminder Sheet (N Williams)
A useful 2 page handout containing the syntax for the most widely used formulae in Excel/Works (addition, subtraction, multiplication, division, percentage, average).
- Spreadsheet & Bar Charts (Higher) (N Williams / iwChameleon)
To create a spreadsheet for a small business showing 1st quarter expenses. Enter data, labels and values. Edit cell contents, save spreadsheet, create charts.
- Spreadsheet & Pie Chart (Higher) (N Williams / iwChameleon)
To create a spreadsheet for a newsagents showing newspaper sales. Enter data & formulae, edit cell contents, save spreadsheet, create pie chart with legend and percentages.
- Rainfall Spreadsheet & Charts (Higher) (N Williams / iwChameleon)
To create a spreadsheet showing rainfall across UK. Enter data & formulae, edit cell contents, insert rows, save spreadsheet, create pie chart, bar chart and comparative bar chart.
- Expenses Spreadsheet & Charts (Higher) (N Williams / iwChameleon)
To create a spreadsheet showing expenses for a small group of people. Enter data & formulae (sum & average), insert column, save spreadsheet, create & save pie chart and bar chart.
- Cinema Spreadsheet & Charts (Higher) (N Williams / iwChameleon)
Create a spreadsheet showing cinema attendance. Enter data & formulae (sum & average), delete row, add columns, save spreadsheet, create & save pie chart and bar chart.
