Lesson video

Hi, I'm Ms. Miah.

Thank you so much for joining me in this lesson today.

In today's lesson, you'll be able to construct bar charts from data using technology.

Your key words are on the screen now, let's go through them together.

The frequency is the number of times an event occurs or the number of individuals with some specific property.

A bar chart, or bar graph, is a graph consisting of bars visually representing the frequency of objects or groups.

And lastly, data are a collection of information.

So, this lesson is all about constructing bar charts by utilizing technology.

We've got two lesson cycles today, and our first lesson cycle is to do with creating bar charts on spreadsheet software, and then we'll be looking at creating bar charts using a template file.

I'm super excited about this lesson, I hope you are too.

Let's begin.

Now, there are many different spreadsheet software available.

Two of the most common are Microsoft Excel and Google Sheets.

Their functionality and appearance are fairly similar.

Find out which spreadsheet software you have access to and open a new spreadsheet.

So, Google Sheets looks like this on the left.

Spreadsheet software has many functions and capabilities.

This lesson is only focusing on its chart creation, specifically, bar charts.

One part of the data cycle is collecting and representing data.

Although this can be done by hand, often investigations result in a large amount of data and using software allows this to be sorted and displayed very efficiently.

Most careers that collect, present, and analyze data would use technology.

Data as a list can be copied and pasted into a spreadsheet.

Laura says, "You can use the keyboard shortcut Control + C and Control + V.

" This saves typing each word separately, which saves time.

What other benefit is there to not typing each word?

Have a think.

So, we know it will save time, but it can also prevent mistakes.

So there we are, data entry is avoided.

Copy this list into your spreadsheet file.

So we're gonna paste the data and ensure it is in a column format.

Have a look here.

Over to you.

Which direction does a list need to be for the spreadsheet to create a chart?

Is it A, horizontal, B, vertical, or C, it doesn't matter?

What do you think?

You can pause the video here and click Play once you've got the answer.

So what did you get?

If you got B, vertical, well done.

The data needs to be vertical on the spreadsheet.

Let's move on.

So, once the data is in the spreadsheet, we can visualize it using charts.

So have a look here.

So here we've got the pie chart and then we can also change this to a bar chart, and you can do this with one click.

Back to you.

Order the steps for inserting a chart from a list of data.

So we've got click Chart, select all the data, change the chart type if necessary, go to the Insert tab on the top ribbon.

You can pause the video here and click Play once you've done that.

So how did that go?

Step one, select all the data.

Step two, go to the Insert tab on the top ribbon.

Step three, click Chart.

And step four, change the chart type if necessary.

Well done if you ordered those correctly.

Let's move on.

If your data is already in a frequency table, then you can copy the whole table onto the spreadsheet or you can type it in.

So here on the left you've got a table.

It shows the gym class and then the frequency.

So we've got aerobics, circuits, spin, and Zumba, and the frequency is on the right.

I'd like you to copy this table onto a new sheet in your spreadsheet.

The following steps use Google Sheets.

Let's have a look.

Follow these steps to insert a bar chart using the frequency table.

Another gym class is offered called Step and 16 members attended.

Let's update the frequency table and check the bar chart.

So you can see it's been reflected there just by adding it in to the table.

So here is some data for different books.

Have a look.

The auto scale was increments of 50.

What scale would you use?

20 or 25 might seem sensible.

The spreadsheet software will detect the data and automatically choose multiples of 50 for the vertical axis.

So here on the left we've got the frequency and then across the X axis we've got books, representing the number of pages per book.

Izzy says, "This scale makes a lot of empty space.

" Let's make the vertical axis go up in multiples of 25 instead.

Have a look.

Over to you.

Add the vertical axis according to this setup.

You can pause the video here and click Play once you're ready to continue.

So how did that go?

Let's have a look.

We can see the Y axis going up in increments of 30.

Over to you.

One, the flower sales at a garden center are recorded.

A, create a bar chart for this list of data.

And you can see quite a few flowers have been listed there.

Ensure it has a title on both axes.

B, would you advise the garden center to order an equal amount of each flower next time or different amounts?

Explain your answer.

Create a bar chart for this table of data about visitors to a museum.

So, on the left we've got the day of the week and on the right we've got the frequency.

I'd like you to ensure it has titles on both axes.

Three, create a bar chart for this table of data about visitors to a museum.

What is different about this bar chart?

You can pause the video here and click Play once you've completed this task.

So how did that go?

Let's have a look.

For one, it doesn't matter if you have changed the colors of the scales, but this is what you should have got.

1B, your response may have included something like this.

The total of sales is not very high.

So although daffodil sales were the lowest on this particular day, it may not be the case on another day.

The garden center should collect further data to get a better understanding of the sales.

This is what your bar chart should have looked like.

Three, so what was different about this bar chart?

Well, it is a comparison bar chart as there were two sets of data for the same thing.

Well done if you managed to complete that task, let's move on.

Creating bar charts using a template file.

Let's start.

Creating bar charts is a fairly simple task on spreadsheet software.

The formatting and design can take a little longer.

Some individuals may need to create multiple charts.

Can you think of any individuals that might need to do that?

Well, a scientific researcher, someone making a presentation, or a data analyst.

To be more efficient, you can create a template file to use over and over again.

Click Template file and save a copy.

You can rename it if you wish, or it will save as Copy of Template file.

When you add data, a bar chart will appear.

And you can see that happening here.

So adding data to the table is making the bar chart appear.

The context column is where you would type the different options.

For example, if your chart is about colors, then you might have red, blue, yellow, or green.

The frequency column is where you would input the number of each option.

Give it a try for yourself.

Over to you.

Fill in the blanks.

A.

.

.

is a useful tool when creating many bar charts where the style and formatting is to stay the same.

You could pause the video here and click Play to continue.

So how did that go?

A template file is a useful tool when creating many bar charts where the style and formatting is to stay the same.

Well done if you got that correct, let's move on.

Other technology can also be utilized even when it is not specifically spreadsheet software.

You can click Desmos template.

We can update the frequency table and the bar chart in our template.

So you can see that by adding that in, a bar chart has appeared.

Over to you.

On the Desmos template file, which icon duplicates?

Is it A, B, or C?

You can pause the video here and click Play once you've got the answer.

So what did you get?

If you got C, well done.

This icon here duplicates whatever you'd like.

Let's move on.

Task B, one.

Using the template file, recreate this bar chart showing the number of moons per planet in our solar system.

Note, you do not need to add the numbers on the bars.

Two, Task B, question two.

Recreate this bar chart showing the number of time zones per country, including overseas territories.

You could pause the video here and click Play once you've completed this task.

So how did that go?

So, for one, the data should have been added like this.

For two, this is what you should have got.

We're now at the end of this lesson, let's summarize our learning.

So, this lesson was all about constructing bar charts by utilizing technology.

You now understand that many careers have a need to represent data, often multiple times.

Technology is an efficient and useful tool to create bar charts.

Template files can be made and set up to assist with the creation of multiple bar charts that all have the same format and layout.

Thank you so much for joining me in this lesson, bye.