Spring 2007 Error Correction Training 200704

50 %
50 %
Information about Spring 2007 Error Correction Training 200704
Entertainment

Published on October 2, 2007

Author: AscotEdu

Source: authorstream.com

CSIS Spring 2007 Error Correction Training:  CSIS Spring 2007 Error Correction Training April 2007 Agenda:  Agenda Types of Errors and Warnings How to Use the Error Charts Input Validation Error Chart Post Aggregation Error Chart Review Errors and Reports Notable Error Conditions Known Issues Suggested Strategies on Fixing Errors Etc. Questions Types of Errors and Warnings:  Types of Errors and Warnings Input Validation Errors May change according to submission Import validation “errors” are due to: Invalid reason, year, File type/Record type/Record subtype Unnecessary data elements/records for transaction User translation filter SRRTS validation filter Error results in record or data element to be filtered Types of Errors and Warnings:  Types of Errors and Warnings Input Validation Errors (continued) Client Validation errors due to: invalid format, character, look-up value or conditional value Server Validation errors due to: invalid values based on conditional data relationships Client and Server input validation errors will result in: E = Error – record is filtered out W = Warning – record is retained F = Fatal error - requires correction in order to proceed Types of Errors and Warnings:  Types of Errors and Warnings Post Aggregation Errors (Server-Side) Change according to submission Produced as a result of inconsistencies/errors detected during Aggregation or Trend step of server processing It is CDE’s intention to ensure acceptable data quality from LEAs All Post Aggregate errors must be fixed before Certification is allowed Will cause the transaction to FAIL. Types of Errors and Warnings:  Types of Errors and Warnings Referential Integrity (RI) errors are detected during server processing and occur when a parent record is missing (eg. ENRA but no DEMO). Record Count Validation Errors are detected during server processing and occur when a child record is missing (eg. DEMO but no ENRA). Missing/Un-Expected Schools detected during server processing, based on CDE’s active schools list. Often results due to missing INST record. Will cause the transaction to FAIL. NOTE: Advise CDE and CSIS of any schools that have opened or closed since Fall Submission Error and Warning Summary:  Error and Warning Summary Client Side Import Validation Errors (Import Error Report) Client Validation Errors (Client Validation Error Report) Server Side Server input validation Errors (All Files Reports) Post Aggregate Errors (All Files Reports) Referential Integrity Errors (All Files Reports) Record Count Validation Errors (All Files Reports) Missing/Un-Expected School Errors (All Files Reports) Accessing SRRTS Reports:  Accessing SRRTS Reports Switch to TestGate for Live Demo… Review Error Resolution Tools:  Review Error Resolution Tools Input Validation Error Chart Sorted by Element Name Provides info about possible causes and resolution tips for E, W and F type messages Post Aggregation Error Chart Sorted by report type Provides info about possible causes and resolution tips for E and W type messages Data Element Mapping Guides Guide by report type Maps aggregation logic to LEA Web reports Reports Analysis User Guide Provide detail description of both client and server-side reports and error correction tips Switch to Error Reports and Error Charts Error Chart Summary:  Error Chart Summary Client Side Import Validation Errors (Input Validation Error Chart) Client Validation Errors (Input Validation Error Chart) Server Side Server Input Validation Errors (Input Validation Error Chart) Post Aggregate Errors (Post Aggregate Error Chart) Referential Integrity Errors (Explanation in AllFiles Report) Record Count Validation Errors (Explanation in AllFiles Report) Missing/Un-Expected School Errors (Information in AllFiles Report) Review – Look up Errors:  Review – Look up Errors 1 Is this an import or validation report? What error chart references these errors? Do I need to resolve the conditions that caused these records to be filtered? Review – Look up Errors:  Review – Look up Errors 2 Is this an aggregation or validation error? What’s the difference? What error chart references this error? Does this error impact my data submission? Review – Look up Errors:  Review – Look up Errors 3 Are these aggregation or validation errors? What’s the difference? What error chart references these errors? Which data value gets fixed when more than one data element is referenced? Review – Look up Errors:  Can Aggregation Errors be ignored? What about the warnings? How do these messages relate to the LEA reports? How can I tell which records are contributing to these errors? Review – Look up Errors 4 Review – Look up Errors:  How are RI errors and Record Count errors different? Do validation errors contribute to the production of RI and Record Count errors? Review – Look up Errors 5 6 Real World Scenarios:  Real World Scenarios Review error examples/questions submitted by participants. Discuss known SIS issues and solutions Known Issues:  Known Issues SS - W-LC-38 produced even though total 5a and total 5b don't match SS - W-LC-029 produced on schools with grades 7-12 in error SS – Exception error at Certify step but Certification goes through successfully Local ID missing for E9058 – Allfiles Report Notable Error Conditions:  Notable Error Conditions Bilingual Teachers CAN’T be coded with English, must be another language Only report teachers that provide core instructions – see Spring DSR Post Agg errors: ALL Post Agg warnings: review for legitimacy Suggested Strategies:  Suggested Strategies Set benchmarks on the local SIS side. Run reports to check for required fields such as Birth Country or primary language to ensure all the data is populated correctly. Run a report that gives summary of totals (ex: expected number of ELs, SNOR students, etc). Set a benchmark by processing data through server (perform SEND), correcting F errors and obvious errors along the way. Evaluate results of LEA report to identify data discrepancies. Review results of All Files report to identify errors that contribute to data discrepancies. Correct these errors only, plus any Aggregation errors. Suggested Strategies (continued):  Suggested Strategies (continued) Review Import reports if All Files errors do not seem to account for all data discrepancies. Repeat steps, this time addressing Import filtering and Client validation messages along the way. Continue to repeat until LEA reports show the correct data aggregate values and there are no Aggregate and Expected/ Unexpected Schools errors. Certify transaction. IF there are no Aggregate errors and IF LEA report is accurate, It is not necessary to correct all remaining errors in order to Certify. Suggested Strategies (continued):  Suggested Strategies (continued) Be aware of Import report totals HINT: If Input count is lower than expected, extract did not pull all your records HINT: If Kept count is lower than expected, check why records were filtered Review Validation reports Assess errors and correct those that will obviously affect the submission (e.g.. Check for missing INST errors in Record Count Validation) Remember, the error reports don’t show every record that has the same error. When correcting your SIS, take time to apply correction to all relevant records. SEND once a group of errors are fixed to assess your success in producing more accurate results. Spring Q & A:  Spring Q & A Spring Q & A document is available on CSIS website: http://www.csis.k12.ca.us/library/reporting-requirements/ Important Deadlines:  Important Deadlines Production LEAs Submission Window ends April 30th Amendment Window ends May 25th Parallel LEAs Traditional Submission Window ends – March 30th CSIS Submission Window ends – April 21st Comparability Window ends – May 25th Support Contact Information:  Support Contact Information Contact CSIS Support at: Phone: (916) 325-9210 Email: support@csis.k12.ca.us CSIS Website – Support http://www.csis.k12.ca.us/support CSIS Listserv Website General - http://www.csis.k12.ca.us/listserv One Way – LEA automatically added based on Digital Certificate Q & A:  Q & A

