McLeod - EdTech 541
  • Home
  • Course Projects
    • "I Am" Poem
    • Vision and Mission Statement >
      • Visual Story of Vision Statement
    • Relative Advantage Chart
    • Instructional Software Lesson Plan
    • Software Support Tools
    • Interactive Presentation
    • Spreadsheet Lesson Framework
    • Shared Docs Lesson Framework
    • Video Integration >
      • Video Enhanced Lesson Plan
    • Internet Enriched Lesson >
      • Learning the Language of Parabolas
      • Parabola Exploration
      • Application Activities
    • Social Networking Learning Activities >
      • Data Compilation Through Social Media
      • Graph Building Using Google Sheets
      • Reflection and Discussion Through Social Media
    • Game-Based Learning >
      • Game 1
      • Game 2
      • Game 3
      • Game 4
    • Content Area Learning Activities: Math/Science >
      • Math and Science Resources
      • Resource Symbaloo
    • Content Area Learning Activities: Art, Music and PE
    • Content Area Learning Activities: Language Arts
    • Adaptive/Assistive Technology >
      • Cognitive Difficulties
      • Physical Difficulties
      • Sensory Difficulties
      • At-Risk Students
      • Gifted and Talented Students
  • Resources
  • AECT Standards
    • Mission Statement and Conceptual Framework
  • Learning Log
    • "I Am" Poem
    • Mission and Vision Statement
    • Relative Advantage Chart
    • Relative Advantage of Instructional Software
    • Relative Advantages of the Basic Software Suite
    • Advantages of Using Multimedia in the Classroom
    • Acceptable Use Policies
    • Walled Gardens and Social Media
    • Relative Advantages of Game-Based Learning in a Special Education Algebra Classroom
    • Relative Advantage of Using Technology to Enhance Learning in a Special Education Algebra Classroom
    • Obstacles and Solutions for Integrating Technology into a High School Algebra Classroom
    • Accessibility Features on a MacBook Pro
    • Final Reflection
  • About

Spreadsheet Lesson Framework

This lesson is an exploration of scatterplots and lines of best fit. In this activity, high school algebra students will enter given data of average points per basketball game vs. player height into a table. Using the chart feature of Google Sheets, students will create a scatterplot of the data with the line of best fit superimposed on the graph. They will use the formulas to calculate slope and y-intercept from their table. They will use the forecast formula to predict both height and points scored for people of their choice. Discussion will take place regarding the validity of the predicted data and outliers will be introduced.

Goals

After this lesson, students will be able to
  • enter data into a Google Sheet in table form, adding borders to increase readability.
  • choose an appropriate chart to showcase data, add labels, and insert it into a spreadsheet
  • add a line of best fit to the scatterplot
  • use the =Slope formula to calculate the rate of change for a table of data
  • use the =Intercept formula to calculate the y-intercept for a table of data
  • use the =Forecast formula to predict data for either the x- or the y-axis
  • explain the definition of an outlier and give one example​

Complex Concepts

  • Why precision when entering data is important
  • Why sample size is important
  • The relationship between tables and graphs
  • What outliers are and the effect they have on data
  • What the line of best fit is, its importance and application
  • What correlation is and how it applies to data

The Table

The data used in the table will be given to students by the teacher and is a random sampling of basketball player's heights vs. average points scored per game. The column heading for the x-axis will be player's heights in centimeters. The column heading for the y-axis will be the average points scored per basketball game. Students will use the internet to find six more data points: three player heights and three game points averages. Students will then use the =Forecast formula in Google Sheets to predict the missing information.

Course Projects
Powered by Create your own unique website with customizable templates.