District Setup

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Compliance

District Management, District Setup, District Info, Compliance Tab

Include Virtual Attendance?

Select to include virtual attendance in the Historic Attendce Information, Hours Attended Regular, and Hours Absent Regular sections.

MO_IncludeVirtualAttendFlag

1

A+ BETA

Defining Co-Teaching Information

System Setup > Roles Administration > Co-Teaching Information

PowerSchool includes five predefined co-teaching roles. The role of Lead Teacher is currently the only role that can be assigned to a section's Section Lead teacher. It is required that the PowerSchool role of Lead Teacher be modified to add the Position Code 60 in the Code field. The four remaining PowerSchool roles may be modified to match the name and description of state Position Code or deleted if the role will not be used. Additional state defined roles may be created if desired by the District.

Lead Teacher

The Role as defined by PowerSchool. This Role can be renamed but will remain as the only Role available for Lead Teacher in a section.

[RoleDef]Name

100

Course Assign

Student Assign

Course Completion

Reference Code

Enter the Position Code 60 for Teachers. All other Roles can be assigned different Position Codes as they relate to the use of that Role.

Note: The Short Name for Reference Code should be defined as Code.

Navigation:

System Management > Security > User > User Roles > Co-Teaching > Configure Table > Code

[RoleAvailableProperty]Code

2

Course Assign

Student Assign

Course Completion

Defining District Courses

Courses > [New/Edit]Courses

Missouri State Course Information

^State information entered at the Section level will over-ride information at the course level.

Position Code/Description

Choose the Position Code required for this course. This field will over-ride the Position Code designated in the Roles Administration.

When there is an additional teacher assigned (not the Lead Teacher), the additional teachers position code will be taken from the code in the Roles Administration.

[S_MO_CRS_X]PositionCode

2

Educator School

Course Assign

Student Assign

Course Completion

CTE Program Type^

Choose the Program Type from the pop-up menu.

Note: For code sets go to MO Core Data/MOSIS

[S_MO_CRS_X]ProgType

4

Course Assign

Course Completion

State Course Number

State Course code that identifies assignment.

• Every assignment/course must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. Create separate assignments/courses in situations where a teacher has more than one grade in a self-contained elementary classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes.

• For Co-Teaching Delivery System only, Course Code 195000 (Direct Service/Inst Spec Ed Core) will be entered into the additional teachers Course Assignment record.
  

[S_MO_CRS_X]StateCourseNumber

6

Course Assign

Student Assign

Course Completion

Course Sequence Number

Enter the course sequence number that identifies the content of the course.

Sequence number that identifies the content of courses taught at more than one level. If only one level of course content is offered, leave Course Sequence Number blank.

[S_MO_CRS_X]CourseSeqNum

1

Course Assign

Course Completion

Course Grade Level^

Choose the course grade level.

Grade level should reflect the grade at which the course curriculum is offered, which is not necessarily the grade level of the students in the classroom.

[S_MO_CRS_X]CourseGrade

6

Course Assign

Semester^

Choose the portion of the year during which the course is taken from the pop-up menu.

Valid values:

• 1 – 1^st Semester

• 2 – 2^nd Semester

• 3 – 3^rd Semester

• 0 or [blank]– Full Year

[S_MO_CRS_X]Semester

1

Course Assign

Course Completion

Delivery System^

Choose the course delivery system from the pop-up menu.

• For code sets go to MO Core Data/MOSIS

• For students in grades K-5 if this value is V - Virtual Class or VH - Before/After School Virtual Classes, then the Virtual Provider details are included in the Student Course Completion Report. However, the section value overrides this value.

[S_MO_CRS_X]DeliverySystem

2

Course Assign

Virtual Provider

Choose the Virtual Provider Name from the list.

[S_MO_CRS_X]VirtualProvider

2

Course Completion

Other Virtual Provider

Enter the name of the Virtual Provider that is not in the Virtual Provider Name list. This field becomes mandatory when 15 - Other is selected for the Virtual Provider field.

[S_MO_CRS_X]OtherVirtualProvider

60

Course Completion

Combined Class^

Enter 00-99 to designate that the course is a combined class. All courses taught during the same time period must have the same Combined Class number.

Combined classes are situations where students of two or more different subjects or course sequence levels (or grade levels for self-contained elementary classes) are taught during the same time period by the same teacher.

[S_MO_CRS_X]CombinedClass

2

Course Assign

Course Program Code^

Choose the course program code from the pop-up menu.

Note: If code “50 – MOVIP” is selected, ED SSN in the Course Assignment Report is output as blank.

Note: For code sets go to MO Core Data/MOSIS

[S_MO_CRS_X]ProgramCode

