Undergraduate Certificate in Microsoft Office Applications

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 2010 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 will also be introduced to the features and capabilities of PowerPoint, the presentation application in the Microsoft Office Suite. This course uses the Microsoft Official Academic Course textbook that is aligned with Microsoft’s Exam--Using Microsoft Office Word 2010. The book meets the topical requirements for the Microsoft Office Specialist (MOS): Microsoft Office Word 2010 Certification; and contains a six month trial of Microsoft Office.

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 2010 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 also be introduced to Outlook, the electronic mail application in the Microsoft Office 2010 Suite. This course uses the Microsoft Official Academic Course textbook that is aligned with Microsoft’s Exam—Using Microsoft Office Excel 2010. The book meets the topical requirements for the Microsoft Office Specialist (MOS): Microsoft Office Excel Certification; and contains a six month trial of Microsoft Office.

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 PowerPoint, the presentation application in the Microsoft Office 2010 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 also be introduced to the Microsoft Word, the word processing application in the Microsoft Office 2010 Suite. This course uses the Microsoft Official Academic Course textbook that is aligned with Microsoft’s Exam—Using Microsoft Office PowerPoint 2010. The book meets the topical requirements for the Microsoft Office Specialist (MOS): Microsoft Office PowerPoint Certification; and contains a six month trial of Microsoft Office.

This course is a study of the concepts and technology trends essential to office communication. Students will explore the principles, practices, features, and functions of Outlook, the electronic mail application in the Microsoft Office 2010 Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will customize the Outlook program; and use messages, signatures, advanced email tools, digital signatures, delivery options, voting capabilities, mail management, rules, contacts, calendar functions, meetings, and tasks. Students will also be introduced to the Microsoft Word, the word processing application in the Microsoft Office 2010 Suite. This course uses the Microsoft Official Academic Course textbook that is aligned with Microsoft’s Exam: Using Microsoft Office Outlook 2010. The book meets the topical requirements for the Microsoft Office Specialist (MOS): Microsoft Office Outlook Certification; and contains a six month trial of Microsoft Office.

This course provides an introduction to Web 2.0 trends and technologies. Students will profile the various features, tools, communities, and practices available in Web 2.0. Also included is a survey of the concepts, tools, and practices used to build blogs and wikis. The course also reviews the various methods of posting information from the blog into web pages using RSS & Atom techniques. Students will also appraise other Web 2.0 technologies, such as forums, collaborative web sites, discussion boards, and wikis. Students will apply the knowledge gained in this course to design and create blogs and forums. Students must have access to a microphone.

This course concentrates on the technical side of the Internet, examining network types, protocols, browsers, search engines, email communication and personal information management, multimedia on the Web, Internet services and tools [newsgroups, telnet, File Transfer Protocol (FTP), and instant messaging], Internet security (encryption, authentication, firewalls, malware, virus detection and prevention, spyware, updates and patches), and IT project management. This course also explores emergent Web 2.0 technologies such as social networking (MySpace), user created content (YouTube), Wikis, Virtual Worlds (Second Life), and online gaming. Students will need access to Microsoft Internet Explorer 7.0 (or higher) with Outlook Express. This software is not provided by the course material grant and must be purchased/provided by the student. This course covers the Internet Business Foundations curriculum of the CIW Foundations certification.