Hello, I'm Mr. Little.

Welcome to today's Computing lesson.

It's from the unit Introduction to spreadsheets and the title of today's lesson is Presenting data using charts.

We are gonna be making some pie charts today along with lots of other really interesting things.

So make sure your brains ready, you work as hard as you can and you try your best and that will make today's lesson a success.

Let's get started.

By the end of today's lesson, you'll be able to present data so it's easy to understand and use.

There are two key words that I want you to watch and listen out for.

The first word is chart and that's a way of presenting data graphically, and graphically means using pictures or images and not just words.

So we're gonna be looking at lots of different charts today and there are some examples for you to look at on the screen now.

The second word is pie chart.

And a pie chart is a type of chart and it's a circular chart where sectors represent different groups in proportion to each other.

And we're gonna be learning about what each of those words means in the definition of pie charts as we go through.

So let's get started.

I split today's lesson into two parts before we create a pie chart in the second half of today's lesson.

First of all, we're gonna compare charts.

So a chart is a way of presenting information graphically.

And remember that's with pictures, with images and not just words.

So it's a little bit like a picture, like a graph or a diagram and it helps you explain and understand numbers and information a little bit more easily.

Let's look at some examples.

You might recognise these.

Do you know the names of them? That first one is a bar chart.

In the middle we have a pie chart, and on the right hand side we have a flow chart.

You might have used these before.

So let's check your understanding of one of our keywords today.

Let's see if you know what a chart is.

So I want you to complete the sentence.

A chart is, a, a way of presenting information using images, b, a way of presenting information correctly, or c, a way of presenting information graphically.

It's c, well done if you got that right? A chart is a way of presenting information graphically.

So let's link that learning to what we know about spreadsheets.

Spreadsheets often contain data and information.

When you are using a chart to present that data or information, it makes it easier often for others to understand.

And lots of times it saves people time when they're looking for something specific.

So when they're looking for a detail, often a chart helps present that really clearly and it will save people looking for information in a spreadsheet because it presents the information graphically with pictures or images.

Izzy and Alex here are having a conversation.

Izzy says, "Using a chart makes things clear for me when I'm looking for the most or least of something." Alex replies with, "Charts help me compare information and look at similarities, what's the same, and differences, what's different." Izzy and Alex a correct here.

So often remember charts help present something and make it clear whether it's the most or least of something or what's the same or what's different.

So let's look at some of those different types of chart we explored earlier.

This is a bar chart and a bar chart uses rectangular bars to show different values and we've labelled that first bar for you to look at.

And remember, the bar is part of the overall chart and bar charts could be shown vertically, so that's top to bottom.

So in the top example, the bars go up from the bottom.

And on the lower example, bar charts could be presented horizontally.

So that's left to right.

In this example of a bar chart, it shows the number of pages read by Jun, Izzy, Lucas and Aisha.

So on the left hand side we've got a table with headings, we've got the names of the pupils, Jun, Lucas, Izzy and Aisha and then the second column is the pages read.

So Jun's read 290 pages, Lucas has read 210, Izzy has read 127, and Aisha, she's been a bit of a bookworm, she's read 382 pages.

And then on the right hand side I've used the bar chart to present that information.

So the information on the left hand side is exactly the same as the right hand side, but on the right hand side we have a bar chart that's a way of presenting the data in a table graphically.

And we can quickly see here Aisha has read the most pages and Izzy has read the least.

And it's really important to highlight here the table on the left and the bar chart on the right show the same information.

So let's check your understanding specific to bar charts.

Is this true or false? A bar chart uses circular bars.

It's false, but why is that? Remember a bar chart uses rectangular bars to show those different values.

Let's look at a different type of chart now and let's look at pie charts.

So a pie chart is a circular chart.

So a pie chart is always represented by a circle where the sectors represent different groups in proportion to each other.

So let's explore that a bit further.

Each part of the pie chart or the pie slice of a pie chart is called a sector.

So let's look at that bottom example of a pie chart.

We've got two sectors, the green sector and the purple sector.

In the top example, we've got one, two, three, four, five, six different sectors and they represent some information in relation to each other.

Let's look at and check your understanding of the correct definition of what a pie chart is.

So choose one of these, is a pie chart a circular chart where sectors represent different groups in proportion to each other.

A circular chart where bars represent different groups in proportion to each other.

