Cover image for Microsoft Office for teachers
Microsoft Office for teachers
Fewell, Patricia J.
Personal Author:
Publication Information:
Upper Saddle River, N.J. : Merrill/Prentice Hall, [2003]

Physical Description:
xiv, 210 pages : illustrations ; 28 cm + 1 CD-ROM (4 3/4 in.)
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
LB1028.3 .F48 2003 Book and Software Set Non-Fiction Area-Oversize

On Order



Focusing on one of the most widely used software packages, this text guides readers through how to use Microsoft Office 2000. Readers are walked through a section of the software package using screen shots in a "Show Me" section, then presented with a "Let Me Try" section. Windows Basics; Office Basics; Word (Word Processing); PowerPoint (Presentation Software); Excel (Spreadsheet); Access (Database); and Outlook.

Author Notes

Patricia J. Fewell is a professor of secondary education and foundations at Eastern Illinois University. She received her Ed.D. in 1988 from Illinois State University. A certified K-I 2 media specialist, she is currently teaching introductory educational media for pre-service teachers. Dr. Fewell has served as president of the division of educational media management of the Association for Education Communications and Technology (AECT) and as secretary/treasurer for the AECT board of directors, and she currently serves as secretary for the Education Communication and Technology Foundation (ECT) Foundation. She also presents at state, national, and international conferences on technology applications in the classroom.

William J. Gibbs is a professor in the School of Technology and the coordinator of the Center for Academic Technology Support at Eastern Illinois University. He received his Ph.D. from the Pennsylvania State University in 1992. Dr. Gibbs teaches courses in instructional technology and works with faculty to design and develop technology-based learning programs. He has presented at state, national, and international conferences on instructional technology and has had a number of articles published in this area.



