ISTC 1001 This course provides an overview of computer hardware, relational databases, local area networks and programming. Information Systems terminology and industry acronyms associated with data, voice and video are also covered. Prerequisites: None
Credits: 2
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1010 This course is designed for the PC novice to learn how to maintain, upgrade, and repair personal computers. Participants will remove and replace motherboards, and various input/output devices. Hard drives maintenance procedures (formatting) and loading operating systems will be covered. Prerequisites: None.
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1015 This course prepares IT students to support end users on the Microsoft Office Suite. This course covers basic computer concepts on computer hardware and desktop application software. Students will learn the fundamentals of word processing, database, and spreadsheet and presentation applications. Students will also be introduced to use of the Internet, online collaboration tools, and outlook. The capstone of the course will cover a comprehensive integration with Office applications.
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1030 This course covers operating system administration with the use of command line for microcomputers. Topics include booting and configuring the system, the use of internal commands and external commands, file management, networking, and writing of batch files. rerequisites: None
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1033 This course is designed to provide students with the knowledge and skills necessary to install, configure, manage and troubleshoot desktop clients in a network. Lectures, hands-on projects and exercises reinforce skills as they are learned. Specific topic coverage includes: Installing; Using the System Utilities; Managing File Systems and Storage; Users, Groups, Profiles, and Policies; Security and Access Controls; Network Protocols; Printing and Faxing; Performance Tuning; Working with the Registry; Booting Process; Fault Tolerance; Troubleshooting. Prerequisites: Operating Systems I ISTC1030
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 1045 This course exposes students to networking concepts, technologies, and typical network administration/analysis duties found in the workplace. Topics covered include communication models, network protocols, IP addressing and subnetting, physical and logical topologies, transmission media, and network hardware.
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1050 This course focuses on the fundamentals of relational databases; their use, design and implementation. The course will include entity-relationship modeling, logical and physical design and normalization. The use of Structured Query Language (SQL) for data manipulation will be emphasized. The course will also cover concepts of client/server, distributed and object-oriented databases, big data security, and data warehousing. Prerequisites: ISTC1015 Supporting Business Applications
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 1061 This course is designed to investigate the analysis and implementation of network security policies, procedures and guidelines for establishing, monitoring and controlling methodologies for local and wide area networks. The course covers authentication methods, communication security, infrastructure security, cryptography, operational security and firewalls. Prerequisites: ISTC 1045 Network Systems I
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 1100 This course focuses on the foundations of business communication in the Information Systems Industry. The topics will include developing your business writing skills, correspondence, written and oral business reports, employment communication, as well as topics on the social and ethical implications of Information Systems. Prerequisites: ISTC1015 and Accuplacer Reading score of at least 70.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 1230 This course provides coverage of systems analysis and design theories and techniques. Both the traditional, structured approach and the object-oriented approach to systems development will be explored. Students will learn the theory of analysis, design and implementation following the guidelines of the Systems Development Life Cycle. Students will demonstrate system modeling with UML. Prerequisite: Introduction to Programming ISTC1300 or equivalent programming experience.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 1300 This course provides the beginner programmer with a guide to developing programs using structured programming logic. Analysis, design, coding, testing and debugging will be covered. Programming key points include structured programming, modularized programming, decision-making, looping, arrays, data file utilization, arrays and object-oriented classes. Students will be exposed to procedural and object-oriented programming. Students will be required to generate simple programs for this course. Prerequisites: None.
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
ISTC 1510 This course covers skills used to create web pages with a focus on client-side technologies, including such topics as cascading style sheets (CSS), HTML, and JavaScript. Prerequisites: ISTC1300 Introduction to Programming
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2006 This course describes the architecture, components, and operations of routers and switches in a small network. Students learn how to configure a router and a switch for basic functionality. By the end of this course, students will be able to configure and troubleshoot routers and switches and resolve common issues with virtual LANs and inter-VLAN routing in both IPv4 and IPv6 networks. Prerequisite: ISTC1045
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2011 This course describes the architecture, components, and operations of routers and switches in larger and more complex networks. Students learn how to configure routers and switches for advanced functionality. By the end of this course, students will be able to configure and troubleshoot routers and switches and resolve common issues with OSPF, EIGRP, and STP in both IPv4 and IPv6 networks. Students will also develop the knowledge and skills needed to implement a WLAN in a small-to-medium network. Prerequisites: ISTC2006
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2035 In this course, the student is expected to learn the procedures underlying server operating systems. The course will cover network design, installing Servers, configuring and optimizing Servers, managing users and groups, disk quotas, basic and dynamic disks, security, and print management. Prerequisites: ISTC1045 Network Systems I and ISTC1033 Operating Systems II
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2037 System administrators can greatly increase their productivity and efficiency by leaving the GUI wizards behind and incorporating PowerShell into their daily routines. This course will expose students using Powershell in a variety of scenarios using many features included in Windows servers, such as Exchange, IIS, SharePoint, Azure, and Office 365.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2040 This course focuses on working with an enterprise-level database management system as well as basic administrative tasks such as installations. The use of Structured Query Language (SQL) will be emphasized as it relates to data definition and data manipulation. Topics also include triggers and stored procedures. Prerequisites: Database Systems ISTC1050.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2050 This course introduces the student to the theory, design, and implementation of common data structures and related algorithms. Topics include linked lists, recursion, stacks, queues, search algorithms, sorting algorithms, graphs, and binary trees. Students will write numerous programs to demonstrate comprehension of the course topics. PREREQUISITE: ISTC 1300
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2066 This course is designed for the network administrator who needs to learn the basics of VPN security and network firewalls. Basic installation techniques are covered along with how to make an intelligent choice of firewall technology. Basic firewall troubleshooting is also presented. This course aligns with the CheckPoint CCSA Certification outline. Prerequisites: ISTC1061
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2071 Course Description This course will provide a foundation in the field of Computer Forensics. The student will learn how to obtain and analyze digital information for possible use as evidence in civil, criminal or administrative cases. Topics include applications of hardware and software to computer forensics, computer forensics law, volume and file system analysis, computer forensics investigations, and computer forensics in the laboratory. Hands-on exercises guide discussions and reinforce the subject matter. Pre-Requisites - ISTC1015 (Supporting Business Apps) AND ISTC1033 (OS-2)
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2080 The CCNA Cybersecurity Operations curriculum provides an introduction to the knowledge and skills needed for a Security Analyst working with a Security Operations Center team. It teaches core security skills needed for monitoring, detecting, investigating, analyzing and responding to security events, thus protecting systems and organizations from cybersecurity risks, threats and vulnerabilities. Prerequisites: ISTC2011 and 2066.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2100 This course will provide fundamentals of planning and managing projects for information system (IS) organization. This includes creating components of a project which will involve schedules, using critical path, assigning resources, and tracking progress. Focus is on topics that are unique to management of projects in an IS department. Prerequisites: ISTC1015 Supporting Business Applications
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2110 This course covers skills used to create dynamic web applications with focus on server-side technologies. Students will learn how to use server-side programming languages to access SQL databases to create dynamic and persistent web applications. Prerequisite: ISTC1510 Web Programming I
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2150 This course is designed to provide students with hands-on experience in creating and managing virtualized server environments and high-availability clusters (aka clouds). Topics include hypervisors, virtual machines, PaaS and laaS options, storage-area networks, administration tools, and related technologies Prerequisites- lSTC1060 (Security-1) AND ISTC2035 (OS-3)
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2315 This course builds on early Java to cover some of Java's more advanced capacities. Topics covered include enterprise-wide development of distributed n-tier client/server applications, Java Database Connectivity (JDBC), server side Java programming (Servlets/JSP), multithreading, collections, and data structures. Prerequisites: ISTC1300 Introduction to Programming
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2320 This course will introduce the student to the .NET application development environment. The student will learn the .NET tools to create applications that correspond to Windows standards. Topics covered include data controls, reports, multiple-document applications, file processing, elementary database interfacing (ADO.NET), and web applications (ASP.NET). The major focus of the course will be on object-oriented topics such as classes, constructors, inheritance, and polymorphism used in the context of creating Graphical User Interface (GUI) intense programs. Prerequisites: Introduction to Programming ISTC1300 or equivalent programming experience.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2325 This course will present advanced topics in .NET application development. Coursework will focus on developing programs in the 3-tier client/server environment. Topics covered include database interfacing using ADO.NET, web applications using ASP.NET, multithreading, collections and interfaces. Prerequisites: .NET I ISTC2320 or equivalent .NET programming experience
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2330 This course is designed to introduce students to the concepts of cross-platform application development utilizing web technologies. Students will build web applications that can be deployed to various mobile and desktop operating systems.
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2550 This course focuses on integrated mobile applications, either Android or iOS-based, with cloud services. Using cloud services in mobile applications will be covered. Developing and deploying applications as cloud services will be explored. Prerequisites: ISTC2330 Cross-Platform Mobile Application Development
Credits: 2
Prerequisites:
Corequisites: None
Future Offering: None
ISTC 2610 This course focuses on capstone web project development. Students will be completing a capstone project that highlights an interactive web application, using both client and server side technologies. Advanced web development topics will be covered. Prerequisites: ISTC2110 Web Programming II or equivalent programming experience
Credits: 3
Prerequisites:
Corequisites: None
Future Offering:
ISTC 2970 This course is designed to provide students the opportunity to work within the Information Technology field. Students are expected to observe and apply all of the technical skills learned thus far in their program. Students are also expected to conduct themselves in a manner that would be expected of a full-time employee of the organization they are working for.
Credits: 3
Prerequisites: None
Corequisites: None
Future Offering:
1300 145th Street E., Rosemount, Minn. 55068-2999 | Phone 651-423-8000 | Toll-free 877-937-3282 | TTY 800-627-3529
A member of Minnesota State.
DCTC is an affirmative action, equal opportunity, employer and educator.