Teacher Course Student (TCS) Report – Alternate Grading Method
Contents
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 award multiple traditional grades and grant partial credit for the course at multiple intervals while the course is in session (course marking period grades) in addition to using Standards based grades.
The grades and credits that are extracted for each course are determined based upon the Term Bins set up for your school terms and the corresponding store codes entered for the Reporting Store Codes (TCS) that are configured on the Start Page > District Setup > Schools/School Info > Edit School page > 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).
- 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.
- The record must have a Store Code defined by the TCS Final Grade Store Code setup for the term of the course.
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]) (District Setup > Schools/School Info > "Grade Levels using Standards" > Click Add and add each applicable grade level one at a time) 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.
Prerequisite Setup
In order to pull marking period grades and earned credit on the report, there is a prerequisite setup that must be completed prior to running this version of the report.
- You must have TermBins setup for each term that has associated courses that use marking period grading and the name of the TermBins must match the StoreCodes you use to store your marking period grades. For example, if you have yearlong courses that use two or four marking period grades, you must set up TermBins for each marking period in that term such as S1 and S2 or Q1, Q2, Q3, and Q4. If you have semester courses that use two marking periods, you must set up TermBins for each semester term, such as Q1 and Q2. Refer to School Setup > Final Grade Setups > New Final Grade in School Setup for information about setting up your TermBins.
- You must have either the schools, courses or sections that use marking periods for grading flagged by setting the corresponding school, course or section Use Marking Period for TCS field to Yes.
- To set the school flag, from the District Office Start page, select District (Setup) > Schools/School Info. Select a school from the list that uses marking period grades. The Edit School page opens. Under Other Information in the Connecticut State Report Information section select Yes for Use marking period for TCS. The default value for this field is No.
- To set the course flag, from the District Office Start page, select District (Setup) > Courses. The Courses page opens with the district course list. Select a course from the list that uses marking period grades. The Edit Course District Information page for the selected course opens. On the District tab under Connecticut State Information, select Yes for Use Marking Period for TCS. The field default unless explicitly set to Yes is to use the school setting. The field can be toggled to the opposite value of the school setting to override the school setting for just the selected course.
- To set the section flag, from the School Start page, select School (Setup) > Sections. Select a course from the list which has sections that use marking period grades. Select the appropriate section. On the Edit Section page under Connecticut State Information, select Yes for Use marking period for TCS. The field default unless explicitly set to Yes is to use the course setting. If explicitly set, the value of this field takes precedence over both the course and school field values.
Additional Information
Parameters have been added to the report run page that allows greater flexibility and control over which students, courses, and grade records are included in the report. This should facilitate easier verification of the data prior to submission because you now have the ability to include records in the report that would not have been in the report previously, and you can also explicitly exclude certain types of records from the report. The following parameters and run options are available:
Dropped Courses
- Exclude All Drop courses – choose this option if you don’t want any drop courses, including those with posted final grades, included in the report.
- Include Only Dropped Course w/ TCS Store Code Final Grade – choose this option if you want to exclude all dropped courses except those that have a final grade posted using a store code that is configured as a final grade store code for the TCS report.
- Include All Dropped Courses – choose this option if you want to include dropped courses for verification purposes.
Enrollment Duration
- Include only students who have been enrolled at least 90 calendar days.
- Include all students who have been enrolled.
Final Grades (applies to courses receiving traditional letter grades; standards-based courses are not affected)
- Exclude courses without a Final Grade.
- Include courses without a Final Grade.
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 it 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. |
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 |
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. | [Users]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 | Numeric | 3 |
7 | District Teacher ID | The district-assigned teacher number used to identify the teacher that taught this course. | [Users]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 complete SCED course code from the Connecticut State Secondary or Prior to Secondary Course list that aligns with the content of this course. Note: The value is extracted from either the Alternate Course Number field or the state reporting SCED Course Code field, depending on the value selected for the SCED Code parameter 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 then [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 code that uniquely identifies this section marking period and grade. This code will be a concatenation of the Course Number, Section Number, marking period TermBins Name and the stored grade record Term ID. Note: 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. | [Courses]Course_Number + “.” + [Sections]Section_Number + “.” + [StoredGrades]TermBinsName + “.” + [StoredGrades]TermID Example: 2397.2.S1.2400 When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SectionCode | Alpha numeric | 30 |
12 | Outcome/ Grade | The grade the student earned for the marking period or the course, depending upon the grading method used for the course. Notes: The grade records included in the extract are determined by the store codes defined on the Edit School > TCS Reporting Store Codes page (Final Grade method) or by the marking period StoreCodes selected at report run time (Marking Period method). 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 marking period or term began, depending upon the grading method used for the course, in MMDDYYYY format. 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 [TermBins]Date1 or [Terms]FirstDay When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SessionBeginDate | Date | 8 |
15 | Session End Date | The date the marking period or term ended, depending upon the grading method used for the course, in MMDDYYYY format. 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 [TermBins]Date2 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 partial credit the student earned in the course for the marking period (Marking Period Method) or the full credit earned for the course (Final Grade Method), expressed as a number with 2 decimal places. | [StoredGrades]EarnedCrHrs Set to 0.00 for Standards based grades or withdrawn courses. | 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 |