Conestoga College Logo - Home Page

Computer Programmer/Analyst (Optional Co-op)

Credential:
Ontario College Advanced Diploma
College Code:
CONS
School:
Engineering & Information Technology
Program Code:
0057C
Accelerated Delivery:
No
Campus:
DO
Academic Year:
2017 / 2018

About the Program

Computer Programmer/Analyst is a three-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 semester in which students can build a major business application for a local business, providing them with a realistic, practical experience.

Students who meet specific performance criteria in Year 1 will be eligible to transfer to the co-op version of this program for Year 2. The co-op component consists of four consecutive work terms (16 months in total) after the second year of studies. These work terms can be completed in business, industry, government or charitable organizations. An entrepreneurial work term in which the student explores development of a product or service may also be possible where certain criteria are met.

For more information contact the Program Coordinator at itprograms@conestogac.on.ca.

Program Information

Length: Three-year Ontario College Advanced Diploma program
Location: Doon (Kitchener)
Start: September
First-Year Capacity: 48 September, 10 January

Admission Requirements

Admission Requirements for Co-op Option

Admission Procedures

Tuition & Fees

Domestic fees are currently unavailable; please check back at a later time.

Financial Assistance

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. Students can also print the application booklet through the OSAP website.

For more information, please visit Financial Services/Awards.

Co-op Information

Graduate Opportunities

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.

On average, 95% of graduates from the last three years (2013 to 2015) found employment within six months.

For more details on related occupations, job market information and career opportunities, see the Government of Canada website: http://www.workingincanada.gc.ca

Pathways & Credit Transfer

Conestoga pathways enable students to build on their academic achievements in order to earn a degree or additional credential. Pathways are formed through agreements between Conestoga programs or partner institutions. View the transfer agreement opportunities for this program.

Often applicants have earned credits from another college or university that may allow a student to be granted advanced standing or exemption. Learn more about credit transfer opportunities at Conestoga.

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.

Learn more about PLAR.

Program Courses

Course Details for 2017 / 2018
Course Code Course Title and Description
Level 1
COMM1030 Interpersonal And Group Dynamics

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: 42
Credits: 3
Pre-Requisites:
CoRequisites:

COMM1085 College Reading & Writing Skills

Description:
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

INFO1265 User Experience

Description: Because of the proliferation of different types of devices, the growing range of digital user interface technologies, and the increasingly competitive nature of the software industry, high-tech companies have come to understand the growing importance of the User Experience, and to value skilled professionals in this area. Thus, students are introduced to best current practices in interactive design, and will solve a series of design problems which draw on different types of devices and varying types of navigation controls, as applied to business and commercial applications. Students will also develop a design project based on a topic of their choice, working through the phases of conception, requirements gathering, addressing technical challenges, storyboarding, documenting and testing the design.
Hours: 45
Credits: 3
Pre-Requisites:
CoRequisites:

MATH1910 Mathematics for Information Technology I

Description: The purpose of the course is to provide students with a sound mathematical foundation for logical reasoning and problem solving. The course stresses computer and business applications using equations, logic, sets, vectors, and data structures. The course includes applications such as cost-volume-profit analysis. The course is designed for IT students to help them translate everyday real world scenarios into mathematical concepts they can solve with computer systems and applications.
Hours: 45
Credits: 3
Pre-Requisites:
CoRequisites:

PROG1245 Programming: Web Foundations

Description: In this course, students develop the skills needed to build static web sites. This includes facility with coding HTML, XHTML, and CSS, as well as the insertion of graphics and video into web sites.
Hours: 60
Credits: 4
Pre-Requisites:
CoRequisites:

PROG1781 Programming Concepts I

Description: Software development programs depend on a strong foundation in programming concepts and logic. In order to develop programs that solve business problems, the student will use the programming concepts of data types, record structures, arrays, and sequential files. 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: 60
Credits: 4
Pre-Requisites:
CoRequisites:

Level 2
INFO1380 Technology Infrastructure: Networking

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 networking concepts including protocols, topologies, transmission media and security, using hands-on examples of networking issues.
Hours: 45
Credits: 3
Pre-Requisites:
CoRequisites:

MATH1920 Mathematics for Information Technology II

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:

PROG1800 Programming Dynamic Websites

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 PROG1781 or PROG1783
CoRequisites:

