Story · The Electricity Bill Tracker
Rahul Built a Tool That Actually Got Used 💡
Rahul, 13, from Pune, lived in a housing society where every month there was confusion about the electricity bills — some flats were charged differently, and no one could easily see who had paid or how much was outstanding.
His mother mentioned it once, and Rahul decided to build a solution. He spent two afternoons working with ChatGPT: asking it to help him design a spreadsheet formula, write a summary email template, and explain the bill in simple language. He created a Google Sheets template with auto-calculations and a short monthly report that his mother's committee started using within two weeks.
"Did you code it?" a friend asked. "Not really," Rahul said. "I told the AI what I needed, it helped me build each piece, I checked everything, and I connected the parts myself." His friend said that sounded like engineering. Rahul thought about that and agreed.
👉 This lesson gives you the framework Rahul used — and five project templates you can start building today.
Section 1 of 5
🗺️ The AI Project Planning Framework
1
Define the problem. Write one sentence: "I want to help [who] do [what] better." The clearer this sentence, the better every step will be. Rahul's: "I want to help our housing society committee track and communicate electricity bills more clearly."
2
Identify the data or inputs. What information does this project need? Where will it come from? Is it available? Is any of it sensitive (names, money, health)? If it is sensitive, what extra care is needed?
3
Choose your tools. What AI tools are available and appropriate? Do you need no-code tools (Google Docs + ChatGPT prompts) or something more programmable (Python)? Match the tool to your skill level and the problem scale.
4
Build a small version first. Do not try to build the complete solution immediately. Build the smallest thing that tests whether your idea works. For Rahul: a single flat's bill calculation first, before the full society template.
5
Test and evaluate. Try it with real data. What works? What breaks? What does it get wrong? Be honest about failures — this is how every professional builds software.
6
Iterate. Improve based on what you learned from testing. Repeat steps 4–6 until the solution works well enough for real use.
Section 2 of 5
🎯 What Makes a Good Problem to Solve with AI?
Not every problem benefits from AI. Use this checklist when evaluating an idea:
- Does it involve repetitive text, data, or analysis? AI is strong at summarising, generating, classifying, and analysing text and structured data.
- Is the output something you can check? A good project produces output you can verify — you are not blindly trusting the AI.
- Would someone actually use the result? Build for a real person with a real need, even if it is just yourself or a family member.
- Is it achievable in 2–5 working sessions? A project that takes more than a week to get a first working version is probably too ambitious for your first project.
Common mistake — solving a problem no one has: Students sometimes build technically impressive projects that no one actually needs. The question "would someone actually use this?" is the most important test. Start with a problem you have personally experienced or seen someone close to you struggle with.
Section 3 of 5
🔧 Tool Selection Guide
| Tool type | Best for | Examples |
|---|---|---|
| AI chatbot (no-code) | Drafting, explaining, summarising, brainstorming, creating templates | ChatGPT, Google Gemini, Claude |
| AI + spreadsheet | Data calculations, formulas, auto-generated summaries, mail merge | Google Sheets + ChatGPT prompts |
| AI + document | Report writing, email templates, structured summaries | Google Docs with Gemini, Word Copilot |
| AI image generation | Illustrations, posters, project visuals, infographics (starting point) | Canva AI, Google Imagen (via Gemini) |
| Python + AI libraries | Custom automation, data analysis, building classifiers or chatbots | Google Colab + Python (next lesson) |
Start no-code first: Before writing a single line of Python, ask yourself: can I do this with a chatbot and a spreadsheet? Many genuinely useful projects can be built with no code at all. Code becomes necessary when you need automation, scale, or precision that chatbot prompts cannot deliver.
Section 4 of 5
💡 Five School-Friendly Project Templates
Project 1
📚 Subject Summary Bot
Goal: Create a 1-page plain-English summary of any textbook chapter
Step 1: Pick a chapter you are currently studying.
Step 2: Prompt: "I am a Class 8 student. Summarise this chapter for me in bullet points. Use simple language. Highlight the 5 most important concepts."
Step 3: Paste the chapter text (or key sections).
Step 4: Review the output. Correct any errors.
Step 5: Format as a study card. Save and share with classmates.
Step 2: Prompt: "I am a Class 8 student. Summarise this chapter for me in bullet points. Use simple language. Highlight the 5 most important concepts."
Step 3: Paste the chapter text (or key sections).
Step 4: Review the output. Correct any errors.
Step 5: Format as a study card. Save and share with classmates.
Project 2
📝 Exam Question Generator
Goal: Generate 10 practice questions with answers for any topic
Step 1: Choose a topic from your current syllabus.
Step 2: Prompt: "Generate 10 multiple-choice questions about [topic] at Class 8 level. Include the correct answer and a 1-sentence explanation for each."
Step 3: Review all questions and answers for accuracy.
Step 4: Use as a self-test or swap with a classmate.
Step 5: Iterate — ask for harder questions on topics you got wrong.
Step 2: Prompt: "Generate 10 multiple-choice questions about [topic] at Class 8 level. Include the correct answer and a 1-sentence explanation for each."
Step 3: Review all questions and answers for accuracy.
Step 4: Use as a self-test or swap with a classmate.
Step 5: Iterate — ask for harder questions on topics you got wrong.
Project 3
📊 Class Survey Analyser
Goal: Analyse your class's survey responses and write a summary report
Step 1: Conduct a simple 5-question survey in your class (favourite subject, most challenging topic, etc.).
Step 2: Enter the results in a Google Sheet.
Step 3: Prompt ChatGPT: "Here are the results of a class survey. Write a 200-word summary report of the key findings."
Step 4: Paste the data.
Step 5: Review and present to the class.
Step 2: Enter the results in a Google Sheet.
Step 3: Prompt ChatGPT: "Here are the results of a class survey. Write a 200-word summary report of the key findings."
Step 4: Paste the data.
Step 5: Review and present to the class.
Project 4
🌱 Community Problem Reporter
Goal: Document a local community issue clearly enough to share with decision-makers
Step 1: Identify a real local issue (broken road, water supply, school facility).
Step 2: Collect your own observations — photos (with parent permission), notes, dates.
Step 3: Prompt: "Help me write a clear 1-page report describing this problem, its impact, and a suggested solution, for a school principal / local councillor."
Step 4: Review, personalise, and share appropriately.
Step 2: Collect your own observations — photos (with parent permission), notes, dates.
Step 3: Prompt: "Help me write a clear 1-page report describing this problem, its impact, and a suggested solution, for a school principal / local councillor."
Step 4: Review, personalise, and share appropriately.
Project 5
🌐 Bilingual Explainer Creator
Goal: Turn an English lesson into a Telugu (or your language) explainer for a younger student
Step 1: Choose one concept from any lesson you understand well.
Step 2: Write a short English explanation in your own words (50–100 words).
Step 3: Prompt: "Translate this into simple Telugu (or Hindi, Tamil, Kannada) for a Class 5 student. Keep the meaning clear."
Step 4: Have a Telugu/Hindi speaker review the translation for accuracy.
Step 5: Share with a younger sibling or cousin.
Step 2: Write a short English explanation in your own words (50–100 words).
Step 3: Prompt: "Translate this into simple Telugu (or Hindi, Tamil, Kannada) for a Class 5 student. Keep the meaning clear."
Step 4: Have a Telugu/Hindi speaker review the translation for accuracy.
Step 5: Share with a younger sibling or cousin.
Section 5 of 5
🚫 Common Beginner Mistakes
Trusting AI output without checking: AI makes factual errors. For any project that will be used or shared, verify the key facts with a textbook, a trusted website, or a teacher.
Overly ambitious first version: "I want to build a full school management system" is not a first project. "I want to create a weekly homework tracker for my class" is. Start small, finish something, then expand.
Using AI to do all the thinking: The best projects combine your judgment with AI assistance. If you just paste a question and submit the first answer, you have not learned anything — and the quality is usually lower than if you engage critically with the output.
Skipping the "who is this for" question: Without a clear user and need, you may build something technically interesting that solves nothing. Define your user in the first step, not as an afterthought.
Giving up after the first failure: Every real AI project fails in the first version. Failure is information — it tells you what to fix. The only way to build is to iterate. Rahul's first spreadsheet had wrong formulas. He fixed them. That is engineering.
🛠️ Quiz — Lesson 10
8 questions · Click your answer · Submit for your score
1. The first step in the AI project planning framework is to:
2. When should you use Python for a project rather than a no-code chatbot approach?
3. Rahul's electricity bill tracker project was successful primarily because:
4. Why is "build a small version first" (Step 4 of the framework) important?
5. The most important test for whether an AI project idea is good is:
6. If you use AI to generate practice exam questions, the most important additional step is:
7. "Using AI to do all the thinking" is a mistake because:
8. The Bilingual Explainer Creator project (Template 5) requires one important human step after AI translation. That step is:
📝 Worksheet — Plan Your Project
Tip: in the print dialog, choose "Save as PDF" to download.In your notebook, design your own AI project using the framework from Section 1:
- Problem statement: "I want to help [who] do [what] better." Write your one sentence.
- Data/inputs: What information will your project need? Where will it come from? Is any of it sensitive?
- Tool choice: Which tool from the tool guide will you use, and why?
- Minimum version: What is the smallest thing you could build to test if your idea works? Describe it in 2–3 sentences.
- Success measure: How will you know if your project works? What would a real user say when it is useful vs when it is not?
📋 Note for Parents and Teachers
What this lesson covers: A 6-step AI project planning framework, how to define a good problem, a tool selection guide, five school-friendly project templates with step-by-step prompts, and common beginner mistakes. Designed to give students a structured way to apply their learning from Lessons 1–9 to a real project.
Practical note: The five project templates can all be completed without any paid tools. ChatGPT (free tier), Google Gemini (free), and Google Docs/Sheets (free) are sufficient for all five. Encourage students to start with Template 1 or 2 — they are the simplest and produce immediately useful outputs.