Connected successfully
Program Outline: Major COPA - Computer Programmer Analyst

COMPUTER PROGRAMMER ANALYST

Program Outline

Major: COPA

Length: 3 Years

Delivery: 6 Semesters, plus 3 work terms

Credential: Ontario College Advanced Diploma, Co-op

Effective: 2011-2012

Location: Barrie

Start: Fall + Winter

Other:

Program Fees

Program Availability (ontariocolleges.ca link will require a search for COPA)

Description

This program is designed to meet the academic needs of all students, whether a recent secondary school graduate, college or university graduate, or a mature student.

Students may elect to complete different levels of development:

* graduating with the two-year diploma as a Computer Programmer; or

* completing this three-year diploma as a Computer Programmer Analyst; or

* transferring to a post-diploma after completing the 2-year or 3-year diploma; or

* completing this three-year diploma and transferring to university to complete a degree in Computer Science or Information Technology.

As students progress through the three years, the courses they take will help them gain insight and experience in the fields in which they may choose to apply their computer skills after graduation.

A structured approach to problem solving, effective oral and written communications, and attention to standards and documentation are stressed throughout.

Industry trends and requirements are continually monitored to ensure curriculum remains current and relevant.

Career Opportunities

Graduates with programming interests/skills will be prepared to work independently or as a member of a team to analyze, design, enhance, and maintain application systems, as well as participate in the management of the activities and personnel involved in an application development project in many types of organizations, including government.

In addition, graduates may be employed in related areas such as the marketing of computer products, information centers and help desks, business analysis, project management, operating systems support, education, computer operations, database design/management/administration, data communications and networking, technical support specialist, network administration, office automation, consulting, technical writing, and web page design/development.

Program Learning Outcomes

The graduate has reliably demonstrated the ability to:

  • communicate clearly, concisely and correctly in the written, spoken, and visual form that fulfills the purpose and meets the needs of the audience;
  • interact with others in groups and teams, use critical thinking skills to evaluate and solve problems, communicate confidently in a variety of situations, and demonstrate technological fluency;
  • analyze and resolve software-related problems through the application of systematic approaches;
  • analyze and define the specifications of a system based on user requirements;
  • analyze, design, develop, implement, maintain, and integrate a variety of application programs;
  • apply knowledge of the design, modeling, and implementation of a database;
  • apply knowledge of connectivity issues to support the development and maintenance of application systems;
  • use relevant methodologies to develop applications;
  • apply principles of project management;
  • participate as an effective individual and member of a team;
  • interpret, produce, and present work-related documents and information effectively and accurately;
  • identify and implement strategies to improve job performance and promote personal and professional growth;
  • demonstrate a basic understanding of business concepts;
  • demonstrate effective communication and interpersonal skills;
  • employ generic skills for personal and professional growth;
  • demonstrate an awareness of organizational and team behaviour;
  • demonstrate an awareness of ethical issues within a multicultural and global business environment;
  • participate in society as an informed citizen and pursue an enriched professional and personal life through life-long learning.
  • In addition to the skills attained as a Computer Programmer , students will have reliably consolidated their computing, business, generic, and interpersonal skills through the completion of a major team project..
  • Curriculum objectives are achieved through a combination of lectures, labs, practical assignments, and co-op placements. Program Learning Outcomes are geared towards developing the skills necessary to design, develop, implement and audit computerized information systems, and toward developing initiative and self motivation.

Practical Experience

Co-operative Education is a mandatory component of all Co-op programs at Georgian College; it has been designed as a process by which students integrate their academic education with paid work experience related to their program of study. This integration affects much more than simply earning a salary, including the adjustment to the work environment and the development of professionalism. It also reinforces skills and theory learned during academic semesters, develops professional contacts, job knowledge and career path, improves human relations and communication skills and promotes personal maturity and financial independence.

Students are requested to register, attend and participate in their scheduled co-operative education classes. These classes are scheduled for all first year students and are expected to be completed in order to proceed successfully to their first co-op work experience. To ensure students are eligible to proceed onto any co-op work experience students should refer to Promotional Status and Eligibility for Co-op as outlined in the College Calendar. Co-op policies and procedures can be located on our website: www.georgianc.on.ca/careers/for-students/

