Computer Information Technology

Computer Information Technology Associate of Applied Science Degree
Network Administrator Track
Software Developer Track
Web Developer Track
MIS/Project Management Track
Game Developer Track

Cisco Certified Network Administrator (CCNA) Discovery Certificate
Computer Literacy Certificate
Database Specialist Certificate
Management Information Systems Certificate
Information Security Certificate
Network Administrator Certificate
Software Developer Certificate
System Z Certificate
Vocational Education Transfer Options with The Ohio State University

 

The Computer Information Technology curriculum provides graduates with a foundation of logic, programming, operating systems, applications, systems analysis, and networking through a core set of courses. Learners may choose to specialize in Game Developer, Network Administrator, Software Developer, or Web Developer. CIT offers a number of industry subject-specific certificates in database, networking, hardware/software, and applications.

Upon completion of the associate degree in Computer Information Technology, Game  Developer Track, the graduate will be able to:

• Demonstrate an understanding of the history, current industry and occupations that constitute the video game industry.
• Develop a broad understanding of the components of a successful video game by working collaboratively with students in the design area.
• Apply creative thinking and problem solving skills through the completion of a collaborative major capstone project.
• Understand the roles and responsibilities of team members and their collaboration in all phases of design, development and implementation.
• Demonstrate appropriate software and programming skills that directly support video game development processes.
• Be able to work as part of a larger technical/design team to complete tasks on time and on budget.
• Possess the necessary depth of understanding of complex principles and details and know how to apply these fundamentals and details by undertaking open-ended technical and creative projects.
• Understand the fundamentals of game development for both Windows and specific consoles such as Xbox.
• Develop a comprehensive professional portfolio to be used in pursuing jobs and/or internship opportunities.

Upon completion of the associate degree in Computer Information Technology, MIS/Project Management Track, the graduate will be able to:

• Participate in collaborative projects utilizing the Systems Development Life Cycle (SDLC).
• Determine project requirements of a computer Network System.
• Create documentation using PC-based applications software.
• Define project goals clearly.
• Design and produce a UML requirement model.
• Implement a UML design in IT Project.
• Determine task dependencies and schedules.
• Assign and optimize resources.
• Produce the implementation plan.
• Manage and respond to change.
• Measure and present results effectively.
• Apply practical aspects learned in the classroom by managing or assisting in managing IT projects.

Upon completion of the associate degree in Computer Information Technology, Network Administrator Track, the graduate will be able to:

• Participate in collaborative projects utilizing the Systems Development Life Cycle (SDLC).
• Determine project requirements of a computer network system.
• Create project documentation using PC-based applications software.
• Install a variety of server configurations using current network software and protocols.
• Apply workstation configurations using a variety of operating systems commands.
• Integrate project requirements utilizing current database technology.
• Complete a series of exercises to prepare for a popular vendor certification program.

Upon completion of the associate degree in Computer Information Technology, Software Developer Track, the graduate will be able to:

• Determine project requirements.
• Design a targeted information technology.
• Develop applications using programming languages
• Identify networking concepts.
• Prepare project documentation.
• Participate in collaborative projects utilizing the Systems Development Life Cycle (SDLC).
• Determine task dependencies and schedules.
• Assign and optimize resources.
• Produce the implementation plan.
• Manage and respond to change.
• Measure and present results effectively.
• Apply practical aspects learned in the classroom by managing or assisting in managing IT projects.

Upon completion of the associate degree in Computer Information Technology, Web Developer Track, the graduate will be able to:

• Participate in collaborative projects utilizing the Systems Development Life Cycle (SDLC). 
• Determine project requirements.
• Create project documentation using PC-based applications software.
• Develop applications using Web programming languages.
• Create a multiple page, multiple presentation Web site.
• Integrate project requirements for an e-commerce Web site using current database and networking technology.
• Complete a series of exercises to prepare for a popular vendor certification program.  
• Apply operating systems fundamentals for effective disk management.

The Cisco Certified Network Administrator (CCNA) Discovery Certificate is a curriculum that provides foundational networking knowledge, practical experience, and soft-skills development to prepare students for entry-level careers in IT and networking. The curriculum focuses on networking for simple home or small office networks to complex enterprise networks. Students are introduced to advanced technologies such as voice, video, wireless and security and gain hands-on experience with switches, routers, cables and other networking technologies. The Cisco Discovery Certificate curriculum prepares students for two different Cisco certification exams, Cisco Certified Entry Network Technician (CCENT), and Cisco Certified Network Associate (CCNA).

