Computer & Applications   

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.

 

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.

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.

Examine the difference between QuickBooks Pro and QuickBooks Online (QBO, a cloud-based accounting software program). Apply key features including: tracking and communicating with customers, invoicing, supplier management, profitability analysis, HST management and reporting. Prerequiste: Knowledge of basic accounting and Windows Textbook Required

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: Desktop version of Microsoft Word 2019 or 365. Online MS Word does not include all features taught and assessed.  Effective Spring 2026, MAC users are supported in this course. 

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

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

This course describes the architecture, components, and operations of routers and switches in a small network. Students learn how to configure a router and a switch for basic functionality. By the end of this course, students will be able to configure and troubleshoot routers and switches and resolve common issues with RIPv1, RIPng, single-area and multi-area OSPF, virtual LANs, and inter-VLAN routing in both IPv4 and IPv6 networks. Pre-requiste: CCNA 1 Introduction Textbook Required.

Software Requirement: Computer that has Internet connectivity; Word processing package (e.g: MS Word), Software will be provided free for download. 

CCNA 3 advances the study of the architecture, components, and operations of wide area networks. The course explores dynamic routing, firewalls, VPN concepts, network automation, virtualization and a selection of WAN technologies. This is the final of three courses that are designed to provide the knowledge and skills necessary for successful completion of the Cisco Certified Network Associate (CCNA) examination. By the end of this course, students will be able to configure and troubleshoot OSPF, ACL, NAT and IPsec in IPv4 and IPv6 wide area networks. Textbook Required. 

Software Requirement: The course textbook includes network simulator software that may be used for course assignments.

Students in this course will gain practical hands-on experience using email, word processing, presentation, and accounting software. The Microsoft Office suite is the most prevalent used by business today and components of the Office package will be utilized in this course. Sage 50 accounting software is widely used across Canada by many small and medium sized businesses and will be the accounting software of choice. Students will record business transactions in the General Journal, Accounts Payables, Accounts Receivables, and Inventory modules. Students will also calculate and account for sales taxes. Textbook Required

This is a hands-on computer applications course that provides the student with the basic and intermediate word processing skills to produce professional business documents. Students will also develop expertise in electronic presentation software and spreadsheet applications in order to meet the demands of today's business industry. Prerequisite: Previous computer and internet experience. Textbook Required.

Software Required: Office 365 (2019)

Examine the fundamental and integrational aspects of designing, managing, and implementing a Geographic Information System (GIS). Apply skills such as Information Technology (IT) expertise, research, procurement and project management. Examine data providers and data management, requests for proposal, system life cycles, benchmarking, general practices of project management, and various standards for spatial data. Prerequisite: Intro to Geographic Information Systems, GIS Software, Global Positioning Systems, Internet Mapping, Remote Sensing, Relational Database Management Systems, Spatial Database Management and Integration. Textbook Required.

Software required: Relational Database of your choice (i.e. MS Access)

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.

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.

 

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.

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.

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: Introduction to Computers 1 or equivalent. No textbook required.

Software Required: Windows, Microsoft Office 2016, 2019 or 365 Excel/PowerPoint/Access. MAC users will not be supported in this course.

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.

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.

Students expand on the knowledge and skills acquired in Introduction to Python Programming/Python Development I. 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.

Software Requirements: Students will be required to set up a GitHub account using their student email address to participate in this course.  Students will be required to use/purchase a Linkedin Subscription/License to participate in this 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: Desktop version of Microsoft Word 2019 or 365. Online MS Word does not include all features taught and assessed.  Effective Spring 2026, MAC users are supported in this course. 

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.