Saturday, April 16, 2016

DegreeWorks Reporting: What to do with all that data



  • Introduction
    • Prerequisite: CPA data
    • Documentation: Degreeworks Advanced Reporting Technical Guide, DegreeWorks Schema
    • Note about ACTIVE_TERM
  • dapfindorphanedaudits
  • Planned Courses
    • Purpose: Determine the number of students who plan to take a specific course grouped by term


  • Still Needed Courses
    • Purpose: Determine the number of students who still need to take a specific course grouped by class


  • Pre-Defined Notes Report
    • Purpose: Find students who have been given a specific pre-defined note in a given date range




  • Degree Candidate Report
    • Purpose: Detailed information about all students identified as graduating in the selected term



This table is not in 2nd normal form.  Students have many records differentiated by result type

  • Miscellaneous Reports
    • CORE Courses

  • Required/Optional Courses



  • Plan Stats