Favorite Holidays

NTeQ Spreadsheet Lesson Plan
Lesson Title: Favorite Holidays
Subject Area(s): Mathematics
Grade Level: Second grade
Time required: One hour
Lesson Summary: The students will discuss their favorite holidays. Then they will take a class survey to determine which holiday; Halloween, Thanksgiving, Christmas, or Easter, the class liked best. The students will create a column graph on paper. Then the students will enter this data into a spreadsheet and create a column graph to display this data. Using the column graph, the students will analyze the data and answer Think Sheet questions.
Learning Objective(s):

By the end of this lesson, the students will: Tennessee Curriculum Standard
Be able to read and interpret data in a column graph Content Standard 5.0 The student will understand and apply basic statistical and probability concepts in order to organize and analyze data and to make predictions and conjectures.
Learning Expectation 5.1 Develop, select, and use appropriate methods to collect, organize, display, and analyze data.

MATERIALS

 Microsoft Excel
 Data Collection/Think Sheet handout
 Favorite holiday spreadsheet template

COMPUTER FUNCTIONS AND DATA MANIPULATION
Computer Function Computer Application Data Manipulation
 Graph  Microsoft Excel  The students will enter the holiday survey data into a spreadsheet and create a column graph that displays this data.


SPECIFY PROBLEM
What is your favorite holiday? What do you think our class’s favorite holiday is? Today, we are going to discuss our favorite holidays. We are going to take a class survey to find out which holiday, Halloween, Thanksgiving, Christmas, or Easter is liked the best by our class. Then we are going to take the results and enter the numbers into a spreadsheet and create a column graph on the computer that will display the results of our favorite holiday survey.

RESULTS PRESENTATION
The students will create a column graph that displays the results of the class’s favorite holiday survey. They will read and analyze the data in the column graph and answer Think Sheet questions about the data.

TEACHER ACTIVITIES BEFORE LESSON
The teacher will have:
1. Chosen four holidays
2. Created an example of a column graph
3. Opened the spreadsheet template on the computer

STUDENT COMPUTER ACTIVITIES
Activity 1
Activities to be completed:
-Prior to going to the computer, the students will participate in the class favorite holidays survey. Using the results of this survey, the students will create a paper column graph to display the data.
- At the computer, the students will enter the favorite holidays data into a spreadsheet template and then create a column graph.
- After going to computer,
The students will take a copy of the column graph to their desks and read and analyze the data to answer Think Sheet questions.

SUPPORTING ACTIVITIES

Activity 1
Activities to be completed:

Students will work on a graphing activity from their math textbook.

ASSESSMENT

Objective or Performance Beginning
Developing
Accomplished

The students will enter
data into a
spreadsheet and
create a column graph
Did not enter data correctly
Missing more than one label: title, X axis, or Y axis
Many words in the labels are misspelled
Has entered data correctly
Missing one label: title, X axis, or Y axis
A few words in the labels are misspelled
All data is entered correctly
All items are labeled correctly
No spelling errors.

The students will read
And analyzed the data
In the column graph
And answered Think
Sheet questions More than four incorrect answers to Think Sheet questions. Less than two incorrect answers to Think Sheet questions All Think Sheet questions answered correctly.

CREDITS

1. Math Curriculum Standards - National Council of Teachers of Mathematics - http://standards.nctm.org/document/chapter7/geom.htm
2. Clip Art – Microsoft Office Clip Art and Media – http://dgl.microsoft.com


What is Your Favorite Holiday?

HOLIDAY # of Classmates
EASTER
HALLOWEEN
THANKSGIVING
CHRISTMAS


1. Color the number of bars for each holiday that represent the number of classmates that liked that holiday best.
 Use a PINK color for EASTER.
 Use an ORANGE color for HALLOWEEN.
 Use a BROWN color for THANKSGIVING.
 Use a RED color For CHRISTMAS.
2. Count the bars for each holiday and write the number.







<br>




EASTER HALLOWEEN THANKSGIVING CHRISTMAS


Name: __________________________ Date: _________________



1. List the four different holidays.
&#61607; __________________________
&#61607; __________________________
&#61607; __________________________
&#61607; __________________________

2. Whatis the class’s favorite holiday? _____________________

3. What is the class’s least favorite holiday? ________________

4. How many more classmates liked Christmas more than Thanksgiving? _________

5. How many more classmates liked Halloween more than Easter? __________

6. How many more classmates liked Thanksgiving more than Easter? ____________

7. How many more classmates like Christmas more than Easter?
___________

8. How many classmates liked Christmas and Thanksgiving? _______

9. How many classmates like Halloween and Easter? ________

10. What was your favorite holiday? _____________________
Why is this your favorite holiday? __________________________________________________________________________________________________________