Download
data validation n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data Validation PowerPoint Presentation
Download Presentation
Data Validation

Data Validation

186 Vues Download Presentation
Télécharger la présentation

Data Validation

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data Validation Dori Baldwin Computer Logic Group

  2. Agenda • PowerSchool Data • Introduction to Data Validation • Create Input Mask • Set validation Rules • PowerSchool Fields • Custom Fields • See the Rules in Action

  3. About the Trainer… Dori • Member of CLG • Retired from education • 15 years • PowerSchool consultant/implementation • PowerSchool administrator • Teacher • Hobbies/Interests • Dogs • Travel • Lighthouses

  4. Your turn…. • Has anybody attempted data validation? • Scale from 1 to 10 • Comfort level with DDE • Comfort level with importing and exporting

  5. Training Material Psugmi.com

  6. Let’s talk data… • Data Dictionary • Definition of the fields within a table • Provides the field type • List the links to other tables

  7. The Data Dictionary

  8. Custom Fields • Some tables can contain custom fields • Students, staff, courses and sections • All state fields are custom fields • 999 field limit

  9. Problems with data • Consistent entry • Phone Numbers • 232-222-3232 or • 232.222.3232 or • 222-3232 or • (232) 222.3232 • 232-222-3232 call mom first

  10. Problems with data • Consistent entry • Relationship • Grandpa • Granddad • Grandfather • Grandpapa

  11. Data Validation • New Feature of PowerSchool • Only for Students and Teachers Tables • Rule types: • Text • Date • Numbers

  12. 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

  13. Data Validation - Number • Rules • Integer • Min Length • Max Length • Min value • Max value • Number Type • Required

  14. Data Validation - Date • Rules • Date Type • Min Date • Max Date • Required

  15. Let’s see it in Action

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

  17. Entering Data in Demographics • If field has a rule it will not let you save until the rule is satisfied • Red text shows what is expected

  18. Importing Data • Fields with rules are verified • If rule is not followed record is not imported

  19. Validating Other Fields • PowerDataSolutions • Fild Validator • http://powerdatasolutions.org/content/field-validator

  20. Recap • Data Validation allows the creation of rules to ensure consistent data entry • Only available on Student and Teacher tables • Available for PowerSchool and custom fields • Validates data being imported • Validates changes in DDA • Validates Autocomm data