Computer Technology - Information Systems Specialist

Associate in Applied Science in Computer Technology

Information Systems Specialist Career Path

60 Credit Hours

This program prepares students for careers in a variety of information technology areas. It gives students a foundation in computer hardware, computer applications, computer programming, the Internet and computer networking. Information systems administrators are involved in many different aspects of computer technology and can expect to employ their skills in a variety of ways to assist all computer users in commercial settings.

Students can earn only one Computer Technology degree in a single career path.

Accreditation

Accounting, Business and Management, Computer Technology and Administrative Office Technology
Accreditation Council for Business Schools and Programs
11520 West 119th St.
Overland Park, KS 66213

General Education Core Requirements

ECO 210	Macroeconomics	3
Lec: 3 Lab: 0 Credit:3 This course covers the study of fundamental principles and policies of a modern economy including markets and prices, national income accounting, cycles, employment theory and fiscal policy, banking and monetary controls, and the government’s role in economic decisions and growth.Learn More Prerequisites MAT 155 and MAT 101 or appropriate placement
or
ECO 211	Microeconomics	3
Lec: 3 Lab: 0 Credit:3 This course includes the study of the behavior of households and firms, including supply and demand, elasticity, price/input in different market structures, pricing of resources, regulations, and comparative advantage and trade.Learn More Prerequisites MAT 101 and MAT 155 or appropriate placement

ENG 101	English Composition I	3
Lec: 3 Lab: 0 Credit:3 This course is a study of composition in conjunction with appropriate literary selections, with frequent theme assignments to reinforce effective writing. It also reviews standard usage and presents basic research techniques.Learn More Prerequisites RWR 100 with a minimum grade of C or appropriate placement

IDS 109	First Year Experience Seminar	3
Lec: 3 Lab: 0 Credit:3 This course introduces students to interdisciplinary thinking, academic integrity and the philosophy of the liberal arts and sciences education. Students develop skills to be academically successful: connecting to campus resources, improving information literacy and practicing integrative learning.Learn More Prerequisites RWR 100 (or equivalent) with a minimum grade of C or appropriate placement scores.

MAT 109	College Algebra with Modeling	3
Lec: 3 Lab: 0 Credit:3 This course is an approach to algebra that incorporates mathematical modeling of real data and business applications. Emphasis is on linear, quadratic, piecewise defined, rational, polynomial, exponential and logarithmic functions. Includes inequalities and matrices. MAT 109 is designed for the student with plans to use college algebra as a terminal course or take MAT 130 after completion. Focus is placed more on applications rather than theoretical mathematics.Learn More Prerequisites MAT 102 with a minimum grade of C or appropriate placement
or
MAT 110	College Algebra	3
Lec: 3 Lab: 0 Credit:3 This course includes the following topics: polynomial, rational, logarithmic and exponential functions; inequalities; systems of equations and inequalities; matrices; determinants; and solutions of higher degree polynomials.Learn More Prerequisites MAT 102 with a minimum grade of C
or
MAT 120	Probability and Statistics	3
Lec: 3 Lab: 0 Credit:3 This course includes introductory probability and statistics, including organization of data, sample space concepts, random variables, counting problems, binomial and normal distributions, central limit theorem, confidence intervals and test of hypothesis for large and small samples, type I and type II errors, linear regression, and correlation.Learn More Prerequisites MAT 032 or appropriate placement

REQ HUM

Select from Humanities

Total:

Major Requirements

CPT 114	Computers and Programming	3	*
Lec: 3 Lab: 0 Credit:3 This course introduces computer concepts and programming. Topics include basic concepts of computer architecture, files, memory and input/output devices. Programming is done in a modern high-level language. The course includes understanding how computer programs work and the role of the programmer in a business environment. The course starts with assembly language, then scripting language, then finishes with object-oriented programming. No previous programming knowledge is needed.Learn More Prerequisites MAT 032

CPT 162	Introduction to Web Page Publishing	3
Lec: 3 Lab: 0 Credit:3 This course is a study of the fundamentals of web page design and implementation.Learn More Prerequisites MAT 032

CPT 172	Microcomputer Database	3
Lec: 3 Lab: 0 Credit:3 This course introduces microcomputer database concepts, including generating reports from databases and creating, maintaining and modifying databases using Microsoft Access.Learn More Prerequisites MAT 032

