COMPUTER TRAINING

Fall 2019 Classes

MICROSOFT OFFICE SUITE

Microsoft Office 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.


INTRODUCTION TO MICROSOFT OFFICE AND 365

PREREQUISITE: Basic Windows knowledge and computer skills.

This beginner-level course is an introduction to the most popular Microsoft Office applications: Outlook, Word, Excel and PowerPoint, as well as MS 365, the cloud-based version of the MS Office package used almost universally in the workplace. Learn to create calendar entries and meeting invitations, a simple text document, a basic spreadsheet and a simple slide presentation. Students with no prior MS Office experience should start with this course, and later progress to a certified MS Office professional with follow-up courses. MOS-117.

INSTRUCTOR: Patricia Callahan

88751. 2 Sessions: 6 hours, CEU 0.6

Cohen Hall, CH 156

Time: 6-9 p.m., Tues and Thurs, Sept 10-12

Cost: $119


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. Also, learn to use the calendar feature, manage contacts, create and send appointments, schedule meetings, utilize voting buttons, change message appearance and archive email. MOS-116.

Textbook included.

INSTRUCTOR: Patricia Callahan

88756. 3 Sessions: 9 hours, CEU 0.9

Cohen Hall, CH 156

Time: 6-9 p.m., Tues, Sept 24-Oct 8

Cost: $159

BACK TO TOP

WORD


MICROSOFT WORD, NOVICE TO MOS CERTIFIED

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

Novice users will master essential Word skills or “fill in the gaps” in their basic knowledge of Word. Following two dedicated sessions to increase knowledge of the most common features of the program, novice students will join intermediate students in MICROSOFT WORD – MOS CERTIFICATION (see class 88755 below) as they work to master new and higher-level skills and to prepare for the core MOS Word Certification Exam 77-725. Included: 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. MOS-118.

*Textbooks and exam voucher are included.

INSTRUCTOR: CCM Staff

88754. 6 Sessions: 24 hours, CEU 2.4

Cohen Hall, CH 156

Time: 9 a.m.-1:30 p.m., Sat, Sept 21-Oct 26

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’ class below (88754), and then continue on with this course.

This course provides a refresher of MS Word, including skills and concepts that are often overlooked or underused in this powerful office tool. Students learn higher-level skills and 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 covered: document creation and management, formatting of text, paragraphs and sections, creating tables and lists, creating and managing references and inserting and formatting graphic elements. This course is bundled with textbooks and an exam voucher to take the MOS Word certification exam at CCM’s state-of-the art Testing Center in the Learning Resource Center. The test voucher, a $150 value, includes a test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake. MOS-119.

*Textbooks and exam voucher are included.

INSTRUCTOR: CCM Staff

88755. 4 Sessions: 18 hours, CEU 1.8

Cohen Hall, CH 156

Time: 9 a.m.-1:30 p.m., Sat, Oct 5-26

Cost: $399

BACK TO TOP

EXCEL


MICROSOFT EXCEL, NOVICE TO MOS CERTIFIED

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

This course covers essential Excel skills and helps those who want to “fill in the gaps” in their basic knowledge of Excel. Following two dedicated sessions to increase knowledge of the most common features of the program, novice students join the intermediate students in MICROSOFT EXCEL – MOS CERTIFICATION (see class, 88753 below). 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. MOS-120.

*Textbooks and exam voucher are included.

INSTRUCTOR: Rreze Zejnullahi-Berisha

88752. 7 Sessions: 24 hours, CEU 2.4

Cohen Hall, CH 156

Time: 9 a.m.-12:30 p.m., Sat, Nov 2-Dec 21 (no class Nov 30)

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 class’ above (88752) and then continue with this course.

This course provides a refresher of MS Excel, including skills and concepts that are often overlooked or underused in this powerful office tool. Students learn higher-level skills and prepare for the core MOS Excel Certification Exam 77-727. This class covers important basics such as add and format data, copy and paste data, insert/delete rows and columns. 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 covered: create and manage worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions and create charts and objects. This course is bundled with textbooks and an exam voucher to take the MOS Excel certification exam at CCM’s state-of-the art Testing Center in the Learning Resource Center. The test voucher, a $150 value, includes a test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake. MOS-121.

