Adult Ed
EXCEL-lence: Strategies for using Microsoft EXCEL

OverviewActivities

Overview:

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

Learning objectives:

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

Materials:

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.


close WNET EDUCATION