(ist) Information Systems Technology Courses

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.


(2 credits)  IST 033 - Tech Studio
Prerequisite: instructor or advisor permission
An introductory hands-on computer technology course for students who have had little or no exposure to computers. Topics include the basics of operating systems, the Internet, word processing, multi-media, the cloud, programming, and e-mail. Students develop file management skills and work with web-based applications. 1 lecture / 2 laboratory hours

course outline   current classes


General Education course Technology
(3 credits)  IST 101 - Computer Concepts with Applications
Prerequisites: ENG 101 and MAT 037 or MAT 042
Introduces students to computer concepts and applications through both lecture and lab materials. Lectures focus on hardware and software, the Internet, multimedia, security and ethics issues, and information. Lab addresses in-depth exposure to Excel spreadsheet and Python software program language. 2 lecture / 2 laboratory hours

course outline   current classes


General Education course Technology
(3 credits)  IST 102 - Computer Concepts with Programming
Prerequisites: ENG 034; 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 Java. 2 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 108 - Introduction to Programming with Mobile Application Development
Prerequisite: MAT 037 or MAT 042 or proficiency in basic algebra
Introduces computing and programming concepts, and explores mobile and web technologies. Topics include variables, decision-making, iteration, lists, functions, decomposition, event-driven programming, databases, client-server computing, web services, platforms, programming languages, animation, texting, and geolocation. Students learn by creating Android mobile applications using App Inventor, a visual programming language. 3 lecture / 2 laboratory hours

course outline   current classes


General Education course Technology
(3 credits)  IST 109 - Introduction to Programming
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   current classes


(3 credits)  IST 110 - Introduction to Python
Prerequisite: IST 101 or IST 102
Designed for students majoring in Computer Information Systems or those with little or no programming background. Python is a widely used interpreted, object-oriented programming language focused on readability and code optimization with a simple, easy to learn syntax. This course is designed for students with basic programming experience in an object-oriented language. 2 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 140 - The Internet and Computer Technology
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   current classes


(4 credits)  IST 144 - Website Development
Introduces website development skills. Thorough examination of Hypertext Markup Language (HTML) includes navigations, tables, Cascading Style Sheets (CSS), images, audios, videos, and forms. Students learn the latest web design and development technologies including HTML5, CSS3, JavaScript, and jQuery. 3 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 208 - Android Application Development
Prerequisite: COS 102 or equivalent
Teaches how to develop applications for Android devices using Java programming language along with the Android SDK. Students learn how to apply Java and object-oriented technology to mobile application development. Doing real projects within the Eclipse integrated development environment further advances practical programming knowledge and skills. 3 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 209 - Project Management Concepts
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   current classes


(4 credits)  IST 218 - iOS Application Development
Prerequisite: COS 102 or equivalent
Introduces the tools and skills needed to create apps for iPhone and iPad. Students learn the Swift programming language and use it with Xcode to create apps on the iOS platform. The course uses Apple's latest “Everyone Can Code” college curriculum with hands-on, real world projects. 3 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 222 - PL/SQL Programming
Prerequisites: IST 109, IST 262
Incorporates programming, problem solving, programming logic, and design techniques. Students acquire advanced programming skills such as accessing and updating data in a relational database and developing applications using PL/SQL. 2 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 244 - Web Application Development
Prerequisite: one of the following: IST 144, IST 108, IST 109, COS 101, COS 102, DMA 145 or equivalent
Introduction to server-side programming and database integration contributes to the creation of dynamic and interactive web applications. Primary programming languages and technologies covered include ASP.NET, C#, SQL Server, and MVC (Models, Views and Controllers) programming model. 3 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 250 - Decision Support Using MS Excel
Prerequisites: IST 102, IST 109, IST 123
Techniques for building complete Excel-based decision support systems in a highly accessible manner. Topics include referencing and names, functions and formulas, charts, pivot tables, macros, programming structures, building user interfaces, and VBA for optimization and simulation. The extended functionality topics include statistical analysis, the Solver and modeling, simulation, and working with large datasets. 3 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 251 - Management of Computer Technology
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   current classes


(3 credits)  IST 253 - Database Concepts
Prerequisite: IST 102 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   current classes


(3 credits)  IST 256 - Systems Analysis
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

course outline   current classes


(4 credits)  IST 259 - Project Management
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

course outline   current classes


(4 credits)  IST 260 - SQL Server Database Design
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

course outline   current classes


(4 credits)  IST 261 - SQL Server System Administration
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

course outline   current classes


(4 credits)  IST 262 - Oracle SQL
Prerequisite: IST 109
Introduces Oracle services, including writing SQL statements, creating databases, manipulating data and tables, working with log files, and performing general database administration. Assists students with preparing for series of examinations leading to the Oracle Certified Associate (OCA) Certificate. 3 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 263 - Database Administration I
Prerequisite: IST 262
Addresses Oracle Database software installation along with new database creation and administration. Students configure the database to support an application, create users, define storage structures, set up security, design a backup and recovery strategy, and monitor the database to ensure its smooth operation. 3 lecture / 2 laboratory hours

course outline   current classes


(4 credits)  IST 264 - Database Administration II
Prerequisite: IST 263
Combines training, experience, and testing to ensure a strong foundation and expertise in the industry's most advanced database management system. Focus includes an Oracle database configuration for multilingual applications, the Oracle Recovery Management and Flashback technology, and database performance monitoring tools. 3 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 265 - Database Cloud Computing Concept
Prerequisites: IST 109, IST 253
Corequisites: IST 262
Teaches database deployment using cloud platforms to program and administer databases in a variety of cloud computing scenarios while managing the platform for scalability, troubleshooting performance issues, and implementing strong security. 2 lecture / 2 laboratory hours

course outline   current classes


(3 credits)  IST 275 - Data Analytics and Visualization
Prerequisite: CIS 175 or appropriate Excel experience
Students acquire a detailed knowledge of descriptive statistics while learning how to use MS Excel to clean, manipulate, and interpret real world data sets with the goal of creating readable, well-constructed data visualization dashboards. 2 lecture / 2 laboratory hours

course outline   current classes


(2 credits)  IST 298 - Information Systems Cooperative Education
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

current classes