2

Course Assign

Section Minutes Per Week^

Enter the minutes of the course per week.

[S_MO_CRS_X]MinperWeek

4

Course Assign

Advanced Placement

Choose Yes or No from the pop-up menu to indicate if the course is advanced placement.

Note: DESE has created State Course Codes specific to AP courses.

[S_MO_CRS_X]AdvPlacement

1

Course Completion

Honors

Choose Yes or No from the pop-up menu to indicate if the course is designated as honors level.

[S_MO_CRS_X]Honors

1

Course Completion

Course Assignment Comment^

Free-form notes used to indicate (1) job titles for Course 887900, (2) course titles for "Other" (xxxx99) courses, (3) supplemental assignment for Course 880000, (4) teachers assisted by an aide, (5) aides assisting a teacher or (6) other nonstandard info

[S_MO_CRS_X]Assn_Comment

70

Course Assign

Course Completion^ Comment

Enter general comments used to indicate job titles, course titles, supplemental assignments, teachers assigned by an aide, aides assisting a teacher, or other non-standard information.

[S_MO_CRS_X]CrsCompComment

70

Course Completion

Course Total Hours^

(For Summer School Only)

The total number of hours the class meets during the full duration of the summer school program, normally 60-120 hours.

Note: This element is reported for the June reporting cycle only.

[S_MO_CRS_X]CourseTotalHours

3

June Course Assign

Tracking Virtual Course Attendance

Virtual Course Attendance Tracking

Note: Detailed instructions for Virtual Course Attendance Tracking can be found in the Virtual Attendance Setup section of School Setup.

Virtual Attendance Award^ (47% of the hours for a regular class.)

Enter the number of hours to be awarded to students in virtual courses. The award is calculated by multiplying the total number of hours for a regular education class by .47.

Example: A regular ed class meets for a total of 100 hours. The Virtual Attendance Award entered would be 47.

Note: Data may be entered to the fourth decimal place.

[S_MO_CRS_X]VirtualHours

10

Student Enrollment and Attendance

Reporting School

Enter the school number to be used if the virtual course is not held in the same school where the teacher is assigned. The course will be reported from the school number in this field.

[S_MO_CRS_X]ReportingSchool

6

Course Assignment

Student Assignment

Course Completion

Defining Assessment Pre-Code Course Information

Assessment Pre-Code Course Information

Assessment Type^

Choose the assessment the students enrolled in this course plan to complete from the pop-up menu.

Valid values:

• EOC

• MAP

• LEP/ELL

• ACT

[S_MO_CRS_X]AssessmentType

6

Assessment Pre-Code

Subject

Choose the EOC Subject that will be taken at the end of the course.

Note: For code sets go to MO Core Data/MOSIS

[S_MO_CRS_X]EOCSubject

6

Assessment Pre-Code

(Required for EOC)

Examiner Email Override*

Enter email address to be reported on the Assessment Pre-Code if the teacher email should not be used.

[S_MO_CRS_X]ExamEmailOverride

60

Assessment Pre-Code

(Required for EOC)

Testing Method^

Choose the testing method for the assessment from the pop-up menu.

Valid values:

• Pencil/Paper

• Online

[S_MO_CRS_X]TestMethod

6

Assessment Pre-Code

(Required for EOC)

Exclude from State Reporting

Select the checkbox to exclude the course from being included in the reports listed to the right.

[S_MO_CRS_X]State_ExcludeFromReporting

1

Course Assign

Student Assign

Course Completion

Creating Entry Codes

District Setup > Code Sets > EntryCode

Code set

Select the Code set type.

[CODESET]CODETYPE=EntryCode

Code

Enter the entry code.

[CODESET]Code

2

Enrollment & Attendance

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the entry code description.

[CODESET]Description

N/A

Required Setup

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate

8

Creating Exit Codes

District Setup > Code Sets > ExitCode

Code set

Select the Code set type.

[CODESET]CODETYPE=ExitCode

Code

Enter the exit code.

[CODESET]Code

2

Enrollment & Attendance

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the exit code meaning.

[CODESET]Description

N/A

Required Setup

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate8

8

Defining Discipline Logs

Log Types > Edit Log Type

Log Type

Enter Discipline to create a log type for discipline incidents.

[Gen]Name

[Gen]Cat=logtype

N/A

Student Discipline Incident

Creating Scheduling/Reporting Ethnicity Codes

Scheduling/Reporting Ethnicity Codes > Edit/New Ethnicity Code

Code

Enter the ethnicity code.

Note: This field is no longer used for state reporting purposes.

[Gen]Value

[Gen]Cat=ethnicity

2

Required Setup

Description