PROG1815 Programming Concepts II

Description: This course bulids on the fundamental logic skills of Programming Concepts I, and adds conceptual skills in order to develop software applications according to current best industry practices. The student will do assignments making use of Graphical User Interfaces (GUI) to create a higher level of interactivity, and will employ the "object" concept - classes, objects, data-hiding, inheritance, polymorphism - in order to promote better system modelling, modularity, and reusablity.
Hours: 60
Credits: 4
Pre-Requisites: PROG1781
CoRequisites:

PROG1825 Introduction to Data Modelling

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: 45
Credits: 3
Pre-Requisites:
CoRequisites:

Electives: General Education
Student must complete a minimum of 42 Hours
Level 3
ACCT1025 Introduction to Accounting

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: 42
Credits: 3
Pre-Requisites:
CoRequisites:

CDEV1020 Co-op and Career Preparation

Description: This mandatory course prepares students for job searching for their co-op work terms and for post-graduate careers. Students will reflect on their skills, attitudes, and expectations and evaluate and interpret available opportunities in the workplace. Self-marketing techniques using resumes, cover letters, cold-calls, and interviewing will be learned and students will learn the expectations, rules, and regulations that apply in the workplace with regards to social, organizational, ethical, and safety issues while developing an awareness of self-reflective practice.
Hours: 16
Credits: 1
Pre-Requisites:
CoRequisites:

INFO2320 Systems Analysis and Design

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 (UML). An object-oriented approach will be applied to a business system case study utilizing a Computer Assisted Systems Engineering tool to analyze the systems requirements and then to use the tool to design a proposed solution from those requirements. Emphasis will be placed on typical industry practices, documentation and presentation skills in a team environment
Hours: 75
Credits: 5
Pre-Requisites: PROG1815
CoRequisites:

PROG2220 Database: S.Q.L.

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:
CoRequisites:

PROG2230 Programming: Microsoft Web Technologies

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: PROG1245, PROG1780 or PROG1781 or PROG1783 or PROG8010
CoRequisites:

PROG2370 Game Programming with Data Structures

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 or PROG1781 or PROG1783
CoRequisites:

PROG2390 Small Business Solutions

Description: Rapid growth and fragmentation of business as a result of new computer technologies has meant that there is a growing number of small businesses and start-ups. Many of these companies look to inexpensive solutions for their business needs. In this course, students get hands-on assignments in which they software tools to develop affordable solutions to classical business problems such as purchasing, sales, inventory and human resource functions.
Hours: 45
Credits: 3
Pre-Requisites: PROG1825
CoRequisites:

Level 4
INFO2040 Systems Development: Mobile Application Design

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:
CoRequisites:

INFO2050 Systems Development: Computer Security

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: PROG1800
CoRequisites:

INFO2060 Technology Infrastructure: Network Operating Systems

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:

INFO2300 Project Development

Description:
Hours: 30
Credits: 2
Pre-Requisites: INFO2320, PROG2220
CoRequisites:

PROG2070 Programming: Software Quality Assurance

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: PROG2370
CoRequisites:

PROG2240 Programming: JAVA Web Technologies

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: PROG1800, PROG2370
CoRequisites:

PROG3180 Programming: Mobile Applications I

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: PROG1800, PROG1825
CoRequisites:

Level 5
COOP2370 Co-op Work Term I (CPA)

Description: This course will provide students will college-approved work experience in an information technology environment. This course will increase the student's understanding of employer expectations with regards to attitudinal, practical, and academic skills. These skill areas will be improved during the work term while the student responsibly performs the duties as defined in the job description, in accordance with course and program outcomes. Student development will be evaluated during and at the conclusion of the work experience.
Hours: 420
Credits: 14
Pre-Requisites: CDEV1020
CoRequisites:

Level 6
COOP3360 Co-op Work Term II (CPA)

Description: This course will provide students will college-approved work experience in an information technology environment. This course will increase the student's understanding of employer expectations with regards to attitudinal, practical, and academic skills. These skill areas will be improved during the work term while the student responsibly performs the duties as defined in the job description, in accordance with course and program outcomes. Student development will be evaluated during and at the conclusion of the work experience.
Hours: 420
Credits: 14
Pre-Requisites: CDEV1020
CoRequisites:

