Computer & Applications   

This course will familiarize students with the digital world by exploring the hardware and software of their computer system. Students will learn to use the most common functions of the Windows operating system including File Explorer for file management, utility programs, various web browsers for social media while observing and identifying security and privacy concerns and issues. Students will learn to build properly formatted documents using Microsoft Word and spreadsheets including correctly functioning formulas using Microsoft Excel and create commanding presentations with Microsoft PowerPoint while using the cloud to store and access their files. No Textbook Required. 
Software Required: Windows, Microsoft Office 2016, 2019 or 365.  MAC users will not be supported in this course. Version 2013 no longer supported.

 

Learn to use Microsoft Excel to create and format spreadsheets in order to analyze data and make more informed business decisions.  You will discover how to; create, edit, format and print workbooks; use mathematical formulas and functions; create and format charts and shapes; insert images; cut, copy and paste data. No Textbook Required. 
Software Required: Microsoft Excel 2016, 2019 or 365.  MAC users will not be supported in this course. Version 2013 no longer supported.

 

Microsoft Access is a computerized database that allows you to manipulate, link, chart, query and report your data to customize the information you need.  You will learn to use Microsoft Access to create databases, view, format, manage and modify data tables and fields.  You will learn to create forms, queries, reports and explore data relationships using its pull-down menus, toolbars and dialog boxes.  Microsoft certified courseware publication is used to present the software features in a well-illustrated graphic format to prepare students to complete the appropriate Microsoft Certification exam #77-730 for students who wish to write the MOS (Microsoft Office Certification).  Students can identify Access Skills to potential employers by successfully completing the course capstone project to earn a skills badge. Prerequisite: Familiarity with Windows and file management concepts No Textbook Required. 

Software required: MS Access v. 2019/365

In this introductory course, you'll learn to create a professional website without having to write code by hand and covers HTML5 and CSS3 for responsive web design. You will also learn how to create HTML-based headings, paragraphs, lists, and tables; insert graphics; add links to text and images; apply cascading styles sheets; and customize the Dreamweaver workspace. And finally, publish a finished site to the Web. Prerequisite: A working knowledge of your computer and operating system. Knowledge of HTML is recommended.

Textbook required. Software Required: Adobe Dreamweaver CS6 or CC.

This course will cover the fundamental aspects of this rising star in the desktop publishing and design industry. Topics covered will include: creating master pages and single and multiple page documents with single and multiple text columns of text; importing text from various sources and flowing it into linked columns of various shapes and sizes; proper kerning/leading and spacing of text and; combining text with imported photos and graphics. Students will learn how to quickly change font or photo size and how to rearrange elements within a page. Assignments will include various document layouts that involve learning about objects, text, colour and fonts. The final assignment be a menu created with all the elements you have learned plus using tables.

Textbook required.

Software Required: Adobe InDesign CC. Supports MAC users. Students please contact instructors immediately upon logging into course to confirm compatibility with their MAC version.

This course will help in developing the students' skills and knowledge in creating digital files for graphic design projects using Adobe Illustrator. As the graphic design industry changes through the development, advancement and integration of computer technology, the importance of learning Adobe Illustrator for the design and production of digital files becomes evident. Textbook required. Software Required: Adobe Illustrator - CS5, CS6 or CC. Lynda.com Access (students to contact registering college for access).

This course will further develop the student’s image correction and restoration skills using Adobe Photoshop. The student will be able to restore black and white images using Adobe Photoshop tools and gain skills in image correction by using, blurring, adjustment layer, layer masks and liquifying techniques. The student will produce content for various media. Prerequisite: Adobe Photoshop 1 No Textbook Required
Software Required: Adobe Photoshop CC

In this course students learn keyboarding techniques using various methods. Keyboarding speed and accuracy are emphasized. Proofreading and editing documents is covered. Research about repetitive stress injury (RSI) and proper ergonomics is included. The student should be able to achieve a minimum speed of 25 net words per minute (nwpm) with 5 or fewer errors with frequent practice.. Textbook Required.
Software/Hardware Required: You will need to access to a home or office personal computer with an Internet connection and Web access. 
Supported Browsers; Chrome version 65 or later,  Firefox version 58 or later, Internet Explorer 11 (Windows 7,8,8.1 only). Compatibility mode is not supported, Microsoft Edge 16 MacOS / OS X, Chrome version 65 or later, Firefox version 58 or later, Safari version 11 or later iOS, Safari version 10 or later. Only the SAM Study Center is supported. 2016 Tasks might not work in portrait mode on iPad, you can't just right-click. Other browsers and versions than those listed might also work, but are not supported. If you have problems when using an unsupported browser, try using a supported browser before contacting your facilitator.

