Course Descriptions

420-A13-HR     3-3-2     2 2/3 cr.
Hardware and Operating Systems
Students learn to identify, describe and upgrade the physical components of a computer.They learn the fundamental functions of an operating system including file, task, processor, and memory management techniques. They learn the commands necessary to organize and manage files, configure devices, and monitor memory in two of the most common operating systems found in business – Windows and Linux. Students install and configure Windows, Linux, and a variety of third-party software packages and learn how to provide direct and indirect technical support for this software.

420-A32-HR     2-3-2     2 1/3 cr.
Networks
(Prerequisite: 420-A13-HR)
Students are introduced to the fundamental concepts used in data communications. They examine the various layers of the TCP/IP networking model. Students learn how to manage network users, groups and servers in a multi-domain environment. They compare a number of current and emerging wide area network architectures. Students also learn basic network security techniques and common techniques for resolving network problems.

420-B10-HR     3-3-3     3 cr.
Programming I
(Prerequisite: 420-A13-HR)
Students learn to design, code, and test simple object-oriented programs. They learn to write effective, efficient algorithms to solve programming problems and to use the three constructs of structured programming in coding their solutions. They learn the principles of object-oriented programming. They learn to draw UML class and sequence diagrams to represent the object-oriented solutions to problems. They learn how to code and use a simple class. They develop complete test plans to test their programs and learn to identify and correct common types of errors. Students use the Java programming language to write their programs.

420-B20-HR     3-3-3     3 cr.
Programming II
(Prerequisite: 420-B10-HR)
Students continue the study of object-oriented programming in this course. They create and refine an object model to solve a programming problem. They learn to apply the principles of encapsulation, inheritance and polymorphism in designing and coding object-oriented programs. They write programs that use arrays and that read from and write data files to produce different kinds of business reports. They write simple GUI programs. The Java programming language is used in this course.

420-B31-HR     2-3-2     2 1/3 cr.
Programming III
(Prerequisite: 420-B20-HR)
Students learn about data structures and abstract data types. They study the list, queue, stack, tree and map abstract data types and learn to implement them using different data structures. They learn to use recursion and study different sorting and searching algorithms. They learn the principles of unit testing and thoroughly test their code using JUnit cases. The Java programming language is used in this course.

420-B42-HR     1-3-3     2 1/3 cr.
Programming IV
(Prerequisites: 420-A31-HR, 420-B31-HR, 420-C40-HR)
Students explore mobile programming using the Android environment. They learn about service oriented architecture and apply it using Windows Communication Foundation. Students also learn how to create on-line help.

420-B51-HR     2-3-3     2 2/3 cr.
Programming V

420-C10-HR     2-3-2     2 1/3 cr.
Web Programming I
Students are introduced to web design, HTML, XHTML, and Cascading Style Sheets (CSS). They build web sites using a text editor and a web authoring tool. Students learn about web site design and how to use graphics, typography, colour, and themes to create a consistent look in their web sites. They create and integrate multimedia content, such as images, sounds, video, and animation, into a web site. They publish and test web sites on a web server.

420-C20-HR     2-3-3     2 2/3 cr.
Web Programming II
(Prerequisites: 420-C10-HR, 420-B10-HR)
Students begin to develop web applications. They use a client-side scripting technologies, such as JavaScript and AJAX, to create interactive web sites. They create solutions for deployment on different web servers such as IIS and Apache. Students learn how to create well-formed and valid XML documents and how to extract data from an XML document.

420-C30-HR     2-3-3     2 2/3 cr.
Web Programming III
(Prerequisite: 420-C20-HR)
Students continue to develop web applications. They use server-side scripting languages such as PHP and Java Servlets to develop and deploy web applications to both Windows and Linux servers. They learn the fundamentals of web server maintenance. They continue to learn about emerging web technologies.

420-C40-HR     2-3-2     2 1/3 cr.
Web Programming IV
(Prerequisite: 420-C30-HR)
Students create dynamic web applications using the.NET framework in Visual Studio. They use a variety of .NET controls to develop web applications. They create web forms to access a database and other data sources. They l perform automated testing to test their web pages and deploy .NET applications to a web server. They learn about security in a web application environment.

