Day 17 - School Admin Dashboard(Part 2)

School Admin Dashboard

· School Summary Insight

· Instructor Overview Insight

· Student Overview Insight

· Course Overview Insight

· School Summary Insight

Calculate Student-teacher Ratio. The student-teacher ratio refers to the number of students for every teacher in a school.

Formula:

Average Class Size. The number of students in classes divided by the number of classes.

Formula:

· Instructor Overview Insight

· Student Overview Insight

· Course Overview Insight

In the School Admin Dashboard, because there is currently only one school, there is no need to set an admin filter. I only need to share with the admin of the school through Share Access. After that, the admin of each school can only see the dashboard of the school, and the admin of Incorta can see the dashboard of all schools.

On canvas Schema, assignments table add flexible foreign key.

In assignments, table add join to course (as a child)