Spring 2019 Classes

MICROSOFT OFFICE SUITE
Intro, Essentials, Novice to Specialist Certifications

The Microsoft Office suite of applications are used universally by corporations, small businesses, in education and at home, by professionals, students and individuals, all who need to navigate and function effectively in a world powered by technology. Knowing Microsoft Word, Excel, PowerPoint and Outlook opens doors and improves your ability to compete in the workforce. Earning Microsoft Office Specialist (MOS) Certifications reflect proven technical skills with an industry valued credential. Each MS application has its own certification exam. Passing a core exam in any, allows you to add MOS to your resume.

ELEVATE YOUR CAREER POTENTIAL AND EARNING POWER


INTRODUCTION TO MICROSOFT OFFICE AND 365

PREREQUISITE: Basic Windows and computer skills needed

This is a beginner level course that will introduce you to the most popular Microsoft Office applications: Outlook, Word, Excel and PowerPoint, as well as the increasingly popular MS 365, the cloud based version of the MS Office package. You will understand the dynamic nature of each of these applications, create calendar entries and meeting invitations, a simple text document, a basic spreadsheet and a simple slide presentation. At the end of this course, you will understand why these applications are used almost universally in the workplace and by students, and be ready to move on to the next level of CCM’s popular MS Office series. Start at the very beginning with this course if you have no prior MS Office experience and progress to a certified MS Office professional. MOS 117

INSTRUCTOR: Patricia Callahan

28751. 2 Sessions: 6 hours, CEU 0.6

Landscape and Horticulture Building, LHT 102

Time: 6:30-9:30 p.m., Wed and Mon, Jan 23 and 28

Cost: $99


OUTLOOK ESSENTIALS

PREREQUISITE: Basic Windows knowledge or Introduction to Microsoft Office and 365

Learn how to send/receive, reply to, forward e-mail messages, attach files, and how to organize items with filters and categories. Manage contacts, use calendar features, create and send appointments, schedule meetings, utilize voting buttons, change message appearance and archive email. MOS 116

*Textbook included.

INSTRUCTOR: Patricia Callahan

28752. 3 Sessions: 9 hours, CEU 0.9

Landscape and Horticulture Building, LHT 102

Time: 6:30-9:30 p.m., Wed and Mon, Jan 30-Feb 6

Cost: $159

WORD


MICROSOFT WORD, NOVICE TO MOS CERTIFIED

PREREQUISITE: Introduction to Microsoft Office and 365, or some familiarity with MS Word

This course is designed to help novice users master essential Word skills or help those who want to “fill in the gaps” in their basic knowledge of Word. Following two dedicated sessions to increase your knowledge and understanding of the most common features of the program, you will be joined by additional students as you work to master new and higher level skills and to prepare for the core MOS Word Certification Exam 77-725. Basics such as enter, edit and format text, margins, tabs, indentations, headers and footers, clip art and bulleted and numbered lists, mail merge, tables, templates, track changes and layout and design options are included. The objectives of the 77-725 Exam: document creation and management; formatting of text, paragraphs and sections; creating tables and lists; creating and managing references and inserting and formatting graphic elements will be covered. MOS 118

This course is bundled with textbooks and an exam voucher to take your MOS Word certification exam at CCM’s state-of-the art Test Center in the Learning Resource Center. The test voucher, a $150 value, includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

*Textbooks and exam voucher are included.

INSTRUCTOR: Patricia Callahan

28753. 8 Sessions: 24 hours, CEU 2.4

Landscape and Horticulture Building, LHT 102

Time: 6:30-9:30 p.m., Mon and Wed, Feb 11-March 6

Cost: $499

MICROSOFT WORD MOS CERTIFIED

PREREQUISITE: Prior MS Word experience. Students needing to learn the basics of Word should enroll in the Novice to MOS Certified (see next listing).

