Fields or values marked with an asterisk (*) denote new questions/options for the fall 2012 data collection.
Columns marked with two asterisks (**) indicate the field is required for evaluating whether the device meets readiness requirements.
| Column # | Field Name | Description | Rules |
|---|---|---|---|
| 1 | Local Organization Code | The school code used to uniquely identify this organization. | Use the 14 character County-District-School (CDS) code. |
| 2 | State Code | State Abbreviation | CA |
| 3 ** | Est Internet Bandwidth | Estimated Internet Bandwidth | |
10 = 10 Mbps - Ethernet |
|||
| 4 ** | Est Internal Network Bandwidth | Estimated Internal Network Bandwidth | 10 = 10 Mbps - Ethernet 100 = 100 Mbps - Fast Ethernet 1000 = 1 Gbps - Gigabit Ethernet 10000 = 10 Gbps - 10 Gigabit Ethernet 11 = 11 Mbps - Wireless 802.11b 54 = 54 Mbps - Wireless 802.11g 600 = 600 Mbps - Wireless 802.11n 999999 = > 10 Gbps |
| 5 ** | Est Internet Network Bandwidth Utilization | Percentage of Network Utilization during Online Testing activities | value between 1 and 100 |
| 6 ** | Est Internal Network Bandwidth Utilization | Percentage of Internal Network Utilization during Online Testing activities | value between 1 and 100 |
| 7 | Wireless Access Points Count | Number of Wireless Access points for the organization | |
| 8 ** | Max Number of Simultaneous Test Takers | Maximum Number of Student Test Takers that will be doing online testing at the same time. | |
| 9 | Est Test Taker Count for 2014-2015 | Estimated Student Test Takers count for the 2014-2015 Academic year | This field is no longer used as of the Fall 2012 collection. |
| 10 ** | Length of Testing Window in Days | Length of Testing Window (in School Days) | For Smarter Balanced summative assessments, the testing window can be as long as 12 weeks. |
| 11 ** | Number of Sessions per Day | Number of Testing Sessions per day in which Student Test Takers will test | Valid values are 0-9. Do not submit information for this field for the Spring 2012 data collection. |
| 12 | School Device Data Entry Complete | Indicates that the school has completed entering their data | false = No true = Yes |
| 13 | Staff / Personnel Survey Question 1 |
Staff / Personnel Issues & Roadblocks Survey
1. Having a sufficient number of test administrators to support online testing. |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 14 | Staff / Personnel Survey Question 2 |
Staff / Personnel Issues & Roadblocks Survey
2. Test administrators having sufficient technical understanding to support online testing. |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 15 | Staff / Personnel Survey Question 3 |
Staff / Personnel Issues & Roadblocks Survey
3. Providing all appropriate training needed for test administrators. |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 16 | Staff / Personnel Survey Question 4 |
Staff / Personnel Issues & Roadblocks Survey
4. Having a sufficient number of technology support staff to support online testing. |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 17 | Staff / Personnel Survey Question 5 |
Staff / Personnel Issues & Roadblocks Survey
5. Technology support staff having sufficient technical understanding to support online testing |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 18 | Staff / Personnel Survey Question 6 |
Staff / Personnel Issues & Roadblocks Survey
6. Providing all appropriate training needed for technology support staff. |
0 = 0 - Not a Concern 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 - Neutral 6 = 6 7 = 7 8 = 8 9 = 9 10 = 10 - Extreme Concern 98 = Not Applicable 99 = Don't Know |
| 19 ** | Grade K Enrollment Count * | ||
| 20 ** | Grade 1 Enrollment Count * | ||
| 21 ** | Grade 2 Enrollment Count * | ||
| 22 ** | Grade 3 Enrollment Count * | ||
| 23 ** | Grade 4 Enrollment Count * | ||
| 24 ** | Grade 5 Enrollment Count * | ||
| 25 ** | Grade 6 Enrollment Count * | ||
| 26 ** | Grade 7 Enrollment Count * | ||
| 27 ** | Grade 8 Enrollment Count * | ||
| 28 ** | Grade 9 Enrollment Count * | ||
| 29 ** | Grade 10 Enrollment Count * | ||
| 30 ** | Grade 11 Enrollment Count * | ||
| 31 ** | Grade 12 Enrollment Count * | ||
| 32 | School Classification * | Type of school | public = Public School private = Private School charter = Charter School other = Other Testing Location |
Notes:
- This file contains data for individuals schools. If a user attempts to upload data for an organization that is not a school, that record will fail the loading process and an error will be generated.
- File must be comma delimited and must include the header row.
- File must be a text file type (i.e., .txt, .csv). File cannot be an Microsoft Excel file type (i.e., .xls, .xlsx).
- If a record containing Organization Code and State Code is found that matches one already in the system, the Survey data provided in the file will replace all Survey data that may already exist for that organization.
Please note: Once a matching organization record is found, all Survey data will be deleted first and then records will be inserted into the database as they pass validations. - Export file will be in the same format as the import file including all data elements.