Or c, a rectangular chart where sectors represent different groups in proportion to each other.

a is the correct answer here, well done if you selected that.

Remember a pie chart is a circular chart where sectors represent different groups in proportion to each other.

So let's have a look at another example of a pie chart and we've paired it with a table of information, and it shows the favourite colours of 12 children in year one.

So here we've got a table with favourite colour and number is the headings.

We've got green, red, blue, and purple.

And we've got the number of children that selected those.

It looks like one person chose green, two selected red, three selected blue, and six chose purple as their favourite colours.

Let's look at that information represented graphically on a pie chart.

And this is where pie charts are really useful because you can really quickly see that the purple sector and we've coloured it purple as well to make it even easier for people to understand.

The purple sector is the most.

And let's link it to a bit of maths, I know that six is half of 12 and my pie chart shows half of my pie as my purple sector.

Three people chose blue.

I know three years a quarter of 12.

So a quarter of my pie chart is filled in as blue.

I've got red chosen by two people.

Two is 1/6 of 12.

So I've got two selected for my red sector and then one out of 12 for my green sector.

Looks like Izzy's put her hand up here and asked a great question.

"When might I use a bar chart?" So we're going back to thinking about bar charts here.

Let's see when we might use a bar chart.

It might be when you want to compare lots of data points precisely.

Remember that example of the pages read by Izzy's classmates.

We can quickly compare those data points, the number of pages each pupil read.

It might be useful also when there is lots of categories.

Let's imagine we chose or we had our class of 30 children and we wanted to compare the number of pages they each read.

A bar chart would be a really clever way of presenting that data graphically.

Also when the data doesn't add to a whole.

So when you are not trying to look at numbers in proportion to each other, is when you might use a bar chart.

So Izzy asks here, when is it a good idea or when might I use a pie chart? And let's look at what the answers might be.

So you might use a pie chart when you want to show visually how the categories contribute to a whole.

Remember that example of the favourite colours? Remember we had six showed half of the whole, so six were chosen by half of the pupils as their favourite colour.

And also when there are fewer categories, sometimes a pie chart is quite hard to show detailed information.

So when there are a few categories, it's a good chance to use a pie chart.

Okay, time to put all of that knowledge you've learned about charts into practise with this task.

I want you to fill in the missing words using the word bank at the bottom, but you don't need to use all of the words.

I've put some in there, so you need to think really hard about which ones are the correct ones to select.

So number one, I want you to fill in the two missing words for a something is a way of presenting something graphically.

Number two, a something chart is a circular chart where something represents different groups in proportion to each other.

Number three, a bar chart uses rectangular something to represent different amounts of data.

And number four, a pie chart always represents a something amount, while a bar chart can show amounts that don't add up to something of something.

So have a go at filling in the missing words using the word bank.

And remember, you don't need to use all of the words.

Okay, let's look at the answers.

So number one, a chart is a way of presenting data graphically.

Number two, a pie chart is a circular chart where sectors represent different groups in proportion to each other.

Number three, a bar chart uses rectangular bars to represent different amounts of data.

And number four, a pie chart always represents a whole amount.

While a bar chart can show amounts that don't add up to a 100% of something.

Well done if you got those right.

The second part of today's lesson, we are gonna get practical and we are gonna be creating a pie chart.

Okay, let's get practical now and look at how to create a pie chart in a spreadsheet.

The first thing you need is some information in a table and Lucas is gonna talk us through what he's done here.

Lucas says, I've asked all of the children in year six what their favourite colour is from a choice of four.

So Lucas has given all of the children in year six, four colours to choose from and each child has to choose their favourite colour from that choice, and he's put the results into a table on a spreadsheet.

Looks like Lucas has been really smart here.

He's used headings, colour and number of pupils.

So he's got green, red, blue and purple and he's totaled up the amounts that each colour has been chosen.

So green is 13, red is 22, blue is 31, and purple is 19.

And remember when you are making a pie chart in a spreadsheet using headings for your data is really important.

Lucas has done that.

And if you don't include headings, the pie chart is gonna be a little bit confused in which data to use.

So you must use headings when you are creating your tables of information for your data.

The pie chart might actually be labelled incorrectly if you don't do this.

When you are making a pie chart in a spreadsheet, it's really important to select all the data you need.

Here the pie chart will only include choices of green and red 'cause I've only selected the cells with the headings colour and number of pupils and then green 13 and red 22.

