PC Application Programmer Certificate

Last updated 5/30/2014

Certificate Code: 5847

Program Contacts:
QC Campus
Debbie Collins, 309-796-5316, collinsd@bhc.edu


This certificate is offered at the Quad-Cities Campus.

This program is a one-year certificate that is ideal for those individuals with no previous programming experience who wish to enter this exciting and demanding career field. Course offerings are designed to give the fundamentals of programming through the creation of programs written in high-level programming languages. Black Hawk College’s PC Application Programmer Certificate provides students with the ability to develop, test, implement, and document customized desktop applications. Students will create object-oriented and event-driven programs using the Visual Basic programming language and will create customized Word, Excel, and Access applications using VBA.

Students starting this program and wishing to continue their education can do so with the Computer Specialist – Programming Track AAS.

Graduates of the program will find employment in PC programming in a business environment. The student will be prepared for an entry-level programming position.

PC Application Programmer Certificate
Certificate Code: 5847
Course of Study Outline – Suggested Courses (Credit Hours)
First Semester
CIP 101 — Computer Logic and Design (4)
CIP 104 — Intro to Computer Programming (3)
CIP 126 — Microsoft Access - fall only (3)
CIP 130 — Microsoft Excel (3)
* Technical Elective (3)

Minimester
CIP 201 — Microsoft Project (1)

Second Semester
CIP 204 — Visual Basic Programming (4)
CIP 227 — Database Management II - spring only (3)
CIP 151 — Adv. Office Applications w/VBA - spring only (3)
* Technical Elective (3)

Minimum total hours required for certificate (33)

* Suggested Technical Electives
(some courses require a pre-requisite – check course descriptions in catalog)

CIP 167 — Scripting for Systems Administration (3)
CIP 190 — Microsoft Sharepoint (3)
CIP 205 — Advanced Visual Basic - recommended (4)
CIP 250 — Java Programing Fundamentals (3)
CIP 280 — Intro to Game Programming (3)
CIP 299 — Independent Study (1-3)
COER 180 — Desktop Application Support (3)

Courses for this program include: »

CIP 101 Computer Logic and Design
4 cr. hrs.;
4 lecture hours; 0 lab hours per week.
An introduction to problem solving and logic needed for working with computer systems. Students will learn to analyze problems and apply the three basic programming structures – sequence, decision, and repetition – and top-down design to develop a solution. Students will also learn number systems, logic, truth tables, Boolean logic, base 2 and base 16 representations. Students will learn the tools used for problem solving such as structure charts, flowcharts, pseudo code, decision tables, and UML. Other topics covered include the concept of a computer system and programming methods.

CIP 104 Intro to Computer Programming
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisite: CIP 101 or concurrent enrollment in CIP 101 recommended.

This course teaches the student the use of key structured programming statements and the use of a programming language in writing microcomputer application programs. Proper programming design, structure, and logic are emphasized.

CIP 126 Microsoft Access
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Analysis of procedures, personnel, and hardware necessary in electronic database processing. Topics covered include review of design, creation, and maintenance of databases including a study of tables and data validation, relationships, queries, forms, reports, macros, SQL, and normalization of tables.

CIP 130 Microsoft Excel
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Spreadsheet analysis is designed for both the novice and experienced user of spreadsheets. Students learn a systematic procedure for formulating and solving business problems using current spreadsheet software.

CIP 151 Adv Office Applications w/VBA
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisites: CIP 101 or CIP 104 and CIP 130 or CIP 126 or CS 100 or ENGT 105 or instructor consent.

This is an advanced course in Microsoft Office applications that prepares students for Microsoft Certified Application Specialist (MCAS) certification exam in Word, Excel, and Access. Student will learn to automate Microsoft Office applications using VBA (Visual Basic for Applications).

CIP 167 Scripting for Systems Administration
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisites: COER 112 or instructor consent.

The student will learn techniques for creating customized scripts in both the Linux and Windows environment. This course provides students with the skills to read, write, maintain, and debug Linux shell scripting and Windows scripting for Systems Administration.

CIP 190 Microsoft SharePoint
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
This course will prepare students for the Microsoft Office Specialist certification exam in SharePoint. Topics include creating and formatting content, managing SharePoint sites, using SharePoint for collaboration, searches, integration with Microsoft Office application.

CIP 201 Microsoft Project
1 cr. hr.;
1 lecture hours; 0 lab hours per week.
Prerequisite: Working knowledge of Microsoft Windows OS.
Develop an understanding of and ability to use Microsoft project in managing projects. Case studies will be Information Technology focused projects.

CIP 204 Visual Basic Programming
4 cr. hrs.;
4 lecture hours; 0 lab hours per week.
Prerequisite: CIP 104 or instructor consent.
This course uses the latest version of the Visual Basic programming language to create GUI-based (Windows) applications applying effective development strategies based on object-oriented programming. Topics include: controls, methods, events, array processing, classes, text file processing, graphics and multimedia, working with multiple forms, creating a setup program, and defensive programming with error trapping.

CIP 205 Advanced Visual Basic
4 cr. hrs.;
4 lecture hours; 0 lab hours per week.
Prerequisite: CIP 204.
This course provides the student with more advanced programming techniques using the latest version of Visual Basic. Topics covered: data controls, user-created controls, ADO.NET, multi-tier applications, classes, and MDI. Windows applications, console applications, and web applications will be developed.

CIP 227 Database Management II
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
This course provides the student with database concepts and implementation using Microsoft SQL Server. Topics covered include: data modeling, normalization, SQL, transaction management, recovery, SQL Server Administration, triggers, views, indexes and security. Students will design and build databases using SQL Server.

CIP 250 Java Programming Fundamentals
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisites: CIP 104 or instructor consent.
This course is designed to teach the student the fundamentals of the Java programming Language and Java programming for the Web. Students will create Java programs, containing fundamental control structures, event handling, objects, I/O and applet development.

CIP 280 Intro to Game Programming
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisites: CIP 204 or CS 121 or instructor consent.
Students will learn introductory game programming concepts using an object-oriented approach VB or C# programming language and DirectX. Topics include: understanding game loops, mouse and keyboard input, sprites, animation, object behaviors, sound scrolling, collision detection, transformations and events. The student will develop several real-time, interactive gaming projects.

CIP 299 Independent Study
.5-3 cr. hrs.;
0.5-3 hours lecture; 0 lab hours per week.
Prerequisite: Department Chair or Lead Instructor consent.
Independent study or group study designed to fit the needs of the students.

COER 180 Desktop Application Support
3 cr. hr.;
2 lecture hours; 2 lab hours per week.
Prerequisites: CS 100 and NETW 120 “C” or better, or instructor consent.
A course on supporting, configuring and troubleshooting common desktop PC application programs, providing hands-on as well as classroom experience. Content covers Microsoft Office, Internet Explorer, Outlook, etc., in a networked office environment. COER 180 covers topics included in the Microsoft Certified Desktop Support Technician exam or similar certification. Students should be familiar with current Microsoft operating system (XP, Vista, Etc.), basic network operation, and desktop applications from a user standpoint..


Gainful Employment

Gainful employment is one important measure that students and parents should pay attention to as they examine colleges and programs. All non-degree programs must be designed to lead to gainful employment in a recognized occupation in order to be deemed eligible for federal student aid. These programs are generally less than 2 years in length and result in a certificate.

PC Application Programmer Certificate