How to use Mario Kart to teach spreadsheets
Modelling Mario
Context
As part of the WJEC GCSE ICT controlled assessment, students are expected to create a spreadsheet to enable a club manager to work out who has the most points for different categories. The results of this are used to decide who receives the trophies at the club’s presentation evening.
In the following series of lessons, students will take it in turns to complete Time Trials around a specified circuit using Mario Kart on the Nintendo Wii. The students will compile the raw data generated by the class and input these into a suitable spreadsheet. The students will then use basic and advanced skills to improve the look and functionality of the spreadsheet (This will be based on the assessment criteria for the controlled assessment).
As part of the WJEC GCSE ICT controlled assessment, students are expected to create a spreadsheet to enable a club manager to work out who has the most points for different categories. The results of this are used to decide who receives the trophies at the club’s presentation evening.
In the following series of lessons, students will take it in turns to complete Time Trials around a specified circuit using Mario Kart on the Nintendo Wii. The students will compile the raw data generated by the class and input these into a suitable spreadsheet. The students will then use basic and advanced skills to improve the look and functionality of the spreadsheet (This will be based on the assessment criteria for the controlled assessment).
Lesson 1
| mario_lesson_1.pdf |
| Mario_Starter.xls |
Task Sheets
| Modelling_Mario_Task_Sheet.pdf |
| Investigating_Mario_Extension_Task.pdf |
Example Model
| Modelling_Mario_Example.xls |
Resources
Resources for this task.
| Modelling_Self_Assessment_Sheet.xls |
| Record_Sheets.pdf |
| Mario_Images.zip |
Help Guides
Help guides for this task (Note: Help guides currently only available for Excel 2007)
| Creating_Graphs.pdf |
| Creating_the_menu_page.pdf |
| VLookuUp_Help.pdf |
Lesson 2
Starter
|
| ||||||
