District Setup

Adding District Courses

Courses > [select course] > Edit Course District Information

Courses > Click Course Number or Name

Course Name

Enter the course name.

[Courses]Course_Name

60

Fall/Spring Submission

Course Number

Enter the course number.

[Courses]Course_Number

30

Fall/Spring Submission

Alternate Course Number

Enter the alternate course number.

[Courses]Alt_Course_Number

N/A

Credit Hours

Enter the credit hours for the course.

[Courses]Credit_Hours

N/A

C0010

Local Course Title

Displays the value entered for Course Name.

[Courses]Course_Name

60

Fall/Spring Submission

C0020

Local Course Number

Displays the value entered for Course Number.

[Courses]Course_Number

30

Fall/Spring Submission

C0025

Common Course Number

Enter the state assigned course number.

Note: The 3 letters of the 6-character course number must be uppercase.

[S_IA_CRS_X]Common_Course_Number

6

Fall/Spring Submission

C0030

NCES Course Code

Enter the NCES Course Code.

[Courses]alt_course_number

N/A

Required Setup

C0035

SCED Course Code

Enter the SCED Course Code.

Notes:

• This field must be 11 characters, blank, or equal to 0.

• If the field is 11 characters, the sixth character must be an uppercase letter.

• If Course Origination is 2, 3, 9, or 81, this field cannot be blank or 0.

• This field must not be blank or 0 if Course or Section FTE is greater than 0.000.

[S_IA_CRS_X]SCED_Course_Code

1

Fall/Spring Submission

C0040

Accreditation Program Area

Choose the accreditation program area from the pop-up menu.

See the Appendix for valid values.

[S_IA_CRS_X]Accreditation_Program_Area

1

Fall/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.

Note: 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

8

Fall/Spring Submission

C0120

Course Origination

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

See the Appendix for valid values.

Note: If this field is 2, 5, 6, 7, 12, or 81, FTE must be blank or 0.000.

[S_IA_CRS_X]Course_Origination

2

Fall/Spring Submission

C0130

Course FTE for Supplementary Weighting

Enter the course FTE for supplementary weighting.

Notes:

• This field must be blank or less than 1.000.

• If Course FTE is greater than 0.000, a SCED Course Code must be entered.

• Course FTE must equal 0.000 or blank if Course Origination is 2, 5, 6, 7, 12, or 81.

[Courses]FTE_Supplemental_Weight

5

Fall/Spring Submission

C0150

Credit Recovery Course

Choose if the course is a credit recovery course.

Rolled over from year to year.

The default value is 0.

Valid values are:

• 1 – Yes

• 0 – No

[S_IA_CRS_X]Credit_Recovery

1

Fall/Spring Submission

C0160

Embedded Work-Based Learning

Choose the predominant Embedded Work-Based Learning experience for the course.

[S_IA_CRS_X]Embedded_WBL

2

C0055

This course is a homeroom course

Select the checkbox to indicate this is a homeroom course.

Note: The element C0055 Primary Section Teacher Folder Number is extracted on the Fall/Spring Submission report if this checkbox is selected and the StatePrID field is entered on the Staff > Edit Information page.

[S_IA_CRS_X]Homeroom

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_CRS_X]PK_Program_1_Type

2

Fall/Spring Submission

Preschool Program 1 Hours

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

Notes: This field must be between 0 and 99.9 or blank.

[S_IA_CRS_X]PK_Program_1_Hours

3

Fall/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_CRS_X]PK_Program_2_Type

2

Fall/Spring Submission

Preschool Program 2 Hours

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

Notes: This field must be between 0 and 99.9 or blank.

[S_IA_CRS_X]PK_Program_2_Hours

3

Fall/Spring Submission

District Info

Name of District

Enter the district name.

[Prefs]Name=districtname

[Prefs]Value

N/A

N/A

District Number

Enter the district number.

[Prefs]Name=districtnumber

[Prefs]Value

8

State ID Request

Fall/Spring Submission

Enable Copy PK Field Values Functionality During Year End Rollover

