Computer Specialist AAS

Program Contacts:
QC Campus
Debbie Collins, 309-796-5316, collinsd@bhc.edu
Don Mosier, 309-796-5278, mosierd@bhc.edu
East Campus
Jodee Werkheiser, 309-854-1821, werkheiserj@bhc.edu


This degree is offered only at the Quad-Cities Campus.

The Computer Specialist Associate in Applied Science degree is a multi-disciplinary degree designed to produce graduates with the knowledge necessary to work in today’s information technology environment. All students will study a variety of introductory courses consisting of HTML, networking, Windows and Linux operating systems, security, hardware, programming logic and Microsoft Project. With this strong foundation, students can go into depth by selecting a track for specialization. Tracks include Desktop Support Technician, Network Administration, Web Programming, Computer Programming, and Network Security. The degree is designed so that an individual may complete one of the related certificate programs (Desktop Support Technician Certificate, Web Developer Certificate, PC Application Programmer Certificate, Network Technician Certificate, Network Administrator Certificate, and Network Security Certificate), and then complete the Computer Specialist Associate’s degree. Individuals may also enroll directly in the Computer Specialist program without any prior coursework. The two-year course of study culminates in the internship which provides valuable on-the-job experience.

Many of the courses prepare students for industry-related certifications including CompTIA’s A+ and N+ certification, Microsoft’s MCITP (Microsoft Certified IT Professional) and MTS certification, CISCO’s CCNA and CCENT certification, and CIW (Certified Internet Web Professional) Foundations exam.

About the tracks: Desktop support work involves installing, configuring, repairing, and managing computer hardware and software. Network administration work manages the back-office by building and configuring networks, installing and configuring servers and workstations, troubleshooting hardware, network, and related problems including routers and switches. Network security work secures systems and detects security attacks. Programmers design and create complex programs in high-level languages. Languages studied include Visual Basic, SQL, VBA, and Java. Web programmers develop and update Web sites with interactive technologies including HTML, CSS, JavaScript, Flash, ASP.NET and PHP.

Required courses for this program include: »

BE 180 Business Communications
Prerequisite: Students must have one of the following placement tests within given scores: ACT English, 22-36; or ASSET writing, 37-55; or COMPASS writing, 32-99.15
Techniques of effective written communications for business. This will include psychology of communicating with customer service emphasis, focus on international communications, and accuracy and conciseness needed for in-house e-mail.
4 credit hours: 4 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 170 Web Page Development
The student will learn Web site development with the three methods that have been used sine Web design first began: hand-coding HTML using a text editor; building Web pages using a WYSIWYG editor like Dreamweaver; and using the most modern method, a Content Management System that separates design from content while making it easy for non-technical users to update a site. Topics include: design principles, formatting Web pages with cascading style sheets, server-side vs. client-side technologies, testing Web pages with multiple Web browsers, and Web servers. In addition, the student will learn how to stay current on W3C standards for Web page development.
4 credit hours: 4 lecture hours; 0 lab hours per week.

CIP 201 Microsoft Project
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 226 Database Management
Prerequisite: CIP 103 or CS 100 or consent of instructor.
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.

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 116 Microcomputer Hardware
This course is an introduction to microcomputer hardware components, from a technician’s perspective. Content includes motherboard, CPU, memory, storage devices, and I/O devices, etc. Emphasis is on installation and repair, as well as hardware/software interaction. Not an A+ Certification prep course, but provides a foundation for future pursuit of this credential.
3 credit hours: 2 lecture hours; 2 lab hours per week.

COER 125 Seminar
Prerequisite: permission of instructor.
Designed to be taken at the same time as the student’s internship in computer repair, network technician, or microcomputer support. Includes discussion of workplace issues, development of job-seeking strategies, and enhancement of interpersonal skills.
1 credit hour: 1 lecture hour; 0 lab hours per week.

CS 100 Introduction to Computers
Introduction to computer concepts, computer applications, and the impact of computers on society. Applications include problem solving methods, word processing, spreadsheet, database, and presentation graphics software. Basic Algebra or equivalent is recommended.
3 credit hours: 3 lecture hours; 1 lab hour per week.

CS 201 Advanced Applications Software
Prerequisite: MATH 090, 091 or equivalent; CS 100 or equivalent.
Advanced problem solving using word processing, spreadsheet, database, and operating system software. The course includes application development in Visual Basic for Applications.
3 credit hours: 2 lecture hours; 2 lab hours per week.

ENG 101 Composition I
Prerequisite: An ACT English score of 22-36, the appropriate COMPASS score, or successful completion of English 091.
English 101 is designed for students who are competent in the fundamentals of composition. Students will write essays using a variety of expository strategies and will apply standard techniques of documentation when appropriate.
3 credit hours: 3 lecture hours; 0 lab hours per week. IAI: C1 900/C1 900R (Grade of “C” or higher required for this course to be eligible to be included in the IAI General Education Core Curriculum.)

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.

NETW 170 Intro to Information Security
Prerequisite: COER 112 and COER 116 and NETW 120 or NETW 125 with “C” or better, or successful completion of proficiency exam, or permission of instructor.
An introduction to the topics, technologies and terminology associated with network information security. This course is a prerequisite for all other courses in the security track of the Microcomputer Support Specialist degree.
3 credit hours: 3 lecture hours; 0 lab hours per week.

NETW 190 Networking Internship
Prerequisite: NETW 120 with a “C” or better and permission of instructor.
Supervised field program providing work experience directly related to the student’s area of concentration. On-the-job experience is required of all program graduates.
1-3 credit hours: 0 lecture hours; 5-15 lab hours per week.

NETW 250 Web Server Administration
A hands-on course in managing and maintaining an Internet Web server, with emphasis on security. Includes server configuration and customization, directory structure, content and user maintenance, server-side applications, performance monitoring and tuning, and security implementation.
3 credit hours: 2 lecture hours; 2 lab hours per week.

Course of Study Outline
Core Program Requirements (Credit Hours)
CIP 170 — Web Page Development (4)
CIP 201 — Microsoft Project (1)
NETW 120 — Basic Computer Networks (3)
NETW 170 — Intro to Information Security (*3)
COER 116 — Microcomputer Hardware (3)
COER 112 — Microcomputer Operating Systems (3)

Gen Ed Requirements (Credit Hours)
CIP 101 — Computer Logic & Design (4)
CS 100 — Introduction to Computers (3)
ENG 101 — Composition I or (3-4)
BE 180 — Business Communication
General Education Courses (two) (6)

Internships (Credit Hours)
COER 125 — Seminar (1)
NETW 190 — Internship (3)

Minimum total hours required for degree (depends on track selected) (64-69)

*Web Track – take NETW 250 fourth semester