Computer Programming and Analysis (Optional Co-op)
- Credential:
- Ontario College Advanced Diploma
- College Code:
- CONS
- School:
- Applied Computer Science & Information Technology
- Program Code:
- 0057
- Accelerated Delivery:
- No
- Campus:
- WA
- Academic Year:
- 2020 / 2021
Notice:
Effective September 2020, the title of this program will change. It was formerly titled Computer Programmer/Analyst.Students in this program are required to bring a mobile device that meets minimum specified requirements.
About the Program
Computer Programmer/Analyst is a three-year advanced diploma program in which students learn the latest skills needed by 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. The optional co-op stream includes four consecutive four-month work terms.
For more information, please contact the Program Coordinator at itprograms@conestogac.on.ca.
Program Information
Length: Three-year Ontario College Advanced Diploma programDelivery Sequence:
Waterloo - September/2020 - Fall | Winter | Fall | Winter | Fall | Winter
Waterloo - January/2021 - Winter | Spring/Summer | Fall | Winter | Fall | Winter
Location: Waterloo
Start: September and January
First-Year Capacity: 55 September, 30 January
Admission Requirements
- 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)
- For more information on preparatory programs, visit Academic Upgrading
Applying to the Co-op Stream
- All applicants apply to the non co-op program. Students will be informed of the application deadline and process to apply for the Co-op Stream. Labour market conditions determine the number of co-op seats in optional co-op programs. Every student who meets academic eligibility requirements may not be admitted to the co-op stream.
- To be considered for admission to the co-op stream, students are required to achieve a minimum overall 80% weighted average in Year 1 with a maximum one dropped or failed course during the first year.
Co-op Information
- Co-op programs add value to your education. Earn while you apply what you learn in a real workplace environment. See the Co-op webpages.
- The College cannot guarantee co-op employment. All co-op students are required to conduct an independent co-op job search in addition to the supports and services provided by the Department of Co-op Education.
- Students are responsible for their own transportation and associated costs in order to complete work term requirements. Work locations may not always be readily accessible by public transportation.
Admission Procedures
- 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, and post-secondary course used in the calculation of academic strength.
- A sound mathematical background is important for success in this program and is considered during the admission process. Minimum cutoffs apply.
Program Requirements
- Academic eligibility for a co-op work term is based on the term that occurs two terms prior to any work term. If this term is also a co-op work term, then work term eligibility will be based on the student's achievement during the preceding academic term.
- Should a student's academic performance decline considerably (including cumulative missed courses) during the term just prior to any work term, the college reserves the right to withdraw the student from the upcoming work term.
- In the case of back to back work terms eligibility to participate in consecutive work terms will be granted upon approval to participate in the initial work term.
- Where two or more work terms occur back to back, should a student fail to achieve academic eligibility for the first work term, their eligibility for the second work term will be based on the term that occurs two terms prior to the second work term.
- Students may only fail/defer one work term regardless of the reason(s).
- Students who do not successfully complete their deferred work term will be removed from the co-op stream.
- Since only one work term may be failed/deferred regardless of the reason(s), should a subsequent work term be missed/failed/unsecured (not successfully completed for any reason) the student will be immediately removed from the co-op stream.
- Students who are discontinued are not eligible for co-op work terms.
- To be eligible for a co-op work term, students are required to achieve a minimum 80% session weighted average during the term that occurs two terms prior to the co-op work term with no dropped or failed courses.
- Students in this program are required to bring a mobile device that meets minimum specified requirements.
Tuition & Fees
Tuition fee details for the 2019-2020 year are listed below. Fees for the next academic year are unavailable at this time. Books and supplies are additional.
Non Co-op Program Fees
Estimated fees based upon the previous academic year (2019 / 2020) for Computer Programmer/Analyst - Program # 0057
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| Full-time Program Tuition | $1348.00 | $1348.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $2025.00 | $1702.00 |
| Year Total | $3727.00 |
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| Full-time Program Tuition | $1348.00 | $1348.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $2025.00 | $1702.00 |
| Year Total | $3727.00 |
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| Full-time Program Tuition | $1348.00 | $1348.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $2025.00 | $1702.00 |
| Year Total | $3727.00 |
| Description | Winter 2020 | Spring 2020 |
|---|---|---|
| Full-time Program Tuition | $1348.00 | $1348.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $197.65 | $0.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $18.76 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $1918.41 | $1702.00 |
| Year Total | $3620.41 |
International Fees
Estimated International fees based upon the previous academic year (2019 / 2020) for
Computer Programmer/Analyst - Program # 0057
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| International Program Tuition | $6250.00 | $6250.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ISR | $375.00 | $375.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI International Health Fee | $500.00 | $0.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $7802.00 | $6979.00 |
| Year Total | $14781.00 |
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| International Program Tuition | $6250.00 | $6250.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ISR | $375.00 | $375.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI International Health Fee | $500.00 | $0.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $7802.00 | $6979.00 |
| Year Total | $14781.00 |
| Description | Fall 2019 | Winter 2020 |
|---|---|---|
| International Program Tuition | $6250.00 | $6250.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $295.00 | $0.00 |
| ISR | $375.00 | $375.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $28.00 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI International Health Fee | $500.00 | $0.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $7802.00 | $6979.00 |
| Year Total | $14781.00 |
| Description | Winter 2020 | Spring 2020 |
|---|---|---|
| International Program Tuition | $6250.00 | $6250.00 |
| Technology Enhancement Fee | $135.00 | $135.00 |
| CSI Health Plan Fee | $197.65 | $0.00 |
| ISR | $375.00 | $375.00 |
| ONE Card Fee | $7.00 | $7.00 |
| CSI Legal Protection | $18.76 | $0.00 |
| Capital Development Fee - Waterloo | $48.00 | $48.00 |
| CSI International Health Fee | $335.00 | $0.00 |
| CSI Advocacy Fee | $12.50 | $12.50 |
| CSI Event Fee | $40.00 | $40.00 |
| CSI Student Clubs | $3.50 | $3.50 |
| Locker Fee | $5.00 | $5.00 |
| Alumni Services | $5.00 | $5.00 |
| Student Spaces | $10.00 | $10.00 |
| Graduation fee | $15.00 | $15.00 |
| Academic Support Fee | $18.00 | $18.00 |
| CSI Academic Support Fee | $5.00 | $5.00 |
| Health and Wellness Fee | $20.00 | $20.00 |
| CSI Health and Wellness Fee | $10.00 | $10.00 |
| Career Services Fee | $10.00 | $10.00 |
| CSI Career Services Fee | $10.00 | $10.00 |
| Session Total | $7530.41 | $6979.00 |
| Year Total | $14509.41 |
Co-op Program 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.
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 87% of co-op and non co-op graduates from the last three years (2015 to 2017) found employment within six months of graduation.
For more details on related occupations, job market information and career opportunities, see the Government of Canada website: https://www.jobbank.gc.ca/home
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. 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. 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 Code | Course Title and Description |
|---|---|
| Level 1 | |
| COMM1085 | College Reading & Writing Skills
Description: This course focuses on the reading, writing and critical thinking skills needed for academic and workplace success. Students will analyse, summarize, and discuss a variety of readings and apply the steps of planning, writing, and revising in response to written prompts. This course prepares students for post-secondary writing tasks, research, and documentation. |
| CON0101 | Conestoga 101
Description: This self-directed course focuses on introducing new students to the supports, services, and opportunities available at Conestoga College. By the end of this course, students will understand the academic expectations of the Conestoga learning environment, as well as the supports available to ensure their academic success. Students will also be able to identify on-campus services that support their health and wellness, and explore ways to get actively involved in the Conestoga community through co-curricular learning opportunities. |
| 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 consider competition, target markets, business models and technical challenges in order to gather requirements , storyboard and document the design. |
| 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. |
| 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. |
| 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, looping, decision making, modifying strings and arrays. Particular attention will be paid to problem solving techniques using flowcharting to design the logic of the program. The student will be introduced to techniques of desk checking, testing and debugging. |
| 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. |
| 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. |
| PROG1800 | Programming Dynamic Websites
Description: Recommended: PROG1080 Programming Fundamentals or equivalent knowledge. |
| 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. |
| 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. |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
| Level 3 | |
| 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 |
| PROG2230 | Programming: Microsoft Web Technologies
Description: This course teaches students how to develop web applications using ASP.NET. Students learn how to create dynamic 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 session variables. |
| 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. |
| 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 to develop programming solutions for common accounting and business problems using database and programming skills. |
| Level 4 | |
| 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. |
| INFO2063 | 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. |
| 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. |
| 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. |
| PROG2240 | Programming: JAVA Web Technologies
Description: 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. |
| PROG2430 | 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. |
| Level 5 | |
| 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. |
| 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. |
| 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. |
| 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. |
|
Electives: Program Option
Student must pass 1 Course(s), selected in the Student Portal from available course options | |
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 | The Consulting Developer
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. |
| 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. |
| Level 6 | |
| INFO2300 | Project Development
Description: This course will support software development capstone courses by having students perform case studies in which they analyze real life examples of deliverables from all phases of the Systems Development Life Cycle (SDLC). The studies will draw on such areas as analytical models, human factors, security, software testing, entrepreneurship, help authoring and technical writing. By analyzing professional systems, it is expected that students will be better prepared to implement their own application. |
| INFO3160 | Systems Development: Emerging Technologies
Description: In this seminar course, students research and prepare presentations on topics dealing with information and digital technologies that have recently come to market. They will be required to evaluate the impact of these technologies on existing IT products and services as well as to predict new products and trends that might result from these developments. |
| 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. |
| 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. |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
| Course Code | Course Title and Description |
|---|---|
| Level 1 | |
| COMM1085 | College Reading & Writing Skills
Description: This course focuses on the reading, writing and critical thinking skills needed for academic and workplace success. Students will analyse, summarize, and discuss a variety of readings and apply the steps of planning, writing, and revising in response to written prompts. This course prepares students for post-secondary writing tasks, research, and documentation. |
| CON0101 | Conestoga 101
Description: This self-directed course focuses on introducing new students to the supports, services, and opportunities available at Conestoga College. By the end of this course, students will understand the academic expectations of the Conestoga learning environment, as well as the supports available to ensure their academic success. Students will also be able to identify on-campus services that support their health and wellness, and explore ways to get actively involved in the Conestoga community through co-curricular learning opportunities. |
| 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 consider competition, target markets, business models and technical challenges in order to gather requirements , storyboard and document the design. |
| 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. |
| 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. |
| 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, looping, decision making, modifying strings and arrays. Particular attention will be paid to problem solving techniques using flowcharting to design the logic of the program. The student will be introduced to techniques of desk checking, testing and debugging. |
| 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. |
| 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. |
| PROG1800 | Programming Dynamic Websites
Description: Recommended: PROG1080 Programming Fundamentals or equivalent knowledge. |
| 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. |
| 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. |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
| Level 3 | |
| CEPR1020 | Co-op and Career Preparation
Description: This series of modules will prepare students for job searching for their co-op work terms and for their future careers. Students will familiarize themselves with the co-operative education policies and procedures and will learn the expectations, rules, and regulations that apply in the workplace regarding social, organizational, ethical, and safety issues while developing an awareness of self-reflective practices. Students will reflect on their skills, attitudes, and expectations and examine available opportunities in the workplace. Successful completion of these modules is a requirement for co-op eligibility. |
| 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 |
| PROG2230 | Programming: Microsoft Web Technologies
Description: This course teaches students how to develop web applications using ASP.NET. Students learn how to create dynamic 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 session variables. |
| 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. |
| 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 to develop programming solutions for common accounting and business problems using database and programming skills. |
| Level 4 | |
| 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. |
| INFO2063 | 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. |
| 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. |
| 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. |
| PROG2240 | Programming: JAVA Web Technologies
Description: 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. |
| PROG2430 | 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. |
| Level 5 | |
| COOP2370 | Co-op Work Term I (CPA)
Description: This co-op work term will provide students with college-approved work experience in an authentic, professionally relevant work environment. Students will be provided the opportunity to connect theory and practice by leveraging their academic training to develop a broad base of vocational skills. The practical applications of this work term will promote students' awareness of key concepts and terminology in their field, cultivate their problem-solving and decision-making capabilities, encourage their development of professional autonomy and collaboration, and enhance their capacity to analyze and reflect on their demonstrated abilities in the workplace. |
| Level 6 | |
| COOP3360 | Co-op Work Term II (CPA)
Description: This co-op work term will provide students with college-approved work experience in an authentic, professionally relevant work environment. Students will be provided the opportunity to connect theory and practice by leveraging their academic training to develop a broad base of vocational skills. The practical applications of this work term will promote students' awareness of key concepts and terminology in their field, cultivate their problem-solving and decision-making capabilities, encourage their development of professional autonomy and collaboration, and enhance their capacity to analyze and reflect on their demonstrated abilities in the workplace. |
| Level 7 | |
| COOP3370 | Co-op Work Term III (CPA)
Description: This co-op work term will provide students with college-approved work experience in an authentic, professionally relevant work environment. Students will be provided the opportunity to connect theory and practice by leveraging their academic training to develop a broad base of vocational skills. The practical applications of this work term will promote students' awareness of key concepts and terminology in their field, cultivate their problem-solving and decision-making capabilities, encourage their development of professional autonomy and collaboration, and enhance their capacity to analyze and reflect on their demonstrated abilities in the workplace. |
| Level 8 | |
| COOP3380 | Co-op Work Term IV (CPA)
Description: This co-op work term will provide students with college-approved work experience in an authentic, professionally relevant work environment. Students will be provided the opportunity to connect theory and practice by leveraging their academic training to develop a broad base of vocational skills. The practical applications of this work term will promote students' awareness of key concepts and terminology in their field, cultivate their problem-solving and decision-making capabilities, encourage their development of professional autonomy and collaboration, and enhance their capacity to analyze and reflect on their demonstrated abilities in the workplace. |
| 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. |
| 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. |
| 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. |
| 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. |
|
Electives: Program Option
Student must pass 1 Course(s), selected in the Student Portal from available course options | |
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 | The Consulting Developer
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. |
| 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. |
| Level 10 | |
| INFO2300 | Project Development
Description: This course will support software development capstone courses by having students perform case studies in which they analyze real life examples of deliverables from all phases of the Systems Development Life Cycle (SDLC). The studies will draw on such areas as analytical models, human factors, security, software testing, entrepreneurship, help authoring and technical writing. By analyzing professional systems, it is expected that students will be better prepared to implement their own application. |
| INFO3160 | Systems Development: Emerging Technologies
Description: In this seminar course, students research and prepare presentations on topics dealing with information and digital technologies that have recently come to market. They will be required to evaluate the impact of these technologies on existing IT products and services as well as to predict new products and trends that might result from these developments. |
| 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. |
| 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. |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
|
Electives: General Education
Student must complete a minimum of 42 Hours | |
Program Outcomes
- Identify, analyze, design, develop, implement, verify and document the requirements for a computing environment.
- Diagnose, troubleshoot, document and monitor technical problems using appropriate methodologies and tools.
- Analyze, design, implement and maintain secure computing environments.
- Analyze, develop and maintain robust computing system solutions through validation testing and industry best practices.
- Communicate and collaborate with team members and stakeholders to ensure effective working relationships.
- Select and apply strategies for personal and professional development to enhance work performance.
- . Apply project management principles and tools when responding to requirements and monitoring projects within a computing environment.
- Adhere to ethical, social media, legal, regulatory and economic requirements and/or principles in the development and management of the computing solutions and systems.
- Investigate emerging trends to respond to technical challenges.
- .Gather, analyze and define software system specifications based on functional and non-functional requirements.
- .Design, develop, document, implement, maintain and test software systems by using industry standard software development methodologies based on defined specifications and existing technologies/frameworks.
- .Select and apply object-oriented and other design concepts and principles, as well as business requirements, to the software development process.
- .Gather requirements and model, design, implement, optimize, and maintain data storage solutions.
- .Integrate network communications into software solutions by adhering to protocol standards.
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.Program Handbook
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 the Ontario Colleges.ca International applicant portal. Please note that not all programs are open to international students; check the list of open programs on our International Student Programs web page before applying.
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.
| Start Date | Campus | Status** |
|---|---|---|
| SEP, 2020 | Waterloo | Open |
| JAN, 2021 | Waterloo | Open |
Program status for international students
Program Accreditations
Success Stories
-
Students develop sustainable solutions at annual hackathonStudents pitched innovative solutions to the college community on March 6 at the 4X4 Challenge...
-
VARLab supports student learning and applied researchA cross-departmental collaboration recently provided marketing students with an opportunity to...
-
eText program delivers benefits and savingsSince it was first piloted in 2016, Conestoga’s eText program has grown to involve more than...
-
IT Pitch Night connects students to industry projectsOn January 16, close to 30 businesses pitched technology needs to students in Conestoga’s...