Selectthischeckboxtoautomatically copy student Preschool Program fields to the Students table during the nightly process. Preschool Program fields from the section and/or course are copied to the corresponding student fields for PK students.

Notes:

• Values are only copied for PK students with blank values in the Preschool fields. The values from the student's most recent 2017-2018 course/section enrollment are used.

• The automated process will execute a single time after the preference is enabled.

• To take advantage of this feature, the district preference must be enabled at least one full day prior to performing the PowerSchool Year End Process. Once the Year End Process has run, this feature cannot be used.

[Prefs]CopyPKFields

1

N/A

Entering Districts of Residence

Districts of Residence > [New/Edit] District of Residence

District ID

Enter the district ID.

Note: See the Addendum A1 Resident District documentation on the Iowa Department of Education website for a list of District of Residence values.

[Gen]Cat=districts

[Gen]Value

4

State ID Request

Fall/Spring Submission

District Name

Enter the district name.

[Gen]Cat=districts

[Gen]Name

N/A

N/A

Setting up Entry and Exit Codes

Adding/Editing Entry Codes

Entry Codes > New/Edit Entry Code

Note: See the Appendix for a list of Entry Codes.

Code

Enter the entry code.

[Gen]Cat=entrycodes

[Gen]Name

2

Fall/Spring Submission

Meaning

Enter the entry code meaning.

[Gen]Cat=entrycodes

[Gen]Value

N/A

N/A

Adding/Editing Exit Codes

Exit Codes > New/Edit Exit Code

Note: See the Appendix for a list of Exit Codes.

Code

Enter the exit code.

[Gen]Cat=exitcodes

[Gen]Name

2

Fall/Spring Submission

Meaning

Enter the exit code meaning.

[Gen]Cat=exitcodes

[Gen]ValueT

N/A

N/A

Configuring Federal Ethnicity and Race Settings

Federal Ethnicity and Race Settings

Note: "Race Decline to Specify" settings are not required for Iowa. See the Appendix for a list of Federal Ethnicity and Race Codes.

Entering Federal Race Categories

Federal Ethnicity and Race Settings > Edit/New Federal Race Category

Code

Enter the ethnicity/race code.

Review additional information about import templates and initial setup of the ethnicity/race code.

[Gen]Value

[Gen]Cat=FederalRace

N/A

State ID Request

Fall/Spring Submission

IA Testing Bar Code Input

Description

Enter a description of the ethnicity/race.

Review additional information about import templates and initial setup of the ethnicity/race code.

[Gen]ValueT

[Gen]Cat=FederalRace

N/A

Required Setup

Entering District Race Codes

Federal Ethnicity and Race Settings > Edit/New District Race Code

Note: The District ethnicity and race values display on the Demographics student page. See the Appendix for a list of District Ethnicity and Race Codes.

Code

Enter the ethnicity/race code.

Review additional information about import templates and initial setup of the ethnicity/race code.

[Gen]Name

[Gen]Cat=race

N/A

State ID Request

Fall/Spring Submission

IA Testing Bar Code Input

Description

Enter a description of the ethnicity/race.

Review additional information about import templates and initial setup of the ethnicity/race code.

[Gen]ValueT

[Gen]Cat=race

N/A

Required Setup

Federal Category

Choose the associated federal category from the pop-up menu.

Note: When a District ethnicity/race code is selected on the Demographics student page, the Federal Category associates the appropriate federal ethnicity/race code. For Iowa reporting, the federal ethnicity/race code is extracted.

[Gen]Value

[Gen]Cat=race

N/A

State ID Request

Fall/Spring Submission

IA Testing Bar Code Input

Alt Race Code

Enter an alternate race code. This field can be used to associate SIF ethnicity/race codes, or additional equivalent district ethnicity/race codes.

[Gen]Value2

[Gen]Cat=race

N/A

N/A

Entering School Information

Schools/School Info > [Choose School] > Edit School

School Name

Enter the school name.

[Schools]Name

20

IA Testing Bar Code Input

School Phone Number

Enter the school phone number

[Schools]SchoolPhone

N/A

School Number

Enter the school number.

[Schools]School_Number

4

State ID Request

Fall/Spring Submission

