Title: Too Late to Hide

Grade Level: 7,8

Subjects:   Mathematics, Social Studies, Language Arts, and Computer/Technology

Lesson Goal:   The students will be able to display data graphically using technology software and utilize the display of data to explain the effects that World War II had on the countries and the Jewish population in Europe.

Learner Outcomes:  The students will:
  1.  be able to display data graphically using Microsoft Excel.
  2.  be able to extrapolate information from the data displayed in their graphs.
  3.  be able to determine measures of central tendencies (mean, median, and mode) which relate to the data being displayed graphically.
  4.  be able to identify the effects that World War II had on the countries involved as related to battle causalities, expenditures of the war, and the Jewish population by visually representing the data in graphs.
  5.  be able to develop a written explanation of the data display in their graphs.

Duration of Lesson: Two 45 minute class periods

Materials:  3.5 diskettes for each student or one for the entire class
              Data Sheet 1 with Axis Casualties and Expenditures
              Data Sheet 2 with Allied Casualties and Expenditures
              Data Sheet 3 with Jewish Populations/Casualties in the Axis Powers
                   Spreadsheet directions printed for each student  "Directions for Creating a Graph"

Technology Tools/Courseware:  Multimedia Computer with Internet access
                                                      Word Processing program
                                                      Spreadsheet program

Teacher Notes:
The students will need the following prerequisite skills:

• using a word processing program (Microsoft Word) .
• entering data into a spreadsheet (Microsoft Excel).
• saving a file to a disk.
• extrapolating data from graphs.

• enter your Chart title.
• enter your label for the X axis.
• enter your label for the Y axis.

Activity 2:  Interpret information from the graphs created in Activity 1
    The students will discuss and be able to identify the effects that World War II had on the countries involved as related to battle causalities, expenditures of the war, and the Jewish population by visually interpreting  the data represented in the graph and data sheets.

Activity 3:  The students will develop a written explanation of the data displayed in their graphs.

Modifications:  Students with special needs may work with partners to complete the assignment.
                          Teacher will provide modified data sheets with fewer data items to be entered into the spreadsheet.
                          Students will be assisted by teacher or a high achieving student.
                          Student will be read the directions on how to graphically display the data.

Enrichment Activities:  The students will:
    1.  Design their own data collection project that reflects the activities and lessons on prejudice and the Jewish persecution.
    2.  Collect the data for your survey and display the results using Microsoft Excel.
    3.  Review their project with other classmates.
    4.  If necessary, make changes to improve their project based on the review from other classmates.
    5.  Present their data collection project to the their classmates.
    Suggestion:  The student may decide to collect real data about their classmates'  feelings on prejudice and persecution or choose to do additional research on number facts from the World War II time period.

Evaluation/Assessment:

• Activity 1:  Total Points Possible 100 points
• Observation of the students following the steps of creating a graph using the spreadsheet. (40 points)
• Written evaluation of the hard copy of the graph based on the following criteria: (60 points)
• Appropriate graph was selected for the data.
• Title of graph is visible and appropriate.
• Horizontal and vertical axes are labeled.
• Intervals on the scale are appropriate.
• Key or legend if needed is included.
• Spelling and neatness of the graph.

• Activity 2:  Observation by teacher of students' interpretations of the data displayed.
• Activity 3:  Total Points Possible 30 points
• Each student is required to:
• use a Word Processing program to create a document with the explanation of the data.
• give a general statement about the data as it is displayed on their graph.
• provide a minimum of 4 interpretation statements about the data displayed
• use appropriate math terminology which relates to statistical data.

National Standards for Education:
Mathematics Standards
        6. Understands and applies basic and advanced concepts of statistics and data analysis.
Geography Standards
The World in Spatial Terms
        1. Understands the characteristics and uses of maps, globes, and other geographic tools and technologies.
History Standards
        4.  Understands the consequences and global consequences of World War II.
Technology Standards
        2. Know the characteristics and uses of computer software programs.
Behavioral Studies Standards
        2.  Understands various meanings of social group, general implications of group membership, and  different ways that groups function.

Job and Career Clusters: Fine Arts/Humanities

References:

• Lesson Plans Mathematics  Grades 6-8
• Resource for searching for Microsoft Excel Help
• Ask Eric: Math Lesson Plans
• Microsoft Excel program - Help from menu
• Workbook - Microsoft Productivity in the Classroom, Math/Science Edition 2
• A curriculum based workbook to integrate computer applications into the math and science classrooms.