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.
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.
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
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. No Textbook Required.
Software Required: Django installation and other third-party libraries from the Python Package Index (PyPI)
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.
In this course, students will be instructed in the hands-on use of computer-aided drafting using the latest version of AutoCAD. Topics include drawing setup, construction and modification, the use of layers, dimensioning, hatching, the creation and use of blocks, and the Design Centre, with the objective of producing industry-standard drawings. Students will be working on drawings that are related to their program of study. Textbook required.
Software required: Access to AutoDesk education products are available here. If you need a quick video tutorial you can find it here. You will have to create and account and validate that you are a student if you are having difficulties the Autodesk support page is available here. Students who are unable to access the Student Autocad software will be responsible for purchasing Autocad. **This course does not support MAC users.**
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.
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.
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 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.
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.
Software required: Web Browser, Text Editor such as EditPad Lite, Editplus or PSPad.
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.