This course will refresh your knowledge of MS Word and may even introduce you to new skills and concepts that are often overlooked or underused in this powerful office tool. Plan to master new and higher level skills and to prepare for the core MOS Word Certification Exam 77-725. A review of important basics such as margins, tabs, indentations, tables, headers and footers, along with focused content like bulleted and numbered lists, mail merge, templates, macros, track changes and layout and design options are included. The objectives of the 77-725 Exam: document creation and management; formatting of text, paragraphs and sections; creating tables and lists; creating and managing references and inserting and formatting graphic elements will be covered. MOS 119

This course is bundled with textbooks and an exam voucher to take your MOS Word certification exam at CCM’s state-of-the art Test Center in the Learning Resource Center. The test voucher, a $150 value, includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

*Textbooks and exam voucher are included.

INSTRUCTOR: Patricia Callahan

28754. 6 Sessions: 18 hours, CEU 1.8

Landscape and Horticulture Building, LHT 102

Time: 6:30-9:30 p.m., Mon and Wed, Feb 18-March 6

Cost: $399

EXCEL


MICROSOFT EXCEL, NOVICE TO MOS CERTIFIED

PREREQUISITE: Introduction to Microsoft Office and 365, or some familiarity with MS Excel

This course is designed to help novice users master essential Excel skills or help those who want to “fill in the gaps” in their basic knowledge of Excel. Following two dedicated sessions to increase your knowledge and understanding of the most common features of the program, you will be joined by additional students as you work to master new and higher level skills and to prepare for the core MOS Excel Certification Exam 77-727. Spreadsheet basics such as add, rename and organize spreadsheets; add and format data; copy and paste data; insert/delete rows and columns will be covered. As the course progresses, you will learn to sort data; create charts, formulas and functions; work with data, pivot tables, filters, macros and much more. The objectives of the 77-727 Exam: create and management worksheets and workbooks; manage data cells and ranges; creating tables; performing operations with formulas and functions and creating charts and objects will be covered. MOS 120

This course is bundled with textbooks and an exam voucher to take your MOS Excel certification exam at CCM’s state-of-the art Test Center in the Learning Resource Center. The test voucher, a $150 value, includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

*Textbooks and exam voucher are included.

INSTRUCTOR: Rreze Zejnullahi

28755.8 Sessions: 24 hours, CEU 2.4

Henderson Hall, HH 113

Time: 9 a.m.-12 p.m., Sat, March 9-May 4 (no class April 20)

Cost: $499

MICROSOFT EXCEL MOS CERTIFIED

PREREQUISITE: Prior MS Excel experience. Students needing to learn the basics of Excel should enroll in the Novice to MOS Certified (see next listing).

This course will refresh your knowledge of MS Excel and may even introduce you to new skills and concepts that are often overlooked or underused in this powerful office tool. Plan to master new and higher level skills and to prepare for the core MOS Excel Certification Exam 77-727. A review of important basics such as add and format data; copy and paste data; insert/delete rows and columns will be covered. As the course progresses, you will sort data; create charts, formulas and functions; work with data, pivot tables, filters, macros and much more. The objectives of the 77-727 Exam: create and manage worksheets and workbooks; manage data cells and ranges; creating tables; performing operations with formulas and functions and creating charts and objects will be covered. MOS 121

This course is bundled with textbooks and an exam voucher to take your MOS Excel certification exam at CCM’s state-of-the art Test Center in the Learning Resource Center. The test voucher, a $150 value, includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

*Textbooks and exam voucher are included.

INSTRUCTOR: Rreze Zejnullahi

28756. 6 Sessions: 18 hours, CEU 1.8

Henderson Hall, HH 113

Time: 9 a.m.-12 p.m., Sat, March 23-May 4
(no class April 20)

Cost: $399

MICROSOFT EXCEL EXPERT LEVEL CERTIFIED 

PREREQUISITE: MOS Excel 77-727 certification or advanced knowledge of Excel

Expert-level Excel users have an advanced understanding of the full Excel environment. Expert level users in the fields of finance, accounting, data analysis, commercial banking, other financial institutions and professionals in data driven fields will want to obtain this certification as a demonstration of your expertise. This course will refresh your knowledge of advanced Excel functions and prepare you for the Expert Level Excel Certification Exam 77-728. Expert level users can create, manage and distribute professional spreadsheets; customize the Excel environment to meet project needs and to enhance productivity; create custom business templates and multiple-axis financial charts, amortization tables and inventory schedules. MOS 122

