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.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Factorial of a number: Breaking the scepticism

HSE issues mast climber alert

CS373 Spring 2022: Anthony Modica

Automated delivery React / Vue app for each Pull Request.

Develop deployment scripts and templates

How to create an expandable item in Jetpack Compose

How hackers are finding creative ways to steal gift cards using artificial intelligence.

Github | Project Documentation Compendium | TODO Templates

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Aryan Irani

Aryan Irani

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

More from Medium

Parents Evening Appointment System — Part 2

Customize Email Templates In AssetSonar

Customize Email Templates In AssetSonar

Send Automated Emails from Google Sheets — Step-to-Step Guide

Streamlined Authentication with Tableau’s Connected Apps