In working toward the Computer Literacy Certificate, the student will learn the fundamental components and terminology of personal computer hardware and software basic concepts. This certificate is designed for beginning computer users to develop computer literacy skills. Upon completion of the Computer Literacy Certificate, the student will be able to:

• Use the Windows operating system to manage files and folders, including creating, renaming, copying, deleting, and moving.
• Demonstrate proficiency within the Blackboard environment.
• Navigate and explore the Internet and the World Wide Web utilizing Microsoft Internet Explorer.
• Utilize the Internet as an effective research tool.
• Describe the basic elements and terminology of the Windows operating system.
• Create and edit Word documents including a research paper, a resume, and a business letter.
• Create and format an Excel worksheet with embedded charts, formulas, and functions.
• Perform a What-if Analysis in Excel.
• Create and use an Access database including tables, queries, and reports.
• Create a slide show in PowerPoint.
• Integrate Office 2003 Applications and the WWW.

In addition to many of the Computer Information Technology competencies, a graduate with a Certificate in Database Specialist will be able to:

• Prepare a systems design utilizing a database management system.
• Design and implement an Oracle and Access database.
• Perform basic administration functions of a database management system.
• Understand data warehousing systems.
• Use the Visual Basic.NET language to interface with a database management system.

In addition to many of the Computer Information Technology competencies, a graduate with an Information Security Certificate will be able to:

• Describe and analyze security threats.
• Protect and organization’s system and data.
• Design disaster recovery strategies for the enterprise.
• Design and implement computer forensics strategies.
• Assess network vulnerabilities.
• Recognize and respond to security threats.
• Design and develop security audits for an organization.
• Understand the ethical issues related to network security.
• Design and implement wireless networks.
• Work with VPNs and firewalls.
• Protect Internet connections and intranets as well as critical data from attacks.
• Learn how to carry out and implement secure communications across unsecured networks.

In addition to many of the Computer Information Technology competencies, a graduate with a Management Information Systems (MIS) Certificate will be able to: 

• Define project goals clearly 
• Design & produce a UML requirement model
• Implement a UML design in IT Project 
• Determine task dependencies and schedules
• Assign and optimize resources
• Produce the implementation plan
• Manage and respond to change
• Measure and present results effectively
• Apply practical aspects learned in the classroom by managing or assisting in managing IT projects

In addition to many fot he Computer Information Technology competencies, a graduate with a Network Administrator Certificate will be able to:

• Describe the various types of distributed processing systems and operating systems.
•  Design, create, and operate a distributed DBMS.
• Use at least one major LAN operating system.
• Complete an industry standard network system examination.
•  Design, create, and implement a distributed processing system to support the information processing requirements for a large information management organization to include installing a DBMS.

In addition to many of the Computer Information Technology competencies, a graduate with a Software Developer Certificate will be able to:

• Demonstrate techniques of object analysis and object design.
•  Design and code programs in C++ and Visual Basic.NET.
• Debug a C# or Visual Basic.NET program.
•  Develop Web front-end applications.
•  Utilize a database for a Web application.

The System Z Certificate was developed to address industry’s continuing need for skilled professionals with mainframe skills. This certificate was designed by area companies and IBM Corporation, which will provide access to hardware/software, course materials/speaker notes, student textbooks, etc. The System Z Certificate is a four-course sequence focused on the basics of enterprise networking, and it is designed for individuals with significant IT working experience or for current students with instructor’s permission.

Specific Certificate Admissions Information

Certain certificate programs have additional requirements for admission.

Database Specialist Certificate
Complete MATH 102 and faculty advisor approval

Information Security Certificate
CIT 151 Networking 1

Network Administrator Certificate
Complete CIT 151 Networking 1

Software Developer Certificate
MATH 104 Intermediate Algebra
Work experience approved by the Department Chair

Software/Hardware Requirements

