Q3 Order in the Clue Room: Filtering
Finding Clues with Filters
Next task to complete in making sense of the sticky note on the folder that said, "What's in Row 10?" and the instructions document that was in the folder of spreadsheets that stated to sort and filter, is to learn how to filter the spreadsheets.
Step 1. Play the video below that provides instructions on how to add a filter view. The video is specifically on Google Sheets. Those who are using Microsoft Excel, don't fret, the steps are basically the same. This video is for you, PC Quick Tip 2 - Filtering Data in Excel (0:59 min.).
- Jot down notes while the video is playing.
How to Create and Use Filter View
Direct link (2:43 min.)
Step 2. Go to your 13. Data Detective Notebook that you have saved in your 21T4S Thing 13 Data Detectives Folder. On slide 6, Q3 Order in the Classroom: Filtering, in your own words, write down the steps you need to do to create a filter view in a spreadsheet.
Step 3. Now that you have learned how to create a filter view in a spreadsheet, it is time to practice. Recall the last instruction from the document in 13. DD Spreadsheet Folder had to do with filtering? Let's see if that helps with finding some clues.
- Return to the Birthday Data Collection Spreadsheet, that you created, in your 21T4S Thing 13 Data Detectives Folder and complete the filtering.
Step 4. Return to your 13. Data Detective Notebook that you have saved in your 21T4S Thing 13 Data Detectives Folder. Again, on slide 6, reflect back on the clues so far. What do you notice based on the filtering of your Birthday Data Collection Spreadsheet? Write down your observations.
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
5. Computational Thinker
b. collect data or identify relevant data sets
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 and Documents
Videos from Outside Sources
- PC Quick Tip 2 - Filtering Data in Excel YouTube (0:59 min.)
- How to Create and Use Filter View YouTube (2:43 min.)
21T4S Documents & Quizzes