A Guide to this Instructors Manual:

Page 1 of 18 Microsoft Excel 2013

Chapter One: Creating a Worksheet and a Chart

A Guide to this Instructor’s Manual:

We have designed this Instructor’s Manual to supplement and enhance your teaching experience through classroom activities and a cohesive chapter summary.This document is organized chronologically, using the same heading in red that you see in the textbook. Under each heading you will find (in order): Lecture Notes that summarize the section, Figures and Boxes found in the section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay special attention to teaching tips, and activities geared towards quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software.In addition to this Instructor’s Manual, our Instructor’s Resources also contain PowerPoint Presentations, Test Banks, and other supplements to aid in your teaching experience.

For your students:

Our latest online feature, CourseCasts, is a library of weekly podcasts designed to keep your students up to date with the latest in technology news. Direct your students to http://coursecasts.course.com, where they can download the most recent CourseCast onto their mp3 player. Ken Baldauf, host of CourseCasts, is a faculty member of the Florida State University Computer Science Department where he is responsible for teaching technology classes to thousands of FSU students each year. Ken is an expert in the latest technology and sorts through and aggregates the most pertinent news and information for CourseCasts so your students can spend their time enjoying technology, rather than trying to figure it out. Open or close your lecture with a discussion based on the latest CourseCast.

SAM:

This text is available with SAM 2013 Assessment, Training, and Projects that map directly to the learning objectives covered in each chapter. SAM's active, hands-on training and skill- based assessment help you master Microsoft Office skills. SAM Projects let you apply skills in real-world scenarios using the actual Microsoft Office applications.Immediate feedback and comprehensive study guides give you the practice and support you need to succeed.If you have a SAM account, login at www.cengage.com/sam2013. To obtain a SAM account, visit www.cengagebrain.com or contact your instructor or bookstore for additional information.Table of Contents Chapter Objectives

EX 2: Introduction

EX 2: Project — Worksheet and a Chart

EX 6: Selecting a Cell

EX 6: Entering Text

EX 12: Entering Numbers

EX 14: Calculating a Sum

EX 15: Using the Fill Handle to Copy a Cell to Adjacent Cells

Microsoft Exce l 2013 Complete 1e Steven Freund Mali Jones Joy Starks (Instru ctor Manual All Chapters, 100% Original Verified, A+ Grade) All Chapters Instructors Manual Supplement files download link at the end of this file. 1 / 4

Excel 2013 Instructor’s Manual Page 2 of 18

EX 22: Formatting the Worksheet

EX 37: Adding a Pie Chart to the Worksheet

EX 41: Changing the Sheet Tab Names

EX 45: Printing a Worksheet

EX 48: AutoCalculate

EX 49: Correcting Errors

EX 54: Chapter Summary

End of Chapter Material Glossary of Key Terms Chapter Objectives

Students will have mastered the material in Chapter One when they can:

Describe the Excel worksheet Enter text and numbers Use the Sum button to sum a range of cells Enter a simple function Copy the contents of a cell to a range of cells using the fill handle Apply cell styles Format cells in a worksheet Create a 3- D pie chart Change a worksheet name and worksheet tab color Change document properties Preview and print a worksheet Use the AutoCalculate area to display statistics Correct errors on a worksheet

EX 2: Introduction

LECTURE NOTES

•Describe how an Excel workbook is used to summarize and chart data •Discuss how a chart is a visual representation of data

TEACHER TIP

Many people use the terms spreadsheet and worksheet interchangeably; however, when working in Excel, the correct term is worksheet.

CLASSROOM ACTIVITIES

1.Group Activity: Divide the class into groups of three or four and have the students make lists of the activities in their lives for which creating a worksheet would be helpful. An example might be trackingall of the receipts for purchases made during the year. Have the groups share the information with th e class.

2.Critical Thinking: Ask students to share ways in which they have seen worksheets used. Then ask them to brainstorm as many uses for a worksheet as they can think of. Encourage students to beattentive as they go through the Excel projects to see if they can add to their list of uses for a worksheet.

3.Quick Quiz:

1) Often _____ is consolidated into a summary. (Answer: data)

2)An Excel _____ allows data easily to be summarized and charted. (Answer: worksheet)

EX 2: Project — Worksheet and a Chart

LECTURE NOTES 2 / 4

