All Master Schedule Templates: How to Complete Template 005

Overview:

Here are the quick instructions for utilizing Template 005 Master Schedule Sections.

Make sure to read the general reporting information for templates before proceeding. Failure to follow these guidelines will result in errors and/or data validation issues.

Before Beginning, Note:

All steps will be completed in Row 7, downwards.

Instructions:

1. Enter the SchoolYear for the data being submitted.

This is the current reporting school year and NOT the calendar year.
- Example: If the reporting school year is 2023-2024, the school year field should be 2024.
Note: Incorrect school year provided will cause data to not be found in Data Exchange.

2. Enter the same SchoolID reporting courses being offered.

See the chart below for more details.

School ID: Public vs. Non-Public Schools

Public

Non-Public

School ID is a ten digit number comprised from current Corporation and State assigned ID

ALL School ID’s start with 10

Next current state assigned Corporation ID - example 1234

Last ends with state assigned School ID 6789

Example School ID: 1012346789

School ID is a ten digit number comprised from current Corporation and State assigned ID

ALL School ID’s start with 10

Next Corporation ID is always four zeros - example 0000

Last ends with state assigned School ID A456 with Alpha converted to number

A=1, B=2, C=3, D=4

Example: School ID: 1000001456

3. Enter the SessionName.

This must match to one of the SessionName that was provided on Template 001 and Template 004, including matching casing and spacing.

4. Enter the LocalCourseCode for each individual course offered.

This must match to the LocalCourseCode that was provided on Template 004, including matching casing and spacing.

5. Enter/Create a SectionIdentifier (letters, numbers only) for each course record.

The SectionIdentifier must be an exact match to the SectionIdentifier provided on Staff Section (template 010) and Student Section (template 018).

6. Enter a SequenceOfCourse.

This is a whole number up to 8 characters indicating the sequence of the course (1, 2, 3, etc)
Examples:
1. Entering “1” for the first semester of Algebra 1, then in the next row, entering “2” for the next semester of Algebra 1.
2. Entering “1” for a year-long course.

6. Enter a MediumOfInstructionDescriptor.

Provide one of the following medium of instruction types for each section of each course reported, using the yellow chart below.
Note: Each section can be uniquely identified as to the type of instruction being taught and does not have to be the same for all sections of the course.
Note: When entering, make sure the name matches EXACTLY what is allowable; caps, lower case, space, etc.

Medium Of Instruction Descriptor	Definition
Face-to-face instruction	Students sitting in the classroom receiving instruction from a teacher
Technology-based instruction in classroom	students physically attending and sitting in a building while receiving instruction through an on-line application like Edmentum, Plato, Apex, etc. This includes credit recovery classrooms.
Virtual/On-line Distance learning	Students enrolled and receiving their education virtually while NOT physically sitting in a classroom in the building. This includes students receiving instruction off-site for dual credit courses at a college or university.

Remember: Templates must be saved as a CSV file (with cells formatted as TEXT) inside of a Compressed Zipped Folder, in order to process correctly.