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: 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. 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	All Students – Includes all students included in the selected school(s) who meet the student selection criteria. The Selected # Students Only – Includes only those students from the current selection of students and the selected school(s) who meet the student selection criteria.
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): SCED Course Code – Choose this value if your school stores the state-defined course number in the SCED Course Code field. Alt Course Code – Choose this value if your school stores the state-defined course number in the Alternate Course Number field.
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): Section Number – Choose this value if your school stores the state-defined section number in the Section Number field. State Section Number – Choose this value if your school stores the state-defined course number in the Section Number (Teacher Course Student Record) field.
Dropped Courses	Choose one of the following: 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	Choose one of the following: Include only students who have been enrolled at least 90 calendar days Include all students who have been enrolled
Final Grades	Choose one of the following: Exclude courses without a Final Grade Include courses without a Final Grade
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