Spreadsheet Starter Warm Up
Never used a spreadsheet before? Not to worry... this resource will help, download the Excel activity pack below and work through the activities.
| basics.xls |
Lesson 1: Computers and Christmas Dinner
Starter: Play the game,
Did you have a good Christmas holiday? How was the Christmas Dinner? Let's us a computer to model and analyse the Dinner! In this lesson you will learn how to use a spreadsheet to model the calories consumed in your Christmas dinner, look for patterns and analyse the data.
Now lets model, calculate and analyse your Christmas Dinner
Homework
Complete this Homework
Did you have a good Christmas holiday? How was the Christmas Dinner? Let's us a computer to model and analyse the Dinner! In this lesson you will learn how to use a spreadsheet to model the calories consumed in your Christmas dinner, look for patterns and analyse the data.
Now lets model, calculate and analyse your Christmas Dinner
Homework
Complete this Homework
Lesson 2: Advanced Features in Spreadsheets
Starter: Play the game
In this lesson you will learn about and use advanced Spreadsheet features such as What is AutoSum, MAX, MIN, COUNT and Average. Use these functions and formulas to analyse further your Christams Dinner!
Homework
Complete this worksheet Homework
In this lesson you will learn about and use advanced Spreadsheet features such as What is AutoSum, MAX, MIN, COUNT and Average. Use these functions and formulas to analyse further your Christams Dinner!
Homework
Complete this worksheet Homework
Lesson 3: Modelling, Exercise and Christmas Dinner.
Starter: Play the game
How did exercise impact on your Christmas Dinner?
In this lesson you will use the skills and knowledge you learnt in lessons 1 and 2 to complete and exercise section of your spreadsheet. This can then be compare to the calorie side that you completed last lesson.
Extension task Homework
How did exercise impact on your Christmas Dinner?
In this lesson you will use the skills and knowledge you learnt in lessons 1 and 2 to complete and exercise section of your spreadsheet. This can then be compare to the calorie side that you completed last lesson.
Extension task Homework
Lesson 4: Graphs, Charts and What They Tell Us,
Starter: Play this game! yes this one --game,
The data in your spreadsheet looks great but, it is difficult to analyse. A better method is to produce a graph or chart. In this lesson you will learn how to create graphs and charts.
What does a graph tell you about your dinner?
The data in your spreadsheet looks great but, it is difficult to analyse. A better method is to produce a graph or chart. In this lesson you will learn how to create graphs and charts.
What does a graph tell you about your dinner?
Lesson 5: Earthquakes and Spreadsheets
This lesson uses Data, Spreadsheets and a modelling to predict and track where Earthquakes occur. Is there a pattern? What does the data tell you? Use the resources below to find out.
|
Lesson 6 and 7: Lies, Computers and Image Editing
How can computers make pictures tell lies? Have you seen pictures that you thought could not be real. Can a celebrity really be that tall, pretty or buff? In this lesson you will learn how Pixels can be used to make an image. Pixels can be changed and therefore the overall picture can be manipulated. Learn the techniques and then create your own fake picture.
Look at these resources: Pixels, Pixel 2
Look at these resources: Pixels, Pixel 2
