Computer Programmer Analyst Advanced Diploma

Speak without obligation to Cambrian College

To contact you must accept the privacy policy

Comments about Computer Programmer Analyst Advanced Diploma - At the institution - Greater Sudbury - Ontario

  • Objectives
    The demand for computer programmers skilled in Web based programming and database administrators is growing at a rapid rate. This demand is created by the critical need for access to immediate information in businesses, health care and manufacturing industries. The Computer Programmer Analyst program prepares you to enter this exciting new field of computer and Web programming. In this program, students will learn about operating systems, networking, security, Web technology, and technical communications. Students will take courses in programming, database design, networks, Web site design and management, and entrepreneurship.
  • Practical experience
    Two optional semesters of co-operative work terms in industry provide students with the opportunity to refine their skills, to expand their awareness of potential career paths, and to make valuable employer contacts.
  • Academic title
    Computer Programmer Analyst Advanced Diploma
  • Course description
    Semester 1
    # CET1100   -   004   -   Desktop Operating Systems/Hardware

    This course introduces the student to the major components and operating characteristics of a computer system's fundamental program - operating system. Without an operating system, the computer is completely inert. If students are to gain more than a superficial understanding of how to operate computers, it is essential that they comprehend how an operating system works and how it enables them to command the hardware and/or software. This course will give the students the insight needed to solve computer problems they encounter and obtain the confidence that comes from being able to control the system with skill. Students will develop practical skills through hands-on experience with the following operating systems including MS-DOS, Unix, and the Macintosh OS.

    # CET1110   -   003   -   Productivity Software

    This course is designed to develop proficiency in word processing, spreadsheet and database management with Microsoft Office 2003. A "hands-on" approach is used to generate professional documents using the features available in Microsoft Word, Excel and Access. As a result, the student will efficiently create and appropriately format business reports, worksheets, graphs, database tables, queries, and forms, as well as integrate objects within documents.

    # CET2305   -   004   -   Local Area Networks

    This course provides the student with a solid foundation in fundamental networking concepts. The course focuses on network terminology and protocols, local-area networks (LANs), wide area networks (WANs), the Open System Interconnection (OSI) model, routers, router programming, Ethernet, TCP/IP addressing, and network standards.

    # CET2320   -   003   -   Client Administration

    The purpose of this course is to address the implementation and desktop support needs of customers that are planning to deploy and support Microsoft Windows XP Professional in a variety of stand-alone and network operating system environments. Customers have indicated that they require an in-depth training solution for implementing and supporting Windows XP Professional. This course will address customers' needs for knowledgeable personnel that can support desktops running Windows XP Professional. This course is based on Windows XP Professional Service Pack 2, using virtual machine software.

    # ENG1551   -   001   -   Writing Fundamentals: Ind. Study

    This course is required in the first semester of most post-secondary programs at Cambrian. The purpose of the course is to allow students to develop their independent learning skills and to review the fundamental conventions of Standard English.

    # ENG1710   -   002   -   Communications/Information Tech I

    This course introduces students to the fundamental communication skills necessary for employment in information technology fields. Topics to be covered focus on reading and writing skills, and include the communication process, reading analysis and comprehension, the writing process, principles and methods of organization, style and tone in technical writing, and editing skills necessary to create clear and concise documents. In addition, students prepare a short oral report.

    # STY1101   -   003   -   Programming Fundamentals

    This course introduces students to computer programming. Students will learn the fundamental concepts and terminology of software application development and develop skills in designing and writing simple computer programs. The course assumes no programming background and provides an overview of the software development process in addition to introducing important programming constructs and methodologies. The Visual Basic .NET programming language is introduced.

    Semester 2

    # CET1210   -   004   -   Network Operating Systems I

    Prerequisite: CET 2320 The purpose of this course is to provide the students with the knowledge and skills to manage accounts and resources in a Microsoft Windows Server 2003 environment. The course is intended for systems administrator and systems engineering candidates who are responsible for managing accounts and resources. These tasks include managing user, computer, and group accounts, managing access to network resources, managing printers, managing an organizational unit in a network based on Active Directory directory service, and implementating Group Policy to manage users and computers.

    # ENG1751   -   001   -   Job Search Skills: Ind. Study

    Prerequisite: ENG 1551 Through guided independent study, students will explore the job search process in detail and gain a comprehensive understanding of the theories and practices that lead to successful job searching and career planning. This course will also encourage further development of the independent learning skills and strategies practiced in ENG 1551 and 1581.

    # ENG1752   -   002   -   Technical Writing II

    Prerequisite: ENG 1552 In this course, students refine their technical communication skills by preparing written and oral responses to a variety of work related situations. As well, students complete a resume and other projects to assist them with their employment search. In the context of Cambrian College's General Education program and Generic Skills Standards, the course provides the opportunity for students to develop an understanding of work and the economy and of the relationships among individuals and society.

    # MTH1188   -   003   -   Mathematics

    Oriented toward business data processing, this subject presents mathematical topics that are important to learners in the world of computing. The emphasis is on a logical and structured approach. Emphasis is also placed on a practical, hands-on approach rather than on complicated mathematical proofs.

    # STY1211   -   004   -   Applied Database Concepts

    Prerequisites: CET 1110

    # STY1215   -   005   -   Programming I

    This course is a continuation of Problem-Solving Concepts - STY 1101. Program design techniques and language syntax are studied and applied to the solution of more challenging problems. Some of the topics covered include arrays, file handling, menus, error trapping, and database access.

    Semester 3

    # CET2310   -   004   -   Network Operating Systems II

    Prerequisite: CET 1210 This course provides students with the knowledge and skills that are needed to effectively maintain server resources, monitor server performance, and safeguard data on a computer running one of the operating systems in the Microsoft Windows Server 2003 family.

    # CET2330   -   003   -   UNIX System Administration

    Prerequisite: CET 1100 This course will introduce the student to the tasks required of a UNIX or Linux system administrator. The student will require a reasonable level of skills with the common UNIX commands and utilities to become familiar with most of the basic system administration tools and processes. The student will obtain a fundamental understanding of a UNIX-based operating system, be comfortable with most aspects of UNIX systems administration. The student will be able to configure, manage and support a UNIX network infrastructure. Skills learned will be through hands-on projects and assignments. Emphasis will be placed on the ability to independently solve problems quickly and completely.

    # PSY2700   -   003   -   Client Comm. & Leadership Develop

    This course examines a number of psychological topics relevant to the work environment. This course is intended to provide the student with the skills necessary to lead and support clients in a variety of settings. Students will acquire knowledge about interpersonal communication theory and will have the opportunity to incorporate these skills in the development of their own personal leadership style. Topics include communication theory, self awareness, perception, listening, non-verbal behaviour, conflict management and negotiation skills, team building, group problem-solving and decision-making, and leadership. Students will be given the opportunity to assess their own values, beliefs, and biases for each of the areas studied.

    # STY2110   -   004   -   Database Design And Development

    Prerequisite: STY 1211 The study of current concepts and principles relating to the design and development of a Relational Database Management System will be continued. The use of Entity-Relationship (ER) database models will be reviewed and implemented using Microsoft Access and Visual Basic for Applications. Approximately 35% of the course will be "hands-on" with the remaining 65% concentrating on concepts.

    # STY2300   -   004   -   Programming II

    Prerequisite: STY 1215 This course builds on the programming skills gained from STY 1215 Programming I. Microsoft C#.NET is used as a vehicle to introduce Object Oriented concepts and programming.

    Semester 4

    # CET2425   -   004   -   Network Infrastructure

    Prerequisite: CET 2310 This course provides students with the knowledge and skills that are needed to effectively maintain server resources, monitor server performance, and safeguard data on a computer running one of the operating systems in the Microsoft Windows Server 2003 family.

    # ENG3410   -   003   -   Communications/Information Tech III

    Prerequisites: ENG 1710, ENG 2710 This course expands the range of communication skills developed in ENG 1710 - Communications for Information Technology I and ENG 2710 - Communications for Information Technology II. It prepares information technology students to complete the kinds of longer technical communications tasks often required in their professions, including a proposal, formal report, and presentation based on primary and secondary research conducted in the information technology field.

    # STY2220   -   004   -   Systems Methods I

    Prerequisite: STY 2110 Students are introduced to the system development discipline within the context of corporate environments. The course focuses on model-driven approaches to system development. The Object Oriented (OO) software design and design patterns compliant with Unified Modeling Language (UML) 2.0 modeling standards, is the system development methodology followed.

    # STY2405   -   004   -   Programming III

    Prerequisite: STY 2300 This course builds on the programming skills gained in STY 2300 - Programming II. Design and programming using object oriented methodologies is studied and applied to the solution of more challenging problems.

    # STY2410   -   003   -   Website Management

    Prerequisite: STY 2305 This course will expand on the skills demonstrated in the previous Web Programming course by learning to develop server-side scripts that serve dynamic, data-bound web pages to users. Under the guidance of the professor, the learner will build web servers in both the Microsoft and Linux environments. Once the servers are built the student will learn to develop scripts that can allow for remote network administration, interacting with a database, or as a gateway to network resources.

    Semester 5

    # BUS3585   -   003   -   Entrepreneurship

    In the context of the College's General Education program, this course introduces the student to the key elements in the development of a business opportunity. The course demonstrates to the student how to investigate and develop the key ingredients of a successful business plan.

    # STY2211   -   005   -   Programming with SQL

    Prerequisite: STY 2110 This course complements the fundamental concepts and practices taught in previous database management courses. An in-depth study of SQL, the premier language for relational database systems, will be conducted. Where possible, the course content will consider the generic SQL capabilities and syntax that may be applied to any particular database software. However, solving problems using SQL will be done using Microsoft SQL Server.

    # STY3221   -   005   -   Systems Methods II

    Prerequisite: STY 2220 This course is a continuation of Systems Methods I. The design, implementation and support phases of the Systems Development Life Cycle are studied using a project management approach. Students learn to use MS Project 2003 and other tools to document nd control the development of information systems projects.

    # STY3500   -   005   -   Programming IV

    Prerequisite: STY 2405 This course provides an advanced study into procedural, object-based, and object-oriented programming methodologies and features. Emphasis is placed on contemporary programming paradigms rather than on the specific mastery of syntax.

    Semester 6

    # BUS1600   -   003   -   Customer Service

    This course will provide students with the knowledge and tools needed for success in dealing with customers. Students will be exposed to practical, real-world concepts and experiences along with suggestions for dealing with a variety of customer situations and problems.

    # CET3615   -   003   -   Network Security

    Prerequisite: CET 2425 This course provides students with the knowledge and skills to begin supporting network security within an organization. Students who complete this course will be able to identify security threats and vulnerabilities and assist with responding to and recovering from secruity incidents.

    # STY3110   -   004   -   Advanced Database Development

    Prerequisite: STY 2211 The purpose of this course is to provide a practical framework within which students will explore and further their past study of database concepts and principles. Emphasis will be placed on the study and implementation of prototyping methodology through the development of a multi-user database application.

    # STY3240   -   003   -   Emerging Technologies

    Prerequisite: STY 3500 This course will provide students in their final academic semester an opportunity to study emerging technologies. The students will be able to determine the content of the course by choosing topics of interest to them. A faculty member will be available to guide them in their investigation. The product of these investigations will then be presented to the class in a manner that will allow the group as a whole to benefit from the research.

    # STY3600   -   005   -   Programming V

    Prerequisite: STY 3500 This course provides the fundamentals of a programming language such as Java in order to develop applications. Learners must have a working knowledge of object-oriented, event-driven, and hypertext markup languages.

Other programs related to computer science

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