|
Spring 1999 Help Topics
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Date Posted: | April 14, 2000 | ||||||||
| File: | flstar.exe 14.4
MB, Windows self-extracting compressed file |
||||||||
| Minimum Download Times: |
|
||||||||
| Description: | A self-extracting compressed file that contains two Fixed-Length ASCII files named "flentities.asc" and "fltestdata.asc". |
Tab-Delimited Files
Tab-Delimited files can be imported into most databases.
| Date Posted: | April 14, 2000 | ||||||||
| File: | tdstar.exe 12.4
MB, Windows self-extracting compressed file
|
||||||||
| Minimum Download Times: |
|
||||||||
| Description: | A self-extracting compressed file that contains two Tab-Delimited ASCII files named "tdentities.tab" and "tdtestdata.tab". |
Access 97 database
Access is a PC-specific database format from Microsoft. This database is compatible with the Access 97 and Access 2000 versions of the product.
| Date Posted: | April 14, 2000 | ||||||||
| File: | AC97star.exe
40 MB, Windows self-extracting compressed file |
||||||||
| Minimum Download Times: |
|
||||||||
| Description: | A self-extracting compressed file that contains one Access 97 (Access 2000 compatible) database file named "STAR Research File.mdb". |
Zip Files
The Research files for Windows are packaged in a self-extracting archive, to save on space and download time. Self-extracting archives have an extension of .EXE, and can be run as commands or double-clicked on just like any other application. When a self-extracting archive is run, the files in the archive are automatically extracted into the directory of your choice. You do not need an unzip program (like PKZIP or WinZip) to extract files from these self-extracting archives.
Research File Formats: Files 1 and 2
There are two research file formats shown: File 1 - Entities and File 2 - Test Data. File 1 (Entities) is for county, district and school data. File 2 is the test data. The formats are described below.
| Type Legend | |
A |
Alphabetic text (letters only) |
T |
Alphanumeric text (letters and numbers allowed) |
N |
Number (numbers only) |
ZN |
Number with left-filled zeroes |
NZ |
Number with right-filled zeroes |
4Y |
4-digit year |
| Sort Legend | |
A |
Ascending order (A...Z, 0..9) |
D |
Descending order (Z..A, 9..0) |
Output record definition for File 1: Entities
| Starting Column | Length | Type |
Sort |
Data | Corresponding Database field |
| 1 | 2 | ZN |
A |
County Code | CountyCode |
| 3 | 5 | ZN |
A |
District Code | DistrictCode |
| 8 | 7 | ZN |
A |
School Code | SchoolCode |
| 15 | 20 | T |
County Name | CountyName | |
| 35 | 20 | T |
District Name | DistrictName | |
| 55 | 20 | T |
School Name | SchoolName |
Output record definition for File 2: Test Data
| Starting Column | Length | Type |
Sort |
Data | Corresponding Database field |
| 1 | 2 | ZN |
A |
County Code | CountyCode |
| 3 | 5 | ZN |
A |
District Code | DistrictCode |
| 8 | 7 | ZN |
A |
School Code | SchoolCode |
| 15 | 4 | 4Y |
Administration/Cycle - '1999' | Year | |
| 19 | 1 | N |
Record Type ('4'=State, '5'=County, '6'=District, '7'=School) |
TypeID | |
| 20 | 1 | N |
Summary Type ('1'=All Students, '2'=LEP Students, ‘3’ = EP Students, ‘4’ = Female Students, ‘5’ = Male Students, ‘6’ = Economically Disadvantaged Students, ‘7’ = Not Economically Disadvantaged Students) |
ClassificationID | |
| 21 | 2 | ZN |
A |
Grade Level | GradeID |
| 23 | 7 | ZN |
Total Enrollment Reported | TotalEnrollment | |
| 30 | 7 | ZN |
Total Number Tested | TotalTested | |
| 37 | 22 | Results Info (Reading) - (see below) | ReadingTest | ||
| 59 | 22 | Results Info (Math) - (see below) | MathTest | ||
| 81 | 22 | Results Info (Language) - (see below) | LanguageTest | ||
| 103 | 22 | Results Info (Spelling) - (see below) | SpellingTest | ||
| 125 | 22 | Results Info (Science) - (see below) | ScienceTest | ||
| 147 | 22 | Results Info (Social Science) - (see below) | SocialScienceTest | ||
| 169 | 18 | Standards Info (English/Language Arts) - (see below) | ELASTD | ||
| 187 | 18 | Standards Info (Math) - (see below) | MathSTD | ||
| 205 | 15 | Augmented Math Scores (Algebra I) - (see below) | AugMAlgI | ||
| 220 | 15 | Augmented Math Scores (Integrated 1) - (see below) | AugMInt1 | ||
| 235 | 15 | Augmented Math Scores (Geometry) - (see below) | AugMGeom | ||
| 250 | 15 | Augmented Math Scores (Integrated 2) - (see below) | AugMInt2 | ||
| 265 | 15 | Augmented Math Scores (Algebra II) - (see below) | AugMAlgII | ||
| 280 | 15 | Augmented Math Scores (Integrated 3) - (see below) | AugMInt3 |
"Results Info" field definition:
| Starting Column | Length | Type |
Data | Corresponding Database field |
| 1 | 6 | N |
Total Number Valid | NumberTested |
| 7 | 5 | T |
Mean Scaled Score | MeanSS |
| 12 | 2 | T |
PR of Mean NCE | MeanPR |
| 14 | 3 | T |
Percent Scoring Above PR 75 | PAC75 |
| 17 | 3 | T |
Percent Scoring At or Above PR 50 | PACAT50 |
| 20 | 3 | T |
Percent Scoring Above PR 25 | PAC25 |
"Standards Info" field definition:
| Starting Column | Length | Type |
Data | Corresponding Database field |
| 1 | 6 | N |
Reported Enrollment | ReportedEnrollment |
| 7 | 6 | N |
Number Tested | NumberTested |
| 13 | 4 | T |
Average Number Correct | AVGCorrect |
| 17 | 2 | T |
Number Possible | NumberPossible |
"Augmented Math Scores" field definition:
| Starting Column | Length | Type |
Data | Corresponding Database field |
| 1 | 6 | N |
Number Tested | NumberTested |
| 7 | 3 | T |
Percent of Enrollment | PCTEnrollment |
| 10 | 4 | T |
Average Number Correct | AVGCorrect |
| 14 | 2 | T |
Number Possible | NumberPossible |