Data Analysis with Excel

The following files allow users to copy data from the STAR website and quickly view tables and graphs.

These files are for use on both Mac and PC. It is recommended that you only downlod the files you need. Look at the grade level in the file name to select the appropriate file. The files are currently updated to work with STAR California Standards Test data for 2009, 2008, and 2007.

Click here for previous year's spreadsheets covering 2008, 2007, and 2006 STAR CST data.

  • PC-Recommended Browser: Internet Explorer

  • Mac-Recommended Browser: Safari

* Use of other browsers may produce unexpected results. Firefox is currently "not" recommended.

Downloads

Step by Step Guide

K-5 Spreadsheet

K-6 Spreadsheet

K-8 Spreadsheet

6-8 Spreadsheet

7-8 Spreadsheet

7-12 Spreadsheet

9-12 Spreadsheet

K-12 Spreadsheet (School Site Level)

Links

STAR Website

Overview presentation: Using Microsoft Excel to Collect and Analyze California Standards Test Data

TICAL - Using Microsoft Excel to Collect and Analyze California Standards Test Data

CTAP -  Using Microsoft Excel to Collect and Analyze California Standards Test Data