Daily Attendance Report

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

AIC desired a centralised student management system for attendance tracking in order to enhance the detection of (relatively new) absentee youth.

Daily monitoring of student attendance is utilised to provide rapid identification and enable schools to implement intervention techniques when new student attendance issues emerge.

Our Solution

We created an automated process whereby attendance records are daily taken from The Alpha School System (TASS), run through SQL servers and a report is compiled from the data, covering all 4 campuses. The report is generated automatically on a daily basis and emailed to the principals of each campus.

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