Mara Morrison

Amy Pasko

Kevin Wu

Diana Antova

Brian Shivliey

Configure Power BI to access the eGrades database

We can make use of Power BI for certain reports that are to be accessed by Registrar staff only

Example of one such report: 

 eGrades report enables the user to pull and categorize each course's status for the quarter, for example:

• not started
• submitted
• in progress
• ready for review
• recorded

There are many instances where the TA or instructor uploads and saves the grades in eGrades before the quarterly grade deadline, but they forget to press the 'submit grades' button. Once the grade deadline passes, the course gets "locked" in the system: the course status changes to 'in progress' or 'ready for review' and the grades disappear from the gradebook and can only be retrieved if an admin reopens the course.

The instructor will then need to log back in and submit the grades.

The only way the admin knows if a course needs to be reopened is when the instructors/advisors reach out individually to the eGrades inbox and asks why their course hasn't been submitted and wonders where the grades went.

It would save a lot of time and communication to know from the start which courses are locked and need to be reopened so they admin can go down the list and reopen them all immediately so that the instructors will be able to submit the grades.

This will also be helpful because the grade deadline is often before a holiday break and there isn't always an admin in the office to reopen courses during that time.