Upload Multiple Student File Layout – TerraNova Checklist before submitting
File must contain a header row that includes all the columns in the file layout. Must remove the max length row File must contain the data in the order listed in the file layout. Fields cannot be longer than the value in the Maximum Length column. All Customers, excluding CSP, will fill out the green Race/Ethnicity fields only (optional) CSP Customers will fill out the yellow Ethnicity fields only (optional)
File must be in comma separated (.csv) format. To save Excel file as type .csv: o Save file updates/changes within Excel. o Open file in Excel, if file not already open. o On the Windows menu bar, click File, then Save As… o The Save As dialog box will appear. The line at the bottom of this box reads Save as type: Click on the down arrow to the right of this line to open a drop down menu. Scroll down the menu until CSV (Comma delimited) is visible. Click on CSV (Comma delimited) [*.csv] to select for the Save as type: Click on Save on the right.
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values
1
A
Mode
6
Y
2
B
District Name
13
Y
3 4
C D
District Code State
10 2
Y N
5
E
School Name
15
Y
6
F
School Code
10
Y
7
G
Grade
2
Y
8
H
Teacher
15
Y
‘PAPER’ The District Name must match the district Name displayed in the DRC INSIGHT Portal District dropdown. The District Code must match the district code displayed in the DRC INSIGHT Portal District dropdown. The School Name must match the school name displayed in the DRC INSIGHT Portal District dropdown. The School Code must match the school code displayed in the DRC INSIGHT Portal District dropdown. KG, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 A-Z, spaces If no Teacher Name applies, use ‘NONAME’ A-Z, spaces DRC will: Convert hyphens, apostrophes, periods, parenthesis, and other non-alpha numeric values to spaces Convert lower case alpha values [a-z] to upper case alpha values [A-Z] Convert diacritical values to their alpha character equivalent o Examples: Ã = a, ñ = n, ë or é = e, Ô = o, and Í = I
9
I
Last Name
20
Y
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values A-Z DRC will: Convert hyphens, apostrophes, periods, parenthesis, and other non-alpha numeric values to spaces Convert lower case alpha values [a-z] to upper case alpha values [A-Z] Convert diacritical values to their alpha character equivalent o Examples: Ã = a, ñ = n, ë or é = e, Ô = o, and Í = I
10
J
First Name
15
Y A-Z DRC will: Convert hyphens, apostrophes, periods, parenthesis, and other non-alpha numeric values to spaces Convert lower case alpha values [a-z] to upper case alpha values [A-Z] Convert diacritical values to their alpha character equivalent o Examples: Ã = a, ñ = n, ë or é = e, Ô = o, and Í = I
11
K
Mid Initial
1
N MMDDYYYY
12 13
L M
Birth Date Gender
8 1
Y Y
Must have leading zeros for birthdates such as January 3rd, 2017 would be formatted the following: 01032017 ‘M’ or ‘F’ A-Z, 0-9, or blank Data will be converted to blank if invalid values are received. For CSP Users: Student ID should be 6 digits if they use this field
14
N
Student ID
10
N 0-9 or blank For CSP Users: 1 = Gifted & Talented
15
O
K
1
N
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values 0-9 or blank For CSP Users: 1 = 1 or less years in Christian School 1 = 2 years in Christian Schools 3 = 3 years in Christian Schools 4 = 4 years in Christian Schools 5 = 5 years in Christian Schools 6 = 6 years in Christian Schools 7 = 7 years in Christian Schools 8 = 8 years in Christian Schools 9 = 9 or more years in Christian Schools
16
P
L
1
N
*May be left blank 0-9 or blank For CSP Users:
17 18
Q R
M N
1 1
N N
This field is used for other groups Allowed values: 1-3 or blank 1 = Home School 2 = International 3 = Other 0-9 or blank
19
S
O
1
N
0-9 or blank
20
T
P
1
N
0-9 or blank Y=Yes, Blank=No Fill in this if a student has an Individualized Education Program
21
U
IEP
1
N Y=Yes, Blank=No
22
V
504
1
N
Fill in this if a student has a Section 504 Plan Y=Yes, Blank=No Fill in this if a student is classified as having Limited English Proficiency (LEP) or as an English Language Learner (ELL) or similar classification
23
W
LEP/ELL
1
N
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Must be one of the below Numbers: Test Type/Number
24
X
Test ID
3
Y
TerraNova CSP
91
TerraNova CSP with InView
92
TerraNova Common Core
93
TerraNova Common Core Plus
94
TerraNova Common Core with InView
95
TerraNova Common Core Plus with InView
96
TerraNova 3rd Edition Complete Battery
97
TerraNova 3rd Edition Complete Battery Plus
98
TerraNova 3rd Edition Complete Battery InView
99
TerraNova 3rd Edition Complete Battery Plus with InView
100
TerraNova 3rd Edition Survey
101
TerraNova 3rd Edition Survey Plus
102
TerraNova 3rd Edition Survey with InView
103
TerraNova 3rd Edition Survey Plus with InView
104
TerraNova 3rd Edition Multiple Assessments
105
TerraNova 3rd Edition Multiple Assessments with InView
106
TerraNova 3rd Edition Multiple Assessments Plus
107
TerraNova 3rd Edition Multiple Assessments Plus with InView
108
SUPERA Survey
111
SUPERA Multiple Assessments
113
InView Standalone
112
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Must be one of the below Test forms – dependent on Test ID:
25
Y
Test Form
2
Y
Test Form
Test ID
Test Type
G
91
TerraNova CSP
G
92
TerraNova CSP with InView
C1 or C2
93
TerraNova Common Core
C1 or C2
94
TerraNova Common Core Plus
C1 or C2
95
TerraNova Common Core with InView
C1 or C2
96
TerraNova Common Core Plus with InView
G or GL
97
TerraNova 3rd Edition Complete Battery
G or GL
98
TerraNova 3rd Edition Complete Battery Plus
G or GL
99
TerraNova 3rd Edition Complete Battery InView
G or GL
100
TerraNova 3rd Edition Complete Battery Plus with InView
G
101
TerraNova 3rd Edition Survey
G
102
TerraNova 3rd Edition Survey Plus
G
103
TerraNova 3rd Edition Survey with InView
G
104
TerraNova 3rd Edition Survey Plus with InView
G
105
TerraNova 3rd Edition Multiple Assessments
G
106
TerraNova 3rd Edition Multiple Assessments with InView
G
107
TerraNova 3rd Edition Multiple Assessments Plus
G
108
TerraNova 3rd Edition Multiple Assessments Plus with InView
A
111
SUPERA Survey
A
113
SUPERA Multiple Assessments
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Must be one of the below levels – dependent on Test ID: Level
Test ID
Test Type
10-21
91
TerraNova CSP
10-21
92
TerraNova CSP with InView
13-18
93
TerraNova Common Core
13-18
94
13-18
95
13-18
96
G = 10-21 GL = 10-12 G = 10-21 GL = 10-12 G = 10-21 GL = 10-12
26
Z
Level
2
97 98 99
TerraNova Common Core Plus TerraNova Common Core with InView TerraNova Common Core Plus with InView TerraNova 3rd Edition Complete Battery TerraNova 3rd Edition Complete Battery Plus TerraNova 3rd Edition Complete Battery InView TerraNova 3rd Edition Complete Battery Plus with InView TerraNova 3rd Edition Survey TerraNova 3rd Edition Survey Plus TerraNova 3rd Edition Survey with InView TerraNova 3rd Edition Survey Plus with InView TerraNova 3rd Edition Multiple Assessments TerraNova 3rd Edition Multiple Assessments with InView TerraNova 3rd Edition Multiple Assessments Plus TerraNova 3rd Edition Multiple Assessments Plus with InView
G = 10-21 GL = 10-12
100
10-21
101
10-21
102
10-21
103
10-21
104
10-21
105
10-21
106
10-21
107
10-21
108
10-19
111
SUPERA Survey
11-19
113
SUPERA Multiple Assessments
Y Level 1-6
27
AA
InView Level
AB
Race – American Indian or Alaska Native
1
N
Required if InView is selected Y=Yes, Blank=No
28
Multiple Fields from Ref # 27 – 31 can be filled 1
N
This field is for all Customers, excluding CSP
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Y=Yes, Blank=No Multiple Fields from Ref # 27 – 31 can be filled
29
AC
Race – Asian
1
N
This field is for all Customers, excluding CSP Y=Yes, Blank=No
30
AD
Race – Black or African American
AE
Race – Native Hawaiian or other Pacific Islander
Multiple Fields from Ref # 27 – 31 can be filled 1
N
This field is for all Customers, excluding CSP Y=Yes, Blank=No
31
Multiple Fields from Ref # 27 – 31 can be filled 1
N
This field is for all Customers, excluding CSP Y=Yes, Blank=No Multiple Fields from Ref # 27 – 31 can be filled
32
AF
Race – White
1
N
This field is for all Customers, excluding CSP 0 = Ethnicity – Hispanic/Latino 1 = Ethnicity – Not Hispanic/Latino
33
AG
Ethnicity
1
N
This field is for all Customers, excluding CSP Valid values are 1-8 or blank 1 = Ethnicity – American Indian or Alaska Native 2 = Ethnicity – African American or Black, Not Hispanic 3 = Ethnicity – Asian 4 = Ethnicity – Pacific Islander 5 = Ethnicity – Hispanic or Latino 6 = Ethnicity – White, Not Hispanic 7 = Ethnicity – Multiethnic 8 = Ethnicity – Other
34
AH
35
AI
CSP - Ethnicity CSP - Test Administration Year
1
N
This field is for CSP Customers only
4
N
4-digit valid year in the format of YYYY
Upload Multiple Student File Layout – TerraNova Valid Values: 01-99, blank If populated, must be one of the below values: Home Language Values 01 = Albanian
41 = Khmer (Cambodian)
02 = Amharic
42 = Khmu
03 = Arabic
43 = Korean
04 = Armenian
44 = Kurdish
05 = Assyrian
46 = Lahu
07 = Bengali
47 = Lao
08 = Bosnian
49 = Mai Mai
09 = Burmese
50 = Mandarin (Putonghua)
11 = Cantonese
51 = Marhsallese
12 = Cebuano
52 = Mien (Yao)
(Visayan) 13 = Chaldean
53 = Mixteco
14 = Chamorro
59 = Pashto
(Guamanian) 15 = Chaozhou
60 = Polish
(Chaochow) 16 = Croatian
61 = Portuguese
18 = Dutch
62 = Punjabi
21 = Farsi (Persian)
65 = Rumanian
20 = English
66 = Russian
22 = Filipino (Pilipino
68 = Samoan
or Tagalog) 23 = French
69 = Serbo-Croatian (Serbian)
36
AJ
Home Language
2
N
24 = French Creole
70 = Somali
26 = German
71 = Spanish
27 = Greek
73 = Taiwanese
28 = Gujarati
74 = Thai
30 = Hebrew
75 = Tigrinya
31 = Hindi
76 = Toishanese
32 = Hmong
77 = Tongan
33 = Hungarian
78 = Turkish
35 = Ilocano
80 = Ukrainian
36 = Indonesian
81 = Urdu
37 = Italian
83 = Vietnamese
39 = Japanese
99 = All Other Non-English Languages
Upload Multiple Student File Layout – TerraNova
Ref Column # Position Name 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB
Acc R1 Acc R2 Acc R3 Acc L1 Acc L2 Acc L3 Acc MA1 Acc MA2 Acc MA3 Acc SC1 Acc SC2 Acc SC3 Acc SS1 Acc SS2 Acc SS3 Acc Inv1 Acc Inv2 Acc Inv3
Maximum Required Length (Y/N) Description / Values 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
N N N N N N N N N N N N N N N N N N
If a tester has any accommodations: Y=Yes, Blank=No IMPORTANT: If more than one category of accommodations is used for a content area, fill in the highest category used. (Category 3 is the highest.)