Manage data, Manage the business world
Today’s businesses and essential services depend on complex information and data management systems. Designing, developing and keeping those systems up to date with the business processes they support is the domain of programmer analysts. In a digitized world, the ingenuity and technical know-how of programmer analysts is in demand. From transportation networks to critical hospital databases to social network driven applications, analysts design and develop the systems that are key to the success of all businesses and services in today’s digital world.
Back to TopProgram Description (Laptop program)
NOTE: Students enrolling in this program are required to purchase their own laptop. For specific hardware and software requirements for this program click here.
This program offers comprehensive study in information technology, systems methodologies and application programming, built on a solid foundation of business expertise. The curriculum includes in-depth instruction and the practical application of structured, mainframe and object-oriented programming languages.
Additionally, you will receive extensive training in:
- Advanced application development
- Database administration
- Internet development
- Project management
You will work independently and in teams to create course deliverables. As a graduate you will begin your career in programming, microcomputer support or computer operations and, with experience, advance to the position of systems analyst with responsibility for the design and planning of system networks and technical support or a management position in programming, operations or other area.
Note: To ensure you make an informed decision about your information technology (IT) career path, a common first semester is offered for the Computer Systems Technician, Computer Systems Technology, Computer Programmer and Computer Programmer Analyst programs. This approach will give you an opportunity to explore the systems/programming applications and networking/hardware applications of the IT sector. At the end of the first semester, you will then select your program of choice.
Back to TopAdmission Requirements
Ontario Secondary School Diploma, General Educational Development, Academic and Career Entrance – College Prep Level or Mature Student Status plus senior level (Grade11orhigher) subject credits, college preparation(C), university/college preparation (M), university preparation (U) or post-secondary (college or university) in:
- Grade 12 English
- Grade 12 mathematics
Back to TopCareer Options
- Application development
- Business analyst
- Programmer analyst
- Project management
- Social networking development
- Software and database development/support
- Systems analyst
- User support
- Web and smart device development
Back to TopCourse List & Descriptions
Semester 1 | Semester 2 |
Semester 3 | Semester 4 |
Semester 5 | Semester 6 |
This course focuses on essential oral and written communication skills for college and career success. Students will be able to practice and apply the principles of effective communication by writing business correspondence using a variety of formats. Effective oral presentation techniques will be examined and applied.
This course will introduce the students to relational databases to automate data management. The students will be taught: database design emphasizing table relationships; introduction to normalization; building tables with different data types; form design for data collection; creating queries and reports; and automating tasks with switchboards and macros using MS-Access databases. The course will also introduce Structured Query Language (SQL). The laboratory assignments and final project will provide the student with the knowledge needed to design and implement a database in any type of application development.
Current market analysis indicates networking and more specifically internetworking is in very large demand. From corporations to small office sites and even into “smart” homes there is a growing need to interconnect computerized equipment. Durham College’s Cisco Networking Academy curriculum will prepare our students to meet this challenge. DCOM 1100 is the first of four courses that lead the student towards the Cisco Certified Network Associate (CCNA) accreditation. This course provides the student with an in-depth knowledge of the principles and topologies in data communications today.
This course introduces students to businesses as “Open Systems” with Inputs, Processes and Outputs. Key to this concept is the knowledge of all stakeholders inside and outside of the organizational boundary of the business and their roles as well as the critical importance of knowledge management within the organization as a tool for effective management decision making. This course also covers a look at career paths and trends in the Information and Communications Technology (ICT) field.
This course introduces the students to the sound mathematical and logical skills required for both technical and programming courses. Topics covered in this course vary from Arithmetic, Algebra, Signals both Analog and Digital, Number systems, Logic gates, Program Design and Statistics emphasizing problems in Business, Digital and Information Technology. The students are taught to solve the mathematical problems with the use of Electronic Calculator and Electronic Spreadsheet (Microsoft Excel) in place of a manual calculator; and also on-line practice and assessment tool (MathXL) from the publisher.
This is an introduction to the general principles of computer programming. Topics will include the selection of basic data types, basic I/O, operators, repetition, flow control, decisions, arrays and the use of simple user-defined methods and user-defined classes. This course teaches the student how to write computer programs, using a high level language, to solve typical business problems. A structured programming approach is taken for the majority of the course with an introduction to OOP principles and program design also included. The C# programming language has been selected as the language vehicle for the course.
This course focuses on the concepts, architecture, and administration of computer operating systems namely DOS, Windows and Linux/Unix using both command line and GUI environment. Students will learn DOS and Linux/Unix commands and build batch files (scripts) to automate simple tasks. The course also covers desktop customization, software installation, task management, system performance and security. Many professional careers depend on the student’s ability to prove his or her expertise through industry certifications. This course contains materials that map to the objectives cited in the requirements for the Microsoft 70-210 and 70-270 exams and Linux+.
This course is designed to provide an introduction to structured programming principles to students studying in the information technology field. The programming language selected is ANSI (Standard) C++. This course teaches how to write computer programs in a structured, procedural approach, using a high level language, to solve typical problems.
This course prepares students for careers in the computer support service field. Emphasis is on IBM and IBM-type personal computers (PCs). Students gain a greater understanding of typical PC components and their relationship to the computer's operating system and peripherals. Students will gain hands-on experience in diagnosis and troubleshooting, which helps prepare them to service PCs and related equipment. This course will assist students in preparing for the A+ Essentials certification exam (220-701).
This course introduces the student to the Internet infrastructure, concentrating on the World Wide Web and Web application servers, and provides a brief overview of emerging Internet technologies. The lectures introduce the student to essential Web techniques and features. The labs focus on producing working web pages published on the Internet, and simple interactive Web applications, with validated code for multi-browser compatibility. The server environment is the Apache server on the UNIX-like OpenBSD OS, with MS Windows browsers and editors on the client side. Server-side Web applications will be done in the PHP scripting language and SQL queries will be done with the PostgreSQL RDBMS running on the server.
Information security topics will be addressed throughout the course.
This course introduces students to systems analysis and design processes and practices, specifically the object-oriented approach to system development. Topics covered will include basic object-oriented concepts, modeling and UML notation, the development life cycle, object-oriented development tools and a basic introduction to the SDLC.
This is an introductory course in the programming language Visual Basic course with emphasis on lab problems. Visual Basic 2010 will be used. Visual Basic is a principle programming technology in a Microsoft environment, which can be used either as a standalone product to code customized applications, or in conjunction with other products. The students must use a laptop computer as specified by Durham College.
This is the lecture-lab course with emphasis on lab problems. The COBOL programming language is covered in great detail. It is intended to provide the student with a foundation in problem analysis, program design and implementation that can be applied in a variety of programming situations and languages. This course is a prerequisite for Cobol Programming II (COBL 4200) in semester 4. A laptop computer as specified by Durham College must be used by the students.
This course includes report writing and job-search communications. The appropriate documentation and research required to execute an effective information technology job search strategy will be created in this course. Report writing skills, involving detailed research and problem solving of current information technology issues and solutions, will be applied. This course will allow the student to further develop effective oral presentation skills which will be invaluable in career development.
This is primarily an extension of the Intro to C++ Programming course (CPRG 3202). In addition, to a closer examination of file input/output, pointers and arrays, this course will focus upon object-oriented programming theory and practices. Students will develop user defined classes to provide computer solutions to business problems.
Internet Development II is a project based course in which students will gain practical experience creating an interactive web site that will allow users to: register, update, login using sessions/cookies, upload images, receive email notifications, search and display records from a database. As the project is group based, students will learn about and use version control software. The practical portion requires students to work in groups to make professional level interactive Web applications in the PHP language, running on an OpenBSD server (a UNIX-like OS). Additionally, throughout the semester students will learn theory dealing with the World Wide Web. The theory portion will provide further in-depth knowledge with Internet related topics including: digital imaging, user testing, XML, internet security, credit card processing on the web, and MIME.
This course introduces students to fundamental accounting concepts. With these concepts, students learn how to keep a simple set of books for a small business, including journalizing, posting, trial balance, adjusting entries, and the preparation of financial statements. Other topics include petty cash, bank reconciliations, and internal control.
This course introduces students to the management aspects of Human Resources in preparation for advanced, specialized studies in the second and third years of the HR program. Specific focus is on the factors that affect the overall atmosphere in the workplace and that which contributes to an environment conducive to maximum productivity. Students will be introduced to effective strategies for hiring, motivating, managing, training, and retaining staff. Students will study the following topics: the strategic importance of Human Resources and the role of the H.R. Manager; competitive challenges facing Human Resources; demographic challenges, government and legal challenges, job analysis and design; Human Resources planning; recruitment and selection; orientation and training; employee relations, and problem-solving techniques. Successful completion of this course and HRM 2200 (with a B standing) will qualify as an approved credit towards the academic component of the Certified Human Resources Professionals designation (CHRP) granted by the Human Resources Professionals Association of Ontario (HRPAO).
This course introduces students to the role of Operations managers in any business – service provider or manufacturer – and begins to explore the wide range of contributions that these people make to the organization. Operations managers are involved in helping manage resources effectively so that the organization can, in an efficient and competitive way, supply products and/or services that meet the needs of its customers. By the end of the course, students will have developed an awareness of some of the activities and decisions that operations managers are involved with as they strive to continuously improve all aspects of the way the organization designs, produces, and delivers the products or services that its customers demand. Careers in operations management are challenging, rewarding, and diverse, and an important goal of the course is to help students build an awareness of the variety of career paths open to someone with an operations management background. Students will be able to identify common operations management-related positions in an organization and begin to identify the skills and abilities that are commonly required to be successful in this field. Students will begin to assess whether operations management is a good “fit” for their own interests and career goals.
This course is aimed at giving students a practical introduction and understanding of the marketing process and the activities of marketers. The material covered will teach the student the basis of marketing planning and principles which are necessary for any type of successful business enterprise—product or service, large or small, profit or not-for-profit. The creation of customer value, an analysis of the changing business environment and its impact, identification of the customer, and an understanding of their decision making, as well as marketing research methods and their linkage to effective marketing strategies will be examined.
This is the lecture-lab course with emphasis on lab problems. It is intended for students in the three-year CPA program. The programming techniques covered include: Advanced data validation, minor totals, arrays, and sequential and indexed file maintenance. Programming logic will be explored using flowcharting and pseudo-code. This course is a prerequisite for several of the advanced programming courses in semesters 5 and 6. A laptop computer as specified by Durham College must be used by the students.
This advanced programming course focuses on creating applications using the C# programming language and the .NET framework. Topics of instruction include the principles of designing and developing programs using C#, designing a user interface using basic and advanced controls and working with files. An understanding of object-oriented programming fundementals is a requirement to be successful in this course.
This course presents a balanced look at the issues and concepts of a constantly changing computer-oriented society. It explores both the benefits and risks of information technology to society. It covers a variety of topics including the history of computers, applications and societal issues such as privacy, viruses, legal and ethical use of computer resources and emerging technologies that may affect people in the near future. The course requires students to write essays and create PowerPoint presentations on various topics such as ergonomics, smart objects, virtual reality, online voting, video-on-demand, etc. In order to function effectively as information consumers, students must be able to evaluate what they read. Critical thinking requires an open mind, a broad background of experience, knowledge of where and how to find information, and the ability to analyze and evaluate the accuracy of that information. This course uses current I.T. in Society related articles to foster critical thinking, reasoning, recognizing logical fallacies, faulty reasoning, analytical reading, and problem solving.
This subject is an introduction to Java, which is an object oriented programming language. Students will learn to create Java applications implementing commonly used Java provided classes/packages, and how to create object oriented systems to create solutions to satisfy business requirements. The JDBC will also be covered in this subject to show students the basics of how to connect to a database within a Java program, and maintain persistent data.
This is an intermediate course in Microsoft’s Visual Basic programming language. Visual Basic is a principle programming technology in a Microsoft environment, which can be used either as a standalone product to code customized applications, or in conjunction with other products. Key elements of this course include the use of advanced intrinsic .NET objects, user-defined classes, inheritance and collections.
VB 2010 will be used in this course, it is expected that all students have Visual Studio 2010 installed on their laptops for all development in this course, professional version is preferred and students can acquire a copy from Microsoft’s DreamSpark website https://www.dreamspark.com/.
This course is a continuation of Accounting 1 and is designed to provide further insight into the preparation and use of financial statements. It covers inventories, receivables, payroll, current liabilities, special journals and sub ledgers, partnerships and property, plant and equipment. The student is also introduced to accounting for corporations.
This course focuses on the factors that affect the overall atmosphere in the workplace and that which contributes to an environment conducive to maximum productivity. It is an advanced course designed to give students who have decided to further their studies or major in Human Resources an understanding of the technical aspects of the Human Resources field. Students will study the following topics: performance management, compensation, employee benefits and services, labour relations, health and safety, equity and diversity, and international human resources management. Successful completion of this course and HRM 1200 (with a minimum combined grade of 65%) will qualify as an approved credit towards the academic component of the Certified Human Resources Professionals designation (CHRP) granted by the Human Resources Professionals Association of Ontario (HRPAO).
This course focuses on the marketing mix, a collection of business variables which marketers can control and manipulate in changing market conditions. Once the marketing objectives have been developed, a company must decide upon very specific pricing, products/services, distribution and marketing communication strategies. Students will study each of these four marketing mix variables in depth in the context of a marketing plan.
This is the second level survey course in operations management, and provides a continuation of the introductory topics relevant to the operations management profession. Operations managers are involved in helping manage resources effectively so that the organization can, in an efficient and competitive way, supply products and/or services that meet the needs of its customers. This course introduces demand forecasting, planning, process design, layout strategies, work measurement, just in time and lean operations, and supply chain management. Careers in operations management are challenging, rewarding, and diverse, and an important goal of the course is to continue to help students build an awareness of the variety of career paths open to someone with an operations management background.
This is the first of two courses that trains the student in the principles and procedures used in programming online computer systems. This is specifically done by instruction in the IBM online transaction processing system CICS Transaction Server v6.
This course focuses on the key knowledge, skills and abilities of technical support professionals including, decision making, troubleshooting, software installation, communicating successfully with a client, determining the client’s specific needs, and writing for the end user. This course includes the latest in support industry trends, especially the use of Web and e-mail-based support. With balanced coverage of both soft skills and technical skills, this course is an excellent resource for those seeking employment in the technical-support field as well as programmers and analysts.
This is the first of two advanced courses which cover database design and development in theory and practice. Students examine the logical design of today’s Relational Databases and compare/contrast them that with typical file systems. A full understanding of an organization’s data requirements is crucial in the development of a logical database solution for that organization. There will be a strong focus on the expansion of techniques to aid in the development of a design that supports the organization’s data needs.
Microsoft SQL Server 2008 will be used to review both DML and DDL components of the SQL language. Further, SQL Server and Crystal Reports will be implemented through application development to create database solutions based on the student’s logical design for a common business problem.
This course is currently under development.
Elective general education courses appear in your program of study as GNED 0000. This is called a “placeholder.” This placeholder is replaced by an actual course that you will select from a list of available "elective" general education courses when you register in the relevant semester.
Please note that the type and number of elective courses available will vary from semester to semester and from year to year.
Please visit the General Education website for more information.
This course is designed to equip the student with a working knowledge of descriptive statistical methods. Emphasis is balanced among theoretical concepts, calculations, and data interpretation. Major topics covered include frequency distributions, graphic presentation of data, measures of centre and variation, probability concepts, probability distributions, sampling methods, Central Limit Theorem, and correlation/regression analysis . For those students using a laptop computer, the course makes extensive use of the statistical capabilities of Excel.
This introductory course provides a basic understanding of the principles of Project Management, specifically for Information Systems students. Students will learn how to create and monitor a project using Microsoft Project. Students will also plan, manage, execute and close a project, taking into consideration all project constraints. This course combines theory and practical assignments while introducing students to current accepted project management methods and terminology, as outlined by the Project Management Institute (PMI). Students will use their PM and MS-Project skills to control group / case assignments provided by faculty in other courses as an ongoing practical application.
This is the second of two courses that trains the student in the principles and procedures used in programming online computer systems. This is specifically done by instruction in the IBM online system CICS Transaction Server v6. This course will also start to explore versions of CICS processing that support web-based access and web services.
This is the second of two advanced database development courses which cover database processing theory and practice. Students continue to examine the logical design and development of database solutions for typical business scenarios. Students are introduced to physical database design, as well as administrative tasks and management of distributed databases and pertinent legal, ethical and governance issues.
Microsoft SQL Server 2008 will be used to implement database solutions and VB 2010 will be used to create embedded SQL database applications based on client requirements.
This is an advanced course introducing Microsoft’s ASP.Net programming language for web development. ASP.Net can be used either as a standalone product to code customized web applications and/or services, or in conjunction with other Microsoft products. Key elements of this course include the use of intrinsic .Net objects and user-defined classes to develop data-driven websites and web services to meet the demands of typical business problems.
ASP.Net 4 will be the main technology used in this course along with code behind forms written using VB 2010. SQLServer 2008 Express will also be used to provide the necessary data for solutions. It is expected that all students have Visual Studio 2010 and SQLServer 2008 Express installed on their laptops for all development in this course, professional version is preferred and students can acquire a copy from Microsoft’s DreamSpark website https://www.dreamspark.com/.
Computer Programmer Analyst students will carry out course-related practical work in the Information Technology field for four consecutive weeks (twenty days / 150 hours) at the end of their three-year course of study. Field Placement is a requirement for graduation. Workplace insurance coverage is provided by the Ministry.
This course will take an in depth-look at Java programming as it is used for Internet application development. It builds upon the Java programming concepts learned in Java Development and extends the knowledge gained in Internet Development II. There will be discussions on Object Oriented Design and development of three-tier Internet solutions, including theories on setting up and maintaining a well-organized web server. Topics will include: JavaScript basics (looking a client-side data validation and basic page dynamics); advanced utilization of Java in the form of Java Server Pages(JSP)/Servlets (dealing with server-side logic control); and, submitting forms and form-requests to Web servers (including object persistence using a database).
This course provides students with new technologies reflecting up-to-date developments in the industry. Students will always get the most recent information on the newest technologies available and the contents changes every year. The course allows students to make sound decisions regarding which technologies are becoming popular and important in the future. Some of the topics include review of emerging technologies, green computing, cloud computing, virtualization, telecommuting, on-line collaboration (blogs and wikis), Unified Communications /Collaboration, Eco Tech, Information aggregation/business intelligence, Ruby programming , Oracle database, XML, CSS, XSL and Data Integration of XML(files and databases).
Courses and course descriptions are for the next academic year and are subject to change.
Back to TopProgram Costs
| | Domestic | International |
| Tuition Fees | $2,533 | $11,820 |
| Compulsory Ancillary Fees | $1,010 | $1,570 |
| Incidental Fees | $350 | $350 |
| Total Fees: | $4,903 | $13,740 |
Please note: fees are based on the 2012-2013 academic year and do not include textbooks. For more information please see Other fees to consider.
Back to TopLaptop Learning
Students enrolled in laptop programs will enjoy an exceptional learning experience through the use of technology. The advanced technical skills and knowledge that employers look for in graduates will provide students with a decided advantage when entering the workforce. Please pay close attention to the hardware and software requirements of your program as the requirements are not the same for all laptop programs.
How laptop learning works:
- Review your specific program page for hardware and software requirements
- Acquire your own laptop from a vendor of your choosing including all of the hardware and software components listed below
Please note: Some software may be included in tuition fees for some programs. Please ensure that you are required to buy software before making a purchase.
Back to TopLaptop Hardware and Software Requirements
Hardware Requirements
- Intel I7 processor with chipset that must support Intel Virtualization Technology
- 8 GB of ram (16 GB preferred)
- 500 GB hard drive
- CDRW/DVDRW combo drive
- 10/100 Auto Sensing Network Card
- 10/100 A/G/N Standard card (one of these standards will suffice)
- Discrete Video Chipset 256 MB or Shared 512 MB
- One USB 3.0 port (two preferred)
Software Requirements
- Windows 7 Professional 64-Bit
- Microsoft Office 2010 64 bit Ultimate (student license)
Back to TopInternships & Placements
You will participate in a four-week, 150-hour work placement at the end of Semester 6. This will give you practical IT experience supporting an enterprise or business function and give you an opportunity to apply the theories and concepts learned.
Internship
An internship is paid employment that enables you to gain longer-term practical work experience directly related to your area of study. Internships are optional and last four, 12 or 16 months. You can participate in the Internship program prior to your final year of study and then return to Durham College to complete your diploma requirements.
Back to TopOpportunities For Degree Completion Or Additional Credentials
Qualified graduates can go on to take:
Graduates may also be eligible to apply their academic credits toward further study through Durham College’s partnerships with many Canadian and international colleges and universities. Please visit the Transfer Guide for more information.
Back to TopDisability Considerations
Students with disabilities who wish to discuss accommodation plans are encouraged to contact the Centre for Students with Disabilities.
Back to Top share