ACT Aspire SDU (Student Data Upload)

Report Layout and Field Match (O=Optional, R=Required)

1.     Update Indicator – O.  Can be blank.  If you create a field in demographics, the values are “U” for update, “D” for delete and “N” for no change.

2.     State – R.  Matched to the state field in demographics.

3.     State District Code – R.  Matched to the default value “Your State” on the state reporting screen.

4.     State School Code – R.  Matched to the school location field from demographics.

5.     ACT High School Code – O.  Add your ACT/College Board CEEB code to one of the default value boxes on the screen to match to this field.

6.     State Student ID – O.  Matched to the SRSD_UIC field in demographics.

7.     Local ID – O.  Matched to the ID_Number field in demographics.

8.     Student First Name – R.  Matched to the Student_First_Name field in demographics.

9.     Student Last Name - R.  Matched to the Student_Last_Name field in demographics.

10.  Student Middle Initial - O.  Matched to the Student_Middle_Name field in demographics.

11.  Date of Birth – R.  Matched to the Birth_Date field in demographics.

12.  Gender – O.  Matched to the Sex field in demographics.

13.  Actual Grade – R.  Matched to the Grade_Year field in demographics. 

14.  English Testing Grade – O.   Values are numeric 00-12 or blank. 

15.  Reading Testing Grade – O.   Values are numeric 00-12 or blank. 

16.  Math Testing Grade – O.   Values are numeric 00-12 or blank. 

17.  Science Testing Grade – O.   Values are numeric 00-12 or blank. 

18.  Writing Testing Grade – O.   Values are numeric 00-12 or blank. 

19.  Class or Group 1 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

20.  Class or Group 2 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

21.  Class or Group 3 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

22.  Class or Group 4 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

23.  Class or Group 5 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

24.  Class or Group 6 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

25.  Class or Group 7 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

26.  Class or Group 8 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

27.  Class or Group 9 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

28.  Class or Group 10 – O.  Ability to group students in any way that the user desires.  By teacher, class, level, etc.

29.  Hispanic or Latino – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

30.  American Indian/Alaska Native – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

31.  Asian – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

32.  Black/African American – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

33.  Native Hawaiian/Other Pacific Islander – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

34.  White – O.  Match to a field in demographics that contains value Y, N, X or leave it blank.

35.  Migrant – O.  Match to a field in demographics that contains value Y or leave it blank.

36.  Economically Disadvantaged – O.  Match to a field in demographics that contains value Y or leave it blank.

37.  IEP – O.  Match to a field in demographics that contains value Y or leave it blank.

38.  ELL – O.  Match to a field in demographics that contains value Y or leave it blank.

39.  Section 504 – O.  Match to a field in demographics that contains value Y or leave it blank.

40.  Othe Accoms Plan – O.  Match to a field in demographics that contains value Y or leave it blank.

41.  Gifted – O.  Match to a field in demographics that contains value Y or leave it blank.

42.  Teacher Email 1 – O.  Leave blank unless available for all teacher email fields.

43.  Teacher Email 2 – O. 

44.  Teacher Email 3 – O. 

45.  Teacher Email 4 – O. 

46.  Teacher Email 5 – O. 

47.  Teacher Email 6 – O. 

48.  Teacher Email 7 – O. 

49.  Teacher Email 8 – O. 

50.  Teacher Email 9 – O. 

51.  Teacher Email 10 – O. 

52.  Pearson Student Code – O.  Match to a field in demographics with 10 character code.