EN ES

For full access, please log in or sign up for a FREE account

Log In Sign Up
  1. Lesson Plans
  2. Graphify: Create a Data-Driven Bar Graph App
Details

Graphify: Create a Data-Driven Bar Graph App

sofware
Software: Google Sheets , Thunkable
| print Print as PDF |
Like (1)
|
Share

Looking for an engaging and innovative way to teach your learners about data collection and analysis? In this lesson, learners will work in teams to collect specific data from their peers in the classroom, using digital tools to create bar graphs that display their findings. But that's just the beginning! From there, learners will put their computational thinking skills to work as they design and develop their own app that uniquely and creatively showcases their data. Finally, learners will present their apps to their peers, using digital communication tools to share their findings and demonstrate their mastery of the material. With opportunities for collaboration, problem-solving, and creativity, this lesson is sure to engage and inspire learners of all ages and abilities!

 

Lesson Overview

   Overview  Activity Objectives
Opening Activity   Learners will get to know the advantages of Bar Graphs and will participate in a challenge where they will document scores and present them using bar graphs.
  • Understand the purpose and characteristics of a bar graph. 
Main Activity  Learners will strengthen their knowledge of data visualization by collecting information about their interest level from peers and creating an app to present the information collected. 
  • Collect and analyze data from peers using digital tools and methods.
  • Create a bar graph that accurately represents the collected data and draw meaningful conclusions.
  • Design and develop an app to effectively showcase the data in a unique and creative way.
 
Closing Activity   Learners will share their creations with peers. 
  • Share findings and app design with peers using digital communication tools. 

 

Prior Knowledge:

Learners should be able to:

  • Collect data through surveys, gforms, etc.
  • Represent data using Bar graphs.

 

Lesson Objectives:
Learners will:

  • Understand the purpose and characteristics of a bar graph.
  • Collect and analyze data from peers using digital tools and methods.
  • Create a bar graph that accurately represents the collected data and draw meaningful conclusions.
  • Design and develop an app to showcase the data in a unique and creative way effectively.
  • Share findings and app design with peers using digital communication tools.
  • Collaborate in teams to achieve a shared goal.

 

Learning Outcomes:
By the end of this lesson, learners will be able to: 

  • Demonstrate an understanding of the purpose and characteristics of a bar graph.
  • Show an understanding of the purpose and importance of data collection and analysis.
  • Utilize digital tools and methods to collect and analyze data, drawing meaningful conclusions based on their findings.
  • Create a visually accurate bar graph representing the collected data and use it to draw meaningful conclusions.
  • Apply computational thinking skills to design and develop an app that effectively showcases the data.
  • Effectively communicate findings and app design to peers using digital communication tools.
  • Demonstrate collaboration skills by working in teams, sharing ideas, and contributing to a shared goal.

 

 

Pre-lesson Prep

  • Like all lessons on Eddy, this lesson follows a certain approach. If this is your first time implementing an Eddy lesson, check out our lesson approach for more information.
  • Prepare necessary logistics in advance.
  • Prepare necessary technology/hardware in advance.
    • Devices (tablets/laptops/Chromebooks/computers) - one per team
    • A stable Wi-Fi connection.
    • Access to https://thunkable.com/ on each device.
    • Access to Google Sheets on each device.
    • Projector

 

 

Slide ImageSlide Image

Slide 1, 2

Introduce learners to the lesson objectives.
Slide Image

Slide 3

 Engage learners by presenting a scenario where they are opening an organic grocery store and need to identify regions with high consumption for profitability. Prompt them to consider the methods they would use to determine these regions. For example, they might suggest surveys or data indicating consumption rates.
Slide Image

Slide 4

Next, show them two ways of representing the data on a slide and ask which method they prefer and why. Anticipate responses such as preferring the bar graph because it allows for a quick visual understanding of regions with high consumption, saving time compared to reading numbers and drawing conclusions.

Affirm the correctness of the response by saying, “Excellent! You are absolutely correct. The bar graph provides a clear and efficient way to identify regions with high consumption of organic food items. We can easily determine which regions have good consumption rates with just a single glance. Well done!”
Slide Image

Slide 5

 Introduce learners to what is meant by a Bar Graph. 
Slide Image

Slide 6

