Data Handling for Year 2 Computing: Learn to Collect and Organize Data

Question 1

Which type of chart is best for showing how data changes over time?

Accepted Answer

Line graph

Answer

Pie chart

Answer

Bar chart

Answer

Venn diagram

Question 2

What type of data field would be best for storing a student's name?

Accepted Answer

Text

Answer

Number

Answer

Date

Answer

Currency

Question 3

What is the purpose of a primary key in a database?

Accepted Answer

To uniquely identify each record

Answer

To store the most important information

Answer

To sort the data alphabetically

Answer

To calculate totals

Question 4

Which operation in a database allows you to add new data?

Accepted Answer

Insert

Answer

Update

Answer

Delete

Answer

Find

Question 5

What is the difference between a field and a record in a database?

Accepted Answer

A field is a single piece of data and a record is a group of related data

Answer

A field is a row and a record is a column

Answer

A field is a column and a record is a row

Answer

A field is a database and a record is a table

Question 6

Which of these is a common file extension for spreadsheets?

Accepted Answer

.xls

Answer

.txt

Answer

.png

Answer

.mp4

Question 7

Can you organize data by getting rid of it?

Accepted Answer

No

Answer

Yes

Question 8

When you have numbers to organize, what is the best choice?

Accepted Answer

Spreadsheet

Answer

Textual document

Answer

Picture

Answer

Video

Question 9

In a database, what do we call groups of related information?

Accepted Answer

Tables

Answer

Rows

Answer

Columns

Answer

Fields

Question 10

Why do we sort data?

Accepted Answer

To arrange it in a logical way

Answer

To get rid of the same information

Answer

To calculate averages

Answer

To make charts

Question 11

What does a database management system (DBMS) do?

Accepted Answer

Creates and manages databases

Answer

Writes information into databases

Answer

Pulls information out of databases

Answer

Arranges information in spreadsheets

Question 12

Which of these tools can you use to organize data into rows and columns?

Accepted Answer

Spreadsheet

Answer

Database

Answer

Word processor

Answer

Presentation software

Question 13

What is the term for entering data into a spreadsheet?

Accepted Answer

Inputting

Answer

Copying

Answer

Pasting

Answer

Importing

Question 14

True or False: Databases can store different types of information, like text, numbers, and pictures.

Accepted Answer

True

Answer

False

Question 15

Which type of chart can show changes over time?

Accepted Answer

Line graph

Answer

Pie chart

Answer

Bar chart

Answer

Scatterplot

Question 16

What is the formula for finding the average of a group of cells in a spreadsheet?

Accepted Answer

=AVG(range)

Answer

=SUM(range)

Answer

=COUNT(range)

Answer

=MIN(range)

Question 17

What is the name of each horizontal row in a spreadsheet?

Accepted Answer

Row

Answer

Cell

Answer

Line

Question 18

If we want to add the values in cells A1 and B1 of a spreadsheet, which formula should we use?

Accepted Answer

=SUM(A1, B1)

Answer

=ADD(A1, B1)

Answer

=PLUS(A1, B1)

Question 19

Which type of chart displays data as a series of lines?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Scatter plot

Question 20

What is the name of the vertical axis in a chart?

Accepted Answer

Y-axis

Answer

X-axis

Answer

Z-axis

Question 21

Which of these is NOT a reliable way to gather information?

Accepted Answer

Making an assumption

Answer

Observing and recording events

Answer

Interviewing individuals

Answer

Distributing a survey

Question 22

Which of these is the best way to collect data about people's favorite colors?

Accepted Answer

Asking them to fill in a survey

Answer

Reading a book about colors

Answer

Watching a TV show about colors

Answer

Playing a video game about colors

Question 23

Which of these is a type of graph that shows data as bars?

Accepted Answer

Bar chart

Answer

Word cloud

Answer

Scatter plot

Answer

Timeline

Question 24

Which of these is NOT a spreadsheet program?

Accepted Answer

Microsoft Word

Answer

Microsoft Excel

Answer

Google Sheets

Answer

Apple Numbers

Question 25

What is a cell in a spreadsheet?

Accepted Answer

A box that holds data

Answer

A row in the spreadsheet

Answer

A column in the spreadsheet

Answer

A formula that calculates data

Question 26

What is a database?

Accepted Answer

A collection of related data

Answer

A spreadsheet program

Answer

A type of graph

Answer

A computer program

Question 27

What is a query?

Accepted Answer

A question you ask a database

Answer

A type of database

Answer

A program that manages data

Answer

A way to create a report

Question 28

Which tool is used to collect data by counting items one by one?

Accepted Answer

Tally chart

Answer

Ruler

Answer

Microphone

Answer

Scale

Question 29

Which of these is NOT a way to organize data?

Accepted Answer

Drawing a picture