Students taking courses in this curriculum may need to own or have access to hardware or software to pursue this degree. This is particularly important for students who are enrolled in distance learning-based sections of a particular course. Check with the program advisor to discuss specific course needs and options.
Note: Some courses may require prerequisites; please ensure to fulfill required prerequisites or meet with your program advisor to discuss.

Computer Information Technology Associate Degree, Game Developer Track

COURSE		CR
Quarter 1
ENGL 101	Beginning Composition	3
IMMT 115	Survey of Digital Gaming Industry	3
MATH 148	College Algebra	5
HUM XXXHUM 111, 112, 113, 151, 152 or 224	5
CIT 103	Computer Concepts and Logic	3
TOTAL CREDIT HOURS		19
Quarter 2
IMMT 188	Introduction to 3D Game Production	4
MATH 150	Pre-Calculus	5
IMMT 236	3D Modeling	4
CIT 121	PC Operating Systems	3
CIT 120	Foundations of Game Programming 1	4
TOTAL CREDIT HOURS		20
Quarter 3
MATH 151	Calculus and Analytic Geometry I	5
CIT 167	C++ Programming	4
CIT 127	Structured Programming	4
CIT 128	Concepts of 3D Graphics	4
ENGL 102	Essay and Research	3
TOTAL CREDIT HOURS		20
Quarter 4
COMM 207	Writing for the Web	3
CIT 206	Foundations of Game Programming 2	4
CIT 227	Data Structures and Algorithms	4
CIT 228	Computer Graphics 1	4
CIT 245	Introductions to Game Prototyping and Development... 4
TOTAL CREDIT HOURS		19
Quarter 5
MATH 152	Calculus and Analytic Geometry II	5
CIT 229	Computer Graphics 2	4
CIT 246	Game Development Project – Part 1	3
PHYS 117	College Physics: Mechanics & Heat	5
TOTAL CREDIT HOURS		17
Quarter 6
COMM 105	Speech (or)
COMM 110	Conference and Group Discussion	3
CIT 226	Digital Audio/Video Programming	3
CIT 247	Game Development Project – Part 2	3
TOTAL CREDIT HOURS		9
TOTAL DEGREE CREDIT HOURS		104

 

Computer Information Technology Associate Degree, MIS/Project Management Track

COURSE		CR
Quarter 1
CIT 101	PC Applications I	3
CIT 103	Computer Concepts and Logic	3
MATH 148	College Algebra	5
ACCT 269	Foundations of Accounting	5
ENGL 101	Beginning Composition	3
TOTAL CREDIT HOURS		19
Quarter 2
CIT 121	PC Operating Systems	3
CIT 163	Visual Basic 1	4
CIT 110	Unified Modeling Language	3
ENGL 102	Essay and Research	3
BMGT 257	Project Management	3
IMMT 122	Digital Media Preparation	3
TOTAL CREDIT HOURS		19
Quarter 3
CIT 175	Systems Analysis 1	4
CIT 151	Networking 1	3
CIT 263	Visual Basic 2	4
BMGT 111	Management	5
MKTG 226	Customer Service Principles and Practices	4
TOTAL CREDIT HOURS		20
Quarter 4
CIT 275	Systems Analysis II	4
CIT 173	Database Programming	3
CIT 264	Visual Basic 3	4
CIT 130	MIS II: Project Management Fundamentals	3
COMM 105	Speech (or)
COMM 110	Conference and Group Discussion	3
TOTAL CREDIT HOURS		17
Quarter 5
CIT 230	MIS III: Project Management Case Studies	3
CIT 251	Networking 2	3
CIT 273	Database Systems	3
COMM 200	Business Communications	3
HUM XXX	HUM 111, 112, 113, 151, 152, or 224	5
TOTAL CREDIT HOURS		17
Quarter 6
CIT 137	Advanced Information Presentation	3
CIT290/299	Seminar and Practicum (or)
CIT 281	Capstone for Software Developer	5
SSCI XXX	SSCI 100, 101, 102, 105, or GEOG 240	5
CIT XXX	Technical Elective	4
TOTAL CREDIT HOURS		17
TOTAL DEGREE CREDIT HOURS		109
Technical Elective
CIT 241	Intro. to the Mainframe – z/OS Basics	4
CIT 242	Intro. to the Mainframe – Lg Scale Commercial	4
CIT 243	Intro. to the Mainframe – Networking	4
CIT 244	Intro. to the Mainframe – Security	4

 

