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

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

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.

 

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

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

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: MS Word 2016, 2019 and 365 are supported. MAC users are not supported.

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.