Making Charts in Google Sheets
📋 Before You Start
To get the most from this chapter, you should be comfortable with: foundational concepts in computer science, basic problem-solving skills
Making Charts in Google Sheets
What is Google Sheets?
Google Sheets is like a spreadsheet on the internet. You organize data in rows and columns, like a table. You can share it with others. Once your data is in Sheets, you can turn it into charts and graphs with just a few clicks!
Entering Data
Type your data into cells. First column is the label (like "fruit" or "subject"). Other columns are the data (like numbers of students). When you finish entering data, Google Sheets is ready to make charts. The more organized your data, the better your chart!
Creating Charts
Highlight your data. Click Insert and choose Chart. Google Sheets shows you chart suggestions! Bar charts, pie charts, line charts, all appear. Pick the chart you like. It automatically updates if your data changes. You can edit colors and labels to make it perfect.
Key Takeaways
- Google Sheets = spreadsheet on the internet
- Organize data in rows and columns
- Charts automatically from your data
- Share your spreadsheet with others
🧪 Try This!
- Quick Check: Name 3 variables that could store information about your school
- Apply It: Write a simple program that stores your name, age, and favorite subject in variables, then prints them
- Challenge: Create a program that stores 5 pieces of information and performs calculations with them
Let Us Go on an Adventure!
Close your eyes for a moment. Imagine you are a tiny explorer, small enough to fit inside a computer. What would you see? Glowing wires carrying messages, tiny switches flipping on and off millions of times every second, and a brain made of electricity that can remember everything it has ever been told. Sounds like a science fiction movie, right? But this is REAL, and it is happening inside the device you are reading this on right now!
Today we are going to explore something really exciting: Making Charts in Google Sheets. By the time you finish reading this, you will understand something that most grown-ups do not even know. How cool is that? You will be able to explain it to your friends, your parents, maybe even your teacher. Ready? Let us begin!
What is a Database? Think of a Super-Organised Diary!
Imagine you have a diary where you write down everything about your friends — their names, birthdays, favourite colours, and favourite foods. Now imagine that diary is SO smart that when you ask "Which of my friends has a birthday in March?", it instantly shows you the answer! That is what a database does.
┌─────────────────────────────────────────────────┐
│ MY FRIENDS DATABASE │
├────────┬──────────┬───────────┬────────────────┤
│ Name │ Birthday │ Colour │ Favourite Food │
├────────┼──────────┼───────────┼────────────────┤
│ Ananya │ 15 Mar │ Purple │ Biryani │
│ Rohan │ 22 Jul │ Blue │ Pizza │
│ Meera │ 03 Mar │ Green │ Dosa │
│ Arjun │ 11 Nov │ Red │ Pani Puri │
│ Zara │ 28 Mar │ Yellow │ Pasta │
└────────┴──────────┴───────────┴────────────────┘
Question: "Friends with birthday in March?"
Answer: Ananya (15 Mar), Meera (3 Mar), Zara (28 Mar)! 🎂Every app you use has a database behind it. When you scroll through Instagram, a database stores all the posts and photos. When you order food on Zomato, a database keeps track of restaurants, menus, and your order history. Even your school has a database with information about every student — your name, class, roll number, marks, and attendance!
Did You Know?
🇮🇳 India's UPI processes more transactions than the entire US credit card system combined. The Unified Payments Interface (UPI) handled over 10 billion transactions in 2024 — that is more than 300 transactions per SECOND, 24/7. Imagine that: while you are reading this sentence, thousands of Indians are sending money to each other using a system built by Indian engineers!
📡 The internet cables under the Indian Ocean. Submarine cables connecting India to the world are thousands of kilometres long and as thick as a garden hose. Yet they carry 99% of all international data traffic. The landing stations in Mumbai and Chennai are architectural wonders, handling data flowing in and out of the entire country.
🛰️ Chandrayaan proved India's tech power. In 2023, India's Chandrayaan-3 mission became the FIRST spacecraft to land in the South Pole of the Moon. The software that controlled this spacecraft, the algorithms that navigated it, and the computers that tracked it were all built by Indian scientists at ISRO. Computer Science at its finest!
🏢 India's IT industry is a superpower. Infosys, TCS, Wipro, and HCL Technologies are among the world's largest IT companies, all founded by Indians. Combined, they employ over 2 million people worldwide and generate over $200 billion in revenue. These companies use the exact concepts you are learning right now.
Let Us Think About It This Way
Imagine you are playing a game of cricket with your friends. The captain is like the CPU — making all the decisions. The scorekeeper is like the memory — remembering everything that happened. The cricket pitch is like the internet — it is the space where all the action happens. And the rules of cricket? Those are like the program — they tell everyone what to do and when. Just like every cricket match follows the same rules, every computer follows its programs!
How It Works — Step by Step
Let me walk you through making charts in google sheets like a teacher drawing on a whiteboard. Imagine we are sitting together in a quiet room, and I am showing you exactly how this works, one step at a time.
Step 1: The Problem Begins
Every making charts in google sheets starts with a problem. A computer needs to do something: display a website, recognize your face, calculate a result, or send a message. The computer does not know how to do it yet — it just knows there is work to do.
Step 2: Break It Into Pieces
Instead of trying to solve the whole problem at once (which is impossible), we break it into tiny, manageable pieces. It is like if someone asked you to clean your entire house — you do not clean everything at once. You start with your room, then the bathroom, then the kitchen. Same thing here.
Step 3: Write the Instructions
For each small piece, we write clear instructions. "Take this piece of information. Check if it is bigger than that piece. If yes, do this. If no, do that." The instructions are so simple that even a machine with no common sense can follow them perfectly.
Step 4: The Machine Follows Along
The computer reads the instructions one by one, incredibly fast. It performs each step, stores results, and moves to the next instruction. This is happening millions of times per second inside your device.
Step 5: Combine the Results
As each small piece is completed, we combine all the results back together. Now we have solved the big problem by solving many small problems. It is like building a house: you build walls, doors, roof, and floor separately, then put them all together into one complete house.
What is an Algorithm? A Recipe for Solving Problems!
An algorithm is just a step-by-step set of instructions. You follow algorithms every day without knowing it! Here is an algorithm for making chai:
ALGORITHM: Make Perfect Chai ☕
Step 1: Pour 1 cup water into a pan
Step 2: Add 1 spoon tea leaves
Step 3: Add 1 spoon sugar (or less if you prefer)
Step 4: Add a small piece of ginger (adrak)
Step 5: Boil for 2 minutes
Step 6: Add 1 cup milk
Step 7: Boil again for 3 minutes
Step 8: Pour through a strainer into a cup
Step 9: Enjoy your chai! ☕
A COMPUTER ALGORITHM works the same way:
ALGORITHM: Find the Biggest Number
Step 1: Look at the first number — remember it as "biggest"
Step 2: Look at the next number
Step 3: Is it bigger than "biggest"? If YES, it becomes the new "biggest"
Step 4: Are there more numbers? If YES, go to Step 2
Step 5: The "biggest" number is your answer!See? An algorithm is just clear, step-by-step instructions that anyone (or any computer) can follow. The chai algorithm is for humans. The number-finding algorithm is for computers. But both work the same way: start at the beginning, follow each step in order, and you get the right result every time!
Real Story from India
Aarav's Digital Classroom
Aarav lives in a small village 200 kilometres from Bangalore. His school has no computer lab, and the best teachers teach in the cities. But two years ago, something changed. His school got connected to the internet, and now Aarav can access DIKSHA — a platform built by the Indian government that provides digital lessons in Hindi, Marathi, Tamil, and 18 other Indian languages.
Through DIKSHA, Aarav watches lessons taught by excellent teachers, solves practice problems, and gets instant feedback. His teacher can see which topics Aarav is struggling with and give him extra help. The platform uses making charts in google sheets — technology that learns from how Aarav studies and suggests lessons he needs most.
What would have been impossible 10 years ago — a village student in India getting personalized, world-class education — is now real. And it was built by Indian engineers at DIKSHA who understood that technology could be a bridge between rural and urban India.
Today, millions of Indian students like Aarav are learning using technology. And every single one of them is using systems built using the concepts from this chapter. YOU could be the engineer who builds the next DIKSHA!
The Story Behind the Screen
Let us take a journey through time! In 1833, a British mathematician named Charles Babbage designed the first general-purpose computer — but it was never built because the technology did not exist yet. His friend Ada Lovelace wrote the first computer program EVER, making her the world's first programmer. And this was almost 200 years ago!
Fast forward to India: in 1991, India opened up its economy and the IT revolution began. Young engineers from small towns across India flocked to cities like Bangalore, Hyderabad, and Chennai. They learned programming, built software for companies around the world, and turned India into the "IT capital of the world." Today, Indian-origin CEOs lead some of the biggest tech companies: Satya Nadella at Microsoft, Sundar Pichai at Google, and Shantanu Narayen at Adobe. They all started exactly where you are — learning the basics!
The concept of making charts in google sheets that you are studying right now is one of the building blocks that made all of this possible. Without people understanding these ideas, there would be no UPI, no Google, no Instagram, no online classes, and no way for your family to video-call relatives in other cities. Every single digital thing you use today was built by someone who once sat in a classroom just like yours and learned exactly what you are learning now.
In India today, there are over 30,000 startups working on technology problems. Some are building apps for farmers to sell their crops at better prices. Others are creating AI that helps doctors diagnose diseases early. Some are building robots that can explore dangerous places. All of them use the concepts from your computer science chapters. The question is not whether you CAN be part of this — you absolutely can. The question is WHAT amazing things will YOU build?
Test Yourself! 🧠
Try answering these questions to see if you understood the chapter:
Question 1: Can you explain making charts in google sheets to a friend using your own words? Try it! If you can explain it simply, you really understand it.
Answer: If you can explain it without using fancy words, you have got it!
Question 2: Where do you see making charts in google sheets being used in your daily life? Think about your phone, computer, games, or apps you use.
Answer: There are many examples! The more you find, the better you understand how it works in the real world.
Question 3: What would happen if making charts in google sheets did not exist? Imagine your world without it. What would be different?
Answer: Thinking through this shows you understand its importance!
Key Vocabulary
Here are important terms from this chapter that you should know:
🎯 Try This At Home!
Here is an experiment you can do right now: ask your parent or older sibling to show you the "Inspect" option on a web browser (right-click on any website and select "Inspect"). You will see the actual code behind the website — all those HTML tags, CSS colours, and JavaScript functions. It looks complicated, but every single part of it is made of the simple building blocks you are learning about. Try changing some text or a colour and watch the page change! Do not worry — refreshing the page will bring everything back to normal.
What You Learned Today
Wow, you have come a long way in this chapter! Let us think about everything you discovered. You learned about making charts in google sheets — something that billions of people around the world use every day, but very few actually understand how it works. YOU are now one of those special people who understands it! The next time someone says something about computers, you can say "I actually know how that works!" How amazing is that?
Remember, every expert was once a beginner. The scientists who built India's supercomputers, the engineers who created UPI, the team at ISRO who landed Chandrayaan on the Moon — they all started exactly where you are right now: curious, excited, and ready to learn. Keep that curiosity alive, keep asking "how does that work?", and you will be amazed at where it takes you.
Crafted for Class 1–3 • Data Science • Aligned with NEP 2020 & CBSE Curriculum