Spreadsheets and Modelling
How Have You Done?
Learning Objectives:
- to assess what you have learned.
Task 1: Test yourself
- If you haven't done it already, try out the online interactive exercises to see check out what you can do.
Spreadsheet 1- A short test on key words
Spreadsheet 2- A test on labels, formulae and values
Spreadsheet 3- A timed test to see if you undersdtand a spreadsheet
Task 2: Checklist
You should have the following items in your folder as evidence of your work:
- Printout of completed Shop spreadsheet
- Printout of first Zoo spreadsheet
- Printout of Zoo spreadsheet with formatting
- Biscuit model completed worksheet
- Charts spreadsheet with barchart
- Other versions of the Charts printout showing different types of charts.
- Survey results with chart
- Spreadsheets Evaluation sheet
Task 3: Assess your progress
- Which of these descriptions fit you? What level have you reached?
| MODELLING (SPREADSHEET) SKILLS | |
3 |
I can decide for myself when I use a spread sheet or a game to model something form the real world |
3 |
I can use models / simulations to solve problems e.g. a spread sheet |
4 |
I can make predictions about what will happen as a result of my decisions |
5 |
I can explore what will happen if I change the formulas in a spread sheet model |
Task 4: Evaluation Sheet
L-Zone
Most recent revision 28 March 2007