Georgian College follows the Co-operative Education guidelines set out by the Canadian Association for Co-operative Education (CAFCE) and Education at Work Ontario (EWO) by supporting the learning outcomes designed for the program specific graduate profile and curriculum as set out by the Ministry of Training, Colleges and Universities.

Program Progression

Fall Intake

Sem 1 - Fall 2011

Sem 2 - Winter 2012

Work Term 1 - Summer 2012

Sem 3 - Fall 2012

Work Term 2 - Winter 2013

Sem 4 - Summer 2013

Work Term 3 - Fall 2013

Sem 5 - Winter 2014

Sem 6 - Summer 2014

Winter Intake

Sem 1 - Winter 2012

Sem 2 - Summer 2012

Sem 3 - Fall 2012

Work Term 1- Winter 2013

Sem 4 - Summer 2013

Work Term 2 - Fall 2013

Sem 5 - Winter 2014

Sem 6 - Summer 2014

Work Term 3 - Fall 2014

Note: To confirm Winter (January) start, contact the Office of the Registrar.

Articulation Agreements

A number of articulation agreements have been negotiated with universities and other institutions across Canada, North America and internationally. These agreements are assessed, revised and updated on a regular basis. Please contact the program co-ordinator for specific details if you are interested in pursuing such an option. Additional information can be found on our website at www.georgianc.on.ca/academics/articulations/.

Admission Requirements

Applicants following the OSS curriculum must have an Ontario Secondary School Diploma (OSSD - 30 credits) or equivalent. Applicants following the OSS curriculum also require Grade 12 English (C) or (U) (ENG 4C, ENG 4U) and any Grade 12 College Mathematics (MAP 4C or MCT 4C), or any Grade 12 University Mathematics.

Applicants who are 19 years of age or over by the first day of classes, and who lack the academic entrance qualifications, may be considered for entrance to an appropriate post-secondary diploma or certificate program as mature applicants. Each applicant will be considered on an individual basis and acceptance will be determined by counselling, Communication Placement Assessment (CPA), previous post-secondary education and evaluation of experience. Some programs also have specific prerequisite requirements that must be met prior to admission. Mature applicants must meet all program specific prerequisites. Those applying as mature students and having no documentation of Grade 12 education must supply, if required, proof of age, such as a copy of an official birth certificate or driver's licence. Refer to Sections 2.5 and 2.6 of the Academic Calendar for further details.

Graduation Requirements

29 Mandatory Courses

2 Communications Courses

5 General Education Courses

3 Co-op Work Terms

Graduation Eligibility

To graduate from this program, the passing weighted average for promotion through each semester, from year to year and to graduate is 60%. Additionally, a student must attain a minimum of 50% or a letter grade of P (Pass) or S (Satisfactory) in each course in each semester.

Mandatory

BUSI1001 Introduction to Organizational Behaviour

COMP1002 Web Authoring Fundamentals

COMP1004 Rapid Application Development

COMP1006 Introduction to Web Programming

COMP1008 Introduction to Java Programming

COMP1009 Introduction to Mainframe Operating Systems

COMP1011 Advanced Java

COMP1030 Computer Programming Concepts

COMP1044 Principles of Data Organization

COMP1045 Computer Organization and Architecture

COMP2003 Relational Database

COMP2007 Enterprise Computing 1

COMP2055 Systems Analysis and Design

COMP2068 Advanced Web Programming

COMP2069 Introduction to Graphics Programming

COMP2070 Advanced Topics in Mainframe Operating Systems

COMP3000 Systems Project 1

COMP3001 Multimedia Programming

COMP3002 Advanced Database

COMP3003 Issues In Information Technology

COMP3006 Systems Project 2

COMP3014 Application Development Tools

COMP3015 Database Administration

COMP3016 Advanced Graphics Programming

COMP3017 Enterprise Computing 2

COMP3018 Comparative Programming Languages

MATH1003 Math for Computer Industry

MGMT2001 Principles of Management

MGMT2008 Project Management for Information Technology

