Course Descriptions
|
420-L01-HR
|
Introduction to Programming in Java
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
016W Produce algorithms
0171 Correct programs
|
|
Pre-requisites
|
None
|
|
Description:
|
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 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-V01-HR
|
Programming in Java (Advanced)
|
|
Competencies
|
016T Use an object-oriented development approach
016W Produce algorithms
016X Develop a user interface
0171 Correct programs
0173 Develop conceptual models using a structured approach
|
|
Pre-requisites
|
420-L01-HR Introduction to Programming in .NET
|
|
Description:
|
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 to data files to produce different kinds of business reports. They write simple GUI programs. The programming language Java is used in this course.
|
|
420-L02-HR
|
Introduction to Programming in .NET
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
016W Produce algorithms
016X Develop a user interface
0171 Correct programs
017B Design and develop an application in a database environment
|
|
Pre-requisites
|
None
|
|
Description:
|
This course presents object-oriented programming and Microsoft .NET Framework. Students create .NET applications with controls, and menus. Students create interfaces that are both data and event-driven. The Microsoft .NET Framework fundamentals are presented.
|
|
420-V02-HR
|
Programming in .NET (Advanced)
|
|
Competencies
|
016T Use an object-oriented development approach
016X Develop a user interface
0171 Correct programs
0173 Develop conceptual models using a structured approach
017B Design and develop an application in a database environment
|
|
Pre-requisites
|
420-L02-HR Introduction to Programming in .NET
|
|
Description:
|
In this course students learn advanced object-oriented programming concepts in the .NET Framework. The .NET Framework is covered in more detail including: namespaces, predefined classes and memory management. This course introduces how to connect to a database and to retrieve or update data. Students use controls like the DataGridView to display information from one or multiple database tables.
|
|
420-L03-HR
|
Relational Databases
|
|
Competencies
|
0170 Organize and maintain data
0175 Create and use databases
|
|
Pre-requisites
|
None
|
|
Description:
|
This course provides the foundation of relational database design and modeling techniques. 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. Students also learn to use SQL to create and modify database tables and to retrieve data from a database. Students learn the principles of transaction processing, database security and distributed database management.
|
|
420-V03-HR
|
Structured Query Language
|
|
Competencies
|
016S Use a structured programming language
016W Produce algorithms
0170 Organize and maintain data
0175 Create and use databases
|
|
Pre-requisites
|
420-L03-HR Relational Databases
|
|
Description:
|
This course provides advanced details of SQL as well as T-SQL and PL/SQL. Students use this knowledge to create Store Procedures in a database.
|
|
420-Q01-HR
|
Career Preparation
|
|
Competencies
|
CW09 To successfully enter the labour market and utilize acquired technical Skills
|
|
Pre-requisites
|
None
|
|
Description:
|
Through hands-on workshops and seminars delivered through industry, students develop a peer-networking group. They also develop a credible résumé targeting the web/IT industry. They learn the importance of establishing and maintaining industry relationships, communication skills when dealing effectively with individuals and the concept of teamwork. Students will develop skills in recognizing and interpreting clients’ needs and be prepared upon completion to make the transition from student to industry professional.
|
|
420-R01-HR
|
Web Page Design
|
|
Competencies
|
016X Develop a user interface
0173 Develop conceptual models using a structured approach
0178 Use multi-media processing utilities
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
None
|
|
Description:
|
Students are introduced to web design, HTML, XHTML, and Cascading Style Sheets (CSS). They build web sites using a text editor and using a web authoring tool. Students learn how to use graphics, typography, colour, navigation, and forms and how 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.
|
|
420-R01-HR
|
Web Page Design
|
|
Competencies
|
016X Develop a user interface
0173 Develop conceptual models using a structured approach
0178 Use multi-media processing utilities
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
None
|
|
Description:
|
Students are introduced to web design, HTML, XHTML, and Cascading Style Sheets (CSS). They build web sites using a text editor and using a web authoring tool. Students learn how to use graphics, typography, colour, navigation, and forms and how 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.
|
|
420-W01-HR
|
JavaScript with Libraries
|
|
Competencies
|
016S Use a structured programming language
0171 Correct programs
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-R01-HR Web Page Design
|
|
Description:
|
Students begin to develop web applications. They use JavaScript, JavaScript libraries and AJAX, to create interactive web sites. They also learn to develop Rich Internet Applications using emerging web technologies. Students learn how to create well-formed and valid XML documents.
|
|
420-W11-HR
|
Server-side Scripting with PHP
|
|
Competencies
|
016S Use a structured programming language
016W Produce algorithms
0171 Correct programs
017B Design and develop an application in a database environment
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-R01-HR Web Page Design
|
|
Description:
|
Students learn about server-side development. They develop and deploy web applications using a server-side scripting language on both Windows and Linux servers. They continue to learn about emerging web technologies. The programming language PHP is used in this course.
|
|
420-X21-HR
|
Server-side Scripting with Java Server Pages and Servlets
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
0171 Correct programs
0173 Develop conceptual models using a structured approach
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-W11-HR Server-side Scripting with PHP
|
|
Description:
|
Students continue to learn about server-side development. They develop and deploy applications using Java Server Pages and Servlets and deploy them to a web server in Windows and Linux. They develop applications using the Model-View-Controller (MVC) architecture.
|
|
420-W21-HR
|
Web Applications in .NET
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
016W Produce algorithms
016X Develop a user interface
0171 Correct programs
0173 Develop conceptual models using a structured approach
017B Design and develop an application in a database environment
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-R01-HR Web Page Design
|
|
Description:
|
Students learn to develop ASP.NET Web applications. The course focuses on user interface, web site structure, web site functionality and implementation details. Students learn to connect to databases and learn the connected and disconnected styles of interacting with a database.
|
|
420-X22-HR
|
Advanced Web Applications and Web Services
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
016W Produce algorithms
0171 Correct programs
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-W21-HR Web Applications in .NET
|
|
Description:
|
Students learn to create well-formed and valid XML documents and schemas, to display XML data in a web browser, and to transform XML data into different formats. They learn about AJAX technology and are introduced to a framework for building applications using service oriented architecture. They develop applications that create and consume web services in .NET.
|
|
420-Y23-HR
|
Final Integrated Project
|
|
Competencies
|
016S Use a structured programming language
016T Use an object-oriented development approach
016W Produce algorithms
016X Develop a user interface
0171 Correct programs
0173 Develop conceptual models using a structured approach
017B Design and develop an application in a database environment
017D Design and develop a hypermedia application within internal and global networks
|
|
Pre-requisites
|
420-L01-HR Introduction to Programming in Java
420-V01-HR Programming in Java (Advanced)
420-L02-HR Introduction to Programming in .Net
420-V02-HR Programming in .Net (Advanced)
420-L03-HR Relational Databases
420-V03-HR Structured Query Language
420-R01-HR Web Page Design
420-W01-HR JavaScript with Libraries
420-W11-HR Server-side Scripting with PHP
420-X21-HR Server-side Scripting with Java Server Pages and Servlets
420-W21-HR Web Applications in .Net
420-X22-HR Advanced Web Applications and Web Services
|
|
Description:
|
Students use the skills they have learned over in the duration of the course to produce a final project which incorporates the skills from all the courses. The result is a single system which consists partly of a desktop application and partly of the web application. The system must gather and use data from a database.
|
|
420-Z01-HR
|
Work Term
|
|
Competencies
|
00V6 Workplace integration
|
|
Pre-requisites
|
All courses in the program
|
|
Description:
|
This course introduces students to the reality of the new work relationship during a 370-hour placement in an organization outside the College. Students will continue to learn and practice the new knowledge, skills and abilities acquired in the program at the host organization.
|
|
|
