Request for consultation
Your form is submitting...
Overview
MINDTAP for Campbell/Carey/Shaffer/Shellman's THE NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 2 TERMS INSTANT ACCESS includes updated Microsoft 365 features and enhanced support for Mac users. The unique in-depth, case-based approach helps students apply Microsoft Office skills to real-world business scenarios based on data from market insights while reinforcing critical-thinking and problem-solving skills. Professional tips and insights are incorporated throughout, and ProSkills Boxes help students strengthen their employability skills. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives. In addition, MindTap and updated SAM (Skills Assessment Manager) digital resources are available to guide additional study and ensure successful results.
- Microsoft Teams coverage includes three digital modules available in MindTap, authored by Corinne Hoisington.
- Updated to reflect Microsoft 365 features, including Accessibility Checker.
- New features for Excel include the application of dynamic arrays and dynamic array functions such as the FILTER, SORT, SORTBY, and UNIQUE functions. Other updates include LAMBDA and LET function for generating custom functions and function variables, along with coverage of Excel’s data types and the Analyze Data button used to spot trends and gain insight into data. Additionally, this edition includes coverage of XLOOKUP.
- New features for PowerPoint include the latest Microsoft 365 features in brand new scenario wrappers.
- New features for Word include the new focus mode, the updated collaboration experience, and Microsoft's expanded search feature and voice options.
- New features for Access include new, real-world scenarios from a wide variety of industries illustrating the relevance of Access databases in today’s businesses.
- Using an in-depth, case-based approach, Campbell/Carey/Shaffer/Shellman's THE NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 1 TERM INSTANT ACCESS CARD helps students apply Microsoft Office skills to real-world business scenarios based on data from market insights, all while reinforcing their critical-thinking and problem-solving skills.
- Introductory Textbook Projects are designed to ensure successful completion by Mac users for Word, Excel and PowerPoint.
- Embracing Change modules in MindTap help students navigate through Microsoft 365 continual software changes. Each module includes accessibility features, application-specific tips, a Microsoft ribbon and toolbar visual overview, and review and discussion questions.
- This title is part of THE NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE®, giving you access to a complete digital library of content spanning Computer Concepts, Operating Systems (for Windows and Mac), and the Microsoft Office Suite -- all for one price, including low-cost rental options. Learn more about Cengage Unlimited at https://www.cengage.com/unlimited .
- Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam. Users of MindTap Collections and SAM will have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.
- Students carefully examine the context for their projects, which increases the motivation to learn as they understand the “why” behind each step in the process.
- ProSkills Boxes help students strengthen their employability skills, including written and verbal communication, problem-solving, decision-making and teamwork.
- Trouble call-outs offer practical tips and insight to help readers avoid common errors.
1. Getting to Know Office Versions.
2. Introduction to MindTap & SAM.
3. Using SAM Projects and Textbook Projects.
4. Getting Started with File Management.
5. Getting Started with Microsoft OneNote.
6. Getting Started with Microsoft Office Online and OneDrive.
7. Getting Started with Microsoft Teams.
8. Getting Started with Office for Mac.
9. Embracing Change in Technology.
TECHNOLOGY FOR SUCCESS: COMPUTER CONCEPTS.
1. Impact of Digital Technology.
2. The Web.
3. Computer Hardware.
4. Operating Systems and File Management.
5. Software and Apps.
6. Security and Safety.
7. Digital Media.
8. Program and App Use and Development.
9. Web Development.
10. Networking.
11. Digital Communication.
12. Digital Transformation: Cloud, eCommerce, and AI.
13. Databases.
14. Digital Ethics and Lifestyle.
OPERATING SYSTEMS MODULES (FROM THE SHELLY CASHMAN SERIES).
1. Introduction to Windows.
2. Working with the Windows Desktop.
3. File and Folder Management.
4. Personalizing you Work Environment.
5. Advanced Personalization and Customization.
6. Advanced Searching Techniques.
7. Microsoft Edge.
8. Mastering Digital Media.
9. Understanding Security, Networking and Utilities.
10. Getting Started with Mac OS.
MICROSOFT TEAMS MODULES.
1. Introduction to Teams.
2. Making Meetings More Productive.
3. Build an Effective Work Team.
MICROSOFT WORD MODULES.
1. Creating and Editing a Document.
2. Navigating and Formatting a Document.
3. Creating Tables and a Multipage Report.
4. Enhancing Page Layout and Design.
5. Working with Templates, Themes, and Styles.
6. Using Mail Merge.
7. Collaborating with Others and Integrating Data.
8. Customizing Word and Automating Your Work.
9. Creating Online Forms Using Advanced Table Techniques.
10. Managing Long Documents.
MICROSOFT EXCEL MODULES.
1. Getting Started with Excel: Tracking Miscellaneous Expenses for a Conference.
2. Formatting Workbook Text and Data: Creating a Sales Report.
3. Performing Calculations with Formulas and Functions: Staffing a Call Center.
4. Analyzing and Charting Financial Data: Preparing an Investment Report.
5. Generating Reports from Multiple Worksheets and Workbooks: Summarizing Profit and Loss Statements.
6. Managing Data with Data Tools: Analyzing Employment Data.
7. Summarizing Data with PivotTables: Developing a Customer Relationship Management Workbook.
8. Performing What-If Analyses: Maximizing Profits with the Right Product Mix.
9. Exploring Financial Tools and Functions: Analyzing a Business Plan.
10. Managing Data with Business Intelligence Tools.
11. Exploring PivotTable Design: Summarizing Sales and Revenue Data.
12. Developing an Excel Application: Creating a Data Entry App.
MICROSOFT ACCESS MODULES.
1. Creating a Database.
2. Building a Database and Defining Table Relationships.
3. Maintaining and Querying a Database.
4. Creating Forms and Reports.
5. Creating Advanced Queries and Enhancing Table Design.
6. Using Form Tools and Creating Custom Forms.
7. Creating Custom Reports.
8. Sharing, Integrating, and Analyzing Data.
9. Using Action Queries and Advanced Table Relationships.
10. Automating Tasks with Macros.
11. Using and Writing Visual Basic for Applications Code.
12. Managing and Securing a Database.
Appendix A: Relational Databases and Database Design.
MICROSOFT POWERPOINT MODULES.
1. Creating a Presentation: Presenting Information About a Staffing Agency.
2. Adding Media and Special Effects: Using Media in a Presentation for a Parks and Recreation Department.
3. Applying Advanced Formatting to Objects: Formatting Objects in a Presentation for a Custom Stationery Company.
4. Advanced Animations and Distributing Presentations: Creating an Advanced Presentation for a Home Staging Company.
5. Integrating PowerPoint with Other Programs: Creating a Presentation for Resident Advisors.
6. Customizing Presentations and the PowerPoint Environment: Creating a Presentation for a Youth Center Upcycling Challenge.
Concepts Module: Planning, Developing, and Giving a Presentation: Preparing a Presentation for an Investment Company.
MICROSOFT OUTLOOK MODULES (FROM THE SHELLY CASHMAN SERIES).
1. Managing Email Messages with Outlook
2. Managing Calendars with Outlook
3. Managing Contacts and Personal Contact Information with Outlook
4. Creating and Managing Tasks with Outlook
5. Customizing Outlook
CAREER READINESS.
Using Resume Assistant Powered by LinkedIn.
Building an Online Portfolio using PathBrite.
Microsoft Office Specialist (MOS) Certification Resources.