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.
- 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
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.
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.
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
Large instructional writing space or projection space and graph paper
Sample data files (Census data, Novell data or SAT Data-Available online)
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.