Upload Multiple Student File Layout
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted 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 Length
Required (Y/N) Description / Values
1
A
Mode
6
Y
2
B
District Name
13
Y
3
C
District Code
10
Y
4
D
State
2
N
5
E
School Name
NA
Y
6
F
School Code
10
Y
‘PAPER’ for CSP Users The District Name must match the district Name displayed in the DRC INSIGHT Portal District dropdown: CALIFORNIA, CSI, FLORIDA, INTERNATIONAL, MID AMERICA, NAUMS, NCSA, NORTHEAST, NORTHWEST, OHIO RIVER VALLEY, ROCKY MOUNTAIN, SOUTH CENTRAL, SOUTHEAST The District Code must match the district code displayed in the DRC INSIGHT Portal District dropdown. CSP01, CSP02, CSP03, CSP04, CSP05, CSP06, CSP07, CSP08, CSP09, CSP10, CSP11, CSP12, CSP13 For CSP users the District will be 5 digits (ex. CSP02) The School Name must match the school name displayed in the DRC INSIGHT Portal District dropdown. Enter the complete School Name exactly as seen in the portal. If the name is longer than 15 characters, it will be truncated automatically during the upload. The School Code must match the school code displayed in the DRC INSIGHT Portal District dropdown. For CSP users the School Code will be 7 digits (ex. 0123456)
Page 1 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Length
Required (Y/N) Description / Values
7
G
Grade
2
Y
8
H
Teacher
15
Y
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
9
I
Last Name
20
Y
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 A-Z
10
J
First Name
15
Y
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 A-Z
11
12
K
L
Mid Initial
Birth Date
1
8
N
Y
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 MMDDYYYY Must have leading zeros for birthdates such as January 3rd, 2017 would be formatted the following: 01032017
Page 2 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Length
Required (Y/N) Description / Values
13
1
Y
14
M
N
Gender
Student ID
6
N
‘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 MUST be 6 digits if using this field 0-9 or blank
15
O
K
1
N
For CSP Users: 1 = Gifted & Talented 0-9 or blank For CSP Users: 1 = 1 or less years in Christian School 2 = 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
17
Q
M
1
N
For CSP Users: This field is used for the following: Allowed values: 1-3 or blank 1 = Home School 2 = International 3 = Other
18
R
N
1
N
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
21
U
IEP
1
N
Enter Y if a student has an Individualized Education Program Y=Yes, Blank=No
22
V
504
1
N
Enter Y if a student has a Section 504 Plan
Page 3 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Y=Yes, Blank=No
23
W
LEP/ELL
1
N
Enter Y if a student is classified as having Limited English Proficiency (LEP) or as an English Language Learner (ELL) or similar classification CSP Users: Must select one of the below Numbers: Test Type/Number TerraNova CSP TerraNova CSP with InView
24
25
X
Y
Test ID
Test Form
2
1
Y
Y
91 92
*Please Note: if you select ‘92’ you will need to provide the Inview level in Ref#27.
CSP Users: Enter G Level 10–21 as follows:
26
27
28 29
Z
TerraNova Level
2
Y
Level 10=Kdg Level 11=1st gr Level 12=2nd gr Level 13=3rd gr Level 14=4th gr Level 15=5th gr Level 16=6th gr Level 17=7th gr Level 18=8th gr Level 19=9th gr Level 20=10th gr Level 21=11th gr Level 21=12th gr
AA
InView Level
1
Y/N
Required if InView is selected (92) in Column X. NOT required if no InView is selected (91) in Column X. Grades 2/3=Level 1 Grades 4/5=Level 2 Grades 6/7=Level 3 Grades 8/9=Level 4 Grades 10/11=Level 5 Grades 11/12=Level 6 (Grade 11 can be administered Level 5 or 6)
AB
Race – American Indian or Alaska Native
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
AC
Race – Asian
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
Page 4 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values
AD
Race – Black or African American 1
N
CSP USERS- LEAVE THIS COLUMN BLANK
31
AE
Race – Native Hawaiian or other Pacific Islander
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
32
AF
Race – White
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
33
AG
Ethnicity
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
30
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
Y
4-digit valid year in the format of YYYY
***CSP USERS—Columns 36–54 MUST have the headers that are on the example spreadsheet, but the columns are to be left blank. No information is needed for CSP Users as it applies to other clients. All column headers must match the Sample Precode Layout file. Header names and their column positions are listed on page 6 of this document.***
Page 5 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref # 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
Column Max Position Name Length AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB
Home Language 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
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Required (Y/N)
Description/Values
N N N N N N N N N N N N N N N N N N N
CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK
Page 6 of 6
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 Length
Required (Y/N) Description / Values
1
A
Mode
6
Y
2
B
District Name
13
Y
3
C
District Code
10
Y
4
D
State
2
N
5
E
School Name
NA
Y
6
F
School Code
10
Y
‘PAPER’ for CSP Users The District Name must match the district Name displayed in the DRC INSIGHT Portal District dropdown: CALIFORNIA, CSI, FLORIDA, INTERNATIONAL, MID AMERICA, NAUMS, NCSA, NORTHEAST, NORTHWEST, OHIO RIVER VALLEY, ROCKY MOUNTAIN, SOUTH CENTRAL, SOUTHEAST The District Code must match the district code displayed in the DRC INSIGHT Portal District dropdown. CSP01, CSP02, CSP03, CSP04, CSP05, CSP06, CSP07, CSP08, CSP09, CSP10, CSP11, CSP12, CSP13 For CSP users the District will be 5 digits (ex. CSP02) The School Name must match the school name displayed in the DRC INSIGHT Portal District dropdown. Enter the complete School Name exactly as seen in the portal. If the name is longer than 15 characters, it will be truncated automatically during the upload. The School Code must match the school code displayed in the DRC INSIGHT Portal District dropdown. For CSP users the School Code will be 7 digits (ex. 0123456)
Page 1 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Length
Required (Y/N) Description / Values
7
G
Grade
2
Y
8
H
Teacher
15
Y
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
9
I
Last Name
20
Y
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 A-Z
10
J
First Name
15
Y
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 A-Z
11
12
K
L
Mid Initial
Birth Date
1
8
N
Y
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 MMDDYYYY Must have leading zeros for birthdates such as January 3rd, 2017 would be formatted the following: 01032017
Page 2 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Length
Required (Y/N) Description / Values
13
1
Y
14
M
N
Gender
Student ID
6
N
‘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 MUST be 6 digits if using this field 0-9 or blank
15
O
K
1
N
For CSP Users: 1 = Gifted & Talented 0-9 or blank For CSP Users: 1 = 1 or less years in Christian School 2 = 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
17
Q
M
1
N
For CSP Users: This field is used for the following: Allowed values: 1-3 or blank 1 = Home School 2 = International 3 = Other
18
R
N
1
N
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
21
U
IEP
1
N
Enter Y if a student has an Individualized Education Program Y=Yes, Blank=No
22
V
504
1
N
Enter Y if a student has a Section 504 Plan
Page 3 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values Y=Yes, Blank=No
23
W
LEP/ELL
1
N
Enter Y if a student is classified as having Limited English Proficiency (LEP) or as an English Language Learner (ELL) or similar classification CSP Users: Must select one of the below Numbers: Test Type/Number TerraNova CSP TerraNova CSP with InView
24
25
X
Y
Test ID
Test Form
2
1
Y
Y
91 92
*Please Note: if you select ‘92’ you will need to provide the Inview level in Ref#27.
CSP Users: Enter G Level 10–21 as follows:
26
27
28 29
Z
TerraNova Level
2
Y
Level 10=Kdg Level 11=1st gr Level 12=2nd gr Level 13=3rd gr Level 14=4th gr Level 15=5th gr Level 16=6th gr Level 17=7th gr Level 18=8th gr Level 19=9th gr Level 20=10th gr Level 21=11th gr Level 21=12th gr
AA
InView Level
1
Y/N
Required if InView is selected (92) in Column X. NOT required if no InView is selected (91) in Column X. Grades 2/3=Level 1 Grades 4/5=Level 2 Grades 6/7=Level 3 Grades 8/9=Level 4 Grades 10/11=Level 5 Grades 11/12=Level 6 (Grade 11 can be administered Level 5 or 6)
AB
Race – American Indian or Alaska Native
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
AC
Race – Asian
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
Page 4 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref Column # Position Name
Maximum Required Length (Y/N) Description / Values
AD
Race – Black or African American 1
N
CSP USERS- LEAVE THIS COLUMN BLANK
31
AE
Race – Native Hawaiian or other Pacific Islander
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
32
AF
Race – White
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
33
AG
Ethnicity
1
N
CSP USERS- LEAVE THIS COLUMN BLANK
30
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
Y
4-digit valid year in the format of YYYY
***CSP USERS—Columns 36–54 MUST have the headers that are on the example spreadsheet, but the columns are to be left blank. No information is needed for CSP Users as it applies to other clients. All column headers must match the Sample Precode Layout file. Header names and their column positions are listed on page 6 of this document.***
Page 5 of 6
Upload Multiple Student File Layout – TerraNova CSP Emphasis Highlighted Ref # 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
Column Max Position Name Length AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB
Home Language 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
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Required (Y/N)
Description/Values
N N N N N N N N N N N N N N N N N N N
CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK CSP USERS- LEAVE THIS COLUMN BLANK
Page 6 of 6
