The second edition of Technology Tools for Teachers: A Microsoft Office Tutorial is a practical, user-friendly guide for teachers who want to learn the basics of the Microsoft Office suite and how to integrate it into the curriculum. Through helpful step-by-step lessons, teachers will learn about the various features of Word, Excel, PowerPoint, Outlook, and Access and how to use them to help you and your students in the classroom. Whether you are looking to extend your knowledge of the programs in the suite, or you would like to begin learning them from scratch, you will find material appropriate to your experience level. Inservice K-12 Teachers.
Computers are in our classrooms to stay. This new step-by-step tutorial will help teachers gain a thorough understanding of Microsoft® Office, including Word, PowerPoint, Excel and Outlook. In this hands-on book, the step-by-step tutorials for each of these components are blended with examples and activities to help preservice and inservice teachers use Office both to improve classroom pedagogy and enhance professional productivity. Separate coverage of each of the applications offers self-contained, standalone units dedicated to Word, Excel, PowerPoint, and Outlook. A common structure to each skills chapter consists of lesson procedures, new terms, chapter overview, and lesson tutorials. For teachers in computer classes and media centers—of students at all grade levels.
NOTES FOR THE PROFESSOR
We shall not fail or falter; we shall not weaken or tire... Give us the tools and we will finish the job.
Sir Winston Churchill, BBC radio broadcast, February 9, 1941
Churchill's sentiment seems as applicable for today's teachers as it was for the British people in 1941. Like them, teachers are dedicated, tireless, and committed workers in one of the noblest of callings. Like them, teachers are faced with a daunting task, and yet our very survival depends on their success in accomplishing it. But how the "tools" they are given have changed in the last 60 years! Who could have predicted that in the post-World War II era, we would become an Information Society in which technologies like word processing and e-mail would help re-define the nature of work and make fundamental changes in the way we relate to each other, to our jobs, and to the world itself?
This textbook was written as an acknowledgement of the importance to teachers and students of learning to use information tools that have become an essential part of the fabric of our modern society. Modern teachers are faced with the task of integrating these tools into their everyday work and, by their example and instruction, teaching their students to do the wane. It is for this reason we feel that teaching teachers how to exploit the power of these tools is a crucial part of their preparation for the classroom.
This book was designed to help current and future teachers use a common and widely-used set of software tools, the Microsoft® Office suite, to gain the following insights and skills related to these software tools:
- Software skills are a learning continuum—The learning activities in each section are designed to take learners from low level of knowledge with each component to a fairly high level of skill. The chapter tutorials make it easy for beginners to learn the basics, but also show them how to build on this foundation. End-of-chapter exercises demonstrate how they can use Microsoft® Office Help and other features to increase their expertise with these powerful technologies.
- Software tools can empower teachers—As teachers learn the features of the software packages in Microsoft® Office, the examples they work through show them how the tools they are learning can enhance both their productivity and their teaching methods. The exercises not only teach them technical "how to" skills, they demonstrate that software tools are a fundamental part of every educator's "teaching toolkit."
- Integrating software tools enables other technology integration—Microsoft® Office is rapidly becoming the common denominator of classroom technology; many teachers have only this suite of programs available to them. Learning to use word processing, spreadsheets, presentation software, e-mail, and planning tools—all powerful resources in themselves—provides teachers with both the motivation and enabling skills to learn about the broader scope of technology tools available to teachers: instructional software, the Internet, multimedia/hypermedia, and content area tools.
Who Will Find This Book Useful
Educational Computing in Elementary/Secondary Education, Using Technology/ Computers in the Classroom, Instructional Design/Multimedia Authoring for Teachers Common software and communications applications including word processing, multimedia presentations, spreadsheets, e-mail, and the World Wide Web are now used in most teacher preparation courses in instructional technology as well as most K-12 classrooms. The authors of this book made several assumptions that were relevant for the publication of this book:
- Most universities now offer one or more teacher preparation courses in instructional technology, all or a portion of which is lab-based.
- The current focus of these teacher preparation courses in instructional technology is computer technology and not necessarily educational media or instructional design issues.
- There is an emphasis on curriculum integration of technology as opposed to only teacher use or productivity, suggesting the emergence of a generation of educators who will utilize the potential of computer-based technologies in the teaching/learning process.
This book is designed to support a hands-on approach to learning how to use software tools and integrate them into classroom activities. The methodology used by the book is to blend step-by-step lesson tutorials with technology application and integration activities. Each chapter demonstrates not only how to use particular features of the Microsoft® Office software productivity tools, but also provides examples of how to apply new skills in using these tools for classroom teaching and learning. This book should be useful in several educational contexts:
- As a primary instructional text. It can support basic instructional technology courses for preservice teachers and workshops and graduate courses for inservice teachers.
- As a supplemental instructional text. For courses that cover integration strategies for all technologies, this text can provide in-depth coverage of the software tools portion of integration.
- As a reference. In K-12 school libraries/media centers and university and college of education libraries and media centers, it can provide a handy way to look up specific skills and information related to the use of Microsof® Office software tools in education.
Cognitive Tools for Technology Integration
The chapters in the book include tutorials and exercises that demonstrate features of Microsoft® Word, Microsoft® Excel, Microsoft® PowerPoint®, Microsoft® Outlook®, that can be used as cognitive tools to support and facilitate teaching and learning in 21St century classrooms. While this book is intended to tutor students in the use of software productivity tools, it is also very much about applying the technology skills acquired through the tutorials to create interesting and engaging learning experiences for the classroom. This book includes many features that will equip preservice and inservice teachers for integrating technology in the classroom:
- Lesson procedures: A list of the tutorial steps at the beginning of each chapter provides an advance organizer for the lesson content and instructional activities.
- New terms: New words for students to learn so they can "talk the talk" as well as "walk the walk." This feature supports or reinforces the chapter content and instructional activities.
- Chapter overview of the lesson content and titles: Each chapter starts with a short overview of the chapter contents and a list of the lessons in the chapter. This feature provides an advance organizer for the chapter instructional activities.
- Lesson tutorials: Each chapter contains step-by-step lessons that teach the various features of the program as well as how to integrate these features into classroom teaching and learning.
- Post-lesson exercises: After each lesson are practice exercises to reinforce and support the technology skills described and demonstrated in the lesson.
- Post-chapter exercises: After each chapter are four sets of exercises:
- Set 1: Reviewing Terms and Concepts—Fill in items to review terms and concepts.
- Set 2: Expanding Your Skills—More activities to expand on skills learned in the chapter.
- Set 3: Use Microsoft® Help—Topics to look up on the Microsoft® Office Help Menu to get additional information on any topic and apply to the learning activities in the chapter.
- Set 4: Create Your Own Lesson—Ideas and activities for designing and developing a lesson that applies the features of the program to classroom teaching and learning.
- Alignment with national technology standards: The tutorial lessons presented in each section are aligned with the ISTE Standards for Students (NETS-S).
- Lesson scenarios: At the start of each section (for each productivity tool), a new case study or scenario is introduced. The chapters and lessons in the section are then presented from the point of view of a classroom teacher learning and applying the tool to teaching and learning in the context of his/her school and classroom.
- Windows and Mac compatibility: When differences occur between the Macintosh® and Windows® versions of an Office® task, a set of instructions specific to the Macintosh® version immediately follow the instructions for the current task.
- Compatibility with most versions of Microsoft® Office: The lessons are designed to be compatible with the latest releases of Microsoft® Office including Microsoft® Office XP for Windows® and Microsoft® Office 2001 and Outlook® 2001 for Macintosh® as well as most earlier versions of these products.
The following ancillaries assist the instructor in helping students learn these technology tools and in evaluating their progress in integrating these technology tools to classroom instruction:
- Lesson Plans ePortfolio: The Lesson Plans ePortfolio is a database students use in conjunction with some of the practice exercises in this book. As students progress through the tutorials and exercises in the book, they will build a portfolio of technology-based learning activit...