Computer Science
Grade 3
20 min
What is a Spreadsheet?: Introducing Rows and Columns
Students will learn the basic layout of a spreadsheet and its components (rows, columns, cells).
Tutorial Preview
1
Introduction & Learning Objectives
Learning Objectives
Define the term 'spreadsheet' as a tool for organizing information.
Identify a column by its letter and a row by its number.
Explain that columns go up and down (vertically).
Explain that rows go side to side (horizontally).
Define a 'cell' as the box where a row and column meet.
Place a single piece of data into the correct cell within a simple table.
Have you ever tried to count all your toys or figure out your friends' favorite ice cream flavors? 🍦 A spreadsheet is like a super-organized grid that helps us keep track of all that information!
Today, we are going to learn about a computer tool called a spreadsheet. We will discover what rows and columns are and how they help us organize data, which is just another word for info...
2
Key Concepts & Vocabulary
TermDefinitionExample
SpreadsheetA computer program that helps you organize information in a grid of rows and columns.A list of students and their favorite subjects, organized neatly in a grid on a computer.
ColumnA line of boxes that goes up and down (vertically). Columns are usually labeled with letters (A, B, C...).In a list of pets, Column A might have all the pets' names.
RowA line of boxes that goes from side to side (horizontally). Rows are usually labeled with numbers (1, 2, 3...).In a list of pets, Row 2 might have all the information about one specific pet, like a dog named Sparky.
CellA single box in a spreadsheet where a column and a row meet. Each cell has an address, like A1 or B3.The box where Column B (Owner's Name) and Row 2 (Sparky the dog) meet is cell B2. It...
3
Core Syntax & Patterns
Columns are for Categories
Each column should hold only one type of information.
When you set up your spreadsheet, decide what categories of information you have. For example, if you're listing friends, your columns might be 'Name', 'Birthday Month', and 'Favorite Color'. Don't mix names and birthdays in the same column.
Rows are for Items
Each row should hold all the information for one single item.
Think of each row as a story about one thing. In a list of friends, Row 2 would have all the information about one friend: their name, their birthday month, and their favorite color, each in a different column.
One Thing Per Cell
Each cell should only hold one piece of data.
To keep things neat, don't write 'Maria, Blue&#...
4 more steps in this tutorial
Sign up free to access the complete tutorial with worked examples and practice.
Sign Up Free to ContinueSample Practice Questions
Challenging
You're tracking scores for a reading contest. Column A has student names. You want to add scores for Week 1, Week 2, and Week 3. What is the best way to add this information?
A.Make new columns B, C, and D for "Week 1", "Week 2", and "Week 3"
B.Put all three scores in Column B for each student
C.Make new rows under each student for their weekly scores
D.Add the scores to the student's name in Column A
Challenging
A row in a spreadsheet contains this data in order: "Carrot", "Orange", "Vegetable". What are the most likely titles for Column A, Column B, and Column C?
A.A: Food, B: Color, C: Food Group
B.A: Color, B: Food, C: Food Group
C.A: Food Group, B: Color, C: Food
D.A: Food, B: Food Group, C: Color
Challenging
A spreadsheet is set up to track class pets. Row 1 has the titles: "Pet Name" in A1, "Pet Type" in B1, and "Owner" in C1. What information would you expect to find in cell B3?
A.The name of the third student who owns a pet
B.The title "Pet Type"
C.The name of the pet in the third row
D.The type of pet listed in the third row (like "Hamster" or "Fish")
Want to practice and check your answers?
Sign up to access all questions with instant feedback, explanations, and progress tracking.
Start Practicing Free