Computer Programmer/Analyst is a 3 year advanced diploma program in which students learn the latest skills needed by business application developers in industry. The program emphasizes problem solving skills using the latest versions of Microsoft, Oracle, Java and open source software to develop enterprise, Internet and mobile applications. Object-oriented analysis, design, agile methodologies and programming techniques are mastered and applied throughout the program.
Students learn through a combination of theory and practice, applying their knowledge to hands-on assignments and challenging projects. Complementary courses in areas such as mathematics, accounting and communications support the core IT courses. All of these skills are then applied to a capstone group project in the last year, in which students build a major business application for a local business, providing students with a realistic, practical experience. In addition, Co-op students complete 8 months of work experience in the Information Technology industry.
Length: Three-year Ontario College Advanced Diploma program Delivery Sequence: Doon (Kitchener) - September/2013 (Waitlist) - Fall | Winter | Fall | Winter | Fall | Winter Location: Doon (Kitchener) Start: September First-Year Capacity: 48 Tuition: Please refer to Program Fee Chart for information *Fees are higher for international students on a Student Visa. *Recreation/Athletics, Graduation/Alumni, Insurance, as well as program-related costs such as books and supplies are additional.
Apply object-oriented analysis, design and programming techniques to the creation of business applications.
Use a variety of languages, technologies, tools and products to design, develop and test databases access for business applications.
Use a variety of languages, technologies and tools to design, develop and test advanced business web sites.
Use a variety of languages, technologies and tools to design, develop and test wireless applications.
Use the C# language and the latest tools to design, develop and test computer video games.
Design, develop and test enterprise grade multi-tier business applications.
Use the latest technologies and techniques to develop Service Oriented Architecture (S0A) and cloud computing solutions.
Perform system management with a variety of common operating systems.
Perform basic network administration.
Apply formal testing techniques to all phases of systems development.
Examine the operations, security requirements and control procedures of a systems organization
Communicate effectively in speech and writing
Work effectively as a member of a team.
Plan and monitor projects.
Interpret and apply basic concepts in organizational behaviour and management of human resources.
Apply business mathematics and statistics to business applications.
Apply basic accounting concepts to business applications.
Analyze user needs, then design, develop and implement business applications to satisfy the needs of business clients for the capstone project and co-op work terms.
Ontario Secondary School Diploma (OSSD) or equivalent or 19 years of age or older with mature student status. (See Mature Student Definition for details.)
Grade 12 compulsory English, C or U, or equivalent, OR Conestoga College Preparatory Communications (COMM1270).
Grade 12 Mathematics, C or U, or equivalent OR Conestoga College Preparatory Mathematics (MATH1375).
English and/or mathematics testing may be required.
An academic strength is calculated by averaging the submitted marks of required subjects. If more than one mark is received for a required subject, the highest mark will be used in the calculation.
Ten (10) additional marks are added to each Advanced level, OAC, U, U/C course used in the calculation of academic strength.
Twenty (20) additional marks are added to each post-secondary course used in the calculation of academic strength. Please note: Beginning with the application cycle for fall 2014, post-secondary courses used in the calculation of academic strength will receive a bonus of ten (10) marks.
A sound mathematical background is important for success in this program and is considered during the admission process. Minimum cutoffs apply.
For program information call the Information Centre for details at 519-748-5220 ext. 3656.
Prior Learning Assessment and Recognition (PLAR)
Conestoga recognizes prior learning of skills, knowledge or competencies that have been acquired through employment, formal and informal education, non-formal learning or other life experiences. Prior learning must be measurable at the required academic level and meet Conestoga standards of achievement for current courses. Challenge exams and portfolio development are the primary methods of assessment. Other methods of assessment may be available depending upon the nature of the course objectives. Successful completion of the assessment results in an official course credit that will be recorded on the student's Conestoga transcript. PLAR cannot be used by registered Conestoga students for the clearance of academic deficiencies, to improve grades or to obtain admission into a program.
Description: In this introductory level course, students learn to apply knowledge from interpersonal relations and group dynamics to working in a team. Emphasis will be placed on utilizing effective communication skills with individuals and groups. Group cohesiveness and group decision-making will be discussed. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: Recommended: The course content is based on the assumption that students can demonstrate competency in the use of the English language.
NOTE: This course does not qualify for a General Education exemption.
This level-one course is designed to introduce students to industrial and business communications. Emphasis is placed on analyzing audience, determining purpose and effective ordering of ideas for various written communications such as letters and memoranda in the technical environment. As well, all students are expected to participate in group work throughout the semester and are expected to give an oral presentation. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: The purpose of the course is to provide the student with a mathematical basis for personal and business financial decisions and mathematics of computer applications. The course stresses business applications using arithmetic, algebra, ratio-proportion and graphing. Applications include payroll, cost-volume-profit analysis and merchandising mathematics. Information technology topics include logic and Boolean algebra. This course stresses logical reasoning and problem solving skills. A Texas Instrument BAII ?Plus? calculator is required for the course. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: The student will use a Graphical User Interface based programming language to develop programs to solve business problems. The programming concepts of data types, record structures, arrays, event driven processes and sequential files will be introduced. Particular attention will be paid to problem solving techniques such as pseudo code and flowcharting to design the logic of the program. The student will be introduced to techniques of desk checking, testing and debugging. Hours: 90 Credits: 6 Pre-Requisites: CoRequisites:
Description: This course will provide the student with the knowledge to conduct meaningful dialogue with the network specialists who design, install and maintain the network within their organization. The student will be introduced to broad, vendor-independent networking concepts. Students will cover a wide range of material including: networking concepts, protocols, topologies, transmission media and security, by examining real-world examples of networking issues. This course maps to Network+ certification objectives by CompTIA. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: Upon completion of this course, the student will understand the Systems Development Life Cycle and the Object-Oriented Analysis methodology using the Unified Modeling Language. An object-oriented approach will be applied to a business system case study utilizing a Computer Assisted Systems Engineering tool to analyse the systems requirements. Emphasis will be placed on typical industry practices, documentation and presentation skills in a team environment. Hours: 60 Credits: 4 Pre-Requisites: PROG1780 CoRequisites:
Description: The purpose of the course is to provide the student with a mathematical basis for personal and business financial decisions, and mathematics of computer applications. Financial topics include: simple interest, simple discount, compound interest, annuities and their applications including loans and investments. Information technology topics include number systems and sets. A Texas Instrument BAII ?Plus? financial calculator is required. Hours: 45 Credits: 3 Pre-Requisites: MATH1910 CoRequisites:
Description: This course introduces the student to the concepts of database management. The student will learn how to design and develop database applications. The course will introduce the following topics: data types, table relationships, data normalization, entity relationship diagrams, table navigation and data entry control. Hours: 75 Credits: 5 Pre-Requisites: PROG1780 CoRequisites:
Description: Recommended: PROG1080 Programming Fundamentals or equivalent knowledge. This course introduces the student to web-based applications development using browser based development tools. The students will program both client and server-side scripting inside of HTML forms. Hours: 60 Credits: 4 Pre-Requisites: PROG1780 or PROG8005 or PROG8090 CoRequisites:
Description: This course introduces the non-accounting student to the subject of Accounting. It is designed to teach the student an essential life skill. The course focuses on the logic of accounting principles and relates it to the financial well being of the student. The student will learn a basic understanding of accounting that can be used in both their personal life and business career. This course introduces ASPE, IFRS, accounting terminology, the accounting equation, the double-entry system of bookkeeping, the accrual basis of accounting, financial statements and financial analysis and the ledgers and journals making up a basic accounting system for both sole proprietorship and corporation forms of businesses. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: Upon completion of this course, the student will understand the Systems Development Life Cycle and the Object-Oriented Design methodology using the Unified Modeling Language. An object-oriented approach will be applied to a business system case study utilizing a Computer Assisted Systems Engineering tool to design a proposed solution from the requirements prepared in the Systems Development: Analysis course. Emphasis will be placed on typical industry practices, documentation and presentation skills in a team environment. Hours: 60 Credits: 4 Pre-Requisites: INFO2070 or INFO8000 CoRequisites:
Description: Recommended: COMP1120 Access or equivalent knowledge. This course introduces the student to Structured Query Language using an industry standard database management system. The topics discussed include Data Definition Language, Data Management Language and testing and debugging techniques. Hours: 45 Credits: 3 Pre-Requisites: PROG1790 CoRequisites:
Description: This course teaches students how to develop Web Applications using ASP.NET. Students learn how to dynamically create web pages using data from a relational database and how to update data on a relational database with information provided by the user through a web form. The students will use application-wide variables, code and style sheets, object-oriented constructs, classes, and sessional variables. Hours: 75 Credits: 5 Pre-Requisites: INFO1570 or PROG1780 CoRequisites:
Description: This course teaches object oriented C# programming through the creation of computer games. Students learn how to create games using the latest development technology. Standards, testing, documentation and practical object-oriented programming techniques are emphasized. Hours: 75 Credits: 5 Pre-Requisites: PROG1780 CoRequisites:
Description: This course will build on the Systems Development: Design course (INFO2080) to apply software design concepts to mobile applications. Students will be introduced to best current practices in interactive design, and will solve a series of design problems which illustrate the unique qualities of a mobile device, which may include a small screen, a limited keyboard, a touchscreen, and varying types of navigation controls. Students will also be required to develop a design project, working through the phases of conception, requirements gathering, addressing technical challenges, storyboarding, documenting and testing the design. Hours: 45 Credits: 3 Pre-Requisites: INFO2080 CoRequisites:
Description: In this course, students will investigate threats to computer business applications from a variety of sources, as well as strategies for handling those threats. Topics will include encryption, SQL injections, URL backdoors, malware, wireless and cloud computing vulnerabilities, code level security, physical security, disaster recovery and backup, and privacy considerations. Hours: 45 Credits: 3 Pre-Requisites: PROG2230 CoRequisites:
Description: In this course, students will learn how to administer network operating systems such as Microsoft's Windows Server and Red Hat's Linux. They will create user accounts, assign users to groups and control access to server-based files and folders. They will also configure server-based services such as web services, database services, DHCP, DNS, and RRAS or routing. Hours: 45 Credits: 3 Pre-Requisites: INFO1030 CoRequisites:
Description: Software quality is everybody's job, no matter what their role in a software product development or IT organization. In this course, we will explore various approaches to testing and improving software quality. We will also learn techniques, practices and tools that programmers employ to achieve higher quality of software products. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: Prerequisite: Programming: Web Fundamentals (60253501) Building on Programming: Web Fundamentals, this course teaches the student to build Web applications using the Java development environment. The student will learn server side development including session management, database access, testing, debugging and exception handling. Hours: 45 Credits: 3 Pre-Requisites: CoRequisites:
Description: This course teaches the student to build mobile applications using the current industry practices and tools. The student will learn client-side smart device development including offline data access, testing, debugging, security, deployment and exception handling. Students will be exposed to writing mobile client software that runs on popular mobile devices. Hours: 45 Credits: 3 Pre-Requisites: PROG2220 CoRequisites:
Description: This course provides the student with an overview of the ?best practices? in information technology operations management and project management. Topics such as planning, policy, code of conduct, security, audit and various controls will be presented from an information technology perspective. Hours: 45 Credits: 3 Pre-Requisites: INFO2080 CoRequisites:
Description: This course provides a bridge between previous programming courses and Systems Development: Systems Project. It builds on previous courses to teach end-to-end development of realistic business applications. Working with an existing case study, students work in teams to implement a complete, complex enterprise application. The finished application is expected to satisfy all design goals, conform to standards, be thoroughly tested, have complete documentation, and be ready to deploy. Hours: 75 Credits: 5 Pre-Requisites: PROG2370 CoRequisites:
Description: This course teaches students how to develop business applications that are distributed over more than one computer. Topics covered include distributing n-tier applications across multiple computers, creating and consuming business-to-business services, Service Oriented Architecture (SOA) and cloud computing. Microsoft Windows Communication Foundation (WCF) will be used for programming tasks, but the significance of vendor-neutral standards and protocols will be emphasized. Hours: 45 Credits: 3 Pre-Requisites: PROG2370, PROG2230 CoRequisites:
Description: Building on Database: Fundamentals, this course introduces techniques used in developing client server database applications including triggers, stored procedures, form generation, report generation and script generation from Entity Relationship Diagrams. Particular attention is paid to Data Definition Language, Data Management Language and data migration. Hours: 45 Credits: 3 Pre-Requisites: PROG2220 CoRequisites:
Description: This course builds on Programming:Mobile Applications I to teach the student to build mobile applications, including client-side, mobile web and hybrid applications, using advanced programming techniques and current development tools. Students will develop mobile application software that runs on a range of smartphobne and tablet devices. Hours: 60 Credits: 4 Pre-Requisites: PROG3180 CoRequisites:
Description: This second level course is designed to further students' abilities in technical communications. Emphasis is placed on analyzing audience, determining purpose and effective ordering of ideas for various written communications such as informal and formal reports, user manuals, digital media, and proposals in a technical work environment. As well, all students are expected to participate in group work throughout the semester and are expected to give oral presentations. Hours: 45 Credits: 3 Pre-Requisites: COMM1180 CoRequisites:
Description: This course is the culmination of the program. Successful completion of this course will require the application of skills learned in most of the courses studied in the prior semesters. Small groups of students are to work as a team to plan, design, code, document and install a custom application for a client. A faculty advisor will meet regularly with the group to ensure the process is properly managed and a plan is followed. Hours: 90 Credits: 6 Pre-Requisites: INFO2040, INFO2050, PROG2070, PROG3180, PROG3200, PROG2240, PROG3050 CoRequisites:
Description: Building on Programming: Java Web Technologies, the student will use Java and Java compatible tools to develop distributed applications incorporating techniques to support security and transaction management using a tiered architecture. Best practices in deployment, testing and debugging will be emphasized. Hours: 45 Credits: 3 Pre-Requisites: PROG2240 CoRequisites:
Electives: General Education
Student must complete a minimum of 36 Hours
Electives: General Education
Student must complete a minimum of 36 Hours
Students graduate with programming experience and the skills necessary to analyze and design computer applications for business. Entry level positions for graduates of this program include computer programmer, web application developer, software tester and quality control professional. In addition to these, career path opportunities would include systems analyst and business analyst.
67% of 2010-2011 graduates found employment within 6 months of graduation.
For more details on related occupations, job market information and career opportunities see the Government of Canada web site: http://www.workingincanada.gc.ca
The Ontario Student Assistance Program (OSAP) is a needs based program designed to help Ontario students cover the cost of post-secondary education. Funded by the federal and provincial governments, OSAP is intended to promote equality of opportunity for post-secondary studies through direct financial assistance for educational costs and living expenses. These interest-free loans are intended to supplement your financial resources and those of your family. The majority of students apply for loan assistance via the OSAP website: http://osap.gov.on.ca. Students can also print the application booklet through the OSAP website.
For more information, please visit Financial Aid/Awards.
Program Advisory Committees
The College appoints Program Advisory Committee members for diploma, degree, certificate and apprenticeship programs. Committees are composed of employers, practitioners and recent program graduates. College representatives (students, faculty, and administrators) are resource persons. Each committee advises the Board on the development of new programs, the monitoring of existing programs and community acceptance of programs.
For a list of the current members, please visit our Program Advisory Committees.