Lesson video

Hello.

My name is Charu.

This is lesson six in data and information unit.

In this lesson you will learn to present your data using graphs.

For today's lesson, you will need a pen and paper.

You will also need access to spreadsheet application.

You can use Google Sheets or alternative softwares such as Microsoft Excel or Purple Mash to calculate.

Please take a moment now to clear away any distractions, including turning off any notifications on any of the apps, and find a comfortable place to work.

Please pause the video, get comfortable and when you're ready press play.

In this lesson, you will choose suitable ways to present data.

Then produce a graph.

Use the graph to show the answer to questions, and finally, suggest when to use a table or a graph.

When you're presenting data, it is easier for people to understand when it is shown graphically.

This saves people from having to look through a detailed spreadsheet and make assumptions.

Using data and spreadsheets, it is possible to make a range of charts and graphs, pie charts, bar charts, column charts, and line graphs.

During this lesson, we are going to be making a pie chart based on spreadsheet you created in previous lesson.

I did remind you to save your spreadsheet.

You can open that for the task.

Or if you haven't saved it, you can follow the link from the worksheet and open the older depopulated spreadsheet.

I'm now going to demonstrate how to create chart using data from spreadsheet.

To create chart, we need to first click and drag to select the data we want to present.

So I'm going to highlight the cell G five, where it says venue total cost and drag down to highlight the cells to H ten.

But says budget leftover.

Now click insert, here on the top menu and then select chart.

This will automatically insert a pie chart using the data you selected.

You can now move this chart and place it where you want.

Can you make a pie chart using the data from the last lesson? This brings us to task one.

You can create your own pie chart now.

You could either follow the link on the worksheet to open the spreadsheet, or you could open your same spreadsheet from previous lesson.

Using the data from your spreadsheet, make a pie chart.

Please pause the video now to complete your task and resume once you've finished.

Welcome back.

You can now answer some questions using your pie charts.

What percentage of your budget was leftover? Have a little think.

Look at your pie chart.

You can consider some more questions.

Which spending type did you spend most money on? What percentage of your budget did you spend on the venue? What happens if you have double the attendees? These are some of the questions which you can answer just by looking at your pie chart.

Take some time, answer these questions.

After you've answered these questions, we can now move on to comparing ways of presenting data.

Now that you have used tables in spreadsheet view and graphs as pie chart to present data, take a moment to think.

When might you use the spreadsheet table view, and when might you use the graph? You would use a graph to show the information visually.

You might want to use a graph to show the overall cost and figures.

You might use a table to show a breakdown of all of the costs.

For example, the individual drink cost in our spreadsheet.

Tables are helpful when you want to sort data.

Use the data to perform different calculations using formulas.

Make changes to the data like adding and taking away items. Or view the individual figures.

Whereas, graph and charts are helpful when you want to see the data visually.

See the differences in the data.

Example the difference in spending if someone chose water instead of coke.

Compare the data.

Each type of presenting the data has its advantages and disadvantages.

So you need to make sure you're presenting it in the clearest way possible.

There will be three scenarios on the next slides.

I want you to think better.

You will choose to use a spreadsheet view, or graph to show the data.

There is no wrong answer, but you have to justify why you would use this method of presenting.

Let's look at the first scenario.

You want to show the teachers how many laptops are available to be booked out.

What method would you use? Table view or graph view? You have to think.

Do you want to display the individual pickers, or you want to see the data visually? That could help you to decide whether you want a table view or a graphical view.

Let's look at the next scenario.

You want to show the scores and statistics for the schools' netball team's season.

Which method would you choose? Table view or graphical view? You have to think.

Do you want to compare the data or do you want a visual data, or do you want to view the individual fitness? That will help you to decide whether you want to choose table or graphs to present your data.

Let's look at the third scenario.

You want to show the dietary information for the attendees of for school event.

Now, for this, which method of presenting would you choose? Table or graph? You might use a table to show a breakdown of all the dietary information, or you might want a visual representation.

You can decide how to present your data.

Well, that brings us to the end of today's lesson and to the end of unit of data and information.

Well done on all your hard work during the lesson.

I hope you enjoyed presenting data using graphs.

If you are able to, please take a picture of your work and ask your parent or carer to share it with your teacher.

And if you'd like, also share a picture of your graphs with @OakNational on Twitter so I can see your colourful graphs too.

Bye for now.