Making Connections Among Cohort Data ATS, HSST, and NYS Accountability Rules

1
Making Connections Among Cohort Data (ATS), HSST,
and NYS Accountability Rules

• Jie Zhang
• Principal
• Queens High School for the Sciences at York
  College
• JZhang_at_schools.nyc.gov

2
Step 1 Using ATS RCOS

• Print or download ATS New York City Public
  Schools Class of 2007 Meeting Graduation
  Requirements (RCOS). See next page for sample.

3
(No Transcript)
4
Data Import

• Open Microsoft Excel then open RCOS.dat
• Import the data
• Clean up the imported data
• Sort the data by Exam Status
• Save the file as an Microsoft Excel worksheet,
  see sample on next page

5
Sample RCOS (Cohort) with Failing or Not Tested
Students Only in Excel form
6
Step 3Using HSST Files

• Download HSST Custom Reports
• 1.37 Transcript Get students grades for subject
  courses by group
• Get Student grades for all students in specified
  year/term. Report returns the following columns
  Student ID, Last Name, First Name, Official
  Class, Grade Level, Course, Section, Period,
  Teacher, Room, Marking period Grade 1, 2, 3,
  Final Exam, Final Mark
• See sample on next page

7
Sample Subject History of a Student
8
1.07 Student Grades for Year/Term

• Subject codes
• English /ESL
• Social Studies
• Mathematics
• Sciences
• Foreign Language
• Career Tech Education
• The Arts
• Health/Physical Education
• Miscellaneous/Guidance

9
Sample Student Subject Class
10
Step 4 (Advanced)

• Merge files received from steps 1, 2, and 3, a
  complete history file for all the students who
  have either failed the Regents Exam or have not
  been tested is made.

11
Now You Have a Complete Subject History for
Students Who Have Not Met the Graduation
Requirements (Both Testing and Course Study)
12
How did we do in meeting the Effective AMO in
2004-2005?

• Please see next page

13
(No Transcript)
14
(No Transcript)
15
How are we doing in meeting this years
Effective AMO?

• See next page

16
Last Two Pages From RCOS
17
(No Transcript)
18
Lets look at Econ Disadvantaged

• Total 96
• Passed (85-100) 4 (level 4)
• Passed (65-84) 36 (level 3)
• Passed (55-64) 18 (level 2)
• Current Performance Index
• 100(2x4 2x36 18)/96 102

19
What is our goal?
20

The Effective AMO for this year is 142.

21
At least how many students in this category need
to pass or move up a level for us to meet the
Effective AMO?

• New PI 100(2x4 2x36 18 ?)/96 142
• Answer 39

22
Thank you very much!Have a nice day!