I Am Learning     ATL




spreadsheet


You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
Eleventh Spreadsheet Exercise.doc629 KB
survey_test0901.xls17.5 KB
You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
Tenth Spreadsheet Exercise.doc808 KB
hotels_test0901(2).xls33.5 KB
You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
Ninth Spreadsheet Exercise.doc886.5 KB
hotels_test0901.xls33.5 KB
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Fifth Spreadsheet Exercise.doc904.5 KB
Tags:
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Seventh Spreadsheet Exercise.doc476.5 KB
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Sixth Spreadsheet Exercise.doc477 KB
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Third Spreadsheet Exercise.doc366 KB
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
First Spreadsheet Exercise.doc458.5 KB
Tags:
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Instructions for spreadsheets.doc1.1 MB
Tags:

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:

A simple starter activity where student need to match up the questions and answers. A teachers answer sheet is provided.

You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
Card Matching Quiz.doc29 KB
Card Matching Quiz Answers.doc31.5 KB
Tags:

The success criteria to show students what they need to create a successful business spreadsheet.

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

A simplified spreadsheet definitions worksheet for KS3.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Spreadsheet Definitions.doc276 KB
Tags:

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

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

Studens are given a scenario in which santa needs to work out whether his income (generated through selling the mince pies etc. left out by the people he visits) is enough to cover his spending (the cost of presents, elf wages etc.)

A template spreadsheet is provided for students and a completed spreadsheet including formatting etc. is provided for teachers.

You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
delivery_costs_student.xls17 KB
delivery_costs_teacher.xls16.5 KB

This fun excel workbook works out how many days old you are. Great for a quick starter or plenary to demonstrate the power of spreadsheets.

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

A cell referencing quiz in which students have to look up letters in the cell references given to spell out words.

.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Cell referencing quiz.doc31.5 KB
Tags:

Here is the makings of a fun spreadsheet model to learn about conditional formatting and formulas. It needs tailoring to your own requirements but the majority of the work is done.

*Updated* - A guide sheet is now included. This isn't really explicit; instead students should try to figure things out for themselves using the 'Help' feature and Google. Students could try to produce their own stadium working in small groups.

.

You need to Login or register to download the 2 files shown below. Registration is free and only takes a second.
AttachmentSize
Stadium Spreadsheet Model.xls25.5 KB
Stadium Booking System - Spreadsheets Warm-up.doc25 KB
You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Spreadsheet Starter.xls145 KB
Tags:

Y7 - Spreadsheet models
Powerpoint presentation on spreadsheet models.
Definition of model, rule and variable.

Also included is an example spreadsheet for demo, a task sheet for lesson, the task spreadsheet and a help sheet.
Also a homework on models.

You need to Login or register to download the 5 files shown below. Registration is free and only takes a second.
AttachmentSize
Sweet Shop Example.xls98.5 KB
SidsSnowSchooltask.xls31 KB
task.doc43.5 KB
help_sheet.doc322.5 KB
homework.doc136.5 KB
Tags:

Matching the key terms to the description.
Used as a starter activity for a Y7 lesson on spreadsheets.
Students should already know to how do many of the things mentioned on the activity.
Could be used for any KS3 lesson on spreadsheets.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Starter.doc40.5 KB
Tags:

This spreadsheet can be used as an example to students who should then produce their own. The invoice uses formulas to calculate the totals, the SUM function and an IF statement to print a 'free' delivery message if the total spend is over £100

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Downloadable Tunes Invoice.xls76 KB
Tags: