Student Report

About the Application

StudentReport is a web application designed to automate the academic reporting process for students at Indiana University, on a semester-by-semester basis.

The application streamlines the entire workflow by automating the import and processing of student grades and academic data. Each semester, the system automatically imports grade files from Google Drive and loads them directly into Google Sheets, where all calculations and validations are handled programmatically.

The app includes a set of automated scripts that:

• Import and process academic data from Google Drive
• Apply and update formulas automatically
• Rename and reorganize columns as required for each semester
• Remove inactive students and add new students
• Format sheets by applying colors and structure
• Protect and lock sheets to prevent unauthorized edits
• Execute a predefined workflow of multiple functions to complete the semester setup efficiently

To ensure proper access control, the application reads the email address of the signed-in user and grants access only to authorized users listed in an internal Access Editor sheet. Certain administrative actions are restricted to these authorized users to maintain data integrity and security.

This application uses Google services solely to automate academic data processing and improve efficiency. User data is accessed only for operational purposes and is not shared with third parties.