CACTUS Institution Table Changes for 2009-2010 - Randy Raphael, Travis Rawlings, Sam Jones
1. In the Fall Clearinghouse, for this first time this year (October 2009), a reported grade level for a student outside of the reported grade span for the school in Cactus produced a warning.
2. LEAs will have all year to correct data, either by changing the grade level of the student in their SIS or changing the grade span (grade_low and/or grade_high) in the CACTUS school_year table for school year 2010. To change either of the grade span fields, the LEA must communicate the desired change to Shaunna Ford, who will then update it in Cactus. (The possibility of opening these fields to the LEA for direct updating was rejected by LEA representatives themselves at a monthly meeting of the Data Warehouse Group.) Shaunna reports having made several such changes during the data collection period.
3. In the Year End Clearinghouse, the same situation as in (1) will produce an error and therefore require correction as in (2) before the file will be accepted.
4. Following the Fall Clearinghouse upload, grade span data will be used to update grade_level_summary in the Cactus school table. Specifically, the first five rules below (a through e) will be applied in the fall to just those schools in which at least one student was reported as enrolled in October 2009; the grade spans of all other schools in Cactus will remain as they were:
- a. If grade_high is -1, set grade_level_summary to PREK.
- b. If grade_high is 12, set grade_level_summary to HIGH.
- c. If grade_high is 09, 10 or 11, set grade_level_summary to MID.
- d. If grade_high is 07 or 08 and grade_low is 05, 06, 07, or 08 set grade_level_summary to MID.
- e. Otherwise, set grade_level_summary to ELEM.
5. Notice that we are reducing use of the K12 designation, as it is problematic when requests are made for a breakdown of schools by the intuitive tripartite classification of “elementary,” “middle” or “high” school.
6. Two implications of the preceding set of rules, which are especially significant for charter schools, are that: a K-8 school will be classified as an elementary school; and, when the same school adds grade 9, it will become a middle school.
7. Prior to the production of accountability reports but after the collection of test answer documents, grade span and grade_level_summary will be used to update upass_report_type in the school_year table for 2010. So, the next rule is:
- f. If grade_high is -1 (preschool), 00 (kindergarten), 01, or 02, set upass_report_code to X (“no report”).
8. But (an unresolved question is) what happens if the test answer documents for a school include a grade outside of its (apparently) established grade span? This may not be a problem. The test is just considered out-of-level for accountability reporting if the test is for a lower grade level than recorded in Clearinghouse. It is not necessarily inappropriate for a school to administer a test out of their grade span.
9. The last two rules will be applied only to schools for which at least 10 (ten) usable answer documents were returned in Spring 2010; the upass_report_type for all other schools in Cactus, no matter what their grade_level_summary, will be set to to X:
- g. If grade_level_summary is HIGH, set upass_report_code to H.
- h. Otherwise, set upass_report_code to E.
10. Notice that there is no effective distinction between elementary and middle schools with respect to accountability reporting, so we are deprecating use of the M [middle school] designation for upass_report_code. When the currently available list of report codes was originally constructed, there was a larger variety of formats for producing accountability reports. (The upass_report_code in the dropdown menu in the Cactus interface will be modified to allow only E, H, or X in order to reduce potential for error.) It may not mattered what type of school it was for a U-PASS report. U-PASS and middle and elementary reports seem to be the same.
11. Problems in classification that remain after this procedure has been applied will be worked out on a case-by-case basis with information external to the database.
12. When principal access to teacher data is enabled via UEN, read only directory information from Cactus will also be exposed, and principals will be encouraged to send email (automatically directed to Shaunna) to request correction of any data element that they believe shows an incorrect value for their school.
Highly Qualified Teacher Reports
- HQ Detail Report – Has been sent to Superintendents; Missing Teachers Example
- HQ Course Counts – 2008-09 Year-end compared to Oct 2009 submission
Discrepancy Report in CACTUS – Demo, Training for CACTUS Users – Will be contacting
CACTUS IDs for New Hires