🧑‍🏫 Teacher Setup: Google Form wiring — expand to configure submission

One-click setup — no manual form building required

A Google Apps Script in scripts/unit5_lesson4_form_setup.gs creates everything automatically: the form with all 32 fields, a linked response spreadsheet, and a pre-built grading sheet with color-coded auto-grading formulas. Do this once and you're done.

Step 1 — Run the setup script (2 minutes)

  1. Go to script.google.com → click "New project"
  2. Delete the default code in the editor
  3. Open scripts/unit5_lesson4_form_setup.gs from this project — copy the entire contents and paste it into the Apps Script editor
  4. Save (Ctrl+S), then click ▶ Run
  5. Authorize when Google prompts (click "Allow") — this lets the script create a Form and Spreadsheet in your Drive
  6. Wait about 10 seconds for it to finish

The script creates: Google Form with 32 fields (section headers, multiple choice where appropriate, confirmation message) + Grading Spreadsheet with a "📊 Grading" sheet that auto-grades every submission in real time with green/red cells and a score column.

Step 2 — Copy the entry IDs

  1. After the script runs, click View → Logs in Apps Script
  2. You'll see the student form URL, your editor URL, the grading spreadsheet URL, and a block of entry IDs
  3. Send the entry ID block to Mr. Bennett — he'll update this digital organizer so the "Submit" button auto-populates the form with the student's answers (student just clicks Submit)

The entry ID block looks like: {"name":1234567890,"period":9876543210,...}

What the grading sheet does automatically

Column colorMeaning
Green · 1Correct answer
Red · 0Incorrect answer
Score ≥ 25Strong performance (≥89%)
Score 18–24Approaching mastery
Score < 18Needs support

Fraction answers accept multiple forms (e.g., "1/30" or "0.033"). The sentence frame column is marked ✏ (written) or — (blank) but not scored — it is for teacher review only. Total score is out of 28 graded fields.

Current status

Script is ready to run. Entry IDs are not yet wired — submission currently opens the blank form. Run the script, send Mr. Bennett the log output, and the connection will be complete.

Algebra 2  ·  Unit 5 · Lesson 4  ·  Level 1–2 Support
Activity 1 — Why Can't We Divide?
Nigeria Population Growth  ·  Problem 5
Nigeria's population grew from 95.3 million (1990) to 122.4 million (2000) — an increase of about 28.4% over one decade.
A student says: "The population grew 2.84% per year because 28.4% ÷ 10 = 2.84%."
Is this correct? Use this organizer to explain why or why not.
Word Bank
Tap a word to select it (turns purple), then tap any blank below to place it. Tap a filled blank with no word selected to clear it.
adds multiplies same amount same factor divide take the 10th root linear exponential
Compare: Linear vs. Exponential Growth
Linear Growth Exponential Growth
Each year, the population the same . Each year, the population by the same .
To find the yearly rate, you can by 10 because the growth is spread evenly. To find the yearly rate, you must because the growth compounds each year.
Nigeria's growth this type:
/
Nigeria's growth this type:
/
Conclusion — Complete Using the Word Bank
Try Writing "28.4% ÷ 10 = 2.84% is incorrect because Nigeria's population growth is growth, not growth. To find the annual growth factor, I need to of 1.284."
Algebra 2  ·  Unit 5 · Lesson 4  ·  Level 1–2 Support
Activity 2 — What Does the Exponent Mean?
Cesium-137 Decay  ·  Problem 8
Cesium-137 has a half-life of 30 years. Starting with 100 grams, the amount remaining is given by:    100 · (½)n    where n is the number of 30-year periods.
How to fill in the table:   The exponent tells you how many 30-year periods have passed. Multiply the exponent by 30 to get the total years.
Example: exponent = 3  →  3 periods  →  3 × 30 = 90 years
Fill in the table — first two columns are given
Expression Exponent (n) — given # of 30-year periods Total years
100 · (½)1 1
100 · (½)3 3
100 · (½)t/30 1/30
100 · (½)t/2 1/2
Tip: type fractions like 1/30 or 1/2 — they will render automatically.
Sentence Frame — Choose one row and explain it
Try Writing "The exponent means 30-year period(s), which is years."
Algebra 2  ·  Unit 5 · Lesson 4  ·  Level 1–2 Support
Synthesis & Cool-Down — Key Vocabulary
Language Objective  ·  Match terms · Complete the frame using the cool-down context
Part 1 — Match each term to its definition
Terms
1. half-life
2. initial amount
3. exponent
4. root
Definitions
  • A. The starting quantity before any decay has occurred — 200 mg in the cool-down.
  • B. The power that a base is raised to; tells you the number of intervals.
  • C. The time it takes for half of a material to remain.
  • D. The inverse of raising to a power; used to find a subinterval factor — the decay (or growth) over a smaller time period than the one given.
Part 2 — Complete the sentence frame using the cool-down function
A(t) = 200 · (½)t/8   describes the amount of Iodine-131 remaining, where t is days.
Try Writing If t = 8 days, the exponent equals 8 ÷ 8 = .  That means half-life has passed.

If t = 16 days, the exponent equals 16 ÷ 8 = .  That means half-lives have passed.
Part 3 — Click which type of function this is
Linear Growth
(adds the same amount each period)
Exponential Growth
(multiplies by the same factor each period)
Done? Check all your answers, then submit to Google Form.