Comprehensive Student Data Roster Guide
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
Comprehensive Student Data Roster - 2017-18 Marking Period 2 Edition
Release date: December 11, 2017
Data Guide
2
3
The Comprehensive Student Data Roster (CSDR) is produced in Excel.
This data guide will provide a basic explanation of the data points and associated abbreviations.
4
To manipulate a CSDR file, you must first download a copy to your own computer.

To use the Comprehensive Data Roster most effectively, you can sort or filter on different data elements and hide columns to focus on the data points or students you are most interested in.
We have created two how-to videos showing users how to sort, filter and print in excel.
5
Click here for How-To Videos
6
Your CSDR is 'Protected Student-Level Data' in Data Reports - InternalMulti-School CSDRs are available to Central Office Staff
7
Each CSDR file contains a choice of field headers.
Row 4 headers are best used by Excel AutoFilter. (Select row 4, pull down "Data -> Filter"). Note: You may delete row 5.
Row 5 is best for use by Excel PivotTable. Note: you may delete rows 1-4.
8
CSDR edition: 2017-18 Marking Period 2 Edition will be published to Google Drive on 12/11/2017.
For questions or comments about the Comprehensive Data Roster, please email Jay Tharp james.tharp@ousd.org
9
Report Section / Data ElementData NotesGuide to Abbreviations
& Additional Resources
Updated in Current CSDR?RAD
Contact
Person
10
Teacher, Course, and Course GradesElementary: Teacher, plus recent Standards-Based Grades

Secondary:
Advisor (if known), plus
Teacher, Course & recent Grades


Teacher and Course information is fresh from class rosters;
Course Grades are from M2 (Fall Marking Period 2).
UPDATED:
Current as of 12/6/2017
James.Tharp@ousd.org
11
Pathway EnrollmentEnrollment in a Linked Learning Pathway or AcademyUPDATED:
Current as of 12/6/2017
Kevin.Schmidke@ousd.org
12
Prior Year EnrollmentSchool and Advisor/Teacher at end of 2016-17Current as of 6/26/2017James.Tharp@ousd.org
13
Disability Category;

SDC / PEC Program Participation
Special Education diagnostic classification -->

SDC, RSP, Inclusion, or 'Other' Special Ed Program
AUT - Autism; DB - Deaf-Blindness; ED - Emotional Disturbance; EMD - Estab Medical Disab; HH - Hard of Hearing; HI - Deaf / Hearing Impairment; ID - Intellectual Disability; MD - Multiple Disabilities; OHI - Other Health Impairment; OI - Orthopedic Impairment; SLD - Specific Lrng Disability; SLI - Speech or Language Impairment; TBI - Traumatic Brain Injury; VI - Visual ImpairmentUPDATED:
Current as of 12/6/2017
James.Tharp@ousd.org
14
Newcomer, UAY, SIFE, RAF, adn HomelessN0 - Mid-Year Arrival; N1 - First Year Newcomer; etc.
UAY - Unaccompanied Youth
SIFE - Student with Interrupted Formal Education
RAF - Refugee or Asylee
UPDATED:
Current as of 12/6/2017
Rattana.Yeang@ousd.org
15
Click Here for AERIES Newcomer Tag Guidance document
16
GPAProvided for students grades 6-12.CUMULATIVE GPAs: "Total" and "Academic",
Weighted and Non-weighted.

MARKING PERIOD GPAs for the current year (Total Weighted).
UPDATED:
Current as of 12/6/2017
James.Tharp@ousd.org
17
Student Data - English FluencyTwo types of fluency designation are provided: (1) Overall Fluency, and (2) Detailed Fluency designation, which is calculated based on a student's years enrolled, CELDT and SRI scores.

For questions, please contact Nicole Knight at nicole.knight@ousd.org or Rattana Yeang at rattana.yeang@ousd.org
Detailed Fluency Groups

- Long Term - EL-LTEL - Enrolled more than 6 years. Did not meet CELDT and Basic Skills requirement for reclassification.
- At Risk - EL-AR - Enrolled for 3-6 years. No growth on CELDT performance level in the last two years. Did not meet Basic Skills requirement for reclassification.
- Progressing - EL-PROG - Enrolled for 3-6 years. Demonstrated growth on CELDT performance leve in th last two years. Met Basick Skills requirement for reclassification.
- Recently Enrolled - EL-REC - Enrolled less than 3 years.

