CAASPP Test Results

California Assessment of Student Performance and Progress

cde.ca.gov-caaspp-2015e-2

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

This dataset is a simple combination of multiple years of California Assessment of Student Performance and Progress (CAASPP) results, for the years 2015 on. The CAASPP was conducted in 2014, but the 2014 file has a different structure from other years ( it’s a “pp” file, see below) so it is excluded from this package.

Download Structure

The Base Download documentation link points to an FTP-like web directory of files, which contain the downloadable files. The other download pages have links to the files in these directories. These directories, as well as the dataset webpages are a bit complex. There seems to be a few different sorts of test result files, but there isn’t a clear distinction between them. These fiels include:

  • “Paper Based” results , for 2014 and 2015
  • Tests in Spanish, marked “STS” for 2016 and 2017
  • Files with code ‘pp’. Some ‘pp’ files have additional codes ‘p2’ or ‘p3’
  • Files with ‘sb’, often also with ‘p2’ or ‘p3’

I think ‘sb’ means ‘Smarter-Balanced’.

The main page for accessing test results, https://caaspp.cde.ca.gov/, has an inconsistent set of links to result pages for each year. For some years, the links are to “STS” results, others are to “Paper-Based” and for 2018, the links are to the “STS” and “Smarter Balanced” results.

Versions

  1. Initial version
  2. total_tested_with_scores datatype changed from ‘unknown’ to ‘integer’ with ‘robust_int’ transform

Contacts

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-caaspp-2015e-2.zip')

# Create Dataframes

subgroup_ids_df = pkg.resource('subgroup_ids').dataframe()
test_ids_df = pkg.resource('test_ids').dataframe()
subgroups_df = pkg.resource('subgroups').dataframe()
entities_df = pkg.resource('entities').dataframe()

Data Dictionary

subgroups | entities | subgroup_ids | tests | test_ids

subgroups

Column NameData TypeDescription
yearintegerSource File Year
county_codeintegerCounty Code
district_codeintegerDistrict Code
school_codeintegerSchool Code
fillerstringFiller
test_yearintegerTest Year
subgroup_idintegerSubgroup ID
test_typestringTest Type
total_caaspp_enrollmentintegerTotal CAASPP Enrollment
total_tested_at_entity_levelintegerTotal Tested At Entity Level
total_tested_with_scoresintegerTotal Tested with Scores
total_tested_at_subgroup_levelintegerTotal Tested at Subgroup Level
gradeintegerGrade
test_idintegerTest Id
caaspp_reported_enrollmentintegerCAASPP Reported Enrollment
students_testedintegerStudents Tested
mean_scale_scorestringMean Scale Score
percentage_standard_exceededstringPercentage Standard Exceeded
percentage_standard_metstringPercentage Standard Met
percentage_standard_met_and_abovestringPercentage Standard Met and Above
percentage_standard_nearly_metstringPercentage Standard Nearly Met
percentage_standard_not_metstringPercentage Standard Not Met
students_with_scoresintegerStudents with Scores
area_1_percentage_above_standardfloatArea 1 Percentage Above Standard
area_1_percentage_near_standardfloatArea 1 Percentage Near Standard
area_1_percentage_below_standardfloatArea 1 Percentage Below Standard
area_1_percentage_at_or_near_standardfloatArea 1 Percentage At or Near Standard
area_2_percentage_above_standardfloatArea 2 Percentage Above Standard
area_2_percentage_near_standardfloatArea 2 Percentage Near Standard
area_2_percentage_below_standardfloatArea 2 Percentage Below Standard
area_2_percentage_at_or_near_standardfloatArea 2 Percentage At or Near Standard
area_3_percentage_above_standardfloatArea 3 Percentage Above Standard
area_3_percentage_near_standardfloatArea 3 Percentage Near Standard
area_3_percentage_at_or_near_standardfloatArea 3 Percentage At or Near Standard
area_3_percentage_below_standardfloatArea 3 Percentage Below Standard
area_4_percentage_above_standardfloatArea 4 Percentage Above Standard
area_4_percentage_near_standardfloatArea 4 Percentage Near Standard
area_4_percentage_at_or_near_standardfloatArea 4 Percentage At or Near Standard
area_4_percentage_below_standardfloatArea 4 Percentage Below Standard

entities

Column NameData TypeDescription
yearintegerSource File Year
county_codeintegerCounty Code
district_codeintegerDistrict Code
school_codeintegerSchool Code
fillerstringFiller
test_yearintegerTest Year
type_idintegerType Id
county_namestringCounty Name
district_namestringDistrict Name
school_namestringSchool Name
zip_codestringZip Code

subgroup_ids

Column NameData TypeDescription
codeinteger
labelstring
groupstring

tests

Column NameData TypeDescription
test_idinteger
test_numinteger
test_namestring

test_ids

Column NameData TypeDescription
test_idinteger
test_numinteger
test_namestring

References

Urls used in the creation of this data package.

Last Modified 2019-08-09T12:22:03

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-caaspp-2015e-2.zip')

# Create Dataframes

subgroup_ids_df = pkg.resource('subgroup_ids').dataframe()
test_ids_df = pkg.resource('test_ids').dataframe()
subgroups_df = pkg.resource('subgroups').dataframe()
entities_df = pkg.resource('entities').dataframe()