
Year 7 Modelling Data (NCCE): Assessment
Quiz by Stuart Smith
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measures 1 skill from
Track each student's skills and progress in your Mastery dashboards
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
What is data?
The understanding that we gain from raw numbers and figures
Raw numbers and figures
45sKS3.C.7 - Q2
We use a spreadsheet to c _ _ _ _ _ _, log and interpret data.
Users re-arrange answers into correct orderJumble60sKS3.C.7 - Q3
A spreadsheet's purpose is to organise
Users re-arrange answers into correct orderJumble60sKS3.C.7 - Q4
"Spreadsheets are particularly useful for powerful c _ _ _ _ _ _ _ _ _ _ _"
Users enter free textType an Answer60sKS3.C.7 - Q5
Name a spreadsheet program
Microsoft Word
Microsoft Excel
Google SheetsGoogle Docs
Microsoft PowerPoint
30sKS3.C.7 - Q6
A spreadsheet can contain more than one ...
Users re-arrange answers into correct orderJumble60sKS3.C.7 - Q7
The row number and column letter for a cell is called the...
Cell reference
Cell recommendation
Cell direction
Cell citation
30sKS3.C.7 - Q8
We can type data into a cell by...
Double-clicking in the cellSelecting the cell
Using the formula bar
30sKS3.C.7 - Q9
"To organise our data in a spreadsheet, we can use s____ and f______ " Pick one of these words from the list.
Format
Sort
Size
Filter30sKS3.C.7 - Q10
To create a mathematical calculation in a spreadsheet we can use a...
Users re-arrange answers into correct orderJumble60sKS3.C.7 - Q11
Link together the follow calculation formula symbols. PLAN YOUR ANSWER FIRST AS YOU CANNOT CHANGE THE LINK ONCE MADE!
Users link answersLinking60sKS3.C.7 - Q12
Which one of these is the correct way to make a formula?
=D1xD2
=d1*d2
=1D*2D
=D1*D2
30sKS3.C.7 - Q13
By moving your mouse to the right-hand corner of a cell with a formula in (like the picture shows), so that it changes to a cross shape, then dragging to replicate your formulas, is called...
Create cells
Move cells
Fill cells
Highlight cells
30sKS3.C.7 - Q14
Match the named function to its purpose. PLAN YOUR ANSWER FIRST AS YOU CANNOT CHANGE THE LINK ONCE MADE!
Users link answersLinking60sKS3.C.7 - Q15
To change the cell colour or font I would ________ the cell
Users re-arrange answers into correct orderJumble60sKS3.C.7