- Recently Proficient - RFEP-REC - Proficient in the last 4 years.
- Long-Term Proficient - RFEP-LT - Proficent over  4 years.
UPDATED:
Current as of 12/6/2017
Rattana.Yeang@ousd.org
18
For more Fluency Detail data, refer to our ELL progress monitoring dashboard.
19
Live-Go Geospatial DataDistance from Residence to School (Miles)
LiveGo classification
Y=student lives and goes to the school in attendance area
N=student does not go to the school in attendance area
X=student address is not geocodeable
C=student attends school with citywide attendance area
O=student lives outside OUSD
UPDATED:
Current as of 12/6/2017
Susan.Radke@ousd.org
20
AttendanceYear-to-date (through end-of-marking-period):
Attendance rate.
Satisfactory = 95% and above
At Risk = Above 90% and less than 95%
Chronic Absent = 90% or below, greater than 80%
Severe Chron Absent = 80% or less
UPDATED:
Coverage through 11/17/2017
Kevin.Smith@ousd.org
21
SuspensionYear-to-date (through end-of-marking-period):
# Suspensions, and # Days Suspended.
Out-of-School SuspensionsUPDATED:
Coverage through 11/17/2017
James.Tharp@ousd.org
24
High School ReadinessA student is considered "High School Ready" when completing the 8th grade year with:
(1) Total weighted GPA of 2.5 or higher;
(2) School attendance 96% or better;
(3) No final D or F grade in core English or math;
(4) No Suspensions.
Current as of 6/27/2017Kaia.Vilberg@ousd.org
25
Graduation & College Readiness - Credits Attempted & CompletedShown for students grades 6-12.Also shown: Credits Completed in each of the A-G subject areasUPDATED:
Current as of 12/6/2017
Kevin.Schmidke@ousd.org
26
EAP - Early Assessment Program for CSU And CCC coursework readinessThe EAP ELA and EAP Math assessments are anchored in SBAC Overall Acheivement Level ScoresReady = Ready for English and/or mathematics college-level coursework;
Conditionally Ready = Conditionally Ready for English and/or mathematics college-level coursework;
Not Yet Ready = Not yet demonstrating readiness for English and/or mathematics college-level coursework;
Not Ready = Not demonstrating readiness for English and/or mathematics college-level coursework.
Includes Scores from May 2017Kevin.Schmidke@ousd.org
27
SRI - Scholastic Reading InventorySRI assessment is adminsistered 3X per year.  Lexile scores from 2015-16 and 2016-17 are provided. Lexile, Lexile Grade and Performance Band scores are provided for the Fall 2017 test administration.Click here for SRI Lexile ChartIncludes Scores from Fall 2017Kevin.Smith@ousd.org
28
F&P and DRAThe Fountas & Pinnell assessment identifies a student's current reading level and is scored on an alphabetical scale from A-Z. The Development Reading Assessment is scored numerically. The CSDR scores are the "instructional" reading levels (rather than independent reading levels). Admin 1 scores may be either the diagnostic or the fall assessment.Click here for OUSD F&P benchmark levelsIncludes Scores from Fall 2017Rinat.Fried@ousd.org
30
SMI - Scholastic Math InventorySMI assessment was adminsistered 2X during 2016-17, to students in grades 3-8 or in an Algebra 1 course.  Quantile scores are shown. A negative score denotes an EM ("Early Mathematician") score.Click here for SMI Quantile and Grade READINESS ChartIncludes Scores from Fall 2017Kevin.Smith@ousd.org
31
Elementary Math - C-EoU scoresCurriculum-embedded summative assessments for grades K-5. During the Fall 2017 testing window, 39 of 54 schools that have K-5 students participated.4 performance bands for the Overall scores.
For Constructed-Response and Performance-Task question groups, a percentage-correct score is provided together with a "mast" -- mastery -- flag for scores that demonstrated proficiency.
New:
Selected Scores from Fall 2017
James.Tharp@ousd.org
32
CELDTPerformance level and scale score provided for 2015-16 and 2016-17 Annual administrations. For 2016-17, we provide listening, speaking, reading and writing performance levels as well as the CELDT criterion flag - which means the student passed the CELDT (received a 3 or better in all four domains).Beginner
Early Intermediate
Intermediate
Early Advanced
Advanced
Coverage through
June 2017
Rattana.Yeang@ousd.org
33
For more CELDT data, refer to our ELL dashboards.
34
SBACELA and Math Achievement Levels, Scale Scores, plus "Claim" Subscores. 4 Performance Bands for Overall Acheivement:
Standard Exceeded, Met, Nearly Met, Not Met.

3 Performance Bands for Subscore Claims:
Above Standard, At or Near Standard, Below Standard
Includes Scores from May 2017James.Tharp@ousd.org
35
PFT - Physical Fitness TestTwo years of PFT results for Aerobic Capacity, Abdominal Strength, Body Composition, Trunk Extensor Strength, Upper Body Strength and Flexibility. Data is based on the state research file and Healthy Fitness Zones created by FITNESSGRAM. FITNESSGRAM uses HEALTHY FITNESS ZONES (HFZ) to evaluate fitness performance. These zones represent minimum levels of fitness that offer protection against the diseases that result from sedentary living. Healthy Fitness Zone Totals 1-6 indicate how many times a student scored in the Healthy Fitness Zone. For more detailed information about FITNESSGRAM, HEALTHY FITNESS ZONES, and the PFT, please refer to the state website: www.cde.ca.gov/ta/tg/pf/

H = In the Healthy Fitness Zone
I = Insufficient or Invalid
N = Needs Improvement
X = Needs Improvement Health Risk
Includes Scores from May 2017Rattana.Yeang@ousd.org
36
For more PFT data, refer to our PFT dashboards.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
Loading...
 
 
 
Sheet1