This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
sasixp:eoy_report_queries [2007/05/17 16:40] GINAC |
sasixp:eoy_report_queries [2007/07/26 15:49] ginac |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ==== EOY Report | + | ==== EOY Student Records Collection |
- | NOTE: For ALL of these Queries, you **MUST** check the "Show Inactive Records" | + | Document created by Jennifer Rhea |
- | == Check English Proficiency, | + | The following queries will help review SASI data due on the End of Year report for accuracy. |
- | DISPLAY | + | |
- | == Check Enter/Leave Code and Date == | + | Notes: |
- | DISPLAY AENR | + | |
+ | - For queries that begin with XXXX ASTU, where XXXX indicates different file names, link ASTU to XXXX by dragging Stulink from the XXXX column to the field above the second column. | ||
+ | - All schools must run all queries to make sure nothing is in the fields that don’t apply. | ||
- | == Check Ethnic Code == | ||
- | DISPLAY ASTU PermNum LastName FirstName EthnicCode# | ||
- | == Check for Blank StateID == | ||
- | DISPLAY ASTU PermNum LastName FirstName StateID | ||
- | == Check Free/ | + | === Check for Blank State Testing Identifier (M) === |
- | DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " " | + | |
- | == Check Gender == | + | DISPLAY ASTU PermNum LastName FirstName |
- | DISPLAY ASTU PermNum LastName FirstName | + | |
- | == Check GATE atom == | + | === Check Unique Local Student Identifier (M) === |
- | DISPLAY | + | |
+ | DISPLAY ASTU | ||
- | == Check Grad Plan == | + | === Check Responsible Division/ |
- | DISPLAY ASTU PermNum | + | |
+ | DISPLAY ASTU PermNum LastName FirstName | ||
- | == Check Grad/Other Completer == | + | These two elements are queried together for comparison reasons. |
- | DISPLAY ASTU PermNum | + | |
- | == Check Grade == | + | The UserCd3 (Tuition Tag) field should be blank unless student resides in Johnson County, TN in which the code will be 10, or the student is in the Co-op Special Ed program at AHS or GES, or is part of a Residential Special Ed Center. |
- | DISPLAY ASTU PermNum LastName FirstName Grade | + | |
- | == Check Hidden Absences | + | === Check Responsible School |
- | DISPLAY | + | DISPLAY ASTU PermNum LastName FirstName |
- | == Check Hidden Absences | + | The Resp. Sch (usernum5) should be blank unless student resides in Johnson County, TN (usercd2) in which the code will be 8888. |
- | DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " " | + | |
- | == Check Homeless | + | === Check Serving Division/ |
- | DISPLAY ASTU PermNum LastName FirstName | + | DISPLAY ASTU PermNum LastName FirstName |
- | == Check KG Readiness == | + | The Serving Div (AltID1) |
- | DISPLAY ASTU PermNum LastName FirstName BirthDate IF BirthDate > " | + | |
- | == Check Migrant | + | === Check Active Status (M) === |
- | DISPLAY ASTU PermNum | + | DISPLAY AENR |
- | == Check Non-Public FTE == | + | If student does not have an Enter or Leave Code their status must be N. Do a matrix to check that every student without an enter/leave code is tagged with an N (no show). |
- | DISPLAY ASTU PermNum LastName FirstName | + | === Check Enter Code/Leave Code/Date (M) === |
+ | DISPLAY AENR ASTU PermNum LastName FirstName | ||
- | == Check PK EXP Time == | + | Link ASTU by dragging Stulink from the AENR column to the field above the second column. |
- | DISPLAY | + | |
- | == Check Responsible Division/ | + | Most all E1’s should fall on or before the first day of the school year. If not, please check for accuracy. |
- | DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3 | + | |
- | == Check Responsible School == | ||
- | DISPLAY ASTU PermNum LastName FirstName UserCd2 UserNum5 | ||
- | == Check Retention Flag == | + | === Check Ethnic Code (M) === |
- | DISPLAY ASTU PermNum | + | DISPLAY ASTU PermNum LastName FirstName |
- | == Check Serving Division/ | + | Every student should have an Ethnic Code. |
- | DISPLAY ASTU PermNum LastName FirstName | + | |
- | == Check Student Name == | ||
- | DISPLAY ASTU PermNum LastName FirstName MiddleName | ||
- | == Check Summer Dropout | + | === Check Gender (M) === |
- | DISPLAY | + | DISPLAY ASTU PermNum LastName FirstName |
- | == Check Summer Dropout 2 == | + | Make sure all male students are marked M (Male) and all female students are marked F (Female). |
- | DISPLAY AENR ASTU 2, Status PermNum LastName FirstName EffDate 1,EnterCode 1,LeaveCode TransYear IF TransYear = " | + | |
- | == Check Summer Dropout 3 == | ||
- | DISPLAY ASTU PermNum LastName FirstName | ||
- | == Check Title I == | + | === Check Birthdate (M) === |
- | DISPLAY ASTU PermNum | + | DISPLAY ASTU PermNum LastName FirstName Grade Birthdate |
+ | Check the Birth Date field for accuracy, in particularly the year of birth. | ||
- | == Check Truancy Conferences | + | === Check Grade Level (M) === |
- | DISPLAY | + | DISPLAY ASTU |
- | == Check Unique Local Student ID == | + | Check that there are no grades outside of your school’s grade range. |
- | DISPLAY ASTU PermNum LastName FirstName | + | |
- | == Check W8 Reason == | ||
- | DISPLAY ASTU PermNum | ||
- | == Check W8 Reason | + | === Check Disability Code (M) === |
- | DISPLAY ASTU PermNum | + | DISPLAY ASTU PermNum LastName FirstName InstrSet IF InstrSet <> “ “ |
+ | |||
+ | All special education students should have a primary disability code (InstrSet). | ||
+ | |||
+ | |||
+ | === Check Free Meals === | ||
+ | DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " " | ||
+ | |||
+ | DISPLAY ASTU PermNum LastName FirstName Homeless IF Homeless = “X” | ||
+ | |||
+ | DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = “X” | ||
+ | |||
+ | These queries will give you a list of all students who have either Free or Reduced lunch, are tagged Homeless, or are tagged Migrant, which indicates a disadvantaged student. | ||
+ | |||
+ | No student should be marked Migrant unless they have a certificate of eligibility provided by the state of Virginia. | ||
+ | |||
+ | If student is homeless and does not receive free/ | ||
+ | |||
+ | |||
+ | === Check Limited English Proficiency/ | ||
+ | DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3 CntryCode IF EngProf <> " " | ||
+ | |||
+ | Link ASTU by dragging Stulink from the AHLN column to the field above the second column. | ||
+ | |||
+ | If the EngProf (ESL) field in the Student Atom is greater than blank the Language3 (Language Spoken to Student at Home) field in the Home Language Atom most likely should be something other than English. | ||
+ | |||
+ | |||
+ | === Check Gifted === | ||
+ | DISPLAY AGAT ASTU LastName FirstName GateDate General Specified# Visual PsyMotor if GateDate <> " " | ||
+ | |||
+ | The GateDate field should reflect the student’s date of referral. | ||
+ | |||
+ | === Check Title 1 (All Schools) === | ||
+ | DISPLAY ASTU PermNum LastName FirstName Grade UserCd7 if UserCd7 <> " " | ||
+ | |||
+ | Middle/High make sure nothing is in this field for grades greater than 02. | ||
+ | |||
+ | |||
+ | === Check GED Program Code (All Schools) === | ||
+ | DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 IF UserCd4 IN [5,8,9] | ||
+ | |||
+ | The UserCd4 (Diploma Tag) field should contain one of the two (GED(5), GED/ | ||
+ | |||
+ | |||
+ | === Check Graduate/ | ||
+ | DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 InstrSet IF Grade = “12” | ||
+ | |||
+ | The UserCd4 (Diploma Tag) field should be greater than blank if grade = 12. If Diploma Tag = 3, 7, or 10 student must have Disability Code (InstrSet). | ||
+ | |||
+ | === Check Graduation Plan(M) === | ||
+ | DISPLAY ASTU PermNum LastName FirstName Grade PostSecond IF Grade = “12” | ||
+ | |||
+ | The GradPln (PostSecond) field should be greater than blank if grade = 12. | ||
+ | |||
+ | |||
+ | === Check Advanced Placement (Classes) === | ||
+ | DISPLAY ACLS | ||
+ | |||
+ | Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column. | ||
+ | |||
+ | If a student is currently enrolled in an AP course they must have 1, 2, or 3 marked in the UserNum2 field in the Student atom. This query’s accuracy depends on the AP courses being marked with an A (Advanced Placement) in the N/H field in the Course atom. | ||
+ | |||
+ | DISPLAY ASTU PermNum LastName FirstName UserNum2 IF UserNum2 <> “ “ | ||
+ | |||
+ | This query is for middle/elem schools to make sure nothing is in the Advanced Placement (UserNum2) field in the Student atom. | ||
+ | |||
+ | |||
+ | === Check Advanced Placement (Class History) === | ||
+ | DISPLAY ACLH ASTU ACRS 2, | ||
+ | |||
+ | Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column. | ||
+ | |||
+ | If a student has taken an AP class during the current year they must have 1, 2, or 3 marked in the UserNum2 field in the Student atom. This query’s accuracy depends on the AP courses being marked with an A (Advanced Placement) in the N/H field in the Course atom. | ||
+ | |||
+ | |||
+ | === Check Dual Enrollment (Classes) === | ||
+ | DISPLAY ACLS | ||
+ | |||
+ | Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column. | ||
+ | |||
+ | If a student is currently enrolled in a Dual Enrollment course they must be on this list. This query’s accuracy depends on each Dual Enrollment course being marked greater than blank in the Dual Enrollment (CollArea1) field in the Course atom. | ||
+ | |||
+ | DISPLAY ACRS Title CollArea1 IF CollArea1 <> “ “ | ||
+ | |||
+ | This query is for middle/elem to check the Course file to make sure no courses are marked as dual enrollment courses. | ||
+ | |||
+ | |||
+ | === Check Dual Enrollment (Class History) === | ||
+ | DISPLAY ACLH ASTU ACRS 2,Status PermNum LastName FirstName Title CollArea1 IF CollArea1 <> " " | ||
+ | |||
+ | Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column. | ||
+ | |||
+ | If a student has taken a Dual Enrollment course during the current year they must be on this list. This query’s accuracy depends on each Dual Enrollment course being marked greater than blank in the Dual Enrollment (CollArea1) field in the Course atom. | ||
+ | |||
+ | |||
+ | === Check CTE Finisher (M) === | ||
+ | DISPLAY AVOC ASTU PermNum LastName FirstName | ||
+ | |||
+ | This is a list of students who have one or the other markings in the Vocation Ed atom. Use this list to verify that they are marked correctly. | ||
+ | |||
+ | |||
+ | === Check W8 Reason (M) === | ||
+ | DISPLAY ASTU PermNum LastName | ||
+ | |||
+ | All students with a droupout (W8) code must have a W8 Reason in the UserCd1 field. | ||
+ | |||
+ | DISPLAY ASTU PermNum LastName FirstName UserCd1 LeaveCode | ||
+ | |||
+ | No student should have a W8 Reason code if they are not dropouts. | ||
+ | === Check Summer Dropouts (M) === | ||
+ | DISPLAY ASTU PermNum LastName FirstName | ||
+ | |||
+ | DISPLAY AENR ASTU 2,Status PermNum | ||
+ | |||
+ | DISPLAY AENR ASTU 2,Status PermNum | ||
+ | |||
+ | Link ASTU by dragging StuLink from the AENR file to the field above the second column. | ||
+ | |||
+ | Any student who was in membership the last day of school the previous year but did not return to any school during the current year by Oct 1 must be marked as a Summer Dropout. | ||
+ | |||
+ | |||
+ | === Check Aggregate Days Present/ | ||
+ | DISPLAY AATD | ||
+ | |||
+ | Link ASTU by dragging StuLink from the AATD file to the field above the second column. | ||
+ | |||
+ | === Check Aggregate Days Present/ | ||
+ | DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " " | ||
+ | |||
+ | Link ASTU by dragging StuLink from the AATP file to the field above the second column. | ||
+ | |||
+ | This query gives you a list of students who have absent marks after their withdrawal date. This will affect both the Aggregate Days Present and Absent. | ||
+ | |||
+ | |||
+ | === Check Retention Flag (M) === | ||
+ | DISPLAY ASTU PERMNUM | ||
+ | |||
+ | If a student is to repeat their current grade next year or will not be promoted until after summer school completion they should have their current grade in the NextGrade field indicating that he/she is Retained. | ||
+ | |||
+ | |||
+ | === Check Truancy Conferences === | ||
+ | DISPLAY ACNF | ||
+ | |||
+ | Link ASTU by dragging StuLink from the ACNF column to the field above the second column, then link ACNR by dragging DescCode from the ACNF column to the field above the third column. | ||
+ | |||
+ | This query gives you a list of students who will be reported as Truant. | ||
+ | |||
+ | |||
+ | === Check Non Public FTE (M) === | ||
+ | DISPLAY ASTU PermNum LastName FirstName PctApport IF PctApport <> " " | ||
+ | |||
+ | Students containing a percentage amount in this field must be part time students taking two courses or less at your school. | ||
+ | Check First Year In Ninth Grade (High) | ||
+ | |||
+ | DISPLAY ASTU PermNum LastName FirstName | ||
+ | |||
+ | All 9th graders must have either 1,2,3, or 4 entered into the 9thTrk (NextTrack) field. | ||
+ | |||
+ | |||
+ | === Check Kindergarten Readiness Assessment === | ||
+ | DISPLAY ASTU PermNum LastName FirstName BirthDate if BirthDate > " | ||
+ | |||
+ | If a student is on this list email those names to jrhea@wcs.k12.va.us indicating whether or not those students were administered the readiness assessment. | ||
+ | |||
+ | |||
+ | === Check Early College School Program Code === | ||
+ | DISPLAY ASTU PermNum LastName FirstName | ||
+ | |||
+ | This query gives you a list of students who have either signed the Early College Scholar Agreement (1) or have earned the Early College Scholar Certificate (2) | ||
+ | |||
+ | |||
+ | === Check Distance Learning === | ||
+ | DISPLAY ACRS | ||
+ | |||
+ | This list gives you the courses in the Course atom that are flagged as distance learning. | ||
+ | |||
+ | |||
+ | === Check PK Experience Code/PK Weekly Time Code === | ||
+ | DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# UserNum1 if Grade = " | ||
+ | |||
+ | All PK students must have a PK Experience Code and PK Weekly Time Code. | ||
+ | |||
+ | |||
+ | === Check Student Name === | ||
+ | DISPLAY ASTU PermNum LastName FirstName MiddleName | ||
+ | |||
+ | Every student should have a first, middle, and last name if applicable. | ||