Skip to main content
Skip table of contents

School Setup

Contents

Introduction

The following data elements are required for school setup. The first two pages of the navigation are omitted for brevity: Start Page > School Setup.

  1. On the Start Page, click the School link. The school list appears.
  2. Choose a school from the pop-up menu. The school start page appears.
  3. Click School. The School Setup page appears.

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Entering Attendance Codes

Attendance Codes

Code

Enter the attendance code abbreviation.

[Attendance_Code]Att_Code

N/A

Fall/Spring Submission

Presence Status

Select Present or Absent as the presence status.

Note: For the Attendance and Tracking Notification function, you must set up attendance codes to track unexcused absences. The presence status for unexcused absences is Absent.

[Attendance_Code]Presence_Status_CD

N/A

Fall/Spring Submission

Code Categories

Select one or more checkbox to associate the attendance code with attendance code categories.

Note: Attendance codes associated with the Unexcused Attendance Code Category are included in the Unexcused Absence calculation for the Fall/Spring Submission report.

[Attendance_Code]ID = [Att_Code_Code_Entity]Attendance_CodeID

[Att_Code_Code_Entity]Code_EntityID = [Code_Entity]ID

[Code_Entity]CE_Code = Unexcused (Present, Excused, etc.)

N/A

Fall/Spring Submission

Earns ADA credit

Select the checkbox to include the attendance code in the attendance calculation.

[Attendance_Code]Calculate_ADA_YN

N/A

Fall/Spring Submission

Counts toward membership

Select the checkbox to include the attendance code in the membership calculation.

[Attendance_Code]Calculate_ADM_YN

N/A

Fall/Spring Submission

Adding Attendance Code Categories

Attendance Code Categories

Note: Attendance code categories are associated with a specific school, but not a specific school year; i.e. they are copied from year to year.

Code

Enter the attendance code category abbreviation.

For the Attendance Tracking and Notification function, you must set up one attendance code category to track unexcused absences.

[Code_Entity]CE_Code

N/A

Required Setup

Name

Enter the name of the attendance code category.

Note: Verify that an attendance code category of Unexcused is set up for each school calculating unexcused absences.

[Code_Entity]External_Name

N/A

Fall/Spring Submission

Setting up Attendance Conversion

Attendance Conversions > New/Edit > Attendance Conversion

Name

Enter the attendance conversion name.

[Attendance_Conversion]Name

N/A

Fall/Spring Submission

Configuring Attendance Conversions

Setting up Period-To-Day Attendance Conversions

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

Note: Attendance conversions must be set up correctly in order to accurately calculate attendance for the Fall/Spring Submission report.

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

Fall/Spring Submission

Setting up Code-To-Day Attendance Conversions

Attendance Conversions > None/Defined > Code-To-Day Attendance Conversion

Note: Attendance conversions must be set up correctly in order to accurately calculate attendance.

Code

Enter 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

Fall/Spring Submission

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

Fall/Spring Submission

Configuring Attendance Mode and Unexcused Tracking Setup

Setting up Attendance Modes

Attendance Tracking and Notification > Attendance Mode Setup > Edit/New

Attendance Mode Value

Choose the attendance mode used as the default for your school:

  • (MPTD) Meeting Period to Day
  • (MTTD) Meeting Time to Day
  • (DCTD) Daily Code to Day
  • (DTTD) Daily Time to Day

[Gen]Value=MPTD, MTTD, DCTD, or DTTD

[Gen]Name=UEAT_Mode

[Gen]Cat=Unexcused

N/A

Required Setup

Setting up Unexcused Tracking

Attendance Tracking and Notification > Unexcused Tracking Setup > Edit/New

Tracking Category

The page displays Unexcused to indicate that the attendance code category selected will be used to track unexcused absences.


NA

N/A

Required Setup

Attendance Category

Choose the attendance code category dedicated to tracking unexcused absences from the pop-up menu.

Attendance code categories can only be used once, so the pop-up menu displays all attendance code categories set up for your school, except for those already associated with an unexcused reporting category.

[Gen]Value

[Gen]Name=UEAT_Category

[Gen]Cat=Unexcused

N/A

Required Setup

Status

Select the radio button for one of the following:

  • Absent – Indicates that this unexcused tracking category is used to track absences.

[Gen]Value2=Absent

[Gen]Name=UEAT_Category

[Gen]Cat=Unexcused

N/A

Required Setup

Entering Full-Time Equivalencies

Full-Time Equivalencies (FTE)

Note: An FTE must be set up and assigned to each student in order to calculate attendance.

Name

Enter the FTE name.

[FTE]Name

N/A

Fall/Spring Submission

Default Attendance Mode

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

[FTE]Dflt_Att_Mode_Code

N/A

Fall/Spring Submission

Default Attendance Conversion

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

[FTE]Dflt_Conversion_Mode_Code

N/A

Fall/Spring Submission

Setting Attendance Preferences

Attendance Preferences

Note: Attendance preference must be set up correctly in order to accurately calculate attendance.

Attendance Recording Methods

Select the Meeting checkbox to enable meeting attendance.

Select the Daily checkbox to enable daily attendance.

[Prefs]Value

where [Prefs]Name=ATT_RecordModeMeeting

[Prefs]Value

where [Prefs]Name=ATT_RecordModeDaily

N/A

