Advertisement

modelling

An APP assessment sheet with student friendly language for formatting techniques, planning and creating spreadsheet models.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Autumn_Spring_y8_3.doc33 KB

This is a complete scheme about modelling designed for year 8 students. This includes an assessment sheet matched against the national curriculum level descriptors.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Autumn_Spring_y8_3.doc33 KB

Several sample spreadsheets for students to play with and complete the exercises.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Excel_lesson_1_using_a_spreadsheet_model.xls54 KB

The fourth section of work about spreadsheets and modelling including a spreadsheets quiz to test understanding.

You need to Login or register to download the 5 files shown below. Registration is free and only takes a second.
AttachmentSize
further_finance_answers.doc147 KB
Further_production_finances.doc19 KB
spreadsheets_ls_4.ppt42.5 KB
starter_-_spreadsheet_quiz.doc25.5 KB
spreadsheets_ls_5.ppt36.5 KB

The third section of work for students studying spreadsheets and modelling. This resources are used to teach students about formulas and functions.

You need to Login or register to download the 4 files shown below. Registration is free and only takes a second.
AttachmentSize
Answer_for_plan.doc106.5 KB
sales_formula_task.xls38.5 KB
spreadsheets_ls_3.ppt33 KB
Weather_functions.xls113.5 KB

A selection of resources to continue teaching students about modelling. This includes a battleships cell referencing game starter and a plenary sheet.

You need to Login or register to download the 8 files shown below. Registration is free and only takes a second.
AttachmentSize
Lesson_2.ppt331 KB
Answer_for_plan.doc106.5 KB
basic_formula_task.xls26.5 KB
Battleships.xls88.5 KB
Planning_the_model_higher.doc92 KB
Planning_the_model_with_labels.doc94 KB
plenary.pdf479.5 KB
The_shows_finances.doc24 KB

During this lesson students will learn what a 'model' is and how formatting features improve readibility and clarity of data.

You need to Login or register to download the 3 files shown below. Registration is free and only takes a second.
AttachmentSize
Lesson_1.ppt155 KB
Formatting_techniques_on_excel.doc24 KB
excel_panto_example.xls37.5 KB