Lesson details

Key learning points

  1. In this lesson, we will acquire the skills to create charts in Google Sheets. We will evaluate results based on questions asked using the chart that we have created. Finally, we will appreciate there are different software tools available within spreadsheet applications to present data.

Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

Loading...

3 Questions

Q1.
Why are data headings important? (Tick 2 boxes)
They allow us to experiment with formatting.
Correct answer: They enable us to keep the data organised.
Correct answer: They help for effective use of formula.
They look attractive on a spreadsheet.
Q2.
Why should data be organised? (Tick 2 boxes)
Correct answer: It is easier to perform calculations using the data.
Correct answer: It makes easier to read and understand data.
It stifles creativity.
Makes the spreadsheet attractive.
Q3.
What calculation in your formula will you use to find C2-Total budget?
A2-B2
Correct answer: A2*B2
A2/B2
A2+B2

4 Questions

Q1.
Presenting data using tables are helpful when you want to: (Tick 2 correct choices)
Compare the data
Correct answer: Make changes to the data (adding / taking away items, etc.)
See the data visually
Correct answer: Use the data to perform different calculations
Q2.
Presenting data using graphs and charts are helpful when you want to: (Tick 2 correct choices)
Correct answer: Compare the data
Make changes to the data (adding / taking away items, etc.)
Correct answer: See the data visually
View the individual figures
Q3.
Which is the best way to present data? Tables OR graphs and charts?
Graphs and charts
Tables
Correct answer: There are advantages and disadvantages to both ways of presenting data.You need to choose which is the most appropriate.
Q4.
Look at the pie-chart to answer this question. Which spending type did you spend the most money on?
Activity total cost
Drinks total cost
Food total cost
Correct answer: Venue total cost

Lesson appears in

UnitComputing / Spreadsheets

Computing