Conceptual Framework In this book, computers and associated software are presented as tools or means to accomplish tasks in instruction, learning, and classroom management. From this perspective, computer software is referred to as applications software. We discuss five categories of applications software, including word processing, presentation, database, spreadsheet, and telecommunications. Each category is presented as part of the Microsoft Office suite in Word, PowerPoint, Access, Excel, and Outlook. We offer specific instructions and recommendations for using these products in the classroom and, therefore, try to provide teachers a starting point from which to develop their technological knowledge as well as to begin integrating technology into the curriculum. Teachers are busy people and often do not have time to learn new software applications. Word processing, databases, and spreadsheets can improve work efficiency, expand the range of tasks performed, improve accuracy and effectiveness, and reduce the amount of time needed to perform routine tasks. However, the initial time needed to learn these applications can be an obstacle for some teachers. We attempt to address this issue in three ways. First, we present a visually illustrated and nontechnical approach to learning the Microsoft Office XP suite. The book includes software "screen-capture" illustrations supplemented with text descriptions, work templates, and exercises to help motivate teachers to learn and use these applications, thereby reducing the frustration one often experiences when studying intensive technical manuals. Second, we believe it is useful to build on the suggestions and work of others; so we have created work templates with the Office products (such as sample newsletters, a grade book, and so on) and exercises that demonstrate the usefulness of the Microsoft Office suite and the diversity of its applications. Teachers can quickly and easily tailor these templates and exercises to meet their specific needs. Third, because there are many tasks that teachers perform each day in the classroom, such as creating grade books, newsletters, and posters, or making presentations to parent groups or the school board, the book focuses on these tasks as a catalyst for learning the Microsoft Office suite. For example, many preservice teachers need to know how to create a class newsletter, store student records, calculate test scores, and help students create an electronic presentation for which word processing, database, spreadsheet, and presentation development skills are fundamental. The activities in this book focus on these tasks to cultivate basic computing proficiency. Using nontechnical and graphically illustrated "how-to" procedures, teachers and students accomplish real-world, computer-based tasks and, in doing so, develop skills in word processing, database management, using spreadsheets, and making presentations. We have written this book for teachers who have very basic computing skills, such as opening, creating, and closing files and operating a mouse. The activities described in the book require a computer capable of running Microsoft Office XP. Organization Chapter I provides an introduction to the book and offers information about state and national technology standards for teachers and students for integrating technology in the classroom. Chapter 2 addresses the Microsoft Office XP interface, including taskbars, menu options, and working with Windows. It also presents the steps for configuring toolbars and using the Office Assistant. Chapter 3 discusses word processing, including the process of creating a new Microsoft Word document and modifying an existing one. It focuses on creating a book report, a Web page document, and a newsletter. Using the chapter activities, students create word processing documents. They use the copy, cut, paste, and formatting options as well as WordArt and clip art to create a document with columns--for the newsletter "look:" The chapter also presents graphic design and layouts of newsletters, and pitfalls to avoid when creating a newsletter or any document with graphics. Once a simple newsletter has been created, the students save the document to a disk and print it. Chapter 4 provides an introduction to Microsoft PowerPoint. It focuses on PowerPoint fundamentals and how to apply them in developing a presentation. Using the example of a student research team reporting on weather conditions, the chapter outlines the steps of creating a presentation. It discusses slide layout, design, importing graphics, and clip art, as well as printing a presentation and saving it as a Web page. Chapter 5 provides an introduction to Microsoft Excel. The focus is on Excel fundamentals and applying them to classroom learning activities. It presents step-by-step instructions for creating workbooks, and editing and manipulating data in worksheets. The chapter activities include creating a workbook, entering data into a worksheet, editing data and performing calculations on them, and charting data. Chapter 6 covers Microsoft Access and discusses the process of opening new and existing databases. It presents detailed instructions for creating a database, entering information into it, and searching a database. The chapter reviews using the wizard as well as the Access editor for database creation. It also discusses saving files and printing reports. Chapter 7 discusses using Microsoft Outlook for e-mail. In it, we review the concepts of e-mail, networking, and the hardware needed to send e-mail. The chapter presents procedures for composing, sending, reviewing, receiving, organizing, and deleting e-mail. Components of an e-mail account are also described. You may sequence the chapters to suit your needs. Although the chapters are related, they can be used independently. For example, a teacher interested in having students create monthly newsletters will find Chapter 3 (Word) useful, whereas another teacher wanting students to create book report presentations will find Chapter 4 (PowerPoint) informative. Features of the Book Each chapter is organized in a similar format. Advance Organizers Each chapter begins with a set of advance organizers intended to prepare readers for the main chapter contents. Advance organizers include the following: An outline of chapter topics Learning objectives Technical terminology An overview summarizing the chapter contents, providing rationale for the topics, and discussing their use Show Me Following the advance organizers, step-by-step instructions for manipulating the technical aspects of the application are presented. For example, procedures may describe writing a letter using Microsoft Word. Using both text and graphics, the steps necessary to accomplish this task are covered in detail. Additionally, the chapters present the rationale for performing specific software functions. Let Me Try Let Me Try exercises are embedded throughout the chapters to give you an opportunity to practice the information presented. These exercises serve two functions. First, they offer guided practice for operating the software. Second, working through the exercises produces outcomes, such as a database file, a Word document, a PowerPoint presentation, and so on. As previously mentioned, classroom teachers perform a host of instructional and managerial tasks each day. The Let Me Try exercises are based on these tasks, which may include, among other things, creating grade books with Excel, class newsletters with Word, or a student research report presentation with PowerPoint. In some cases, digital files of templates and examples are provided to support the Let Me Try exercises. Chapter Summary Each chapter concludes with a challenge section and a summary. The challenges are suggestions based on the Show Me topics from the chapter. The summary highlights the main topics covered in the chapter and presents a brief summation of them. Acknowledgements A number of the ideas within this text were conceived or provided by classroom teachers to whom we are most grateful. We would like to especially thank the teachers at the Prairieland Elementary School. They gave us many ideas. Bridgette Belasli graciously provided work samples that proved most useful and helped us develop real-world examples in the text. Terry Hyder spent many hours reviewing drafts of the text. Her suggestions were invaluable, and we greatly appreciate her efforts. We also thank Debbie Stollenwerk and Dan Parker for their support of our ideas and the insights they provided us along the way. They were always encouraging and helpful. The following reviewers also provided invaluable advice: J. Michael Blocher, Northern Arizona University; Judith L. Cope, California State University of Los Angeles; Kim Foreman, San Francisco State University; Leslie Hall, University of New Mexico; Mary Hayes, Clearwater Christian College; Michael Jackson, Southern Illinois University-,Virginia Jewell, Columbus State Community College; Mary Juliano, Caldwell College; Ronghua Ouyang, Kennesaw State University; and Elizabeth M.Willis, Northern Arizona University. Mostly, we thank our families for their understanding and support as we developed this book. Earl Longman, Joy Longman, and Suzanne Longman, and Annette Gibbs, Lauren Gibbs, and Liam Gibbs, and James and Helen Gibbs, your encouragement made this book possible. Excerpted from Microsoft Office for Teachers by Patricia J. Fewell, William J. Gibbs All rights reserved by the original copyright owners. Excerpts are provided for display purposes only and may not be reproduced, reprinted or distributed without the written permission of the publisher.

