Learning to Give, Curriculum Division of The LEAGUE

The LEAGUE

Valuable Data?
Lesson 3:
printEmail this Lesson
Lesson
Handouts
Academic Standards
Philanthropy Framework

Purpose:

This lesson will introduce learners to the procedures used in the compilation and organization of data provided for the Lesson Two: Developing a Sense of Self surveys concerning values. It will expose learners to the use of Microsoft Excel ® (or other appropriate software), spreadsheets and the creation of graphs. The lesson will conclude with learners interpreting the data representations and making summary statements regarding the relationship(s) between their personal values and those of the larger communities.

Duration:

Two Forty-Five to Fifty Minute Class Periods

Objectives:

    The learner will:
  • organize the data by compiling the responses to the Lesson Two: Developing a Sense of Self Peer Survey and Community Priorities Survey.
  • express the raw data graphically through Microsoft Excel ® Graphic Wizard or other appropriate software.
  • make generalizations and draw conclusions about trends and interrelationships revealed by the data.
  • participate in substantive conversation.

Materials:

  • Three Surveys (Self, Peer and Community Priorities) from Lesson Two: Developing a Sense of Self

  • Spreadsheet application (such as Microsoft Excel ®)

Instructional Procedure(s):

Anticipatory Set:

Instructor will begin lesson by introducing learners to a variety of charting options (e.g., line, bar, pictograph, pie,) and lead a discussion concerning what types of data are best suited to the various charting options. The set will end with the instructor explaining that charts, tables and graphs are all visual representations of concepts or ideas, and that the students' pending analysis will give the data meaning. Students will collectively determine which charting option most clearly conveys the survey data they have collected.

Instructor's Note: For those of you who are unfamiliar with this technique, it is thoroughly explained at the Web Address: www.jigsaw.org

To very briefly summarize, the technique uses five to six-member cooperative groups. Each member has a small segment of responsibility and then the group cooperatively brings all the pieces together. A goal of this technique is to effectively utilize group bonding of diverse learners. The home page gives a ten-step process for effective implementation of jigsaw cooperative learning groups.

  • Learners working in cooperative Jigsaw groups will compile the data obtained from the Lesson Two: Developing a Sense of Self (Peer and Community Priorities) surveys.

  • Compiled/organized data will then be entered into spreadsheets.

  • Groups will create charts and graphs using the Chart Wizard tool.

  • Learners' groups will then choose the best format to present the data.

  • Each group will analyze their data representations and make generalizations and identify trends as reported in a written document.

  • Each group will report their findings to the whole class.

  • Class will challenge the validity of findings and offer alternative conclusions.

  • Difference of interpretation will be resolved by a simple majority vote of the class.

  • Individually, students will compare and contrast their own self survey to the findings from the Peer Survey and Community Priorities Survey.

Assessment:

  • Accuracy in the compilation of survey data

  • Producing the data in an appropriate format, i.e. chart, graph

  • Written interpretation of the data in document form using technical report writing techniques

  • Reflective journal entry concerning role played in class substantive conversation

Bibliographical References:

Jigsaw Classroom. <www.jigsaw.org> (May 28,2002).

Lesson Developed and Piloted by:

John Slocum
North Muskegon Public Schools
North Muskegon High School
Muskegon, MI 49445

Bradley Bloomhuff
Southfield Public Schools
Arthur Ashe Academy
Southfield, MI 48034

Handouts:

Philanthropy Framework:

Submit a Comment

All rights reserved. Permission is granted to freely use this information for nonprofit (noncommercial), educational purposes only. Copyright must be acknowledged on all copies.

Copyright © LearningToGive.org