LEARN NC

K–12 teaching and learning · from the UNC School of Education

Learn more

Related pages

  • Women's ACC Basketball Tournament School Day Curriculum: Four collections of basketball-based units for grades K–8 teach all areas of the curriculum through the lens of the 2009 Women's ACC basketball tournament.
  • Blueberries for Sal - Counting and Correspondence: This lesson is designed to aid the teacher in teaching the math skills of one to one correspondence, number recognition, and matching numbers to sets. It is also a great lesson to intergrate into a unit on Bears or the color Blue.
  • Does your House Measure Up?: This lesson is intended to be used as a final assessment of a student's understanding of an inch, foot, and yard. It will also assess their ability to use a yardstick, follow written directions, and work with a partner to draw a house on the school blacktop as part of a class neighborhood.

Related topics

Help

Please read our disclaimer for lesson plans.

Legal

This page copyright ©2008. Terms of use

Learning outcomes

Students will:

  • create a computer-generated scatterplot from information gathered in class.
  • create a project from data collected with parents.

Teacher planning

Time required for lesson

4 days

Materials/resources

Worksheet - “Correlation - What Makes a Perfect Pair?” (see attachment: rubric.htm)

Rubric - “Parent Scatter Gram Project Rubric” (see attachment: corr.rtf)

Technology resources

Computer

Spreadsheet program with graphing capabilities

Pre-activities

Students will have worked in a lab setting inputing teacher-generated data in a spreadsheet and creating various graphs with the data.

Activities

  1. Students will be given the worksheet, “Correlation: What Makes a Perfect Pair?” (corr.rtf)
  2. They will rate 10 TV programs and then select a peer to rate the same 10 TV programs. They will enter this data in a spreadsheet and use the graphing options to create a scatterplot. Students will share their scatterplots with the class and identify the correlation as positive, negative, or none. From the scatterplots, the students will write statements that they can infer from the data. (e.g., My friend and I would always argue over what TV program to watch.) Students will share their inferences.
  3. Students will have two or three more lessons about scatterplots and correlation of data. Depending on the class, lessons could get as involved as figuring the correlation coefficient using the formula for rank correlation.Students will complete a final project given these directions: Most teenagers complain that the older generation does not understand them. Try and prove that opinion! Think of something to rate that you feel your parent(s) would rate completely differently from you. Create a computer-generated scatterplot to show if a negative correlation really does exist between your parent’s opinions and yours. Mount your ratings, your scatterplot and inferred conclusion statements with an appropriate title, border and illustrations. Complete a rank correlation chart to find the correlation coefficient for extra credit. Overall neatness, creativity, and effort will be graded also.

Assessment

Students’ inferences from their first correlation activity will help the teacher see if students understand the type of information they can infer from a scatterplot versus the literal information that it offers.

Student/Parent correlation projects will assess the overall unit using a rubric given to the students when the project is assigned.

Supplemental information

None

Related websites

Under Data Analysis & Probability (Grades 6 - 8):
Scatterplot ? Plot multiple data points in two dimensions and determine correlation.
http://matti.usu.edu/nlvm/nav/topic_t_5.html

Comments

Feel free to download the attachments and edit them for your personal use. Over time the TV programs on the worksheet would have to be changed to reflect current programming.

Although the rubric has the correlation coefficient as being mandatory, you could delete this part of the rubric to make finding the correlation coefficient extra credit as suggested in the lesson. You will need to weight the rubric as to which areas you think are the most important. I always divide the weight among the topics to be assessed so that a perfect score is 100.

North Carolina Curriculum Alignment

Information Skills (2000)

Grade 8

  • Goal 3: The learner will RELATE ideas and information to life experiences.

Computer Technology Skills (2005)

Grade 8

  • Goal 1: The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.
    • Objective 1.10: Use spreadsheet and graphing terms/concepts to present and explain content area assignments. Strand - Spreadsheet
  • Goal 3: Select and use a variety of technology tools to collect, analyze, and present information. Strand - Societal/Ethical Issues
    • Objective 3.04: Create/modify spreadsheets to analyze and interpret information, test simple "what if..." statements, solve problems, and make decisions in content areas. Strand - Spreadsheet

English Language Arts (2004)

Grade 8

  • Goal 3: The learner will continue to refine the understanding and use of argument.
    • Objective 3.02: Continue to explore and analyze the use of the problem-solution process by:
      • evaluating problems and solutions within various texts and situations.
      • utilizing the problem-solution process within various contexts/situations.
      • constructing essays/presentations that respond to a given problem by proposing a solution that includes relevant details.
      • recognizing and/or creating an organizing structure appropriate to purpose, audience, and context.

Mathematics (2004)

Grade 8

  • Goal 4: Data Analysis and Probability - The learner will understand and use graphs and data analysis.
    • Objective 4.01: Collect, organize, analyze, and display data (including scatterplots) to solve problems.
    • Objective 4.02: Approximate a line of best fit for a given scatterplot; explain the meaning of the line as it relates to the problem and make predictions.