Versions Compared

Old Version 2

changes.mady.by.user Vince Pete Darcangelo

Saved on

compared with

New Version Current

changes.mady.by.user Vince Pete Darcangelo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Update data from Pull most recent CU-SIS info and update the course audit files

Run the following SAS programs (no changes required)

  • L:\FCQ\DATA\auditfiles\cyyt\OLAdminDtscyyt.sas

  • L:\FCQ\CODE\AuditList\C00_audit_init.sas

  • L:\FCQ\CODE\AuditList\C10_CrsList_CUSIS.sas

  • L:\FCQ\CODE\AuditList\C20_ClsList_4Excel.sas

Update the course audit files

Run the following SAS programs (no changes required)

L:\mgt\FCQ\CourseAudit\NewAuditDept.sas

...

code sequence

Files that are generated

Expand
titleCurrent semester audit files

  • Generated in the C:\Users\darcange\OD.new\OneDrive - UCB-O365\CourseAudit

...

L:\mgt\FCQ\CourseAudit\NewAuditAll.sas

...

  • folder

  • These files are updated each time the above code sequence is run

The “_all” master file

  • audit(term_cd)_all.xlsx

    • Contains all classes for all campuses participating in FCQs in one file

The “_campus” files

  • audit(term_cd)_campus(campus_cd).xlsx

    • A file for each separate campus listing all classes in one file

The “dept” files

  • audit(term_cd)_(campus)_(coll or campus_cd)_(dept_cd).xlsx

    • Traditional audit files for each individual campus/department

    • Example: C:\Users\darcange\OD.new\OneDrive - UCB-O365\CourseAudit

...

Updates incremental “forensic” audit file in L:\mgt\FCQ\CourseAudit

...

L:\mgt\FCQ\CourseAudit\NewAuditViz.sas

  • Updates source document for Tableau in L:\mgt\FCQ\CourseAudit\cyyt_auditfile.csv

Update the Tableau visualization

Update the data source

  • Open Tableau file, "L:\mgt\FCQ\Tableau\Course_Audit\Course_Audit.twb"

  • Click on the “Data Source” tab

  • Change “Connection” (in upper-right) from “Extract” to “Live”

  • Click on the file beneath the “Connections” heading

  • Select “Edit Connection”

  • Select the updated file L:\mgt\FCQ\CourseAudit\cyyt_auditfile.csv

  • Click “Open”

Refresh the Tableau dashboards

  • Change “Connection” (in upper-right) from “Live” to “Extract”

  • Click “Refresh” next to “Extract”

Upload the Tableau visualization

...

Go to “Course Audit” dashboard (instructions page)

...

Save the file

...

Click the “Share” button

...

Click “Save”

...

    • \audit2241_CUBLD_BLDR_APRD.xlsx

Expand
titleArchived course files for reference and troubleshooting

  • Because the audit files are a snapshot of the CU-SIS data, it’s good to create archive versions

The “final” audit archive

  • At the end of each semester, the audit files from above are moved to their own folder in the “Previous_Semesters” folder

    • C:\Users\darcange\OD.new\OneDrive - UCB-O365\CourseAudit\Previous_Semesters\(term_cd)

    • This is a snapshot of the CU-SIS data the last time they were updated in the previous semester

    • However, this doesn’t show how that information changed over time

The “_bak” audit archive

  • Example: audit2237_091523.xlsx

  • Each time the code sequence is run, a raw file with all of the CU-SIS information from that day is created and timestamped in the CourseAudit_bak folder under the current semester

    • This creates 25-30 snapshots of CU-SIS data throughout the semester, which we can later use for troubleshooting errors or inconsistencies

  • “c20” and “clscu_r” files

  • Each time the code sequence is run, the c20 and clscu_r files are overwritten with the most recent CU-SIS data