Before you keep reading...
Runestone Academy can only continue if we get support from individuals like you. As a student you are well aware of the high cost of textbooks. Our mission is to provide great books to you for free, but we ask that you consider a $10 donation, more if you can or less if $10 is a burden.
Before you keep reading...
Making great stuff takes time and $$. If you appreciate the book you are reading now and want to keep quality materials free for other students please consider a donation to Runestone Academy. We ask that you consider a $10 donation, but if you can give more thats great, if $10 is too much for your budget we would be happy with whatever you can afford as a show of support.
7.3. Visualizing Data¶
This lesson introduces students to data manipulation and visualization using Google spreadsheets and Google My Maps. Students will follow tutorials to learn how to import data and create visualizations of it. These tools will be used in the next lesson where students explore a data set of their own choosing.
The Student Lesson: Complete the activities for Mobile CSP Unit 7: Lesson 7.3 Visualizing Data.
- Computer lab
- Access to Google Drive and Google Maps
7.3.1. Learning Activities¶
Estimated Length: 45 minutes
- Hook/Motivation (5 minutes): Using the animated gif image from census.gov or another data visualization of your own choice, put the graphic of the data on the projector and ask the students these questions about it:
- What is the data shown in this visualization?
- What type of data is used — text, numbers, geocodes, date and time, etc.?
- What conclusions can you draw from the data?
- How is the data presented in the visualization that makes it easy to understand and use?
- What are the drawbacks of this visualization?
- Experiences and Explorations (30 minutes):
- Activity Intro: Explain the instructions for today's class. Students will follow the student tutorials to answer the questions working in pairs.
- Activity 1: May be done as a class or in pairs
- Activity 2: Have the students follow to create formulas and charts with the given data set on butterflies using Google Sheets.
- Activity 3: Have students create a map of the data using Google My Maps following the tutorial. Here's a possible solution
- Rethink, Reflect and/or Revise (10 minutes): Have students complete their reflection in their portfolios.
The College Board's AP Classroom provides a question bank and Topic Questions. You may create a formative assessment quiz in AP Classroom, assign the quiz (a set of questions), and then review the results in class to identify and address any student misunderstandings. The following are suggested topic questions that you could assign once students have completed this lesson.
Suggested Topic Questions:
- Topic 2.4 Using Programs with Data
- Note: Solutions are only available to verified educators who have joined the Teaching Mobile CSP Google group/forum in Unit 1.
- Quizly Solutions
- Portfolio Reflection Questions Solutions
You can examine students’ work on the interactive exercise and their reflection portfolio entries to assess their progress on the following learning objectives. If students are able to do what is listed there, they are ready to move on to the next lesson.
- Interactive Exercises:
- Portfolio Reflections:
LO X.X.X - Students should be able to ...
- In the XXX App, look for:
Differentiation: More Practice
If students are struggling with lesson concepts, have them review the following resources:
- Google Sheets Tutorial, especially on Functions
- Google My Maps Help Center
Students can explore the data sets and create additional visualizations. Here is a Google My Maps Tutorials using shark spotting data. In Unit 9, there is also an optional app using Google Fusion Tables.
(Optional) Voter Registration lesson from the Civic Knowledge and Action Project in collaboration with the College Board. This optional lesson plan develops students' understanding of how to use programs to process voter registration and turnout data to discover information and create new knowledge. The materials map to skills 2.B and 5.B in the AP Computer Science Principles Course and Exam Description.
7.3.2. Professional Development Reflection¶
Discuss the following questions with other teachers in your professional development program.
I am confident I can teach this lesson to my students.
- 1. Strongly Agree
- 2. Agree
- 3. Neutral
- 4. Disagree
- 5. Strongly Disagree