School of Advanced Technology

Our Program

This two-year Ontario College Diploma program prepares students for a career in software development. The program also specializes in program development strategies (using object-oriented modelling), database design and database administration.

This is a mobile learning program which engages students in a collaborative, mlearning environment which helps them become skilled, confident users of the technology they are expected to use in the workplace. Students are required to supply and use a laptop computer that meets the minimum hardware and software specifications as outlined at http://mlearning.algonquincollege.com . Computers and supplies can be purchased directly from Algonquin's New Technology Store at educational rates.

Students work with leading industry software products, such as Oracle; programming languages (Java, C#, SQL, PHP, JavaScript), operating systems (Windows and Unix/Linux) in a networked environment and CASE tools.

Approximately 75 per cent of the curriculum consists of courses in applications programming; programming languages; object-oriented analysis and design; operating systems; coding in integrated development environments; debugging, testing, and maintenance of code; database design, implementation, and administration. The balance of the curriculum consists of courses in oral and written communications, mathematics and others useful in the life-long learning required by software developers.

In the final year, students participate in a program-culminating real-world team project and an individual project exploring emerging technologies. Because of the constantly evolving nature of the information technology (IT) environment, the program places emphasis on preparing students to become independent learners.

Students have access to modern computing facilities in the School of Advanced Technology, such as Windows and Linux-based workstations, linked in an internal wireless network with access to the Internet. An extensive repository of software is available on the network. Additional software is available through the department-sponsored Microsoft Developer's Network Academic Alliance (MSDNAA), other vendor agreements and from software supplied under the mobile technology fee.

Students who maintain a College-prescribed academic standing and who possess the appropriate level of business communication skills may take part in a cooperative placement at the end of Level 03. Co-op students work in two back-to-back 15-week paid work terms before returning for their final level.

The two program start dates each year are at the beginning of the Fall and Winter Terms.

SUCCESS FACTORS

This program is well-suited for students who:

• Enjoy solving problems.
• Plan to continue learning; as it will be critical to meet the challenges presented by quickly changing technology.
• Take pleasure in providing assistance to others (will build computer systems to meet their needs).
• Like working with others as a member of a team.
• Can work independently.
• Are organized in their work and pay attention to detail.

Back to Top

Your Career

Graduates may find a variety of employment opportunities as applications programmers and systems analysts who can work independently and as part of a team to analyze, design, code, debug, test, implement and maintain application systems. Training in web programming, business programming, database design and database administration may also present job opportunities in those areas. Employment may be found in organizations of all sizes in both the public and private sectors.

Back to Top

Courses

Programs at Algonquin College are delivered using a variety of instruction modes. Courses may be offered in the classroom or lab, entirely online, or in a hybrid mode which combines classroom sessions with online learning activities. Upon registration, each full-time student is provided an Algonquin email account which is used to communicate important information about program or course events.

Level: 01		Hours
CST8101	Computer Essentials Learn how to manage your laptop environment to gain the best advantage during your college program and later in the workplace. Create backups, install virus protection, manage files through a basic understanding of the Windows Operating System, install and configure the Windows Operating System, install and manage a virtual machine environment. Explore computer architecture including the functional hardware and software components that are needed to run programs. Finally, study basic numerical systems and operations including boolean logic.	60.0
CST8110	Introduction to Computer Programming Learn the fundamental problem-solving methodologies needed in computing, such as structured analysis, structured design, structured programming and an introduction to object-oriented programming. Use pseudocode, flowcharting, as well as a programming language to develop solutions to real-world problems of increasing complexity. The basics of robust computer programming, with emphasis on correctness, structure, style and documentation are learned using Java. This course reinforces theory with application by means of practical laboratory assignments. An online section of this course is available on a first-come, first-served basis. Once enroled in the program, students are notified by email of the registration procedure for this option.	75.0
CST8282	Introduction to Database Systems This course introduces students to the design and development of database systems using a current Database Management System (DBMS). Concepts and terminology of relational databases and design principles using the Entity Relationship model are presented. Students use SQL to create, modify and query a database.	60.0
CST8300	Achieving Success in Changing Environments Rapid changes in technology have created personal and employment choices that challenge each of us to find our place as contributing citizens in the emerging society. Life in the 21st century presents significant opportunities, but it also creates potential hazards and ethical problems that demand responsible solutions. Students explore the possibilities ahead, assess their own aptitudes and strengths, and apply critical thinking and decision-making tools to help resolve some of the important issues in our complex society with its competing interests.	45.0
ENL1813T	Communications I Communication remains an essential skill sought by employers, regardless of discipline or field of study. Using a practical, vocation-oriented approach, students focus on meeting the requirements of effective communication. Through a combination of lectures, exercises, and independent learning, students practise writing, speaking, reading, listening, locating and documenting information, and using technology to communicate professionally. Students develop and strengthen communication skills that contribute to success in both educational and workplace environments.	45.0
MAT8001	Math Fundamentals This course prepares students with the foundational mathematics required in many college technical programs. Students learn to solve both measurement problems involving a variety of units and ratio and proportion problems. They learn to manipulate algebraic expressions and solve equations. Students evaluate exponential and logarithmic expressions, study the trigonometry of right triangles and graph a variety of functions.	45.0

Level: 02		Hours
CST8102	Operating System Fundamentals (Linux) Learn the basic concepts of the components of Linux operating systems, how they work and how they interact. Learn to install and configure a Linux OS, how the OS interacts with computer hardware components, and how to administer the system resources and processes. Lab exercises are designed to demonstrate how to implement the theory by developing skills using the powerful command-line tools and utilities in Linux, and in creating and executing shell scripts. Prerequisites: CST8101	75.0
CST8103	Networking Basics This course covers the important concepts necessary to understand modern LAN and Internet networking. Students gain an appreciation and perspective of the immense impact that networking is having on technology in general and society as a whole. Included is a detailed study of the terminology and concepts related to the implementation and operation of computer networks. Topics include the basic structure and design of networks, layered communications models, IP addressing and subnetting, industry standards for network media, and protocols with an emphasis on TCP/IP protocol suite and Ethernet. Labs include practical exercises in using common networking tools for diagnosing and troubleshooting typical network problems. The course includes material from the Cisco Network Academy Program CCNA Exploration Networking Fundamentals and borrows from the CompTIA Network+ certification.	75.0
CST8284	Object-Oriented Programming (Java) In this course, students learn object-oriented programming methodology using the Java programming language. Object-oriented concepts, such as encapsulation, inheritance, abstraction and polymorphism are covered and reinforced with practical applications. This course helps students prepare for industry-recognized Java certification exams. Prerequisites: CST8110	60.0
CST8285	Web Programming This course introduces students to website design and implementation. JavaScript and PHP are used to explore web-based solutions to problems of increasing interactivity and complexity. Lectures are reinforced by practical assignments that encourage students to construct and maintain their own websites. Prerequisites: CST8110	60.0
DAT2355D	Database Systems In this course, students acquire practical experience using Oracle, an object-relational database management system. Advanced topics in database design are covered. Students have hands-on use of SQL, SQL scripts, PL/SQL and embedded SQL in host programs. Database concepts covered include data storage and retrieval, administration, data warehouse, data mining, decision support, business intelligence, security and transaction control. Students also explore the use of open source database software. The course helps students prepare for industry-recognized database certification exams. Prerequisites: CST8282	60.0

Level: 03		Hours
CST8288	Object-Oriented Programming with Design Patterns This course continues to focus on object-oriented program development, introducing students to "best practice" software design patterns. UML program specifications are implemented using the Java programming language. A database is used for implementing "data access objects". Course topics include refractoring, domain models, JDBC and multi-threading. Students develop proficiency in creating, testing, debugging, deploying and documenting programs, applets, servlets and/or Java Server pages. The course helps students prepare for industry-recognized Java certification exams. Prerequisites: CST8284 Co-requisites: DAT2234D	60.0
DAT2234D	Systems Analysis and Design Following industry standard software engineering methodologies, this course provides hands-on experience with case studies in developing systems from preliminary investigation to object-oriented analysis and design, using modelling tools, prototyping, presentations and technical reports. Risk management and project management principles are used within team development of assigned projects. Implementation (including verification and validation) and system maintenance are discussed. Software methodologies studied include the system development life cycle (SDLC), rapid application development (RAD), agile approach and rational unified process (RUP). CASE tools are used to automate the modelling process of UML-based object-oriented models. Prerequisites: DAT2355D	60.0
DAT2335	Graphical Interface Programming (C#) This course introduces the student to the development of graphical user interfaces (GUI) in a multi-tier application architecture. Students learn to construct applications that segregate presentation, problem domain and data storage layers. Prerequisites: CST8284 Co-requisites: DAT2234D	60.0
DAT2390	Cooperative Education Work Term Preparation This course covers career planning, effective resumes, job search techniques, job interviews, raising one's profile, supervisors, security in the workplace, setting personal learning objectives, self-directed learning, the co-op evaluation and work report guidelines.	15.0

Elective: choose 1		Hours
CST8237	Game Programming This course combines skills learned in previous courses to develop advanced multimedia and game applications that run on a PC. Using the power of the Graphics Processing Unit (GPU) on the video card it is possible to program shaders that simulate real-life objects moving under the laws of physics. As an end product, the course develops a complete virtual 3D world with terrain, and a dynamic environment that the user can explore and interact with.	60.0
CST8255	Web Imaging and Animations This course introduces students to basic concepts and techniques used to produce graphics, animations and video optimized for the World Wide Web. Students use Adobe software to create images and animations, build graphical user interfaces and author interactive applications. Prerequisites: CST8110	60.0
CST8256	Web Programming Languages I This course places emphasis on ways of moving data between web pages and databases using the .NET platform: ASP, ADO, C#, and the .NET Framework. Heavy emphasis is placed on how web applications can interact with (remote) databases through ODBC or other technologies. It explores server-side methods and the advantages of multi-tiered applications. This course concludes with a mini-project to develop a live web application that interacts with a database. Prerequisites: CST8253 and DAT2355D	75.0
CST8283	Business Programming This course continues computer program development, in a business environment, using structured methodology and the COBOL language. Topics include: output design; logic design tools; structured, top-down and modular coding; testing and debugging; JCL and documentation. The programs include interactive and file-based processing of data related to business problems. Arrays, indexed files and sub-programs are included. Prerequisites: CST8110	60.0

Choose one from equivalencies:		Hours
GED0336	General Education Elective For this course, you have the opportunity to choose one from a group of general education electives. Your options will include courses which cover the following broad topic areas: Arts in Society, Civic Life, Social and Cultural Understanding, Personal Understanding and Science and Technology. Equivalencies: ARC9001 or DSN2001 or ENL7643 or ENV0002 or FAM1218 or GED1896 or GED5002 or GED5004 or GED5005 or GED5006 or GED5009 or GED5300 or GED6022 or GEN1957 or GEN2000 or GEN2007 or GEN2009 or HIS0001 or HIS2000 or HOS2228 or LIB1982 or MGT7330 or MVM8800 or PSI0003 or PSI1702 or RAD2001	45.0

Level: 04		Hours
CST8276	Advanced Database Topics This course provides practical experience in the administration of database management systems using Oracle. Knowledge of database physical storage supports planning and database creation. Students add new users, grant and revoke privileges, and learn about backup and recovery procedures. Information management topics such as access to information, privacy, business intelligence, decision support, security, and data management are explored and related to best practices in workplace environments. Prerequisites: DAT2355D	60.0
CST8277	Enterprise Application Programming With a focus on the "IT Enterprise," this course introduces the student to the application enterprise environment using and extending the technologies learned in previous courses. Topics studied may include the Java enterprise environment (J2EE), the Microsoft ".net" environment, security and the corporate database repository. The course helps students prepare for industry-recognized Java certification exams. Prerequisites: CST8288	60.0
CST8333	Advanced Languages What new programming languages pique your interest? Since you are expected to learn new programming languages on the job, this is an opportunity to experience self-study of a language of your choice (confirmed, supported and assessed by professor (coach)). Prerequisites: CST8288	60.0
CST8334	Software Development Project This course integrates the skills learned throughout the program. Following appropriate software engineering methodologies and using object-oriented modelling, teams plan, analyze, design and implement computer applications. The teams manage and complete development and implementation of projects (case-study or real projects). Teams participate in interviews, technical reviews, presentations, and technical report writing. The culmination of the course is a final presentation and submission of a finished product, including a complete documentation set. Prerequisites: CST8285 and CST8288 and DAT2234D and DAT2335	60.0

Choose one from equivalencies:		Hours
GED0336	General Education Elective For this course, you have the opportunity to choose one from a group of general education electives. Your options will include courses which cover the following broad topic areas: Arts in Society, Civic Life, Social and Cultural Understanding, Personal Understanding and Science and Technology. Equivalencies: ARC9001 or DSN2001 or ENL7643 or ENV0002 or FAM1218 or GED1896 or GED5002 or GED5004 or GED5005 or GED5006 or GED5009 or GED5300 or GED6022 or GEN1957 or GEN2000 or GEN2007 or GEN2009 or HIS0001 or HIS2000 or HOS2228 or LIB1982 or MGT7330 or MVM8800 or PSI0003 or PSI1702 or RAD2001	45.0

Back to Top

Fees & Expenses

Approximate 1st Year Costs

Tuition/Fees: $ 3,424
Books/Supplies: $ 850
Incidental Fees: $ 0
Total: $ 4,274



Tuition Fees listed are in effect for the 2011-2012 academic year.

Tuition Fees: $1,212.20 per term in Levels 01 and 02 and $1,206.40 per term in Levels 03 and 04.

Information Technology Fee: $62 per term. *

Mobile Computing Fee: $150 per term. **

Student Activity/Sports Fee: $190.50 per term.

Student Centre Building Fee: $17.50 per term.

Health Service Fee: $10 per term.

Health Plan Fee: $114.50 paid once annually. ***

A $35 graduation fee is payable in the final term.

A $25 transcript fee is payable in the first term a student attends Algonquin College.

International Students pay all relevant Canadian fees plus an International Premium of $4,400 per term.

* Students paying the Information Technology fee are provided with a network account, an email address, and Internet access. For more information please visit our website at www.algonquincollege.com/its/services/it_fee.htm

** The Mobile Computing Fee covers the costs associated with providing various services to students registered in a mandatory laptop programs.
*** Students who have coverage with another plan can request a refund by supplying the Students' Association with documentation supporting the
request. This request will have to be made annually.

Co-op Fee: $465 payable in two installments in the term preceding each work term. The first installment of $100 is payable at the time of registration for co-op and is non-refundable. The second installment of $365 is payable on the standard fees due date. Students on a co-op work term will pay 10% of the Student Activity and Building Fees. Co-op students on work term in the Fall will pay the Health Plan Fee.

Books and supplies cost approximately $850 for the first year and $650 for the second year and can be purchased in the campus bookstore. Selected books are available for a reduced price through ebook initiatives at
www.coursesmart.com. This program is a mandatory laptop program.

Back to Top

Admission Requirements  2012/20132011/2012

Back to Top

Application Information

Applications to full-time day programs must be submitted with official transcripts showing completion of the academic admission requirements through:

ontariocolleges.ca
60 Corporate Court
Guelph, Ontario
N1G 5J3
1-888-892-2228

Students currently enrolled in an Ontario secondary school should contact their Guidance Office to apply. For all other applicants, applications are available online at ontariocolleges.ca. A $95 fee applies.

Applications for Fall Term and Winter Term admission received by February 1 will be given equal consideration. Applications received after February 1 will be processed on a first-come, first-served basis as long as places are available.

International applicants applying from out-of-country can obtain the
International Student Application Form at
https://xweb.algonquincollege.com/FormIE/index.aspx or by contacting the Registrar's Office.

For further information on the admissions process, contact:

Registrar's Office
Algonquin College
1385 Woodroffe Ave, Room C150
Ottawa, ON K2G 1V8
Telephone: 613-727-0002
Toll-free: 1-800-565-4723
TTY: 613-727-7766
Fax: 613-727-7632
Email: askalgonquin@algonquincollege.com

Back to Top

Additional Information

Curriculum for this program is reviewed annually to reflect evolving industry standards in the information technology field.

For more information regarding this program, please contact:
Reg Dyer, Coordinator/Professor, 613-727-4723 ext. 5148, coordcp@algonquincollege.com or visit www2.algonquincollege.com/sat.

Back to Top