Courses Minor: Data Management

Learners in this course evaluate and perform linear, exponential, logarithmic, and other mathematical functions that include algebraic, graphic, and numeric properties. Learners then apply these concepts to the social and natural sciences, business, and everyday life.

Learners build an understanding of mathematical analysis techniques. Learners apply number logic and set theory, functions and sequences, relations equivalence, partial order, digraphs, recurrence relations, counting techniques, logic and techniques of proof, graphs, and algorithms to the fields of business and information technology. Prerequisite(s): MAT1050.

Learners in this course use fundamental terminology, concept analysis, and practical knowledge of the components of computing systems to develop their understanding of the information technology field. Throughout the course, learners also build, demonstrate, and apply skills needed for professional communication. For BS in Information Technology learners only. Must be taken during the learner’s first quarter. Cannot be fulfilled by transfer or credit for prior learning.

This course is an introduction to the fundamental concepts of databases and database management systems (DBMS). Learners demonstrate vocabulary, component requirements, sorting and querying, and maintenance of simple databases using the fundamentals of database manipulation. Learners also apply Structured Query Language (SQL) and relational database management systems (RDBMS).

This course introduces learners to the programming discipline and prepares them to serve as Java programmers. Learners study and apply the fundamentals of the Java programming language such as data types, variables, expressions, statements, and methods. Learners also examine and practice the Java-object-oriented features of classes and objects. The course offers numerous opportunities for analyzing, designing, coding, testing, debugging, and evaluating Java programs in an authentic Java development environment.

This course introduces learners to the key concepts underlying Local Area Network (LAN), Metropolitan Area Network (MAN), and Wide Area Network (WAN). Learners examine the layered architecture of the network protocol stack, including the OSI and the TCP/IP models, and apply the principles of designing networks and implementing network protocols. Learners also apply topics of network topologies, cloud computing, networking devices, cabling, and basic network security.

Learners in this course identify and apply their knowledge of inherent ethical concerns in the information technology profession to cultural and human interaction in global and domestic issues. Learners also show evidence of their understanding of ethical codes related to web technologies, intellectual property, and cybercrime.

Learners build fundamental web design and development skills. Learners create web pages using HTML5 markup language and apply contemporary design principles to create a W3C compliant website. Learners format the page layout, structure, and visual design elements using CSS3, with emphasis placed on effective coding, visual design, and user experience.

This course introduces JavaScript for interactive web pages. Learners in this course cover the JavaScript scripting language essentials, including flow control, form validation, animation, and Document Object Model (DOM) manipulation. Learners develop client-side, platform independent functionality using JavaScript to enhance user experience with HTML5 and CSS3. This course provides a foundation for other web technologies such as jQuery and AJAX. Prerequisite(s): Completion of or concurrent registration in IT3212.

Learners analyze core enterprise organizations, business processes, and information technology infrastructures and display their understanding of the value of information technology in achieving organizational maturity. Learners apply their knowledge of the relationship that exists between an enterprise organization’s business and information technology goals with operational models.

In this course, learners explore the boundary between humans and technology with a focus on the human factors that influence the design of effective interfaces and engaging user experiences. Learners analyze designs for enterprise, mobile, and web interactive environments. Learners also define user characteristics, design for accessibility, and appraise usability. Prerequisite(s): IT2240 or IT2249.

In this course, learners demonstrate their knowledge of hardware and operating systems, focusing on peripherals and file management. Learners use modern operating systems, including Windows, Linux and MacOS to demonstrate their skill with hardware and operating systems.

This course provides the opportunity for learners to acquire the foundational skills and knowledge required of a systems administrator. Learners employ tools and procedures to install, configure, administer, troubleshoot, and maintain modern computer systems.

In this course, learners demonstrate knowledge and skills related to the fundamentals of software engineering and architecture. During a course-long project, learners create a Software Development Plan (SDP) to use as a foundation for future software development projects within an organization. Other topics include software process models, project definition, project organization, validation plan and version control. Prerequisite(s): Completion of or concurrent registration in IT2230.

Learners apply features and techniques beyond the basics of the Java programming language to develop applications of moderate complexity. Learners analyze advanced object-oriented programming concepts like inheritance, polymorphism, interfaces, and abstract classes. Learners also investigate programming Graphical User Interface (GUI) applications with Java and the Java rich library of data structures like lists, stacks, and queues. Prerequisite(s): IT2249.

Learners in this course demonstrate their knowledge and skills with the fundamentals of network architecture. Learners apply knowledge of network characteristics and network topologies to develop a scope document for a proposed network architecture. Prerequisite(s): Completion of or concurrent registration in IT2250.

Learners in this course demonstrate their knowledge of information security fundamentals. Learners apply their understanding of the concepts of confidentiality, integrity, and availability to securing organizational assets.

In this course, learners are introduced to the fundamental basics of project management and gain a broad overview of project management standards and their applicability to both business and IT projects. This course emphasizes management theories, concepts, tools and techniques defined by the Project Management Institute (PMI^®) including the Process Groups and Knowledge Areas. This course also introduces other project management methodologies and frameworks, with an emphasis on Agile.

This course presents material specific to the activities of identifying and collecting data that is required to accomplish business intelligence and data analytics projects. Learners examine factors used to identify and collect accurate data within the right context and for the right audience and purposes. Topics include strategies for minimizing errors and biases and managing limitations in data collection. Learners apply these factors in order to identify and collect data for business intelligence and data analytics projects.  Prerequisite(s): ACS1003 or BUS3007 or IT2230.

This course covers legal and ethical issues pertaining to information security and privacy. Learners demonstrate an understanding of core organizational processes and workflows and how these factors impact core data processes. Prerequisite(s): ACS1003 or BUS3007 or IT2230.

In this course learners identify the role data architects play in data and metadata design and management. Learners evaluate tools and strategies used by data architects in designing data and metadata solutions.  Prerequisite(s): IT2230

Learners evaluate the roles and responsibilities of database administrators and explore how they contribute to data management. Learners determine how database design, administration, regulations, and standards impact effective data management processes. Additionally, learners investigate the tools and strategies that allow a database administrator to support data management. Prerequisite(s): IT2230.

Learners in this course study data integration and the role it plays in data management. Topics include evaluation of legal and ethical environments that dictate the strategies and tools available for data integration within the data management context. Learners explore methodologies, tools, and strategies that enhance the ability for data integration to support data management. Prerequisite(s): IT2230.

Learners assess the role data quality plays in the creation of effective data management processes and workflows. Learners research and apply methodologies, strategies, and tools that play a role in measuring and applying data quality and data cleansing as part of an effective data management program. Prerequisite(s): IT2230.

In this course, learners evaluate the role data models, standards, and techniques play in an effective data management program. Topics include exploration of data structure options and how those options impact the creation of data models. Learners apply tools and techniques to demonstrate how they support data management. Prerequisite(s): IT2230.

Learners analyze the role that distributed, cloud-based, and virtualized environments play on processes and workflows related to the management and analysis of core data. Learners research and apply tools and strategies that allow effective data management and analysis of core data within the constraints of distributed and virtualized environments. Learners evaluate the impact that subjects of core data projects have on security and privacy. Prerequisite(s): IT2230.

In this course, learners apply knowledge and skills from other courses as they develop a project that benefits an organization, community, or industry. Learners prepare a proposal that includes a project description, deliverables, completion dates, and associated learning. Upon approval from the instructor, learners execute the proposal, record their progress weekly using a project tracking website, and produce a final project report. For BS in Information Technology learners only. Must be taken during the learner’s final quarter. Cannot be fulfilled by transfer or credit for prior learning.