Bachelor of Science in Information Technology

This course introduces students to the concepts of Web site design, including Web project management, the Web site development process, and ethical and legal issues in Web development. The course provides hands-on experience with Web page layout, navigation, typography, Web graphics, color, color theory, web safe colors, HTML, XML, XHTML, structural elements (tables and framesets), cascading style sheets, and metadata. It also explores readability, interactivity, navigation, usability and accessibility, browsers and design considerations, audio, motion, multimedia, and the impact of these design elements on the performance of the web site. Students will need access to Microsoft Internet Explorer 7.0 (or higher) and Firefox 2.0 (or higher). This software is not provided by the course material grant and must be purchased/provided by the student. This course covers lessons 1-16 of the Design Methodology and Technology curriculum of the CIW Site Designer certification.

Pre Reqs: Web Development Fundamentals(WEBD121)

This course is a study of the principles, practices, and technical architecture and development characteristics of Object Oriented Programming and an examination of the differences between object oriented programming and traditional programming. It examines objects, instances, classes, inheritance, polymorphism, encapsulation, abstraction, methods, attributes, tight-encapsulation, interfaces, type casting, type conversions, and object libraries. This course differentiates between single-inheritance model and multiple inheritance models. This course also explores the foundations of the Unified Modeling Language (UML), class models, state models, and interaction models.

This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site.

This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site.

This course focuses on developing Microsoft Access Switchboard applications; it includes: designing and building form and report interfaces, interfacing the Access database to a web page, building dynamic web pages, integrating Access with other Office applications such as Excel, building pivot tables and charts, categorizing the various types of join operations, examining the rudiments of the Visual Basic for Applications (VBA) code, debugging VBA code, creating macros and functions, and designing Access applications. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Prerequisite: INFO161

Pre Reqs: Relational Databases with MS Access: Introduction(INFO161)

This course is a study and application of the MS Access VBA Programming; it takes you from using Access to programming with Access. This course translates ERD diagrams into database designs, examines the VBA programming model, converts macros to VBA code, delves into the rudiments of the Visual Basic for Application (VBA) language system, uses the VBA editor, uses VBA to connect to Access, utilizes VBA to perform DDL actions in Access, creates sub procedures, implements functions, handles errors, performs debugging, and utilizes the built-in functions. This course also includes implementing database access in Windows-based and Web-based solutions. This course also includes an examination of the Security Model in the context of Access and VBA. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Prerequisite: INFO261 and INFO221

Pre Reqs: Relational Database Concepts(INFO221),Relational Databases with MS Access: Advanced(INFO261)

This course introduces the student to local area networking concepts in an easy to understand way. In today's competitive business world, one needs to have a basic understanding of the networking technology that runs it. Whether they choose to delve full bore into the technical side of networking or use what they learn to make an informed decision regarding the design, implementation, and maintenance of their local area network, this course will give the student a good foundation to build upon. Students must have access to MS Visio software. Course software requirements with the appropriate versions are listed under the course materials site. This course meets the topical requirements of the DoD Directive 8570.1M Information Assurance Management (IAM) Technical I category.

This course will discuss both computer and network security, from the wetware (human), software, and hardware perspectives. The "wetware" component will deal with identification of potential risk situations, establishing policies for avoidance, recovery, and prosecution, and proactive measures to reduce causal factors for security breaches in an organization. The "software" perspective will examine types of inappropriate software activity, as well as asset protection issues (recognizing software assets). This component will also address software tools available to assist in reducing administrative costs due to both malicious and accidental loss. The "hardware" component will address hardware approaches to protecting assets, as well as hardware techniques used to compromise assets. Specific technologies discussed include firewalls, symmetric key encryption, public key encryption, digital certificates, and cryptographic systems (SSL/TLS, VPNs, and Kerberos).