The descriptions that follow provide brief outlines of the courses. Please note that some courses have prerequisite and/or corequisite requirements not shown here, that need to be met in order to enroll in the course. You will be advised of any requisite requirements during the registration process, or you can contact the academic area for further details.

Communications

COMM1001 Communications at Work

Plus one addition communications to be selected from College list

(Note: this is in addition to any mandatory communications listed for the program)

General Education Courses

To be selected from College list

Co-op

COOP1005 Computer Programmer Work Term 1

COOP2002 Computer Programmer Work Term 2

COOP3001 Computer Programmer Work Term 3

COURSE DESCRIPTIONS

BUSI1001 Introduction to Organizational Behaviour 42.0 Hours

Organizational Behaviour is an introductory course which teaches social science theory as applied to the business world. It provides rich insights about working people in all kinds of organizations and also suggests how people may be motivated to work together more productively. This course is eligible for Prior Learning Assessment.

COMM1001 Communications at Work 42.0 Hours

In the workplace, employers require high standards of communication skills. Students develop their communication skills for the workplace as they research, write and edit work-related correspondence and reports. Using technology, they individually and collaboratively design and deliver professional presentations and meetings. This course focuses on communication tasks specific to students' program areas and their future careers.

COMP1002 Web Authoring Fundamentals 42.0 Hours

This course covers HTML, client-side scripting and design issues for the World Wide Web. Students will learn how to use HTML source tags, build websites, manage a website's directories, and publish a website. The creation of web pages that conform to web standards and that use cascading style sheets for presentation will be emphasized. Students will work in groups to build mock commercial, institutional, government or educational websites. More advanced topics, such as bandwidth, aesthetics, human- interface and future developments will also be covered.

COMP1004 Rapid Application Development 42.0 Hours

This course introduces programming techniques supported by a visual rapid application development environment (such as Visual Basic) including forms, controls, user-defined classes and objects. The packages provided by the platform that support visual programming, data files and Graphical User Interfaces (GUI) are studied. The skills learned in this course can be applied to such diverse system capabilities as e-commerce and database manipulation.

COMP1006 Introduction to Web Programming 42.0 Hours

This course is designed to provide the student with systems and programming knowledge and skills for software development on the Internet. The student will learn about the Net as a development platform through the use of popular representative languages (such as PHP). The student will learn about web page design techniques, server-side programming, and web-enabled databases. The skills learned in this course can be directly applied to development of e-commerce systems.

COMP1008 Introduction to Java Programming 42.0 Hours

In this course, students will learn to program in the popular Java programming language. It is assumed students have already learned to design and outline the logic and structure of a program and that they understand object-oriented principles. Upon that foundation, this course will build skills in creating Java application programs that use primitive data types, API classes and user-defined classes as needed. Throughout the course, class

diagrams, unit tests and javadoc comments will be employed to document programs, verify correctness and ensure program quality. Students will write text-mode programs that process/manipulate data using object-oriented programming techniques.

COMP1009 Introduction to Mainframe Operating Systems 42.0 Hours

This course introduces students to the key concepts and principles that are applicable to a variety of mainframe operating systems. Mainframe operating systems will be discussed in relationship to specific hardware architectures and applications. In the lab, user interfaces, tools and utilities, application development, and the runtime environment will be explored. The emphasis of this course is to develop an understanding of the complex relationships required in a mainframe operating system to support user processes.

COMP1011 Advanced Java 42.0 Hours

Building on the students' Java programming skills, this course introduces features of Java that lend themselves to the creation of sophisticated applications. The skills learned in this course can be applied to such diverse system capabilities as e-commerce, database manipulation, and network connectivity. Graphical user interface design and construction will also be covered in greater detail.

COMP1030 Computer Programming Concepts 42.0 Hours

In this course the student will gain a broad understanding of modern computer programming. The student will acquire introductory skills in problem analysis, solution design, and program construction using structured and object-oriented techniques. Through practical programming activities, the student will gain an appreciation of the nature and history of computer programming and the significant role it plays in the computer field. The student will develop vocabulary related to design patterns.

COMP1044 Principles of Data Organization 42.0 Hours

