Spreadsheet exercise 1 - 'Easy as Pie'

This spreadsheet exercise provides students with an opportunity to practise:

• basic formuae
• create a pie chart
• basic formatting and printing options

Extension tasks are provided

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 3 - 'Absolutely Relative'

This spreadsheet exercise provides students with an opportunity to practise:

• relative cell references
• absolute cell references

Extension tasks are provided

Spreadsheet exercise 4 - 'Count IFULA'

This spreadsheet exercise provides students with an opportunity to practise:

• IF formula
• COUNTIF formula
• COUNTA formula
• COUNT formula
• RANK formula

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

Spreadsheet exercise 7 and 8 - 'Hogwarts 1 and 2'

This spreadsheet exercise provides students with an opportunity to practise:

• setting up validation

Extension tasks are provided

Spreadsheet exercise 9 - 'SORT it ahht'

This spreadsheet exercise provides students with an opportunity to practise:

• autofilter
• customising filter searches
• sorting data in a table
• recording macros
• assigning macros

Extension tasks are provided

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 X-box magazine. 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 a helpsheet on how to create a logo should they get stuck.

A set of images is provided for them to use.

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 s 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.