I Am Learning     ATL
Home

modelling


Year 8 APP Sheet 3

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
Tags:

Spreadsheet Modelling SoW

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
Tags:

Sample Spreadsheets

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
Tags:

Modelling Part 4

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
Tags:

Modelling Part 3

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
Tags:

Modelling Part 2

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
Tags:

Modelling Part 1

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
Tags: