Spanish Reading/Language Arts California Spanish Assessment (CSA)

View Test Results

Search Results

Understanding Results

Research Files

2021–22 Fixed-Length* Research Files Record Definitions

The Fixed-Length* Research Files Record Definitions page provides the following information:

Type Legend – data format of individual data fields
Entities File Layout – layout of entity file data fields
Research File Layout – layout of research file data fields
Table A — Student Groups
Table B — Grades
Table C — Test IDs and Names

Report Options

Select Year

Type Legend

Type	Description
T	Alphabetic text (letters only)
A	Alphanumeric text (letters and numbers allowed)
N	Number (numbers only)
SA	Alphanumeric with left-filled spaces
AS	Alphanumeric with right-filled spaces
ZA	Alphanumeric with left-filled zeroes
AZ	Alphanumeric with right-filled zeroes
ZN	Numeric with left-filled zeroes
NZ	Numeric with right-filled zeroes
SN	Numeric with left-filled spaces
NS	Numeric with right-filled spaces
4Y	4-digit year

Entities File Layout

Field #	Data Element	Type Legend	Length	Start Position	End Position	Column Header for Caret Delimited (CSV) Research file
1	County Code	ZN	2	1	2	County Code
2	District Code	ZN	5	3	7	District Code
3	School Code	ZN	7	8	14	School Code
4	Filler	AS	4	15	18	Filler
5	Test Year	4Y	4	19	22	Test Year
6	Type ID (04 = State 05 = County 06 = District 07 = School 09 = Direct Funded Charter School 10 = Locally Funded Charter School)	ZN	2	23	24	Type ID
7	County Name	AS	50	25	74	County Name
8	District Name	AS	50	75	124	District Name
9	School Name	AS	50	125	174	School Name
10	Zip Code	AS	5	175	179	Zip Code

The entity file created is comprised of state, all tested counties, districts, and schools in California

Field #	Data Element	Type Legend	Length	Start Position	End Position	Column Header for Caret Delimited (CSV) Research file
1	County Code	ZN	2	2	1	County Code
2	District Code	ZN	7	5	3	District Code
3	District Name	AS	40	8	47	District Name
4	School Code	ZN	7	48	54	School Code
5	School Name	AS	60	55	114	School Name
6	Type ID (04 = State 05 = County 06 = District 07 = School 09 = Direct Funded Charter School 10 = Locally Funded Charter School)	ZN	2	115	116	Type ID
7	Filler	AS	4	117	120	Filler
8	Test Year	4Y	4	121	124	Test Year
9	Test Type(California Spanish Assessment = R)	AS	1	125	125	Test Type
10	Test ID(California Spanish Assessment = 39)	ZN	2	126	127	Test ID
11	Student Group ID(Detailed listing provided below – Table A)	ZN	3	128	130	Student Group ID
12	Grade(Detailed listing provided below – Table B)	ZN	2	131	132	Grade
13	Total Students Enrolled	SA	9	133	141	Total Students Enrolled
14	Total Students Tested	SA	9	142	150	Total Students Tested
15	Total Students Tested with Scores	SA	9	151	159	Total Students Tested with Scores
16	Mean Scale Score	SA	6	160	165	Mean Scale Score
17	Percent Range 3	SA	6	166	171	Percent Range 3
18	Count Range 3	SA	9	172	180	Count Range 3
19	Percent Range 2	SA	6	181	186	Percent Range 2
20	Count Range 2	SA	9	187	195	Count Range 2
21	Percent Range 1	SA	6	196	201	Percent Range 1
22	Count Range 1	SA	9	202	210	Count Range 1
23	Overall Total	SA	9	211	219	Overall Total

Research File Layout

Field #	Data Element	Type Legend	Length	Start Position	End Position	Column Header for Caret Delimited (CSV) Research file
1	County Code	ZA	2	1	2	County Code
2	District Code	ZA	5	3	7	District Code
3	School Code	ZA	7	8	14	School Code
4	Filler	ZA	4	15	18	Filler
5	Test Year	4Y	4	19	22	Test Year
6	Student Group ID(Detailed listing provided below – Table A)	ZN	3	23	25	Student Group ID
7	Test Type(California Spanish Assessment = R)	A	1	26	26	Test Type
8	Total Tested at Reporting Level	SN	7	27	33	Total Tested at Reporting Level
9	Total Tested with Scores at Reporting Level	SN	7	34	40	Total Tested with Scores at Reporting Level
10	Grade(Detailed listing provided below – Table B)	ZN	2	41	42	Grade
11	Test ID(California Spanish Assessment = 39)	ZN	2	43	44	Test ID
12	Students Enrolled	SN	7	45	51	Students Enrolled
13	Students Tested	SN	7	52	58	Students Tested
14	Mean Scale Score	SN	6	59	64	Mean Scale Score
15	Percent Range 3	SN	6	65	70	Percent Range 3
16	Percent Range 2	SN	6	71	76	Percent Range 2
17	Percent Range 1	SN	6	77	82	Percent Range 1
18	Students with Scores	SN	7	83	89	Students with Scores
19	Type ID (04 = State 05 = County 06 = District 07 = School 09 = Direct Funded Charter School 10 = Locally Funded Charter School)	ZN	2	90	91	Type ID

