LESSON CONTENT

🎯 Learning Objectives

By the end of this module, learners will be able to:

  • Analyse data using spreadsheets

  • Summarise and format datasets

  • Create pivot tables and charts

  • Build dashboards

  • Import and visualise data

  • Perform basic data scraping

🔹 Lesson 1: Reporting Data Using Spreadsheets

📘 Content

  • Creating spreadsheets

  • Organising data into tables

  • Using formulas (SUM, AVERAGE)

  • Creating charts (bar, line, pie)

💡 Example

  • Total sales = SUM(column)

  • Average = AVERAGE(values)

🔹 Lesson 2: Summarising & Formatting Data

📘 Content

  • Sorting and filtering data

  • Using tables

  • Conditional formatting

  • Data validation

🔹 Lesson 3: Pivot Tables & Charts

📘 Content

  • Creating pivot tables

  • Summarising large datasets

  • Creating pivot charts

💡 Example

  • Sales per region using pivot table

🔹 Lesson 4: Dashboards

📘 Content

  • Combining charts and tables

  • Data visualisation

  • Using slicers and filters

🔹 Lesson 5: Data Importing

📘 Content

  • Import from CSV files

  • Import from databases

  • Import from reports

🔹 Lesson 6: Data Visualisation

📘 Content

  • Identifying trends

  • Using graphs effectively

  • Presenting insights

🔹 Lesson 7: Data Scraping

📘 Content

  • Extracting data from websites

  • Using tools for scraping

  • Storing and analysing scraped data

 

PreviousNext