Computer Information Technology Associate Degree, Network Administrator Track

 

COURSE		CR
Quarter 1
CIT 101	PC Applications	3
CIT 103	Computer Concepts and Logic	3
CIT 121	PC Operating Systems	3
CIT 123	Workstation Systems	3
ENGL 101	Beginning Composition	3
BMGT 257	Project Management Principles	3
TOTAL CREDIT HOURS		18
Quarter 2
CIT 102C	PC Applications 2 Module 3 (Access)	1
CIT 151	Networking 1	3
MATH 148	College Algebra	5
COMM 105	Speech (or)
COMM 110	Conference and Group Discussion	3
MKTG 226	Customer Services Principles and Practices	4
ENGL 102	Essay and Research	3
TOTAL CREDIT HOURS		19
Quarter 3
CIT 175	Systems Analysis 1	4
CIT 251	Networking 2	3
CIT 233	Expert Access	3
CIT 250	Network Comm. Systems	3
ACCT 269	Foundations of Accounting	5
TOTAL CREDIT HOURS		18
Quarter 4
CIT 171	Database Administration/SQL	4
CIT 163	Visual Basic 1	4
CIT 252	Networking 3	4
IMMT 112	Fundamentals of Interactive Design	3
LAWE 215	Introduction to Cyberlaw	3
TOTAL CREDIT HOURS		18
Quarter 5
CIT 257	Network Security	3
CIT 253	TCP/IP	3
CIT 255	Networking 4	4
HUM XXX	Humanities 111, 112, 113, 151, 152, or 224	5
COMM 204	Technical Writing	3
TOTAL CREDIT HOURS		18
Quarter 6
CIT 258	Wireless Networking	3
CIT 290/299	CIT Seminar/Practicum (or)
CIT 282	Capstone Web/Net 5
CIT xxx	Technical Elective	4
SSCI XXX	SSCI 100, 101, 102, 105, or GEOG 240	5
TOTAL CREDIT HOURS		17
TOTAL DEGREE CREDIT HOURS		108
Technical Electives
CIT 110	Unified Modeling Language	3
CIT 130	MIS II: Project Management Fundamentals	3
CIT 160	CCNA Voice	4
CIT 164	CCNA Security	4
CIT 166	CCNA Wireless	4
CIT 241	Intro. to the Mainframe – z/OS Basics	4
CIT 243	Intro. to the Mainframe – Networking	4
CIT 244	Intro. to the Mainframe – Security	4
CIT 259	Advanced Network Security	3
CIT 260	Web Security	3
CIT 271	Data Mining and Data Warehousing	4
CIT 276	Information Security Audit	3
CIT 277	Computer Forensics	3
CIT 278	Business Continuity and Disaster Recovery	3

Computer Information Technology Associate Degree, Software Developer Track

COURSE		CR
Quarter 1
CIT 101	PC Applications I	3
CIT 103	Computer Concepts and Logic	3
MATH 148	College Algebra	5
ACCT 269	Foundations of Accounting	5
ENGL 101	Beginning Composition	3
TOTAL CREDIT HOURS		19
Quarter 2
CIT 121	PC Operating Systems	3
CIT 163	Visual Basic 1	4
CIT 175	Systems Analysis 1	4
ENGL 102	Essay and Research	3
CIT 110	Unified Modeling Language	3
TOTAL CREDIT HOURS		17
Quarter 3
CIT 145	HTML	3
CIT 151	Networking 1	3
CIT 263	Visual Basic 2	4
CIT 275	Systems Analysis 2	4
MKTG 226	Customer Services Principles and Practices	4
TOTAL CREDIT HOURS		18
Quarter 4
CIT 147	JavaScript Fundamentals	3
CIT 179	C# Programming I	4
CIT 169	Java Programming 1	3
CIT 173	Database Programming	3
CIT 264	Visual Basic 3	4
COMM 105	Speech  (or)
COMM 110	Conference and Group Discussion	3
TOTAL CREDIT HOURS		20
Quarter 5
CIT 279	C# Programming 2	4
CIT 269	Java Programming 2	3
CIT 273	Database Systems	3
COMM 204	Technical Writing	3
HUM XXX	HUM 111, 112, 113, 151, 152, or 224	5
TOTAL CREDIT HOURS		18
Quarter 6
CIT290/299	CIT Seminar/Practicum (or)
CIT 281	Capstone for Software Developer	5
BMGT 111	Management	5
IMMT 122	Digital Media Preparation	3
SSCI XXX	SSCI 100, 101, 102, 105, or GEOG 240	5
TOTAL CREDIT HOURS		18
TOTAL DEGREE CREDIT HOURS		110

