EDS School Setup
The following data elements are required for school setup. The first two pages of navigation are removed for brevity:
Start Page > School Setup.
- On the Start Page, click the School link. The school list appears.
- Choose a school from the pop-up menu. The school start page appears.
- Click School. The School Setup page appears.
Note: For more information on code values, see the Appendix.
Data Element | Additional Information | [Table]FieldName | Used in these Reports |
Code | Enter the attendance code abbreviation. | [Attendance_Code]Att_Code | AzEDS: StudentSchoolAttendanceEvent StudentSectionAttendanceEvent |
Description | Enter the attendance code description. | [Attendance_Code]Description | Required Setup AzEDS: StudentSchoolAttendanceEvent StudentSectionAttendanceEvent |
Presence Status | Select Present or Absent as the presence status. | [Attendance_Code]Presence_Status_CD | AzEDS: StudentSchoolAttendanceEvent |
Code Categories | Select the checkboxes for the appropriate attendance code categories. Associate absence codes to either the Excused or the Unexcused attendance code categories to properly report absences to SAIS (AbsenceReasonCode, 1 = Excused, 2 = Unexcused). | [Att_Code_Code_Entity]Code_EntityID | AzEDS: StudentSchoolAttendanceEvent |
Earns ADA credit | Select whether the attendance code affects attendance calculation. | [Attendance_Code]Calculate_ADA_YN | AzEDS: StudentSchoolAttendanceEvent |
Counts toward membership | Select whether the attendance code affects membership calculation. | [Attendance_Code]Calculate_ADM_YN | AzEDS: StudentSchoolAttendanceEvent |
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 | AzEDS: Required Setup |
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. | [Code_Entity]CE_Code | AzEDS: StudentSchoolAttendanceEvent |
Name | Enter the name of the attendance code category. Note: The attendance code categories Excused, Unexcused and Tardy are set up by default and cannot be deleted. The Excused attendance code category is used to determine AbsenceReasonCode in SAIS absence transactions. ** The name field of the Excused attendance code category should not be changed, in order for AbsenceReasonCode to be calculated correctly. | [Code_Entity]External_Name | AzEDS: StudentSchoolAttendanceEvent |
Description | Enter a description for the attendance code category. | [Code_Entity]Description | Required Setup |
Sort Order | Choose the sort order from the pop-up menu to determine where the attendance code category displays on the page. | [Code_Entity]SortOrder | Required Setup |
Name | Enter the attendance conversion name. | [Attendance_Conversion]Name | AzEDS: |
Day Attendance Value | Enter the day attendance value for the period-to-day attendance conversion for the FTE. Attendance values must be 0.00, 0.25, 0.50, 0.75, 1.00, or 1.25 to comply with SAIS guidelines. Report full-day students as 1.00, regular (or half-day) kindergarten students as 0.50 and preschool students as 1.00. Each of these groups of students should be assigned a separate FTE, with a separate associated attendance conversion. | [Attendance_Conversion_Items] Conversion_Mode_Code=periodday [Attendance_Conversion_Items] Attendance_Value | AzEDS: StudentSchoolAttendanceEvent |
Attendance Conversions > Time (Time-To-Day Attendance Conversion) | |||
Minutes Present | Enter the minutes present for the time-to-day attendance conversion. | [Attendance_Conversion_Items] Conversion_Mode_Code=timeday [Attendance_Conversion_Items]Input_Value | AzEDS: StudentSchoolAttendanceEvent |
Day Attendance Value | Enter the day attendance value for the time attendance conversion. Attendance values must be 0.00, 0.25, 0.50, 0.75, 1.00, or 1.25 to comply with SAIS guidelines. Report full-day students as 1.00, regular (or half-day) kindergarten students as 0.50 and preschool students as 1.00. Each of these groups of students should be assigned a separate FTE, with a separate associated attendance conversion. | [Attendance_Conversion_Items] Conversion_Mode_Code=timeday [Attendance_Conversion_Items] Attendance_Value | AzEDS: StudentSchoolAttendanceEvent |
Name | Enter the FTE name. Note: SAIS requires FTE values to be submitted for kindergarten and preschool students. Create separate FTEs for any group of students who attends school for a different number of periods or time than regular full-time students, such as full-day kindergarten students, half-day kindergarten students, and preschool students. See the Attendance Conversion setup items above for more information. | [FTE]Name | AzEDS: |
Default Attendance Mode | Choose the default attendance mode for the FTE from the pop-up menu. Note: The default attendance mode and default attendance conversion do not determine the SAIS attendance values – see Meeting Conversion Attendance Mode on the Attendance Preferences page. | [FTE]Dflt_Att_Mode_Code | Required Setup |
Default Attendance Conversion | Choose the default attendance conversion for the FTE from the pop-up menu. | [FTE]Dflt_Conversion_Mode_Code | Required Setup |
Value | Choose the membership value associated with the FTE from the pop-up menu. Valid values:
| [FTE]Value | Required Setup |
Attendance Recording Methods | Select the Meeting checkbox. SAIS reporting supports the Meeting attendance method with Period or Time conversion methods. | [Prefs]Value [Prefs]Name=ATT_RecordModeMeeting [Prefs]Name=ATT_RecordModeDaily | AzEDS: Required Setup |
Enable Per-Minute Meeting Attendance Times | Check the box to enable Meeting Period Clock-in / Clock-out functionality on the Students Edit Meeting Attendance (week view) screen. Meeting Period Clock-in / Clock-out functionality is used with the following Arizona-specific Attendance Methods (selected on the School Attendance Preferences page):
| [Prefs]Value [Prefs]Name= PSSR_AttendanceMeetingTime_Visible | AzEDS: StudentSchoolAttendanceEvent |
Count these codes for period conversion | Choose Absences from the count these codes for period conversion pop-up menu. Note: Using absent attendance codes with period-to-day attendance conversions is referred to as Negative Attendance. Positive attendance implies that the numbers of present attendance codes for a student are used in attendance conversions. | [Prefs]Value [Prefs]Name=ATT_CalcCntPresentsAbsences | AzEDS: StudentSchoolAttendanceEvent |
Attendance Reporting Method (Grade 9- 12) | Select an attendance reporting method for the school.
If Minutes of Attendance is selected, the actual minutes attended each day is reported to AzEDS, otherwise absence information is reported. Note: This option displays for Alternative Schools only. | [Prefs]Value [Prefs]Name=az_att_repo_method[schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
SAIS Attendance Mode (Grade 9 - 12) | Select an Attendance Mode for the school.
Displays if the school has grade levels of 9+ at the school. | [Prefs]Value [Prefs]Name=az_att_calc_k_conv[schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
School Schedule Type | Select the school schedule type. (Displays if the Method 2: Minutes Attended option is selected).
| [Prefs]Value [Prefs]Name=az_att_sched_type[schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
Attendance Reporting Method (Grade K - 8) | Select an attendance reporting method for the school.
If Minutes of Attendance is selected, the actual minutes attended each day is reported to AzEDS, otherwise absence information is reported. Note: This option displays for Alternative Schools only. | [Prefs]Value [Prefs]Name=az_att_repo_method_k8 [schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
SAIS Attendance Mode (Grade K - 8) | Select an Attendance Mode for the school.
Displays if the school has grade levels of 8 or below at the school. | [Prefs]Value [Prefs]Name=az_att_calc_k_conv_k8 [schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
Percent of Day Present Method | Select the K-8 absence reporting method. (Displays if the 'Percent of Day Present' option is selected).
| [Prefs]Value [Prefs]Name=az_att_pdp_method [schoolid][yearid] | AzEDS: StudentSchoolAttendanceEvent |
Name | Enter the bell schedule name. | [Bell_Schedule]Name | AzEDS: BellSchedule |
Attendance Conversion Method | Choose the attendance conversion method for the bell schedule from the pop-up menu. | [Bell_Schedule]Attendance_Conversion_ID | AzEDS: Required 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 current school year. | [Calendar_Day]Date | AzEDS: AcademicWeek CalendarDate |
Day | Choose the appropriate cycle day from the pop-up menu. | [Calendar_Day]Cycle_Day_ID | AzEDS: ClassPeriodReference |
Schedule | Choose the appropriate bell schedule from the pop-up menu. | [Calendar_Day]Bell_Schedule_ID | AzEDS: BellSchedule CalendarDate |
Tracks | Check the appropriate tracks. | [Calendar_Day]A, B, C, D, E, F | AzEDS: CalendarDate |
In Sess | Check the checkbox to count the calendar day in attendance calculation. | [Calendar_Day]InSession | AzEDS: AcademicWeek CalendarDate GradingPeriod Session StudentSchoolAttendanceEvent StudentSectionAttendanceEvent |
Memb Value | 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 | AzEDS: Required Setup |
Type | Choose the appropriate calendar membership type from the pop-up menu. | [Calendar_Day]Type | AzEDS: CalendarDate |
Day Letter | The day letter is view-only on this page. To edit the number of days associated to this school year, navigate to School Setup > Years & Terms > Edit School Year. | [Cycle_Day]Letter | AzEDS: Required Setup |
Day Abbreviation | Enter the day abbreviation. | [Cycle_Day]Abbreviation | Required Setup |
Day Name | Enter the day name. | [Cycle_Day]Day_Name | Required Setup AzEDS: BellSchedule Intervention |
Final Grade Entry Options > Standards-based Grading | |||
Display/Enter | The value entered in the Display/Enter field will be used to determine which Standards score to output. Note: Even if a value is displayed in the field, please be sure to Submit the page when visiting the page for the first time. Once the page is submitted, it will not need to be submitted again unless the value needs to be changed. | [Prefs]Name Name = STDFGEntryType-Snnn (where nnn= the school’s school number [Prefs]Value | Student-Teacher-Course Connection Reports AzEDS: StudentAcademicRecord CourseTranscript |
Period Number | The period number is view-only on this page. To edit the number of periods associated to this school year, navigate to School Setup > Years & Terms > Edit School Year. | [Period]Period_Number | AzEDS: ClassPeriod ClassPeriodReference |
Period Abbreviation | Enter the period abbreviation. | [Period]Abbreviation | Required Setup |
Period Name | Enter the period name. | [Period]Name | Required Setup AzEDS: ClassPeriod ClassPeriodReference |
Room Number | Enter the number of the room. | [Room]Room_Number | AzEDS: Location LocationReference |
Room Maximum | Enter a number to specify the maximum number of students that the room can accommodate. | [Room]Occupancy_Maximum | AzEDS: Location LocationReference |
Sections > [select course] > [select section] > Edit Section | |||
Course Number | Enter the course number for the section. | [Sections]Course_Number | Student-Teacher-Course Connection Reports AzEDS: Course CourseReference CourseOffering CourseOfferingReference Section |
Schedule | Select the meeting schedule for the section. | [Sections]Expression [Section_Meeting]SectionID = [Sections]ID | Student-Teacher-Course Connection Reports AzEDS: ClassPeriod ClassPeriodReference |
Term | Choose the term for the section from the pop-up menu. | [Sections]TermID | Student-Teacher-Course Connection Reports AzEDS: CourseOfferingReference SessionReference |
Teacher (Pre PowerSchool 7.5) | Choose the teacher for the section from the pop-up menu. | [Sections]Teacher | Student-Teacher-Course Connection Reports AzEDS: |
Teacher – Section lead (PowerSchool 7.5 and higher) Teachers/Staff – Additional (PowerSchool 7.5 and higher) > Edit Section > Click Add Note: PowerSchool allows a single teacher at a time to be designated as the Section Lead teacher, with all additional staff members entered into the Teachers/Staff Additional section. | |||
Staff | Select the teacher from the pop-up menu. | Student-Teacher-Course Connection Reports AzEDS: StaffSectionAssociation | |
Role | Section Lead: All Section Lead teachers are currently required to have the Role of Lead Teacher (renamed to Regular Class in the Co-Teaching Roles Setup section above). Use the Actions Note field to override a teacher’s Role Code. Additional Teachers/Staff: Select a role from the pop-up menu. | Student-Teacher-Course Connection Reports AzEDS: StaffSectionAssociation | |
% Allocation | Enter the teacher’s Contribution Percent. Used by the state to weight the educator’s assigned responsibility for student learning in a class. Defaults to default allocation percent of the role selected. | Student-Teacher-Course Connection Reports AzEDS: StaffSectionAssociation | |
Start Date | Enter the date the teacher begins being associated with this section. Defaults to Term start date. | Student-Teacher-Course Connection Reports AzEDS: StaffSectionAssociation | |
End Date | Enter the date upon which the teacher is no longer associated with the section. Defaults to Term end date. | Student-Teacher-Course Connection Reports AzEDS: StaffSectionAssociation | |
Actions - Note Field (Paper Icon) | Use the Actions column Note field to override the teacher’s Role Code for Lead or Additional Teachers. The Note can only contain valid Role Code values | Student-Teacher-Course Connection Reports | |
Room | Enter the room in which the course section meets. | [Sections]Room | Student-Teacher-Course Connection Reports AzEDS: Location LocationReference |
Section Number | Enter the section number. | [Sections]Section_Number | AzEDS: Section SectionReference |
Grade Level | Enter the grade level associated with this section. | [Sections]Grade_Level | NA |
Exclude From Attendance | Select the checkbox if attendance for the section is to be excluded from student ADA/ADM calculations. | [Sections]Exclude_ADA | AzEDS: StudentSchoolAttendanceEvent |
Exclude From Storing Final Grades | Select the checkbox if the section is to be excluded from storing final grades. Use for Sections that are not graded so blank records are not stored with final grades. Defaults to the value selected for the Course. | [Sections]ExcludeFromStoredGrades | AzEDS: CourseTranscript Grade Report Card StudentAcademicRecord |
GradeScale | Choose the grade scale for the section from the pop-up menu. Defaults to the value selected for the Course. | [Sections]GradeScaleID | AzEDS: CourseTranscript StudentAcademicRecord |
Exclude from GPA? | Select the option to include or exclude the section from GPA calculations. Defaults to the value selected for the Course. | [Sections]ExcludeFromGPA | AzEDS: StudentAcademicRecord |
Exclude from Class Rank? | Select the option to include or exclude the section from class rank calculations. Defaults to the value selected for the Course. | [Sections]ExcludeFromClassRank | AzEDS: StudentAcademicRecord |
Exclude from Honor Roll? | Select the option to include or exclude the section from honor roll calculations. Defaults to the value selected for the Course. | [Sections]ExcludeFromHonorRoll | AzEDS: StudentAcademicRecord |
Allow PowerTeacher entry of Variable Awarded Credit | Select No or Yes from the pop-up menu. This selection at the individual section level overrides the setting specified on the Variable Credit Setup page. | [SectionAttrib]IsEarnedVarCreditAllowed | AzEDS: CourseTranscript StudentAcademicRecord |
Allow PowerTeacher entry of Variable Attempted Credit | Select No or Yes from the pop-up menu. This selection at the individual section level overrides the setting specified on the Variable Credit Setup page. | [SectionAttrib]IsPotentialVarCreditAllowed | AzEDS: CourseTranscript StudentAcademicRecord |
JTED Section Led by a CTE Instructor | Choose Yes from the pop-up menu to include the section in JTED reports. | [Sections]JTED_Indicator = 1 | Student Information Student Attendance Information Attendance Audit Information AzEDS: Student Enrollment Student Attendance |
JTED Section Rank | If Yes is chosen for the previous field, click Set Ranking to assign a ranking for this section. See JTED Section Ranking for more information. | [Sections]JTED_Section_Rank | Student Information AzEDS: Student Attendance |
Instructional Setting | Enter the instructional setting for the course Note: Defaults to course level setting if blank. Drop down values:
| [Sections]Instructional_Setting | Student-Teacher-Course Connection Reports AzEDS: Section |
Course Level Characteristics | An indication of the level of rigor in a course Note: Defaults to course level setting if blank. Valid values:
| [S_AZ_SEC_X]CourseLevel | Student-Teacher-Course Connection Reports AzEDS: Section |
End of Course Assessment Code | For sections that end with Assessment testing, choose a course assessment code. See the Appendix for valid values. | [S_AZ_SEC_X]EOC_AssessmentCodeType | AzEDS: Course |
Low Grade Level | Select the lowest grade level of students either enrolled in the course or for which the course is targeted. Note: Defaults to course level setting if blank. | [S_AZ_SEC_X]LowGrade | Student-Teacher-Course Connection Reports AzEDS: Section |
High Grade Level | Select the highest grade level of students either enrolled in the course or for which the course is targeted. Note: Defaults to course level setting if blank. | [S_AZ_SEC_X]HighGrade | Student-Teacher-Course Connection Reports AzEDS: Section |
Standards Grades Identifier (Populate if using Standards instead of Traditional grades for course) | Enter Standard Identifier if using Standards instead of Traditional grades for course. Ex: LA.11.3.12 Note: Defaults to course level setting if blank. If no value is present in any Standards Grades Identifier field, Traditional grades are reported (StoredGrades). | [S_AZ_SEC_X]StandardID | Student-Teacher-Course Connection Reports AzEDS: StudentAcademicRecord CourseTranscript |
Exclude from AZ Student-Teacher –Course Connection Reports | Click the checkmark to exclude From AZ Student-Teacher-Course Connection Reports. Note: Defaults to course level setting if blank. | [S_AZ_SEC_X]ExcludeSTC | Student-Teacher-Course Connection Reports AzEDS: Section |
Course Identifier | Enter the state course code, ex. AZ10100 if applicable. If the field is blank, the value will be pulled from the associated course. Use this field if you have multiple state course sections tied to a single generic course in PowerSchool. For example, if you have First Grade Math and Second Grade Math sections all associated to a single course called Math in PowerSchool. | [S_AZ_SEC_X]CourseID | Student-Teacher-Course Connection Reports AzEDS: Course CourseOffering CourseTranscript |
Course Name | Enter the course name, if applicable. If the field is blank, the value will be pulled from the associated course. Use this field if you have multiple state course sections tied to a single generic course in PowerSchool. For example, if you have First Grade Math and Second Grade Math sections all associated to a single course called Math in PowerSchool. | [S_AZ_SEC_X]CourseName | Student-Teacher-Course Connection Reports |
Is Dual Credit (HS Only) | Click the checkmark if students enrolled in the course are concurrently enrolled in a post-secondary institution and receiving credit at both levels. Defaults to course level setting if blank. Note: High School Course Only. | [S_AZ_SEC_X]DualCredit | Student-Teacher-Course Connection Reports AzEDS: Section |
Concurrent Enrollment (HS Only) | Click the checkmark if the section is a college course attended by students prior to high school graduation for which they are not receiving high school credit. Reporting these sections is optional. Defaults to course level setting if blank. Note: High School Course Only. | [S_AZ_SEC_X]ConcurEnroll | Student-Teacher-Course Connection Reports AzEDS: Section |
Is CTE Certificate (HS Only) | Click the checkmark if the course is part of a career or technical education program leading to a specific technical certification. Defaults to course level setting if blank. Note: High School Course Only. | [S_AZ_SEC_X]CTECert | Student-Teacher-Course Connection Reports AzEDS: Section |
Is Required for Graduation (HS Only) | Click the checkmark if the course is one of the required courses a student must take to meet graduation requirements. Notes:
| [S_AZ_SEC_X]ReqGrad | Student-Teacher-Course Connection Reports AzEDS: Section |
External Provider Name | If the course is being provided by an external organization, e.g. a distance education or virtual course, the name of that providing organization. | [S_AZ_SEC_X]Provider | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 1 Last Name | Enter the last name for the teacher. Note: When Provider 1 Teacher Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher’ box is checked. | [S_AZ_SEC_X]ProviderT1LastName | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 1 First Name | Enter the first name for the teacher. | [S_AZ_SEC_X]ProviderT1FirstName | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 1 Role | Enter the role for the teacher. | [S_AZ_SEC_X]ProviderT1Role | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 2 Last Name | Enter the last name for the teacher. | [S_AZ_SEC_X]ProviderT2LastName | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 2 First Name | Enter the first name for the teacher. | [S_AZ_SEC_X]ProviderT2FirstName | Student-Teacher-Course Connection Reports AzEDS: Section |
Provider Teacher 2 Role | Enter the role for the teacher. | [S_AZ_SEC_X]ProviderT2Role | Student-Teacher-Course Connection Reports AzEDS: Section |
Include both External Provider and Internal Teacher information in STC reports | Check the box to report both External Provider information as well as Internal Teacher information in STC reports. ** Check this box if both the external provider and the internal PowerSchool teacher(s) both provide instruction to the students | [S_AZ_SEC_X]STC_TeacherIntExt | Student-Teacher-Course Connection Reports AzEDS: Section |
Notes | Any clarifying information for this course section. | [S_AZ_SEC_X]Notes | Student-Teacher-Course Connection Reports AzEDS: Section |
Course Duration (Total Instructional Minutes) | The total number of minutes of instructional time for the course. * Used by the MCESA Student Teacher Course Report. If blank, course level settings will be used. If course and section settings are blank, value will be calculated based on Bell Schedule minutes for the section. | [S_AZ_SEC_X]CourseDuration | MCESA Student Teacher Course Report |
Sequence of Course | When a Section is part of a sequence of parts for a course, the number if the sequence. If Sections value is blank, Courses value will be used. Defaults to 1 if blank. | [S_AZ_SEC_X]SequenceOfCourse | AzEDS: Section |
Homeroom | Select the checkbox to set the section as a homeroom. | [S_AZ_SEC_X]Homeroom | Student Attendance Detail |
21st CCLC Program Course | Select the checkbox to use this section in CCLC Program Attendance records. Note: It is recommended that this section be excluded from attendance. | [S_AZ_CRS_X]CCLCProgramCourse | AzEDS: StudentProgramAttendanceEvent |
Name | Enter the name of the term. | [Terms]Name | Required Setup AzEDS: Session |
Abbreviation | Enter an abbreviation for the term. | [Terms]Abbreviation | Required Setup AzEDS: CourseOfferingReference CourseTranscript Grade GradingPeriod GradingPeriodReferrnce ReportCard Session SessionReference StudentAcademicRecord |
First Day of Term | Enter the first day of the term. | [Terms]FirstDay | Required Setup AzEDS: AcademicWeek GradingPeriod GradingPeriodReference |
Last Day of Term | Enter the last day of the term. | [Terms]LastDay | Required Setup AzEDS: GradingPeriod Session |
What portion of the school year this term represents | For terms within the school year, elect the fraction or item that represents the portion of the school year during which the term takes place. For example, if you define Semester 1 and your school operates with trimesters, Semester 1 represents one-third of your school year. | [Terms]Portion | AzEDS: CourseOfferingReference GradingPeriod GradingPeriodReference Session SessionReference |