A PRACTICAL APPROACH TO MEET TECHNOLOGY CHALLENGES
Modern society is using technology almost every day, everywhere. This brings up many challenges to businesses, governments and people. Technology has to be efficient. It has to help and serve people. It has to be secure. To address these challenges, we need well trained professionals who can handle the current needs but most importantly, can create new innovative solutions to improve our daily lives, make our systems safer and make technology more useful.
Our revised program addresses these issues in many ways. First, we have increased the number of hours in the lab to make our classes more practice oriented. Next, we have increased the number of hours spent on networking and security, since these two aspects alone are increasingly important. And of course, we still cover all the other important aspects of the career like programming, the WEB, the human touch – yes, IT professionals DO interact with other human beings – business aspects and finally, databases.
Mathematics 526 or 564506 or 565506-TS or SN Level 5
Information Technology (IT) is used in all areas of businesses and industry, from Agriculture and Aerospace to Waste Management and Wireless Communications. This means that there is an incredible variety of careers open to qualified CST graduates, ranging from selecting and installing hardware and software, to programming and implementing applications and complete information systems, as well as user support and network management. During their three years of study, future professionals will acquire a comprehensive knowledge of how to apply the computer to most common business information systems, in traditional and web-based environments as well as in mobile or wireless environments. They will learn to use a variety of development tools, including multimedia tools, and will learn how to assist users to get the most out of their computerised systems.
The program has a practical orientation and emphasizes the use of industry-sought structured and object-oriented techniques, whether it is in problem solving, in systems analysis and development, or in program design and construction. Unique to Lennoxville, the program also includes more in depth coverage of networks, security and cloud computing. The program concludes with a full semester “practical apprenticeship” in a local business where the students get a chance to apply the skills learned in the first five semesters in a real business setting. This last semester is also the occasion for students to take a “distance education” course, where course material will be offered through the Internet.
The IT professional is a person who can work alone or as a member of a team. He or she is curious, capable of concentration and can approach a problem with a creative and analytical mind. This person also communicates effectively, both orally and in writing, and adapts quickly to changing circumstances. By its very nature, the ever-changing computer industry requires that the IT professional be a lifelong learner.
At the end of the program a graduate will be ready to enter the job market as an entry level computer technician. More specifically, he or she will be able to:
- organise work time efficiently and effectively, either alone or as a member of a team;
- carry out the analysis and design of applications for both stand-alone and web environments (needs assessment, analysis, program design, database design);
- develop applications (programming, testing, implementation, documentation);
- provide application support (user support, user training, maintenance);
- perform hardware installation, maintenance and upgrades;
- perform software installation, maintenance and upgrades;
- plan, install and maintain local area networks, in a variety of operating system environments;
- demonstrate critical thinking and problem solving skills;
- demonstrate ethical behaviour, both professionally and personally;
- communicate effectively in English in both oral and written form;
- communicate with relative ease in a French working environment;
- be aware of the importance of a healthy lifestyle to his or her general well being.
THE COMPREHENSIVE ASSESSMENT
The Comprehensive Assessment is a required integrative activity that allows students to demonstrate, in a real working environment, the knowledge and skills acquired during their studies, so that the student’s attainment of the graduate profile objectives can be verified. Students must successfully complete a 15 week internship in a real working environment during the sixth semester followed by a written report and an oral presentation. Three questionnaires, one completed by the student’s company supervisor, one by the teacher supervisor and one by the student himself complete the evaluation.
Many Quebec universities grant advanced standing (DEC-BAC) in Information Technology related programs to graduates of the CST program. A DEC-BAC agreement with Bishop’s University is available for graduates of the program. The Université de Sherbrooke is also a good example of a university that grants advanced standing. These programs usually require additional Math courses. Consult specific universities for details.
Also, graduates of the Computer Science Technology program may complete a Bachelor of Information Technology degree in one year at Griffith University in Australia.
Total courses : 36
Total credits : 91 2/3
|Physical Education 101||109-101-MQ|
|Humanities - Knowledge||345-101-MQ|
|Mathematics for IT||201-M10-LE|
|IT Careers and Skills||420-C10-LE|
|Computers Inside Out||420-S10-LE|
|Physical Education 102 or 103||109-10?-MQ|
|Humanities – World Views||345-102-MQ|
|French – General||602-10?-MQ|
|Help Desk/User Support||420-C20-LE|
|Multimedia and Web Design||420-D20-LE|
|Windows Operating Systems||420-S20-LE|
|English for AMT and CIS||603-BEM-LE|
|Statistics for IT||201-M30-LE|
|Systems Analysis and Design||420-D30-LE|
|Object Oriented Programming||420-P30-LE|
|Unix Operating Systems||420-S30-LE|
|Humanities for AMT and CIS||345-BEM-LE|
|French – Specific||602-BE?-LE|
|English 102 or 103||603-10?-MQ|
|Business Fundamentals for IT||401-C40-LE|
|Database Design and Use||420-D40-LE|
|Database Application Development||420-P40-LE|
|English 102 or 103||603-10?-MQ|
|Soft Skills for IT||350-C50-LE|
|Web Programming 2.0||420-P60-LE|
|201-M10-LE||MATHEMATICS FOR IT||(2-2-2) 60 HRS / 2 CR|
This course focuses on elements of mathematics that are important for information technology. Topics include: number systems (decimal, binary, octal, hexadecimal), representation of data in computer memory, truth tables, computer-related logic, basic concepts of Boolean algebra and logic circuits, proof by induction, matrices and systems of linear equations.
|420-C10-LE||IT CAREERS AND SKILLS||(1-3-3) 60 HRS / 2 1/3 CR|
This course introduces students to the variety of careers available to them upon graduation, as well as to some of the software tools used every day by workers in this field: word processing, spreadsheet, presentation, diagramming, project management and time management software. While examining the various IT job titles, professional and work ethics as well as current laws governing the IT professions will be reviewed. Through examination of work functions in the main career areas of software, hardware, networks and support services, students will also learn the fundamental concepts and vocabulary of Information Technology. They will also learn how to use a client-centred approach to conduct a needs assessment and to use proper research techniques to prepare the resulting hardware/software proposals.
|420-P10-LE||PROGRAMMING 1||(1-4-3) 75 HRS 2 2/3 CR|
This is the first course in programming. The student will learn to translate an algorithm (step by step solution to a problem) into the Visual Basic .NET structured programming language. The student will learn to develop user interfaces using a subset of the controls available in the Integrated Development Environment (IDE). The student will learn how to use flowcharts, pseudocode and TOE (Task Object Event) charts to represent algorithms. He or she will then develop these algorithms using the three programming control structures: sequence, selection and iteration. The student will also learn and apply a proper methodology in writing, testing, and debugging programs for simple interactive applications.
|420-S10-LE||COMPUTERS INSIDE OUT||(2-3-3) 75 HRS / 2 2⁄3 CR|
This course will cover the architecture of computer systems, both desktop and wireless mobile devices. Students will learn to identify hardware components and recognize the characteristics and function of components such as processors, memory, buses, clocks, input/output ports, transmitters and receivers. Students will understand how these components function to form a useful device. They will also learn how peripheral devices (printers, disk drives, keyboards, touch screens, CD-ROM, etc.) function. Students will learn how to search efficiently to solve problems and will be asked to report on their findings through documents or class presentations. Finally, the students will learn the basics of troubleshooting microcomputer problems and will learn how to install and uninstall hardware components and the required software. Students will also learn how to properly document their work.
|420-C20-LE||HELP DESK/USER SUPPORT||(2-2-3) 60 HRS / 2 1⁄3 CR|
This course will teach students the fundamentals of organising and working at help desks. Through simulated and actual work with users (students and staff), students will learn the skills needed to help novice and intermediate users solve problems they encounter when using computers. They will also learn about the tools used to document and to track problem reports, and will prepare a short course or workshop for staff or students on a computer-related topic.
(Prerequisites: 420-C10-LE, 420-S10-LE)
|420-D20-LE||MULTIMEDIA AND WEB DESIGN||(2-4-3) 90 HRS / 3 CR|
This course will introduce the students to multimedia elements and concepts, as well as hardware and software tool used in building multimedia Web sites. Students will also learn the basics of user-centred web page design. As part of the required course work, students will have to collaborate on the design and development of a multimedia web site and will learn to analyse, plan and track their work using project management software such as Microsoft Project.
|420-P20-LE||PROGRAMMING 2||(1-5-3) 90 HRS / 3 CR|
This course continues the study of the programming language VB.NET. Building on the knowledge gained in the course 420-P10-LE, the student will learn to design and write programs of increasing complexity. The student will learn the concept of data structures for organizing data in memory and in files. Arrays, structures, and collections are the main programming constructs used to store data in memory while sequential and random file access represent the fundamental means of storing data on external media. The student will also be introduced to the different techniques for sorting and searching data. The use of proper programming style and current programming standards will be emphasized throughout the course
|420-S20-LE||WINDOWS OPERATING SYSTEMS||(1-3-3) 60 HRS / 2 1/3 CR|
In this course, students will learn how to use the file, desktop, memory and application management features of Windows operating systems. They will also learn how to install and uninstall software, how to use the operating system’s command language to automate tasks, and how to verify the functionality of the user’s workstation environment, including wireless devices.
|201-M30-LE||STATISTICS FOR IT||(2-2-2) 60 HRS / 2 CR|
This course will allow students to develop computer-related mathematical and statistical knowledge and skills while learning to use a spreadsheet application such as Microsoft Excel. Topics include: descriptive statistics; using lists, tables and graphs in Excel to organize, summarize and present information; sets and Venn diagrams, counting principles, permutations and combinations; basic rules of probability; probability distributions such as binomial, Poisson and normal distributions; and an introduction to statistical inference.
|420-D30-LE||SYSTEMS ANALYSIS AND DESIGN||(2-3-3) 75 HRS / 2 2⁄3 CR|
This course will teach students the concepts, tools and techniques needed to analyse, design and document information systems using the structured development approach. Students will learn to use appropriate CASE (computer-aided system engineering) tools to create data models and process models. The course will cover the theory and techniques required. Students will get to apply these newly learned techniques, as well as the project management skills learned in the Multimedia for the Web course, in a major Systems Analysis project.
(Prerequisites: 420-D20-LE, 420-P20-LE)
|420-N30-LE||NETWORK MANAGEMENT||(1-3-3) 60 HRS / 2 1⁄3 CR|
This course examines the how networks can be used to support the information needs of the organisation. Students will examine the features and functions of network hardware, network software, data organisation. Students will also learn how to use a network operating system such as Windows to create accounts and award access rights and restrictions to users based on their needs and organisational practices.
|420-P30-LE||OBJECT ORIENTED PROGRAMMING||(1-4-3) 75 HRS / 2 2⁄3 CR|
This course teaches the student the fundamental concepts of Object-Oriented Programming (OOP) and their implementation in the Java programming language. The student will be introduced to the notions of class, object and data encapsulation, which constitute the core of the OOP approach to program development. This will be followed by a study of the different types of relationship between classes. In particular, the inheritance mechanism will be studied and will serve to implement the concept of code reuse. The student will be introduced to Object-Oriented Design. He or she will learn to create and gradually refine an Object Model for an application using the Unified Modeling Language (UML) standard. The student will also learn to correct faulty programs by analysing a program's behaviour to identify the nature of the problem and to determine appropriate code modifications.
|420-S30-LE||UNIX OPERATING SYSTEMS||(1-2-2) 45 HRS / 1 2/3 CR|
In this course, students will learn how to use the file, desktop, memory and application management features of UNIX/Linux operating system. They will also learn how to install and uninstall software and how to use the operating system’s command language to automate tasks.
|401-C40-LE||BUSINESS FUNDAMENTALS FOR IT||(3-2-2) 75 HRS / 2 1⁄3 CR|
This course gives the CST students an understanding of the business environment and the application of the various information systems for business operations, in order to prepare them for their role as an IT specialist/technician in a business environment. The course will cover the business management process and business functions such as Marketing, Production, Finance, Accounting, and Human Resources, as well as the different types of information systems used to support them. The students are introduced to an overall integrated picture of Canadian business and its operations. Students will learn the fundamentals of business in its contemporary environment and the organizational, national, and international trends that affect business both large and small.
|420-D40-LE||DATABASE DESIGN AND USE||(1-3-3) 60 HRS / 2 1⁄3 CR|
This course will allow students to explore data modelling for complex relational databases. Students will analyse the features of a database and of the DBMS (database management system) used to manage it. They will use SQL Server to create and manage databases. They will also use a combination of SQL (Structured Query Language) commands and programming to update databases with queries and forms, etc. Database security and data integrity issues will also be covered.
(Prerequisite: 420-D30-LE, corequisite: 420-P40-LE)
|420-N40-LE||NETWORK SECURITY||(1-3-3) 60 HRS / 2 1⁄3 CR|
In this course, students will learn how to secure a workstation as well as a network server from various common attack methods, such as denial of service, sniffing, spoofing, and port scanning. Network topology and data communication protocols will be examined in determining appropriate measures in securing a computer environment.
(Prerequisites: 420-N30-LE, 420-S30-LE)
|420-P40-LE||DATABASE APPLICATION DEVELOPMENT||(1-4-3) 75 HRS / 2 2⁄3 CR|
This course will allow students to develop, implement, test, and document a small database application using Microsoft Access. In the first part of the course, the student will learn to use the basic features of Access such as tables, forms, queries and reports. The student will also be introduced to macros and VBA programming. In the second part of the course, the student will perform the analysis, design, and data modeling for a simple database system. The student will also develop the user interface, write VBA code, perform quality assurance tests, and produce the program documentation.
|350-C50-LE||SOFT SKILLS FOR IT||(1-2-3) 45 HRS / 2 CR|
This course allows students to learn about interpersonal relationships and communication techniques in the workplace. Emphasis will be placed on establishing and maintaining relationships, listening and speaking skills, non-verbal communication, conflict resolution, teamwork, and ethical behaviour in the workplace. There will also be some discussion of discrimination, motivation, power and stress. A practical approach will be taken regarding the process of job hunting including cover letters, resumes and interviewing. As well, students will learn to become more self-aware so they can assess their personal techniques with the aim of improving their communication skills.
|420-N50-LE||CLOUD COMPUTING||(1-3-3) 60 HRS / 2 1/3 CR|
Expanding on the knowledge gained in the courses Windows Operating Systems, Network security, and Network Management, students will plan, design, setup, and use an Intranet Cloud. They will also look at the various advantages and disadvantages of Cloud Computing.
|420-P50-LE||WEB PROGRAMMING||(2-4-3) 90 HRS / 3 CR|
This course will cover the technology needed to develop a successful and efficient Web application. Using current tools such as ASP.NET, the student will post a traditional desktop database application to the Web. To do so, they will make appropriate modifications to the application, ensure its quality through extensive testing, and produce technical and user documentation. The Web application will be developed following a three-tiered application model comprising a presentation layer (user interface), a business logic layer (code), and a data layer (database).
(Prerequisites: 420-D20-LE, 420-P40-LE)
|420-P51-LE||GAME PROGRAMMING||(1-4-3) 75 HRS / 2 2/3 CR|
This course is an introduction to the field of game programming using Java. Building on the knowledge gained in the course 420-P30-LE Object-Oriented Programming, the student will learn to develop casual games for mobile devices running on the Android operating system. Topics covered will include getting familiar with the Android platform, developing a simple animation framework, image management and manipulation, sprite animation, sound effects and music.
|420-C60-LE||INTERNSHIP||(1-31-2) 480 HRS / 11 1/3 CR|
Through this course, students in the CST program integrate the knowledge they have gained in all the previous courses in the program, and apply these skills in a real business environment. The project undertaken will allow the student to implement an application, the nature of which will vary with each stage site. Professional behaviour (punctuality, adherence to schedules, ethics, suitable interpersonal skills, etc.) on the part of the student will be expected at all times when dealing with employers, co-workers or clients.
Depending on the stage, the student may also have to conduct a complete or partial systems analysis, or develop an application using the structured or object-oriented methodology; he or she could also develop a database application, provide application support, perform hardware/software installation, maintenance and upgrades or plan, install and maintain local area networks in a variety of operating system environments.
The classroom contact hour is reserved for weekly meetings with the stage supervisor and formal presentations to classmates at the end of the course. Students will have to write a 10-page report that summarises their experience.
The comprehensive assessment for the CST program is attached to this course. The comprehensive assessment verifies that the student achieved the program objectives. There will be an entry in the “Bulletin Cumulatif” reporting the result (pass or fail) of the comprehensive assessment. The student must pass their Comprehensive Assessment to receive their DEC.
(Prerequisites: All CST Program-specific and 345-BEM-LE, 603-BEM-LE).
|420-P60-LE||WEB PROGRAMMING 2.0||(1-4-2) 75 HRS / 2 1⁄3 CR|
NOTE: SOME COURSE TITLES MAY DIFFER SLIGHTLY ON STUDENTS' TRANSCRIPTS; PLEASE REFER TO COURSE NUMBERS.