School Setup

Data Element

Additional Information

[Table]Field Name

Length

Used in these Reports

Entering Attendance Codes

School Setup > Attendance: Attendance Codes > New/Edit

There are no state-mandated attendance codes for Connecticut. You must assign a status of present or absent to each attendance code.

Code

Enter the attendance code abbreviation.

[Attendance_Code]Att_Code

N/A

PSIS

Description

Enter the attendance code description.

[Attendance_Code]Description

N/A

PSIS

Presence Status

Choose Present or Absent as the presence status for this attendance code.

[Attendance_Code] Presence_Status_CD

N/A

PSIS

This attendance code earns ADA credit

Select the checkbox to include this attendance code in attendance calculations.

[Attendance_Code] Calculate_ADA_YN

N/A

PSIS

This attendance code counts towards membership

Select the checkbox to include this attendance code in membership calculations.

[Attendance_Code] Calculate_ADM_YN

N/A

PSIS

Defining Attendance Code Categories

School Setup > Attendance: Attendance Code Categories > New/Edit

Define attendance code categories such as tardy, excluded, and so on.

Code

Enter the attendance code category abbreviation.

[Code_Entity]CE_Code

N/A

PSIS

Name

Enter the name of the attendance code category.

[Code_Entity]External_Name

N/A

PSIS

Description

Enter a description for the attendance code category.

[Code_Entity]Description

N/A

PSIS

Sort Order

Choose the sort order from the pop-up menu to determine where the attendance code category displays on the page.

[Code_Entity]SortOrder

N/A

PSIS

Configuring Attendance Conversion Settings

School Setup > Attendance: Attendance Conversions > New/Edit

Configure attendance calculation conversion settings used when calculating ADA.

Name

Enter the attendance conversion name.

[Attendance_Conversion]Name

N/A

PSIS

(NONE)/Defined > Period-To-Day Attendance Conversion

Day Attendance Value

[Attendance_Conversion_Items] Conversion_Mode_Code=periodday

[Attendance_Conversion_Items] Attendance_Value

N/A

Required for schools that use period/meeting attendance

(NONE)/Defined > Code-To-Day Attendance Conversion

Code

The code for the code-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items] Conversion_Mode_Code=codeday

[Attendance_Conversion_Items] Input_Value

Note: The value in the Input_Value field is the ID of an attendance code in the [Attendance_Code] table.

N/A

Required for schools that use daily attendance

Day Attendance Value

Enter the day attendance value for the code-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items] Conversion_Mode_Code=codeday

[Attendance_Conversion_Items] Attendance_Value

N/A

Required for schools that use daily attendance

Adding Full-Time Equivalencies (FTE)

School Setup > Attendance: Attendance Conversions > New/Edit

Add the student full-time equivalencies used when calculating ADA. Assign FTEs to students, Start Page > Student > Transfer Info > Edit Enrollment.

Name

Enter the FTE name.

[FTE]Name

80

PSIS

Default Attendance Mode

Choose the default attendance mode for the FTE from the pop-up menu.

[FTE]Dflt_Att_Mode_Code

N/A

PSIS

Default Attendance Conversion

Choose the default attendance conversion for the FTE from the pop-up menu.

[FTE]Dflt_Conversion_Mode_Code

N/A

PSIS

Setting Attendance Preferences

School Setup > Attendance: Preferences

Set attendance preferences for recording methods and period conversion.

Attendance Recording Methods

Select checkboxes for the appropriate types of attendance.

[Prefs]Value where [Prefs]Name=(method)

N/A

PSIS

Count these codes for period conversion

Choose Absences or Presents from the count these codes for the period conversion pop-up menu.

Note: This option determines whether or not to count present or absent codes for period-to-day attendance conversions.

[Prefs]Value where [Prefs]Name=ATT_CalcCntPresentsAbsences

N/A

PSIS

Defining Bell Schedules

School Setup > Calendaring: Bell Schedules > New/Edit

Define bell schedules for the current school.

Name

Enter the bell schedule name.

