Skip to main content
First District RESAFirst District RESA

Technology Services · AI

Georgia Standards Lesson Planner

Build a Gemini Gem that knows the Georgia Standards of Excellence, understands your class rosters, and drafts a full week of standards-aligned lesson plans in minutes.

Start the setupTechnology Services

Overview

What you are building

Three pieces that work together: a spreadsheet of the standards, a spreadsheet describing your classes, and a Gem that reads both.

  • 15–20 minute setup
  • K–12 Georgia educators
  • Needs Gemini Advanced

What you will need

  • A Google account
  • A Gemini Advanced subscription (included with Google Workspace for Education or Google One AI Premium)
  • About 15–20 minutes for the initial setup

  1. Part 1

    A Google Sheet with the standards

    A spreadsheet that pulls the complete Georgia Standards of Excellence from the official database at case.georgiastandards.org using a built-in script. Your Gem gets a live, accurate knowledge base.

  2. Part 2

    A Classroom Profiles sheet

    A simple spreadsheet where you enter each class once: teacher, school, course, block, and a breakdown of student support needs (IEP, ESOL, 504, gifted). The Gem reads it so you never re-enter that information.

  3. Part 3

    A Gemini Gem

    A custom assistant pre-loaded with your standards, your class profiles, and instructions for writing Workshop Model lesson plans. Ask for a week by naming the standard and the class period.

Part 1 · Standards knowledgebase

Load the Georgia Standards into a Sheet

Your Gem needs the Georgia Standards of Excellence so it can quote exact codes and language. A short script pulls them straight from the official database into a Google Sheet.

  1. 1

    Create a new Google Sheet

    Create a new Google Sheet and name it Georgia Standards of Excellence.

  2. 2

    Open Apps Script

    In the spreadsheet, click Extensions > Apps Script. Delete any code already in the editor.

  3. 3

    Paste the script

    Copy the script and paste it into the Apps Script editor.

  4. 4

    Save and run

    1. Click Save (Ctrl+S) in the Apps Script editor.
    2. Go back to the spreadsheet and reload the page.
    3. A new Georgia Standards menu appears in the toolbar.
    4. Click Georgia Standards > List Frameworks (Index Tab) to confirm the connection works.
    5. Then Import Selected Framework for specific subjects, or Import All Frameworks for everything.
    The first time it runs, Google asks you to authorize the script. Click Review permissions, choose your Google account, and click Allow.

Part 2 · Class profiles

Describe each class once

The Classroom Profiles sheet holds one row per class period. When you ask for a lesson plan, the Gem pulls the teacher, school, course, block, and every student support detail from here.

Get the template

  1. Download the template below.
  2. In Google Sheets, choose File > Import and upload it. Name the sheet Classroom Profiles.
  3. Replace the sample row with your own classes, one row each.
Download the template
Be specific in your accommodation notes. "Extended time and graphic organizers" produces better results than "has accommodations."
One row per class period. If you teach the same course in multiple periods, give each its own row. The student needs are usually different.
You can add rows at any time. If your roster changes, add a row and save. The Gem sees the update automatically.
Enter 0 and N/A for categories with no students. The Gem will skip those supports.

Column guide

