Introduction to Spreadsheets: Understanding Data Organisation

Explore the basics of spreadsheets with Lesson 1, delving into what a spreadsheet is, its relevance in data organisation, and practical exercises to enhance data literacy skills. Engage in activities to analyze data, ask insightful questions, and develop a fundamental understanding of using spreadsheets effectively.

• Spreadsheets
• Data Literacy
• Data Organisation
• Year 6
• Introduction

harkless_a Follow

Uploaded on Sep 27, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. Save a copy Lesson 1: What is a spreadsheet? Year 6 Data and information Introduction to spreadsheets

2. Objectives Lesson 1: What is a spreadsheet? To identify questions which can be answered using data I can explain the relevance of data headings I can answer questions from an existing data set I can ask simple relevant questions which can be answered using data 2

3. Introduction What is a spreadsheet? A spreadsheet is a computer application that allows users to organise, analyse, and store data in a table. Think, write, pair, share: What do you know about spreadsheets? 3

4. Introduction What does this data show? A B 1 Reina 10 2 David 13 3 Yiannis 1 4 Bob 5 5 Amin 9 6 Petra 18 Data in spreadsheets is stored in a table. What might this data be showing? 4

5. Introduction Data headings A B 1 Name Number of days off 2 Reina 10 3 David 13 4 Yiannis 1 5 Bob 5 6 Amin 9 7 Petra 18 Data headings allow us to organise the data in a meaningful way. 5

6. Activity 1 What s the answer? Can you answer the questions using the spreadsheet? 6

7. Activity 1 Spreadsheet questions A B C D Fruit Cost Number sold Subtotal 1 Apples 0.40 4 1.60 2 Bananas 0.50 9 4.50 3 Kiwi 0.80 3 2.40 4 Grapefruit 1.00 1 1.00 5 Total income: 9.50 6 7

8. Activity 2 What do you think this spreadsheet is showing? 8

9. Activity 2 Can you ask simple, relevant questions about the data? 9

10. Activity 2 Spreadsheet questions Can you ask and answer questions about a spreadsheet? 10

11. Plenary Spreadsheet quiz Ask your questions to the class! 11

12. Assessment How confident are you? (1 3) I can explain the relevance of data headings 3 - Very confident I can ask simple relevant questions which can be answered using data 2 - Unsure I can answer questions from an existing data set 1 - Not confident 12

13. Summary Next lesson In this lesson, you Next lesson, you will Identified questions which can be answered using data Explain that objects can be described using data 13