Operating Systems and Scripting 420-223-LA
(Concentration course for Computer Science students only)
In this course, students will learn basic operating system concepts and functions, such as system architecture, process and memory management, scheduling, I/O device drivers and file systems. Through lectures and hands-on labs, students will gain a general overview and understanding of UNIX, both in a multi-user and single user environment. This experience will be deepened by the use of command line tools and system and shell programming to automate common tasks.
Prerequisite: 420-121 (Computer Fundamentals) 4 hours/week Units: 2.00
Configuring, Managing and Maintaining Computers 420-224-LA
(Concentration course for Computer Science students only)
In this course students will gain an introductory understanding of how to operate within the Windows 8 environment from your PC and be able to take full advantage of the many sharing, storing, and multi-platform benefits inherent in the Windows 8 operating system. Topics to be introduced to students are computer management; disk management; control panel; applications and services using task manager; add, view and manage your devices among others new features such as Windows 8 Client Hyper-V and Metro suite.
Also in this course the student will acquire the necessary hands on hardware skills to install, repair, and maintain computers. It makes the students aware of the steps involved in planning, debugging, testing computer problems and identification of possible software tools that will help to complete the tasks required to make computers function properly.
Prerequisite: 420-121-LA (Computer Fundamentals) 4 hours/week Units: 2.00
COBOL programming 420-321-LA
(Concentration course for Computer Science students only)
The course starts with an overview of structured programming concepts. The four divisions of a COBOL program and their functions are reviewed in detail. You will gain hands on experience through a series of class discussions and workshop exercises that include several modifications to a skeletal COBOL program. File processing, program looping, conditional program statements, and table processing (single and multi-dimensional) SORT a sequential file in a COBOL program using both Input and Output procedures are covered in detail.
Development of clear and understandable program designs is stressed along with building maintainable programs.
Prerequisite: 420-221-LA (Programming with Java) 4 hours/week Units: 2.00
Database Design and SQL language 420-322-LA
(Concentration course for Computer Science students only)
This course introduces students to basic database modeling, design, and implementation concepts and techniques. Entity- Relationship (E-R) modeling methodology is described in detail and students learn how to model information requirements and develop conceptual models from user specifications. Relational database theory is presented including the description of the relational model and theory of Normal Forms. Transformations techniques between the E-R and relational models are described. Database programming using SQL is introduced in lectures and supported by practical exercises using ORACLE (a relational DBMS). In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Prerequisite: 420-221-LA (Programming with Java) 5 hours/week Units: 2.66
Networking and Internet Services 420-324-LA
(Concentration course for Computer Science students only)
This course is intended to provide students with the knowledge necessary to understand and identify the tasks involved in supporting networks. The course is designed to provide an overview of networking concepts and how they are implemented in a Windows environment. The focus will be on performing desktop and server installation and configuration tasks, as well as network and operating system management tasks. The TCP/IP protocol suite, essential network security concepts, including authentication, encryption and firewalls, routing and related IP addressing schemes are covered. Content also includes selected topics in Web server, File Server, Printer Server support and LAN/WAN connectivity.
Prerequisite: 420-223-LA (Operating Systems and Scripting) & 420-224-LA (Configuring, Managing and Maintaining Computers)
Computer Science – Legacy to Mobile (Continued)
Game Development (Concentration course for Computer Science students only) 420-323-LA
In this course the students will learn how to use Open Web Technologies such as JavaScript, CSS3 & HTML5 to create browser based single or multiplayer games. We will discuss and compare different methods of real-time animation, implementing game loop, structure of the code or communication between the players. Students will learn how to run a game as a desktop application outside the browser on MacOSX, Linux & Windows, or as a native application on a mobile device. Additionally the course will cover the requirements on how to sell it in the App stores.
Prerequisite: 420-221-LA (Programming with Java) & 420-222-LA (Web site planning and implementation)
4 hours/week Units: 2.00
Business System Analysis 420-424-LA
(Concentration course for Computer Science students only)
From problem definition and planning to project proposals and systems design, this course gives students a thorough understanding of the entire Systems Development Life Cycle. Replete with both “hard” and “soft” skills, this semester long course builds a sound strategy for analyzing business processes and demonstrates how to apply concepts and practical techniques within the context of an experiential learning environment. Students emerge from this course with a firm base of systems foundations as well as a greater understanding that doing the right things is just as important as doing things right. Students will also learn how to document requirements in both business and systems use case diagrams using the Unified Modeling Language (UML).
Prerequisite: 420-322-LA (Database Design and SQL language) & 420-324-LA (Networking and Internet services) & 410- 921-LA (Business Fundamentals for IT)
5 hours/week Units: 2.66
JCL/RPG (Concentration course for Computer Science students only) 420-421-LA
This course has two components; the first one provides a practical overview of job processing functions, JCL commands and the use of JCL with the MVS/ESA operating system. It teaches how to successfully write, interpret and debug JCL job streams. Topics include how to prepare a COBOL program to accept data from the PARM field in JCL and to pass data to a subprogram, Use COBOL Intrinsic Functions such a upper case and Current Date, Build a series of programs for a typical batch job scenario.
The second part allows the student to get a comprehensive exposure to the basic features and functions of RPG IV. Develop and maintain simple RPG IV programs written using the latest features and techniques available in the compiler. This course is for students in our third year who are new to RPG IV.
Prerequisite: 420-321-LA (Cobol programming) 3hours/week Units: 1.66
Legacy System Modernization (Concentration course for Computer Science students only) 420-422-LA This course introduces the student to look at the needs of the business industry that faces growing maintenance fees, shortage of trained developers, expected end-of-life announcements, cumbersome deployment processes, platform dependencies as reasons that companies are migrating from legacy Main Frame COBOL or RPG applications to modern Java solutions. Understanding what it takes to convert existing legacy systems, operations infrastructure or reporting applications, the COBOL to Java migration process is a valuable tool for our students.
Converting a procedural language like COBOL to object oriented Java presents several challenges. The conversion process requires that the result application should work exactly the same as the original application, the result application should be maintainable and follow the object oriented concepts and paradigms ( encapsulation, abstraction, modularization, loose coupling) and the result application should perform the same or better than the original one.
Prerequisite: 420-321-LA (Cobol programming) & 420-221-LA (Programming with Java)
Computer Science – Legacy to Mobile (Continued)
Web Programming (Concentration course for Computer Science students only) 420-423-LA
Building on yourHTML skills, in this course students learn how to manipulate text and other data, create Web forms to handle user input, structure code using functions and server-side includes, and creates various types of program logic. The course also covers topics required to build refined, data-driven Web applications, including cookies and sessions, handling uploaded files, querying databases, and producing and consuming Web services using PHP. The code will be written in OOP format, which in this case means creating a number of re-usable classes.
Students will learn many current topics, how to connect to a MySQL database, retrieve data and how to format and display that data in XML format, add custom tabs to their Facebook Fan Page using IFrame, creating web services, Site-map generation with images, how to use PHP’s DOMDocument to parse your XML so you do not have to use XML parser, how to create a shopping cart using session object variables.
Prerequisite: 420-322-LA (Database Design and SQL language) & 420-323-LA (Game Development)
3 hours/week Units: 2.00
Database System Administration 420-513-LA
(Concentration course for Computer Science students only)
The second in a database course sequence related to ORACLE technology that deals with the administration and implementation of a relational database system. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. Topics covered may include: embedded SQL; PL/SQL; advanced/optimized SQL queries; transaction management including concurrency and recovery; schema refinement; higher-level normal forms; integrity; security; and database administration development. Prerequisite: 420-411-LA (Business Systems Analysis) & 420-423-LA (Web Programming)
5 hours/week Units: 2.66
Software Testing and Quality Assurance 420-521-LA
(Concentration course for Computer Science students only)
This course is designed to prepare our students who will either assess or be assessed as part of a data center quality system. The focus of the course is to improve information systems and manage resources through careful planning.
Industrial tools will be introduced to demonstrate how to perform a software and data quality assessment (DQA) to evaluate data and provides detailed information on graphical and statistical tools. This course will familiarize students with the process for performing software data quality assessment.
Prerequisite: 350-921-LA - Successful completion of all 420 courses from semester 1 through 4
3 hours/week Units: 1.33
Building Windows and Web Applications 420-522-LA
(Concentration course for Computer Science students only)
This fifth semester course draws in your previous learned skills and introduces Microsoft Visual Studio. Prototyping, modeling, and visual design tools enable you to create modern applications for Windows and the Web. It allows the students to take advantage of new opportunities and capabilities offered by multi-core programming and cloud development tools.
Topics to be discussed are the Windows Azure platform, create Web applications by using Microsoft ASP.NET, JavaScript, Ajax, and Microsoft Silverlight, desktop applications that use Windows Presentation Foundation (WPF) technology and web services developer using WCF and accessing data MS SQL Server 2012 with ADO.NET.
Prerequisite: 420-423-LA (Web Programming) & 420-411-LA (Business Systems Analysis) & 420-323-LA (Game Development)
Computer Science – Legacy to Mobile (Continued)
Final Project 1 – Legacy to Mobile 420-523-LA
(Concentration course for Computer Science students only)
The Final Project sets up a typical environment for the development of a detailed proposal for a software business, multimedia or web related real life system project. The instructor will assist each group of student in choosing an appropriate project topic and in refining the proposal through all stages from initial outline to final formal design specification. The completed proposal will serve as the blue print of the project to be implemented in the Practicum 2 – System implementation. The course involves scheduled milestones, periodic meetings, group discussions, and walkthrough sessions. The Final Project is graded on theory on systems principles and usage of CASE tools and a project document encompassing the milestones completed during the course.
Prerequisite: 350-921 - Successful completion of all 420 courses from semester 1 through 4
7 hours/week Units: 3.33
Mobile Applications Development 420-524-LA
(Concentration course for Computer Science students only)
In this course, you learn about the capabilities of Android tool kit and how to use them to develop mobile applications by using the Eclipse coding approach. The course begins with overviews of mobile development, Android Environment, and Eclipse IDE. You then learn about the essential application programming interfaces (APIs) and tools that enable the development, back-end integration, security, and management of cross-platform mobile applications. This course covers topics that include client-side APIs, user interface (UI) frameworks, integration, authentication techniques, push notification, and deploying and managing applications.
The hands-on lab exercises throughout this course reinforce lecture content by giving you direct experience in working with Android development kit and mobile application development.
Prerequisite: 420-423-LA (Web programming) & 420-323-LA (Game Development)
4 hours/week Units: 2.00
Career Planning (Concentration course for Computer Science students only) 420-526-LA
The course is designed to provide a strong finish to your college career, while introducing you to opportunities in a variety of business environments that depend on information technology in their daily activities. The understanding of industry trends in those businesses and developing verbal, written and visual communication techniques applied to professional situations, including professional development and career planning are covered.
Prerequisite: 412-H22-LA (Social Media for Business) and successful completion of all 420 program courses from semester 1 through 4.
3 hours/week Units: 1.33
Emerging Technologies 420-613-LA
(Concentration course for Computer Science students only)
This course was designed with a focus on some of the major technologies that are already being deployed, as well as those that will be deployable within the next one to three years. The contents are evaluated by the department in a yearly basis in order to cover a new technology or tool.
Prerequisite: 420-523-LA Final Project 1 – Legacy to Mobile
3 hours/week Units: 1.66
Externship – Legacy to Mobile 420-621-LA
(Concentration course for Computer Science students only)
This twelve week work study experience provides the student with the knowledge and skills acquired within a real-world situation, and to become familiar with one company’s approach to the IT industry. Students will gain invaluable work experience and hone their communication, time management, planning and group interaction skills.
Successful completion of all 420 program courses from semester 1 through 5 with the only exception being 1 general education course in either English, Humanities, French, Complementary or Physical Education and not a block-B English, Humanities or French
Computer Science – Legacy to Mobile (Continued)
Final Project 2 – Legacy to Mobile 420-622-LA
(Concentration course for Computer Science students only)
This capstone course provides depth in the application and integration of core system development and implementation concepts. Emphasis is placed on the integration of systems analysis/design techniques learned in the Final Project course with concepts of operating systems, data structures, file and database processing, computer architecture and software engineering. This is a project course that requires significant collaborative in and out-of-class work, written documents and oral presentations. Students will carry out autonomous milestones using different software development tools. Traditional structured programming, scripting programming and/or object oriented programming may be used in the various projects to be implemented.
Prerequisite: 420-523-LA (Final Project 1 – Legacy to Mobile) & 420-513-LA (Database System Administration) & 420-522- LA (Building Windows and Web applications)
6 hours/week Units: 3.00
Comprehensive Assessment / Digital Portfolio 420-623-LA
(Concentration course for Computer Science students only)
The comprehensive assessment requires a successful completion of a digital portfolio, final project (parts 1 and 2) and Stage.
Portfolios are being used as an assessment tool and as a general record of student achievement while studying in our faculty. A portfolio allows students to integrate text and the full range of digital media, including photos, illustrations, data sheets, audio, video recordings, data and information uses in the specific project assignments for each of the courses of the program prior to 6th semester which will be marked according to criterions established by the instructor.
Tool to produce the portfolio component is the use of electronic media software.
Successful completion of all 420 program courses from semester 1 through 5 with the only exception being 1 general education course in either English, Humanities, French, Complementary or Physical Education and not a block-B English, Humanities or French