← Back to Session 7

Session 7 Study Guide: Introduction to Spreadsheets

Data Science for Young Minds — Grade 3

Key Topics

TopicDetails
What a spreadsheet isWhat a spreadsheet is: a grid for organizing numbers and text
Rows (horizontal, numbered) and columns Rows (horizontal, numbered) and columns (vertical, lettered)
CellsCells: where a row and column meet (like A1, B3, C7)
ActivityActivity: open a spreadsheet and navigate to specific cells
Typing data into cellsTyping data into cells: numbers, text, and dates
Making headers bold and clearMaking headers bold and clear
Adjusting column widths to fit your dataAdjusting column widths to fit your data
ActivityActivity: enter your class survey data into a spreadsheet
What a formula isWhat a formula is: an instruction that calculates automatically
SUMSUM: add up a range of numbers
AVERAGEAVERAGE: find the mean
COUNT, MAX, MINCOUNT, MAX, MIN: how many, highest, lowest
Selecting data for a chartSelecting data for a chart
Choosing the right chart typeChoosing the right chart type
CustomizingCustomizing: titles, labels, colors
ActivityActivity: create a bar chart and a line chart from your data

Lesson Summaries

Lesson 1: What Is a Spreadsheet?

Explore the spreadsheet interface: rows, columns, cells, and how to navigate the grid.

Lesson 2: Entering and Formatting Data

Learn to enter your survey data into a spreadsheet and make it look clean and readable.

Lesson 3: Basic Formulas

Learn the 5 most important spreadsheet formulas: SUM, AVERAGE, COUNT, MAX, and MIN.

Lesson 4: Creating Charts

Turn your spreadsheet data into beautiful graphs with just a few clicks.

Review Questions

  1. What is a spreadsheet?
  2. What is a cell?
  3. Why are spreadsheets useful?
  4. What free spreadsheet can you use?
  5. How do you enter data into a spreadsheet?
  6. Why should headers be bold?
  7. How do you adjust column width?
  8. What types of data can go in a cell?
  9. What is a formula?
  10. How do you write a SUM formula?
  11. What does =AVERAGE(B2:B20) do?
  12. What do MAX and MIN do?
  13. How do you create a chart from spreadsheet data?
  14. How do you choose the right chart type?
  15. How do you add a title to your chart?
  16. What is the advantage of charts in a spreadsheet vs. by hand?