Computer Programmer/Analyst Ontario College Advanced Diploma

Speak without obligation to Conestoga College

To contact you must accept the privacy policy

Comments about Computer Programmer/Analyst Ontario College Advanced Diploma - At the institution - Kitchener - Ontario

  • Objectives
    Computer Programmer/Analyst is a diploma program in which you will learn the latest skills needed by programmer/analysts employed in industry. The program emphasizes problem solving skills using the latest release of Microsoft, Oracle and Sun software to develop both enterprise and Internet applications. Object-oriented analysis, design and programming techniques are mastered throughout the program and applied to a group project in the last year to build a major application for a local business. In the program you will gain through practice, the knowledge, skills and attitudes that Information Technology employees are required to have. The complementary courses in areas such as mathematics, accounting and communications support the technical courses.
  • Practical experience
    This program has a co-op component option. Co-op students will complete 8 months of work experience in the Information Technology industry.
  • Academic title
    Computer Programmer/Analyst Ontario College Advanced Diploma
  • Course description
    Level One
    COMM1180     Effective Technical Communications I

    Description: Recommended: The course content is based on the assumption that students can demonstrate competency in the use of the English language.

    NOTE: This is course does not qualify for a General Education exemption.

    This level-one course is designed to introduce students to industrial and business communications. Emphasis is placed on analyzing audience, determining purpose and effective ordering of ideas for various written communications such as letters and memoranda in the technical environment. As well, all students are expected to participate in group work throughout the semester and are expected to give an oral presentation.
    Hours: 45
    Credits: 3

    INFO1570     Technology Infrastructure: Fundamentals

    Description: This course will introduce the student to the architecture of the computer hardware and operating systems software typically used in a business environment. Specific topics will include directory structures, drive mappings, internet searching, email concepts and basic HTM, XHTML, and JavaScript programming.
    Hours: 60
    Credits: 4

    INFO1580     Systems Development: Concepts
    Description: This course will teach the student to describe and solve business application problems using object-oriented techniques. The student will apply the techniques to typical logic problems using an object-oriented programming language. The application of the concepts of abstraction, polymorphism, inheritance and encapsulation will be emphasized.
    Hours: 45
    Credits: 3

    MATH1010     Business Mathematics I

    Description: The purpose of the course is to provide the student with a mathematical basis for personal and business financial decisions through four instructional models. The course stresses business application using arithmetic, algebra, ratio-proportion and graphing. Applications include payroll, cost-volume-profit analysis and merchandising mathematics. This course stresses logical reasoning and problem solving skills. A Texas Instrument BAII 'Plus' calculator is required for the course.
    Hours: 45
    Credits: 3

    PROG1780     Programming: Fundamentals

    Description: The student will use a Graphical User Interface based programming language to develop programs to solve business problems. The programming concepts of data types, record structures, arrays, event driven processes and sequential files will be introduced. Particular attention will be paid to problem solving techniques such as pseudo code and flowcharting to design the logic of the program. The student will be introduced to techniques of desk checking, testing and debugging.
    Hours: 90
    Credits: 6

    Level Two
    ACCT1030     Introductory Financial Accounting I

    Description: This course introduces accounting terminology, the accounting equation, the double-entry system of bookkeeping, the accrual basis of accounting, financial statements, and the ledgers and journals making up a basic accounting system. Equivalent Course: OLRN1320 Financial Accounting 1 (Internet)
    Hours: 45
    Credits: 3

    COMM1130     Effective Technical Communications II

    Description: This second level course is designed to further students' abilities in technical communications. Emphasis is placed on analyzing audience, determining purpose and effective ordering of ideas for various written communications such as informal and formal reports, user manuals, job search materials and proposals in a technical work environment. As well, all students are expected to participate in group work throughout the semester and are expected to give oral presentations.
    Hours: 45
    Credits: 3
    Pre-Requisites: COMM1180

    INFO2070     Systems Development: Analysis
    Description: Prerequisite: Systems Development: Concepts (60253201) Upon completion of this course, the student will understand the Systems Development Life Cycle and the Object-Oriented Analysis methodology using the Unified Modelling Language. An object-oriented approach will be applied to a business system case study utilizing a Computer Assisted Systems Engineering tool to analyse the system requirements. Emphasis will be placed on typical industry practices, documentation and presentation skills in a team environment.
    Hours: 60
    Credits: 4
    Pre-Requisites: INFO1580

    MATH1020     Business Mathematics II
    Description: This course provides the student a mathematical basis for financial decisions. Topics range from simple interest to sinking funds and Canadian mortgages and refinancing of loans. A Texas Instrument BAII 'Plus' financial calculator is required.
    Hours: 45
    Credits: 3
    Pre-Requisites: MATH1010

    PROG1790     Database: Fundamentals

    Description: This course introduces the student to the concepts of database management. The student will learn how to design and develop database applications. The course will introduce the following topics: data types, table relationships, data normalization, entity relationship diagrams, table navigation and data entry control.
    Hours: 75
    Credits: 5
    Pre-Requisites: PROG1780

    PROG1800     Programming: Web Fundamentals

    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 PROG8000

    Level Three
    INFO1030     Technology Infrastructure: Networking and UNIX

    Description: In this course the student will learn to relate the OSI network model to the physical network. The course will cover the following network topics: protocols, devices, addressing, topology, file structures, cabling and assembly. The student will learn command shell programming, data manipulation, scripting, setting file permissions and email management.
    Hours: 45
    Credits: 3

    INFO2080     Systems Development: 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. An object-oriented approach will be applied to a business system case study utilizing a Computer Assisted Systems Engineering tool to design a proposed solution from the requirements prepared in the Systems Development: Analysis course. Emphasis will be placed on typical industry practices, documentation and presentation skills in a team environment.
    Hours: 60
    Credits: 4
    Pre-Requisites: INFO2070 or INFO8000

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

    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: INFO1570, PROG1780 or PROG8000

          Electives: General Education
    Description: Student must complete a minimum of 36 Hours

    Level Four
    FIN2090     Financial Applications Integration

    Description: This course prepares the student to perform ad-hoc data manipulation, database"driven reporting, and integration of purchased products. Hands-on assignments show how to load, export and import data, format and print data, and how to integrate an in-house application with an off-the-shelf financial application and standard office productivity tools.
    Hours: 45
    Credits: 3
    Pre-Requisites: ACCT1030

    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

    MATH2250     Statistics
    Description: This is an introductory course in Business Statistics. The course covers simple
    descriptive statistics, probability and the binomial and normal probability
    distributions, statistical inference, introduction to sampling distributions,
    simple regression and correlation analysis.
    Hours: 45
    Credits: 3
    Pre-Requisites: MATH1010

    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

    PROG2250     Programming: Client Server
    Description: This course builds on the students' skills to develop client server applications using industry standard tools. The course will include the following topics: multiple documents interface, tabbed forms, ADO.Net, rich controls and exception handling. Particular attention will be paid to proper syntax, application development, testing, debugging and security techniques.
    Hours: 60
    Credits: 4
    Pre-Requisites: PROG2220

          Electives: General Education

    Description: Student must complete a minimum of 36 Hours

    Level Five
    INFO3060     eCommerce

    Description: This course explores the processes and issues involved in conducting commerce over the World Wide Web. The topics covered in this course will include technologies used to deliver eCommerce Web content; the strategies used to launch an eCommerce Web Site; electronic payment methods and security; and the systems development life cycle of an eCommerce implementation.
    Hours: 45
    Credits: 3

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

    PROG3040     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: 75
    Credits: 5
    Pre-Requisites: PROG2220

    PROG3050     Programming: Microsoft Enterprise Applications

    Description: This course provides a bridge between previous programming courses and Systems Development: Systems Project. It builds directly on Programming: Client Server to teach the student how to create realistic multi-tier business applications with a professional object-oriented programming language. Working from an existing design, students work in teams to implement a complete, complex business application. The finished application is expected to conform to standards, be thoroughly tested, have complete user and technical documentation, and be ready to deploy.
    Hours: 75
    Credits: 5
    Pre-Requisites: PROG2250

    PROG3170     Programming: Distributed Applications Development

    Description: Students will be introduced to programming techniques intended to achieve interoperability of business information systems. Topics to be addressed would include generating and parsing XML (and related XML tools), web services, SOA, multi-platform interoperation, multi-vendor interoperation and multi-language development.
    Hours: 45
    Credits: 3
    Pre-Requisites: PROG2250, PROG2230

    Level Six
    BUS1020     Organizational Behaviour

    Description: Studying people and organizations, this course examines the behaviour of individuals working alone or in teams. Using actual examples, this course examines how behavioural factors affect organizational effectiveness. Note: This course is an approved HRPAO credit. Equivalent: Introduction to Business Management & Organizational Behaviour. OLRN1470 (Internet).
    Hours: 45
    Credits: 3

    INFO3800     Systems Development: 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: 90
    Credits: 6
    Pre-Requisites: INFO2080, PROG2240, PROG2250, PROG3040, PROG3050, PROG2230
    CoRequisites: PROG3030

    PROG3030     Systems Development: Project Evaluation & Control
    Description: This course will support the Systems Development: Systems Project and Systems Development: Application 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 and entrepreneurship. By analyzing professional systems, it is expected that students will be better prepared to implement their own application.
    Hours: 45
    Credits: 3
    Pre-Requisites: INFO2080, PROG2220, PROG2230

    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

Other programs related to oracle

This site uses cookies.
If you continue navigating, the use of cookies is deemed to be accepted.
See more  |