Table of Contents

Chapter 1 Introductionp. 1
Chapter Outlinep. 1
Learning Objectivesp. 2
Technical Termsp. 2
Chapter Overviewp. 2
About This Book and Using Technologyp. 2
Expectations of Teachersp. 3
Expectations of Studentsp. 4
Teacher Production of Materialsp. 5
Student Production of Materialsp. 6
Tying It All Togetherp. 7
Chapter 2 Office Basicsp. 8
Chapter Outlinep. 8
Learning Objectivesp. 9
Technical Termsp. 9
Chapter Overviewp. 9
Working with Microsoft Office Suitep. 9
Opening Office Applicationsp. 9
Main Menu Toolbarp. 11
Standard Toolbarp. 16
Office Assistantp. 17
Formatting Toolbarp. 18
Tying It All Togetherp. 19
Chapter 3 Word 2002p. 20
Chapter Outlinep. 20
Learning Objectivesp. 21
Technical Termsp. 21
Chapter Overviewp. 21
About Wordp. 22
How a Teacher and Students Might Use Word 2002p. 22
Show Mep. 22
Creating a Word Documentp. 22
A challenge Using Word 2002p. 36
Tying It All Togetherp. 36
Chapter 4 Powerpoint 2002p. 37
Chapter Outlinep. 37
Learning Objectivesp. 38
Technical Termsp. 38
Chapter Overviewp. 39
About PowerPointp. 39
Working with PowerPointp. 39
Show Mep. 40
Developing the Presentationp. 40
Adding a Design Templatep. 42
Navigating Between Slidesp. 46
Adding Clip Artp. 49
Modifying Textp. 54
Previewing the PowerPoint Presentation in the Slide Showp. 66
Saving the Presentationp. 66
Adding Slide Transitionsp. 67
Saving as a Web Pagep. 68
What PowerPoint Savesp. 69
Spell Checking the PowerPoint Presentationp. 70
Printing the PowerPoint Presentationp. 71
A Challenge Using PowerPoint 2002p. 72
Tying It All Togetherp. 72
Referencesp. 72
Chapter 5 Excel 2002p. 73
Chapter Outlinep. 73
Learning Objectivesp. 74
Technical Termsp. 74
Chapter Overviewp. 74
About Excelp. 74
Working with Excelp. 75
A Word About Excel Workspacep. 75
Moving About in a Worksheetp. 77
Show Mep. 77
Creating a Workbook and Worksheetsp. 77
Entering Data in a Worksheetp. 77
Merge and Centerp. 79
Formulasp. 89
Moving and Copying Datap. 93
Charting Excel Datap. 96
Modifying the Chartp. 101
Saving as a Web Pagep. 104
Opening the Workbook in a Web Browserp. 106
Spell Checking the Excel Workbookp. 108
Printing the Excel Workbookp. 109
A Challenge Using Excel 2002p. 110
Tying It All Togetherp. 110
Referencesp. 110
Chapter 6 Access 2002p. 111
Chapter Outlinep. 111
Learning Objectivesp. 112
Technical Termsp. 112
Chapter Overviewp. 112
About Accessp. 112
Working with Accessp. 113
A Word About Access Workspacep. 113
Show Mep. 114
Creating a Databasep. 114
Creating a Table Using a Wizardp. 115
Creating a New Database Using Design Viewp. 124
Creating a Formp. 127
Creating a Queryp. 130
A Challenge Using Access 2000p. 132
Tying It All Togetherp. 132
Referencesp. 132
Chapter 7 Outlook 2002p. 133
Chapter Outlinep. 133
Learning Objectivesp. 134
Technical Termsp. 134
Chapter Overviewp. 134
About Outlookp. 134
Working with Outlookp. 135
A Word About Outlook Workspacep. 135
Show Mep. 136
The Inboxp. 136
Calendarp. 142
Contactsp. 145
Tasksp. 148
Notesp. 149
Journalp. 150
Outlook Todayp. 152
A Challenge Using Outlook 2002p. 152
Tying It All Togetherp. 153
Referencesp. 153
Appendix A PowerPointp. 154
Appendix B Excelp. 158
Appendix C Accessp. 161
Appendix D Outlookp. 163
Appendix E Windowsp. 164
Appendix F Macintoshp. 186
Indexp. 205