I haven't selected all the data I need.

So in this example, my pie chart would only show green and red.

It wouldn't show all of the data.

So what I'd need to do here is click and drag all the way down to the bottom two cells purple and 19.

Okay, let's look at this graphic of how to insert a pie chart.

It's gonna keep repeating, so let me talk you through it.

First thing I need to do is highlight the data that I need.

So I'm clicking and dragging and highlighting the data.

I'm then clicking insert from my toolbar and then I'm gonna click chart and it creates a pie chart for me.

I'll talk you through that again.

Highlight the data, click insert from the toolbar and click chart and the spreadsheet automatically inserts a pie chart for you.

Really important here, remember I'm selecting all of the data I need.

Once more, highlight data, click insert and then chart.

Let's check your understanding.

There's a missing word here and I want you to choose from the options which missing word should complete this sentence.

A spreadsheet will make a chart based only on the you have selected.

Is it a, data, b, boxes, or c, formulas? It's data.

Remember when you are creating a pie chart, you need to select all of the data you need.

And a true or false check for understanding.

Now, creating a pie chart requires information from a table.

Is that true or false? It's true.

Remember when you are creating a pie chart, you need to select information from a table.

So when you are presenting a pie chart, sometimes it's useful to change the colour of the sectors on the pie chart.

So in this example here, we are changing the colours so they match the colours that each pupil chose from Lucas's example.

So let's look at how you do that.

When your pie chart has been inserted, you can double click on the sector of the pie chart you want to change.

And on the right hand side of your screen, it will appear so you can edit the pie sector.

And here you can see I'm changing what's labelled as my purple sector from green to purple and what's labelled as my green section from green, sorry, from blue to green.

And then what's labelled as my blue section from that yellow orangey colour to blue.

So a reminder, you double click the sector of the pie chart you want to edit and then choose a colour from the right hand side of your screen.

So Izzy and Alex have been tasked with creating a pie chart.

They're discussing and thinking about what they need.

Izzy says, "Before we make a pie chart, we need to collect our data and enter it into a spreadsheet." Spot on there from Izzy.

Alex replies with, "To create the pie chart.

We can use the information in our completed party planning spreadsheet." So remember in a previous lesson we planned a party, we planned an event using a spreadsheet, and I'm gonna show you an example of creating a pie chart using that information and data.

So we are gonna look at Alex's party and this pie chart shows the costs for Alex's class.

First of all, I'm showing you the table.

So we've got party items and costs are heading.

We've got the venue total costing 150 pounds.

The activity total cost is 20 pounds.

The drinks total cost 3.

60 pounds, the food's total cost 35.

70 pounds, essentials total cost is 16.

50 pounds, The budget left over is 224.

20 pounds, and the total party cost is 225 pounds ATP.

So it looks like Alex has inserted a pie chart here.

And this pie chart shows really quickly the different piece of information that Alex has spent on the budget for his class's party.

I'll give you a moment to look at that pie chart.

And it looks like we've got six different sectors.

Although the table has got seven rows in it, we haven't included the total party cost in this spreadsheet we've just selected all the way down to the budget leftover.

And we can see here that the orange sector is the most amount of money.

It looks like Alex has got some budget left over.

He's actually spent the most of his money on the venue cost because that's the second biggest sector, that smallest sector, that small slither, that small sector of the pie chart is the drinks total cost.

You can see Alex has spent the least on his drinks.

And remember this is important, the table and the pie chart show the same information.

So remember here while the table show the exact amounts, the pie chart shows the data visually.

So if I want the exact amounts I've spent, I might have to look at the table here, but the pie chart shows the data visually and graphically.

Let's look at that orange sector in a bit more detail.

It shows here that Alex has almost got nearly half of his budget left over, 'cause I can see that what looks like almost half of that pie chart is orange and that shows the budget left over.

One of the other benefits of a pie chart is you can add labels to help show you different things.

So here I've labelled the pie chart to show the largest sector is the budget leftover and the smallest sector is the total drinks cost.

Another benefit is that I can add percentages to each sector.

So I've got the spreadsheet to include the percentages for the budget leftover 49.

7%, almost half of Alex's budget.

If it was another 0.

3% that would take it to 50% and that'd be half of Alex's money.

Whereas a third, 33.

3% of Alex's budget has gone on the venue total cost.

