Assessment Snapshot

Assessment Snapshot — Georgia Standards of Excellence

No login • No cloud • Local only Future‑ready: Google Sheets

Paste class scores, see Learning / Growth / Proficiency color bands, and print or export. Designed for principals & teachers on fsicourses.net.

1) Data Source

Source

Paste class data (headers optional)

Student‑level columns (preferred): StudentID, StudentName?, Standard, Pre, Post
or Standard summary: Standard, N, AvgPre, AvgPost

2) Thresholds & Options

Proficiency bands (Post score)

Customize cut scores (defaults shown)

Beginning ≤

Developing ≤

Proficient ≤

Distinguished ≤

Beginning Developing Proficient Distinguished

Growth bands

Choose how growth is computed and its cut points.

Growth Type

Decline <

Low <

Typical <

High ≥

Decline Low Typical High

Privacy & Display

Hide subgroup rows with N <

Show student table

3) Snapshot

Proficiency Distribution

Growth Distribution

Standards Heatmap

Each row: Georgia Standard → Learning (avg Post), Growth (avg gain), Proficiency mix.

AI‑Assisted Insights (on‑device)

This assistant uses rules (no internet) to flag trends. “Copy Summary” gives you a prompt for deeper analysis in ChatGPT.

Export & Print

4) Future‑Ready: Connect to a Protected Google Sheet

Implementation plan (kept simple)

Create a Google Sheet with a tab like Assess and columns matching either student‑level or standard summary formats.

In Apps Script, add a Web App:

function doGet(e){
  // TODO: add auth checks as appropriate for your domain
  var sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getSheetByName('Assess');
  var values = sheet.getDataRange().getValues(); // 2D array
  // Return JSON with CORS limited to fsicourses.net
  return ContentService
    .createTextOutput(JSON.stringify({range: sheet.getDataRange().getA1Notation(), values: values}))
    .setMimeType(ContentService.MimeType.JSON);
}
function doPost(e){
  // Optional: accept updates from authorized users only
  // Validate e.postData and write to the sheet as needed
}

Deploy as “Web app” → Execute as: Me → Who has access: Only myself / specific users or your Google Workspace domain. Teachers must be signed into authorized accounts.
In this page, set the Web App URL above and click Fetch. CORS may require setting the response header via HtmlService (advanced). Keep this endpoint private to protect student data.

Until that’s ready, continue using the paste workflow. All data remains on the device.