1 / 21

CEDARS – Comprehensive Education Data and Research System

CEDARS – Comprehensive Education Data and Research System. CEDARS Statewide: February 9, 2012 Webinar Bilingual Validations Common CEDARS Questions HQT Questions relating to CEDARS Logical Deletes – threshold settings. CEDARS Statewide Agenda. Welcome!

anaya
Download Presentation

CEDARS – Comprehensive Education Data and Research System

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. CEDARS – Comprehensive Education Data and Research System CEDARS Statewide: February 9, 2012 Webinar Bilingual Validations Common CEDARS Questions HQT Questions relating to CEDARS Logical Deletes – threshold settings

  2. CEDARS Statewide Agenda • Welcome! • Bilingual Validations – live Feb 15 • October Enrollment report available • Common CEDARS Questions • Staff Type Codes • HQT tool use of CEDARS data • Logical Delete Threshold • Basic concepts • CEDARS data manual as a tool • NEW threshold settings page Feb 9, 2012

  3. Bilingual Validations Live on Feb 15th (submissions sent 2/15) Will error Bilingual Student records Data Quality Reports available since Jan Feb 9, 2012

  4. October Enrollment Report Feb 9, 2012 4

  5. October Enrollment Report Live on OSPI’s k12 website: http://www.k12.wa.us/DataAdmin/default.aspx Feb 9, 2012

  6. Feb 9, 2012

  7. Common CEDARS Questions Feb 9, 2012 7

  8. Common CEDARS Questions • Staff Type Codes • Appendix U in CEDARS • Not the same list of ALL available Duty or Staff Type codes available for S-275 fiscal reporting • Staff type codes that are not valid for CEDARS may be valid for S-275 fiscal reporting • Ex: coaches, office/clerical staff Feb 9, 2012

  9. Common CEDARS Questions • HQT Tool uses CEDARS data • CEDARS to HQT Tool Data Map: http://www.k12.wa.us/CEDARS/default.aspx Feb 9, 2012

  10. HQT Tool Training Opportunities • Hosted by OSPI Title II, Part A office • WEBINAR: March 1, 2012 (1-4PM) Registration link not yet available • Register online for ESD in-person trainings at: http://www.surveygizmo.com/s3/803913/Registration-Technical-Assistance-HQT-Data-Collection-Tool The in-person trainings will be held at the following ESDs: Feb 9, 2012

  11. Logical Delete Threshold Feb 9, 2012 11

  12. Logical Delete Threshold • CEDARS Processing Basics • District sends zipped CEDARS file submission • Contains 13 text files (i.e. Location, SchoolStudent) • Some districts have their SIS vendor send automatically • CEDARS checks files for correct naming and all files • End of above process is considered “Submitted” status • Nightly loading starts at 6:30PM each day • The logical delete threshold evaluation happens during nightly loading Feb 9, 2012

  13. Logical Delete Threshold • What is meant by the term “logical delete?” • Records stored in a database • Use “key fields” to uniquely identify the record • Start date – date we first receive and load the record • End date – date the record is logically deleted and no longer used for any data reporting from CEDARS From CEDARS submission Automatic in databaseDistrict Sends OSPI assigns Key Fields Data Record End Record Start Feb 9, 2012

  14. Logical Delete Threshold • What are the “key fields” for each file? • CEDARS data manual has an indicator for a key field: http://www.k12.wa.us/CEDARS/Manuals.aspx • Chart from Logical Delete FAQ document: http://www.k12.wa.us/CEDARS/TrainingMaterials/LogicalDeleteFAQ.doc Feb 9, 2012

  15. Logical Delete Threshold • A logical delete can occur to a record for 3 reasons: • The record is missing from your current submission. • The record now has a submission exception (error). • A key field used to identify the record has changed in the most recent submission. When key fields change, the old record is logically deleted. Feb 9, 2012

  16. Logical Delete Threshold • Logical deletes can occur: • Without tripping the threshold • Without any submission exceptions (errors) • Due to normal school district business practices • Ex. StudentSchedule records are logcially deleted in high numbers the first week of school Feb 9, 2012

  17. Logical Delete Threshold • Where do I find the threshold settings? • CEDARS -> Submissions tab -> Logical Delete Thresholds • Current default settings are 2% for each file • If the records in the most recent submission would logically delete 2% or more of the existing records, CEDARS does not finish loading the most recent submission. • Changing the percentage for the threshold is now available to CEDARS District Administrators! Feb 9, 2012

  18. Logical Delete Threshold Feb 9, 2012

  19. CEDARS Resources and Materials Jan 27, 2012

  20. CEDARS Website: www.k12.wa.us/CEDARS Feb 9, 2012

  21. Questions & Answers • This webinar recording will be posted to the K12 web site at http://www.k12.wa.us/CEDARS THANK YOU! OSPI Customer Support customersupport@k12.wa.us 1.800.725.4311 Emily Rang Meaghan Thompson Magen Blevins Micah Ellison Feb 9, 2012

More Related