CPT 174	Microcomputer Spreadsheets	3
Lec: 3 Lab: 0 Credit:3 This course introduces the use of spreadsheet software on the microcomputer. Topics include creating, editing, using formulas, using functions and producing graphs using Microsoft Excel.Learn More Prerequisites MAT 032

CPT 180	Shell Scripting	3
Lec: 3 Lab: 0 Credit:3 This course is a study of shell scripting and emphasizes the designing, coding, and testing of scripts. This course will cover shell scripting from both the command line and the Graphical User Interface.Learn More Prerequisites MAT 032 and CPT 114 or CPT 167 or IST 165 or IST 190

CPT 209	Computer Systems Management	3
Lec: 3 Lab: 0 Credit:3 This course examines the methods and procedures used in maintaining microcomputer systems. Topics include hardware and software installation, configuration, operations and troubleshooting. This course examines the interaction of people, systems and computers. Strategic management issues unique to the information technology environment are discussed. Specialities include remote support technician, help desk technician, call center technician specialist, representative, depot technician and bench technician. Emphasis will be placed on computer design, operating systems, internetworking of devices and general information security concepts. This course will cover learning objectives associated with the CompTIA A+ certification exam. Emphasis will be placed on individual hardware components, BIOS, firmware, troubleshooting computer design, operating systems, internetworking of devices and general information security concepts.Learn More

CPT 242	Database	3
Lec: 3 Lab: 0 Credit:3 This course introduces database models and the fundamentals of database design. Topics include database structure, database processing and application programs that access a database. Upon completion of this course the student will be able to 1) demonstrate the fundamental skills needed to successfully design and implement a database, 2) demonstrate a thorough understanding of database concepts and technologies, and 3) be able to use and understand SQL commands.Learn More

CPT 264	Systems and Procedures	3
Lec: 3 Lab: 0 Credit:3 This course covers system analysis, design, development and implementation.Learn More Prerequisites CPT 114 or CPT 167 and CPT 162 and CPT 242 and IST 166 and ENG 101

IST 161	Introduction to Network Administration	3
Lec: 3 Lab: 0 Credit:3 This course is an introductory study of networking operating system administration. Techniques of installation and administration of a networking operating system will be included. This course will focus on Microsoft Desktop Administration. This course covers the objectives of the associated Microsoft certification exam.Learn More

IST 166	Network Fundamentals	3
Lec: 3 Lab: 0 Credit:3 This course is a study of local area networking concepts through discussions on connectivity, communications and other networking fundamentals. The course is designed to prepare the student to be successful in completing industry network fundamental certification exams. This course covers the content included in the CompTIA Network + certification exam.Learn More

IST 190	Linux Essentials	3
Lec: 3 Lab: 0 Credit:3 This course provides students with the fundamental knowledge and concepts of the Linux operating system, including command line functions, file systems, user and group administration, process management, text editors, and network applications. This course helps students prepare for the CompTIA Linux+ certification exam.Learn More

Total:

Electives

Select four courses from the following options.

Microcomputer Programming Option

CPT 167	Introduction to Programming Logic	3
Lec: 3 Lab: 0 Credit:3 This course introduces foundation concepts in structured programming. Problem solving and algorithm development through pseudo code and flowcharting is emphasized. Solutions are developed using the basic control structures of sequential, decision and iteration.Learn More Prerequisites MAT 101

CPT 187	Object-Oriented Logic and Design	3
Lec: 3 Lab: 0 Credit:3 This is a study in the planning and implementation of object-oriented programs.Learn More Prerequisites CPT 167 with a minimum grade of C

CPT 237	Advanced Java Programming	3
Lec: 3 Lab: 0 Credit:3 This course is a study of advanced topics of the Java programming language by building on a basic knowledge of the Java language. Topics covered will include multi-reading, swing classes, swing event models, advanced layout managers, the JavaBean component model, network programming and server-side programming.Learn More Prerequisites CPT 187 with a minimum grade of C

CPT 244	Data Structures	3
Lec: 3 Lab: 0 Credit:3 This course examines data structures widely used in programming. Topics include linked lists, stacks, queues, trees, and sorting and searching techniques. Students use C++ to develop ideas about multidimensional tables of objects, variable record length files, pointers and complex programs that reuse functions.Learn More Prerequisites CPT 237 with a minimum grade of C

