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 - 2018-19 School Start-Up Edition
Release date: August 9, 2018
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: 2018-19 School Start-Up Edition will be published to Google Drive on 8/9/2018.
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
11
School and Pathway EnrollmentEnrollment in a Linked Learning Pathway or AcademyUPDATED:
Current as of 8/5/2018
Kevin.Schmidke@ousd.org
13
Prior Year EnrollmentSchool and Advisor/Teacher at end of 2017-18Current as of 6/26/2017James.Tharp@ousd.org
14
Disability Category;

SDC / SpEd 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 8/5/2018
James.Tharp@ousd.org
15
Newcomer, UAY, SIFE, RAF, and 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 8/5/2018
Rattana.Yeang@ousd.org
16
Click Here for AERIES Newcomer Tag Guidance document
17
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 8/5/2018
James.Tharp@ousd.org
18
Student Data - English FluencyTwo types of fluency designation are provided: (1) Overall Fluency, and (2) Fluency subgroup 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
Fluency Subgroups

- 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.

* During 2017-18, California transitioned to ELPAC testing; CELDT growth data is no longer available. Moving forward, At Risk and Progressing students will be flagged as ELL-3-6 YRS: student enrolled for 3-6 years in US school.
UPDATED:
Current as of 8/5/2018
Rattana.Yeang@ousd.org
19
For more Fluency Detail data, refer to our ELL progress monitoring dashboard.
20
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 8/5/2018
Susan.Radke@ousd.org
21
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
Coverage through EOY 2017-18Kevin.Smith@ousd.org
22
SuspensionYear-to-date (through end-of-marking-period):
# Suspensions, and # Days Suspended.
Out-of-School SuspensionsCoverage through EOY 2017-18James.Tharp@ousd.org
23
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.
Coverage through EOY 2017-18Kaia.Vilberg@ousd.org
24
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 8/5/2018
Kevin.Schmidke@ousd.org
25
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 SBAC
(May 2018)
Kevin.Schmidke@ousd.org
26
SRI - Scholastic Reading InventorySRI assessment is adminsistered 3X per year.  Lexile scores from 2016-17 and 2017-18 are provided. Lexile, Lexile Grade and Performance Band scores are provided for the Spring 2018 test administration.Click here for SRI Lexile ChartCoverage through EOY 2017-18Kevin.Smith@ousd.org
27
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 levelsCoverage through EOY 2017-18Rinat.Fried@ousd.org
29
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 ChartCoverage through EOY 2017-18Kevin.Smith@ousd.org
30
Elementary Math - C-EoU scoresCurriculum-embedded summative assessments for grades K-5. 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.
Coverage through EOY 2017-18James.Tharp@ousd.org
31
ELPACThe English Language Proficiency Assessments for California (ELPAC) is the successor to the California English Language Development Test (CELDT). Beginning in 2017-18, the ELPAC is the required state test for English Language Proficiency (ELP) that must be given to students whose primary language is a language other than English. State and federal law require that local educational agencies administer a state test of ELP to eligible students in kindergarten through grade twelve. The ELPAC is aligned with California's 2012 English Language Development Standards and is comprised of two separate ELP assessments:

1. Initial ELPAC - An initial identification of students as English Learners.
2. Summative ELPAC - An annual summative assessment to measure an English Learner's progress in learning English and to identify the student's ELP level. Only Summative ELPAC data is currently available in this spreadsheet.
For Overall, Oral Language & Written Language
1 - Level 1
2 - Level 2
3 - Level 3
4 - Level 4

For Listening, Speaking, Reading & Writing
1 - Beginning
2 - Somewhat/Moderately
3 - Well Developed
Coverage through
April 2018
Rattana.Yeang@ousd.org
32
For 2017-18 ELPAC performance data in RAD dashboards.
33
For 2017-18 ELPAC reclassification criteria data in RAD 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 2018James.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 2018Veronica.Chew@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
 
 
Main menu