Available courses

Engaging students with Moodle- Yamna Ettarres- Shared

The Student engagement with Moodle Moodle course presents some ideas to engage students in a Moodle Course: labels with images, texts and links, a book with H5P MCQ, a choice activity, a quiz with feedback, a database activity with a tiles format template. With the database template, it is possible to expand images for larger viewing, while incorporating a black background.

Gamification is presented using the Activity results block (Set up with a quiz) and badges. A step-by-step content in a Moodle page explains how to add a badge to a Moodle course.

The course is developed by Dr. Yamna Ettarres, Knowledgeone Inc. (Opens in new window), 2022.

It is shared under the License: Attribution-NonCommercial CC BY-NC.



Computer Applications

Welcome to the Computer Applications course. This course focuses on both theoretical knowledge and hands on application projects. The course will prepare students to not only utilize Microsoft Word, Excel, PowerPoint, and Access software, but will also to be able to translate this knowledge to other similar application software commonly used in industry.

Learning outcomes
By reviewing this resource, learners will be able to:
Describe
the role of computer applications in various fields
Apply
computer applications to solve real-world problems
Analyze
the features and functions of different computer applications
Create
documents, spreadsheets, and presentations using computer applications

Introduction to Data Science

Excel Beginner to Advance

If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.

Microsoft Excel is a feature-rich spreadsheet program that allows users to create and format workbooks for data analysis and decision-making. Some key features and functions include:

  • Data Tracking and Analysis: Excel enables users to track data, build models, and analyze data using various tools.
  • Formulas and Calculations: Users can write formulas to perform calculations, and Excel supports over 400 worksheet functions, including advanced functions like dynamic array formulas.
  • Data Visualization: Excel provides options to present data through professional-looking charts and pivot tables. It also includes features like slicers for interactive data filtering.
  • Conditional Formatting: Users can apply conditional formatting to visually explore and analyze data, helping to identify patterns and trends.
  • Advanced Data Types: Excel allows users to work with advanced data types such as Stocks and Geography, which can be easily converted from text.
  • Freeze Panes: This feature allows users to keep specific rows or columns visible while scrolling through the rest of the worksheet.
  • Autocomplete and AutoSum: Excel can autocomplete entries in cells and quickly sum rows or columns of numbers using the AutoSum feature.

📘 Module 1: Excel Basics

Objective: Build foundational skills.

  • Lesson 1.1: Introduction to Excel Interface
    • Workbook vs Worksheet
    • Ribbon, Tabs, and Quick Access Toolbar
  • Lesson 1.2: Data Entry and Formatting
    • Cell types, formatting numbers, dates, text
  • Lesson 1.3: Basic Formulas and Functions
    • SUM, AVERAGE, MIN, MAX, COUNT
  • Lesson 1.4: Sorting and Filtering Data
  • Lesson 1.5: Basic Charts (Bar, Line, Pie)

📗 Module 2: Intermediate Excel

Objective: Enhance productivity and data handling.

  • Lesson 2.1: Logical Functions
    • IF, AND, OR, NOT
  • Lesson 2.2: Lookup Functions
    • VLOOKUP, HLOOKUP, XLOOKUP
  • Lesson 2.3: Conditional Formatting
  • Lesson 2.4: Data Validation and Drop-down Lists
  • Lesson 2.5: Named Ranges and Tables
  • Lesson 2.6: PivotTables and PivotCharts

📙 Module 3: Advanced Excel

Objective: Master data analysis and automation.

  • Lesson 3.1: Advanced Formulas
    • INDEX-MATCH, INDIRECT, OFFSET
  • Lesson 3.2: Array Formulas and Dynamic Arrays
    • FILTER, SORT, UNIQUE, SEQUENCE
  • Lesson 3.3: Power Query Basics
  • Lesson 3.4: Power Pivot and Data Modeling
  • Lesson 3.5: Introduction to Macros and VBA
  • Lesson 3.6: Dashboard Design Principles