Skip to main content
Skip table of contents

Student Course Grade Teacher Report

On this page:

Introduction

Use the Student Course Grade Teacher extract to collect course assignment and grade records from the Courses, Sections and Stored Grades table.

This report uses the State reporting Platform to generate results.

Selection Criteria

Selection criteria determine which database records are used in the report.

Records for the SCGT report are selected based on the following criteria:

  • The student must not be excluded from State Reporting.
  • The student's course enrollment start date must be inclusive of the Report Start Date and Report End Date.
  • The course/section cannot be excluded from State reporting.
  • The stored grade selected based on the term grade mapping must not be excluded from state reporting.

Report Setup

You must map the following data prior to running the reports:

  • Letter Grade Mapping is used to map grade completion statuses to the state Course Final Letter Grades.
  • Term Grade Mapping is used to map, for each school, the Store Code that should be extracted for each term ID.

These options are found on the District > District Setup page in the Maryland State Information area at the bottom of the page. For example, for school 100, Term ID 2001 (first semester), the store code might be S2 for the final grade for that semester. You must enter a record to designate the Store Code to extract for that term.

You must also run the Store Grades process for a given term.

Grades entered manually into Historical Grades via Single Entry are also used by the report, if the course is the district course. When manually entering out of district courses in Historical Grades, select the Exclude this Historical Grade from State Reporting, as these courses are not collected for the Student Course Grade Teacher report.

During Stored Grades manual entry, if a Course Number is entered, data is pulled from that course if the fields are not populated in the Additional State Fields. If a course section is entered, the data is will be extracted from that section; if blank, data is extracted from the course. If no course number is entered, data is extracted only from the fields on the Stored Grades page. If blanks are found in fields there, blanks will extract for those fields.

During Stored Grades manual entry, you must be logged into the school from which the grades will be extracted, rather than at the District Office.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Report Parameters

Set Select All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file.

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.

Select Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected [number] Students Only
  • All Students

Note: If running the report for a single student, or group of students, select the students prior to running report.

Report Start Date

Enter the start date for this report

Report End Date

Enter the end date for this report

Submission Date

Enter the submission date to be used for this report – enter 2012 for the 2011-2012 school year.

Academic Year

Enter the academic year for this report – enter 2012 for the 2011-2012 school year.

Submission Number

Enter the submission sequence number starting with 001.

Use Alternate School NumbersIf you require the use of the Alternate School number select Yes.

Append Section ID to Period for These Schools

Select the school if running for current school for which you would like to have the period appended with the section id.

Select multiple schools for which you would like to have the period appended with the section id if running for the entire district.

On windows hold the Ctrl key for multiple selections. On a Mac hold the Command button for multiple selections.

Include Column Headings?Select Yes if you want column headers to be populated on the report output.
Scheduling OptionsDescription

Scheduling – Run Now

Leave Run Now selected to run the report now.

Submit

Click Submit to run the report now

Scheduling – Please Select When to run

Click the Schedule button to schedule this report to run.

Please Select Schedule Settings

Enter the Start Date and Start time. Click the Repeat button.

Please select repeat cycle options.

Choose the applicable option.

Please select end date range option

Enter the appropriate information.

Submit

Click Submit to schedule the report

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item

Data Element

Description

[Table]FieldName

Field Type

Field Length

Column

See Standard Student Demographic String for Items 1 - 35.

36


Submission Number

This field contains a sequential number between 001 through 999.

From report parameter page

Numeric

3

AJ

37

Academic Year

This field contains the school year for the student grade records. Format: YYYY

Calculated

Numeric

4

AK

38

LEA Course Code

This field contains the course code. This field value is extracted from the Stored Grades table, Student Selection > Historical Grades or the Course table, District Setup > Courses.

[StoredGrades]Course_Number OR

[Courses]Course_Number

Alpha numeric

10

AL

39

LEA Section Number

This field contains the number identifying the course section. This field value is extracted from the Sections table, School > Sections.

[Sections]ID

Alpha-numeric

10

AM

40

LEA Section Title

