Download introduction to computers and inform ation technology

000200010270781411_BOOK.pdf 7/11/11 2:38 PM - 104 - ( )
Chapter 13
Spreadsheet Basics
Lesson Plan 13-1
Exploring Spreadsheets
Prepare and Engage
Objectives
1. Explain the purpose of spreadsheet software.
2. Identify and describe parts of a worksheet.
3. Summarize key features of spreadsheet software.
Prepare a worksheet using spreadsheet software.
Create a worksheet. In column A, list students’ names. In columns B, C, D, and E, add dates
and four sample test scores for each student. Sum up and average each student’s scores using a
formula in column F.
Review basic worksheet functions.
Open and project the worksheet file. Explain how spreadsheets can be used for a variety of
purposes, including making charts and calculating numbers. Point out the various parts such
as the entry line, the cell identifier, and the scroll bars.
Teach
• Have students read this lesson.
• For the As You Read activity, show students examples of concept webs, and make sure they
understand how to prepare one.
• Review the key terms.
Teaching Tips
• Explain that spreadsheets enable you to organize data in columns and rows, calculate numerical data, display data in various formats, and speed the process of changing and updating data.
• If possible, display the spreadsheet window on a SmartBoard or overhead, point out each
part of the window labeled in Figure 13.1.2, and briefly describe the use of the feature.
• Have students practice activating different cells and scrolling through the spreadsheet. Have
them use the Home, End, Page Up, Page Down keys, and the scroll bars to move around in
the spreadsheet.
• Review how to select cells and enter data, noting in particular that to enter a formula, you
must first enter an equal sign or plus sign.
96
•
Part 2