[Bell_Schedule]Name

50

Required Setup

Attendance Conversion Method

Choose the attendance conversion method for the bell schedule from the pop-up menu.

[Bell_Schedule] Attendance_Conversion_ID

N/A

PSIS

Note: After entering the Name and Attendance Conversion Method, when you click Submit, the Bell Schedules page displays an Edit Schedule link.

Bell Schedules > Edit Schedule > New

Period

Choose the period associated with the bell schedule item from the pop-up menu.

[Bell_Schedule_Items]Period_ID

N/A

Required Setup

Start time

Enter the start time of the bell schedule item.

[Bell_Schedule_Items]Start_Time

N/A

Required Setup

End time

Enter the end time of the bell schedule item.

Note: Bell schedule items/period times must not overlap in the bell schedule.

[Bell_Schedule_Items]End_Time

N/A

Required Setup

Counts for ADA

Select the checkbox to include attendance recorded for the bell schedule item in attendance calculations.

[Bell_Schedule_Items]ADA_Code

N/A

Required Setup

Use for Daily Attendance

Select the checkbox if the bell schedule item is used to record daily attendance.

[Bell_Schedule_Items] Daily_Attendance_Code

N/A

Required for daily attendance

Default Time In

If the bell schedule item is used for Daily attendance, enter the default start time of the school day.

[Bell_Schedule_Items] Daily_Time_In_Default

N/A

Required for daily attendance

Default Time Out

If the bell schedule item is used for Daily attendance, enter the default end time of the school day.

[Bell_Schedule_Items] Daily_Time_Out_Default

N/A

Required for daily attendance

Assigning Days to Membership Types and Schedules

School Setup > Calendaring: Calendar Setup

Date

The date is view-only on this page. The days included in the calendar are determined by the start date and end date of current school year.

[Calendar_Day]Date

N/A

PSIS

Cycle Day

Choose the appropriate cycle day from the pop-up menu.

[Calendar_Day]Cycle_Day_ID

N/A

PSIS

Bell Schedule

Choose the appropriate bell schedule from the pop-up menu.

[Calendar_Day]Bell_Schedule_ID

N/A

PSIS

School In-Session

Select the checkbox if the calendar day should be counted in attendance calculations.

[Calendar_Day]InSession

N/A

PSIS

Membership Value

Enter the membership value for the calendar day to use when calculating membership.

Note: The value is normally 1 for each day.

[Calendar_Day]MembershipValue

N/A

PSIS

Tracks In-Session

Select the checkboxes for the appropriate tracks.

[Calendar_Day]A, B, C, D, E, F

N/A

Not Required

Type

Choose the appropriate calendar membership type from the pop-up menu.

[Calendar_Day]Type

N/A

Not Required

Note

Enter a note to describe the calendar day.

[Calendar_Day]Note

N/A

Not Required

Define Cycle Days

School Setup > Scheduling: Days > Cycle Days > Edit

Day Letter

The day letter is view-only on this page. To edit the number of days associated with this school year, navigate to School Setup > Years & Terms > Edit School Year.

[Cycle_Day]Letter

N/A

Required Setup

Day Abbreviation

Enter the day abbreviation.

[Cycle_Day]Abbreviation

N/A

Required Setup

Day Name

Enter the day name.

[Cycle_Day]Day_Name

N/A

Required Setup

Adding Graduation Requirement Sets

School Setup > Scheduling: Graduation Sets > New

Name

Enter the name of the Graduation Set.

[GradReqSets]Name

N/A

Graduation Sets > Edit Requirements > Edit Graduation Requirement > New/Edit

Subject Area

Enter the name of the subject area.

[GradReq]SubjectArea

N/A

Requirement Name

Enter the name of the requirement.

[GradReq]Name

N/A

Prerequisite Hours

Enter the number of credit hours to award to the student for meeting this requirement.

[GradReq]ReqCrHrs

N/A

Prerequisite Courses

Choose whether to award credit for courses based on course number, course type, course group, or for any course at all.

