Data validation - whole number

British English CC

Data validation in a spreadsheet model

Computing

Spreadsheet modelling

Formulas in a spreadsheet model

Formatting in a spreadsheet model

Lookup and reference functions

Visualising data using charts in a spreadsheet

Improving a spreadsheet model

Spreadsheet project I

Spreadsheet project II

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions.

Spreadsheets

What is the term for the data or information entered into a system or program?

the rules that decide what data is allowed in a cell

a notification shown when data doesn’t meet the criteria

allowing only numbers between 1 and 100 in a cell

automatically calculating totals in a column

Which of these is an example of data validation?

by ensuring only valid data is entered into cells

How can data validation improve data accuracy?

Data validation can check values entered into a cell.

Data validation can stop users from leaving required cells blank.

Data validation can automatically fix incorrect data.

Data validation can ensure data accuracy and consistency.

Which of these statements about data validation is false?

Data validation displays an error message.

Arrange these steps in order for correcting an error using data validation:

to improve clarity, usability and presentation of data

What is the purpose of formatting in a spreadsheet?

combines two or more cells into one larger cell

splits a cell into multiple smaller cells

What does the merge function do in a spreadsheet?

combines text from multiple cells into one

automatically breaks long text onto multiple lines within a cell

What does the wrap function do in a spreadsheet?

to highlight key data points based on set conditions

Which of these is an example of formatting?

Choose the conditional formatting option.

Put these steps in order for applying conditional formatting:

This lesson was made for home learning during the pandemic.

Data validation in a spreadsheet model

Lesson outcome

This lesson was made for home learning during the pandemic.