GO! with Office 2016, Volume 1

Description

Teach the course YOU want in LESS TIME!

In today’s fast-moving, mobile environment, the GO! with Office 2016 series focuses on the job skills needed to succeed in the workforce. With job-related projects that put Microsoft Office^® into context, students learn the how and why at the moment they need to know, all in the appropriate Microsoft procedural syntax.

For Office 2016, the hallmark guided-practice to skill-mastery pathway is better than ever. Students have many opportunities to work live in Microsoft office to apply the skills they’ve learned. In addition, instructional projects are now available as grader projects in MyITLab, so students can work live in Office while receiving auto-graded feedback. These high-fidelity simulations match the text and provide an effective pathway for learning, practicing, and assessing their abilities. After completing the instructional projects, students can apply their skills with a variety of progressively challenging projects that require them to solve problems, think critically, and create on their own. New GO! Collaborate with Google projects allow students to apply their skills to a new environment that is already popular in many workplaces. Integrated Microsoft Office Specialist (MOS) objectives make GO! your one resource for learning Office, gaining critical productivity skills, and prepare for MOS certification.

MyITLab^® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, to engage students and improve results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, so students learn more quickly and effectively, and build the critical skills needed for college and career success. Digital badges allow students to showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers.

Teach the course YOU want in LESS TIME!

In today’s fast-moving, mobile environment, the GO! with Office 2016 series focuses on the job skills needed to succeed in the workforce. With job-related projects that put Microsoft Office^® into context, students learn the how and why at the moment they need to know, all in the appropriate Microsoft procedural syntax.

For Office 2016, the hallmark guided-practice to skill-mastery pathway is better than ever. Students have many opportunities to work live in Microsoft office to apply the skills they’ve learned. In addition, instructional projects are now available as grader projects in MyITLab, so students can work live in Office while receiving auto-graded feedback. These high-fidelity simulations match the text and provide an effective pathway for learning, practicing, and assessing their abilities. After completing the instructional projects, students can apply their skills with a variety of progressively challenging projects that require them to solve problems, think critically, and create on their own. New GO! Collaborate with Google projects allow students to apply their skills to a new environment that is already popular in many workplaces. Integrated Microsoft Office Specialist (MOS) objectives make GO! your one resource for learning Office, gaining critical productivity skills, and prepare for MOS certification.

Also available with MyITLab

MyITLab^® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, to engage students and improve results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, so students learn more quickly and effectively, and build the critical skills needed for college and career success. Digital badges allow students to showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers.

Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

• Windows 10
• Chapter 1 Getting Started with Windows 10
• Chapter 1 Introduction to Microsoft Office 2016 Feature
• Introducing Microsoft Word 2016
• Chapter 1 Creating Documents with Microsoft Word 2016
• Chapter 2 Creating Cover Letters and Using Tables to Create Resumes
• Chapter 3 Creating Research Papers, Newsletters, and Merged Mailing Labels
• Introducing Microsoft Excel 2016
• Chapter 1 Creating a Worksheet and Charting Data
• Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks
• Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
• Introduction to Microsoft Access 2016
• Chapter 1 Getting Started with Microsoft Access 2016
• Chapter 2 Sort and Query a Database
• Chapter 3 Forms, Filters, and Reports
• Introducing Microsoft PowerPoint 2016
• Chapter 1 Getting Started with Microsoft PowerPoint
• Chapter 2 Formatting PowerPoint Presentations
• Chapter 3 Enhancing a Presentation with Animation, Video, Tables, and Charts
• Integrated Projects
• Chapter 1 Integrating Word, Excel, Access, and PowerPoint
• Appendix
• Glossary
• Index

About the Book

• NEW! Coverage of Office 2016 features ensures that students are learning the skills they need to work in today’s job market.
• GO! To Work Page offers a summary of the chapter items focused on employability, including a MOS Objective summary, Build Your ePortfolio guidelines, and the GO! For Job Success soft skills videos and discussions.
• The clean design includes plenty of screenshots that validate students’ actions and engage visual learners.
• NEW! In-text boxed content is included in-line with the instruction—not in the margins—so students won’t miss this important information and will learn it in context with what is on their screen. This applies to Another Way, Notes, More Knowledge, Alerts, and By Touch.

Also available with MyITLab

MyITLab^® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, to engage students and improve results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, so students learn more quickly and effectively, and build the critical skills needed for college and career success. Digital badges allow students to showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers.