Enter the ethnicity description.

Note: This field is no longer used for state reporting purposes.

[Gen]Name

[Gen]Cat=ethnicity

N/A

Required Setup

Defining District Schools

Schools/School Info > Edit School > Missouri State School Information

Exclude From State Reporting?

Select the checkbox to exclude the school from state reporting.

[Schools]State_ExcludeFromReporting

N/A

Uniq-ID State ID Request

Att Hrs by School & Grade

Educator Core

Educator School

Course Assign

Grad Follow-up

Course Completion

Grades

Enter the school grades (lowest - highest).

Note: Grade levels must be in the range -10 to 20.

[Schools]Low_Grade

[Schools]High_Grade

2

Att Hrs by School & Grade

Actual Attendance Hours (from DESE Screen 10)

Enter the total hours of attendance possible for a full-time student as shown on DESE Screen 10.

[S_MO_SCH_X]CalendarHours

10

Student Enrollment and Attendance

GPA Scale

Choose the GPA Scale from the pop-up menu.

[S_MO_SCH_X]GPAScale

N/A

Student Core

GPA Grade Scale

Choose the GPA Grade Scale from the pop-up menu.

[S_MO_SCH_X]School_GPAScale

Student Core

Special Programs > Special Program Information – NO LONGER USED FOR STATE REPORTING

Adding GPA Calculation Methods

GPA Calculations > Calculation Methods > New GPA Calculation Method

Method Name

Enter APlusGPA.

[Gen]Name

[Gen]Cat=gpacalcmethod

N/A

Required for A+ Program

GPA Calculation

It is recommended to use the Simple GPA formula:

round((sum(gpa_gpapoints())/gpa_count()),4)

Note: For districts that offer the A+ scholarship program, a GPA calculation named APlusGPA must be defined.

[Gen]ValueT

[Gen]Cat=gpacalcmethod

N/A

Calculation Type

Choose Cumulative from the pop-up menu.

[Gen]Value

[Gen]Cat=gpacalcmethod

N/A

Terms

Enter S1,S2.

[Gen]queryterms

[Gen]Cat=gpacalcmethod

N/A

Grade Levels

Enter 9,10,11,12.

[Gen]querygrades

[Gen]Cat=gpacalcmethod

N/A

Only include grades

Select the checkbox that count in GPA.

[Gen]queryflaggpa

[Gen]Cat=gpacalcmethod

N/A

Creating/Editing Tests

Grading > [New/Edit]Tests

This section includes the required ASVAB Test configuration to support the June ASVAB Report submission.

The Test Name must be entered exactly as specified. Districts with existing ASVAB test records can modify the Test Name and/or Test Score Names as needed to match the required naming conventions provided below.

Name

Enter ASVAB as the Test Name.

[Test]Name

35

ASVAB Report

Type

Select National from the dropdown list. Optional element.

[Test]Test_Type

Description

Enter the test description. Optional element.

[Test]Description

Editing Test Scores

Test > [New/Edit]Edit Scores

Test Score Names must be entered exactly as listed. The Test Score Names use the same naming conventions as the column header values in the state ASVAB Excel template. All Test Score Names are entered as a single word with no spaces, underscores, or other characters.

Name

Enter each Test Score Name exactly as appears below under Test Score Name to Enter. All Test Score Names are entered as a single word with no spaces, underscores, or other characters.

[TestScore]Name

35

ASVAB Report

Sort Order

Enter the number for the desired sort order. This value can be assigned as the district sees fit.

[TestScore]SortOrder

Description

Optional element.

[TestScore]Description

Test Score

Test Score Name to Enter

Verbal Skills

VerbalSkills

[TestScore]Name

35

ASVAB Report

Math Skills

MathSkills

[TestScore]Name

35

ASVAB Report

Science and Tech Skills

SnTSkills

[TestScore]Name

35

ASVAB Report

General Science

GeneralScience

[TestScore]Name

35

ASVAB Report

Arithmetic Reasoning

ArithmeticReasoning

[TestScore]Name

35

ASVAB Report

Word Knowledge

WordKnowledge

[TestScore]Name

35

ASVAB Report

Paragraph Comprehension

ParaComprehension

[TestScore]Name

35

ASVAB Report

Mathematics Knowledge

MathKnowledge

[TestScore]Name

35

ASVAB Report

Electronics Information

ElectronicsInfo

[TestScore]Name

35

ASVAB Report

Auto and Shop Information

AutoShopInfo

[TestScore]Name

35

ASVAB Report

Mechanical Comprehension

MechComprehension

[TestScore]Name

35

ASVAB Report

Military Entrance Score

EntranceScore

[TestScore]Name

35

ASVAB Report