This field contains the course section name. The course name is extracted from the Courses table, District Setup > Courses

[Courses]Course_Name

Alpha-numeric

30

AN

41

LEA Class Period

This field contains the period in which the student took this course section. This field value is extracted from the Sections table, School > Sections.

[Sections]Expression

Alpha-numeric

50

AO

42Unique LEA Classroom Key ElementsThis is an optional element used as a component of the LEA classroom key; it is used for LEA purposes ONLY. No MSDE required LEA classroom key component should be reported in this field without it also appearing in the appropriate MSDE required field.CalculatedAlpha-numeric10AP

43

Instruction Outside of School Flag

If this field contains a Y, this course is taught outside of school.

This field is extracted from the Stored Grades table, Student Selection > Historical Grades. If the value in the Stored Grades table is blank, it is extracted from the Sections table, School > Sections. If the value in the Sections table is blank, it is extracted from the Courses table, District Setup > Courses.

Note: If set to 'Y' the Primary Teacher Gender reports as 0 and Primary Teacher Ethnicity reports as 'N'.

[S_MD_CRS_X]Outside_Of_School OR

[S_MD_SEC_X]Outside_Of_School OR

[S_MD_SGR_X]Outside_Of_School

Alpha numeric

1

AQ

44

Course Marking Term

This field contains the term in which the student earned the grade for this course.

If this field is left blank, the Term is extracted from the Term Grade Mappings table (District >Term Grade Mapping).This field contains identifies the term in which the class was taken.

[S_MD_SGR_X]Course_Term

If blank, [S_MD_TermGradeMapping_S]CourseTerm

Numeric

2

AR

45Filler



Alpha-numeric1AS

46

Course Completion Status

Indicates the student’s final status for the course.

[S_MD_CC_X]Completion_Status

Alpha-numeric

2

AT

47

Alpha Grade

This field contains the letter grade the student earned in this course. This field is extracted from the Stored Grades table, Student Selection > Historical Grades.

[StoredGrades]grade converted to mapped value in the Letter Grade Mapping table:

[S_MD_GSI_LetterGradeMapping_C]Code01 through [S_MD_GSI_LetterGradeMapping_C]Code05

[StoredGrades]Grade

Alpha numeric

2

AU

48

Standards-Based Grade

This field contains the letter grade the student earned in this course. This field is extracted from the Stored Grades table, Student Selection > Historical Grades.

Reports as an 'NA' if an Alpha Grade is reported.

[StoredGrades]Grade

Alpha numeric

28

AV

49Filler


Alpha numeric1AW
50Filler

Alpha numeric1AX

51

Multiple Teacher Course Flag

If this field contains a Y, this course is taught by multiple teachers. If applicable, the secondary and tertiary teacher information displays in the extract.

If this field contains an N, this course is taught by one teacher. The secondary and tertiary teacher information is blank for that course.

This field is extracted from the Sections table, School > Sections.

[S_MD_SEC_X]Multiple_Teacher_Flag

Alpha numeric

1

AY

52

Primary Teacher Statewide Identifier

This field contains the Unique Statewide identifier assigned to the primary teacher by the MSDE (SATID). This field is extracted from the Staff Table, Staff Selection > Edit Information.

[S_MD_USR_X]State_Identifier

Alpha numeric

10

AZ

53

Primary Teacher - Local Employee ID

This field contains the local number assigned to the primary teacher by the district. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[S_MD_USR_X]Local_Employee_Number

Alpha numeric

10

BA


54

Primary Teacher - Last Name

This field contains the last name of the primary teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[Users]Last_Name

Alpha-numeric

25

BB


55

Primary Teacher - First Name

This field contains the first name of the primary teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[Users]First_Name

Alpha-numeric

15

BC

56

Primary Teacher -Middle Name

This field contains the middle name of the primary teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[Users]Middle_Name

Alpha-numeric

15

BD

57

Primary Teacher -Generational Suffix

This field contains the generational suffix of the primary teacher, if applicable. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[S_MD_USR_X]Generational_Suffix

Alpha-numeric