This course will familiarize students with the digital world by exploring the hardware and software of their computer system. Students will learn to use the most common functions of the Windows operating system including File Explorer for file management, utility programs, various web browsers for social media while observing and identifying security and privacy concerns and issues. Students will learn to build properly formatted documents using Microsoft Word and spreadsheets including correctly functioning formulas using Microsoft Excel and create commanding presentations with Microsoft PowerPoint while using the cloud to store and access their files. No Textbook Required. 
Software Required: Windows, Microsoft Office 2016, 2019 or 365.  MAC users will not be supported in this course. Version 2013 no longer supported.

 

This will course provide the student with more advanced and related skills in constructing spreadsheets using Microsoft Excel, developing presentations using Microsoft PowerPoint and creating, maintaining and publishing a database using Microsoft Access. Students completing this course will have a well rounded knowledge of the Microsoft Office Suite. Prerequisite: Computers 1 - Introduction to or equivalent. Familiarity with Windows Operating System, XP or higher as well as file management concepts. No textbook required. Software Required: MS Office 2013 or 2016 Excel/PowerPoint/Access. Short monthly subscriptions to Office 365 are available at an additional cost (relatively small cost) if Access is not included in the version of Office the student is using. MAC users NOT supported in course.

This course provides students with concepts and strategies for writing command level CICS using COBOL programs. CICS provides online transaction processing and management facilities. CICS is used throughout the world at large corporations, banking, finance, health care, insurance, public utilities, government, and a multitude of other public and private enterprises. Students will be making major enhancements to an existing menu driven system.

Using Word, you will learn to combine basic design principles and techniques to produce a variety of printed matter, such as stationery, business cards, posters, newsletters, resumes, and more.  This is a practical, hands-on course that will place emphasis on producing real-life, professional materials using specific desktop publishing terminology and document-handling techniques. Textbook required. Software Required: Textbook assumes a full installation of Word 2010 or Word 2013.

This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course Excel - Core. Students will learn how to create and analyze spreadsheets using PivotTables and PivotCharts, and Excel’s What-If analysis tools. Students also learn many of Excel’s advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create their own custom functions. In addition, students learn how to protect and share their workbooks. This course helps prepare students wishing to pursue the MOS certification exams for Excel Expert (Excel Expert 2016 exam 77-728 and Excel Expert 2019 exam MO-2019). Prerequisite: MS Excel - Core or equivalent.

Software Required: Microsoft Excel 2016, 2019 or 365. Version 2013 no longer supported. MAC users will not be supported in this course.

No Textbook required.

Learn to use Microsoft Excel to create and format spreadsheets in order to analyze data and make more informed business decisions.  You will discover how to; create, edit, format and print workbooks; use mathematical formulas and functions; create and format charts and shapes; insert images; cut, copy and paste data. No Textbook Required. 
Software Required: Microsoft Excel 2016, 2019 or 365.  MAC users will not be supported in this course. Version 2013 no longer supported.

 

Students will learn some of the most important topics of HTML, from the basics of creating Web pages with graphics and links, using tables, and controlling page layout, to more advanced topics including cascading style sheets, and adding pre-written JavaScript to HTML documents. Also how to create a multimedia Web page, and create a Web page with forms. No Textbook Required. 
Software Required: Any word processing software, Basic text editor, Web Browser that supports frames and HTML 4 and up. Students do require access to server space for the final assignment in this course. Note, students my need to pay an additional fee if an acceptable free alternative cannot be sourced.

Students expand on the knowledge and skills acquired in Introduction to Python Programming. Students explore advanced Python data structures, learn to manage project files, and perform basic error handling and testing. Through hands-on activities, students apply recommended programming practices including documentation and naming conventions to build Python files. Prerequisite: Introduction to Python Programming. No Textbook Required.

Gain an understanding of GIS fundamental concepts and terminology including the role of GIS in business, government, surveying and natural resources. Learn how to create and manipulate data using GIS. Examine the collection, management, analysis and presentation of spatial data, concepts of database systems, data modeling and digital mapping. Textbook Required

Software Required: Quantum GIS (QGIS) - free software (Works on Windows, Macs and Linux) but all instructions and tutorials will be based on a Windows environment.

In this course students install and set up a Python development environment and learn to apply fundamental concepts of Python programming by manipulating various data types. Through hands-on assignments, students execute Python scripts that use logical operators, conditional statements, and loops. No Textbook Required.

This course expands upon the basic skills you have in developing Java applications to developing more robust Java applications.  You will learn some of the more advanced Java topics such as utilizing inheritance, the swing toolkit, layout managers, the event model, exceptions and file input/output. Prerequisite: Java Introduction or equivalent Textbook Required. 
Software Required: JAVA SDK, JAVA IDE - both free downloads. Can support MAC users. Have students contact instructors immediately upon logging into course to confirm compatibility with their MAC version.