This course introduces students to Web site development through a combination of readings and hands-on development exercises. This course emphasizes XHTML, including hyperlinks, tables, Web forms, frames, images, colors, and other graphical elements. Image techniques, such as image maps, image transparency, image interlacing, and animation are examined. GUI editors, e-commerce practices, and advanced Web technologies, such as server-side and client-side languages, DHTML, and DOM are also addressed in this course. Fundamentals of JavaScript programming are also introduced in this course. Students will need access to Microsoft Internet Explorer 7.0 (or higher) and Firefox 2.0 (or higher). This software is not provided by the course material grant and must be purchased/provided by the student. This course covers the Site Developer Foundations curriculum of the CIW Foundations certification. It also covers lessons 30-34 of the Design Methodology and Technology curriculum of the CIW Site Designer certification.

This course expands on the topics that were introduced in Web Development Fundamentals (WEBD121). This course introduces the student to fundamental JavaScript programming concepts such as variables and data, functions, controlling program flow (branching and iterating), the JavaScript object model (window, document, image, history, location, and navigator objects), and JavaScript language objects (String, Array, Date, and Math objects). This course also addresses the development of interactive forms with JavaScript, cookies and JavaScript security, controlling frames with JavaScript, and custom JavaScript objects. Students must have access to Internet Explorer 5.5 (or higher) or Netscape 4.0 (or higher) software. This course covers the Javascript Fundamentals curriculum of the CIW JavaScript Fundamentals certification. This software is not provided by the course material grant and must be purchased/provided by the student.

This course focuses on the theory and principles of various programming languages that are used on the web, with particular focus on HTML, XHTML, and DHTML. Students will explore the principles of Object Oriented Programming (OOP) and examine inheritance, encapsulation, and polymorphism. They will also examine the components of OOP languages; the scope, protocols and parameters for various methods, such as: dynamic text ranges (move, moveStart, moveEnd, moveToPoint, moveToElement, getElementById, getBookmark, compareEndPoints, setEndPoints, Expand, Collapse, FindText), transition ranges (blendTrans, revealTrans), event propagation (stopPropogation, addEventListener, removeEventListener), dynamic content (createAttribute, createElement, createTextNode, cloneNode), and dynamic styles (CSS) and dynamic positioning (CSS-P) (coordinate systems, absolute positioning, relative positioning, and dynamic data binding). Students will explore the principles governing the animation of text (pulsating text, expanding text, flying text, drag and drop). This course focuses on improving the user-application interactivity via dynamic content, animation, media (audio and video), forms, web-safe colors, styles, and Cascading Style Sheet (CSS).

Pre Reqs: Web Development Fundamentals(WEBD121)

This course is a study of the design and development of web sites using Dreamweaver. Students will use professionally designed templates to develop coordinated and sophisticated layouts for a multi-page website. They will work with Cascading Style Sheets (CSS), graphics (enhance, optimize, embed, and edit image properties), tables, templates, frames, forms, and snippets. They will also perform site management and use the extensibility feature of Dreamweaver. Microsoft Expression Web will also be introduced. Students must have access to Microsoft Internet Explorer 7.0 (or higher), Firefox 2.0 (or higher), Microsoft Expression Web, Adobe and Dreamweaver CS3 (or higher), and Opensource software. This course covers lessons 17-23 of the Design Methodology and Technology curriculum of the CIW Site Designer certification. Students must obtain their own software for the course.

This course is a study of the concepts and applications of the Extensible Markup Language (XML), a general-purpose markup language that can be used to formally specify special-purpose markup languages. This course will be taught from a mixture of analytical and practical methods. Topics include: the history of XML, the XML language, Data Type Definition (DTD), XML Schema, eXtensible Style Sheet Language (XSL), and eXtensible Style Sheet Language Transformations (XSLT). The student will bind values to elements to render them distinct and different from its other instances of that attribute and explore the power of XML as a tool for Enterprise Exchange in both the J2EE and .NET Software Development Frameworks. Knowledge of XML will enable the student to standardize and reuse reference text, paragraphs, and chapters.