• NEW! MyITLab 2016 Grader Projects: In addition to the homework and assessment Graders already available, the A and B instructional projects are now Graders, enabling students to learn by doing live in the application and receive the instant feedback they need to ensure understanding.
• MyITLab HTML5 Training & Assessment Simulations provide a high-fidelity environment with a step-by-step summary of student actions and include just-in-time learning aids to assist students: Read, Watch, Practice.
• NEW! Simulations for Office 2016 have been updated to match the pedagogical approach of the textbook projects and provide a direct one-to-one learning experience.
• NEW! Windows 10 Coverage includes GO! Learn How videos and MyITLab simulation trainings for the Windows 10 skills covered in the textbook, helping students get up and running with the new operating system.
• NEW! Google Projects: For each A and B instructional project, students construct a parallel project using Google productivity tools. This gives them the opportunity to think critically and apply what they are learning about Microsoft Office to other productivity tools, which is an essential job skill.
• NEW! Microsoft Office Specialist (MOS) objectives are integrated into the text for easy review and reference for students who are preparing for a MOS certification exam. The MOS appendix provides a comprehensive list of the exam objectives.
• NEW! Lessons on the GO! projects cover newer Microsoft apps such as Sway and MIX and things yet to come! These lessons are found in MyITLab and the Instructor’s Resource Center, and come with instructional content, student data files, solutions files, and rubrics for grading.
• Videos help students learn and gain skills and insights needed to succeed in the workforce, in an enjoyable way.
• NEW! GO! Walk Thru videos show a quick 30-second preview of what students will do and create—from beginning to end—by completing each of the A and B Instructional Projects. These videos increase confidence by showing the entire Project built quickly.

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master’s degree in business education from Northern Illinois  University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Nancy Graviett is a professor in the Business and Computer Science department at St. Charles Community College in Cottleville, Missouri, where she is the program coordinator for the Business Administrative Systems program and teaches within the program. Nancy is also very active with distance learning and teaches in face-to-face, hybrid, and online formats. She holds a master’s degree from University of Missouri. Nancy holds Microsoft® Certified Application Specialist certification in multiple applications and provides training both on and off campus. In her free time, Nancy enjoys quilting and spending time with family and friends.

Debra Geoghan is currently an associate professor of computer and information science at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has earned certifications from Microsoft, CompTIA, Apple, and others. Deb has taught at the college level since 1996 and also spent 11 years in the high school classroom. She holds a B.S. in Secondary Science Education from Temple University and an M.A. in Computer Science Education from Arcadia University. Throughout her teaching career, Deb has worked with other educators to integrate technology across the curriculum. At BCCC, she serves on many technology committees, presents technology workshops for BCCC faculty, and runs a summer workshop for K-12 teachers interested in using technology in their classrooms. Deb is an avid user of technology which has earned her the nickname “gadget lady”.

Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College. She holds a master’s and a bachelor’s degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

About the Book

• NEW! Coverage of Office 2016 features ensures that students are learning the skills they need to work in today’s job market.

• A project-based approach clusters learning objectives around the projects, rather than software features. The instruction is based on the teachable moment where students learn important concepts at the exact moment they are practicing the skills.

  • Explanations and concepts are woven into each step without making students read long paragraphs of text before interacting with the software.

  • Learning outcomes are clearly stated, with numbered objectives, so students always know what they need to learn.

  • Each Project Opening Page clearly outlines:

    • Project Activities: what the student will do in this project

    • Project Files: what starting files are needed and how the student will save the files

    • Project Results: what the student’s finished project will look like

• The clean design includes plenty of screenshots that validate students’ actions and engage visual learners.

  • Color-coded steps guide students through the projects with colors coded by project.

  • End-of-project icons let students know when they have completed a project, especially useful in self-paced or online classes.

  • NEW! In-text boxed content is included in-line with the instruction—not in the margins—so students won’t miss this important information and will learn it in context with what is on their screen. This applies to Another Way, Notes, More Knowledge, Alerts, and By Touch.

• Teach the Course You Want in Less Time: the GO! series’ one-of-a-kind instructional system provides you with everything you need to prepare for class, teach the material, and assess your students.

  • Student Assignment Tracker lets students to track their own work.

  • Solution Files offer examples of homework submissions to serve as examples for students

  • Teach

  • PowerPoint Presentations provide a visual walk-through of every chapter with suggested lecture notes included.

  • Audio PowerPoint Presentations provide a visual walk-through of the chapter with the lecture notes read out loud.

  • Assess

    • Every assignment is accompanied by either a scoring checklist, a task-specific rubric, or an analytic rubric.

    • Solution Files are provided in three formats: native file, PDF, and annotated PDF.

    • Rubrics provide guidelines for grading open-ended projects.

    • Testbank questions are available for you to create your own objective-based quizzes for review.

• NEW! IT Innovation Station lets you stay current with Office and Windows updates, news, and trends, especially now that Microsoft Office is in the cloud. Monthly updates on the MyITLab Community site,  www.myitlabcommunity.com, from Pearson’s product team and author-instructors will offer tips on understanding updates, using new capabilities, implementing new instructional techniques, and optimizing your Office usage.

Additional information