This course is bundled with textbooks and an exam voucher to take your MOS Excel Expert certification exam at CCM’s state-of-the art Test Center in the Learning Resource Center. The test voucher, a $150 value, includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

*Textbooks and exam voucher are included.

INSTRUCTOR: Rreze Zejnullahi

28757. 2 Sessions: 6 hours, CEU 0.6

Henderson Hall, HH 113

Time: 9 a.m.-12 p.m., Sat, June 8-15

Cost: $249

POWERPOINT


POWERPOINT ESSENTIALS

PREREQUISITE: Basic Windows knowledge or Introduction to Microsoft Office and 365

Learn to create PowerPoint presentations, including slide layout, text and lists, master slides, templates, graphics, charts tables, collaborative presentations, animation, media and how to set up a show. Improve your PowerPoint skills and become more effective at creating slides that tell a story and convey information clearly. MOS 115

*Textbook included.

INSTRUCTOR: Patricia Callahan

28758. 5 Sessions: 15 hours, CEU 1.5

Emeriti Hall, EH 208
Time: 6:30-9:30 p.m., Mon and Wed, May 20-June 5 (no class May 27)
Cost: $299

Even if you do not take one of CCM’s Microsoft Office courses, you can still sit for a Microsoft Office Specialist Certification for Office 2016 at the conveniently located CCM Testing Center in the Learning Resource Center.

  • 77-725: MS Office Word 2016
  • 77-726: MS Office Word 2016 Expert
  • 77-727: MS Office Excel 2016
  • 77-728: MS Office Excel 2016 Expert
  • 77-729: MS Office PowerPoint
  • 77-731: MS Office Outlook

CCM’s examination fee is $150 and includes Gmetrix self-study materials, 1 practice exam, the Certification Exam and 1 exam retake.

For more information, visit www.ccm.edu/testing

WORDPRESS


WORDPRESS FOR BUSINESSES, ENTREPRENEURS, AND BLOGGERS

Students will be required to establish a WordPress account at the first class and should bring a credit card. The annual fee begins at $48; levels available for all budgets. At the end of this course, students will have a fully functional WordPress website.

PREREQUISITE: working knowledge of computers

WordPress is a powerful web design platform that is user-friendly for those with little to no programming experience. In this class, learn the tips and tricks to create a modern website that will allow for flexibility and easy updates, with many popular embedded features that can expand your reach through social media. Learn to add plugins to your site to maximize its performance. WDA 241

INSTRUCTOR: John Hester

28881. 4 Sessions: 12 hours, CEU 1.2

Sheffield Hall, SH 162
Time: 6-9 p.m., Tues, March 5-26

Cost: $199

GOOGLE


GOOGLE SUITE OF APPS

PREREQUISITE: working knowledge of computers and a Google/gmail account

Course information TBD.


GOOGLE FOR EDUCATORS

PREREQUISITE: working knowledge of computers and a Google/gmail account

Chromebooks in the classroom has had a huge impact on the way teachers teach and students learn. This course is designed with educators in mind. Via an organized, structured and professionally developed preparation course, you will be prepared to take the Google Educator Level 1 and Level 2 exams. During the course, students will learn and create practical, reusable content with Gmail and Google Groups, Drive, Sites, Classroom, Search, Calendar, Docs, Sheets Slides, Forms and keep, all the apps necessary for passing the exams.

By mastering these skills, teachers will:

  • Increase student learning and engagement
  • Streamline assessing and sharing student grades
  • Measure teaching impact with data analysis tools
  • Satiate individual needs with Google products
  • Boost educator and student technology literacy

Individuals who achieve certification may publicize their status with a personalized certificate and badge useful for a resume, portfolio, website or anywhere. The certification is valid for 36 months. The Google Educator Level 1 and Level 2 exams registrations and fees are not included in the course. CPC 609

INSTRUCTOR: Susan Wise

88871. 5 Sessions: 15 hours

Location: TBD

Time: TBD

Cost: $249