School Setup

Entering Attendance Codes

Attendance Codes > Edit/New Attendance Code

Code

Enter the attendance code abbreviation.

[Attendance_Code]Att_Code

N/A

CEDARS N07

Attendance

Unexcused Absences

Description

Enter the attendance code description.

[Attendance_Code]Description

N/A

Required Setup

Presence Status

Select Present or Absent as the presence status.

Note: Use for CEDARS absence calculations.

[Attendance_Code]Presence_Status_CD

N/A

CEDARS N

Attendance

Unexcused Absence

Points

Enter the number of points associated with the attendance code – can be used to withhold credit when awarding grades.

[Attendance_Code]Course_Credit_Points

N/A

Not Required

Teacher can assign

Choose Yes or No from the pop-up menu to indicate whether the teacher can assign the attendance code.

[Attendance_Code]Assignment_Filter_YN

N/A

Required Setup

This attendance code is considered in ADA calculations

Select to indicate that the attendance code affects attendance calculation.

[Attendance_Code]Calculate_ADA_YN

N/A

Required Setup

This attendance code counts toward membership

Select to indicate that the attendance code affects membership calculation.

[Attendance_Code]Calculate_ADM_YN

N/A

Required Setup

Sort order for display

Choose the sort order, 1 through 30, from the pop-up menu to determine where the code displays on the page.

[Attendance_Code]SortOrder

N/A

Not Required

Defining Attendance Code Categories

Attendance Code Categories > Edit/New Attendance Code Category

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

N/A

Required Setup

Name

Enter the name of the attendance code category.

Note: Ensure that a Category named "Unexcused" exists. The name Unexcused is not required, but the name chosen is used later with Attendance Codes and Unexcused Tracking Categories.

[Code_Entity]External_Name

N/A

CEDARS N

Attendance

Unexcused Absences

Description

Enter a description for the attendance code category.

[Code_Entity]Description

N/A

Not Required

Sort order for display

Choose the sort order, 1 through 30,  from the pop-up menu to determine where the attendance code category displays on the page.

[Code_Entity]SortOrder

N/A

Not Required

Defining Attendance Conversions

Attendance Conversions > New/Edit > Attendance Conversion

Note: Washington schools are not required to use a specific attendance conversion. You must set up at least one of the following:

• Period-To-Day
• Code-To-Day
• Time-To-Day

Name

Enter the attendance conversion name.

[Attendance_Conversion]Name

N/A

Required Setup

Attendance

Unexcused Absences

CEDARS N

Configuring Attendance Tracking and Notification

Editing Attendance Mode

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

Note: Attendance Tracking and Notification values should not be changed during the school year. It is recommended to wait until the end of the school year to make any necessary changes.

Attendance tracking and notification functionality requires PowerSchool 6.0.1.6 or later.

Attendance Mode Value

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

Valid values:

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

Note: For CEDARS N reporting, ITVL is not valid.

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

[Gen]Name=UEAT_Mode

[Gen]Cat=Unexcused

N/A

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Creating Unexcused Tracking Categories

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

Note: Attendance Tracking and Notification values should not be changed during the school year. It is recommended to wait until the end of the school year to make any necessary changes.

Attendance tracking and notification functionality requires PowerSchool 6.0.1.6 or later.

Tracking Category

The page displays Unexcused to indicate that the attendance code category will track unexcused absences or tardies.

Note: Choose the Att Category named earlier as the Attendance Code Category, usually Unexcused.

N/A

N/A

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Attendance Category

Choose the attendance code category dedicated to tracking unexcused absences or tardies 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

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Status

Select one of the following options:

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

Tardy – Indicates that this unexcused tracking category is used to track tardies.

[Gen]Value2=Absent or Tardy

[Gen]Name=UEAT_Category

[Gen]Cat=Unexcused

N/A

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Adding Full-Time Equivalencies

Attendance: Full-Time Equivalencies (FTE)

Name

Enter the FTE name.

[FTE]Name

N/A

Attendance

Unexcused Absences

Default Attendance Mode

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

[FTE]Dflt_Att_Mode_Code

N/A

Attendance

Unexcused Absences

Default Attendance Conversion

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

[FTE]Dflt_Conversion_Mode_Code