Ask: What are some advantages of displaying data via Bar Graphs?
Expected responses: Bar graphs are easy to read and understand. They also fit in extensive data.
Affirm correct responses by saying:

  • Bar graphs are easy to read and understand, especially for visual learners.
  • They allow for quick comparisons between different categories or groups.
  • Bar graphs provide a visual representation that helps identify trends and patterns in data.
  • They make it easier to draw conclusions and make predictions based on the information presented.
  • Bar graphs effectively display large amounts of data in a compact and organized manner.
  • They allow for clear communication and presentation of data to others.
Slide Image

Slide 7

 Introduce learners to the process of representing data via bar graphs. 
Slide Image

Slide 8

 Walk learners through the elements of a Bar Graph.
Slide ImageSlide Image

Slide 9, 10

To help learners understand the benefits of bar graphs compared to textual data representation, you can provide them with an example using Covid cases. On slide 9, display a large Excel sheet filled with Covid case data. On slide 10, present the same data as a bar graph.

To make it engaging for learners, you can ask them to identify which area had the highest Covid cases. Pause at each slide and allow them time to analyze and determine the answer. This interactive approach encourages critical thinking and allows students to visually observe how bar graphs can simplify data comprehension compared to raw text.
Slide ImageSlide Image

Slide 11, 12

Introduce learners to the Game and share that we will document the scores using bar graphs for this game. You can project the Bottle Flip Challenge Worksheet on the screen and assign the task of entering the data to learners. 

Conclude the activity by asking learners to determine who is the winner. 

