This Google Apps Script project automatically generates math quizzes in the form of:
- ๐ Google Forms (MCQ-style, auto-marked)
- ๐ Google Sheets (with question/answer tracking)
- ๐ Printable PDFs (Student & Teacher copies)
Designed for teachers and educators who want to save time preparing math drills for students aged 9โ13.
โ
Auto-generates 4 Aktiviti (quizzes) per run
โ
Each Aktiviti has 60 randomized questions
โ
Supports: Addition, Subtraction, Multiplication, Division
โ
MCQ format with 4 choices per question
โ
Sets the correct answer + wrong options automatically
โ
Creates both:
- ๐งโ๐ Student version (blank)
- ๐งโ๐ซ Teacher version (with answers)
โ
Auto-grading enabled
โ
Shows results immediately after submission
โ
Collects Name, Class & Email
โ
Response sheet linked for teacher review
โ
Friendly feedback if the answer is wrong
โ
Smart scoring tiers:
- ๐ Above 50% โ โWell done!โ
- ๐งก 30โ49% โ โGood try, keep practicing!โ
- โค๏ธ Below 30% โ โDonโt worry! You can improve!โ
This tool was created to support teachers โ especially those working with underperforming students or in rural schools โ who need to simplify their quiz workflow and make math practice more engaging without the manual headache.
| Google Form (MCQ) | Teacher PDF | Google Sheet |
|---|---|---|
![]() |
![]() |
![]() |
This script uses the Google Apps Script environment to:
- Randomly generate math questions
- Create a new sheet with questions and answers
- Generate a Google Form linked to that sheet
- Export printable PDFs for both student and teacher
- Auto-mark responses and sync to Sheets
- Go to script.new
- Paste in the
Code.gscontents - Save and name your project (e.g. "Maths Generator")
- Run the function
batchGenerateMathsQuizzes - Accept the permission prompts
Done! Youโll now find:
- Forms in your Google Forms
- Sheets in your Drive
- PDFs in separate folders per Aktiviti
- โ Does not handle fractions, decimals, or word problems
โ ๏ธ Limited to 4 Aktiviti per run due to execution time limits- โ Not designed for advanced math or older students (yet)
- ๐ฉโ๐ซ Primary and middle school math teachers
- ๐ป Education tech volunteers and NGOs
- ๐งโ๐ผ Developers building tools for education
Want to expand this?
- Add fractions or harder difficulty
- Translate into other languages (BM, CN, etc.)
- Export score reports or summary analytics
PRs welcome!
This project is licensed under the MIT License โ free to use, modify, and share.