What goes in each column, with examples.

  1. 1Profile Name

    A short, easy-to-say name you will use when talking to the Gem.

    Period 1 – Physical Science · Block 3 Chemistry · My 4th Period Class

  2. 2Teacher Name(s)

    Your name as it should appear on the lesson plan header. If two teachers share the class, list both.

    Jane Smith · Jane Smith & John Doe

  3. 3School

    Your school's full name as it should appear on the lesson plan.

    Statesboro High School

  4. 4Course

    The official course name.

    Physical Science · Chemistry I · Biology

  5. 5Block / Period

    The class period or block number.

    Period 1 · Block A · 3rd Period

  6. 6School Year

    The current school year.

    2026/2027

  7. 7# IEP Students

    Number of students with an active IEP.

    3

  8. 8IEP Accommodation Notes

    Group accommodations the Gem should plan for. No individual student names.

    Extended time on tests, graphic organizers, chunked assignments, read-aloud on assessments

  9. 9# ESOL Students

    Number of English learner students.

    5

  10. 10ESOL Level(s)

    WIDA proficiency levels present in your class.

    Level 1, Level 2, Level 3

  11. 11# 504 Students

    Number of students with a 504 plan.

    2

  12. 12504 Accommodation Notes

    Accommodations that apply.

    Extended time, preferential seating, low-distraction testing

  13. 13# Gifted / Advanced

    Number of gifted-certified or advanced learners.

    4

  14. 14Advanced Notes

    Extension or enrichment appropriate for this group.

    AP-track students · independent project opportunities

  15. 15Other Notes

    Anything else the Gem should know.

    Co-teacher present Mon–Wed · benefits from visual anchor charts

Part 3 · Build the Gem

Set up your Gemini Gem

With the two spreadsheets ready, build the Gem that ties them together.

  1. 1

    Open Gem manager

    1. Go to gemini.google.com.
    2. In the left sidebar, click Gems.
    3. Click New Gem.
  2. 2

    Name your Gem

    Give it a clear name, such as:

    Georgia Standards Lesson Planner

    Optionally add a description: “Builds standards-aligned lesson plans for Georgia K–12 teachers using the Georgia Standards of Excellence and your class profiles.”

  3. 3

    Add your knowledge files

    This is the most important step.

    1. Scroll to the Knowledge section of the Gem editor.
    2. Click Add files > Drive and select your Georgia Standards of Excellence spreadsheet.
    3. Click Add files > Drive again and select your Classroom Profiles spreadsheet.
    Why Drive instead of uploading? Linking from Drive means the Gem always uses the current version. Refresh your standards or update a class profile and the Gem has the change automatically.
  4. 4

    Add the instructions

    Scroll up to the Instructions field and paste the full prompt. It tells the Gem who it is, how to use your knowledge files, and exactly how to build a lesson plan.

  5. 5

    Preview and save

    Use the Preview panel on the right to test with a sample message:

    “I need a lesson plan for S8P1.a for my Period 1 class.”

    • Confirm the Gem asks the right follow-up questions before drafting.
    • Once satisfied, click Save.
  6. 6

    Optional: use your district's lesson plan template

    The instructions end with a default Output Template. You can swap in your district's own:

    1. Open your district lesson plan template.
    2. Select all (Ctrl+A) and copy it.
    3. Find the Output Template section in the Gem instructions.
    4. Replace that section with what you copied.
    Formatting does not need to be exact. The Gem formats the output when it generates a plan.

Part 4 · Generate plans

Using your Gem

Your Gem is live. From here, every lesson plan starts with one sentence.

Quick start

  1. 1Click your Gem name in the left sidebar of Gemini to open a new conversation.
  2. 2Tell it the standard and the class period.
  3. 3Answer its follow-up questions: materials, days needed, supporting standards.
  4. 4The Gem generates a complete, formatted lesson plan using your standards and class profile.
  5. 5Copy the generated plan into your district-approved template.

Example prompt

“I need a full week lesson plan for SC3.c for my Period 4 Chemistry class.”

Keeping things current

  • Standards

    If Georgia releases updated standards, re-run the Apps Script import. Drive-linked spreadsheets update automatically.

  • Class profiles

    Update your Classroom Profiles spreadsheet whenever your roster or accommodations change. The Gem reads directly from Drive.

  • Gem instructions

    To adjust how the Gem writes plans, open Gem manager, find your Gem, click the edit icon, and update the instructions.

Want a hand setting it up?

The Technology Services team runs this as a hands-on session for schools and districts. Email us and we will work out a date.

etc-grp@fdresa.orgTechnology Services