NOTE: Teachers may check out this activity as a less logistics-intensive alternative to the Bottle Flip Challenge.
Jellybean Tree Game: In the Jellybean Tree, learners will watch as tree sprouts with different colored jellybeans. Red, orange, yellow, green, and purple jellybeans will appear. Each time the game is played, there will be a different number of jellybeans and a different number of each color of jellybean, always between 25 and 50. Users can then “pick” the jellybeans and drag and drop them to their correct places in a bar graph shown on the other side of the screen. They also changed the view to make the bar graph a pie chart. Finally, the user must answer five questions involving the “jellybean tree.” (Source: https://mrnussbaum.com/the-jellybean-tree-online-game)

 

 

 
Slide Image

Slide 11


Introduce learners to the task they’re about to embark on. Share that they would collect data from peers today and create a custom app that would display data as a bar graph.

Slide Image

Slide 12

 

Get learners excited and geared up for the task by initiating discussion for the following questions:

What are some of your favourite mobile apps?

 
Slide Image

Slide 13


Highlight the popularity of the apps by sharing "These are some of the most popular apps in the world right now."
Ask learners if they recognize any of the apps, then proceed onto sharing a brief background information about the apps.
Encourage learners to think critically about the apps: "What do you think makes these apps so popular? What features do you like or dislike about them?"
Relate the apps to your lesson topic: "We will be creating a data visualization app today. While these apps may not display data in the same way, they all use technology to provide users with information in a useful and engaging way."
Motivate learners to think about the potential impact of creating their own app: "Who knows? Maybe one day, your app will be on a list of popular apps like these."
Slide Image

Slide 14


Ask learners on what they think are the steps involved in creating an app. Encourage them to think beyond the surface level and consider the complexities involved in creating and promoting an app. Using following  probing questions and prompts, you can help learners develop a deeper understanding of the steps involved in creating an app and the skills needed to succeed in this field:
What do you think are the main steps involved in creating an app?
- Can you break down the process of creating an app into smaller steps?
- What do you think is the most important step in creating an app?
How do you think people decide on what kind of app to create?
- What factors do you think influence their decision?
- How do they determine the purpose and target audience of the app?
What do you think are the most important technical skills needed to create an app?
- Do you think coding is the most important skill? Why or why not?
- What other technical skills do you think are important?
Slide Image

Slide 15


Share the steps of App development with learners:
Ideate: This step involves brainstorming and coming up with ideas for the app, defining the purpose and target audience, and conducting market research.
Design: In this step, designers create wireframes and mockups, define the user experience, and create visual designs.
Code: This step involves writing the actual code for the app, developing the functionality, and integrating various technologies and systems.
Test: In this step, the app is tested for bugs, errors, and functionality. Testers provide feedback on usability and user experience, and developers make necessary changes.
Improve: This step involves continuous improvement of the app based on user feedback, data analysis, and performance metrics. Developers add new features, fix bugs, and optimize the app for better performance and user engagement.
Slide Image

Slide 16


Share the ideation worksheets with learner groups. Apprise them of the task by sharing that they would now brainstorm and finalise the genre of their app, collect relevant data, store it in an excel sheet and sketch wireframes for their app.
Slide ImageSlide Image

Slide 17, 18


Ask learners about what they think is a wireframe. Proceed onto slide 18 to share that A wireframe is like a blueprint for a website, app or software. It is a simple drawing that shows where everything goes on the screen, like pictures, text, and buttons. It helps people who are designing a website or app to figure out how it should look and work before they make it.
Slide Image

Slide 19

 

Ask learners: What kind of data will your app collect and display as a bar graph? Some categories are:

Sports

Education

Health and Fitness

Entertainment

Lifestyle

Travel

Weather

 
Slide Image

Slide 20

 

Apprise learners of the tasks in hand:

  • Filling Ideation sheet. 
  • Collecting peer data and storing in an excel sheet.
  • Creating wireframe of the app.

 

 
Slide ImageSlide Image

Slide 21, 22

This video tutorial will guide learners through the steps of making a bar graph in the spreadsheet.
Slide Image

Slide 23

Allow learners to work on the wireframe of the app.
Slide ImageSlide ImageSlide ImageSlide ImageSlide Image

Slide 24, 25, 26, 27, 28

Allow learners to sign in and introduce them to the interface.
Slide ImageSlide Image

Slide 29, 30

This video tutorial will guide learners through the steps of creating the app interface.
Slide Image

Slide 31

Ask learners if the app will work now. 

Expected responses may include that it will still need to be programmed to make it interactive.
Slide Image

Slide 32

This video tuitorial will guide learners through the steps of making the app interactive.
Slide Image

Slide 33

Ask learners to check the output screen.
Slide Image

Slide 34

Provide learners with some time to customie their app.
 

Icon
For beginners or learners who may struggle with the concept
Provide a list of data collection ideas: Provide a list of data collection ideas to help struggling learners get started. This can include prompts such as "What are your favorite foods?" or "How many siblings do you have?" to help them think of ideas. Use simpler language: Simplify the language used in the Excel sheet to make it more comprehensible for struggling learners. Use short sentences, bullet points, and visual aids to help them understand the task. Allow for group work: Allow struggling learners to work in pairs or small groups, so they can support and learn from each other as they complete the activity.
Icon
For advanced learners:
Encourage creative data collection methods: Encourage learners to think creatively about how they can collect data, such as through surveys, interviews, or observation. Challenge them to think outside the box and come up with innovative ideas. You may ask: What are some ways to collect data you haven't seen or tried before? Provide more complex prompts: Provide more complex prompts or open-ended questions for advanced learners to respond to in the Excel sheet. This can help them think more deeply about their data collection process and encourage higher-order thinking skills. You may ask: How might the data you collect be biased, and what can you do to mitigate these biases? Explain to them about outliers. What are some limitations of the data you are collecting, and how can you address these limitations to ensure your data is accurate and reliable? Encourage critical reflection: Encourage learners to reflect critically on their data collection process and consider their data’s potential biases or limitations. Ask them to consider how to mitigate these issues to ensure their data is accurate and reliable. You may ask: How can you use the data you collect to create a more detailed and insightful visualization? What are some unexpected insights that your data might reveal? Provide leadership opportunities: Provide learners with opportunities to take on leadership roles, such as mentoring struggling learners or presenting their data collection ideas to the class. This can help them develop leadership skills and demonstrate their expertise to their peers. You may ask: How can you use your expertise to support and mentor fellow learners in the class? How can you showcase your data collection and visualization skills by presenting your app to the class or school community?
 
Slide ImageSlide Image

Slide 51, 52

Groups will now present their app to their peers individually. The time limit for each group is 7 minutes. During this presentation, they will: 

  • Begin with an introduction: Start by introducing your app and its purpose. Be clear and concise about what your app does and who it's for.
  • Show the bar graph: Display the bar graph of the data collected in the classroom and explain what it represents. Share any insights or trends that you observed in the data.
  • Showcase the wireframe or mockup: Display the wireframe or mockup of your app design and explain how it works. Highlight any unique or innovative features that you included.
  • Talk about the technology: Explain the technology you used to create your app, including the programming languages, software, and tools. If you encountered any challenges during the development process, share how you overcame them.
  • Demonstrate the app: Show a live demo of your app, highlighting its key features and functionality. Walk the audience through the app's user interface and explain how to use it.
  • Discuss future plans: Share any plans you have for improving or expanding your app in the future. Invite feedback from the audience and encourage them to try out your app.

 

 

Walk learners through the following rules for a respectful and productive presentation experience:

For Viewers:

  1. Actively listen and engage: Viewers should pay attention to the presenter, actively listen, and engage in the presentation by asking relevant questions and participating in discussions.
  2. Provide constructive feedback: Viewers should offer feedback that is specific, respectful, and focused on improving the app's data visualization, user experience, or overall effectiveness.
  3. Be supportive and encouraging: Viewers should acknowledge the presenter's efforts and provide positive reinforcement for aspects of the app that are well-executed or innovative.
  4. Foster a collaborative atmosphere: Viewers should aim to create a collaborative learning environment by sharing their insights, suggestions, and ideas to enhance the overall understanding and effectiveness of data visualization.

 

Icon
For beginners or learners who may struggle with the concept
Provide a checklist or rubric: Give struggling learners a checklist or rubric to help them organize their presentation and ensure they cover all the key points. This can help them stay focused and ensure they don't forget anything important. Provide sentence starters: Provide sentence starters or templates for each section of the presentation, to help struggling learners structure their ideas and build their confidence in presenting. Pair with a buddy: Pair struggling learners with a more confident peer or mentor to help them practice and prepare their presentation. This can provide additional support and help struggling learners feel more comfortable presenting. Allow for more rehearsal time: Allow struggling learners to practice their presentation in a low-stakes environment. This can help them build confidence and improve their speaking skills.
Icon
For advanced learners
Encourage creativity: Encourage excellent learners to think outside the box and develop unique or innovative ways to present their app. They could use multimedia elements, such as video or animation, or create a prototype of their app to showcase during their presentation. Provide challenging prompts: Challenge excellent learners to think critically about their app and its potential impact. Ask them to consider how their app could be used to solve real-world problems or address social issues. Encourage peer feedback: Encourage excellent learners to seek feedback from their peers during their presentations and use it to improve their app design and functionality. Provide leadership opportunities: Provide excellent learners with opportunities to take on leadership roles, such as helping to organize the presentation activity or mentoring struggling learners. This can help them develop valuable leadership skills and demonstrate their expertise to their peers.
 

Data collection and analysis

Expand
 

Emerging

Learner collects data using limited digital tools and methods and analyzes data to demonstrate limited understanding of the key concepts.
 

Developing

Learner collects data using digital tools and methods and analyzes data to demonstrate some understanding of the key concepts.
 

Proficient

Learner collects data using various digital tools and methods and analyzes data meaningfully and thoughtfully.
 

Bar Graph

Expand
 

Emerging

Learner creates a partially clear and accurate bar graph representing some of the data collected but not drawing meaningful conclusions.

 

Developing

Learner creates a clear and accurate bar graph representing the data collected and draws conclusions.

 

Proficient

Learner creates a clear and accurate bar graph that effectively represents the data collected and draws meaningful conclusions.

 

App Design

Expand
 

Emerging

Learner designs and develops an app that partially showcases the data collected but lacks creativity or computational thinking skills.

 

Developing

Learner designs and develops an app that showcases the data collected most effectively, using some computational thinking skills to solve problems and make decisions.

 

Proficient

Learner designs and develops an app that effectively showcases the data collected uniquely and creatively, using computational thinking skills to solve problems and make decisions.

 

Comments (0)

×
hide-arrow
Subject
Math
Grade
5th Grade
6th Grade
Tech Domain
Programming & Coding
Common Core (Math)
2.MD.D.10
Draw a picture graph and a bar graph (with single-unit scale) to represent a data set with up to four categories. Solve simple put-together, take-apart, and compare problems using information presented in a bar graph.
ISTE
Computational Thinker
Learners develop and employ strategies for understanding and solving problems in ways that leverage the power of technological methods.
Creative Communicator
Learners use digital tools to express themselves and communicate effectively with others.
Empowered Learner 1.1.a
Students articulate and set personal learning goals, develop strategies leveraging technology to achieve them and reflect on the learning process itself to improve learning outcomes.
Innovative Designer: 1.4.a
Students know and use a deliberate design process for generating ideas, testing theories, creating innovative artifacts or solving authentic problems.
Topic
Data Visualisation
Share your thoughts on our Facebook group
Eddy Teacher Community
hide-arrow