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 - 2019-20 School Start-Up Edition
Release date: August 5, 2019
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 school's CSDR is available via RAD Data RequestsMulti-school CSDRs are available to Network and 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: 2019-20 School Start-Up will be available upon request, on 8/5/2019.
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/1/2019
Kevin.Schmidke@ousd.org
13
Prior Year EnrollmentSchool and Advisor/Teacher at end of 2018-19Current as of 6/23/2019James.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/1/2019
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/1/2019
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 6/23/2019
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/1/2019
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/1/2019
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 2018-19Kevin.Smith@ousd.org
22
SuspensionYear-to-date (through end-of-marking-period):
# Suspensions, and # Days Suspended.
Out-of-School SuspensionsCoverage through EOY 2018-19James.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 2018-19Kaia.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 6/23/2019
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 2018-19Kevin.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 2018-19Rinat.Fried@ousd.org
28
SBAC Interim Block AssessmentsFall 2018, Gr 3-8: 'Reading Literary Texts'
Mid-Year, Gr K-2: selected Math blocks.
Performance Levels:
1-Below Standard, 2-Near Standard, 3-Above Standard

A scaled score and a DFS (Distance from Standard) score are provided.
Coverage through (March) 2019 formative assessmentsJuan.Du@ousd.org
29
Math Curriculum-Embedded
C-EoU Benchmarks
Results from Fall 2018 Grades K-2: Percent-correct and performance levels are provided for Multiple-Choice, Short-Answer, and Performance-Task question groups.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 December 2018James.Tharp@ousd.org
30
SMI - Scholastic Math InventorySMI assessment was adminsistered twice per year since 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 2018-19Kevin.Smith@ousd.org
31
ELPAC SummativeSince 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.

Per CA State Guidance, grades 1 - 12 must score 4 overall to qualify for reclassification. 2018-19 ELPAC scores are preliminary results that were last updated on 2019-07-26.
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
June 2019
Rattana.Yeang@ousd.org
32
For ELPAC performance data in RAD dashboards.
33
SBACELA and Math Achievement Levels, Scale Scores and Distance-From-Standard, 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 Preliminary Scores
from May 2019
James.Tharp@ousd.org
34
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 2019Veronica.Chew@ousd.org
35
For more PFT data, refer to our PFT dashboards.
36
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...