(IST) Information Systems Technology
[program website]
Note: Students should consult their academic advisor and the college or university to which they intend to transfer regarding information technology course requirements. The receiving institution always makes the final decision concerning transferability of credits.
IST 033 - Tech Studio (2 credits)
Prerequisite: instructor or advisor permission
An introductory computer technology course for students who have had little or no exposure to computers. Topics include the basics of Windows, the Internet, word processing, multi-media, and e-mail. Students create a web-based ePortfolio to showcase their coursework. 1 lecture/2 laboratory hours
course outline
IST 101 - Computer Concepts with Applications (3 credits)
Prerequisite: reading proficiency
Corequisite: MAT 037 (or MAT 037A and 037B)
Addresses hardware, software, the Internet, multimedia, and security and ethics issues. Lab includes exposure to Windows as well as word processing, database, spreadsheet, and presentation applications. 2 lecture/2 laboratory hours
course outline
IST 102 - Computer Concepts with Programming (3 credits)
Prerequisites: ENG 034 and MAT 037 (or MAT 037A and 037B) or equivalent proficiency
An introduction to computer literacy including a programming laboratory. Lectures cover the Internet; software; system components; peripherals; communications; databases; security, ethics, and privacy; programming languages; and enterprise computing. The laboratory covers forms, menus, decisions, loops, arrays, searching, the user interface, and database programming with VB.NET. 2 lecture/2 laboratory hours
course outline
IST 103 - Computer Concepts with Programming and Productivity Software (4 credits)
Prerequisites: ENG 034 and MAT 037 (or MAT 037A and 037B) or equivalent proficiency
Lecture topics in this computer literacy course include the Internet; software; the systems unit; peripherals; careers; communications; database systems; security, ethics, and privacy; and programming and enterprise computing. The laboratories cover VB.NET basics, decisions, loops, arrays, and database programming as well as word processing, spreadsheets, database management, and presentation graphics. 2 lecture/4 laboratory hours
IST 107 - Introduction to C/C++ Programming (3 credits)
Corequisites: proficiency in basic algebra, MAT 037 (or MAT 037A and 037B)
By programming to solve problems in C/C++, students gain an appreciation for the role that computers and programs play in today's society. Topics include programming in a traditional environment, variables, methods, decisions, repetition, arrays, and object-orient programming. Extensive laboratory exercises reinforce lecture concepts. 1 lecture/4 laboratory hours
course outline
IST 109 - Introduction to Programming (3 credits)
Prerequisites: proficiency in basic algebra, MAT 037 (or MAT 037A and 037B)
Introduces fundamental programming structure, tools and documentation, including how to design interfaces and develop Task Object Event (TOE) and Object Properties and Settings charts, hierarchy charts, pseudocode, and flowcharts. Problem-solving techniques and program design using logic control structures of sequence, selection, iteration, arrays, and sequential files are emphasized in laboratory exercises using VB.NET. 2 lecture/2 laboratory hours
course outline
IST 111 - Introduction to Help Desk Support (4 credits)
Prerequisites: NET 102, NET 103
With structured practical experience through use of an international practice firm model, students learn basic Help Desk concepts, skills, and technologies required to provide entry-level assistance as an information technology professional. Students are involved in Help Desk support activities, decision-making, critical thinking, and team projects. 1.5 lecture/5 laboratory hours
IST 123 - Programming in Visual Basic.NET (3 credits)
Prerequisite: IST 109
Overview of Visual Basic.NET language to create event-driven programming applications to be run in a Windows environment. Develops object-oriented solutions for a variety of problems in personal and business computing. 2 lecture/2 laboratory hours
course outline
IST 129 - Introduction to C# Programming (3 credits)
Prerequisite: IST 102, IST 103, IST 109, or permission of instructor
Corequisite: MAT 135 or higher
By programming to solve problems using C#, students gain an appreciation for the role that computers and programs play in today's society. Topics include programming environment, variables, methods, decisions, repetition, exceptions, arrays, and object-oriented programming. 2 lecture/2 laboratory hours
course outline
IST 134 - Introduction to Oracle SQL and PL/SQL (3 credits)
Prerequisite: IST 109 with a minimum C grade
An introduction to Structured Query Language (SQL) and Oracle's Programming Language SQL (PL/SQL). Topics include relational database models, database normalization, forms, and reports. Students implement database models using the Oracle DBMS and its developer tools. 2 lecture/2 laboratory hours
IST 137 - Introduction to Java Programming (3 credits)
Prerequisite: IST 102, IST 103, or IST 109
Corequisite: MAT 135 or higher
Introductory programming course using Java for students who have had some exposure to any language. Topics include procedural and object-oriented programming, the syntax of Java, conditional statements, looping, classes, the user interface, arrays, recursion, searching, and sorting. Some projects require an understanding of college algebra. 2 lecture/2 laboratory hours
IST 140 - The Internet and Computer Technology (3 credits)
Prerequisite: computer literacy
Introduction to Internet technology and the use of the World Wide Web as a tool. Topics include Internet and Web history, client-server networks, Web browsers, search engines and queries, multimedia, electronic commerce, social networking utilities, electronic mail, and computer security. Students design a Web page using HTML. 2 lecture/2 laboratory hours
course outline
IST 143 - Introduction to HTML and Website Hosting (4 credits)
Prerequisite: IST 101 or equivalent computer proficiency
Explores operating systems for website hosting, including installing, configuring and optimizing operating systems and web servers. Examines Hypertext Markup Language (HTML), its future direction, and scripting languages. 3 lecture/2 laboratory hours
course outline
IST 145 - Scripting for the World Wide Web (3 credits)
Prerequisites: IST 102 or IST 103, IST 143 and ENG 101
Corequisite: MAT 140 or higher
Explores operating system options for website hosting including the installation of Apache Web Server on a computer with a UNIX operating system and Active Server Pages on a computer with Windows. Students use XML, CCS, and XHTML to generate multi-page, multimedia websites that can be accessed via the Internet. 2 lecture/2 laboratory hours
course outline
IST 209 - Project Management Concepts (3 credits)
Cultivates strategies to orchestrate carefully designed action plans to complete projects successfully, often incorporating complex, dynamic and changing requirements. Explores the management of technology, people, and change to achieve goals, reach targets, and deliver the project on time and within budget. 2 lecture/2 laboratory hours
course outline
IST 223 - Advanced Programming in Visual Basic.NET (3 credits)
Prerequisite: IST 123
Incorporates programming, problem solving, programming logic, and the design techniques of an object-oriented language. Students acquire advanced VB programming skills such as accessing and updating data in a relational database, developing applications for the Web and mobile devices, and adding browser-based Help files to applications. 2 lecture/2 laboratory hours
course outline
IST 229 - Intermediate C# Programming (3 credits)
Prerequisites: ENG 101 and IST 129
Corequisite: MAT 135 or higher
An intermediate programming course for students who have completed an introductory college course in C#. Addresses advanced object-oriented programming, determining system and resource parameters, and advanced Windows programming. Lab exercises use the .NET programming environment to reinforce lecture and text materials. 2 lecture/2 laboratory hours
course outline
IST 231 - Advanced C# Programming (3 credits)
Prerequisites: IST 229 and MAT 135
Addresses advanced topics including advanced Windows programming, accessing and updating databases from local and remote locations, and Web-based client-server applications. Lab exercises use the .NET programming environment to reinforce lecture and text materials. 2 lecture/2 laboratory hours
course outline
IST 238 - Intermediate Java Programming (3 credits)
Prerequisites: IST 137 and MAT 135 or higher
An intermediate programming course for students who have completed an introductory college-level course in Java. Topics include object-oriented analysis and design, lists, stacks, queues, sets, maps, trees, graphics, files, Applets, Swing, and AWT. These topics focus on using Java for the study of computer programming technology. 2 lecture/2 laboratory hours
IST 239 - Advanced Java Programming (3 credits)
Prerequisite: IST 238
Focus on the use of Java as a tool for professional programming. Topics include advanced object-oriented programming including inheritance and polymorphism; exception handling; generic methods; multithreading and networking; database access; Web programming, including Servlets and JavaServer pages; and formatting and regular expressions. 2 lecture/2 laboratory hours
course outline
IST 245 - Building e-Commerce Websites (3 credits)
Prerequisites: DMA 145 and IST 145
Covers the fundamental technologies used to build and market interactive business-to-business or consumer-oriented e-commerce websites. Server and client-side programming, files, and Web page authoring tools are used to provide customer authentication, ordering, and order-closeout. 2 lecture/2 laboratory hours
course outline
IST 247 - Advanced e-Commerce Websites (3 credits)
Prerequisites: IST 245 and CIS 173
A continuation of IST 245. The applications that were developed in IST 245 using files are revised to use SQL datasets, and enhanced to encrypt critical data and to process credit payments using SSL. 2 lecture/2 laboratory hours
course outline
IST 250 - System Audits and Controls (3 credits)
Prerequisite: two years of programming experience or equivalent proficiency
Introduction to the fundamentals of systems auditing, emphasizing the importance of system controls and the effects poor controls can have within a computer-based information system. Covers various audit tests of data and controls, risk assessment, and professional standards. 3 lecture hours
IST 251 - Management of Computer Technology (3 credits)
Prerequisite: completion of 30 credits toward Information Systems or Information Technology program
Explores solutions to the challenges facing a typical computer technology manager, including project life-cycles, security, access, end-user computing, project planning, scheduling, staffing, employee development, and external threats to private computers. 2 lecture/2 laboratory hours
course outline
IST 252 - Database Security (3 credits)
Prerequisites: IST 109, IST 253
Overview of security architecture, including fundamentals of operating system security. Topics include administration of users; profiles, password policies, privileges, and roles; database application security models; virtual private databases; database auditing models; application data auditing; database activity auditing; and security and auditing. 2 lecture/2 laboratory hours
IST 253 - Database Concepts (3 credits)
Prerequisite: IST 102, IST 103, or IST 109
Covers relational database technology and how to apply it in solving basic and advanced database problems and cases. Provides the foundation for the advanced study of individual database management systems, electronic commerce, and enterprise computing. 2 lecture/2 laboratory hours
course outline
IST 254 - Database Administration (3 credits)
Prerequisite: IST 253
Examines the activities of database administration. Topics include relational design, start-up, access management, scaling, security, data integrity, backup, recovery, and troubleshooting. The theory and techniques for heterogeneous databases are applied using several products typically found in small business. 2 lecture/2 laboratory hours
IST 255 - Data Mining (4 credits)
Prerequisite: BUS 205
Corequisite: BUS 206
Focuses on the methods used to extract and organize data in a data warehouse, including OLAP (Online Analytical Processing). Students investigate the advantages and disadvantages of various methods to extract, organize, and present data that has been stored in a large data repository. 3 lecture/2 laboratory hours
IST 256 - Systems Analysis (3 credits)
Prerequisite: NET 102.
An introduction to systems analysis and design, including analyzing the business case, requirements modeling, and development strategies. Additionally covers output and user interface design, data design, systems architecture and implementation, and systems operation, support, and security. 2 lecture/2 laboratory hours
IST 257 - Project Risk Management (3 credits)
Prerequisite: IST 209
Includes and follows the current Project Management Body of Knowledge (PMBOK) on risk. The many aspects of risk -- including analysis, matrix, assessment, evaluation, management, transfer, and avoidance -- are identified and explored. 2 lecture/2 laboratory hours
IST 259 - Project Management (4 credits)
How to select, initiate, operate, and control all types of projects, including how to manage risks and uncertainties. Equips students with the quantitative skills, knowledge of organizational issues, and insights into human behavior that are needed for effective project management. 3 lecture/2 laboratory hours
IST 260 - SQL Server Database Design (4 credits)
Prerequisite: NET 120
Corequisite: NET 122
Covers user-defined functions and constraints, database methodologies including OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) issues, and SQL Server. Additionally covers the relational database model, normalization issues, and ensuring data integrity through the use of views, triggers, and stored procedures. 3 lecture/2 laboratory hours
IST 261 - SQL Server System Administration (4 credits)
Prerequisite: IST 260
Covers the concepts and skills required for support of SQL Server and Microsoft Certified Database Administration (MCDBA) certification: backing up and restoring databases, setting up and managing users, managing database security, managing the replication environment, tuning the database system, and troubleshooting any problems that arise. 3 lecture/2 laboratory hours
IST 297 - IT Capstone Project (2 credits)
Prerequisite: completion of 36 credits toward Information Systems or Information Technology degree program
Students work in a simulated business environment to define, plan, schedule, complete, document, and present to the IT faculty a major system, website, or networking project of their own choosing. 1 lecture/3 laboratory hours
IST 298 - Information Systems Cooperative Education (2 credits)
Prerequisite: final course for degree in Information Technology
Integration of classroom study with specific planned period of learning through job experience. Based on an individualized learning contract. 180 work experience hours