Computer Information Technology Associate Degree, Web Developer Track

 

COURSE		CR
Quarter 1
CIT 101	PC Applications I	3
CIT 103	Computer Concepts and Logic	3
MATH 148	College Algebra	5
SSCI XXX	Social Sciences 100, 101, 102, 105, or GEOG 240	5
ENGL 101	Beginning Composition	3
TOTAL CREDIT HOURS		19
Quarter 2
CIT 121	PC Operating Systems	3
CIT 102	PC Applications 2	3
CIT 139	Web Essentials	3
CIT 175	Systems Analysis 1	4
ENGL 102	Essay and Research	3
TOTAL CREDIT HOURS		16
Quarter 3
CIT 145	HTML	3
CIT 163	Visual Basic 1	4
CIT 233	Expert Access	3
COMM 207	Writing for the Web	3
IMMT 112	Fundamentals of Interactive Design	3
TOTAL CREDIT HOURS		16
Quarter 4
CIT 212	Web Database Development	3
CIT 151	Networking 1	3
CIT 169	Java Programming 1	3
MKTG 111	Marketing Principles	5
ACCT 269	Foundations of Accounting	5
TOTAL CREDIT HOURS		19
Quarter 5
CIT 147	JavaScript Fundamentals	3
CIT 213	Designing an e-Commerce Website	3
CIT 269	Java Programming 2	3
COMM 204	Technical Writing	3
MKTG 226	Customer Service Principles and Practices	4
IMMT 262	Web Publishing Site Design	4
TOTAL CREDIT HOURS		20
Quarter 6
CIT 171	Database Administration/SQL	4
CIT290/299	CIT Seminar/Practicum (or)
CIT 282	Capstone Web/Net 5
HUM XXX	HUM 111, 112, 113, 151, 152 or 224	5
COMM 105	Speech (or)
COMM 110	Conference and Group Discussion	3
TOTAL CREDIT HOURS		17
TOTAL DEGREE CREDIT HOURS		107

 

Vocational Education Transfer Option with The Ohio State University College of Education

The Computer Information Technology, Web Developer program at Columbus State has completed an articulation agreement with the Technical Education and Training Program of the Ohio State University College of Education.  This agreement allows Computer Information Technology, Web Developer students to complete their associate degree at Columbus State, transfer their credits to Ohio State, and complete a baccalaureate degree in Technical Education and Training.  Students completing the Ohio State program may be eligible for certification by the Ohio Department of Education to teach in related high school career and technical education programs throughout the State of Ohio. Interested students should contact their Columbus State department chairperson for curriculum requirements and additional details. Please note that course requirements for this transfer option may differ from the standard plan of study published in the catalog.

CCNA Discovery Certificate

COURSE		CR
Quarter 1
CIT 150	Networking for Home and Small Business	4
TOTAL CREDIT HOURS		4
Quarter 2
CIT 152	Working at a Small-to-Medium Business	4
TOTAL CREDIT HOURS		4
Quarter 3
CIT 154	Introducing Routing and Switching in the Enterprise	4
TOTAL CREDIT HOURS		4
Quarter 4
CIT 156	Designing and Supporting Communications Technology	4
TOTAL CREDIT HOURS		4
Quarter 5
CIT XXX	Technical Elective	4
TOTAL CREDIT HOURS		4
Quarter 6
CIT 158	CISCO Certification Review	1
TOTAL CERTIFICATE CREDIT HOURS	21
Technical Electives
CIT 160	CCNA Voice	4
CIT 164	CCNA Security	4
CIT 166	CCNA Wireless	4

Computer Literacy Certificate

COURSE		CR
Quarter 1
CIT 095	Computer File Management	1
CIT 100	Computer Literacy	1
Quarter 2
CIT 094	Web Learning Tools	1
Quarter 3
CIT 101	PC Applications I	3
TOTAL CERTIFICATE CREDIT HOURS		6

