Q3 Order in the Clue Room: Introduction
Introduction
You tracked down clues from your classmates and uncovered which collectible items had gone missing. Along the way, you discovered that tools like Forms (or Surveys) can turn answers into a spreadsheet and even make charts for you automatically. You also practiced entering everyone’s birthdays into a sheet to keep things neat and easy to compare. But sometimes you won’t get perfectly organized information. You will get a messy spreadsheet and need to sort it out yourself. In this Quest, you will learn how to organize your files in a folder and clean up a spreadsheet so your data becomes clear, useful, and detective-ready.
learning objectives
I can:
- Categorize different types of data.
- Use sorting and filtering tools in Google Sheets or Microsoft Excel.
- Identify patterns and potential connections from the organized data.
Your first find of the day!
As you enter class on this day, you think that we didn’t really get anywhere in our mystery. But as you approach your desk, you see a folder with a post-it note. The note says, “What’s in Row 10?”
You open the folder and… It’s a folder of spreadsheets!
Step 1. Select (open) the link to the folder of spreadsheets below the picture of the desk.
Step 2. Scan the contents of the folder and notice that one of the items has instructions on it. Read the instructions so that you know what you will be accomplishing in this Quest.
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
21T4S Documents & Quizzes