Microsoft Office XP
Concepts and Techniques

Excel 2002Project OneCreating a Worksheet and Embedded Chartobjectives
Students will have mastered the material in this project when they can:


l Start Excel


l Describe the Excel worksheet


l Describe the speech recognition capabilities of Excel


l Select a cell or range of cells


l Enter text and numbers


l Use the AutoSum button to sum a range of cells


l Copy a cell to a range of cells using the fill handle


l Bold font, change font size, and change font color


l Center cell contents across a series of columns


l Apply the AutoFormat command to format a range


l Use the Name box to select a cell


l Create a Column chart using the Chart Wizard


l Save a worksheet


l Print a worksheet


l Quit Excel


l Open a workbook


l Use the AutoCalculate area to determine totals


l Correct errors on a worksheet


l Use the Excel Help system to answer their questions


project overview
In creating the worksheet and chart in this project, students gain a broad knowledge of Excel. First, they are introduced to starting Excel and learn about the Excel window. They find out how to enter text and numbers to create a worksheet. Students discover how to select a range and use the AutoSum button to sum the numbers in a row or column. Using the fill handle, students copy a cell to adjacent cells. Once the worksheet is built, they change the font size of the title, bold the title, and center the title across a range using buttons on the Formatting toolbar. Steps and techniques are presented to format the body of the worksheet using the AutoFormat command. Students use the Chart Wizard to add a 3-D Column chart. After completing the worksheet, they save the workbook on disk, print the worksheet and chart, and quit Excel. Students then start Excel by opening an Excel document, use the AutoCalculate area, and edit data in cells. Finally, students discover how to use the Excel Help system to answer their questions.

lesson plan
Project Outline


Page


Teacher Notes and Activities


« Smaller is Smarter:
Smart Card Technology in Your Wallet


E 1.04


Smart cards can hold the equivalent of 30 typewritten pages of data. Students may be most familiar with smart cards used as keys for hotel rooms. Often, these cards also provide access to hotel services such as cafeterias, swimming pools, lockers, and parking lots. Smart cards also are used as prepaid telephone cards, to track customer information or employee attendance, and to store patient records. As a storage medium for an individual’s medical history, smart cards offer obvious benefits. The cards can be carried in a wallet with, or in lieu of, an insurance card, providing both insurance records and an immediate, up-to-date medical history. A form of smart cards, called Personal Information Carriers (PICs), is being adopted by the army to replace dog tags. Ask students to suggest other ways smart cards could be used. Explain how an intelligent smart card is different from a memory card. Smart cards also can store electronic money (e-money or digital cash) and be used as a means of paying for goods and services over the Internet. Review the history of smart cards. Ask students if smart cards someday will replace conventional currency. Why or why not?


I. What is Microsoft Excel?


E 1.06


Define Microsoft Excel. Describe the four major parts of Excel: worksheets (spreadsheets), charts, databases, and Web support. Examine the Case Perspective.
VisiCalc introduced electronic spreadsheets to the workplace, but it was an innovative program developed by Mitch Kapor in 1983 that revealed the far-reaching capabilities of spreadsheet software. Lotus 1-2-3 (so named because Kapor, a teacher of transcendental meditation, combined three elements in a spreadsheet program that was “as easy as one, two, three” to use) performed more complex operations and linked spreadsheets, graphics, and databases. Within seven years, Kapor’s original eight-person company had almost 3,000 employees and revenues of over half a billion dollars a year. In 1991, Microsoft released a new version of their spreadsheet program, Excel 2, designed to take advantage of the Windows 3.0 environment. Excel surged to the front of the market, adding features such as three-dimensional graphics, auxiliary functions, wizards to guide users through complex tasks, powerful what-if tools, and easy-to-use database capabilities. Today, under Windows, Excel is the leader in the business world. Spreadsheets, however, are not limited