This course introduces students to the fundamentals of data representation, organization, and storage. The concepts of fields, records, files, and databases will be studied. The interaction of data and programs will be explored so that students can attain an appreciation for the importance of the relationship between data and programs.

COMP1045 Computer Organization and Architecture 42.0 Hours

We use computers every day, from the PC on our desktop to the mainframe systems and server farms that operate mostly unseen and at distance over the Internet. This course examines what makes this work. It surveys computer hardware large and small; the operating system software that drives the hardware; and the network technology that connects everything. As the course title suggests, the emphasis is on the overall architectural principles that characterize computing. Practical lab exercises will include working with operating systems at the command level, assembly language programming to gain insight into the computer's internal workings and configuring workstations in networked settings.

COMP2003 Relational Database 42.0 Hours

In this course, the student is introduced to the process of creating and managing a relational database using Structured Query Language (SQL) statements. The emphasis of this course is data manipulation and extraction.

COMP2007 Enterprise Computing 1 42.0 Hours

Students will learn about the protocols and applications that make possible the simultaneous and seamless interaction of millions of computers through the internet and enterprise networks. In order to design and implement enterprise class applications, the student will undertake an in depth study of the Java Enterprise Edition application programming interface (Java EE API). To understand the practical aspect of enterprise computing, the student will build a working example of a dynamic, secure web enterprise application. Topics that will be covered include Service Oriented Architecture (SOA) and Service Component Architecture (SCA).

COMP2055 Systems Analysis and Design 42.0 Hours

This course provides a practical approach to systems analysis and design using a blend of traditional development with current technologies. Course material covers the theory, tools, and techniques used in the analysis of business information systems. The justification for a formalized systems life cycle, the importance of satisfying the information needs of end-users, and the necessity for accurate and concise documentation is stressed throughout.

COMP2068 Advanced Web Programming 42.0 Hours

This course is designed to give students the opportunity to enhance and enrich their skills in Web programming. Students will learn to develop Web applications that use three-tier architecture, session management, object-oriented techniques, and advance database interactions. Concepts such as advanced CSS concepts, rich interactive Web environments, authentication, and security will also be explored.

COMP2069 Introduction to Graphics Programming 42.0 Hours

This course introduces students to fundamental mathematics, algorithms, techniques, and programming skills that are useful for presenting data visually on the computer. Graphics programming in a variety of applications (such as games, animation, and geographical information systems) will be explored. Students will focus on the development of practical skills in using graphics libraries and tools.

COMP2070 Advanced Topics in Mainframe Operating Systems 42.0 Hours

Large-scale mainframe computing continues to dominate in the world of big business and there is no indication that this will change in the foreseeable future. Business simply has too much invested in legacy code. These legacy applications rely heavily on the COBOL programming language. There are literally billions of lines of COBOL code in existence. This course prepares students to work as applications programmers in the mainframe world by examining this language.

COMP3000 Systems Project 1 42.0 Hours

This is the first of two courses where the student will participate in a system study leading to the computerization of a small system. Completion of this course will require successful participation in a group project in the project planning, analysis, description, and recommendation for change in an actual business situation. Students will use and expand upon many of the skills to which they have been exposed over their first 4 semesters. This course is eligible for Prior Learning Assessment.

COMP3001 Multimedia Programming 42.0 Hours

Students will learn about the use of multimedia elements on web pages. Different types of multimedia and tools used to create them will be explored. The effectiveness and appropriateness of multimedia elements in web sites will be studied. The main focus of the course will be on creating and programming interactive web pages. Working as an individual and a member of group, students will design and develop web sites that integrate Macromedia Flash content.

COMP3002 Advanced Database 42.0 Hours

The Structured Query Language(SQL) is used at an advanced level with emphasis on real world commercial SQLs. A relational database is created and maintained using SQL and SQL procedural language.

COMP3003 Issues In Information Technology 42.0 Hours

This course examines some of the current and emerging issues facing Information Technology (IT) professionals, and is intended for senior-level Computer Studies students. Accepted analysis and design criteria are reviewed and applied for the evaluation of an IT trend. This course is eligible for Prior Learning Assessment.

COMP3006 Systems Project 2 42.0 Hours

