Comments and
Suggestions
We welcome your comments
and suggestions. Please do
not hesitate to let us know.

Web and Desktop Programming (LEA.25)

Course Descriptions


420-NA1-HR Introduction to Programming
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-V11-HR Advanced Programming
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-NA1-HR Introduction to Programming
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-N02-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-N02-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-N03-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-N03-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-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-Y22-HR Server-side Scripting
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-NA1-HR Introduction to Programming
420-V11-HR Advanced Programming
420-N02-HR Introduction to Programming in .Net
420-V02-HR Programming in .Net (Advanced)
420-N03-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-Y22-HR Server-side Scripting
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-Z11-HR Work Term
Competencies 00V6 To successfully enter the labour market and build a career
Pre-requisites All courses in the program
Description: This course introduces students to the reality of the new work relationship during a 375-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.