[Fall/Spring Submission

Count these codes for period conversion

Choose Absences or Presents from the 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

Fall/Spring Submission

Defining Bell Schedules

School Setup > Bell Schedules

Note: Bell schedules must be set up correctly in order to accurately calculate attendance.

Name

Enter the bell schedule name.

[Bell_Schedule]Name

N/A

Fall/Spring Submission

Attendance Conversion Method

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

[Bell_Schedule]Attendance_Conversion_ID

N/A

Fall/Spring Submission

Setting up the School Calendar

Calendar Setup

Note: The calendar must be set up correctly in order to accurately calculate attendance and membership.

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 set up. To edit the number of days in the school year, navigate to School Setup > Years & Terms.

[Calendar_Day]Date

N/A

Fall/Spring Submission

Day

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

[Calendar_Day]Cycle_Day_ID

N/A

Fall/Spring Submission

Schedule

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

[Calendar_Day]Bell_Schedule_ID

N/A

Fall/Spring Submission

In Sess

Select the checkbox to include the calendar day in attendance calculations.

[Calendar_Day]InSession

N/A

Fall/Spring Submission

MembValue

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

Fall/Spring Submission

Defining Cycle Days

Cycle Days

Note: Cycle days must be set up correctly in order to accurately calculate attendance.

Day Letter

The day letter is view-only. 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

Fall/Spring Submission

Day Name

Enter the day name.

[Cycle_Day]Day_Name

N/A

Required Setup

Defining Schedule Periods

Periods

Note: Periods must be set up correctly in order to accurately calculate attendance.

Period Number

The period number is view-only. To edit the number of periods associated with this school year, navigate to School Setup > Years & Terms > Edit School Year.

[Period]Period_Number

N/A

Required Setup

Period Abbreviation

Enter the period abbreviation.

[Period]Abbreviation

N/A

Fall/Spring Submission

Period Name

Enter the period name.

[Period]Name

N/A

Required Setup

Defining Course Sections

Sections > [select course] > [select section] > Edit Section

Course Number

Enter the course number for the section.

[Sections]Course_Number

30

Fall/Spring Submission

Term

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

[Sections]TermID

N/A

Fall/Spring Submission

Schedule

Select the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

N/A

Required Setup

Teacher

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

[Sections]Teacher

N/A

Fall/Spring Submission

Section Number

Enter the section number.

[Sections]Section_Number

6

Fall/Spring Submission

Iowa State Report Information

C0045

Section Delivery Method

Choose the delivery method of the section of the course from the pop-up menu.

The default value is 1.

Valid values are:

  • Blank
  • 1 – Face to Face
  • 2 – Internet/Online
  • 3 – ICN
  • 4 – IPTV (Not applicable for school year 2021-22)
  • 5 – Satellite
  • 6 – Other
  • 7 – Face to Face on college site
  • 8 - Blended

[S_IA_SEC_X]Section_Delivery_Method

1

Fall/Spring Submission

Preschool Program 1 Type

Choose the Preschool Program 1 Type from the pop-up menu.

The default value is 99 - Not Applicable

See the Appendix for valid values.

[S_IA_SEC_X]PK_Program_1_Type2Fall/Spring Submission
Preschool Program 1 Hours

Enter the number of hours per week a student attends Preschool Program 1.

[S_IA_SEC_X]PK_Program_1_Hours3Fall/Spring Submission
Preschool Program 1 Type Session

Entertheuserdefinedcodefor this preschool session.

Notes: If a value is entered into this field, then Preschool Program 1 Type and Preschool Program 1 Hours at either the section or course level must also contain non-blank values.

[S_IA_SEC_X]PK_Program_1_Session20Fall/Spring Submission
Preschool Program 2 Type

Choose the Preschool Program 2 Type from the pop-up menu.

The default value is 99 - Not Applicable

See the Appendix for valid values..

[S_IA_SEC_X]PK_Program_2_Type2Fall/Spring Submission
Preschool Program 2 Hours

Enter the number of hours per week a student attends Preschool Program 2.

This field must be between 0 and 99.9 or blank.

[S_IA_SEC_X]PK_Program_2_Hours3Fall/Spring Submission
Preschool Program 2 Type Session

Entertheuserdefinedcodefor this preschool session.

Notes: If a value is entered into this field, then Preschool Program 2 Type and Preschool Program 2 Hours at either the section or course level must also contain non-blank values.

[S_IA_SEC_X]PK_Program_2_Session20Fall/Spring Submission

C0050

Institution Providing Section

Choose the institution providing the section of the course from the pop-up menu, or enter the district number.

The reports will show the district number plus 0000, or a 6-digit IPEDS code.

[S_IA_CRS_X]PSEOA_Provider

[S_IA_CRS_X]PSEOA_District

8Fall/Spring Submission

C0120

Section Origination

Choose the type of course from the pop-up menu.

See the Appendix for valid values.

Notes:

  • If a value is entered into this field, the SCED Course Code cannot be blank or 0. See the District Setup Coursessectionformoreinfomration on SCED Course Codes.
  • If this field is 2, 5, 6, 7, 12, or 81, FTE must be blank or 0.000.

[S_IA_SEC_X]Course_Origination

2

Fall/Spring Submission

C0130

Section FTE for Supplementary Weighting

Enter the course section FTE for supplementary weighting

Notes:

  • This field must be blank or less than 1.000.
  • Section FTE must equal 0.000 or blank if Section Origination is 2, 5, 6, 7, 12, or 81.

[S_IA_SEC_X]FTE_Supplemental_Weight

5

Fall/Spring Submission

Setting up Years & Terms

Years & Terms > New/Edit Terms

Name

Enter the name of the term.

[Terms]Name

N/A

Required Setup

Abbreviation

Enter an abbreviation for the term.

[Terms]Abbreviation

N/A

Required Setup


First Day of Term

Enter the first day of the term.

[Terms]FirstDay

N/A

All reports

Last Day of Term

Enter the last day of the term.

[Terms]LastDay

N/A

All reports

JavaScript errors detected

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

If this problem persists, please contact our support.