Term 4 – Spreadsheets

yr9_term4_spreadsheets_header

– Spreadsheets – 

In this unit you will look at what a spreadsheet is and why it is a useful tool when working with numeric data.  You will be able to design simple formulae and use some of the tools in Microsoft Excel such as AutoFill.  You will be able to format numeric data in a manner that is useful for your intended audience.  You will be able to produce and customise graphs.  You will be able to use conditional formatting to highlight actions that need to be taken.  You will also see how a spreadsheet package can be used to produce a simple mailing list that can be used by a word processing package to create a “mail merge”.

Lesson 1 – Burger Sales Spreadsheet
Lesson 2 – Burger Yearly Sales

Lesson 3 – Stock Levels
Lesson 4 – Profit and Loss
Lesson 5 – Calorie Counter
Lesson 6 – Mail Merge
Unit Assessment – Bob’s Café

Teach-ICT Keyword Revision Games
ICT Workout Revision Tasks (ask your teacher for the username and password)

Creative Commons Licence
Bob’s Burger Van (Year 9 Computing Unit) is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. This unit is (c)2015 Belper School and Sixth Form Centre.

Lesson 1 – Burger Sales Spreadsheet

Lesson Objectives * To develop basic skills in working with spreadsheets * Be able to use basic SUM formula * Be able to use the fill down handle Learning Outcomes Must Revise and refresh spreadsheet skills learnt in Y8. (Grade 4) Should complete the basic spreadsheet showing Bob’s sales figures, and decorate it with rich text […]

Lesson 2 – Burger Yearly Sales

Lesson Objectives * To analyse an existing spreadsheet and produce useful information * To produce information in a graphical form Learning Outcomes Must practice and improve on skills from last week’s lesson. (Grade 4) Should complete a well laid out spreadsheet with graph. (Grade 5) Could create a professional looking spreadsheet with a relevant, neatly presented graph. Estimate […]

Lesson 3 – Stock Levels

Lesson Objectives * To create new formulae * To set up conditional formatting to improve usability of the spreadsheet Learning Outcomes Must complete and decorate an existing spreadsheet . (Grade 4) Should add conditional formatting to the spreadsheet varying the colour of the cells depending on the content. (Grade 5) Could complete the above and use IF to create […]

Lesson 4 – Profit and Loss

Lesson Objectives * To understand what profit and loss is * To create new formula and improve an existing spreadsheet * To be able to take information and summarise that information Bob has another meeting, this time with his investors. They are worried that they won’t get a lot of money back this year and […]

Lesson 5 – Calorie Counter

Lesson Objectives * To link spreadsheets to real life situations * To use absolute formula and understand why absolute formula are important Bob has had a few customers asking about how healthy Bob’s food is. Bob has started to create a spreadsheet to help work out how many calories are in a typical meal and […]

Lesson 6 – Mail Merge

Lesson Objectives * To know what a mail merge is and understand how to create one * To develop skills in using spreadsheets with other applications Bob has a list of his regular customers names and addresses. Bob has a cunning plan to increase business at the van. He would like to send letters to […]

Unit Assessment – Bob’s Café

Lesson Objectives * To examine your ability to develop spreadsheets independently * To look at what skills you have developed over the previous lessons Assessment Criteria Level 4 – A spreadsheet has been produced, however there is little use of formulae or the formulae used are mostly incorrect.  Graphs have been produced however they might be […]