Q2 Spreadsheet Secrets: Introduction
Introduction
Case File 002: Cracking the Case with Spreadsheets
Every great detective needs the right tools—and in this case, your secret weapon is a spreadsheet. As a Data Detective, you will use spreadsheets to track the facts, spot patterns, and connect the dots. Think of it as your digital evidence board: instead of sticky notes and red string, you’ve got rows and columns ready to organize everything you uncover about the missing collectibles. With spreadsheets, your clues won’t just sit around—they’ll come together to reveal the truth!
learning objectives
I can:
- Identify parts of a spreadsheet, including columns, rows, cells, and header rows.
Consistently enter and organize data so it’s clear and searchable.
Every detective needs to know how to use their tools. Your next tool is a spreadsheet, the digital version of a detective’s notebook. Let’s take a little time to learn the basic essentials. The video below uses Microsoft Excel, but don’t worry, Google Sheets works the same way.
While playing the video below, be able to provide answers the following question once the video is done.
- What are the labels in the header row of this video?
- What information is in cell C10?
- What does C stand for?
- What does 10 stand for?
Microsoft Excel: Working with Rows and Columns
Direct link (2:47 min.)
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
1. Empowered Learner
d. Understand the fundamental concepts of technology operations, demonstrate the ability to choose, use, and troubleshoot current technologies, and transfer their knowledge to explore emerging technologies.
5. Computational Thinker
a. Formulateproblem definitions suited for technology-assisted methods such as data analysis, abstract models, and algorithmic thinking in exploring and finding solutions.
b. Collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
c. Break problems into parts, extract key information, and develop descriptive models to understand complex systems or facilitate problem-solving.
6. Creative Communicator
c. Communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models, or simulations.
d. Publish or present content that customizes the message and medium for a variety of audiences.
Websites
Videos from Outside Sources