Remember that's another benefit of using a pie chart.

You can add these things in if you want to.

Another great question here from Izzy.

"Are charts always easier to understand compared to table?" So why might I use a chart compared to a table? Let's have a look.

Remember pie charts show that information and data visually and they make it easier to spot patterns.

They're not designed to let you read exact amounts from them always, but tables information are provided to show exact values.

Remember Alex's example, you had the table and the chart next to each other.

So presenting the tables and charts next to each other is often really, really useful.

Okay, let's check your understanding.

Is this true or false? Presenting tables and pie charts together is helpful.

It's true.

Remember when you are presenting a pie chart often it's useful to show the table of data together.

Okay, time for a practise task and time to create your own pie chart.

So I want you to create a pie chart showing the total cost of your party plan.

Now, if you've created your own party plan, you can use that.

If you haven't, you can use Izzy's completed party plan.

When you are creating that pie chart remember to select all the information you want to show and remember, you can edit your pie chart so that it has a title and a legend and you can edit the colours of the pie chart if you want to as well.

So let's watch the media clip to explain how to do this.

In this clip gonna show you how to insert a pie chart.

We're using this spreadsheet that we've used before.

It's got my items, my spending type, my cost, my quantity, and my subtotal and we've used formulas to work out the subtotal.

I've also got my attendees, my budget per person and my total budget using a formula.

So to insert a pie chart, you need to highlight some information and we are gonna use this table as our information.

So we've got our party items and our overall party costs.

I'm gonna click and highlight that until I get down to budget left over.

I don't want my total party cost or my party cost per person in my pie chart, so I'm not gonna select that.

I then go to my toolbar and click insert and chart and it'll insert a pie chart for me.

Now the first thing I'm gonna do is move the pie chart around and make it slightly bigger.

And then I'm gonna change the font size for my title by clicking on my title and changing my font size.

Let's go for 24.

And for my chart legend or my labels, I'm gonna change the font size also to 24.

Now on the pie chart, you can change things round.

If I want to change the colour of a certain sector, I'm gonna double click on the sector.

I can go over to the right hand side to customise my colour.

And also I can also change my style of my chart.

I can change the background colour if I wanted to.

The border colour, I can make it 3D.

I can add in a donut hole on the right hand side here, I can change the title.

So this is Izzy's party.

I'm gonna make that bold.

Now, one of the benefits of using a pie chart on a spreadsheet, let's just make it smaller so you can see.

Is that if any of my costs change, my pie chart will automatically update.

So keep an eye out.

Let's say my venue cost actually gets more expensive.

So instead of costing 150 pounds in cell C2 here, let's say it doubles in cost.

So it's now 300 pounds.

I'm changing the cost, we've still only got one of them.

The subtotal will update.

And as soon as I press enter, I think our venue venue total sector will get bigger.

So let's have a look, let's press enter.

Notice how my venue cost now is the largest sector of my pie chart.

Let's change it back to 150.

Let's say my party games and price increasing in cost from 20 pounds to 50 pounds.

I'm gonna change that and press enter.

And you can see my activity total sector gets larger here.

So your pie chart will probably look different to Izzy's example here.

And let's have a look at Izzy's overall party costs.

Looks like the budget leftover she's got, she's labelled it with percentages as well.

She's got 41.

8%.

The biggest amount of money left over is what she's got left to spend.

She spent 33.

3% on her venue cost.

Her activity, total cost is 11.

1%.

She spent a small amount on her drinks total cost 0.

8%.

Her food total cost is 8.

6%.

And then she spent 4.

3% of her budget on her essentials.

So we're almost at the end of today's lesson, but before we finish, let's summarise what we've learned together.

Remember, a chart is a way of representing data graphically.

So a way of presenting data with pictures or images.

And we looked at two different types of charts in detail today.

We looked at bar charts and they're useful when you might wanna compare multiple points of data really precisely, or if there are many categories or if the data doesn't always add up to a whole.

And secondly, hopefully you created and we looked at in detail what a pie chart is.

And remember, they're useful when you need to show visually how the categories contribute to a whole.

And also when there are a few categories to show, that's when pie charts are useful to present.

And remember, when you actually creating a pie chart using a spreadsheet, presenting it alongside a table with headings is really important.

I hope you enjoyed creating a pie chart in today's lesson.

See you again soon.