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.
Fall 2019 Classes
PROGRAMMING LANGUAGES
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
88872. 5 Sessions: 10 hours, CEU 1.0
Cohen Hall, CH 156
Time: 5:30-7:30 p.m. Thurs, Sept 26-Oct 24
Cost: $499
C# – INTRO TO PROGRAMMING CONCEPTS
PREREQUISITE: Working knowledge of personal computers.
C# is a simple, modern, general-purpose, object-oriented programming language, borrowing key concepts from several other languages. This class is an introduction to programming concepts such as variable and argument usage, decision structures, and loops. CPC-612.
*Textbook required; see below. Search CPC.
INSTRUCTOR: Roberta Principe
88760. 10 Sessions: 30 hours, CEU 3.0
Henderson Hall, HH 114
Time: 6-9 p.m., Wed, Oct 2-Dec 11 (no class Nov 27)
Cost: $749
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.
INSTRUCTOR: CCM Staff
88761. 5 Sessions: 10 hours, CEU 1.0
Time: TBD
Cost: $499
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. Most code written in Python is platform-independent or easily-portable, making distribution straightforward. Students will be introduced to the core language, learn about built-in data types and functions, work with imported modules and explore graphical user interface (GUI) development in Python.
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: CCM Staff
89762. 5 Sessions: 10 hours, CEU 1.0
Time: TBD
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-608.
INSTRUCTOR: Kelly Fitzpatrick
88871. 1 Session: 8 hours, CEU 0.8
Cohen Hall, CH 156
Time: 9:30 a.m.-5:30 p.m., Fri, Nov 22
Cost: $299
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.
88873. 1 Session: 8 hours, CEU 0.8
Cohen Hall, CH 156
Time: 9:30 a.m.-5:30 p.m., Fri, Sept 20
Cost: $299
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. 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
TABLEAU II – Offered Spring 2020
This course picks up where Tableau I finishes. Students will move beyond fundamentals to perform advanced data visualization using Tableau and prepare for the Desktop Qualified Associate Exam. CPC-619.
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 five 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
- Tableau II
*Textbook required; go to https://bookstore.ccm.edu/college and search for your course number.