Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of ICT Spreadsheets
Put labels and numbers into a spreadsheet
Enter a formula on your sheet
Use the SUM formula to add lots of cells together quickly. Changing data to answer
‘What if....?’ questions and check predictions I need to calculate the cost per child.
Not all the children need to hire a sleeping bag, as two children have their own and one child cannot swim so he will not need to pay the fee for the pool. These slight differences mean that the total cost for each child won’t work out the same. I am taking six pupils from year 5 on a camping trip for two nights. ’ Using the formula ‘SUM’ to calculate different costs for a school trip You need to know how much money to take. Some of your friends are likely to change their minds
or some more friends might decide to join you. You want to take six friends to the
Mc Smart Burger Bar for a party. Entering labels and numbers for calculating totals.
Did you manage it?
Of course you did! Can you say it then?
“I know what a spreadsheet is, I can enter simple data
into a spreadsheet, and I can use simple formulae to
perform calculations. With help I can create simple graphs.” Congratulations! Select the data you are going to graph.
Now you are ready to create a graph! Find this icon and click it.
Select the column graph and click NEXT.
Click the ‘Series’ tab. Change each series, Series 1 – Boys, Series 2 – Girls, and Series 3 – Total.
Click NEXT and give your chart a title and label the X and Y axis.
Click NEXT, choose to place chart in new sheet, then click FINISH.
Now you can print your chart.
It’s that simple!! Task five Now you need to find out how many boys and how many girls are in each year group.
Find out and enter the data.
In column D use a formula to add up the totals.
Click on B10
Then click on on the toolbar. Open a new spreadsheet and set up the columns and rows as shown here. Creating Graphs
You can use spreadsheets to create graphs of your data.
Of course you will need some data to make graphs of! Task five Open a new document and enter this information into the correct cells. PE Kit
You receive a letter from your teacher. It tells you what PE you
need for the new term.
2 T-shirts, 2 pairs of shorts, 2 pairs of socks, a pair of trainers for
outdoors and a pair of plimsolls for indoors Task Four Try the same with divisions. Start in cell A2 and type in the even numbers. In cell B2 type in /2. Press enter. Fill in the total columns. Remember to save your work in your folder. Task Three Adding, Subtracting, multiplying and dividing two cells to explore number patterns. =a2*b2
This is because these are the cells with
the numbers we want to multiply.
Note want happens when you enter the
Now use the same method that you used
to FILL column B with 7’s to repeat the
formula in column C.
Can you remember how? Task one Enter this data as shown in the right cells.
We are going to make up some Multiplication tables. Click on cell B2.
Enter the number 7
Highlight the column from B2 to B13
On the Menu bar. Select: Edit – Fill – Down. The whole column will fill with 7’s.
Click on cell C2. We are going to enter the calculation.
What do we need to enter first? Open a new page in Microsoft Excel. Task one There is one more thing
that you need to know
About using a spreadsheets
to perform calculations.
The symbols for the
operations are not all the
So to calculate 3x4
You would enter =3*4
And the spreadsheet would
show “12”. (That’s the
answer!) Using formulae Let’s do something more difficult then!
Let’s use some formulae (that means sums!)
In Numeracy, when we write a number sentence we write the ‘=’ sign just before the answer, in a spreadsheet we write it first, before the sum.
So when you want a spreadsheet to work out a sum:
PUT THE = FIRST!
If you don’t it won’t work. Login and open Microsoft Excel
Entering data in spreadsheets is really easy!
You just click on the cell and type it in. Using formulae Once you know how to do it – they can do almost any maths that you could need! They are used to carry out lots of calculations quickly and to store large amounts of information for a range of purposes. A spreadsheet is a powerful tool for organising information. What can they do? What are they for? What is a Spreadsheet? Starting at the Beginning By the end of the lesson, I want you to be able to say… “I know what a spreadsheet is, I can enter simple data into a spreadsheet, and I can use simple formulae to perform calculations. With help I can create simple graphs” When you have managed to get as near to the budget as possible, you can print your spreadsheet and compare it to the ones created by other pupils in the class. Carry out a survey of both classes, asking which items are the most popular. You will
need to put this information into a graph so that you can see which are the most popular choices.
When you have done this, set up your own spreadsheet on the computer. Remember to plan what you think you will buy. You can not spend more than £60.00! You need to find out which games and toys are popular with both classes so that
your choices are fair. You have been given £60.00 from the money raised at the school fair to spend on games, toys and activities for use during wet playtimes. You will be sharing these with another class. Ask two of your friends to change one of their meal choices; perhaps they change an orange for a cola. Now recalculate the totals in the table. Save this work in your folder. Use the menu and decide the meal choices for you and your three friends. Type numerical information into excel. Burgers
Mc Smart Burger £0.90
Mc Smart Cheese Burger £1.10
Mc Smart Double Deluxe £1.60
Mc Smart Veggie Burger £1.00
double Choc £0.85
Fudge Delight £1.00 Now you are ready to create a graph!
It is easy – but watch carefully!! Click on B3, hold down the shift key and click on B8.
The column total should appear in B10.
Use this method to complete the rest of this spreadsheet. Creating Graphs
This tool allows you to add up column totals. Task five With the information shown above you can calculate the cost of you new PE Kit for yourself.
Fill in cells D2, D3, D4, D5 and D6.
Now select cell D7 and click on this symbol on the toolbar Press RETURN and the column total appears
Use multiplication to fill column E and F, and use to total up the columns. Task Four Task Two
In a new spreadsheet, can you create
the 8x table using the techniques we
have learned so far. If you have done it right, which you
will have done!
Your spreadsheet should look like this. Task one
The ‘Quick’ and ‘Easy’ guide to using Microsoft Excel Introduction to Spreadsheets 1.Work out the total cost using the information below.
2. I have been asked to take four extra children on the camping trip. They are going to make their own way to the campsite, so there will be no transport costs for them. Two children have their own sleeping bags. Work out the new total if these four children join the trip. Save both pieces of work in your folder. Cell
(Every one on these boxes is a cell) F22 Every cell has a name to help you find the right one.
Its name starts with the column letter and then the row number.
So, this cell is called what? Columns
(Up and Down)
(Side to Side)
[Numbered] So, how do they work then?