Complete API data for SFUSD, '99-'05
The data was taken from the full DBF format files found on the CA Department of Education site, on the Academic Performance Index (API) - Data Files page. The data found on this site spans all schools in California. I first cut it down to just the San Francisco schools. Then I compiled the growth and base API data into separate Excel spreadsheets, sorted by school type and school name:
- sfusd-api-growth-00-05.xls (0.83MB)
- sfusd-api-base-99-04.xls (0.93MB)
For a complete description of the data, consult the record layout and flag definitions links on the API Data Files page. The data collected changes from year to year, so it is not possible to give a single, simple summary description here.
I will continue to distill the data down to more manageable formats, but I thought some of you would be interested in all the grisly details. Note that each file breaks down the API data by school, by ethnicity, and they include all the data used to compute the SCI or School Characteristic Index that is used to compare schools in the Similar Rank statistic. If all you want to examine are the School Rank and Similar Schools data, you will want to download the API Base file.
More on this later. This is just the rush copy for those who really want to fire up Excel and do some number crunching.

0 Comments:
Post a Comment
<< Home