Courses Minor: Data Analytics

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 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.

Learners in this course explore data storage technologies used within the IT industry, and the impact those technology selections have on data analytics. Topics include the impact of data storage technologies on secondary use of data and how data security and privacy controls within storage technologies constrain or support access to that data. Learners apply data storage technologies and tools to determine how they impact data analytics at a granular level. Prerequisite(s): IT2230.

This course covers the impact data integration has on data analytics and how that impact is managed across the spectrum of data management and data analytics. Learners research technologies common to the IT industry that are used to integrate data from multiple resources. Learners gain an understanding of those data integration tools and techniques and apply them to data analysis. Prerequisite(s): IT2230.

Learners in this course focus on the extraction, transformation, and loading (ETL) process, which is used to prepare and provide data that supports the work of data analytics. Learners study how ETL is used to identify, clean, transform, and serve the most effective data for data analytics projects. Learners apply tools and technologies specific to these activities in order to gain an understanding of the alternatives and applications appropriate within different contexts. Prerequisite(s): IT2230.

In this course, learners use a data mining project to identify, evaluate, and prepare data appropriate for the project. Learners use Excel spreadsheets and pivot tables to complete an accurate and effective data mining project. Prerequisites(s): IT2230.

This course presents an advanced look at the role of statistical analysis in completing effective data analytics projects. Learners apply SAS to a data analytics project to strengthen their experience with Excel spreadsheets and pivot tables. Prerequisite(s): Completion of or concurrent registration in IT4330.

Learners in this course examine the final phase of an effective data analytics project when the results of the project are shared with the appropriate audience, using the best timing and approach. Learners explore the various options and technologies available as tools to share data with a variety of types of audiences. Topics include factors that influence how to effectively present data using particular tools in a data analytics project. Prerequisite(s): ACS1003 or BUS3007 or 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.