This course is a study of the .NET framework. Students will examine the differences between Visual Basic (VB) and VB.Net, the Common Language Runtime (CLR), Microsoft Intermediate Language (MSIL), the XML Web Services platform, .NET Framework Class Library, and examine Visual Studio.NET and Visual Basic.NET (VB.NET). They will create classes, properties, methods, constructor methods, sub-procedures, and function-procedures. They will handle events, explore datatypes, build Window forms and Web Forms, add and interact with controls, specify events, develop event-handling code, and add menus. They will also evaluate ADO.Net, choose an ADO.Net provider, connect to a database, and perform database interactions. Students must have access to Visual Studio 2005 or Visual Basic 2005 Express Edition (or higher). This software is not provided by the course material grant and must be purchased/provided by the student.

This course is a study of the theory and application of developing dynamic desktop and web-based applications using the .NET Framework and Visual Basic.NET (VB.NET). This course examines the architecture of the VB.NET IDE, the rudiments of the VB.NET programming language, the .NET Framework Class Library, OOP Design, Design Patterns, overriding members, overloading members, component-based programming, exception handling, interface-based programming, common windows controls, file management, control licensing, ADO.NET, connection pooling, and data validation. They will also interface with relational databases, use the GDI class library, draw graphics, perform graphic transformations, build MDI applications, and use access modifiers to control visibility. Students must have access to Visual Studio 2005 or Visual Basic 2005 Express Edition (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.

This course is a study of the theory, concepts, and applications of the Active Server Page (ASP.NET) web development environment. Students will learn about working with the page (HtmlForm class, error handling, tracing, page personalization, and rich page composition), the ASP.NET object Model (request, response, server, session, application, global.asax file, and collaborative data object), data providers (managed providers, SqlConnection class, and SqlCommand class), data containers (SQlDataAdapter, DataSet, DataTable, and DataView objects), data source based data binding, and managing the HTTP Request Context and lifecycle. The student will also manage and establish state across HTTP connections, explore caching, and examine ASP.NET’s security architecture (“session hijacking,” Forms authentication, membership and role management, and security related controls). Students must have access to Visual Studio 2008 or Visual Web Developer 2008 Express Edition software. This software is not provided by the course material grant and must be purchased/provided by the student.

This course is a study of the C# language and its object-oriented facilities to create applications using the .NET Framework. Students will explore datatypes, classes, methods, parameters, properties, interfaces, iteration, conditional branching, constructor methods, and destructor methods. They will examine parameter passing, method overloading, method overriding, access modifiers, exception handling, and event handling. They will also create forms with controls, and with event handling for these controls. Students will also use Visual Studio.Net to set profiles, create projects, use the solution explorer, set references, set project properties, use the code editor, define assembly information, compile the code, run the application, and debug the program. Students must have access to Visual Studio 2005 or Visual C# 2005 Express Edition (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.

This course evaluates the process for designing, developing, and deploying .NET enterprise applications. This course is a culmination of courses on Visual Basic.Net, ASP.Net, and C#.Net; the student will apply the knowledge and skills learned in these courses to develop and deploy a web-based application. This course investigates the process for configuring the .Net Framework and examines the issues related to project integration and application deployment. Students must have access to Visual Studio 2005 or Visual Web Developer 2005 Express Edition (or higher) and Microsoft Access 2007 (or higher) software.

This course is designed to provide a solid foundation for undergraduate study in the online environment. Students will be introduced to learning theory, the tools available in the online classroom and campus, and online research. Identification of personal learning style allows students to improve their study/learning techniques and prepares them to succeed in college level courses. Students will be introduced to formatting and citation styles. APUS policy and procedure is addressed. There is an emphasis on written communication to assist students in the transition to the online environment.

This capstone course is a senior level course designed to allow the student to review, analyze and integrate the work the student has completed toward a degree in Information Technology. The student will complete an approved academic project and paper that demonstrates mastery of their program of study in a meaningful culmination of their learning, and assesses their level of mastery of the stated outcomes of their degree requirements. This is a capstone course to be taken after all other Information Technology courses have been satisfactorily completed. Students must have submitted a graduation application and have been cleared by the graduations department prior to registering for this course.