Each student, alone or in a suitable small team with other students in the course, develops and implements a complete computer system to satisfy some real need. In completing this course, students use many of the skills to which they have been exposed over the past five semesters. This course is eligible for Prior Learning Assessment.

COMP3014 Application Development Tools 42.0 Hours

This is a comprehensive course in extracting data from sources of various formats, manipulating this data, combining with other data, and producing and saving meaningful output for management in various formats. A combination of different software products will be used to develop applications. This course is designed for students with a background in structured programming, SQL, and HTML.

COMP3015 Database Administration 42.0 Hours

This course builds on knowledge learned in COMP2003 - Relational Database and COMP3002 - Advanced Database. The course introduces basic database server administration principles using SQL and database utilities. Topics such as backup, recovery, security, optimization, monitoring, authentication, and authorization will be explored.

COMP3016 Advanced Graphics Programming 42.0 Hours

Building on principles and skills from the Introduction to Graphics Programming course, the student will explore three-dimensional (3D) concepts and techniques enabling them to create and design sophisticated graphics applications. Topics such as game programming, virtual reality, and computer animation will be investigated.

COMP3017 Enterprise Computing 2 42.0 Hours

In this course, the student will explore various technologies in enterprise computing in order to gain an appreciation for and acquire the programming skills required to work within enterprise systems. Service oriented architecture (SOA), security, and multi-platform application design and programming may also be investigated.

COMP3018 Comparative Programming Languages 42.0 Hours

In this course, a variety of programming languages will be presented that were not studied in previous semesters. The student will be provided an opportunity to study the similarities and differences amongst various programming paradigms and languages. Emphasis will be placed on exploring simple programs to promote an understanding of the advantages of using certain languages for particular programming applications.

COOP1005 Computer Programmer Work Term 1 560.0 Hours

Co-operative Education is a mandatory component of all Co-op programs at Georgian College. Students are required to attend and participate in their scheduled semester co-op classes PAR2102 (12 sessions) in order to proceed successfully to their first co-op work experience.

COOP2002 Computer Programmer Work Term 2 560.0 Hours

After completion of co-op work experience 1, students are required to attend a scheduled debriefing session. This session will be scheduled in the first month for all returning co-op students and is intended to prepare students for work term 2. This session will also allow the student to validate and submit supporting documentation for work term I credit. This must be achieved before proceeding to co-op work experience 2.

COOP3001 Computer Programmer Work Term 3 560.0 Hours

After completion of co-op work experience 2, students are required to attend a scheduled debriefing session. This session will be scheduled in the first month for all returning co-op students and is intended to prepare students for work term 3. This session will also allow students to validate and submit supporting documentation for Work Term 2 credit.

Upon completion of work experience 3 students will be invited to a final co-op debriefing session. This session is intended to prepare students for graduate job search and allow the student to validate and submit supporting documentation for work term 3 credit

MATH1003 Math for Computer Industry 42.0 Hours

This course provides students with the practical knowledge and skills in the use of mathematics in relation to computers. Alternate number bases, set theory, logic and Boolean algebra are the foundation of this course. In addition matrix operations are covered. In addition, basic matrix concepts are covered.

MGMT2001 Principles of Management 42.0 Hours

This course provides you with an introduction to the various philosophies, roles and functions of management. In addition it will cover on going changes in business that have a direct effect on the role of management. This course is eligible for Prior Learning Assessment.

MGMT2008 Project Management for Information Technology 42.0 Hours

This course introduces the fundamental principles necessary for successful management of Information Technology (IT) projects. Project planning, management and control techniques will be discussed and the application of computers in project management will be studied.

Adults with significant life and work experience may receive credits toward a college certificate or diploma program through an assessment process.

More information about Prior Learning Assessment and Recognition (PLAR)

NOTE: Information contained in College documents respecting programs is correct at the time of publication. Academic content of programs and courses is revised on an ongoing basis to ensure relevance to changing educational objectives and employment market needs. The college reserves the right to add or delete programs, options, courses, timetables or campus locations subject to sufficient enrolment, and the availability of courses.

How To Apply

Last Update: March 08, 2012.