Technology Information Center for Administrative Leadership


Using Microsoft Excel to Collect and Analyze California Standards Test Data

Free tools to help you utilize free data!

By Michael Nunn
Consultant, California Technology Assistance Project
Los Angeles County Office of Education


California Standardized Testing and Reporting (STAR) Results are freely available on-line. Michael Nunn has created a set of Microsoft Excel® templates to make it easier for educators to collect and analyze this data.


In this narrated presentation created especially for TICAL, Michael walks you through the process for moving the data from the CDE website into one of the templates he has prepared.


We suggest you view the presentation once as an overview. Then, print a copy to use as reference as you actually move through the steps.


Technical note: To view these presentations, you'll need an Internet connection and Adobe Flash Player. If needed, the Adobe Flash player may be downloaded for free from Adobe. If you experience difficulties viewing any of the presentations, please contact us with the specifics of the issue.