N/A

Attendance

Unexcused Absences

Setting Attendance Preferences

Attendance: Preferences

Attendance Recording Methods

Select the Meeting checkbox to enable meeting attendance.

Select the Daily checkbox to enable daily attendance.

Select the Time checkbox to enable time attendance.

Select the Interval checkbox to enable interval attendance.

[Prefs]Value

where [Prefs]Name=ATT_RecordModeMeeting

[Prefs]Value

where [Prefs]Name=ATT_RecordModeDaily

N/A

Attendance

Unexcused Absences

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

Attendance

Unexcused Absences

Defining Bell Schedules

Calendaring: Bell Schedules > Edit/New

Name

Enter the bell schedule name.

[Bell_Schedule]Name

N/A

Attendance

P223

Unexcused Absences

Attendance Conversion Method

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

[Bell_Schedule]Attendance_Conversion_ID

N/A

Attendance

P223

Unexcused Absences

Setting Up the School Calendar

Calendaring: Calendar 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

N/A

Attendance

CEDARS N06

P223

Unexcused Absences

Cycle Day

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

[Calendar_Day]Cycle_Day_ID

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Bell Schedule

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

[Calendar_Day]Bell_Schedule_ID

N/A

Attendance

CEDARS N

P223

Unexcused Absences

School In-Session

Select the checkbox to count the calendar day in attendance calculation.

[Calendar_Day]InSession

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Membership 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

N/A

Attendance

CEDARS N

Unexcused Absences

Defining Cycle Days

Scheduling: Days > Edit Cycle Days

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

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Day Abbreviation

Enter the day abbreviation.

[Cycle_Day]Abbreviation

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Day Name

Enter the day name.

[Cycle_Day]Day_Name

N/A

Required Setup

Defining Schedule Periods

Scheduling: Periods > Edit Period

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

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Period Abbreviation

Enter the period abbreviation.

[Period]Abbreviation

N/A

Attendance

CEDARS N

P223

Unexcused Absences

Period Name

Enter the period name.

[Period]Name

N/A

Required Setup

Editing Course Sections

Scheduling: Sections > [select section] > Edit Section

Course Number

Enter the course number for the section.

CEDARS “Course ID” element.

[Sections]Course_Number

20

CEDARS D04, E06, G05, H07

Term

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

CEDARS “Term” element.

Note: The conversion to match the abbreviation to the CEDARS terms values is done within the reports. See Appendix P of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Sections]TermID

N/A

CEDARS E08, G07, H19

Schedule

Select the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

N/A

Required Setup

Teacher-Section Lead

Click Add and choose the primary teacher for the section from the pop-up menu.

CEDARS “Staff ID” element.

[SectionTeacher]TeacherID

20

CEDARS F03, G04

Teachers/Staff–Additional

Click Add and choose the teacher for the section from the pop-up menu.

[SectionTeacher]SectionId

[SectionTeacher]TeacherId

[SectionTeacher]RoleId

N/A

Not required

Section Number

Enter the unique section number for an individual class.

CEDARS “Section ID” element.

[Sections]Section_Number

20

CEDARS E07, G06

Grade Level

Enter the grade level associated with this section.

[Sections]Grade_Level

N/A

P223H

Exclude this course from CEDARS reporting

These options override the corresponding value on the Courses page. When selected:

Course Value: Overrides the Course value selected for "Exclude this course from the CEDARS reporting" on the Courses page.

Section Value: Overrides the Section value selected for "Exclude this course from the CEDARS reporting" on the Courses page.

[S_WA_SEC_X]State_ExcludeFromReporting

1

Not implemented; CEDARS D, E, F and G are using Course settings

State Course Code

If the state course code for this section is different from the course for this section, enter the course code associated with this section; otherwise, leave blank.

[S_WA_SEC_X]StateCourseCd

6

CEDARS D08, H15

Choose the section's level of rigor. Section value overrides course value in reports.

Reports as 'General or Regular' if blank at course and section.

CEDARS Course Designation Code is comprised of letter values associated with the following checkbox indicators and used in these report:

• CEDARS Course Catalog File element D07
• CEDARS Student Grade History File element H13

International Baccalaureate (I)

Select the checkbox to indicate this is an International Baccalaureate course.

