1 / 21

Data Validation

Data Validation. Dori Baldwin Computer Logic Group. Agenda. PowerSchool Data Introduction to Data Validation Create Input Mask Set validation Rules PowerSchool Fields Custom Fields See the Rules in Action. About the Trainer…. Dori. Member of CLG Retired from education 1 5 years

xenon
Download Presentation

Data Validation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related