Attendance Information Report

Attendance Information Report

Step 1: Pulling Attendance Information

  1. Log into PowerSchool Admin panel.
  2. Select School: Elementary School, Middle School or High School
  3. Then from Setup > System > Data Management > Direct Database Export (DDE)Screen Shot 2016-08-16 at 1.15.25 PM
  4. Select Current Table : Attendance(157) and click “Select all records in this table”Screen Shot 2016-08-16 at 1.22.43 PM
  5. In the Search Attendance, put in the Attendance date you wish to pull attendance for and click on “Search all records in this table”Screen Shot 2016-08-16 at 1.23.28 PM
  6. It will show the attendance records, post the date that you have put in. Click on “Export Records”Screen Shot 2016-08-16 at 1.23.34 PM
  7. Now put in the following fields (in the same syntax as below) to be exported:
    [157]Att_Date
    [157]PeriodID
    [156]description
    [4]course_number
    [1]lastfirst
    [1]Grade_level
    [133]NameScreen Shot 2016-08-16 at 1.23.43 PM
  8. It will give you all attendance codes for the all the attendance days for that period.Screen Shot 2016-08-16 at 1.23.50 PM
  9. Sort via description field and take off all the attendance code except the one that you require.. in this scenario “Tardy Unexcused”
    After that you can either do “Sorting by Att_Date” or by “lastfirst” to have it by student.
    Note: This report is only allowing for taking the “Course Number”. To get the Course name:

Step 2: Pulling Course Names

  1. Go to DDE again and select the table as “Courses(2)”Screen Shot 2016-08-16 at 1.23.56 PM
  2. Click on “Export Records” and choose the following fields to export to excel –  “course_name” / “course_number”Screen Shot 2016-08-16 at 1.24.02 PM
  3. Save this file for future reference also. You will have to replace the course_number with course_name in the Attendance sheet to get the class student was late in.

Step 3: Pulling Bell Schedules

  1. Go to “DDE” and select the table as “Bell_Schedule_Items(134)”Screen Shot 2016-08-16 at 1.24.08 PM
  2. Export records via selecting these fieldsScreen Shot 2016-08-16 at 1.24.11 PM
  3. Save the file and open in Excel.

Final Format

In the Attendance Excel file now:

  1. Replace Course_number with “course_name
  2. Take all of the Attendance codes that you don’t require from the “Description” column.. just keep the one that you want.
  3. Align the exported bell schedule item period with the exported attendance period id to get timings of the periods
Recent Posts
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search

photoScreen Shot 2016-08-16 at 1.34.43 PM
Copyright © 2017 AES All Rights Reserved