[GradReq]CourseSource = listed, credittype, group, or any

[GradReq]CourseListT (course numbers)

[GradReq]CreditType (credit types)

[GradReq]CourseGroup (course group)

N/A

Sort Order

Enter a sort order for this requirement in relation to other requirements in this graduation set.

[GradReq]SortOrder

N/A

Setting up Term Bins

School Setup > Grading: Final Grade/Reporting Term Setup > [New]

If your district or schools use marking period grades for awarding grades and earned credit periodically throughout the term of the course instead of awarding a single final grade and credit at the end of the course, you must set up Term Bins using the New Final Grade setup page and the name of the Term Bins must match the StoreCodes you use to store your marking period grades.

Failure to set your TermBins up properly will result in no grade data being extracted in the TCS – Alternate Grading Method report. You must set up TermBins for every term that has associated courses that use marking periods. 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.

Name

Enter the name of the TermBin you are using for your marking period. This must match the StoreCode you use when you store your marking period grades.

[TermBins]StoreCode

2

Teacher Course Student (TCS)

TCS Alternate Grading Method

Starting Date

Enter the starting date of your TermBin (marking period).

[TermBins]Date1

10

Teacher Course Student (TCS)

TCS Alternate Grading Method

Ending Date

Enter the ending date of your TermBin (marking period)

[TermBins]Date2

10

Teacher Course Student (TCS)

TCS Alternate Grading Method

Adding/Editing a Course Section

School Setup >  Scheduling: Sections > [course] > New/Edit

Course Number

Enter the course number for the section.

[Sections]Course_Number

20

Teacher Course Student (TCS)

Term

Choose the term for the section from the pop-up menu.

[Sections]TermID

N/A

Teacher Course Student (TCS)

Schedule

Select the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

1

Teacher Course Student (TCS)

Teacher

Choose the teacher for the section from the pop-up menu.

[Sections]Teacher

N/A

Teacher Course Student (TCS)

Section Number

Enter the number that identifies this course section.

[Sections]Section_Number

3

Teacher Course Student (TCS)

Section Number (Teacher Course Student Record)

Enter the section number extracted on the Teacher Course Student Record extract. Leave this field blank to extract the local Section Number field value.

[S_CT_SEC_X]TCSSectionNumberOverride

3

Teacher Course Student (TCS)

Exclude Section from TCS Reporting

Select the checkbox to exclude the section from the TCS report.

[Sections]Exclude_State_Rpt_YN

1

Teacher Course Student (TCS)

Use the Marking Period for TCS

Select Yes if this section uses marking periods for awarding grades and credits instead of a single final grade at the end of the course. This setting can be used to override at the school or course setting.

Note: The default for this field is Use Course Preference.

[S_CT_SEC_X]UseMarkingPeriodDates

1

Teacher Course Student (TCS)

TCS Alternate Grading Method

Teacher EIN (Employee Identification Number

Uniquely identifies a teacher within the state reporting system

[S_CT_SEC_X]TeacherEIN

[S_CT_CC_X]TeacherEIN

Teacher Type

Specifies the teacher’s role.

[S_CT_SEC_X]TeacherType

[S_CT_CC_X]TeacherType

ED165 Connecticut School Data Report

Lunch Minutes

Enter the lunch duration.

[S_CT_SCH_X]LunchMinutes

2

ED165 Connecticut School Data Report

Recess

Select this option if Recess is applicable for the students.

[S_CT_SCH_X]Recess

N/A

ED165 Connecticut School Data Report

Highest Grades

Select the highest grade that receives recess when recess is provided.

Note: The highest grade should be less than or equal to 12.

[S_CT_SCH_X]HighestGrade

N/A

ED165 Connecticut School Data Report

Dual Enrollment Code

If this is a dual enrollment course that earns college credit, select the program code from the dropdown list.

[S_CT_SEC_X]DualEnrollPrgmCode

10

Teacher Course Student (TCS)

Civil Rights Data Collection (CRDC)

For instructions on completing the CRDC fields, see CRDC School Setup.