Spreadsheet Lesson 2

Spreadsheets

By Shahbaz Farooq

​In this lesson you will:

●Explain the difference between data and information

●Explain the difference between primary and secondary sources of data

●Collect data

Multiple Choice

A row is a vertical reference in a spreadsheet.

• True
• False

Multiple Choice

A mathematical operation is called a _____.

• formula
• range
• label
• graph

Multiple Choice

A group of cells is called a _____.

• graph
• selecting
• range
• cell

Multiple Choice

The intersection of a row and column in a spreadsheet is called a __________.

• Cell
• Formula
• Label
• Value

Multiple Choice

All spreadsheet formulas begin with which symbol?

• =
• ^
• $
• #

Multiple Choice

Which of the following is an example of a cell reference or cell address?

• C
• 9
• B4
• =A1+A2

Multiple Choice

The cell that is currently selected

• Cell reference
• Cell range
• Label
• Active cell

Multiple Choice

a file which contains one or more spreadsheets.

• Workbook
• Spreadsheet
• Cells
• Entry

Multiple Choice

These are unorganized facts that, which include words, numbers, images, and sounds.

• Process

• information

• Data

Multiple Select

Select examples of sources of information.

• mirror

• books

• Radio

• keys

• newspaper

Multiple Choice

There are facts that are Organised, meaningful and useful or we can say it's the output we get from a computer.

• Data

• Input

• Information

• Process

Multiple Choice

Which of the following is correct?

• Data leads to information, and information leads to knowledge.

• Knowledge leads to information, and information leads to data

• Data leads to knowledge and knowledge leads to information

Multiple Choice

Which of these is not data?

• Words
• Numbers
• Shoes
• Dates

Multiple Choice

Which answer is not true . Information is

• Processed
• Structured
• Organised
• Random

Multiple Choice

Which answer is false. A supermarket needs information to....

• Know what products to sell
• Have something to read
• Know when to sell certain products
• Find out what sells best in different parts of the country

Multiple Choice

Information is gained from data

• True
• It depends
• False
• Sometimes

Multiple Choice

A source created about an event or time-period by someone who was there

• Primary

• Secondary

Multiple Choice

Something made about an event or time period by someone who was not there

• Primary

• Secondary

Multiple Choice

An article about the Civil War written during the Civil War

• Primary

• Secondary

Multiple Choice

A report about the life of Abraham Lincoln written by a 5th grade student

• Primary

• Secondary

Multiple Choice

A newspaper article created about 9/11 at the same time of 9/11

• Primary

• Secondary

Multiple Choice

An audio recording of an immigrant talking about their experience of Ellis Island.

What is the audio recording in this sentence?

• Primary

• Secondary

Multiple Choice

In the audio recording of an immigrant talking about their experience of Ellis Island.

What is the purpose of the audio?

• To learn about immigrants

• To learn personal stories and experiences from Ellis Island

• To learn about Ellis Island

Multiple Choice

Which answer below is a Secondary Source?

• Autobiography

• Photograph

• Diary

• Textbook

Multiple Choice

I go to a play about Christopher Columbus discovering America. What is the play?

• Primary

• Secondary

Multiple Select

I understand primary and secondary sources.

There is no wrong answer to this! Tell me the truth so that I can know how to help you do best on your quiz tomorrow! :)

• Yes

• Not really...

• I could use more practice!

Activity 1a: Design and make a survey

Create a short survey using MS Forms and then generate a single data set from the survey responses of the whole class.

​

This data set will be used in the next lessons to demonstrate data analysis techniques in spreadsheets.

​

As a group, brainstorm ideas of questions for the survey that the learners will fill in. The questions could be related to the party planned during the previous lesson, personal interests, hobbies, free time, etc.

Part 2: Carry out the survey & generate data

​

Share a link to the survey throught teams chat and have learners fill out the survey individually to collect the data.

​

Afterwards, generate a spreadsheet from the responses. You can either do this in class as part of the activity, or at a later time prior to the next lesson.