Upload Multiple Student File Layout

Report 7 Downloads 38 Views
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.)