Student to Employee Ratio

Location

Perth, Western Australia, Australia
Adelaide, South Australia, Australia

Campuses

Kewdale | Thornlie | Dianella

About AIC

AIC was founded in 1986 and has grown to become one of Western and South Australia’s most significant Islamic educational institutes. AIC has experienced numerous beneficial improvements over the years. The teachers and staff of AIC exemplify the institution’s mission of educating students in a constructive manner that fosters an understanding of the world in which we live. Their mission to establish a modernized Islamic educational institution explains why they have progressed so far since their inception.

Problem Statement

Australian institutions are obligated to abide by the rules of student to employee ratios in all their campuses and are consistently reviewed. In order to keep up with the obligation, AIC needed a regularly updated report to prove that AIC was ensuring the correct student to employee ratio.

Student to staff ratio is calculated as the sum of students divided by sum of staff full time equivalence (FTE) in teaching and teaching/research functions, including actual casual staff.

Our Solution

We created a dashboard that provides detailed figures of the student to employee ratio, ranging from the total number of students against the total number of employees, and in each department of the schools such as High School, Primary School, Head Office and Non-teaching staff. 

The report is continuously updated on the basis of any new employees being hired and any new students gaining admission into the school.

Platforms used

Power BI

Microsoft Power BI

Automate

Microsoft Automate

microsoft_sharepoint_logo_office_icon_145722[1]

Microsoft SharePoint

Team for this Project

Maria Shamim

Project Manager

Waqas

Waqas Ahmed

Developer

New Project (46)

Abdus Sami Patel

Developer

Yasir Hussain

Yasir Hussain

QA Engineer