Visualising Table Data

In this lesson, you will learn how to create visual representations of your table data, making it easier to understand and analyze.

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Setting Up the Environment
2 Importing Sample Data
3 Understanding the Data
4 Creating a Bar Chart
5 Customizing the Chart
6 Creating a Pie Chart
7 Analyzing the Charts
8 Saving and Sharing Your Work
Quiz

1 - Setting Up the Environment

Visit Google Sheets and create a new blank spreadsheet. Name it 'Visualising Table Data'.

👇 Mark your steps as done as you complete them.

+5 XP

2 - Importing Sample Data

In your new spreadsheet, click on File > Import. Select 'Upload', then download and upload the sample data file provided by your teacher. Choose 'Replace spreadsheet' and click 'Import data'.

👇 Mark your steps as done as you complete them.

+10 XP

3 - Understanding the Data

Take a moment to study the data in your spreadsheet. You should see a table with columns for Name, Age, Height, and Weight. Each row represents a different person.

+5 XP

4 - Creating a Bar Chart

Click and drag to select the data in your table, including the headers. Then, click on Insert > Chart. A bar chart will appear on your sheet. This chart shows the relationship between the names and their corresponding ages.

+15 XP

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.