Teacher Course Student (TCS) Report
CT_GradeUsingStandard.Report Description
This report contains teacher, course, student, grade/outcome, and credit data for all students who were enrolled in the district for a minimum of 90 total calendar days during the school year for which the report is being run.
Use this report to extract the data needed to meet Connecticut state TCS reporting requirements when your schools use Standards based grades and/or award a single traditional final grade and grant credit for the course one time at the end of the course.
The final grades and credits that are extracted for each course are determined based upon the store codes entered for the Reporting Store Codes that are configured on the Start Page > District Setup > Schools/School Info > Edit School > Reporting Store Codes (TCS) page.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The student must not be excluded from state reporting.
The student enrollment must be in a school selected on the report parameter page.
[CC] Record Selection
The CC record must be within the current school year of the school where the course is being taken.
Associated section must not be excluded from the TCS report. ([Courses]exclude_state_rpt_yn = 1).
The CC record must occur during the year of the selected term.
Historical Grade [StoredGrades] record selection
The record must not be excluded from TCS ([S_CT_SGR_TCS_X]ExcludeFromTCS).
The record must either:
Have a Section ID associated with a selected CC record.
Have a SectionID = 0, TermID within the selected school year, and SchoolID of a selected student enrollment record.
Standards-based Grades Selection
The student enrollment record grade level must be less than or equal to the Highest grade using Standards Grading (S_CT_SCH_Standard_Grd_Levels_C[Grade_Level]) of the school where the course is taken [CC]SchoolID.
Note: If a student does not receive a grade for a course that ordinarily is awarded a grade (example: student not enrolled long enough to complete sufficient course work) but a grade such as EX (Exempt) or NG (No Grade) is recorded for the student, these grades should be stored using a unique Store Code that is not included in the TCS Final Grade Store Code setup so they will not be picked up in the report. The SCED code associated with the Teacher of Record (101) indicates the entire course weight and credit earned and the SCED code associated with the Co-Teacher (103) will be worth 0 with 0 earned.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | If run at the district level, choose one of the following:
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 |
|
Course Code | Choose one of the following based on where the state-defined course number is entered on the Edit Course District Information page (Start Page > District Setup > Courses):
|
Section Number | Choose one of the following based on where the state-defined section number is entered on the Edit Section page (Start Page > School Setup > Sections):
|
Dropped Courses | Choose one of the following:
|
Enrollment Duration | Choose one of the following:
|
Final Grades | Choose one of the following:
|
Display Headers? | Select Yes or No if you want to turn headers on or off in the report. |
Include identifying information with each record for troubleshooting* | Select Yes to include students’ and teachers’ last name and first name at the end of the record to help identify problems. Do NOT use when generating a marking period report. When you run the report with "Include identifying information with each record for troubleshooting" selected, the following information is displayed: The student Grade_Level, EnrollmentSchoolID; section Course Name, course Potential Credit; adjacent column holding just the credit value from the SCED code, when is a secondary code structure; “Group” or “Group Code”, student CC most recent Date Enrolled and Date Left and a total of days enrolled in the class. This helps you verify if the data is correct. |
Include Session Membership Attended* | Select Yes or No if you want to include the session membership attended in the report. |
Include Session Membership* | Select Yes or No if you want to include session membership in the report. |
Summer Grades | Date from which summer grades to be included. This runtime parameter filters the data from Historical grades having met the below criteria:
|
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.
The Teacher Course Student report will also display the data for the co-teacher with Course credit earned as 0.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | State Assigned Student ID (SASID) | The student’s state-assigned identifier. The report will trim spaces from the value. | [Students]State_StudentNumber Spaces are trimmed but published as blank if the resulting value is larger than 10 characters. | Numeric | 10 |
2 | Reporting District | The three-digit code identifying the district reporting the teacher course student data. | [Prefs]Value where [Prefs]Name = districtnumber | Numeric | 3 |
3 | District Student ID | The locally assigned student number. | [Students] Student_Number | Alpha numeric | 20 |
4 | Date of Birth | The student’s birth date. | [Students]DOB | Date | 8 |
5 | Educator Identification Number (EIN) | The state-assigned teacher number used to identify the teacher who taught this course. The report will trim spaces from the value. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [Teachers]SIF_StatePrid Spaces are trimmed but published as blank if the resulting value is larger than 10 characters. When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_TeacherEIN | Numeric | 10 |
6 | Teacher Type | The three-digit code indicating the type of teacher assigned to the student for a given course. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_SSF_X] TeacherType When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_TeacherType If the role of the teacher is defined as co-teacher in a section, then the co-teacher type will be 103, 203, 303, 403 based on the level of the teacher defined in teacher's profile. | Numeric303 | 3 |
7 | District Teacher ID | The district-assigned teacher number used to identify the teacher that taught this course. | [Teachers]TeacherNumber | Alpha numeric | 20 |
8 | Course Facility Code | The school number for the school where this course is taught. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [Sections]WhereTaught [Schools] Alternate_School_Number [Schools]School_Number When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_CourseFacilityCode | Numeric | 7 |
9 | SCED Course Code | The state-assigned completed SCED course code for this course record. Note: The value is extracted from either the Alternate Course Number field or the SCED Course Code field, based on the SCED Code parameter selection at report runtime. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_CRS_X] SCEDCourseCode [Courses]Alt_Course_Number When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SCEDCourseCode | Alpha numeric | 12 |
10 | District Course Code | The district course code assigned to this course record. | [Courses]Course_Number | Alpha numeric | 20 |
11 | Section Code | The section number assigned to this course section record. Note: The value is extracted from either the Section Number field or the State Section Number (Teacher Course Student Extract) field, depending on the selection at report runtime. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_SEC_X]TCSSectionNumberOverride [Sections]Section_Number When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SectionCode | Alpha numeric | 30 |
12 | Outcome/ Grade | The grade the student earned upon completion of this course. Notes: The grade records included in the extract are determined by the store codes defined on the Edit School page. For students who are assigned Standards instead of Stored Grades a default value set on the Edit School page is used as a default. An override option is available under the students All Enrollments page. Sections that should not be included can be excluded on the Sections page. | [StoredGrades]Grade [S_CT_GradeLevelOutcome_S]TCSOutcome [S_CT_CC_X]TCSOutcomeOverride | Alpha numeric | 10 |
13 | Facility 1 Code | The seven-digit Facility 1 Code for the student as reported in the Public School Information System (PSIS). | [S_CT_STU_X] FacilityCode1 [Schools]Alternate_School_Number [Schools]School_Number | Numeric | 7 |
14 | Session Start Date | The date the class/section began, in the format MMDDYYYY For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_TRM_X]ClassFirstDayDate or [Terms]FirstDay When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_SessionBeginDate | Date | 8 |
15 | Session End Date | The date the class/section ended, in the format MMDDYYYY For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_TRM_X]ClassLastDayDate or [Terms]LastDay When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_SessionEndDate | Date | 8 |
16 | Outcome/ Grade Status | An indicator to clarify the Outcome/Grade field that describes the circumstances under which the student exited from membership in a class section. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_CC_X]TCSOutcomStatusOverride [S_CT_GSI_X]TCSGradeStatus [S_CT_GradeLevelOutcome_S]TCSOutcomeStatus When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_OutcomeStatus | Alpha numeric | 20 |
17 | Course Credits Earned | The number of Carnegie credits the student earned in the course, expressed as a number with 2 decimal places. | [StoredGrades]EarnedCrHrs Set to 0.00 for Standards based grades or withdrawn courses. Set to 0.00 for co-teachers | Numeric | 4 |
18 | Number of Membership Sessions | The number of times the class met. If the [S_CT_SGR_TCS_X]O_MembershipSessions field is empty then the value is derived from the number of times the class met between "ClassFirstDayDate" and "ClassLastDayDate" override fields from S_CT_TRM_X table, if available. Otherwise, these counts will be based on days between the Session Start Date and Session End Date. | [S_CT_SGR_TCS_X]O_MembershipSessions, if populated. Otherwise: [S_CT_TRM_X]ClassFirstDayDate [S_CT_TRM_X]ClassLastDayDate | Numeric | 3 |
19 | Number of Membership Sessions Attended | The number of membership sessions a student in the course attended. | [S_CT_SGR_TCS_X]O_SessionsAttended , if populated. Otherwise: Calculated based on the school calendar, periods, section schedule, and daily attendance. Note: If a course section meets for more than one period on the same day, the multiple periods are calculated as a single session for the day. Absence in any one of those periods is counted as an absence for that session. | Numeric | 3 |
20 | Dual Enrollment Code | The code associated with the higher learning dual enrollment program for which the student is earning college credit. For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column. | [S_CT_SEC_X]DualEnrollPrgmCode When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_DualEnrollPrgmCode | Alpha numeric | 10 |
21 | CSDE Use | This field is not currently used. | N/A | Alpha numeric | 20 |
22 | End of Record Marker | X displays in this field. | Set to “X” | Alpha numeric | 1 |