Favorite Sports - Excel Lesson Plan

Author: Christopher Kato  03/10/2008 07:08:00 PM EST		 TaskStream - Advancing Educational Excellence

VITAL INFORMATION
Subject(s):
Elementary, Physical Education, Computers
 
Topic or Unit of Study:

Computer Literacy
 
Grade/Level:
4
 
Objective:

This activity will demonstrate the basic capabilites of Microsoft Excel.

 
Summary:

By compiling data in a spreadsheet (prepared by the instructor) and plugging that data into Microsoft Excel, students will gain an understanding of how to create and maintain spreadsheets on the computer.
 
IMPLEMENTATION
Learning Context:

This activity fits into the general context of computer literacy and learning.

 
Procedure:

1. Instructor hands out blank 'Favorite Sports' spreadsheet. The table is separated by Boys and Girls in rows and favorite sports in the columns.

2. The data is compiled by a show of hands after the teacher says the sport. For example, he/she will ask which boys chose football as their favorite sport, then repeat the question for the girls. The students will compile this data in their spreadsheets.

3. Students will log onto their computers and open Microsoft Excel.

4. The instructor will show the students how to recreate their spreadsheets in Microsoft Excel and how to find the sum of the data.

5. The instructor will show the students how to create a graph that corresponds to their data.
 
Differentiated Instruction:

This lesson can be modified for students with special needs in a variety of ways. Special computer software, such as magnified screens, headphones, and Microsoft Excel tutorials, can be used if students need help understanding the computer material. Advanced learners can take advantage of Excel's other features, including colored graphs.
 
Sample Student Products:
Attachments
  1. Student Sample and Graph
 
Collaboration:
Students will work individually.
 
Time Allotment:
2 class periods. 35 Min. per class.
 
Author's Comments & Reflections:  
 
MATERIALS AND RESOURCES
Instructional Materials:
Attachments
  1. Blank Data Collection Sheet
 
Resources:  
 
STANDARDS & ASSESSMENT
Standards:
USA- ISTE: Profiles for Technology Literate Students (includes NETS for Students)
• Grade : Grades 3-5

Numbers in parentheses following each performance indicator refer to the standards category to which the performance is linked. The categories are:
1. Basic operations and concepts
2. Social, ethical, and human issues
3. Technology productivity tools
4. Technology communications tools
5. Technology research tools
6. Technology problem-solving and decision-making tools

Reprinted from National Educational Technology Standards for Students - Connecting Curriculum and Technology, copyright © 2000, ISTE (International Society for Technology in Education), 800.336.5191 (U.S. & Canada) or 541.302.3777 (Int’l), iste@iste.org, www.iste.org. All rights reserved. For more information about the NETS Project, contact Lajeane Thomas, Director, NETS Project, 318.257.3923, lthomas@latech.edu. Reprint permission does not constitute an endorsement by ISTE or the NETS Project.

 Performance Objective 1: Use keyboards and other common input and output devices (including adaptive devices when necessary) efficiently and effectively. (1)
 Performance Objective 2: Discuss common uses of technology in daily life and the advantages and disadvantages those uses provide. (1, 2)
 Performance Objective 3: Discuss basic issues related to responsible use of technology and information and describe personal consequences of inappropriate use. (2)
 Performance Objective 4: Use general purpose productivity tools and peripherals to support personal productivity, remediate skill deficits, and facilitate learning throughout the curriculum. (3)
 Performance Objective 5: Use technology tools (e.g., multimedia authoring, presentation, Web tools, digital cameras, scanners) for individual and collaborative writing, communication, and publishing activities to create knowledge products for audiences inside and outside the classroom. (3, 4)
 Performance Objective 8: Use technology resources (e.g., calculators, data collection probes, videos, educational software) for problem solving, self-directed learning, and extended learning activities. (5, 6)

MI- Michigan Grade Level Content Expectations
• Subject : MATHEMATICS
• Grade : FOURTH GRADE
• Strand : DATA AND PROBABILITY
• Topic : Represent and solve problems for given data
 Expectation : D.RE.04.01 Construct tables and bar graphs from given data.
 Expectation : D.RE.04.03 Solve problems using data presented in tables and bar graphs, e.g., compare data represented in two bar graphs and read bar graphs showing two data sets.
 
Assessment/Rubrics:
Rubrics
  1. Favorite Sports - Excel Rubric