IA Testing Bar Code Input

Alternate School Number

Enter the alternate school number.

[Schools]Alternate_School_Number

4

State ID Request

Fall/Spring Submission

Exclude From State Reporting?

Select the checkbox to exclude the school from state reporting.

[Schools]State_ExcludeFromReporting

N/A

Fall/Spring Submission

IA Testing Bar Code Input

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

All reports

Other Information

District Number Override

This override is intended only for non-public schools within a Diocese comprised of schools with multiple district numbers

Enter the four-digit district number based on the geographic location of your school within a diocese.

Iowa public schools should leave this field blank.

[S_IA_SCH_X]District_Number_Override

4

State ID Request

Entering Other Information

Iowa State Reporting: eTranscript

Sending Building Contact First Name

Enter the first name of the school contact.

[S_IA_SCH_X]Contact_First_Name

N/A

Sending Building Contact Last Name

Enter the last name of the school contact.

[S_IA_SCH_X]Contact_Last_Name

N/A

Maximum GPA

Enter the highest possible GPA a student could obtain.

[S_IA_SCH_X]MAX_GPA

N/A

Non-weighted GPA Method

The GPA method to calculate the Non-weighted GPA (eTranscript Collection).

[S_IA_SCH_X]NwgtGPAMethod

1

Weighted GPA Method

The GPA method to calculate the Weighted GPA (eTranscript Collection).

[S_IA_SCH_X]WgtGPAMethod

1

Iowa Term Store Code Mapping

Click on the link to map StoreCodes. Each school in the district should map a single final grade store code for each scheduling term. Validations now prevent the mapping of multiple store codes to the same scheduling term.

[S_IA_SCH_TermMap_C]YearID

[S_IA_SCH_TermMap_C]TermID

[S_IA_SCH_TermMap_C]StoreCode

Defining Years & Terms

Years & Terms

Years & Terms

Define term names and abbreviations with term beginning and ending dates.

Term names must be defined using the whole word, no abbreviations. For example: year, semester, quarter, trimester, summer, mini. The term name is not case sensitive.

[Terms]FirstDay

[Terms]LastDay

N/A

All reports run at the district.

Setting up Test Details

Tests > Edit/New

Name

Enter the name of the test.

Note: Set up a test with the name ACT for the Fall/Spring Submission report.

[Test]Test_Name = ACT

N/A

Fall/Spring Submission

Type

Choose the type from the pop-up menu.

[Test]Test_Type

N/A

Required Setup

Description

Enter a description of the test.

[Test]Description

N/A

Not Required

Defining Test Scores

Tests > Edit Scores > Edit/New

Name

Enter the name of the test score.

Note: Set up a test score with the name Composite for the Fall/Spring Submission report.

[TestScore]Name = Composite

N/A

Fall/Spring Submission

Sort Order

Enter the sort order, which determines the order the test scores display on the Edit Student Test page.

[TestScore]SortOrder

N/A

Required Setup

Description

Enter a description of the test score.

[TestScore]Description

N/A

Not Required

Configuring Attendance Tracking and Notification

Setting up Tracking Methods

Attendance Tracking and Notification > Tracking Methods

Name

Choose the appropriate value from the pop-up menu.

[Gen]Name=UEAT_Percent

[Gen]Cat=Unexcused

N/A

Required Setup

Threshold

Enter a value for the threshold.

Enter 99 as the threshold for the Percent tracking method to indicate that a student must miss more than 99% of a school day due to unexcused absence to be reported.

[Gen]ValueLi=99

[Gen]Cat=Unexcused

N/A

Required Setup

Setting up Unexcused Tracking Levels

Attendance Tracking and Notification > Unexcused Tracking Levels

N/A

There are no specific IA requirements for this setting; however, it is required to avoid errors when running the Refresh Attendance Tracking Report.

N/A

NA

Required Setup

Setting up Illness Tracking Levels

Attendance Tracking and Notification > Illness Tracking Levels

N/A

There are no specific IA requirements for this setting; however, it is required to avoid errors when running the Refresh Attendance Tracking Report.

N/A

NA

Required Setup