*Textbooks and exam voucher are included.

INSTRUCTOR: Rreze Zejnullahi-Berisha

88753. 5 Sessions: 18 hours, CEU 1.8

Cohen Hall, CH 156

Time: 9 a.m.-12:30 p.m., Sat, Nov 16-Dec 21 (no class Nov 30)

Cost: $399

BACK TO TOP

 EXCEL ADVANCED

PREREQUISITE: Intermediate Excel skills.

Many businesses require individuals to possess advanced Excel skills. In this course, learn how to use What If Analysis tools such as Scenarios and Solver. Record and run macros, create advanced charts and use complex functions. MOS-126.

INSTRUCTOR:  Emily O’Brien

88758. 1 Session: 8 hours, CEU 0.8

Henderson Hall, HH 114

Time: 9 a.m.-5 p.m., Tues, Nov 12

Cost: $199

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-125.

Textbook included.

INSTRUCTOR: Patricia Callahan

88757. 6 Sessions: 18 hours, CEU 1.8

Cohen Hall, CH 156

Time: 6-9 p.m., Tues and Thurs, Nov 5-21

Cost: $359

BACK TO TOP

Even if you do not take one of CCM’s Microsoft Office courses, you can still sit for a Microsoft Office Specialist Certification 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 modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

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

WEB AND DESIGN AND DEVELOPMENT


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

88881. 5 Sessions: 15 hours, CEU 1.5

Henderson Hall, HH 114
Time: 6-9 p.m., Tues, Oct 1-29

Cost: $299

BACK TO TOP


CERTIFICATE IN WEB DESIGN AND DEVELOPMENT

PREREQUISITES: Competent computer skills, working knowledge of Windows.

Web Design and Development Certification enables you to add digital expertise to your career as a digital web designer or web marketing / business specialist. Learn to develop and maintain websites using the tools used by web designers. Create digital content and digital media and employ technologies common to all websites. Learn CSS skills needed to format text, incorporate graphics and multimedia, create special effects, and create interactive forms using the most current web styling techniques. Create web pages with images, lists, tables, events, rollover images, slide presentations, FAQs, banners and more. Offer creative design and maintenance skills to your clients, employer, or to your personal website with complete confidence.

This class includes Web Design Using HTML5 & CSS3, JavaScript, jQuery and Adobe Dreamweaver, the production tool that simplifies the creation and maintenance of websites. You will use the complete set of tools to design and control websites. At the end of this course, you will have the knowledge and skills to develop and design professional, high-quality websites from start to finish.  WDA 242.

Certificate:  Upon completion of the course, the Certificate in Web Development & Design may be awarded upon request.

*Textbook required; see below. Search WDA.

INSTRUCTOR: Ciro Petti

88880. 6 Sessions: 42 hours, CEU 4.2

Time: 8:30 a.m.-4:30 p.m.

Henderson Hall, HH 113, Fri, Oct 18, Nov 1, Nov 8

Learning Resource Center, LRC 216, Fri, Nov 22, Dec 6, Dec 20

Cost: $799

GOOGLE


GOOGLE FOR EDUCATORS

GOOGLE EDUCATOR EXAM PREP COURSE

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 1 and Google Educator 2 certification 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 applications necessary for passing the exams.

By mastering these skills, you 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 their personalized certificate and badge on their resume, portfolio, website or anywhere. The certification is valid for 36 months. The Google Educator Level 1 & Level 2 exam registrations and fees are not included in the course. CPC-609.

INSTRUCTOR: Susan Wise

88522. 5 Sessions: 15 hours
Emeriti Hall, EH 211

Time: 9 a.m.-12 p.m. Sat, Sept 28-Oct 26

Cost: $299

BACK TO TOP

*Textbook required; go to https://bookstore.ccm.edu/college and search for your course number.

Questions about Computer Training?  wfd@ccm.edu or 973-328-5187