Table A — Student Groups

Student Group	Student Group Name	Student Group ID
All Students	All Students	001
Disability Status	Reported disabilities	128
Disability Status	No reported disabilities	099
Economic Status	Socioeconomically disadvantaged	031
Economic Status	Not socioeconomically disadvantaged	111
English-Language Fluency	IFEP, RFEP, and EO (Fluent English proficient and English only)	006
English-Language Fluency	IFEP (Initial fluent English proficient)	007
English-Language Fluency	RFEP (Reclassified fluent English proficient)	008
English-Language Fluency	ELs enrolled less than 12 months	120
English-Language Fluency	ELs enrolled 12 months or more	142
English-Language Fluency	EL (English learner)	160
English-Language Fluency	ADEL (Adult English learner)	243
English-Language Fluency	EO (English only)	180
English-Language Fluency	Ever–EL	170
English-Language Fluency	LTEL (Long-Term English learner)	250
English-Language Fluency	AR–LTEL (At-Risk of becoming LTEL)	251
English-Language Fluency	Never–EL	252
English-Language Fluency	TBD (To be determined)	190
Race and Ethnicity	American Indian or Alaska Native	075
Race and Ethnicity	Asian	076
Race and Ethnicity	Black or African American	074
Race and Ethnicity	Filipino	077
Race and Ethnicity	Hispanic or Latino	078
Race and Ethnicity	Native Hawaiian or Pacific Islander	079
Race and Ethnicity	White	080
Race and Ethnicity	Two or more races	144
Ethnicity for Economically Disadvantaged	American Indian or Alaska Native	201
Ethnicity for Economically Disadvantaged	Asian	202
Ethnicity for Economically Disadvantaged	Black or African American	200
Ethnicity for Economically Disadvantaged	Filipino	203
Ethnicity for Economically Disadvantaged	Hispanic or Latino	204
Ethnicity for Economically Disadvantaged	Native Hawaiian or Pacific Islander	205
Ethnicity for Economically Disadvantaged	White	206
Ethnicity for Economically Disadvantaged	Two or more races	207
Ethnicity for Not Economically Disadvantaged	American Indian or Alaska Native	221
Ethnicity for Not Economically Disadvantaged	Asian	222
Ethnicity for Not Economically Disadvantaged	Black or African American	220
Ethnicity for Not Economically Disadvantaged	Filipino	223
Ethnicity for Not Economically Disadvantaged	Hispanic or Latino	224
Ethnicity for Not Economically Disadvantaged	Native Hawaiian or Pacific Islander	225
Ethnicity for Not Economically Disadvantaged	White	226
Ethnicity for Not Economically Disadvantaged	Two or more races	227
Gender	Female	004
Gender	Male	003
Migrant	Migrant education	028
Migrant	Not migrant education	029
Parent Education	Not a high school graduate	090
Parent Education	High school graduate	091
Parent Education	Some college (includes AA degree)	092
Parent Education	College graduate	093
Parent Education	Graduate school/Postgraduate	094
Parent Education	Declined to state	121
Military Status	Armed forces family member	050
Military Status	Not armed forces family member	051
Homeless Status	Homeless	052
Homeless Status	Not homeless	053
Foster Status	Foster youth	240
Foster Status	Not foster youth	241

Table B — Grades

Grade	Description
03	Grade 3
04	Grade 4
05	Grade 5
06	Grade 6
07	Grade 7
08	Grade 8
09	Grade 9
10	Grade 10
11	Grade 11
12	Grade 12
14	All High School (Grades 9–12)
13	All Grades (Grades 3–12)

Table C — Test IDs and Names

Test ID	Test Name
39	CSA - Spanish Reading/Language Arts

* - Some filler fields are omitted from the .CSV versions of these files.