This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course OL702 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-201). Computer Software Requirements: MS Excel version 2016, 2019, 2021 or 365 for windows. MAC users are not supported in this course.
Learn MoreHave you ever needed to design your own business card or a flyer for an event? If so, this is the course for you. Design Basics will give you the building blocks of design. You will learn about fonts, different layout techniques and simple layout concepts essential to effective graphic design. It is recommended that students have knowledge of InDesign, Illustrator or Photoshop. Computer Software Requirements: Word Processing Software. Students require a design/page layout program such as Adobe InDesign, Adobe Illustrator, Adobe Photoshop, Canva, or Corel Draw capable of creating and saving small graphic design compositions in jpeg or PDF formats.
Learn MoreStudents will learn how to communicate with each other, manage their time and work more efficiently using Microsoft Office Outlook 365. Proper email etiquette for sending and receiving electronic mail, organizational methods for storing mail, mailboxes, address books, contact lists, tasks and journals are among the topics covered. Computer Software Requirements: Microsoft Outlook 365.
Learn MoreUsing 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.Computer Software Requirements: Microsoft Word 2016
Learn MoreThis 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.It is recommended that students have taken OL766 HTML Introduction prior to taking this course. Note: Students will require a text editor, such as EditPad Lite, Editplus or PSPad.
Learn MoreThis 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. Computer Software Requirements: Adobe Illustrator - CS5, CS6 or CC
Learn MoreThis course introduces fundamentals of C# programming language. Students will explore object-oriented programming (OOP) concepts including data abstraction, inheritance and polymorphism. Using .NET and C#, students will learn to design, code and document business-oriented programs. Computer Software Requirements: Recommended Min. of 192 MB of RAM (384 MB preferred) At least a 1 GHz processor (1.6 GHz preferred) Microsoft Windows 7 or Windows 8 At least 1.6 GHz processor (2.2 GHz preferred) Software: Visual Studio.net 2022, which is a free download.
Learn More