My First Project: Project Automation

I am pursuing B-Tech(Computer Engineering) at NMIMS.

Since last year we have been undergoing online lectures and examinations, as a result of the pandemic. This presented a unique problem for the college administrators: how to distribute the test scores via email. Considering the number of students, the task required automation. I was allowed to devise a solution.

Let me take you on a journey from the problem to the solution.

Part 1: The Problem

Teachers had a requirement for sending out mark sheets via email to individual students and parents. Also, they did not want the scores of the students to be revealed to everyone. The subject-wise (also term-wise) scores were stored in a Google Sheet and initially, the whole Google Sheet was shared to show the students' marks.

Part 2: The Solution

Since the data was in a Google Sheet, I decided to use Google Apps Script as part of the solution. The Google Sheet contained the following data:

  • Name of the Student
  • Roll number/Id of the student
  • Scores in subjects in 2 terms
  • Email Address of the student

The requirement was to create individual PDF’s (mark sheets) for each student and email it to them. The PDF has the following details :

  • Name of the Student
  • Roll(Id) of the Student
  • Marks of the student in subjects in 2 terms

Part 3: The Automation Script

Part 4: Execution

With the click of the button (Send PDF), individual mark sheets will be created and emailed to the students.

If you want to learn how to assign scripts to images and run them, please refer to the video below.

Part 5: Summary

This solution was derived from a previous blog, which dealt with sending PDF’s using Google Apps Script. You can check out the video below to know more.

Teachers will now be able to able to send mark sheets to individual students in the form of PDF’s using Google Apps Script.

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student.