Looker Studio Student Performance Dashboard

Project Title:

Creation of Helper Sheet for Looker Studio Integration and Looker studio student report setup

Project Description:

We are building a student performance dashboard in Looker Studio (Google Data Studio) and need a Google Sheets–based helper file that will serve as the single clean data source.

The raw data (from "Teacher’s Dashboard") contains multiple sheets such as:

Student Master (IDs, Names, Grade, Subjects)

Attendance records (date-wise, subject-wise, present/absent)

Test/Assessment coverage

We require a Google Apps Script automation that:

Syncs student master → creates/updates a Students_Id sheet with:

Student ID

Student Name

Grade (normalized as GradeNorm)

Subjects (expanded → e.g., PCM = Physics, Chemistry, Math)

Builds Attendance_Detail:

One row per student per day per subject

Columns: Student ID, Student Name, Date, Subject, Attendance (P/A), ID_Valid

Builds Attendance_Summary:

Aggregated monthly/subject-level attendance % per student

Columns: Student ID, Student Name, Month, Subject, % Attendance, Present Count, Total Sessions

(Optional) Syncs Test Coverage → clean tab (one row per student per subject test).

Ensures live sync: whenever Teacher’s Dashboard is updated, the helper sheet should refresh and reflect in Looker Studio.

Deliverables:

Google Apps Script code (clean, modular, well-documented).

Helper Google Sheet with the following tabs auto-generated/updated:

Students_Id

Attendance_Detail

Attendance_Summary

Test_Coverage_Clean (optional)

Documentation on how to re-run sync or extend for new data.

Skills Required:

Google Sheets & Apps Script (mandatory)

Data Cleaning & Transformation

Looker Studio (Google Data Studio) integration

Strong attention to detail (subject-level attendance & test data must be accurate)