Adult Ed - Lesson Plans

EXCEL-lence: Strategies for using Microsoft EXCEL

In today's information age consumers manage data in ways that were once reserved for degreed professionals. The Microsoft Office Suite has become the global industry standard for word processing software and each version is more useful and user friendly. This lesson will provide users with strategies for using Microsoft EXCEL to process information for presentations. Techniques for calculating averages, counting values and presenting data will be described along with a few tips for working with Microsoft Word and Powerpoint.

Subject Matter

Technology, Math, Career Workplace Readiness

Students will be able to:

Construct pivot tables
Develop formulas that will count, calculate averages and sum data
Identify information processing "shortcuts" by using software functions and program wizards

Standards

Math, Science, Technology Education
Standard 5 - Technology
Students will apply technological knowledge and skills to design, construct, use, and evaluate products and systems to satisfy human and environmental needs.
http://www.nysatl.nysed.gov/mathstand.html

Career Development and Occupational Studies
Standard 2 - Integrated Learning
Students will demonstrate how academic knowledge and skills are applied in the workplace and other settings.
http://vls.nysed.gov/vls/menu.do?lmid=128

Media components
Sample data from Novell, Inc.
Examples of uses for Pivot tables

2000 Census Data NY City by age and gender
1997 Census Data Women & Minority-owned businesses

(Per class)
Microsoft Office-Excel
Large instructional writing space or projection space and graph paper
Sample data files (Census data, Novell data or SAT Data-Available online)
Crib Sheet transparency (List of Word and EXCEL shortcuts using Control and Alt keys)

Prep for teachers Create transparencies from one of the source files or provide students with copies of data files.

Overview | Activities
Lesson Plans
Adult Ed Online
Thirteen Ed Online
Thirteen