Level 7
COOP3370 Co-op Work Term III (CPA)

Description: This course will provide students will college-approved work experience in an information technology environment. This course will increase the student's understanding of employer expectations with regards to attitudinal, practical, and academic skills. These skill areas will be improved during the work term while the student responsibly performs the duties as defined in the job description, in accordance with course and program outcomes. Student development will be evaluated during and at the conclusion of the work experience.
Hours: 420
Credits: 14
Pre-Requisites: CDEV1020
CoRequisites:

Level 8
COOP3380 Co-op Work Term IV (CPA)

Description: This course will provide students will college-approved work experience in an information technology environment. This course will increase the student's understanding of employer expectations with regards to attitudinal, practical, and academic skills. These skill areas will be improved during the work term while the student responsibly performs the duties as defined in the job description, in accordance with course and program outcomes. Student development will be evaluated during and at the conclusion of the work experience.
Hours: 420
Credits: 14
Pre-Requisites: CDEV1020
CoRequisites:

Level 9
PROG3050 Programming: Microsoft Enterprise Applications

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:

PROG3170 Programming: Distributed Applications Development

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: PROG2230, PROG2370
CoRequisites:

PROG3200 Database: Application Development

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:

PROG3210 Programming: Mobile Applications II

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:

Electives: Program Option
Student must pass 1 Course(s)
View Program Option Electives

Please note that all courses may not be offered in all semesters. Go to your student portal for full timetabling details under "My Courses".

INFO3070 Systems Development: Information Technology Management

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:

PROG3240 Business Intelligence

Description: Successful businesses in today's high-tech environment use business intelligence to gain a competitive advantage. This course introduces some of the methodologies and technologies used in the analysis of large amounts of historic data. Topics covered include data visualization, data warehousing, online analytical processing and data mining. Practical use of these technologies are presented in the context of descriptive, predictive and prescriptive analytics.
Hours: 45
Credits: 3
Pre-Requisites: PROG2110 or PROG2220
CoRequisites:

Level 10
INFO3165 Architecture for Emerging Technologies

Description: New methodologies and technologies are regularly increasing the power of computers, networks and applications. Students are given analysis, design and programming assignments that explore these various architectures. They will build on this knowledge to explore new technologies, evaluate their potential, and incorporate them into software designs and system specifications.
Hours: 30
Credits: 2
Pre-Requisites: PROG3180
CoRequisites:

INFO3220 Systems Project

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: 60
Credits: 4
Pre-Requisites: INFO2040, PROG2240, PROG3050, PROG3200, PROG3180, INFO2050
CoRequisites:

PROG3060 Programming: Java Enterprise Applications

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 42 Hours

Program Outcomes

Software Downloads

  • Students and instructors in a full-time science, technology, engineering or mathematics program are entitled to a number of additional Microsoft software packages through Conestoga's Microsoft Partner Agreement.
  • Your login information will determine what programs you have access to download.

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.

Apply Now

Domestic students should apply online at www.ontariocolleges.ca or by phone at 1-888-892-2228.

ONTARIOCOLLEGES.CA
60 Corporate Court
Guelph, Ontario
Canada N1G 5J3

Detailed steps on the application process may help you to apply.

International students should apply online using a Conestoga College International Application Form. Please note: not all programs are open to international students. Interested students should check the listing of open programs on our international students web page before applying.
For program information, call the Information Centre at 519-748-5220 ext 3656.

Disclaimer

The College reserves the right to alter information including requirements and fees and to cancel at any time a program, course, or program major or option; to change the location and/or term in which a program or course is offered; to change the program curriculum as necessary to meet current competencies in the job market or for budgetary reasons; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations, over-acceptance of offers of admission, budgetary constraints, or for other such reasons. In the event the College exercises such a right, the College’s sole liability will be the return of monies paid by the applicant or student to the College.

Students actively registered in cohort delivered programs who take longer than the designed program length of time to complete their studies are accountable for completing any new or additional courses that may result due to changes in the program of study. Unless otherwise stated, students registered in non-cohort delivered programs must complete the program of study within seven years of being admitted to the program.

PROGRAM SEARCH


Videos

Engineering and Information Technology at Conestoga College video
More videos

Success Stories

Back To Top