Lesson video

Hello and welcome to lesson five in our flat file databases unit.

I'm Andy.

And in this lesson we'll be looking at comparing data visually.

For this lesson, you'll need a computer with access to the internet and something to write on and to write with.

Other than that, please clear away any distractions then we can start.

In this lesson you'll be able to explain that computer programmes can be used to compare data visually.

You'll select an appropriate chart to visually compare data.

You'll refine a chart using a particular filter and your best to explain the benefits of using a computer to create charts.

So, first question, why do we use graphs? I'll give you a moment to think.

Okay.

Graphs are a visual representation of data, of information.

So sometimes it's a much quicker way to find something out.

It's easy to see the most or the least or to see how things change.

So often we use graphs because it's quicker and easier to see.

So let's look at this one.

What does this graph tell us? I'll give you a moment to look at it.

Okay, we have a title and it says how many legs do minibeasts have? And it has the name of the minibeast.

And it has a bar showing how many legs it has.

So this graph tells us how many legs four different minibeasts have.

So what's about this graph.

What does this graph tell us? I'll give you a moment to look at it.

Okay.

So we've got countries across here and it says population brackets, millions coming up here.

So that's 20 million, 40, 60, 80 million.

So I think it's telling us the population of different countries in millions.

So France has a population of over 60 million and Italy has a population of just about 60 million and so on.

So it doesn't have a title and it really should have a title.

What title could we give it? Okay, perhaps it's something as simple as population of different countries.

They will have to be in Europe.

It could be population of European countries but there's something about population and countries in the title.

So what about this graph? What does this tell us? I'll give you a moment to look Okay.

So we have lots of bars that all the same heights we have account and it's got decimal places a maximum of one and they're all one and it has lots different countries down here.

So I don't think it tells us anything really.

Other than lots of countries have one.

It could be how many names does a country have? It has one name.

Okay, so it doesn't have a title.

It doesn't have enough information to know what it's telling us.

So you've got a task now and on the worksheet, there are some different charts and you need to look at these charts and graphs and decide which one is the best one for answering the question that's on there.

So pause the video now.

Okay, so let's have a look at those together.

So the first question was which country has the largest area and we had two charts chart one and chart two and this is a bar chart and this is a pie chart.

And if we look at the two, we can see this one, biggest area is Russia.

It's quite clear it's a bigger bar.

On this one, that one looks the biggest it is Russia.

But if you want to know more than that, it's quite hard to tell difference between these.

So I think this is the better chart for that question.

Okay.

So the next question is which minibeasts have wings? And this has got, does it have wings, true false? And it just says how many? So it doesn't really tell us that much.

This tells us some many beasts and if they have wings or not.

So I think this is the more useful chart in this case.

So what questions could this graph answer? Okay, I'll give you a moment to look at it.

Okay, it's from the Titanic database and it says it's gender and survivor or victim equals S so it's the survivors.

So it's telling us that over 300 women females survived and just under 200 men.

So more women than men survived the sinking of the Titanic.

Okay, so here's the database and we'll have a go at making a chart.

So if I click on the chart tab then I can search for something, so I might click and search for let's search for first class passengers.

So 324 first class passengers and I'm going to have this sideways bar chart and I'm going to say gender.

Here we go.

And as you pointed it, it shows you so 144 female, 118 male.

So we could actually change this.

There's our graph.

It says gender first-class.

If I click on that, I could switch it to second and you can see the chart redraws itself.

So quite quickly we can get different charts or we can even try different views.

Okay.

So you're going to have a go yourself.

Okay, so your task is to use the chart tool to answer the questions on the worksheet.

So pause the video now.

Okay, so let's have a look at those different questions then.

So we were to find the answer and to note down the chart type that we chose, which axis we used what the fields were and why we thought that was the best chart for the job.

So the first question is, were there more males or females on board the Titanic? So I need to go to the chart and I'm just going to try if I click on this and do gender straight off I've got a chart and it tells me there's more males than females.

So I think that answers it.

That's pretty good.

That's pretty quick.

Let's try this one.

Pie chart works pretty well.

That's a nice one, we can clearly see there's more of this than that one Or the bar.

So I think any of these would be fine.

And it's whichever one you think was the clearest to see and that shows us they are more males than females on the Titanic.

The second question is how many second class passengers boarded at Belfast? So I'm going to search for this one.

I'm going to search for where they boarded.

And that was Belfast.

And it wants to how many second-class.

So if I click on that and choose class, it shows me first and second, it shows there's more seconds, but it's not as clear unless I hover and white, I think this might be better.

I can read quite clearly, six, second class passengers.

So I think that's probably the clearest.

Maybe this one, that's fine as well.

So one of those two works for that.

How many males were in first class? So if I go and choose class and I put first, so that's first class and that's class it's changed this one and we're going to do gender.

And that shows us males and females, and it's over 175 its 180 if we point.

Let's just try the others.

There's less markings on this,so that's not as easy to see.

And we've seen this one before.

It shows us through proportion, but not the number.

So I think this was the best option and it was gender.

So the last one was how many people boarded at Belfast or Queens town.

So I could clear this and I could just choose board it and see if that tells me.

Okay, so I've got each of the, the boardings there, Belfast or Queenstown I can see them.

There's this one.

I think this might be a little bit clearer.

So we've got the Belfast people who boarded and we have the Queenstown people who boarded.

But could also try searching.

Let's add that as well and see what we get.

So if we search for boarded at, and it was Belfast or Queenstown, so I had to go or boarded at Queens town.

Okay.

And actually if I graph boarding, I can see how many from each.

I could also get it to show me, say the gender.

So I can see that male or female balance of those who boarded at Belfast or Queenstown.

So all the people on either of those, that's how many men or women there were.

So I think there was different ones that would show that quite clearly.

And you could have used gender there.

You could have used boarded.

We could search.

You didn't necessarily have to.

Okay, so hopefully you might have worked through those.

If you want to go back and look at them, of course you can do that.

Okay, so that's almost it for this lesson.

So in this lesson you thought about which kinds of graphs and charts were most appropriate for the answers you were trying to show and you created charts and graphs to answer questions.

As always, if you'd like to share your work please ask your parents or care to share it for you.

And they can share it on Instagram, Facebook, or Twitter tagging it at Oak national and #LearnwithOak, see you next time.