Add a comment

Related presentations

Related pages

Accident Analysis First solo follies - Flight Training

April 2007 Departments Accident Analysis. By: Dan Namowitz. ... It's a nice spring day, ... as reinforced in all the prior training.
Read more

Word 2007: Using Grammar Check, UWEC

Microsoft Word 2007 ... to access correction options allows you to manage grammar mistakes quickly and easily. Right click the grammatical error » select ...
Read more

Error Bars in Excel Charts - Peltier Tech Blog - Peltier ...

Error Bars in Excel ... I have written a new article about Error Bars in Excel 2007. ... for individual error bars, such as different color error bar ...
Read more

Basic Microsoft Excel Training For Beginners Course: 2007 ...

Microsoft ® Excel ® Basics Become a confident, capable Excel 2007 and 2010 user with this customized Excel training! Covers Excel 2007 and 2010 ...
Read more

How to Write a Spelling Corrector - Peter Norvig

... independently told me they were amazed at how Google does spelling correction so ... 270 spelling errors, ... British spelling (our training ...
Read more

PDF417 2D Barcode Information & Tutorial | IDAutomation

Create a Barcode in Excel 2007; ... PDF417 Error Correction Levels. PDF417 uses Reed Solomon ... IDAutomation PDF417 barcode products all support the ...
Read more

Corrections - ESPN

Corrections of significant factual errors across ... Patriots coach Bill Belichick's NFL punishment in 2007. ... day of training ...
Read more

COGNITIVE-BEHAVIORAL TREATMENT

National Institute of Corrections COGNITIVE-BEHAVIORAL ... cognitive-behavioral coping-skills training ... 2007 in press). The Cognitive-Behavioral ...
Read more