420-C50-HR     2-3-3     2 2/3 cr.
Web Programming V
(Prerequisite: 420-C40-HR)
Students use a service oriented architecture to build web applications. They develop applications that create and consume web services using AJAX, Java and .Net. They analyze the security required for a web application. They create well-formed and valid XML documents and use these documents in web applications.

420-D10-HR     2-4-3     3 cr.
Database Management I
(Prerequisite: 420-B20-HR)
Students learn the basic principles of relational database management systems. They learn to analyze the data and develop a data model based on data requirements. They use a CASE tool to create an entity-relationship diagram to represent the data model. Students also learn to use Oracle SQL to create and modify database tables and to retrieve data from a database. The students design and implement a database from a case study. Students learn the principles of transaction processing, database security and distributed database management.

420-D20-HR     2-2-2     2 cr.
Database Management II
(Prerequisite: 420-D10-HR)
Students continue their study of the Oracle database and learn to use advanced SQL structures such as stored procedures, triggers and cursors. They also learn to refine a data model to meet performance guidelines. Students continue to work on the case study started in Database Management I. The Oracle PL/SQL language is used in this course.

420-E01-HR     2-2-2     2 cr.
Business Information Systems
Students are introduced to a broad, general overview of business operations in both the private and public sectors. They learn about the different types of business information systems and about the flow of information within an organization. They study the important roles computer specialists play in all organizations. Students also learn how to write various business documents.

420-E11-HR     3-3-3     3 cr.
Systems I
(Prerequisites: 401-H01-HR, 420-B20-HR)
Students are introduced to systems analysis and design methods with an emphasis on the systems analysis phases. They learn how to use tools and techniques necessary for discovering and analysing user requirements required for information systems. Students develop feasibility analysis and recommendation skills needed by a systems analyst. Research and documentation is emphasized throughout analysis.

420-E21-HR     2-3-3     2 2/3 cr.
Systems II
(Prerequisites: 420-B31-HR, 420-D10-HR, 420-E10-HR)
Students learn graphical systems modeling and prototyping techniques and use them in systems analysis. The graphical systems modeling covers UML object modeling and basic process modeling. Students have an opportunity to apply all of the techniques in a simulated case study.

420-E31-HR     2-2-2     2 cr.
Systems III
(Prerequisite: 420-E20-HR)
Students learn systems design methods, security design, project management, testing methods, systems support and operation functions. Modeling techniques learned in the previous systems course are used to design systems. Students also gain experience in using project management and computer-assisted software engineering (CASE) software and apply the techniques learned in a simulated case study.

420-E42-HR     1-3-3     3 cr.
Systems IV
(Prerequisites: 420-E30-HR, 420-E50-HR)
Students conclude their study of systems analysis and design methods. Students research the information technology trends and complete a final technical document and presentation of their program accomplishments. They develop and provide training in the use of a software package, and develop a companion training manual.

420-E50-HR     0-6-2     2 2/3 cr.
Development Project I
(Prerequisites: 420-B40-HR, 420-C30-HR, 420-D20-HR, 420-E20-HR)
Students undertake the development of a new computer application in this course. Their primary responsibility is to analyze the requirements for the application, which is later developed in the Web and Windows Development Project courses. Working in project teams, the students identify the functional requirements of the application, develop models and prototypes, identify the technical alternatives and select an appropriate technical architecture.

420-E63-HR     0-13-4     5 2/3 cr.
Development Project II
(Prerequisites: 420-B41-HR, 420-C50-HR, 420-E30-HR, 420-E50-HR)
Students integrate the skills they have acquired in their previous courses by participating in a project to design and implement a web based computer application involving a database. Their primary responsibility is to complete the development of the application started in the Development Project I course. Working in project teams, the students design, code and test the application, produce documentation and manage the project.

420-E71-HR     0-6-2     2 2/3 cr.
Maintenance Project
(Prerequisites: 420-B50-HR, 420-C40-HR, 420-D20-HR, 420-E30-HR)
Students participate in a project to make functional enhancements to an existing application. They analyze the requirements, add to and modify the functionality of the application, test the application and update the documentation.