WorksheetsMID-TERM EXAMS TERM 3
Total questions: 30
Worksheet time: 15mins
What is the first step when planning a statistical investigation?
Making a graph
Choosing computing tools
Asking a question
Typing a report
Which tool is most suitable for organising data into columns and rows?
Drawing software
Calculator
Spreadsheet
Database
When would you use a database in a statistical investigation?
To paint a picture
To store and sort large sets of data
To solve maths equations
To record sounds
What tool helps you write about your data findings in full sentences?
Spreadsheet
Document editor (e.g., Word)
Database
Coding platform
If you're comparing how different groups answered a survey, which tool helps display that clearly?
Drawing app
Data logger
Spreadsheet chart
Text file
Why is it helpful to use computing tools in statistical investigations?
They make it harder
They allow us to avoid collecting data
They speed up analysis and improve accuracy
They write the questions for us
What does a data logger do in investigations?
Creates graphs
Records continuous data automatically
Sends emails
Writes summaries
You need to sort and search through responses from 100 students. What’s best?
Word Processor
Spreadsheet
Database
What is continuous data?
Data with exact numbers like 1, 2, 3
Data that includes whole numbers only
Data that can have any value within a range
Data based on names or groups
Which of these is continuous data?
Number of pets
Age in years and months
Favourite food
Number of siblings
What would be a suitable question to collect continuous data?
What colour is your hair?
How tall are you in centimetres?
Do you like pizza?
What is your favourite sport?
Why should a form use clear units when collecting continuous data?
To make the form longer
To make it harder to answer
To ensure accurate data collection
To confuse the user
What is the best way to record continuous data in a form?
Yes/No checkboxes
Open-ended numerical fields
Picture boxes
Dropdowns with set categories
Which form field is best for recording time in seconds?
Multiple-choice list
Short text input
Numeric input with label “seconds”
Colour selector
When designing a data form, what does “purpose-driven” mean?
It has fun questions
It’s based on what the teacher wants
Every question helps meet the goal of the investigation
It only asks personal questions
You are collecting rainfall amounts over a week. What type of data is that?
Discrete
Categorical
Continuous
Binary
What is a spreadsheet cell?
A type of battery
A small square where you enter data
A part of a calculator
A menu option
What is cell referencing?
Naming a spreadsheet
Referring to a cell using its location (e.g., A1, B2)
Changing colours
Counting how many cells are filled
In a spreadsheet, what does the formula =A1 + A2 do?
Adds the contents of A1 and A2
Deletes cells
Highlights cells
Multiplies cells
What function would you use to find the average of numbers in B1 to B5?
=TOTAL(B1:B5)
=AVERAGE(B1:B5)
=SUM(B1:B5)
=MIDDLE(B1:B5)
What does the function =SUM(C1:C4) do?
Calculates the average of the numbers
Finds the largest number
Adds the values in cells C1, C2, C3, and C4
Deletes the values
Why use formulas in a spreadsheet instead of typing the answers?
It looks more complicated
It’s easier to make mistakes
It allows updates when data changes
It slows down the process
What symbol must a formula in Excel always start with?
$
#
=
&
Which of these shows correct use of a function in Excel?
SUM = (A1:A4)
=SUM(A1:A4)
Add A1 to A4
=TOTAL[A1-A4]
Why use AVERAGE in a spreadsheet?
To show the lowest number
To add values
To find the middle value
To calculate the mean of several numbers
Which tool in a spreadsheet helps to make it easier to read large amounts of data?
Highlighting everything
Using filters and formatting
Typing in bold
Using all capital letters
What’s the advantage of using cell references in formulas?
You can decorate the cells
Formulas update automatically when values change
You don’t need headings
It makes it harder to edit
Which of the following is NOT a correct spreadsheet operation?
=A1 * B1
=A1 + C2
=SUM(A1:A5)
=LABEL(A1:A5)
What is the role of arithmetic operators in spreadsheets?
To decorate cells
To move data
To perform calculations
To delete rows
A spreadsheet with cell referencing and functions is useful because:
It adds style
It makes random data
It helps with accurate and quick calculations
It reduces screen brightness