This course provides the beginning programmer with a guide to developing applications using the Java programming language.  This course covers object-oriented programming concepts including: creating and using classes and methods, loop structures, string method, if/thenelse, joptionPane Class and arrays. Prerequisite: Introduction to computers or equivalent, programming experience is an asset. Textbook Required. 
Software Required: JAVA SDK, JAVA IDE - both free downloads -Can support MAC users. Have students contact instructors immediately upon logging into course to confirm compatibility with their MAC version.

This subject introduces the student to computer programming using the JavaScript programming language. While JavaScript is the language of instruction, the course covers the essential concepts and constructs which are part of most modern programming languages, including sequence, selection, repetition, variables, arrays, and objects. This course leads the student from writing the simplest of programs to creating programs that interact with the elements in a web page. Using only a simple text processor and a browser, the student will write and run programs that utilize variables, calculations, arrays, if statements, loops, objects, and events. In addition to writing programs, the student will also be instructed in the elements of good programming style and their importance.Prerequisite: HTML Introduction Textbook Required.
Software required: Web Browser, Text Editor such as EditPad Lite, Editplus or PSPad.

This course explores network security basics, including how hackers access online networks and the use of Firewalls and VPNs to provide security countermeasures. Students focus on both managerial and technical aspects of security. Coverage includes packet filtering, authentication, proxy servers, encryption, bastion hosts, virtual private networks (VPNs), log file maintenance, and intrusion detection systems. Note:This course has mandatory group work. Textbook required

Preparing students to recognize and understand the inherent vulnerabilities of Windows systems by using and understanding tools and techniques to decrease the risks arising from vulnerabilities in Microsoft Operating Systems and applications, this course introduces defense strategies through understanding of system and file permissions, password and account security, the Windows Registry, Malware prevention, encryption, and Directory Service management via policies. No textbook required.

Learn to use MS PowerPoint for Windows using its pull-down menus, toolbars and dialogue boxes. PowerPoint as a presentation program allows you to create colorful graphics and text slides along with reports for your projects. Prerequisite: This course requires a familiarity with Windows XP or higher. Textbook required. Software Required: MS Office 2013 or 2016 which includes PowerPoint, Excel and Word. MAC users NOT supported in course.

If you have never written a computer program and have wondered how to do it, here is an opportunity for you. Working at a fairly relaxed pace, you can learn how to store information in the computer, how to determine what the computer does next, and how to get information into and out of the computer. Other topics will be included as time permits. Upon successful completion of this course, you will have a general understanding of what is involved in computer programming. Those wishing to pursue further programming courses will be well prepared for an intensively paced course. Textbook required. Software Required: You will need access to a C compiler for this course.

C is a powerful, efficient, portable, and flexible programming language, making it one of today's most popular choices for writing computer programs. This course introduces structured programming and problem solving techniques using C. Upon successful completion of the course, students will have a firm foundation for other programming courses, including C++. The course covers many aspects of C, from variable, simple operations, and flow control to input/output, arrays, pointers, strings, and structures. You do not need to have prior computer programming experience to take this course, but please be aware that this is a fast-paced intensive course. You will need access to a C compiler. Prerequisite: Familiar with your computer's operating system. Textbook required. Software Required: Access to a C or C++ compiler is required.

QuickBooks Online (QBO) is a cloud-based accounting software program. Students will learn the difference between QuickBooks Pro and QBO before utilizing program features. Students will explore and apply key features, including: tracking and communicating customers, invoicing, supplier management, profitability analysis, payroll, HST management and reporting. Additionally, students will explore 3rd party application integration. Prerequiste: Knowledge of basic accounting and Windows Textbook Required

Students will learn the advanced software features required to organize and prepare complex professional documents. Prerequisite: Word - Specialist (or equivalent) and familiarity with Windows and file management concepts. Textbook required. Software Required: Microsoft Word Version 2010 or 2013. MAC users NOT supported in course.

Learn to use MS Word 2019 or 365 for Windows, a word processing package that has the convenience and efficiencies of pull-down menus.  Learn to create, edit, format and print documents.  Use paragraph, page, and character formatting commands.  Create multiple page documents with table, and desktop publishing with MS Word. No Textbook Required

Software Requirements: MS Word 2016, 2019 and 365 are supported. MAC users are not supported.

Learn to build and maintain a website using WordPress, the most used Content Management System (CMS) in the world. Students will understand and apply web design principles that will support their ability to service small and medium sized business clients. Select the best hosting solution and domain name for a website. Evaluate, recommend and apply themes, plugins, widgets, content architecture, user experience and other solutions. Analyze client needs and apply appropriate solutions within a WordPress environment. Understand the basic concepts of Search Engine Optimization (SEO) and Search Engine Marketing (SEM). Implement security and backup strategies and learn how to use WordPress as a complete e-commerce platform. Prerequisite: Foundational knowledge of web browsing and navigation, Basic knowledge of creating, saving and uploading computer files (Windows/MacOS), Basic understanding of HTML is an asset but not required. No Textbook Required.