Many thanks to Jon Bridgeman of Finham Park School for very kindly contributing the following resources:

 

Spreadsheet Exercises KS3, 4 and 5  
Spreadsheet exercise 2 - 'Online Auctions'

This spreadsheet exercise provides students with an opportunity to practise:

  • adjusting column widths
  • basic formatting and cell alignment
  • inserting new columns and rows
  • MIN, MAX and AVERAGE formulae

Extension tasks are provided

 

Spreadsheet exercise 5 - 'INTeresting T-Shirts'

This spreadsheet exercise provides students with an opportunity to practise:

  • INT function
  • percentage calculations

Extension tasks are provided

 

Spreadsheet exercise 6 - 'TEXT me'

This spreadsheet exercise provides students with an opportunity to practise:

  • PROPER function
  • FIND function
  • LEN function
  • LEFT function
  • RIGHT function

Extension tasks are provided

 

 

John has kindly contributed a set of cover lessons for year 7, units 7.1-7.6 and for year 8, units 8.1-8.4.

Each lesson comes with a pupil worksheet and a guidance sheet for the teacher. The guidance sheet is designed to be used by the cover teacher and will explain how the students should approach the tasks. It also gives guidance on internet usage and SEN.

Please note that there may be references on the sheets to Jon's school network directory structure so you will have to change these to suit your particular network and file system.

 

KS3 Cover lesson Resources  
Unit 7.1

This cover lesson asks students to create a storyboard on paper for a presentation for the school reception area.

If they have time, they should then create the presentation on the computer.

There is also an interactive crossword which they can have a go at.

 

Unit 7.2

This cover lesson provides students with four links to different sites containing information about Harry Potter.

Students are asked to visit each site and then assess the sites for their usefulness.

 

Unit 7.3

Two cover lessons are provided for this unit.

Cover lesson 1:

Students are given two pictures of the same magazine produced in different countries such as the X box magazine. (YOU WILL NEED TO FIND AND DOWNLOAD TWO RELEVANT IMAGES). They are asked to identify similarities and differences between the two versions. They are then asked to think about developing a magazine cover of their own from a choice of different scenarios.

 

Cover lesson 2:

Students are asked to design a logo for a new pizza restaurant. They are given clear instructions about things they need to consider.

 

There is also an interactive crossword should they need an extra activity

 

 

 

 

 

 

 

Unit 7.4

This cover lesson asks students to use a prepared spreadsheet to work out the costs of running a charity event at school.

 

Unit 7.5

This cover lesson asks students to think about creating a survey to find out the most popular choice of a trip for year 7. They write an hypothesis and then set up a spreadsheet to test their hyphothesis.

There is an interactive crossword that they can have a go at if they should finish the work set.

 

Unit 7.6

This cover lesson asks students to use the BBC Bitesize site and this site to undertake some research about computer control. They are then asked to consider whether a human or a computer controlled machine would be better to deal with a variety of tasks.

An extension task is provided.

 

Unit 8.1

This cover lesson asks students to access a data set and use it to create a suitable chart to display the data. They are then asked to interpret their findings.

 

Unit 8.2

This cover lesson asks students to investigate a selection of websites for different pizza restaurants. They have to collect ideas that they can use to help them design a homepage for a new pizza restaurant. They sketch out their homepage onto paper and if time, go on to create it using software of their choice.

Unit 8.3

This cover lesson asks students to choose a controversial topic from a given list. They are then asked to search the Internet for information about their chosen topic before answering a series of questions. If time, they go on to produce a PowerPoint presentation about their topic.

 

Unit 8.4

This cover lesson asks students to investigate a spreadsheet model based on a market stall selling computer supplies. They then go on to investigate some online simulations and afterwards write about what they have seen.

 

 

 

 

Copyright © www.teach-ict.com