Secondary 4
PROBLEM SETS, REVISION SETS
OTHER SCHOOL PAPERS, PRELIM PAPERS, GCE PAPERS
Embedded Files
Visit and subscribe theCPAtube. Complete all HBL assignments on SLS & GC.
PS 10 MS-Excel. Data Validation
PS 10 MS-Excel. Data Validation
LEARNING OUTCOMES
LEARNING OUTCOMES
- Data Validation settings in MS-Excel
- 3 Data Validation checks
- Setting Error Messages
STUDY SLIDES
Slides 10-1 Data Validation
Slides 10-2 Data Validation CCA Form
...
Test Yourself
Refer to Textbook for further details.
- 132 Learning Outcomes, Overview
- 133 Data Validation
- 134 Types of data validation
- 136 Error messages
- 138 Data entry
- 139 String function (Date)
- 139 String function (Text)
...
- 143 Worksheet 10.1 Types of CCA
- 148 Worksheet 10.2 Choosing CCA
- 153 Worksheet 10.3 This is my CCA
Types of Data Validation (Important!)
Types of Data Validation (Important!)
pg 134-135
pg 134-135
There are 3 types of Data Validation:
(a) length check;
(b) range check; and
(c) type check.
Error Messages pg136
Error Messages pg136
2 Types of Error Messages
Messages may be displayed to give instructions or feedback to the users.
An error message can be displayed if an invalid data is entered.
There are 2 types of error messages:
- System defined
- User defined
PS 10 Details
PS 10 Details
What is Data Validation? pg 133
What is Data Validation? pg 133
- Data validation is a process used to control the type of data that is entered in the spreadsheet.
- Data needs to be validated (checked) before being processed so that data entered is according to requirements.
- By configuring (setting) data validation field, you can prevent users from entering data that is not valid (prevent wrong data entry).
How?
How?
In the spreadsheet software (MS-Excel), data validation can be configured by
(a) providing a list of choices (drop-down list); or
(b) defining the types of input data (setting criteria).
Creating A Data Validation Check
Creating A Data Validation Check
To create a data validation check for a single cell or a range of cells, we simply have to
- Select the cell range
- Go to Data/Data Validation
- A Data Validation window will pop-up
- Enter your requirements in Settings, Input Message & Error Alert.
3 Data Validation Types | Length, Range, Type
3 Data Validation Types | Length, Range, Type
1. Length Check
1. Length Check
Length check determines the length of the data and make sure that it is not too short or too long.
example: You require a password of 5 characters only
2. Range Check
2. Range Check
A range check determines whether the data entered falls within a specified range.
example: the user needs to enter a text between 5 and 8 characters.
3. Type Check
3. Type Check
A type check determines the type of data that can be entered, like date, whole number or decimal number in the cell.
example: user is required to enter to enter a date for birthday.
Data Validation
Data Validation
Error Messages p136
Error Messages p136
Messages may be displayed to give instructions or feedback to the users.
An error message can be displayed if an invalid data is entered.
///
Types of Error Messages
- System Defined
- User Defined
See images below.
- Left (System Defined
- Right (User Defined)
PS 10.2 CCA Form | Page 148
PS 10.2 CCA Form | Page 148
In this assignment, you will set the data validation for a CCA Form.
PS 10.3 My CCA Form | Page 153
PS 10.3 My CCA Form | Page 153
In this assignment, you will create your own CCA Form and set the data validation.
// You may need to include the "Input Messages" & "Error Alert" to assist the user of your form.
Google Sites
Report abuse