CEDARS Designation I

[S_WA_SEC_X]Desig_IB

1

CEDARS H13

Transcript

College in High School (C)

Select the checkbox to indicate this is a College in High School course.

CEDARS Designation C

[S_WA_SEC_X]Desig_CollegeInHS

1

CEDARS H13

Transcript

Tech Prep (T)

Select the checkbox to indicate this is a Tech Prep course.

CEDARS Designation T

[S_WA_SEC_X]Desig_TechPrep

1

CEDARS H13

Transcript

Honors (H)

Select the checkbox to indicate this is an Honors course.

CEDARS Designation H

[S_WA_SEC_X]Desig_Honors

1

CEDARS H13

Transcript

Advanced Placement (A)

Select the checkbox to indicate this is an Advanced Placement course.

CEDARS Designation A

[S_WA_SEC_X]Desig_AP

1

CEDARS H13

Transcript

Running Start (R)

Select the checkbox to indicate this is a Running Start course.

CEDARS Designation R

[S_WA_SEC_X]Desig_RunningStart

1

CEDARS H13

P223

Transcript

College Academic Distribution Requirements (CADR) (B)

Select the checkbox to indicate this is a CADR course.

CEDARS Designation B

[S_WA_SEC_X]Desig_CADR

1

CEDARS H13

Transcript

Cambridge Program (K)

Select the checkbox to indicate this is a Cambridge Program Course.

CEDARS Designation K

[S_WA_SEC_X]Desig_Cambridge

1

CEDARS H13

Transcript

Online (O)

Select the checkbox to indicate this is an Online course.

CEDARS Designation O

[S_WA_SEC_X]Desig_Online

1

CEDARS H13

Transcript

Local Competency Test (L)

Select the checkbox to indicate this is a Local Competency Test course.

CEDARS Designation L

[S_WA_SEC_X]Desig_LocalTest

1

CEDARS H13

Transcript

National Competency Test (N)

Select the checkbox to indicate this is a National Competency Test course.

CEDARS Designation N

[S_WA_SEC_X]Desig_NationalTest

1

CEDARS H13

Transcript

Quantitative (Q)

Select the checkbox to indicate this is a Quantitative course.

CEDARS Designation Q

[S_WA_SEC_X]Desig_Quantitative

1

CEDARS H13

Transcript

Science Lab (S)

Select the checkbox to indicate this is a Science Lab course.

CEDARS Designation S

[S_WA_SEC_X]Desig_SciLab

1

CEDARS H13

Transcript

Non-Instructional (Z)

Select the checkbox to indicate this is a non-instructional course.

CEDARS Designation Z

[S_WA_SEC_X]secDesig_NonInstructional

1

Non-Instructional (Z)

Select the checkbox to indicate this is a Youth Reengagement course.

CEDARS Designation Y

Select the checkbox to indicate this is a District Dual Credit course.

Select the checkbox to indicate this is a Locally determined course with a locally administered assessment.

Select the checkbox to indicate this is a Local Transition course.

CEDARS Designation E

Select the checkbox to indicate this is an Advanced Manufacturing course.

CEDARS Designation G

Select the checkbox to indicate this is a Maritime course.

CEDARS Designation U 

Select the checkbox to indicate this is an Aerospace course.

CEDARS Designation V

Select the checkbox to indicate this is a Construction course.

CEDARS Designation W

Course identification for which districts authorize course equivalency to each CTE course offered within the course catalog collection file.

Required for CTE courses.

Valid Values:

• A - Statewide Equivalency Course
• B - Local Equivalency Course
• C - No Course Equivalency

Choose the course equivalency designation for Career and Technical Education (CTE) courses.

Valid values:

• 01 - Other Local Equivalency not aligned with valid values 02-19
• 02 - Algebra 1
• 03 - Algebra 2
• 04 - Geometry
  
• 05 - Statistics
  
• 06 - Biology
  
• 07 - Physics
  
• 08 - Lab Science
  
• 09 - Science( Other than Biology, Physics or Lab Science)
  
• 10 - 1 Credit Beyond Geometry
  
• 11 - 3rd Year Math
  
• 12 - 3rd Year Math and Science
  
• 13 - Biology or Lab Science
  