Excel 2013 Instructor’s Manual Page 3 of 18 • Use Figures 1-1a and 1-1b to review the worksheet and chart to be created in this project • Discuss the importance of understanding exactly what is required and use Figure 1-2 to explain what a requirements document is • Use the Roadmap to review the general activities that will be performed in this chapter

• Enter text in a blank worksheet
• Calculate sums and use formulas in the worksheet
• Save the workbook using the file name, Bob Gleamin Budget
• Format text in the worksheet
• Insert a pie chart into the worksheet
• Assign a name to the worksheet tab
• Preview and print the worksheet

• Briefly review the color-coded abbreviated version of the roadmap used throughout the chapter to indicate chapter progress • Use Figure 1-3 to discuss the utility of a sketch of the worksheet and emphasize the sketch’s importance in planning the worksheet • Review the steps to run Excel and create a blank workbook

FIGURES and TABLES: Figures — 1-1a, 1-1b, 1-2, 1-3

BOXES:

• CONSIDER THIS: Discuss the significance of careful planning for developing a worksheet that is

useful. When designing a worksheet solution for a problem, follow these steps: (1) define the problem; (2) design the worksheet; (3) enter the data and formulas; (4) test the worksheet.

• Yellow Box: For an introduction to Windows and instruction about how to perform basic Windows

tasks, refer students to the Office and Windows chapter at the beginning of this book, where they can learn how to resize windows, change screen resolution, create folders, move and rename files, use Windows Help, and much more.

• Yellow Box: One of the few differences between Windows 7 and Windows 8 occurs in the set of

steps required to run Excel. If you are using Windows 7, click the Start button, type Excel in the ‘Search programs and files’ text box, click Excel 2013, and then, if necessary, maximize the Excel window. For detailed steps to run Excel in Windows 7, refer to the Office and Windows chapter at the beginning of this book. For a summary of the steps, refer to the Quick Reference located at the back of this book.

4. BTW:

BTWs. Refer students to the Student Companion Site for a complete list of the BTWs from the text, and to the Student Download Web page for detailed instructions about accessing available resources.

• Yellow Box: If you are using your finger on a touch screen and are having difficulty completing the

steps in this chapter, consider using a stylus. Many people find it easier to be precise with a stylus than with a finger. In addition, with a stylus you see the pointer. If you still are having trouble completing the steps with a stylus, try using a mouse.

TEACHER TIP 3 / 4

Excel 2013 Instructor’s Manual Page 4 of 18 Many people start creating a worksheet before a requirements document or sketch has been made.Encourage students to work from a requirements document and to create a sketch of what they want the worksheet to look like. These two tools are similar to creating an outline before writing a book.

CLASSROOM ACTIVITIES

• Class Discussion: Ask students why they think each component of a requirements document (needs

statement, source of data, summary of calculations, and special requirements) is important in developing a worksheet.

• Group Activity: Divide the class into small groups. Ask each group to select one or more of the

following projects that might be done in Excel, and write a requirements document for each, including a needs statement, the source of data, required calculations, and chart requirements: (1) A log for the usage, maintenance schedule, insurance, and licensing of the vehicles of a family with two cars, a pick-up truck, and a van (2) A money-tracking schedule for a student organization (3) A statistical record for a neighborhood T-ball league (4) A fitness-tracking program for a gym with several members

• Critical Thinking: Ask students to consider the following scenario: “You are an assistant to the

accounting manager for a small company that sells sports equipment online. The manager needs an analysis of sales by product to be presented at Friday’s managers’ meeting and asks you to gather and summarize the data.” How can you use Excel to complete this assignment? What information do you need to produce an accurate, useful analysis? What questions might you ask the accounting manager before starting on the assignment?

• Critical Thinking: What Excel features make the software such an important and popular tool for

business professionals?

• Critical Thinking: What is the most important factor in creating a useful worksheet? Why?

LAB ACTIVITIES

• Have students start Excel with a blank workbook and then explore the Excel window elements and

worksheet elements.

EX 6: Selecting a Cell

LECTURE NOTES

• Define the phrase to select a cell (make it active) • Describe how to select/activate a cell by tapping it or clicking it • Review the alternative method of selecting a cell with arrow keys • Explain how to know when a cell is active/selected

BOXES:

• Yellow Box: For an introduction to Office and instruction about how to perform basic Office tasks,

read the Office and Windows chapter at the beginning of this book, where you can learn how to run an application, use the ribbon, save a file, open a file, exit an application, use Help, and much more.

• / 4