Y7

Revision tools

You can print this page for a quick reference guide or you can use the tools below to create printable test sheets

4a: Identify columns, rows, cells, and cell references in spreadsheet software

Keyword	Definition
cell reference	tells you the location of a cell within a spreadsheet
cells	spaces in a spreadsheet that hold data
column	vertical collection of cells
range	collection of more than one cell in a spreadsheet
row	horizontal collection of cells
spreadsheet	rows and columns of data that you can edit and process

4b: Use formatting techniques in a spreadsheet

Keyword	Definition
background	the colour and style used to fill in a cell in a spreadsheet
borders	the colour and style of the lines around cells in a spreadsheet
conditional formatting	changing the appearance of a spreadsheet based on the data in each cell
foreground	the colour and style used to display data in a cell in a spreadsheet
formatting	the appearance and style of a spreadsheet

4c: Use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /)

Keyword	Definition
-	operator that you can use in a formula to do subtraction
*	operator that you can use in a formula to do multiplication
/	operator that you can use in a formula to do division
+	operator that you can use in a formula to do addition
cell	a space that can hold data in a spreadsheet
cell reference	the location of a cell in a spreadsheet involving the column letter and the row number
formula	an expression starting with = that can be used to calculate the value in a cell
spreadsheet	a collection of cells organised into rows and columns so you can edit and process data

4d: Use the autofill tool to replicate cell data

Keyword	Definition
autofill	intelligently copying the values or formulae from one cell into other cells
data	numbers, text or other information in a cell
formula	an expression used to calculate out the value in a cell
formulae	more than one formula
replicate	make a copy
value	a number that's been entered into a cell

4e: Explain the difference between data and information

Keyword	Definition
data	text or numbers that haven't been organised or put into context to give them meaning
information	text or numbers that have been organised or put into context to give them meaning

4f: Explain the difference between primary and secondary sources of data

Keyword	Definition
data	facts and figures that have not been organised or processed
Information	Facts and figures that have been organised so that they have meaning
news article	example of a secondary source that you can use to find data
Primary source data	Data that you have collected and that you are using yourself
Secondary source data	Data that somebody else collected and that you are using
user survey	example of a primary source that you can use to collect data

4g: Collect data

Keyword	Definition
bias	where a survey question unfairly leads people to a particular response
branching	where people see different questions in a survey depending on their previous answers
closed question	a survey question where people have limited options to choose from for their answer
likert scale	where people choose answers to multiple statements from options between two extreme responses
open question	a survey question where people can write whatever they like for their answer
poll	a survey where people's answers to questions can be collected and analysed

4h: Create appropriate charts in a spreadsheet

Keyword	Definition
bar chart	a type of chart that is ideal for comparing values for different categories of data
chart title	a description of what the whole chart shows
legend	a description of what the different colours or sections of a chart show
line chart	a type of chart that is ideal for plotting how a value changes over time
pie chart	a type of chart that is ideal for comparing proportions of data
scatter chart	a type of chart that is deal for plotting the relationship between two values
x axis label	a description of what the horizontal axis of a chart shows
y axis label	a description of what the vertical axis of a chart shows

4i: Use the functions SUM, COUNTA, MAX, MIN, and AVERAGE in a spreadsheet

Keyword	Definition
AVERAGE	spreadsheet function which works out the mean value from a range of cells
cell reference	the location of an individual cell in a spreadsheet
COUNTA	spreadsheet function which counts how many cells in a range are not empty
function	a useful piece of code within a formula that can calculate and return a value
MAX	spreadsheet function which works out the largest value from a range of cells
MIN	spreadsheet function which works out the smallest value from a range of cells
parameter	an input to a function such as a value, range or cell reference
range	multiple values from more than one spreadsheet cell
SUM	spreadsheet function which adds up each value in a range and returns the total
value	an individual number or data item in a spreadsheet cell

4j: Analyse data

Keyword	Definition
comparison	analysing the difference between two or more items of data
conclusion	a summary of what you have found that data shows after you've analysed it
outlier	an item of data which doesn't fit the general trend or pattern of the rest of the data
prediction	an estimate of what you think data will show before you analyse it
trend	a general pattern or relationship which most of the data follows

4k: Use a spreadsheet to sort and filter data

Keyword	Definition
ascending	ordered from smallest to largest
descending	ordered from largest to smallest
filter	showing or hiding data based on their values
includes	type of filter that shows all data that contains a value
matches	type of filter that shows all data which is the same as a value
sort	arranging data into order based on their values

4l: Use the functions COUNTIF and IF in a spreadsheet

Keyword	Definition
boolean expression	a question based on the value of a cell which can only be answered by either True or False
COUNTIF	spreadsheet function which counts how many values in a range match a certain criteria
criteria	a condition that data has to match in order to be counted or included
IF	spreadsheet function which displays one of two values depending on the value of a cell
range	more than one cell in a spreadsheet

4m: Use conditional formatting in a spreadsheet

Keyword	Definition
border	the style of the outline of a cell
cell	a space for data in a spreadsheet
conditional formatting	changing the colours and style of cells based on the values in each cell
fill	the background color of a cell
font	the style of text in a cell