School Assessment Science and (Alt-MSA)

Use Alternate School Number

Select Yes to submit the school’s Alternate school number or No to submit the school’s school number.

Test Type: MSA or Alt-MSA

Select MSA to select students taking the School Assessment Science Test or Alt-MSA to select students who are taking the Alt-MSA test.

Test Type: Pre or Post

Select Pre Test if you are submitting the Pre Test, Post Test if you are submitting the Post Test.

Test Format

Select Electronic if the students are taking the Electronic format of this test, Paper if the students are taking the Paper format of this test.

Pre Test Date

Enter the Date the students will take the Pre Test.

Post Test Date

Enter the Date the students will take the Post Test.

Submission Date

Enter the Date the file is being created.

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Submit

Click Submit to run the report

1

LEA

This field contains the two-digit local education agency code (LEA). This field is extracted from the District Information page, Start Page > District Setup > District Information.

[Pref]MD_DistrictLEA

Numeric

2

2

School Number

This field contains the four-digit code that identifies the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.

[Schools]School_Number

Or

[Schools] alternate_school_number

Numeric

4

3

State Student Identifier

This field contains the student identification number assigned by the Maryland State Department of Education. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.

[Students]State_StudentNumber

Numeric

10

4

Local Student Number

This field contains the student identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Student_Number

Numeric

10

5

Last Name

This field contains the last name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Last_Name

Alpha numeric

25

6

First Name

This field contains the first name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]First_Name

Alpha numeric

15

7

Middle Name

This field contains the middle name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Middle_Name

Alpha numeric

15

8

Generational Suffix

Reported Values:

1=Jr, 2=II, 3=III, 4=IV, 5=V, 6 =VI, 7=VII, 8=IIX, 9=IX, 10=X

This field contains the student’s Generational Suffix. This field value is extracted from the State/Province MD page, Start Page > Student Selection > State/Province MD.

[S_MD_STU_X]Generation

Alpha numeric

3

9

Birthdate

This field contains the birth date of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]DOB

Date format of YYYYMMDD

10

10

Grade

Reported Values:

3 = 03, 4 = 04, 5 = 05, 6 = 06, 7 = 07, 8 = 08, 10 =10

This field contains the grade level of the student. This field is extracted from the Edit Demographics page or the Edit Current Enrollment page, Start Page > Student Selection> General Demographics or Start Page > Student Selection > Transfer Info > Edit Current Enrollment.

[Students]Grade_Level

Alpha numeric

2

11

Gender

Reported Values:

2 = Female , 1 = Male

This field contains the gender of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Gender

Alpha numeric

1

12

Hispanic or Latino Ethnicity

Reported Values:

1 If fedethnicity = 1 OR MD_Hispan_Lat = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[Students]fedethnicity OR

[Students]MD_Hispan_Lat

Alpha numeric

1

13

American Indian or Alaska Native

Reported Values:

1 If RaceCd = 1 OR MD_Eth_Amer_Ind = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[StudentRace]RaceCd OR

[Students]MD_Eth_Amer_Ind

Alpha numeric

1

14

Asian

Reported Values:

1 If RaceCd = 1 OR MD_Eth_Asian = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[StudentRace]RaceCd OR

 [Students]MD_Eth_Asian

Alpha numeric

1

15

Black or African American

Reported Values:

1 If RaceCd = 3 OR MD_Eth_Black = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[StudentRace]RaceCd OR

 [Students]MD_Eth_Black

Alpha numeric

1

16

Native Hawaiian or Other Pacific Islander

Reported Values:

1 If RaceCd = 4 OR MD_Eth_Hawaiian = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[StudentRace]RaceCd OR

[Students]MD_Eth_Hawaiian

Alpha numeric

1

17

White

Reported Values:

1 If RaceCd = 5 OR MD_Eth_White = 1 else 0.

Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[StudentRace]RaceCd OR

 [Students]MD_Eth_White

Alpha numeric

1

18

Filler 1

Not Used

Alpha numeric

9

19

Filler 2

Not Used

Alpha numeric

1

20

Title 1

Reported Values:

Y If Title_One = 1 else N

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]Title_One

Alpha numeric

1

21

Free/Reduced Price Meals

Reported Values:

Y If LunchStatus  <> P else N

Start Page > Student Selection > Lunch.

[students]Lunch_Status

Alpha numeric

1

22

Migrant

Reported Values:

Y If Migrant = 1 else N

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]Migrant

Alpha numeric

1

23

Filler 3

Not Used

Alpha numeric

1

24

Special Education Services

Reported Values:

Y If ST_SPED = 1

E If ST_SPED = 2

3 If ST_SPED = 3

2 If ST_SPED = 4

else N

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]Special_Education

Alpha numeric

1

25

SPED Exit Date

Reported Values:

If ST_SPED = 2 Then the student’s SPED exit date is submitted.

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]SpecEd_End_Date

Date format of YYYYMMDD

8

24

Filler 4

Not Used

Alpha numeric

1

25

LEP Services Indicator

Reported Values:

Y If ELL = 1

E If ELL = 2

else N

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]ELL

Alpha numeric

1

26

First Date in US School

Reported Values:

If ELL = 1 or 2 Then the student’s First Date in US School is submitted.

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]First_Date_In_US_School

Date format of YYYYMMDD

8

27

LEP Exit Date

Reported Values:

If ELL = 2 Then the student’s LEP End date is submitted.

Start Page > Student Selection > Maryland State Information.

[S_MD_STU_X]ELL_End_Date

Date format of YYYYMMDD

8

28

Filler 5

Not Used

Alpha numeric

1

29

Submission Date

Entered at run Time

Date format of YYYYMMDD

8

30

Filler 6

Not submitted

Alpha numeric

1

31

Filler 7

Not submitted

Alpha numeric

1

32

Alt-MSA Indicator

Reported Values:

If Alt_MSA_ Indicator =1  Then Y, Else N.

Start Page > Student Selection > Maryland State Information> MSA & (Alt-MSA) - Science

[S_MD_STU_MSA_X]Alt_MSA_ Indicator

Alpha numeric

1

33

Filler 8

Not submitted

Alpha numeric

1

34

Filler 9

Not submitted

Alpha numeric

1

35

Test Format - Science

Reported Values:

If Test_Format = E then E, else Test_Format = P then P.

Start Page > Student Selection > Maryland State Information> MSA & (Alt-MSA) - Science

[S_MD_STU_MSA_X]Test_Format

Alpha numeric

1

36

Science Test Group

If the user selects MSA for the Test Type ‘0000’ is submitted else null.

Alpha numeric

4

37

Filler 10

Not submitted

Alpha numeric

1

38

Filler 11

Not submitted

Alpha numeric

1

39

Filler 12

Not submitted

Alpha numeric

1

40

Filler 13

Not submitted

Alpha numeric

1

41

Special Orders - Science

Reported Values:

If the user selects MSA for the Test Type AND  SpecialOrder_Science = 1  then 1, else if SpecialOrder_Science = 2  then 2, else if SpecialOrder_Science = 3  then 3 else null.

Start Page > Student Selection > Maryland State Information> MSA & (Alt-MSA) - Science

[S_MD_STU_MSA_X] SpecialOrder_Science

Alpha numeric

1

42

Filler 14

Not submitted

Alpha numeric

1

43

Filler 15

Not submitted

Alpha numeric

1

44

Filler 16

Not submitted

Alpha numeric

1