Skip to main content
Skip table of contents

School Setup

Introduction

The following data elements are required for state reporting.

To navigate to the school setup page:

  1. Click the School link at the top of the page. The School pop-up menu appears.
  2. Choose a school. The school Start Page appears.
  3. Under School, click Setup.

Note: The following information describes the setup required for State Reporting. For information about general school setup, see Help > System Help.

Data Element

Additional Information

[Table]FieldName

Length

Used in These Reports

Entering Attendance Codes

Attendance Codes > [New/Edit] > Attendance Code

Code

Enter the attendance code.

[Attendance_Code]Att_Code

N/A

MI 10/30 Day – By Class

MI 10/30 Day – By Period

Description

Enter the attendance code description.

[Attendance_Code]Description

N/A

MI 10/30 Day – By Class

MI 10/30 Day – By Period

Presence Status

Select the checkbox whether the attendance code should be categorized as present or absent.

[Attendance_Code]Presence_Status_CD

N/A

N/A

Code CategoriesSelect the checkbox for the appropriate attendance code category.N/AN/AN/A

Points

Enter the number of points associated with the attendance code – can be used to withhold credit when awarding grades.

[Attendance_Code]Course_Credit_Points

N/A 

N/A
Teacher can assignChoose Yes or No from the pop-up menu to determine whether the teacher can assign the attendance code.[Attendance_Code]Assignment_Filter_YN

N/A 

N/A

This attendance code is considered in ADA calculations

Select the checkbox if this attendance code counts towards ADA calculations.

[Attendance_Code]Calculate_ADA_YN

N/A

N/A

This attendance code counts towards membership

Select the checkbox if this attendance code counts towards ADM calculations.

[Attendance_Code]Calculate_ADM_YN

N/A

N/A

Sort Order for display

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

[Attendance_Code]SortOrder

N/A

N/A

Configuring Attendance Conversion Settings

Defining Attendance Conversions

Attendance Conversions > [New/Edit] > Attendance Conversion

Name

Enter the attendance conversion name.

[Attendance_Conversion]Name

N/A

N/A

Defining Period-To-Day Attendance Conversions

Attendance Conversions > [None/Defined] > Period-To-Day Attendance Conversion

Day Attendance Value

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

[Attendance_Conversion_Items] Conversion_Mode_Code=periodDay

[Attendance_Conversion_Items]Attendance_Value

N/A

N/A

Adding Full-Time Equivalencies

Full-Time Equivalencies (FTE) > [New/Edit] > FTE Code

Name

Enter the FTE name.

[FTE]Name

N/A

N/A

Default Attendance Mode

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

Valid values:

  • Meeting
  • Daily

[FTE]Dflt_Att_Mode_Code

N/A

N/A

Default Attendance Conversion

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

Valid values:

  • Period to Day
  • Time to Day

[FTE]Dflt_Conversion_Mode_Code

N/A

N/A

Creating Bell Schedules

Bell Schedules > [New]

Name

Enter the bell schedule name.

[Bell_Schedule_Items]Name

N/A

N/A

Attendance Conversion Method

Choose the attendance conversion method.

[Bell_Schedule_Items]Attendance_Conversion_ID

N/A

N/A

Adding Bell Schedule Periods

Bell Schedules > Edit Schedule > [New/Edit] Period

Period

Choose the period number.

[Bell_Schedule_Items]Period_ID

1

N/A

Start Time

Enter the start time of the period.

[Bell_Schedule_Items]Start_Time

N/A

N/A

End Time

Enter the end time of the period.

[Bell_Schedule_Items]End_Time

N/A

N/A

Counts for ADA

Select the checkbox if the period counts for ADA.

[Bell_Schedule_Items]ADA_Code

1

N/A

Setting Up the School Calendar

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 the current school year as defined in Years & Terms.

[Calendar_Day]Date

N/A

MI 75% Membership

Cycle Day

Choose the cycle day.

[Calendar_Day]Cycle_Day_ID

N/A

N/A

Bell Schedule

Choose the bell schedule.

[Calendar_Day]Bell_Schedule_ID

N/A

N/A

School In-Session

Select the checkbox if the date is an in-session day for all students on this date.

[Calendar_Day]InSession

N/A

N/A

Membership Value

Enter the membership value.

[Calendar_Day]MembershipValue

N/A

N/A

Tracks In-Session

Select the checkbox(es) for appropriate track(s).

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

N/A

N/A

Type

Choose the type of day.

Valid values:

  • Holiday
  • In Session
  • MI Forgiven Day
  • MI Unforgiven Day

[Calendar_Day]Type

N/A

MI 75% Membership

Note

Enter any notes for the day.

[Calendar_Day]Note

N/A

MI 75% Membership

Creating Course Sections

Sections > [Select Course] > [New/Select Section]

Course Number

Enter the course number.

[Sections]Course_Number

Max 11

N/A

Schedule

Select the checkboxes for the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

N/A

N/A

Term

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

[Sections]TermID

N/A

N/A

Teacher – Section Lead

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

[Sections]Teacher

N/A

N/A

Teachers/Staff – Additional

Choose the teacher from the pop-up menu.

[SectionTeacher]TeacherID

N/A

N/A

Section Number

Enter the section number.

[Sections]Section_Number

Max 10

N/A

Exclude From Attendance

(Optional: Use only to exclude this section from counting towards ADM/ADA for students.)

Select the checkbox to exclude the section from attendance.

[Sections]Exclude_ADA

N/A

N/A

Exclude From Storing Final Grades

(Use for Sections that are not graded so blank records are not stored with final grades.)

Select the checkbox to exclude from storing final grades.

[Sections]ExcludeFromStoredGrades

N/A

N/A

Grade Scale

