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.
Electronic Publishing and Emerging Library Technologies
Focus on electronic publishing, including using basic web design, 3D printing, screen recording, blogs, microblogs, augmented reality and gamification.
This course will provide leaders with the appropriate skills and knowledge to be able to effectively recruit personnel, train them, and manage their performance in a professional manner. Leaders will use their knowledge of the concepts of statutory and common law to conduct interviews, handle performance problems, counsel and discipline as required, plan and direct training needs assessments, methods and program delivery. This course includes mandatory group work. We recommend viewing the course schedule immediately upon logging into the course to view course and group work requirements.
Today's leaders are often called upon to implement and support the change process. They need to be able to identify and respond to internal and external factors that will determine when and what type of change initiatives are required. Environmental scanning, identifying trends, implementing and measuring successful change are all essential to developing and managing change to the benefit of the organization. Organizational readiness and risk assessment will also be covered in the context of best practices.
Leaders in any organization need to understand the cost of doing business. Financial documents are used to explain how money is used in a business and can be interpreted to predict an organization's success. The ethical and effective use of financial statements and ratio calculations for forecasting and budget preparation can ensure investments or withdrawals within an organization will produce a healthy return or mitigate decline in other areas. Knowing the processes for assessing ROI, creating a budget and anticipating variances are critical in any organization in order to make effective decisions.
This advanced course in calculus contains some special methods of integration, Maclaurin, Taylor and Fourier series, various types of first and second order differential equations, an introduction to Laplace transforms, and applications to the electrical/electronics area.Prerequisite: OL722 Calculus
Students 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.
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.Computer Software Requirements: Microsoft Word 2016
This course takes a decolonized approach to examining Canadian history and the relationship between Indigenous peoples, settlers, and the Canadian government from first contact to the present. Focusing on Indigenous perspectives, worldviews, and experiences, it highlights early cooperation and partnerships during the fur trade, the significance of the treaty-making era, and the profound impact of British and early Canadian colonial policies on Indigenous rights, communities, and identity. The course also analyzes the lasting effects of colonization and the ongoing efforts of Indigenous peoples to heal from harm, reclaim their rights, and restore their culture in contemporary Canada. Finally, the course highlights Indigenous resilience, resistance, and resurgence in shaping modern society, deepening understanding of the historical and current dynamics between Indigenous peoples and Canada. This insight is crucial for engaging with the ongoing process of truth and reconciliation in Canada today.
In this course, students will gain an understanding of the historical factors that contributed to the creation of Residential Schools, including the history of colonization and the relationship between the government and Indigenous communities. Students will reflect upon and further develop their understanding of the ongoing impact of Residential Schools.
In this course, students are engaged in an examination of Indigenous cosmology(s), knowledge(s), and world view(s) as they intertwine with the land. By centering the influence of the land on Indigenous worldviews, and through a self-reflective process, we aim to cultivate a holistic understanding of contemporary perspectives on identity, self-determination, and worldviews. This course will examine Indigenous narratives, oral traditions, language, culture, and storytelling traditions, including the relationships between human beings, the land, and spiritual dimensions. By inviting reflection and introspection, students will gain insights into the complexities of their own cultural backgrounds and their relationships with the land.
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.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.