• Home
  • Courses
    • School Best Practices
    • PowerSchool
    • CALPADS State Reporting
  • Memberships
  • Student Data Services
  • EdVision Portal
  • About Us
    • Contact
EdVision LearnEdVision Learn
  • Home
  • Courses
    • School Best Practices
    • PowerSchool
    • CALPADS State Reporting
  • Memberships
  • Student Data Services
  • EdVision Portal
  • About Us
    • Contact

CSMC Internal Attendance Development Program

  • Home
  • All courses
  • Internal Use Only
  • CSMC Internal Attendance Development Program
CoursesInternal Use OnlyCSMC Internal Attendance Development Program
  • Introduction to the Attendance Department 1

    This section will give you a broad overview of the items that the Attendance Department takes care of.

    • Lecture1.1
      What type of services does the Attendance Department provide? 03 min
  • Everything P-Reporting 11

    This section will walk you through the initial steps of prepping for P-Reports, through the workflow process, the upload of data to the State Software, the download of reports and certificates, and the submission of P-Reports.

    • Lecture2.1
      P-Reporting in a Nutshell 03 min
    • Lecture2.2
      P-Reporting Workflow 03 min
    • Lecture2.3
      How to create an Attendance Reporting Calendar using an excel template 30 min
    • Lecture2.4
      How to verify P-1, P-2, P-3 Cut-off 30 min
    • Lecture2.5
      How to Download and Install the State Software 30 min
    • Lecture2.6
      How to create an account on State Software 30 min
    • Lecture2.7
      How to load data to State Software 30 min
    • Lecture2.8
      How to Extract DAT file from State Software 05 min
    • Lecture2.9
      How to save reports from State Software 30 min
    • Lecture2.10
      How to save certificate pages from State Software 05 min
    • Lecture2.11
      How to calculate Basic Aid ADA 15 min
  • PowerSchool Audit Items 5

    In order to run the most accurate Attendance Reports from PowerSchool, we need to audit the items that affect the reports' output which includes the setup for Attendance.

    • Lecture3.1
      How to Compare # of physical school calendar days to what is in PowerSchool 05 min
    • Lecture3.2
      How to verify FTEID for current school year 05 min
    • Lecture3.3
      How to verify which periods count for ADA 05 min
    • Lecture3.4
      How to check PowerTools for Padded Enrollments 05 min
    • Lecture3.5
      How to fix padded enrollments 05 min
  • Reporting Period Audit Items 3

    • Lecture4.1
      How to Audit Monthly Student Attendance Report and Correct Errors in PS 30 min
    • Lecture4.2
      How to Audit Attendance Summary by Grade Report and Correct Errors in PS 30 min
    • Lecture4.3
      How to check for Negative Attendance by using the ADM/ADA by Student Report
  • Ongoing Clerical Duties 6

    • Lecture5.1
      How to exclude Winter Break if applicable 05 min
    • Lecture5.2
      How to update Attendance Tracker
    • Lecture5.3
      How to identify school’s 20th Day
    • Lecture5.4
      How to identify school’s enrollment count as of 20th day
    • Lecture5.5
      How to upload Up-to-date files onto CV
    • Lecture5.6
      How to create a Special Program at the District Level for ADA breakout purposes
  • Submission Reports 5

    • Lecture6.1
      How to prepare Month 1 LAUSD Statistical Report
    • Lecture6.2
      How to prepare Month 2 – Month 10 Statistical Report
    • Lecture6.3
      How to prepare LAUSD Classification Report
    • Lecture6.4
      How to identify a specific school’s month reporting range
    • Lecture6.5
      How to prepare FICS Enrollment Report

    How to Audit Attendance Summary by Grade Report and Correct Errors in PS

    To accurately report ADA for a school, we must audit the attendance reports to ensure that they are working properly. The first thing to look for when running the Attendance Summary by Grade Report is to make sure that you are running the report for the correct school and the correct reporting period. If you are unsure about the school’s reporting range, verify with the school calendars that we have in the Calendars folder OR with the LAUSD provided calendars.

    The second thing to look out for is that the number of days in session on the reporting term match their physical school calendar.

    On the Attendance Summary by Grade report, the number of in-session days will appear right after the date range:

    If this number matched to the number of in-session days that you calculated when creating the attendance reporting calendar for that school, then you are okay.

    If the report does not match the number of days, then you know that there is something wrong with the Calendar Setup.

    To correct the number of days:

    1. From the start page in PowerSchool, click on School

    2. Click on Calendar Setup

    3. Compare the days in-session with the calendar you created

    vs

    4. Identify the extra day

    5. Remove the extra day by blanking out the Cycle Day, Bell Schedule, unchecking the box underneath School In-Session and by switching the 1 to 0 under Membership Value

    6. Scroll to the bottom and click Submit to save the changes

    Once you are finished, re-run the report to ensure that correct number of in-session days is now displaying. The reason why this is important is because when calculating ADA, you are using a bigger divisor which will lower your ADA. In other words, if the number of days in attendance was 1,530 and you are diving that by 19, then the ADA is going to be 80.53. Whereas diving 1,530 by the true divisor of 18, will give you an ADA of 85.00.

    Another thing to look out for is that the ADA is not being calculated correctly. It is important that at least two grade levels have the ADA calculation checked by manually calculating the ADA on a calculator.

    In the example above, we we want to ensure that 935 (number of days in attendance) divided by 15 (total number of in-session days) equals 49.21 (ADA). When I manually divide 935 by 15, I get 62.33. This tells me that there is something wrong in the calculation of the ADA. In order to identify the divisor (total number of in-session days), I am going to divide 935 by 49.21 (the ADA on the report) which gives me 19. This tells me that there are 4 days that are not being counted towards the total in-session days.

    Upon

     

    Verify accuracy of ADA calculations on reports > Winter Break exclusion example

    Prev How to Audit Monthly Student Attendance Report and Correct Errors in PS
    Next How to check for Negative Attendance by using the ADM/ADA by Student Report

    Leave A Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Copyright © 2018 EdVision

    • Privacy
    • Terms
    • Sitemap