Choose the grade scale.

[Sections]GradeScaleID

N/A

N/A

Exclude From Teacher Student Data Link

Choose Yes (1) or No (0) to indicate whether to include or exclude the section from the Teacher Student Data Link.

[S_MI_SEC_TSDL_X]ExcludeTSDL

1

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Exclude from Ed-FiSelect Yes (1) to exclude the section from publishing to Ed-Fi. The value set for the course is displayed next to this field. [Sections.S_SEC_X]excludeFromEdfi1
SCED Subject Area CodeThis field is moved to the Obsolete section.[Courses.S_MI_CRS_TSDL_X]NCESsubjectArea

SCED Course Identifier CodeThis field is moved to the Obsolete section.[Courses.S_MI_CRS_TSDL_X]NCEScourseId

MSIX Course Section ID

Choose the MSIX course section ID.

Valid values:

  • 01 - Full Year
  • 02 - Section A
  • 03 - Section B
[S_MI_SEC_TSDL_X]MSIXCourseSectionID2

Co-Teacher PIC 1

Choose the Co-Teacher.

[S_MI_SEC_TSDL_X]CoTeacher1

12

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Co-Teacher PIC 2

Choose the Co-Teacher.

[S_MI_SEC_TSDL_X]CoTeacher2

12

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Virtual Method

Choose the code that represents the Virtual Delivery method of the course if applicable.

Valid values:

  • BL - Blended Learning
  • DL - Digital Learning
  • OC - Online Course
  • NV - Not Virtual

[S_MI_SEC_TSDL_X]VirtualDelivery

4

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Virtual Course Mentor PIC 1

Choose the Mentor Teacher.

[S_MI_SEC_TSDL_X]MentorTeacher1

12

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Virtual Course Mentor PIC 2

Choose the Mentor Teacher.

[S_MI_SEC_TSDL_X]MentorTeacher2

12

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Virtual Course Mentor PIC 3

Choose the Mentor Teacher.

[S_MI_SEC_TSDL_X]MentorTeacher3

12

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Course Funding Program

Choose the course funding type.

Values:

  • Blank (Default)
  • 01 - Sec 23a Dropout Recovery

Note: If course funding program is set at both section and course then section code is used.

[S_MI_SEC_TSDL_X]CrsFundingPrgm5MI Teacher Student Data Link (TSDL)
College Credit (potential)

Enter the number of potential college credits the students earn for this course.

  • Decimal number data type with a fixed-length format: N.NN
  • Minimum value: 0.00
  • Maximum value: 25.00
[S_MI_SEC_TSDL_X]CollegeCredits24MI Teacher Student Data Link (TSDL)

Defining Years & Terms (For the Teacher Student Data Link (TSDL) Report store codes)

NOTE: The Teacher Student Data Link (TSDL) file is no longer updated beginning with the 2023-2024 school year.


Years & Terms > Term Setup > [New/Edit Terms]

If using the new TSDL report, define the store codes in the School > Final Grade/Reporting Term Setup > [New/Edit Final Grade Name].

Name of Term

Enter the name of the term.

[Terms]Name

N/A

N/A

Abbreviation

Enter an abbreviation for the term.

[Terms]Abbreviation

N/A

N/A

First Day of Term

Enter the first day of the term.

[Terms]FirstDay

N/A

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Last Day of Term

Enter the last day of the term.

[Terms]LastDay

N/A

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Michigan TSDL store code (e.g. S1)Enter the store code that denotes where the official grade for sections of this term length should be pulled from.[S_MI_TRM_TSDL_X]StoreCode10

MI Teacher Student Data Link (TSDL)

MI MSDS Setup Validation

MI Teacher Student Data Link (TSDL) Validation

Defining Final Grade/Reporting Term Setup (For the new TSDL Report store codes)

Final Grade/Reporting Term Setup > [New/Edit Final Grade Name]

If using the old TSDL report, define the store codes in the Years & Terms > Term Setup > [New/Edit Terms]

Name (e.g. S1)

Enter a name for this final grade, such as Y1.

Remote Enrollment: This final grade name must match a final grade name at the student home school in order to store grades.

[TermBins]StoreCode

3

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Starting Date

Enter the starting date to indicate the date the term begins using the format mm/dd/yyyy.

[TermBins]Date1

date

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Ending Date

Enter the ending date to indicate the date the term ends using the format mm/dd/yyyy.

[TermBins]Date2

date

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Suppress Letter Grade Display

Select the checkbox if you do not want to display letter grades in the system and on reports. Only percentage grades appear.

[TermBins]SuppressLtrGrd

1


Suppress Percent Display


Select the checkbox if you do not want to display percent grades in the system on reports. Only letter grades appear.[TermBins]SuppressPercentScr1

At Or Above This Level Of Attendance Points

Enter a level of attendance points for the given date range to automatically affect students' grades due to attendance. Otherwise, enter 0 or leave the field blank.

[TermBins]numattpoints

5


Change A Student's Grade ToEnter the grade that students receive after meeting or exceeding the attendance points indicated in the previous field.[TermBins]changegradeto5
Include Final Grade in TSDL reportingCheck the box to determine that this Name is one of the official grades that will be pulled for sections of this term length and Name.[S_MI_TRB_TSDL_X]includeTSDL1

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Grade Levels included for this Final Grade:

Select the grade levels that will be reporting the term store code grade level for Teacher Student Data Link (TSDL).

If no grade levels are selected all grade levels will use this final grade if the 'Include Final Grade in TSDL reporting' checkbox is selected.

[S_MI_TRB_TSDL_X]TSDLgrade500

MI Teacher Student Data Link (TSDL)

MI Teacher Student Data Link (TSDL) Validation

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.