AIT. 101 Product Design and Reverse Engineering Studio (3)

Students will be provided with a “real” software/hardware product produced by a local organization and currently in use. The goal will be to understand the original need for the product and the approach the designer used in creating the final product. "Reverse Engineering is the process of analyzing an existing software system to identify the system's components and their inter-relationships, and to create representations of the system in another form at higher levels of abstraction (Ira Baxter)." Reverse engineering is a process of examination only. Modification of the software is referred to as reengineering which is performed in subsequent courses in the program. Students learn to understand and evaluate a software product from the design and functionality perspectives. Collaboration, brainstorming, teambuilding and other communication skills are practiced in this studio course. (Corequisite AIT. 102)

AIT. 102 Introduction to Computer Hardware, Software and Networks (3)

In this introductory course, students learn the nomenclature, functions and operating characteristics of IT system components. Students work with various operating systems and networks including wireless communications. Security issues are discussed and implemented. This course also introduces the importance of interpersonal communications skills to facilitate the technician-user interaction. The idea of IT fluency (National Research Council, 1999) was proposed as a minimum standard that all college students should achieve by the time they graduate. This course is a foundational course that enables students to begin developing IT fluency including the basic concepts of: computer organization, information systems, networks, digital representation of information, information organization, modeling and abstraction, algorithmic thinking and programming, limitations of information technology, the societal impact of information technology, the ability to set up a personal computer, connect a computer to a network, and use a database system to set up and access information.

AIT. 112 Introduction to C# Programming (3)

This course takes students through object-oriented programming including full coverage of the concepts of data encapsulation, inheritance, polymorphism, classes design, attributes and methods. Once the fundamental concepts and language constructs are established, students are then guided in the creation of a working system with objects working together to model the solution to a real world problem. (Prerequisite AIT. 101 and 102 or permission of department chair)

AIT. 201 Technology Ventures and Cross Cultural Team Development Studio (3)

Using numerous real-world scenarios and tools, this course is designed to provide students with an understanding of the concepts of teamwork and its role in modern organizations. Common problems teams encounter and how to solve them are addressed. The course also covers the application of popular and emerging collaboration tools to enhance team performance. The differences in individual behavior in organizational sub-cultures as well as global cross cultures are examined so that students can adapt their work style to achieve high team performance. In addition, the skills required to take a technology venture form idea to commercialization is studied. In this course, the student will learn the theory required to refine an idea, map a path for developing the idea into a viable product opportunity and then plan the organizational infrastructure to take the product to commercialization. (Prerequisite AIT. 101 and 102 or permission of department chair)

AIT. 211 Software Application and Database Integration Studio (3)

Working with SQL Server, student will apply the foundational concepts for modeling, designing, querying, and managing relational databases in an application environment. Techniques and skills developed in the course include the relational model, normalization, SQL programming, distributed databases, and capabilities of an object-relational database management system. In addition there is a focus on query optimization, database security, transaction management, concurrency control and recovery. (Prerequisite AIT. 112)

AIT. 212 Object Oriented Systems Analysis and Design (3)

This course details the unified process methodology for applications development by applying the appropriate unified modeling language (UML) constructs. The wide range of UML diagrams poses a challenge to most practitioners when selecting the best tools to meet the needs of the application under development. Techniques are presented to identify the best UML elements without requiring students to know Java or C++. Developing interviewing skills to gain an understanding of user needs are also covered in the course. (Prerequisite AIT. 112)

AIT. 301 Business Applications using ERP Studio (3)

This studio introduces students to SAP and Enterprise Resource Planning (ERP) concepts. Students will study the role ERP systems play in an organization and plan a SAP implementation to support the introduction of their product. Core business processes and the interactions between the Financials (FI), Sales & Distribution (SD), Materials Management (MM), Production Planning (PP), and Human Resources (HR) modules will be examined. The effects of ERP on the decision-making environment of the organization will be discussed. The relationship between the relational database and an ERP system will be explored. (Prerequisite AIT. 211)

AIT. 302 ABAP Programming (3)

