nisd

A Google Apps Script project for managing and automating dyslexia materials requests within NISD Student Services. This tool streamlines the request process, improves tracking, and enhances communication between staff and the student services dyslexia team.

A Google Apps Script that automates the creation of personalized praise slides for teachers using Google Forms responses, integrating with Sheets and Slides to celebrate staff achievements in educational settings.

Google Apps Script automation that identifies students who skipped flex classes by consolidating COGNOS attendance data with FlexiSched absence reports.

Google Apps Script solution for automatically updating form dropdown choices with student data from Google Sheets using time-based triggers

Google Apps Script bound script that generates sign-in/sign-out attendance and time reports for resource fair events. Originally built for a school district, generalized for public use.

Google Apps Script project that automates student data organization and report generation for NISD's annual Special Olympics track & field event — grouping athletes into days, heats, and lanes, and producing heat sheets, scorecards, condensed lists, and labels for coaches and volunteers.

A Google Apps Script library that provides school holiday and break dates for use in date calculations.

Google Apps Script that automates consolidation of monthly classroom data from individual campus spreadsheets into a master dashboard. Originally built for a school district, generalized for public use.

A Google Apps Script project for Northside ISD that calculates mileage between district campuses and facilities. It includes a numberOfMiles(start, destination) custom function for use in Google Sheets and a ClearForm macro to reset the entry form. This project is meant for NISD staff who need to submit mileage for reimbursement.

A Google Apps Script library that automatically deletes "Untitled" spreadsheets from Google Drive. Originally built for a school district and generalized for public use.

Automates collection and reporting of Alternative Learning Environment (ALE) class counts for NISD Student Services. Uses Google Apps Script to read Google Sheets, calculate per-campus/per-class counts, and produce exportable, compliance-ready reports for administrators.

A Google Apps Script that forwards all Gmail threads and attachments to a personal email address, tracking progress with labels to avoid duplicates. Originally built for a school district and generalized for public use.

A Google Apps Script that automates weekly behavior data collection sheets in Google Sheets, links them to a summary view, and emails daily behavior reports. Originally built for a school district, generalized for public use.

Lightweight Gmail filter automation using Apps Script (clasp): label Cognos reports and auto-archive. This addresses a limitation of default Gmail filters.

Google Apps Script automation that generates monthly co-teaching student reports for NISD elementary campuses. Pulls Cognos data from Gmail, processes per-campus student records, and produces a formatted Google Sheet with staffing ratio calculations.