Teaching and Learning with Microsoft® Office 2010 and Office 2011 for Macis an ideal resource for pre-service and practicing teachers aspiring to integrate technology effectively, create an engaging learning environment, and learn the basics of common application software. This text introduces and explains the most important functions of the Microsoft Office tool including Word, PowerPoint and Publisher and includes two complete chapters on the use and application of Microsoft Excel. This text is designed with both the novice and the expert in mind and offers tips, practice problems, teaching ideas and tiered exercises that provide practice and skill acquisition for every level: beginner, intermediate, and advanced.

Tim Newby

Timothy Newby is a Professor of Learning Design and Technology at Purdue University. He conducts research on issues pertaining to motivation, human learning, and the impact of instructional strategies on the learning process.  He teaches introductory courses in educational technology, as well as advanced courses in instructional design, foundations of instructional design theory and instructional strategies. His research efforts have produced several textbooks focused on educational technology, as well as journal articles dealing with the development and use of instructional strategies such as analogies, mnemonics, and various forms of animated and static graphics. His instructional strategies research has led to an interest in the technologies that can help to implement those strategies. Currently he is investigating the use of Web 2.0 technologies and their potential impact within various types of learning environments.  

 

Judy Lewandowski

Judith Oates Lewandowski is an Associate Professor of Instructional Technology at Indiana University South Bend. Prior to joining the faculty, Judith served as a high school educator, professional development specialist, and K-12 Outreach Coordinator for Purdue University. Her research and pedagogical interests include technology integration, social studies education, issues of privacy and security, and the development of authentic assessment within technology integration courses.

Introduction     

 

Chapter 1: SYSTEM SOFTWARE—MS Windows 7: The Basics of Navigating the System    

Introduction     

Orientation

Level 1: Designing, Building, and Using a Good Filing System   

Level 2: Help, I Need Some Info   

Level 3: Integration and Application

MS Office 2011 for Mac: System Software:  The Mac OS 

 

Chapter 2: WORD PROCESSING—MS Word: The Basics of a Writing Assistant

Introduction     

Orientation

Level 1: Designing, Creating, and Producing Written Documents     

Level 2: Tables, Templates, and Other Good Stuff  

Level 3: Integration and Application

MS Office 2011 for Mac:  MS Word for Mac 2011    

 

Chapter 3: SPREADSHEETS—MS Excel: The Basics of a “Number Cruncher”    

Introduction     

Orientation

Level 1: Designing, Creating, and Producing a Useful Data-based Class Project

Level 2: “What If’s...” and Other Good Stuff    

Level 3: Integration and Application in the Classroom

MS Office 2011 for Mac:  MS Excel for Mac 2011     

 

Chapter 4: DATA MANAGEMENT—More MS Excel: The Basics of Collecting, Organizing, and Retrieving Loads of Information

Introduction     

Orientation

Level 1: Revisiting the Recycling Project     

Level 2: Mail Merge and Other Good Stuff

Level 3: Integration and Application

MS Office 2011 for Mac:  Excel as a database

 

Chapter 5: PRESENTATION SOFTWARE—MS PowerPoint: The Basics of Creating Presentations, Handouts, and Much, Much More

Introduction     

Orientation

Level 1: Creating Presentations to Teach    

Level 2: Creating Presentations to Learn     

Level 3: Integration and Application

MS Office 2011 for Mac:  MS PowerPoint for Mac 2011 

 

Chapter 6: DESKTOP PUBLISHING—MS Publisher: The Basics of Creating a Publication    

Introduction     

Orientation

Level 1: Designing, Creating, and Producing Publications    

Level 2: Tables, Templates, and Other Good Stuff  

Level 3: Integration and Application     

 

Glossary    

Index