Answer

Using a spreadsheet

Answer

Using a database

Answer

Sorting by size

Question 30

What is the main purpose of a data visualization?

Accepted Answer

Making data easier to understand

Answer

Storing data securely

Answer

Collecting data efficiently

Answer

Analyzing data statistically

Question 31

The first step in collecting data is to ______.

Accepted Answer

Identify the question you want to answer.

Answer

Gather the data.

Answer

Organize the data.

Answer

Analyze the data.

Question 32

We use a spreadsheet to organize data because it helps us to ______.

Accepted Answer

Both A and B.

Answer

Store and manage lots of data.

Answer

Perform calculations on the data.

Question 33

Which of these is a type of spreadsheet?

Accepted Answer

Both A and B.

Answer

Google Sheets

Answer

Numbers

Question 34

A pie chart is used to show ______.

Accepted Answer

How different parts of a whole compare to each other

Answer

How data changes over time

Answer

The relationship between two or more variables

Answer

The distribution of data

Question 35

What is the first step in collecting data?

Accepted Answer

Asking questions

Answer

Writing down data

Answer

Organizing data

Answer

Analyzing data

Question 36

What is the purpose of a bar chart?

Accepted Answer

To compare different types of things

Answer

To show changes over time

Answer

To predict future events

Answer

To show relationships between variables

Question 37

Which of the following is NOT a type of data?

Accepted Answer

Emotions

Answer

Numbers

Answer

Words

Answer

Pictures

Question 38

What is the difference between qualitative and quantitative data?

Accepted Answer

Quantitative data is in numbers, while qualitative data is not.

Answer

Qualitative data is in numbers, while quantitative data is not.

Answer

Qualitative data is collected through interviews, while quantitative data is collected through surveys.

Answer

There is no difference between qualitative and quantitative data.

Question 39

Which tool can be used to store data in rows and columns?

Accepted Answer

Spreadsheet

Answer

Word processor

Answer

Presentation software

Answer

Database

Question 40

Why is it important for data to be accurate?

Accepted Answer

To ensure that the data is reliable and trustworthy.

Answer

To make the data look more organized.

Answer

To get a good grade.

Answer

To impress the teacher.

Question 41

Which of these is not a way to gather information?

Accepted Answer

Guessing

Answer

Surveys

Answer

Interviews

Answer

Experiments

Question 42

Which of these graphs shows changes over time?

Accepted Answer

Line graph

Answer

Bar graph

Answer

Pie chart

Answer

Scatter plot

Question 43

What is the difference between information that can be counted and information that cannot be counted?

Accepted Answer

Information that can be counted is called quantitative data, while information that cannot be counted is called qualitative data.

Answer

Information that can be counted is called qualitative data, while information that cannot be counted is called quantitative data.

Answer

Qualitative data is gathered from surveys, while quantitative data is gathered from experiments.

Answer

There is no difference between qualitative and quantitative data.

Question 44

What is the first step in the data handling process?

Accepted Answer

Collecting data

Answer

Organizing data

Answer

Analyzing data

Answer

Presenting data

Question 45

What is the difference between a table and a graph?

Accepted Answer

Tables show data in rows and columns, while graphs show data visually.

Answer

Graphs show data in rows and columns, while tables show data visually.

Answer

Tables are used for qualitative data, while graphs are used for quantitative data.

Answer

There is no difference between a table and a graph.

Question 46

Why do we organize data?

Accepted Answer

To make it easier to understand.

Answer

To make it look pretty.

Answer

To make it harder to use.

Answer

To hide it from others.

Question 47

What's a good way to organize information in a spreadsheet?

Accepted Answer

Sort it by a specific column.

Answer

Leave empty spaces between numbers.

Answer

Put the information in random order.

Answer

Repeat all the information in different columns.

Question 48

What is a database?

Accepted Answer

A place to store lots of connected information.

Answer

A website to keep your files safe.

Answer

A website for finding things on the internet.

Answer

A spreadsheet with many pages.

Question 49

What's an advantage of using a spreadsheet to organize data?

Accepted Answer

It's easy to sort and filter information.

Answer

You can't lose any information.

Answer

It always updates itself.

Answer

It's impossible to make mistakes.

Question 50

What's the difference between descriptive and number data?

Accepted Answer

Descriptive data tells us words, while number data uses numbers.

Answer

Descriptive data is easy to collect, number data is harder.

Answer

Descriptive data is more trustworthy, number data is less reliable.

Question 51

Which of these is an example of descriptive data?

Accepted Answer

What students think about a lesson.

Answer

How many students are in a class.

Answer

How long it takes to finish a task.

Answer

The average score on a test.

Question 52

What does a pie chart show us?

Accepted Answer

How much of something is in different parts.

Answer

How different things compare.

Answer

How something changes over time.