TICAL - Technology Information Center for Administrative Leadership

Quick Fact:

Only 1 in 6 users of internet search engines can tell the difference between unbiased search results and paid advertisements.
Source:Pew Internet and American Life Project, 2005

Quote:

We can't solve problems by using the same kind of thinking we used when we created them.
-- Albert Einstein

TICAL is a statewide educational technology service provided by Santa Cruz County Office of Education with funding from the Calfornia Department of Education.

Website problems?
Email the webmaster

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. Michael's templates are available from CTAP Region 11 at Los Angeles County Office of Education.

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 the presentation, you'll need a 56K or faster Internet connection and Adobe Flash Player Version 4 or higher, which is pre-installed in most Web browsers and on most computers. If needed, the player may be downloaded for free from Adobe. If you experience difficulties viewing any of the presentations, please click here and send us a message with particulars.

Presentation (9 minutes) Updated April 2008
Printable version (pdf)
E-mail Michael Nunn
Direct link to the templates

Disclaimer - TICAL has listed private consultants and vendors on this web site as resources for educational administrators. By including these private consultants and vendors, TICAL makes no endorsement of them or the services or products they offer. Nor, by this listing, is TICAL making any statement about other private consultants and vendors that are not listed. Any person, organization, or entity choosing to use one of the private consultants and vendors listed on this site, should exercise due diligence prior to entering into a contract. This web site may from time to time be linked to third party web sites. Such links do not constitute an endorsement of such third party web sites, nor is TICAL responsible for any viruses, content, or disputes resulting from access to such third party sites.

Today's date and time: May 17, 2008, 6:49 am PDT
Copyright 2001 - 2008 Santa Cruz County Office of Education