The Information Technology Program offers an Associate in Applied Science degree and certificates in Information Technology Fundamentals, Computer Programming, Database Administration, Electronic Commerce, Computer Support Specialist, Network Administration, and Web Development. This curriculum is supported by a solid foundation of core courses that focus on problem-solving and communication skills for Information Technology professionals involved in computer network environments. The program provides opportunities for practitioners in a variety of career fields to obtain knowledge and skills that enable them to adapt technology use to specific needs in their field of study. Students entering this program need basic computer skills such as would be obtained through CIS 100 (Introduction to Computers) or equivalent.
The Computer Programming Option/Certificate provides students with an introduction to programming languages with at least one of the languages studied at the intermediate level. Students will have the opportunity to study one language in depth or develop a breadth of knowledge in several languages. Students completing this option are prepared for the entry-level computer programmer positions.
The Database Administration Option/Certificate is intended for students wishing to upgrade or acquire new vocational skills in the fields of database administration, database design, and programming with database management systems. The course of study includes a foundation in business information systems, database theory and design, a procedural programming language, and a database language. A capstone course utilizes a special project, encompassing all of the areas, suitable for job experience and a job portfolio. Upon completion of the option/certificate, the graduate will be qualified to take industry designed and recognized certification examinations. Employment opportunities include entry-level positions to develop, implement, manage and maintain database systems.
The Electronic Commerce Option/Certificate provides training in designing, deploying, and managing an Internet e-commerce site. This option will prepare students for careers as web page designers, web masters, or web site managers of a web-based business. A capstone class in web site implementation will encompass all facets of the program of study, and will provide experience and a job portfolio.
Students entering this certificate program will need to have basic computer skills and basic program logic skills such as would be obtained through CIS 100 (Introduction to Computers), CIS 120 (Program Design and Development) and CIS 130 (Microcomputer Applications) or equivalent.
Associate in Applied Science
Click here to show/hide Associate in Applied Science requirements.
Click here to print Associate in Applied Science requirements
Associate in Applied Science
General Education Core:
ENG 101 Writing I.............................................................................. 3
ENG 102 Writing II............................................................................. 3
MT 150 College Algebra.................................................................... 3
PHY 152 Introduction to Physics AND............................................... 3
PH 162 Introduction to Physics Laboratory II OR............................ 1
PH 171 Applied Physics OR........................................................... (4)
PH 217 Applied Industrial Physics.................................................. (5)
Oral Communications Course....................................................... 3
Social Interaction Course............................................................. 3
Heritage/Humanities Course......................................................... 3
Subtotal 22-23
Technical Core
CIS 120 Program Design and Development....................................... 3
CIS 130 Microcomputer Applications OR.......................................... 3
ET 107 Computer Applications for Technicians............................ (4)
ET 232 Computer Software Maintenance OR.................................... 3
CIS 110 Operating Systems Concepts.............................................. (3)
ET 234 Computer Hardware Maintenance......................................... 3
NIS 160 Networking Core Technologies1 OR..................................... 3
IT 120 Cisco Internetworking I 2................................................... (4)
IT 170 Introduction to Database Design........................................... 3
IT 132 Web Page Development OR................................................. 3
IT 130 Web Site Design and Production........................................ (4)
Beginning Level Programming Language..................................... 3
1 recommended for Microsoft Networking Tracks
2 recommended for Cisco Networking Tracks
Subtotal 24-27
Beginning Level Programming Language Courses:
CIS 143 COBOL Programming.......................................................... 3
IT 147 SQL Programming ............................................................... 3
CIS 148 Visual BASIC I...................................................................... 3
CIS 149 Java Programming I............................................................. 3
CIS 155 C/C++ Programming I.......................................................... 3
CS 115 Introduction to Computer Programming.............................. 3
NIS 150 Perl Programming I*............................................................ 3
NIS 152 Introduction to Javascript*.................................................. 3
* Suggested for Electronic Commerce option
Intermediate Level Programming Language Courses:
CIS 232 Programming for Windows Environment............................. 3
CIS 243 COBOL Applications........................................................... 3
CIS 252 C/C++ Programming II......................................................... 3
CIS 262 C/C++ Programming III........................................................ 3
CIS 248 Visual Basic II: Desktop Applications.................................. 3
CIS 249 Java Programming II............................................................ 3
CIS 250 Java Game Development I.................................................... 4
CS 215 Intro to Program Design, Abstraction, and Problem Solving... 4
Advanced Level Programming Language Courses
CIS 258 Visual Basic III: Distributed Applications.............................. 3
CIS 259 Java Programming III........................................................... 3
CIS 260 Java Game Development II.................................................. 4
Computer Programming Option
CIS 220 Systems Analysis and Design................................................ 3
COE 199 Cooperative Education OR................................................... 3
CIS 280 Internship.......................................................................... (3)
ACC 201 Financial Accounting ........................................................... 3
Programming Languages (must include at least 6 credit hours above the beginning level) 12
Management Course (Choose from courses listed below)................ 3
Subtotal 24
Total 70-74
Management Courses
BA 200 Small Business Management................................................. 3
BA 274 Human Resource Management.............................................. 3
BA 287 Supervisory Management..................................................... 3
BA 288 Personal and Organizational Leadership............................... 3
MFG 256 Production Management...................................................... 3
OST 275 Office Management.............................................................. 3
QMS 101 Introduction to Quality Systems........................................... 3
QMS 201 Customer Service Improvement Skills.................................. 3
Database Administration Option
IT 147 SQL Programming................................................................ 3
IT 270 Database Systems – Implementation & Management........... 3
Intermediate Level Programming Language................................. 3
Select Oracle or Microsoft Track (listed below)......................... 12
Subtotal 21
Total Credits 67-71
Electronic Commerce Option
B&E 100 Introduction to Business and Economics OR......................... 1
BA 160 Introduction to Business.................................................... (3)
BA 282 Principles of Marketing........................................................ 3
ACC 201 Financial Accounting ........................................................... 3
BA/CIS 151 Introduction to Electronic Commerce.................................. 3
IT 132 Web Page Development* OR............................................... 3
IT 130 Web Site Design and Production*...................................... (4)
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-Driven Web Design...................................................... 3
IT 291 E-Commerce Practicum: Site Implementation...................... 3
* Must take either IT 130 or IT 132 whichever course was not taken in the technical core.
Subtotal 22-25
Total 68-75
Network Administration Option
NIS 211 Administering Microsoft Windows Professional: Topic........ 3
NIS 213 Administering Microsoft Windows Server: Topic................. 3
NIS 214 Supporting Windows Network Infrastructure Topic:............. 3
Take one of the following MCSA Track electives.................... 3-6
Technical Electives (listed below)................................................ 6
Subtotal 18-21
Total 64-71
Electives for MCSA Track
NIS 216 Implementing and Administering Microsoft Windows Directory
Services Topic:..................................................................... 3
NIS 246 Microsoft SQL Server System Administration Topic:........... 3
NIS 245 Designing a Secure Windows Network Topic:....................... 3
NIS 262 Microsoft Internet Security and Acceleration Server (ISA)... 3
NIS 264 Implementing and Managing Microsoft Exchange Server..... 3
IT 210 Operating System Support* AND ........................................ 3
IT 215 Application Support *.......................................................... 3
* must be completed together to count as single elective
Web Development and Administration Option
CIS 248 Visual Basic II: Desktop Applications OR............................. 3
CIS 249 Java Programming II......................................................... (3)
NIS 150 Perl Programming I OR........................................................ 3
NIS 152 Introduction to Javascript.................................................. (3)
NIS 275 Internet Servers Administration........................................... 3
IT 130 Web Site Design and Production........................................... 4
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-driven Web Design....................................................... 3
IT 295 Web Development & Administration Practicum:
Site Implementation.......................................................... 3
Technical Elective....................................................................... 3
Subtotal 25
Total 71-75
Technical Electives:
NIS 211 Administering Microsoft Windows Professional: Topic........ 3
NIS 213 Administering Microsoft Windows Server: Topic................. 3
IT 147 SQL Programming................................................................ 3
NIS 246 Microsoft SQL Server System Administration Topic:........... 3
IT 240 XML.................................................................................... 3
IT 236 Active Server Pages.............................................................. 3
IT 134 Macromedia Flash................................................................ 3
IT 270 Database Systems – Implementation & Management........... 3
Beginning Level Programming Language (must be different from technical core. Recommend CIS 148 Visual BASIC I or CIS 149 Java Programming I) 3
Certificates
Click here to show/hide Certificate requirements.
Click here to print Certificate requirements
Information Technology Fundamentals
CIS 120 Program Design and Development....................................... 3
CIS 130 Microcomputer Applications OR.......................................... 3
ET 107 Computer Applications for Technicians............................ (4)
ET 232 Computer Software Maintenance OR.................................... 3
CIS 110 Operating Systems Concepts.............................................. (3)
ET 234 Computer Hardware Maintenance......................................... 3
NIS 160 Networking Core Technologies OR...................................... 3
IT 120 Cisco Internetworking I..................................................... (4)
IT 170 Introduction to Database Design........................................... 3
IT 132 Web Page Development OR................................................. 3
IT 130 Web Site Design and Production........................................ (4)
Beginning Level Programming Language..................................... 3
Total 24-27
A+ Certification
CIS 130 Microcomputer Applications OR.......................................... 3
ET 107 Computer Applications for Technicians ........................... (4)
ET 232 Computer Software Maintenance ......................................... 3
ET 234 Computer Hardware Maintenance......................................... 3
Total 9-10
Computer Programming
CIS 120 Program Design and Development....................................... 3
CIS 220 Systems Analysis and Design................................................ 3
COE 199 Cooperative Education OR................................................... 3
CIS 280 Internship.......................................................................... (3)
ACC 201 Financial Accounting ........................................................... 3
Beginning Level Programming Language..................................... 3
Programming Languages (must include at least 6 credit hours above the
beginning level)......................................................................... 12
Management course (listed in the option).................................... 3
Total 30
Database Administration – Basic
(Prerequisite: Moderate knowledge of industry-standard microcomputer operating systems, application software, computer program design and development techniques, and familiarity with at least one programming language)
Oracle Track
IT 170 Introduction to Database Design........................................... 3
IT 147 SQL Programming................................................................ 3
IT 270 Database Systems – Implementation and Management......... 3
IT 272 Oracle Database Fundamentals I........................................... 3
NIS 213 Administering Microsoft Windows Server OR....................... 3
NIS 230 UNIX Administration........................................................ (3)
Total Credits 15
Database Administration – Enhanced
(Prerequisite: Moderate knowledge of industry-standard microcomputer operating systems, application software, computer program design and development techniques, and familiarity with at least one programming language)
Oracle Track
IT 170 Introduction to Database Design........................................... 3
IT 147 SQL Programming................................................................ 3
IT 270 Database Systems – Implementation and Management......... 3
IT 272 Oracle Database Fundamentals I........................................... 3
IT 274 Oracle Database Fundamentals II.......................................... 3
IT 278 Oracle Performance Tuning................................................. 3
NIS 213 Administering Microsoft Windows Server OR....................... 3
NIS 230 UNIX Administration........................................................ (3)
Total Credits 21
Microsoft Track
IT 170 Introduction to Database Design........................................... 3
IT 147 SQL Programming................................................................ 3
IT 270 Database Systems – Implementation and Management......... 3
NIS 246 Microsoft SQL Server System Administration Topic:........... 3
NIS 247 Microsoft SQL Server Implementation................................. 3
NIS 248 Microsoft SQL Server Data Warehousing............................. 3
NIS 213 Administering Microsoft Windows Server: Topic................. 3
Total 21
Electronic Commerce
B & E 100 Introduction to Business and Economics OR......................... 1
BA 160 Introduction to Business.................................................... (3)
BA 282 Principles of Marketing........................................................ 3
ACC 201 Financial Accounting ........................................................... 3
BA/CIS 151 Introduction to Electronic Commerce.................................. 3
IT 130 Web Site Design and Production........................................... 4
IT 132 Web Page Development ...................................................... 3
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-Driven Web Design...................................................... 3
IT 291 E-Commerce Practicum: Site Implementation...................... 3
Total 26-28
Web/Database Administration
(Prerequisite: Fundamental knowledge of industry-standard microcomputer operating systems, applications software, computer program design and development techniques, and at least one programming language)
Microsoft Track
IT 170 Introduction to Database Design........................................... 3
IT 147 SQL Programming................................................................ 3
NIS 246 Microsoft SQL Server System Administration Topic:........... 3
BA/CIS 151 Introduction to Electronic Commerce.................................. 3
IT 132 Web Page Development OR................................................. 3
IT 130 Web Site Design and Production........................................ (4)
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-Driven Web Design...................................................... 3
IT 291 E-Commerce Practicum: Site Implementation...................... 3
Programming Course (scripting language preferred)..................... 3
Total 27-28
Electronic Commerce
B & E 100 Introduction to Business and Economics OR......................... 1
BA 160 Introduction to Business.................................................... (3)
BA 282 Principles of Marketing........................................................ 3
ACC 201 Financial Accounting ........................................................... 3
BA/CIS 151 Introduction to Electronic Commerce.................................. 3
IT 130 Web Site Design and Production........................................... 4
IT 132 Web Page Development ...................................................... 3
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-Driven Web Design...................................................... 3
IT 291 E-Commerce Practicum: Site Implementation...................... 3
Total 26-28
Computer Support Specialist
CIS 130 Microcomputer Applications OR.......................................... 3
ET 107 Computer Applications for Technicians OR...................... (4)
ET 232 Computer Software Maintenance OR.................................... 3
CIS 110 Operating Systems Concepts.............................................. (3)
ET 234 Computer Hardware Maintenance......................................... 3
CIS 230 Advanced Microcomputer Applications OR.......................... 3
OST 225 Introduction to Desktop Publishing................................... (3)
IT 237 Help Desk Service Skills and Tools....................................... 3
IT 210 Operating System Support.................................................... 3
IT 215 Application Support............................................................. 3
CIS 280 Internship OR...................................................................... 3
COE 199 Cooperative Education...................................................... (3)
Computer Support Elective (listed in the option)......................... 6
Total 30-31
Cisco Networking Basic
IT 120 Cisco Internetworking I........................................................ 4
IT 122 Cisco Internetworking II...................................................... 4
IT 220 Cisco Internetworking III..................................................... 4
IT 222 Cisco Internetworking IV..................................................... 4
Total 16
Cisco Networking Enhanced
IT 120 Cisco Internetworking I........................................................ 4
IT 122 Cisco Internetworking II...................................................... 4
IT 220 Cisco Internetworking III..................................................... 4
IT 222 Cisco Internetworking IV..................................................... 4
NIS 213 Administering Microsoft Windows Server: Topic OR........... 3
NIS 230 UNIX Administration........................................................ (3)
Electives (listed in the option)..................................................... 6
Total 25
Web Administrator
NIS 160 Networking Core Technologies............................................ 3
NIS 275 Internet Servers Administration........................................... 3
ET 232 Computer Software Maintenance OR.................................... 3
CIS 110 Operating Systems Concepts.............................................. (3)
ET 234 Computer Hardware Maintenance......................................... 3
IT 132 Web Page Development....................................................... 3
NIS 150 Perl Programming I OR........................................................ 3
NIS 152 Introduction to Javascript.................................................. (3)
Electives (listed in the option)..................................................... 6
Total 24
Web Site Developer
CIS 120 Program Design and Development....................................... 3
IT 130 Web Site Design and Production........................................... 4
IT 132 Web Page Development....................................................... 3
IT 170 Introduction to Database Design........................................... 3
IT 230 Advanced Web Page Development....................................... 3
IT 235 Data-Driven Web Design...................................................... 3
Programming Languages.............................................................. 9
Electives (listed in the option)..................................................... 6
Total 3
The rapid spread of computers and information technology has fueled explosive growth in demand for qualified workers to design, develop, manage and maintain hardware and software systems. Network administrators design, install and support LAN, WAN, network segment, Internet and intranet systems. They maintain network hardware and software, analyze problems, and monitor the network to ensure its availability to users. Administrators also may plan, coordinate, and implement network security measures and implement organizational information security. Web developers are responsible for day-to-day site design and creation. The proliferation of computer specialty occupations reflects the growing emphasis on client-server applications, the continued growth of the Internet and related applications and the demand for more end-user support.
Training in Information Technology can lead to such positions as:
Network Administrator Data Warehouse Specialist
Web Developer Database Administrator
Web Administrator Programming Analyst
Job growth for IT specialists is expected to increase much faster than the average for all occupations through 2014, as organizations continue to adopt increasingly sophisticated technologies. Job growth will continue to be driven by expansion of the computer system design and related services industry, which is expected to remain one of the fastest growing industries in the country. In Northern Kentucky, the job outlook is favorable due to joint industry and education efforts to increase the pool of qualified workers as a means to attract employers. Gateway is part of this effort
Look up the median annual base salary In Northern Kentucky for occupations related to this program at
www.Salary.comCurriculum in the KCTCS system is constantly being reviewed, improved and updated to ensure quality and relevance. Exact course requirements will be provided by a program advisor at an advising session or upon enrollment. Courses listed in this document are representative, but not binding on Gateway College.
