CODING

An increasing number of businesses rely on computer code and individuals who are versed in a range of programming languages.  Coding is not a skill limited to the technology sector.  Individuals with coding skills may find careers in hospitals or manufacturing, as well as high-tech companies. According to the Bureau of Labor Statistics (BLS), programming jobs overall are growing 12% faster than the market average.

The five major job categories requiring coding skills include Information Technology (IT) workers, data analysts, artists and designers, engineers and scientists.  These professionals are able to use various programs to write instructions to a computer as opposed to using established applications. Programming languages including JavaScript and HTML for building websites, statistical programs R and SAS, AutoCAD programs for engineers, and other all-purpose programming languages such as Python, Java, C# and C++ are in demand in today’s job market.

INTRODUCTION TO CODING AND COMPUTER PROGRAMMING

This classroom course will provide an overview of programming methodology for those without prior coding experience, and aims to prepare those interested in any of the language-specific programming courses offered at CCM (R, C#, C++ and Python). Topics covered will include computer science fundamentals (data types, data structures, input/output, functions, sorting/searching, program structure, etc.) and basic algorithms. CPC-621

Instructor: Samuel Jacobs, MEng

28321. 2 sessions: 8 hours, CEU 0.8

Time: 8:30 a.m.-12:30 p.m., Sat, Feb 1-8

Location: Henderson Hall, HH 215

Cost: 229

C++ OBJECT ORIENTED PROGRAMMING

Prerequisite: Introduction to Computer Programming, the C# class, or prior coding experience.

C++ is a sophisticated, efficient and general-purpose programming language based on C. Many of today’s operating systems, system drivers, browsers and games use C++ as the core language. This makes C++ one of the most popular languages today. This course builds on the basic programming concepts learned in C#. You will realize and experience the full power of an object oriented programming language. You will be introduced to the usage of arrays, classes, private members, constructors and destructors. A project will be completed that will reinforce your understanding of these basic programming tools. CPC-613

Instructor: Roberta Principe, MS

28324. 10 sessions: 30 hours, CEU 3.0

Time: 6-9 pm. , Tues, April 7-June 9

Location: Emeriti Hall, EH 229

Cost: $599

INTRODUCTION TO R PROGRAMMING AND DATA SCIENCE

PREREQUISITE: Working knowledge of personal computers.   

This ten-hour course introduces students to R, a free, open source, statistical software program used to analyze large data sets. Students will complete projects analyzing large data sets related to environmental and business issues. The course will cover exploratory data analysis techniques, visualization methods, modeling and ideas in reproducible research. R’s widespread popularity in today’s data driven business world makes R a must-know data analysis tool in almost every field of business: finance, bio science, supply chain, sports, retail, marketing, social media, manufacturing and even journalism. High school statistics teachers will benefit from this course as well, by incorporating technology, an element of the common core curriculum. At the completion of this introductory class, students will be able to produce their own R-based report in their own business or school environment. Enrollment is limited to 20. CPC-603.

INSTRUCTOR: Kelly Fitzpatrick, MA

28871. 5 Sessions: 10 hours, CEU 1.0

Time: 5:30-7:30 p.m., Thurs, Jan 23-Feb 20

Location: Cohen Hall, CH 156

Cost: $499


PYTHON INTRODUCTION

Prerequisite: Introduction to Computer Programming or prior coding experience.

Python is a general-purpose programming language. Its simplicity, robust extensibility and 3rd-party package availability make Python an ideal language to learn for any application. Professional-quality packages are freely-available for scientific computing, networking, web development, databases, image processing, cryptography and dozens of other applications. Additionally, most code written in Python is platform-independent or easily portable, making distribution straightforward as a developer. In this course, students will be introduced to the core language, learn about built-in data types and functions, work with imported modules. Students will directly apply these topics to a series of in-class projects. CPC-622

Each topic will have an associated exercise for a hands-on understanding of the material, and each exercise will build upon previous exercises.  At the end of the course, students will have a complete program generated with Python Code. This program may also be used for job interviews as evidence of proficiency. CPC 607.

INSTRUCTOR: Samuel Jacobs, MEng

28322. 3 Sessions: 9 hours, CEU 0.9

Time: 9 a.m.-12 p.m., Sat, Feb 22-March 7

Location: Cohen Hall, CH 156

Cost: $499

SPECIAL TOPIC IN PYTHON: NUMERICAL COMPUTING

Prerequisite: Prior Python experience, STEM background.

This course is aimed at those with a STEM background looking to lessen their reliance on Excel or MATLAB with the use of high quality, freely available scientific packages in the Python ecosystem. Topics covered will include an introduction to the Spyder IDE and the Python packages SciPy (FFT, Optimization, Image Processing), NumPy (Linear Algebra), and Matplotlib (2D/3D data visualization). CPC-623

Instructor: Samuel Jacobs, MEng

28323. 3 sessions: 9 hours, CEU 0.9

Time: 9 a.m.-12 p.m., Sat, March 21-April 4

Location: Cohen Hall, CH 156

Cost: $499


VISUAL BASIC APPLICATIONS IN EXCEL

PREREQUISITE: Proficient knowledge of MS Excel.

You will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with learning how to record macros and the basics of VB programming. The course will teach you to read, write and debug VB code. You will also learn how to pass lists and floating variables though VB. The course will teach you to use conditional statements, create input and message boxes. At the end of this course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. CPC-624.

Instructor: Kelly Fitzpatrick, MA

28872. 1 Session: 6 hours, CEU 0.6

Time: 9:30 a.m.-4:30 p.m., Fri, Feb 28

Location: Cohen Hall, CH 156

Cost: $299


BUSINESS ANALYTICS WITH EXCEL

The Business Analytics course is designed to teach students how data science is applied in business.  Students will utilize the Analysis ToolPak built into Excel to explore concepts in correlation, regression analysis and hypothesis testing. Students will learn the theory behind these statistical methods as they master the practical application.  Students will explore multivariate analysis and how correlation can help them understand portfolio diversification and design. ‘What If’ analysis will be covered utilizing the Solver and Go Seek features of Excel. CPC-617.

1 Session: 8 hours, CEU 0.8

Next offered Spring 2020

Cost: $299


TABLEAU 

Tableau has advanced the capacity to easily analyze large datasets. Tableau allows users to analyze data using multiple dimensions and creates tables and visualizations ready for the boardroom.

TABLEAU I

Learn the basic fundamentals of Tableau, how data is managed, sorted and filtered.  This project based course will teach students the difference between dimensions and measures, how to create custom analytics, 24 interactive graphs and dashboards.  Start your journey to gain the knowledge required for the Desktop Qualified Associate exam and continue with Tableau II, III and IV. CPC-618.

Textbook included.

88874. 1 Session: 8 hours, CEU 0.8
Cohen Hall, CH 156

Time: 9:30 a.m.-5:30 p.m., Fri, Dec 6

Cost: $499

Coming in Spring 2020 – Tableau II, III and IV

Students will move beyond fundamentals to perform advanced data visualization using Tableau and prepare for the Desktop Qualified Associate Exam. Dates TBD.

JAVASCRIPT

PREREQUISITE: Working knowledge of personal computers.

JavaScript is a dynamic, interpretive object-oriented language, most often used for web pages, but with other useful applications.  Learn to add functionality to web pages in this hands-on course as you master the most common and useful features of the JavaScript language. CPC-616.

Coming in Fall 2020

DATA ANALYTICS CERTIFICATE PROGRAM

The CCM ‘Certificate in Data Analytics’ offered through Workforce Development provides participants with data acumen in the areas of data manipulation, visualization and interpretation. To obtain your certificate, you must take all of the following courses. Classes may be taken in any order, but the recommended sequence is:

  • Visual Basic Applications in Excel
  • Introduction to R Programming and Data Science
  • Business Analytics with Excel
  • Tableau I-IV

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