MassCUE Logo

Collecting, Organizing and Visualizing Data

Data is such an important part of our lives. Data is collected every day, whether it pertains to school work or during our personal lives. It has become important that our students have an understanding of how to analyze and work with data. In this workshop, participants will gather a skillset on how data can be collected, how it can be arranged after the data has been collected, as well as how the data should be visualized for others. Tools that will be used in the session: Google Forms, Google Sheets, Google Data Studio and Canva for Education.

NOTE: It is important to note we will only focus on how to use Data Studio when not collecting PII. Presenter will highlight how Data Studio can be used for students to analyze information. Participants will have an opportunity to test out features that are being demonstrated with sample data provided as well as have an opportunity to create something on their own. Presenter will also highlight on how to use Canva under the free Canva for Education account.

 

REGISTRATION DEADLINE:  April 26, 2022

Course Details

Audience Educators & Administrators  Grades 6-12  
Level All
Instructor Craig Sheil  @csheil [7]
Dates May 3, 2022 through May 24, 2022

Required Meets – Tuesdays 

May 3, 2022: 4:15pm – 5:45pm

May 10, 2022: 4:15pm – 5:45pm

May 17, 2022: 4:15pm – 5:45pm

May 24, 2022: 4:15pm – 5:45pm

Additional Self-Paced Hours: 6 

Earn 12 PDPs 
Location Online
MassCUE Member Cost $150.00
Non-Member Cost $190.00
Limit 20 Participants
Optional WSU Graduate Credit Pending – At the first class, participants may choose to register for 1 graduate credit through Worcester State University for an additional fee of $125.

Craig Sheil

Craig is a Digital Learning Specialist at Bedford High School, a public school in Bedford, NH. He has been in the educational field for 18 years – where he initially started out sharing his love for mathematics to high school students. Over the past five years, Craig has helped Bedford High transition into a 1:1 Chromebook program. He can also be found sharing his love of teaching others at Fitchburg State University, where he co-teaches several technology courses for educators, as well as local conferences. He has been a Google for Education Certified Trainer since 2014. 

Twitter: @csheil  [8]

Blog: www.craigmsheil.com [9] 

COURSE OUTLINE

Week 1: COLLECTING and ORGANIZING DATA (Google Forms and Sheets)  

Back to the basics. Before we can work with data, we have to make sure the data we are collecting is in fact what we are looking for. We will explore how data can and should be collected through use of Google Forms and Google Sheets. What type of questions work best? How should data be organized?  

Tuesday, May 3, 2022 4:15 – 5:45 pm – Required Google Meet

Self Paced Learning – 1 additional hour

Week 2: VISUALIZE DATA (DATA STUDIO) 

You have analyzed the data and it is time to tell a story with the data that has been collected. Google Data Studio can help us with this. We will walk through how to create a Data Studio with sample data. (It is important to note we will only focus on how to use Data Studio without using PII). 

Tuesday, May 10, 2022 4:15 – 5:45 pm – Required Google Meet

Self Paced Learning – 2 additional hours

Week 3: VISUALIZE DATA (DATA STUDIO) 

We will continue our conversation and discovery with Google Data Studio. 

Tuesday, May 17, 2022 4:15 – 5:45 pm – Required Google Meet

Self Paced Learning – 2 additional hours

WEEK 4: VISUALIZE DATA (OTHER TOOLS) 

This week, we will look at other tools that help us tell stories based on data that has been collected. Sometimes, you don’t need a full in-depth data studio dashboard to tell a story. We will take a look at how to pull data from spreadsheets into infographics (using Canva for Education) or maps (using Google Maps).

Tuesday, May 24, 2022 4:15 – 5:45 pm – Required Google Meet

Self Paced Learning – 1 additional hours

DESE DLCS Standards

This course supports the following Massachusetts Digital Literacy and Computer Science standards:  

6 – 8.CT.c.3 Create, modify, and use a database (e.g., define field formats, add new records, manipulate data), individually and collaboratively, to analyze data and propose solutions for a task/problem. 

6 – 8.CT.c.4 Perform a variety of operations such as sorting, filtering, and searching in a database to organize and display information in a variety of ways such as number formats (scientific notation and percentages), charts, tables, and graphs. 

6 – 8.CT.c.5  Select and use data-collection technology (e.g., probes, handheld devices, geographic mapping systems) to individually and collaboratively gather, view, organize, analyze, and report results for content-related problems. 

6 – 8.CT.e.1 Create a model of a real-world system and explain why some details, features and behaviors were required in the model and why some could be ignored. 

9 – 12.DTC.b.1  Communicate and publish key ideas and details to a variety of audiences using digital tools and media-rich resources. 

9 – 12.DTC.b.2 Perform advanced searches to locate information and/or design a data-collection approach to gather original data (e.g., qualitative interviews, surveys, prototypes, simulations). 

9 – 12.DTC.c.3  Evaluate digital sources needed to solve a given problem (e.g., reliability, point of view, relevancy). 

9 – 12.DTC.c.4  Gather, organize, analyze, and synthesize information using a variety of digital tools. 

9 – 12.DTC.c.5  Create an artifact that answers a research question, communicates results and conclusions, and cites sources. 

9 – 12.CT.c.3 Create, evaluate, and revise data visualization for communication and knowledge. 

Sign Up for This Workshop

Collecting, Organizing and Visualizing Data

Required Meets – Tuesdays: 

May 3, 2022  4:15 – 5:45pm

May 10, 2022 4:15 – 5:45pm

May 17, 2022 4:15 – 5:45pm

May 24, 2022 4:15 – 5:45pm

Additional Self-Paced Hours: 6 

Register Now [10]

 

REGISTRATION DEADLINE: April 26, 2022