Online Undergraduate Certificate in Microsoft Office Applications

This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access® Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization, and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels. Microsoft Access® is a registered trademark of Microsoft Corporation.

This course is a study of the concepts and technology trends essential to office productivity applications. Students will explore the principles, practices, features, and functions of the word processing application in the Microsoft Office® Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Word® to create and format documents; and use lists, themes, mail merge, watermarks, templates, graphics, navigation tools, tables, charts, citations and bibliographies. Students may access MS Office 365® Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty. Microsoft Office®, Microsoft Word® and Microsoft Office 365® is a registered trademark of Microsoft Corporation.

This course is a study of the concepts and technology trends essential to office productivity applications. Students will explore the principles, practices, features, and functions of the electronic spreadsheet application in the Microsoft Office® Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Excel® to create and format spreadsheets; they will also manipulate data and use formulas, charts, workbooks, styles, hyperlinks, themes, functions, conditional logic, graphics, comments, and security features. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. The course content maps to the Microsoft Office Specialist (MOS): to Microsoft Office Excel Certification. Students may access MS Office 365® Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty. Microsoft Office®, Microsoft Excel® and Microsoft Office 365® is a registered trademark of Microsoft Corporation.

This course is a study of the concepts and technology trends essential to office presentation, communication and productivity applications. Students will explore the principles, practices, features, and functions of Microsoft PowerPoint®, the presentation application in the Microsoft Office® Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft PowerPoint to build and format presentations; and to use styles, templates, lists, tables, charts, hyperlinks, transitions, animations, graphics, multimedia, and digital signatures. They will also rehearse the timing of the presentation and prepare presentations for the Web. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. Students may access MS Office 365® Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty. Microsoft PowerPoint®, Microsoft Office® and Microsoft Office 365® are registered trademarks of Microsoft Corporation.

In this course, students will explore the principles, practices, features, and functions of software in the Microsoft Office® Suite. The course will be taught through a mixture of analytical methods and practical exercises. Students will use Microsoft Word®, Excel®, Outlook®, Access®, and PowerPoint® to format and design documents, databases, and spreadsheets. Students will also design and publish advertising and marketing documents according to hypothetical and real-world scenarios. Through this course, students may acquire a more comprehensive understanding of commonly used applications and how they can be integrated with one another. Students may access the free Microsoft Office 365® suite via their MyCampus account. This software suite is available to students using both Apple® and Microsoft Windows® computers. Microsoft Word®, Microsoft Excel®, Microsoft Outlook®, Microsoft Access®, Microsoft PowerPoint®, Microsoft Office 365®, and Microsoft Windows® are registered trademarks of Microsoft Corporation. Apple® is a registered trademark of Apple Inc.

This course studies the concepts and technology trends of project management. Students will explore the principles, practices, features, and functions of the Microsoft Project® application, using a combination of analytical methods and practical exercises. In this course, students will create project plans; organize tasks such as estimating, budgeting, and scheduling; and perform and manage resource allocation. In addition, students will identify project constraints, determine a project’s critical path, create Gantt charts, and establish a project baseline using Microsoft Project. Students must have access to Microsoft Office Project Standard 2016 or higher. Course software requirements, including the appropriate versions, are listed under the course materials site. This course aligns with the topical requirements for the CompTIA Project+® Certification. Students are required to purchase and use Microsoft Project® to successfully complete the course. The software is not included with the course. While the course aligns with Microsoft Office Project Standard 2016 or higher related exams, students will need additional preparation beyond the course to sit for the exam. Microsoft Project® is a registered trademark of Microsoft Corporation. CompTIA Project+® is a registered trademark of the Computing Technology Industry Association, Inc.