• 14 - English
  
• 15 - English and 3rd Year Math
  
• 16 - English and Science
  
• 17 - English, 3rd Year Math, and Science
  
• 18 - Life Science of Lab Science
  
• 19 - Physics or Lab Science
  

Select which, if any, state or nationally industry recognized certifications are available through this CTE course.

Advanced Placement Course

Required if Advanced Placement is checked under Course Designations above.

Course Value: If Advanced Placement is selected as a Course Designation Code under Course Values, the value displays here.

Section Value: If Advanced Placement is selected as a Course Designation Code under Section Values, and the subject is different than the course value, choose a subject from the pop-up menu.

CEDARS “AP/IB Course Code” element.

See Appendix Q of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_SEC_X]APCode

5

CEDARS H16

International Baccalaureate Course

Course Value: If International Baccalaureate is selected as a Course Designation Code under Course Values, the subject displays here.

Section Value: If International Baccalaureate is selected as a Course Designation Code under Section Values, and the subject is different than the course value, choose a subject from the pop-up menu.

CEDARS “AP/IB Course Code” element.

See Appendix Q of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_SEC_X]IBCode

5

CEDARS H16

Direct Transcription Available

(Invalid beginning 2011-2012)

Choose Yes or No from the pop-up menu to indicate if direct transcription is available for the vocational course.

Note: No longer used for state reporting; was D11, H22.

[Sections]WA_Sec_DirectTranscription

1

Not Required

Skills Program Course

Course Value: If the course associated with this section is a Skills Program course, the course value appears here.

Section Value: If the course associated with this section is a Skills Program course, but the section is different than the course value, choose an option:

Valid values:

• Same as Course
• (1) Skills Courses
• (2) Basic Courses offered at Skills Program

The default for a new section is to use the information from the course.

[S_WA_SEC_X]SkillsProgram

1

P223

Work Based Course

The default for a new section is to use the information from the course.

[S_WA_SEC_X]WorkBased

1

P223

The default for a new section is to use the information from the course.

Non-FTE Course

Choose the appropriate value, or leave the pop-up menu as "Same as Course".

The default for a new section is to use the information from the course.

Valid values:

• Same as Course
• (1) Course not considered in FTE calculations.

[S_WA_SEC_X]Non_FTE_Credit

P223

Content Area Codes

The default for a new section is to use the information from the course.

Valid values:

• Same as Course
• (123) More than one core content area (block class)
• (ZZZ) Non-Instructional Time

CEDARS “Content Area Code” element.

[S_WA_SEC_X]ContentAreaCd

N/A

CEDARS H14

ALE Course Type

Choose the ALE type for this course, or leave the pop-up menu as "Same as Course".

Valid values:

• Same as Course
• (N) No, course was not taught through ALE
• (O) Online
• (R) Remote
• (T) Site Based - Requires regular weekly in-person instructional contact time
• (U) Site Based - Requires regular less than weekly in-person instructional contact time
• (S) Site based (Obsolete as of 2017-2018. Use T or U instead)

[S_WA_SEC_X]ALEFunded

N/A

CEDARS E09, H27

Valid values:

• Blank
• 1 – One-way Dual Language Program
• 2 – Two-way Dual Language Program

Choose the secondary language the course is taught in.

Required if Dual Language Instruction Type is not blank.

See Appendix K of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

CEDARS D15

Identifies the online provider offering the course.

See Appendix AA, of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

Identifies the online program offering the course.

See Appendix AB, of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

Setting up Civil Rights Data Collection (CRDC)

Scheduling: Sections > Civil Rights Data Collection (CRDC) > See CRDC School Setup (2020 - 2021)

Civil Rights Data Collection (CRDC)

Use this link to access CRDC data entry.

N/A

N/A

N/A

Defining Years & Terms

Scheduling: Years & Terms > Edit Terms > Term Setup > Edit/New Term

Name of Term

Enter the name of the term.

[Terms]Name

N/A

All Reports

Abbreviation

Enter an abbreviation for the term.

CEDARS “Term” element.

Note: The conversion to match the abbreviation to the CEDARS terms values is done within the reports. See Appendix P of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Terms]Abbreviation

12

CEDARS E08, G07, H19

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