Business Application Solutions Specialist Option

CPT 179	Microcomputer Word Processing	3
Lec: 3 Lab: 0 Credit:3 This course introduces microcomputer word processing. Topics include creating, editing, formatting and printing documents using Microsoft Word.Learn More

CPT 270	Advanced Microcomputer Applications	3
Lec: 3 Lab: 0 Credit:3 This course emphasizes the integration of popular microcomputer software packages using advanced concepts in microcomputer applications software.Learn More Prerequisites CPT 174 and CPT 179 and CPT 290

CPT 290	Microcomputer Multimedia Concepts and Applications	3
Lec: 3 Lab: 0 Credit:3 This course will cover introductory microcomputer multimedia concepts and applications. The course will utilize text, graphics, animation, sound, video, and various multimedia applications in the design, development and creation of multimedia presentations.Learn More

Internet Programming Option

CPT 238	Internet Scripting	3
Lec: 3 Lab: 0 Credit:3 This course is a study of Internet programming including the syntax of scripting languages and Internet programming concepts and examines topics related to client-side scripting language programming as well as introducing topics related to server-side scripting.Learn More Prerequisites IST 239

CPT 262	Advanced Web Page Publishing	3
Lec: 3 Lab: 0 Credit:3 This course is a study of advanced techniques in web page design and implementation.Learn More Prerequisites CPT 162 or ARV 227 and CPT 114 or

CPT 283	PHP Programming I	3
Lec: 3 Lab: 0 Credit:3 This course is an introduction to the PHP programming language and will cover topics related to the syntax of PHP language and how PHP can be used to design and develop dynamic, database-driven web pages.Learn More Prerequisites CPT 162 and CPT 114 or

IST 239	Datum and JavaScript	3
Lec: 3 Lab: 0 Credit:3 This course includes concepts and skills for developing dynamic functionality and interactivity for websites using JavaScript: variables, operators, conditionals, functions, objects (image and form), properties, methods, cookies, frames and arrays. This course covers the basics of the JavaScript language, how to place JavaScript into an HTML file and advanced JavaScript topics such as event handlers, arrays, forms and cookies.Learn More Prerequisites CPT 162 or ARV 227 and CPT 114 or CPT 167

Database Administration Option

CPT 202	SQL Programming I	3
Lec: 3 Lab: 0 Credit:3 This course is an introduction to the writing of basic Structured Query Language (SQL) used in creating tables, inserting data, retrieving data, and manipulating data from database.Learn More Prerequisites CPT 242

IST 272	Relational Database	3
Lec: 3 Lab: 0 Credit:3 This course provides a comprehensive foundation in both SQL and relational database design and implementation. Dynamic and embedded SQL programming techniques are emphasized. Additional topics include forms developer, triggers, stored procedures and PL/SQL programming.Learn More Prerequisites CPT 202

IST 274	Database Administration	3
Lec: 3 Lab: 0 Credit:3 This course is a study of the duties and responsibilities of a database administrator. The course covers setting up, maintaining, and troubleshooting a distributed, multi-user database.Learn More Prerequisites CPT 202

Linux Systems Administration Option

IST 191	Linux System Administration	3
Lec: 3 Lab: 0 Credit:3 This course provides students with the skills necessary to administer a Linux system, including hardware/software configuration, user and group administration, Linux network configuration, and file system management. This course helps students prepare for the RedHat Certified Systems Administrator (RHCSA) certification exam.Learn More Prerequisites IST 190

IST 192	Linux Network Applications	3
Lec: 3 Lab: 0 Credit:3 This course provides students with the skills necessary to deploy and administer the core networking services in a Linux system, such as Apache Web Server, Samba File Server, BIND Domain Name Service, NFS and others. This course helps students prepare for the RedHat Certified Engineer (RHCE) certification exam.Learn More Prerequisites IST 191

IST 198	Cloud Essentials	3
Lec: 3 Lab: 0 Credit:3 This course is a study of Cloud computing as a framework for providing network access to shared computing resources including storage, network, server and virtualization infrastructures.Learn More Prerequisites IST 166 or IST 190

Cisco Certified Network Associate Option

