Additional Download Information

Three Download Formats:

• Excel (.xls) - New for 2011. The download file will open automatically in Excel, both in older versions as well as in the latest. Note that in Excel 2007 a warning message may appear. Simply click "yes" to open file. Downloading the district and campus aggregates for the whole state using the Excel format will take extra time due to the large file size.
• Comma Delimited (.dat)
• Tab Delimited (.dat)

Data Elements:

Most data elements are grouped logically. For example, when selecting "Grade 3, Mathematics, 2010," a group of 14 variables will be included in the downloaded data. The data element or variable name is on the first row of the downloaded file.

ID number for District or Campus:

All district and campus downloads have as the first column the ID number. This number must be treated as text because some applications will delete leading zeroes. For this reason, the Excel download (.xls) includes a single quote: ' in front of the ID number. This informs the application that the number should be treated as text. Note that if the ' is deleted, Excel will not show the leading zeroes.

The comma-delimited and tab-delimited (.dat) downloads do not include the single quote in front of the ID number.

Column Names and Description:

Go to the Master Reference for Data Elements Used in AEIS for a detailed description of the downloaded elements. The AEIS Data Dictionary provides a mock up of the report with each cell labeled according to the download.

 

Explanation of Masking | 2009-10 AEIS | Performance Reporting