3

BE

58

Primary Teacher -Maiden Last Name

This field contains the maiden name of the primary teacher, if applicable. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[S_MD_USR_X]Maiden_Name

Alpha-numeric

25

BF

59

Primary Teacher - Date of Birth

This field contains the primary teacher’s birth date. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[UsersCoreFields]DOB

Numeric

8

BG

60

Primary Teacher -Gender

This field contains the primary teacher’s gender. This field is extracted from the Staff Table, Staff Selection > Edit Information.

[UsersCoreFields]Gender

Alpha-numeric

1

BH

61

Primary Teacher -Ethnicity Hispanic/Latino

A Y in this field identifies the teacher’s ethnicity as Hispanic or Latino. Start Page > Staff > Select A Staff Member > Edit Information.

[Users]FedEthnicity OR

[S_MD_USR_X]Hispan_Lat_TF

Alpha-numeric

1

BI

62

Primary Teacher - Race

This field contains the staff member’s race. This field is calculated by concatenating the following fields entered on the Start Page > Staff > Select A Staff Member > Edit Information.

  • Race Codes 1–5

[TeacherRace]RaceCode OR

[S_MD_USR_X]Race_Amer_Ind_TF

[S_MD_USR_X]Race_Eth_Asian_TF

[S_MD_USR_X]Race_Black_TF

[S_MD_USR_X]Race_Hawaiian_TF

[S_MD_USR_X]Race_White_TF

Alpha-numeric

5

BJ-BO

63

Secondary Teacher -Statewide Identifier

This field contains the Unique Statewide identifier assigned to the teacher by the MSDE (SATID). This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[S_MD_USR_X]State_Identifier

Alpha numeric

10

BQ

64

Secondary Teacher - Local Employee ID

This field contains the local number assigned to the teacher by the district. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[S_MD_USR_X]Local_Employee_Number

Alpha numeric

10

BR

65

Secondary Teacher - Last Name

This field contains the last name of the teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[Users]Last_Name

Alpha-numeric

25

BS

66

Secondary Teacher - First Name

This field contains the first name of the teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[Users]First_Name

Alpha-numeric

15

BT

67

Secondary Teacher -Middle Name

This field contains the middle name of the teacher. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[Users]Middle_Name

Alpha-numeric

15

BU

68

Secondary Teacher -Generational Suffix

This field contains the generational suffix of the teacher, if applicable. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[S_MD_USR_X]Generational_Suffix

Alpha-numeric

3

BV

69

Secondary Teacher - Maiden Last Name

This field contains the maiden name of the teacher, if applicable. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[S_MD_USR_X]Maiden_Name

Alpha-numeric

25

BW

70

Secondary Teacher - Date of Birth

This field contains the teacher’s birth date. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[UsersCoreFields]DOB

Numeric

8

BX

71

Secondary Teacher -Gender

This field contains the teacher’s gender. This field is extracted from the Staff Table, Staff Selection > Edit Information. (Currently blank)

[UsersCoreFields]Gender

Alpha-numeric

1

BY

72

Secondary Teacher -Ethnicity Hispanic/Latino

A Y in this field identifies the teacher’s ethnicity as Hispanic or Latino. Start Page > Staff > Select A Staff Member > Edit Information. (Currently blank)

[Users]FedEthnicity OR

[S_MD_USR_X]Hispan_Lat_TF

Alpha-numeric

1

BZ

73

Secondary Teacher - Race

This field contains the staff member’s race. This field is calculated by concatenating the following fields entered on the Start Page > Staff > Select A Staff Member > Edit Information. (Currently blank)

  • Race Codes 1–5

[TeacherRace]RaceCode OR

[S_MD_USR_X]Race_Amer_Ind_TF

[S_MD_USR_X]Race_Eth_Asian_TF

[S_MD_USR_X]Race_Black_TF

[S_MD_USR_X]Race_Hawaiian_TF

[S_MD_USR_X]Race_White_TF

Alpha-numeric

5

CA-CF

Back to Top

S_MD_TermGradeMapping_S

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.