IST 201	Cisco Internetworking Concepts	3
Lec: 3 Lab: 0 Credit:3 This course is a study of current and emerging computer networking technology. Topics include safety, networking, network terminology and protocols, network standards, LANs, WANs, OSI model, cabling tools, Cisco routers, router programming, star topology, IP addressing, and network standards. This helps prepare students for the Cisco Certified Network Associate (CCNA) credential.Learn More Prerequisites IST 166

IST 202	Cisco Router Configuration	3
Lec: 3 Lab: 0 Credit:3 This course is a study of LANs, WANs, OSI model, Ethernet, token ring, FDDI, TCP/IP protocol, dynamic routing, and the network administrator’s role and function. This helps prepare students for the Cisco Certified Network Associate (CCNA) credential.Learn More Prerequisites IST 201

IST 203	Advanced Cisco Router Configuration	3
Lec: 3 Lab: 0 Credit:3 This course is a study of configuring Cisco routers. This helps prepare students for the Cisco Certified Network Associate (CCNA) credential.Learn More Prerequisites IST 202

IST 204	Cisco Troubleshooting	3
Lec: 3 Lab: 0 Credit:3 This course is a study of troubleshooting network problems. This helps prepare students for the Cisco Certified Network Associate (CCNA) credential.Learn More Prerequisites IST 203

CompTIA Systems Specialist Option

IST 293	IT and Data Assurance I	3
Lec: 3 Lab: 0 Credit:3 This course introduces the basics of network security. Topics covered will include network vulnerabilities and threats, security planning, security technology, network security organization, as well as legal and ethical issues related to network security. This course will provide coverage of the objectives associated with the CompTIA Security+ certification.Learn More

Other Electives

ARV 217	Computer Imagery	3
Lec: 2 Lab: 3 Credit:3 This course covers the use of the computer as a tool to create images that address the needs of the visual communication field. Adobe Photoshop software is used. It is recommended that students enrolling in ARV 217 be familiar with basic computer functions and computer file management.Learn More

ARV 227	Website Design I	3
Lec: 2 Lab: 3 Credit:3 This course introduces the production of an interactive website.Learn More Prerequisites ARV 217 or MAP 112

CPT 208	Special Topics in Computer Technology	3
Lec: 3 Lab: 0 Credit:3 This course focuses on changes in computer technology.Learn More

CPT 282	Information Systems Security	3
Lec: 3 Lab: 0 Credit:3 This course is the study of the protection of information and equipment in computer systems. Topics include all aspects of systems protection, including physical security, hardware, software and communications security. Students will learn about risk assessment, business continuity planning, privacy and regulatory compliance. Addresses technical, legal and ethical issues.Learn More

CPT 297	Big Data Analytics	3
Lec: 3 Lab: 0 Credit:3 This course introduces big data concepts and the fundamentals of providing efficient analytics for extremely large datasets.Learn More

IST 235	Handheld Computer Programming	3
Lec: 3 Lab: 0 Credit:3 This course is a survey of the techniques of rapid application development for handheld devices. Topics include setup of development environment, creation and deployment of programs, and design strategies to overcome memory and interface limitations. The focus of the course will be the development of software for the Android mobile phone.Learn More Prerequisites IST 239 with a minimum grade of C

IST 290	Special Topics in Information Sciences	3
Lec: 3 Lab: 0 Credit:3 This course covers special topics in information sciences technologies.Learn More

Any CPT or IST course not required in the career path.

Total:

Cooperative Work Experience/Internship Option

CWE	Cooperative Work Experience	*
Lec: 0 Lab: * Credit:* Credit for Cooperative Work Experience is available in various programs and for 1-4 credits. Students can participate in CWE more than once for credit. Contact your academic advisor to discuss prerequisites and enrollment approvals. * Credits are awarded based on the number of contact hours students work, based on a 1:5 credit-to-contact ratio.Learn More

IST 286	Technical Support Internship I	3
Lec: 0 Lab: 9 Credit:3 This course is an entry-level technical support/help desk internship. Students intern at the college’s help desk and provide support to faculty and staff. Students will participate in weekly evaluation sessions of calls and solutions.Learn More Prerequisites CPT 209 and IST 165 and departmental approval

Admission Requirements

Admission into this program requires proof of high school graduation (or GED) and qualifying placement levels.