Computer & Applications   

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.

A continuation of the Introduction course, Dreamweaver Advanced will present material for the serious or professional web designer. Concepts explored include: HTML5 and CSS3, typography, layouts, navigation, interaction design, managing CSS, working with javascript behaviours and CSS interactivity, utilizing advanced time saving features within Dreamweaver, and developing mobile websites using Dreamweaver and jQuery Mobile. Prerequisite: Adobe Dreamweaver. Knowledge of HTML is recommended. Textbook Required.

Software Required: Adobe Dreamweaver 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

This course is designed to familiarize the student with basic computer operations and applications through instructor-led exercises, activities, and case studies. It explores various concepts of effective computer usage with a hands-on introduction to the Windows operating system, file management, and working effectively and collaboratively in an online environment. It provides in-depth exploration and application of various features of the current version of Microsoft Office software including Word, PowerPoint, and Microsoft Teams. Microsoft Excel is covered briefly in this course.

Software Required: Computer with Windows operating system and Microsoft Office Suite. MSTeams is used for scheduled lectures/seminars each week. 

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. 

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)

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.

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.

The demand for cross-platform web-based applications has increased tremendously with the rapid growth of mobile and remote computing. This course is aimed at students who wish to develop professional, database-driven web sites that can be accessed with equal ease from any web-enabled computing device. Students will install the Apache and MySQL servers on the platforms of their choice and develop web-based applications in PHP and SQL. Prerequisite: HTML Introduction 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.

 

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.

 

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 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 explore the fundamentals of AutoCAD for Windows. They examine the industry standards of interior design to produce a partial set of drawings of floor plans and elevations. Students examine the differences between drawings for client presentations and contractor installations. Through online content, interactive follow-along videos, and practical exercises, students draw, manage, modify, annotate, and export drawings of floor plans and elevations. Textbook Required. 

Software Required: AutoCAD for Windows. A link to download the required software is provided within the course. This course does not support MAC users.

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 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 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.

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.

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.

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.

Students apply their knowledge and skills of python to build a database-backed web application using the Django framework. Students deploy the application to a managed cloud-based platform-as-a-service. Through a project-based approach, students install and import modules from third party libraries, build database schemas and queries using Python and object-oriented programming patterns, and securely serve dynamic content over the web. Prerequisite: Intermediate Python Programming - Building and Packaging an Application/Python Development II. No Textbook Required.
Software Required: Django installation and other third-party libraries from the Python Package Index (PyPI)

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

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

Create advanced level business documents that are in high demand in today's business world. You will learn how to effectively create valuable business documents that incorporate data from several Microsoft Office Applications. Prerequisites: Excel - Specialist, Word - Specialist, Access - Specialist, PowerPoint. No textbook required. Software required: MS Office Suite 2010 or higher. Note: Access is not available for the MAC System. It only runs on a Windows platform. Mac Users will be required to download Windows or have access to a PC machine.

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.

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.

This course comprises four modules that provide informtion on how to use anti-virus software and spam filters to protect your computer from scams and viruses. Learn how to spot phoney companies and services from their ‘fake’ ads. Find out how to report scams and security breaches. Learn how to back-up important information, secure files, label sensitive information, and how to avoid data loss.

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