Database Specialist Certificate

 

COURSE		CR
Quarter 1
CIT 233	Expert Access	3
CIT 175	Systems Analysis 1	4
TOTAL CREDIT HOURS		7
Quarter 2
CIT 171	Database Administration/SQL	4
CIT 273	Database Systems	3
TOTAL CREDIT HOURS		7
Quarter 3
CIT 173	Database Programming	3
CIT 271	Data Mining and Data Warehousing	4
TOTAL CREDIT HOURS		7
Quarter 4
CIT 163	Visual Basic 1	4
CIT 200	Certification Review	1
TOTAL CREDIT HOURS		5
TOTAL CERTIFICATE CREDIT HOURS		26

Information Security Certificate

COURSE		CR
Quarter 1
CIT 257	Network Security	3
CIT 258	Wireless Networking	3
TOTAL CREDIT HOURS		6
Quarter 2
CIT 259	Advanced Network Security	3
CIT 260	Web Security	3
TOTAL CREDIT HOURS	6
Quarter 3
CIT 276	Information Security Audit	3
TOTAL CREDIT HOURS		3
Quarter 4
CIT 277	Computer Forensics	3
TOTAL CREDIT HOURS		3
Quarter 5
CIT 278	Business Continuity and Disaster Recovery	3
TOTAL CREDIT HOURS		3
Quarter 6
CIT 200	Certification Review	1
TOTAL CREDIT HOURS		1
TOTAL CERTIFICATE CREDIT HOURS		22

Management Information Systems (MIS) Certificate

COURSE		CR
Quarter 1
CIT 103	Computer Concepts and Logic	3
CIT 130	MIS II: Project Management Fundamentals	3
TOTAL CREDIT HOURS		6
Quarter 2
CIT 110	Unified Modeling Language	3
CIT 175	Systems Analysis 1	4
TOTAL CREDIT HOURS		7
Quarter 3
CIT 230	MIS III: Project Management Case Studies	3
CIT 275	Systems Analysis II	4
TOTAL CREDIT HOURS		7
TOTAL CERTIFICATE CREDIT HOURS		20

Network Administrator Certificate

COURSE		CR
Quarter 1
CIT 250	Network Communication Systems	3
TOTAL CREDIT HOURS		3
Quarter 2
CIT 251	Networking 2	3
CIT 253	TCP/IP	3
TOTAL CREDIT HOURS		6
Quarter 3
CIT 252	Networking 3	4
TOTAL CREDIT HOURS		4
Quarter 4
CIT 255	Networking 4	4
TOTAL CREDIT HOURS		4
Quarter 5
CIT 257	Network Security	3
CIT 258	Wireless Networking	3
CIT 200	Certification Test Review	1
TOTAL CREDIT HOURS		7
TOTAL CERTIFICATE CREDIT HOURS		24

Software Developer Certificate

COURSE		CR
Quarter 1
CIT 145	HTML	3
CIT 179	C# Programming 1	4
CIT 163	Visual Basic 1	4
TOTAL CREDIT HOURS		11
Quarter 2
CIT 169	JAVA Programming 1	3
CIT 279	C# Programming 2	4
CIT 263	Visual Basic 2	4
TOTAL CREDIT HOURS		11
Quarter 3
CIT 269	Java Programming 2	3
CIT 264	Visual Basic 3	4
TOTAL CREDIT HOURS		7
Quarter 4
CIT 173	Database Programming	3
CIT 270	Advanced Web Programming	4
TOTAL CREDIT HOURS		7
TOTAL CERTIFICATE CREDIT HOURS		36

System Z Certificate

 

COURSE		CR
Quarter 1
CIT 241	Introduction to the Mainframe – z/OS Basics	4
TOTAL CREDIT HOURS		4
Quarter 2
CIT 242	Introduction to the Mainframe – Large Scale	4
TOTAL CREDIT HOURS		4
Quarter 3
CIT 243	Introduction to the Mainframe – Networking	4
TOTAL CREDIT HOURS		4
Quarter 4
CIT 244	Introduction to the Mainframe – Security	4
TOTAL CREDIT HOURS		4
TOTAL CERTIFICATE CREDIT HOURS		16