Create a simple model using formulae and make use of basic formatting features.
Recap spreadsheet terminology
To use a range of formula with confidence
You will be able to write a formula and identify where you can find a cell, row, label, column and formula on a spreadsheet.
Let's get started
Open the link to a wordsearch and try to find as many words as possible while the register is being taken VIVO points will be given for the best results.
Let's look at this powerpoint to refresh your memory on some of the things we covered last lesson. This should only take us 5 minutes.
Click on the learning check and complete the first section to say what you know about spreadsheets and formula at the beginning of this lesson. Remember it's fine to say that you don't know anything at all, by the end of the lesson you will :). Be quick 2 minutes should be enough to enter your X's.
In todays lesson we will look at how to make a formula in a spreadsheet using + - / * and the, =Sum( ) function. This is important and we might need 15 minutes to cover this.
Open and save the formula spreadsheet then complete each worksheet. If you get stuck before you ask me for help try looking at the spreadsheet powerpoint to help you or you can ask a friend. You have 10 minutes to complete this task. I've also given you a link to some video tutorials.
You are now going to use your skills to create a spreadsheet to help Hurry Plotter buy all of the equipment he needs for his first term at Bogwalks. You will need to click on the spreadsheet link then follow the instructions. You have 20 minutes to complete as much as you can.
Let's look at how we did - Wizard Master?
Now complete the final section of the learning check to say how much progress you feel you made this lesson. I'm sure that you have all been really successful and helped Hurry to complete his shopping list. You have been awarded the title of Bogwalks senior spreadsheet wizard master - well done you :)
Wow you are really brilliant. The job of Grand Wizard Master is available try to complete the extension activity to show that you should be considered for the job - good luck.