PSUG REGIONAL ACADEMY Users Helping Users Data Validation

PSUG REGIONAL ACADEMY Users Helping Users

Data Validation DORI BALDWIN-WHITE PSUG EVENTS - CONSULTING

Agenda • • Data types Data validation setup How it works Running the data validation report

About the trainer. . . • Education - 1998 -2012 – Started using PS in 2001 – Classroom teacher – PS Administrator – PS Consultant/Implementation • CLG - 2013 -2017 – Trainer and Support Specialist • Independent Consulting

Your turn. . . • Has anyone setup data validation? • Who wants to control how data is entered?

Data Validation

What is a Data Validation • Feature of Power. School • Only for Students and Teachers Tables • Rule types: – Text – Date – Numbers

Data Validation - Text • Rules – – – Exclude Text Min Length Max Length Required Add a text mask • 2 Step Process – Create the Text Mask – Use the Mask in the Data Validation Rule

Data Validation - Numbers • Rules – – – – Integer Min Length Max Length Min value Max value Number Type Required Grade_level

Data Validation - Date • Rules – – Date Type Min Date Max Date Required Exit. Date

Validating Custom Fields • Use the add button • Select field • Set customization Car_permit_date

Data Validation - Report • Tests current values against new rules – Select students > Group Functions > Data Validation Report – Select the Fields to check – Run Report

Validating Other Fields • Power. Data. Solutions – Field Validator – http: //powerdatasolutions. org/content/field-validator

Course Survey