EN ES

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

Log In Sign Up
  1. Planes de lección
  2. Graphify: Create a Data-Driven Bar Graph App (es)
Details

Graphify: Create a Data-Driven Bar Graph App (es)

sofware
Software: Google Sheets , Thunkable
| print Print as PDF |
Como (0)
|
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!

 

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.

 

Resources: 

 

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.

 

 

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 wifi connection.
    • Access to https://thunkable.com/ on each device.
    • Access to Google Sheets on each device.
    • Projector

Slide

Activity

2

Introduce learners to the lesson objectives.

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.

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!”

5

Introduce learners to what is meant by a Bar Graph. 

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.

7

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

8

Walk learners through the elements of a Bar Graph.

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.

11 & 12

Introduce learners to the Game and share that for this game, we will be documenting the scores using bar graphs. 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 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 total number of jellybeans and a different number of each color of jellybean, always between 25 and 50 in total. 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 change the view so that the bar graph can be a pie chart. Finally, the user must answer five questions involving the “jellybean tree.” (Source: https://mrnussbaum.com/the-jellybean-tree-online-game)

Slide

Activity

13

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 displaying data as a bar graph. 

14

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

  • What are some of your favorite mobile apps? 
  • Have you created mobile apps before? If yes, list the apps you have created.

15

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 to share brief background information about them.
Encourage learners to think critically about the apps: "What makes these apps so popular? What features do you like or dislike about them?"
Relate the apps to your lesson topic: "We will create 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 app: "Who knows? Maybe one day, your app will be on a list of popular apps like these."

16

Ask learners what they think are the steps involved in creating an app. Encourage them to think beyond the surface level and consider the complexities of creating and promoting an app. Using the following probing questions and prompts, you can help learners better understand 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 is the most crucial step in creating an app?
  • How do you think people decide what app to create?
    •  What factors do you think influence their decision?
    • How do they determine the purpose and target audience of the app?
  • What are the most important technical skills needed to create an app?
    • Do you think coding is the most critical skill? Why or why not?
    • What other technical skills do you think are essential?

17

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 usability and user experience feedback, and developers make necessary changes.
  • Improve: This step involves continuous app improvement based on user feedback, data analysis, and performance metrics. Developers add new features, fix bugs, and optimize the app for better performance and engagement.

18

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

19 & 20

Ask learners if they know what a wireframe is. 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 designing a website or app figure out how it should look and work before they make it.

21, 22 & 23

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.

Apprise learners of the tasks at hand:

  • Filling Ideation sheet. 
  • Collecting peer data and storing it in an Excel sheet.
  • Creating a wireframe of the app.
  • Play the timer on the screen.

24 - 32

Walk learners through the steps to sign in and set the User Interface of the app’s Start page. These slides are a mix of guided and independent practice

33

Ask learners if the app will work now. 

Expect mixed responses. 

Clarify that the user interface has been created but is not responsive, as we have not programmed it yet. 

34 - 50

These slides are a mix of guided and independent practice. You can walk learners through these slides and help them complete their projects. 

51

Now that the app's basic structure is ready, learners can customize the app based on their users. 
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

Activity

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 data visualization’s overall understanding and effectiveness.
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.
Criteria 4 - Exceeds Expectations 3 - Meets Expectations 2 - Approaching Expectations 1 - Below Expectations
Data Collection and Analysis Learner collects data using various digital tools and methods and analyzes data meaningfully and thoughtfully.

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



 		 Learner collects data using limited digital tools and methods and analyzes data to demonstrate limited understanding of the key concepts. Learner does not effectively collect or analyze data.
Bar Graph Learner creates a clear and accurate bar graph that effectively represents the data collected and draws meaningful conclusions. Learner creates a clear and accurate bar graph representing the data collected and draws conclusions. Learner creates a partially clear and accurate bar graph representing some of the data collected but not drawing meaningful conclusions. Learner does not create a straightforward or accurate bar graph.
App Design 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. Learner designs and develops an app that showcases the data collected most effectively, using some computational thinking skills to solve problems and make decisions. Learner designs and develops an app that partially showcases the data collected but lacks creativity or computational thinking skills. Learner does not effectively design or develop an app.
Communication Learner effectively communicates their findings and app design to their peers using various digital communication tools and methods, demonstrating strong interpersonal and presentation skills. Learner communicates their findings and app design to their peers using some digital communication tools and methods, demonstrating some interpersonal and presentation skills. Learner communicates their findings and app design to their peers using limited digital communication tools and methods, demonstrating limited interpersonal and presentation skills. Learner does not effectively communicate their findings or app design.
Collaboration Learner works collaboratively in a team to achieve a shared goal, demonstrating effective teamwork, problem-solving, and contribution to a team effort. Learner works collaboratively to achieve a shared goal, demonstrating teamwork, problem-solving, and contribution to a team effort. Learner works collaboratively but demonstrates limited teamwork, problem-solving, or contribution to a team effort. Learner does not effectively work collaboratively in a team.

 

Comments (0)

×
hide-arrow
Subject
Math
Grade
5th Grade
6th Grade
Tech Domain
Programming & Coding
Share your thoughts on our Facebook group
Eddy Teacher Community
hide-arrow