Houghton Muslim Academy is a school located in Johannesburg with a foundation phase that caters to over 500 students. The school was in need of a solution to help calculate the marks and percentages of each student in the phase, as well as a way to determine the top achievers in each class.
To address this challenge, I utilized the power of Google Sheets. I created a custom sheet with formulas and Google Apps script that allowed every teacher to easily edit their own mark sheet. This sheet then automatically calculated each student’s marks and percentages, making it easy to keep track of their academic progress.
In addition, the sheet was designed to determine the top achievers in each class and grade. With this feature, teachers could quickly see which students were excelling in their studies and reward them accordingly.
Thanks to this custom Google Sheets solution, Houghton Muslim Academy was able to streamline their academic tracking process and make it easier for teachers to manage their students’ progress. The school can now more easily identify top achievers and provide the necessary support and resources to help all students excel.