This course will study the design, coding, and implementation of custom programs for enterprise information systems. The SAP R/3 enterprise environment and ABAP/4 development workbench will be used as the vehicle to learn these skills. Main topics of the course include ABAP/4 syntax, creating functions, calls to data dictionary objects, use of SQL programming, scripting for ERPs, and the use of third party programming languages. (Prerequisite AIT. 112 and 301)

AIT. 311 Advanced Business Applications using ERP Studio (3)

This studio course requires the students to develop an in-depth knowledge of one of the SAP sub modules in the Financials (FI) or Sales & Distribution (SD) modules. The students will then integrate their module with others as they move toward the implementation plan developed in AIT. 301. These modules are tightly integrated requiring system thinking and the effect of one module on the rest of the system will be explored. (Prerequisite AIT. 301)

AIT. 401 Data Warehousing, Mining and Analytics Studio (3)

This studio will apply data warehousing techniques to the cohort project using the Business Intelligence (BI) module of SAP. Main topics include studying the components of an enterprise data warehouse, the use of a relational database to support the data warehouse, and the process to extract, cleanse, consolidate, and transform heterogeneous data into a form appropriate for the data warehouse. The data in the warehouse will then be analyzed to show how overall decision making for the enterprise can be improved. (Prerequisite AIT. 311 and Math. 205)

AIT. 402 Application Integration using SOA with NetWeaver Studio (3)

This course explores Service Oriented Architecture (SOA) by covering SOA concepts and design principles, supporting standards, security issues, runtime infrastructure required, and web services as an implementation technology for SOA. Included are the fundamentals of defining, designing, testing, and implementing a SOA system. The impact of SOA on software quality, efficiency, security, performance, and flexibility are studied. The standards that support web services are also studied: Simple Object Access Protocol (SOAP), Web Service Definition Language (WDSL), and Universal Description Discovery and Integration (UDDI). SAP NetWeaver platform will be used for exercises involving SOA design, computer programming, system installation, and testing. The course will require students to create a web service project by bringing together previous SAP course content as well as ABAP programming. (Prerequisite AIT. 302 and 311)

AIT. 412 Best Practice Frameworks for IT within Organizational Contexts (3)

A critical aspect of any IT organization is its ability to provide the necessary business support to enable the organization to reach its goals. Organizations are now so dependent on the automation of large parts of their business processes that the quality of IT services and the synchronization of these services with the needs of the organization are now essential to their survival. In this course, students will learn IT Service Management (ITSM) as defined by the best practice library, ITIL (information technology infrastructure library) and apply some of the concepts to the project. This course will also survey other best practice IT models including ISO 20000, CMM (Capability Maturity Model), COBIT (Control Objectives for Information and related Technology), Prince2 (Projects in Controlled Environments), and Six Sigma. (Prerequisite AIT. 212 and senior standing)

AIT. 421 IT Security and Risk Management (3)

The focus of this course is on dfesigning and insuring information systems that can endure and survive attack. Physical and operating security will be explored at the network, oprtating system, DBMS, application and data layer. Protecting systems from internal as well as external threats and natural disasters will be covered in this course. (Prerequisite AIT. 212 and senior standing)

AIT. 422 Business Computer Networking (3)

An introduction to the fundamentals of networking in IT. Course topics include routing, switching, physical layer, security, and application areas. The use of enterprise networks in meeting business requirements and in the selection, design, deployment, integration, and administration of the network and communication infrastructures in an organization is also covered in detail. The networking aspects of multimedia, information storage and distribution, and the World Wide Web are also explored. (Prerequisite AIT. 212 and senior standing)

AIT. 444 Internship (1-3)

The internship provides the student with experience in a real-world business environment and aids in understanding the application of the knowledge learned in the classroom. The internship experience expands on the classroom knowledge and increases the student’s marketability upon graduation. As a part of the internship, the student will also explore the issues of career planning. (Junior or Senior standing)

AIT. 449 Special Topic in Applied Information Technology (1-3)

A study of selected issues in Information Technology (IT), especially those with a current impact on the IT discipline