PC Application Programmer Certificate

Certificate Code: 5847

Program Contacts:
QC Campus
Debbie Collins, 309-796-5316, collinsd@bhc.edu
East Campus
Jodee Werkheiser, 309-854-1821, werkheiserj@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. In addition, students will take courses preparing for the MCDST (Microsoft Certified Desktop Support Technician).

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.

Required courses for this program include: »

BE 145A Information Processing I

Students learn word processing software most commonly found in area offices.
1 credit hour: 1 lecture hour; 0 lab hours per week.

 

BE 145B Information Processing II
Students learn word processing software most commonly found in area offices.
1 credit hour: 1 lecture hour; 0 lab hours per week.

 

BE 145C Information Processing III
Students learn word processing software most commonly found in area offices.
1 credit hour: 1 lecture hour; 0 lab hours per week.

BE 248A Desktop Publishing I
Prerequisites: BE 145 “C” or better or BE 145A, B, and C or instructor consent.

Use of current software to produce a variety of documents incorporating desktop publishing features and principles of layout and design.
1 credit hour: 1 lecture hours; 0 lab hours per week.

 

BE 248B Desktop Publishing II
Prerequisites: BE 145 “C” or better or BE 145A, B and C or instructor consent.

Use of current software to produce a variety of documents incorporating desktop publishing features and principles of layout and design.
1 credit hour: 1 lecture hours; 0 lab hours per week.

BE 248C Desktop Publishing III
Prerequisite: BE 145 “C” or better or BE 145A, B and C or instructor consent.

Use of current software to produce a variety of documents incorporating desktop publishing features and principles of layout and design.
1 credit hour: 1 lecture hours; 0 lab hours per week.

CIP 101 Computer Logic and Design
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.
4 credit hours: 4 lecture hours; 0 lab hours per week.

CIP 104 Intro to Computer Programming
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.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 151 Adv Office Applications w/VBA
Prerequisites: CIP 101 or CIP 104 and CIP 230 or CIP 226 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).
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 167 Scripting for Systems Administration
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.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 185 XML (eXtensible Markup Lang.)
The student will develop XML documents and learn the related technologies. Topics include: creating valid and well-formed XML documents, DTD’s, XML schemas, XML editors (software), XSLT and applications using XML.
1 credit hour: 1 lecture hours; 0 lab hours per week.

CIP 201 Microsoft Project 1
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.
1 credit hour: 1 lecture hours; 0 lab hours per week.

CIP 204 Visual Basic Programming
Prerequisite: CIP 101 or CIP 104 or instructor consent.
This course uses the latest version of the Visual Basic programming language to create GUI-based (Windows) applications and Web applications with ASP.NET, 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.
4 credit hours: 4 lecture hours; 0 lab hours per week.

CIP 205 Advanced Visual Basic
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.
4 credit hours: 4 lecture hours; 0 lab hours per week.

CIP 226 Database Management
Prerequisite: CS 100 or instructor consent.
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.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 227 Database Management II
Prerequisite: CIP 226.
This course provides the student with more advanced database concepts and implementation using Microsoft SQL Server. Topics covered include: advanced SQL, query optimization, transaction management, recovery, SQL Server Administration, triggers, views, stored procedures, indexes and security. Students will design and build databases using SQL Server.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 230 Spreadsheet Analysis
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.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 250 Java Programming Fundamentals
Prerequisites: CIP 104 and CIP 170 or instructor consent.
This course teaches students fundamentals of Java programming for the Web. It focuses on event-driven object oriented programming and includes Java control structures, event handling, I/O and applet development.
3 credit hours: 3 lecture hours; 0 lab hours per week.

CIP 280 Intro to Game Programming
Prerequisites: CIP 204 and 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.
3 credit hours: 3 lecture hours; 0 lab hours per week.

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

COER 112 Microcomputer Operating Systems
This is a course on Microcomputer Operating Systems. Intel-compatible system software will be the focus. There are two basic PC Operating Systems: 1) Microsoft Operating Systems, and 2) DOS. Each of these will be explored independently in a comparative fashion with a primary focus on the usage of the command-line interfaces.
3 credit hours: 2 lecture hours; 2 lab hours per week.

COER 180 Desktop Application Support
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.
3 credit hours: 2 lecture hours; 2 lab hours per week.

NETW 120 Basic Computer Networks
An introductory course in networking for the technical student. Includes basic network hardware, software, troubleshooting, and maintenance.
3 credit hours: 2 lecture hours; 2 lab hours per week.

Course of Study Outline
First Semester Suggested Courses (Credit Hours)
CIP 101 — Computer Logic and Design (4)
CIP 104 — Intro to Computer Programming (3)
CIP 226 — Database Management (3)
CIP 230 — Spreadsheet Analysis (3)
* Technical Elective (3)

Minimester Suggested Courses (Credit Hours)
CIP 201 — Microsoft Project (1)

Second Semester Suggested Courses (Credit Hours)
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: (5 credits needed)

(some courses require a pre-requisite – check course descriptions in catalog)

BE 145 A, B, C — Word (1-3)
BE 248 A, B, C — Desktop Publishing (1-3)
CIP 167 — Scripting for Systems Administration (3)
CIP 185 — XML (eXtensible Markup Lang.) (1)
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 112 — Microcomputer Operating Systems (3)
COER 180 — Desktop Application Support (3)
NETW 120 — Basic Computer Networks (3)


Occupational Profiles

CIP Code:
SOC Code:

Cost of Attendance

Success Rates All Students Full-Time Part-Time
Completion rate at 100%
Completion rate at 150%

Job Placement Rate:

Loans

  • Median loan debt
  • Title IV loan debt
  • Private loan debt – $0
  • Institutional debt – $0