SYLLABUS COVERAGE PROGRESSION SHEET
COURSE: MICROSOFT EXCEL
CERTIFICATION: NATIONAL DIPLOMA EXAMS
Institution: VTI- GLONETA TIKO. Training Year: _______2024/2025_______
First Semester Breakdown
Course Title: Microsoft Excel Basic Skills. Code: MSE 201
Semester period : 5th October - 15th December
Semester focus: The focus will be on building foundational skills in Ms Excel
Weeks Teaching/ Learning unit Guide of lesson
1: 02 oct- 06oct. 2024 CHAPTER 1: Basic Skills in MS Excel
Overview of the Excel
Lesson1: introduction to Microsoft Excel interfac
-Creating, opening, and
saving workbooks
- Understanding file formats
(.xlsx, .csv, etc.) in excel
application
2: 09 oct -13 oct Lesson 2: Basic Cell and Worksheet - Entering and editing data in cells
Operations
- Selecting, copying, cutting, and
Practical work pasting data
- Inserting and deleting rows,
columns, and sheets
3: 16 oct -20 oct Lesson 3: Basic Formatting - Formatting cells: font styles, sizes,
and colors
Practical work
- Number formatting: dates,
currency, percentages
- Alignment, borders, and fill colors
4: 23 oct -27oct Lesson 4: Basic Formulas and Functions Introduction to formulas and
functions
Practical works
- Using basic arithmetic operators
(+, -, *, /)
- Common functions: SUM,
AVERAGE, MIN, MAX
5: 30 oct - 03 Nov Evaluation ( Theory and practice)
6: 06 Nov - 10 Nov Lesson 5 : Working with Tables - Creating and formatting tables
- Sorting and filtering data
- Using structured references in
formulas
7: 10 Nov -13 Nov Lesson 6: Data Visualization - Creating and formatting basic
charts (column, line, pie)
- Adding and editing chart elements
- Understanding chart types and
their uses
8: 20 Nov - 24 Nov Basic Data Validation - Setting up data validation rules
- Using drop-down lists
- Handling invalid data entries
9: 27 Nov - 1st Dec Practical assessment: creating a formatted Real work & simulation
document with images involving printing
10: 04 Dec - 08 Dec Practical assessment: creating a formatted Real work & simulation
document with list involving printing
11: 11Dec - 15 Dec 1st Semester Examination and
ChristmasBreak
Second Semester Breakdown
Course Title: Microsoft Excel Advanced Skills and Features Code: MSW 202
Semester period : 2nd January - May 20th
Semester focus: The focus will be on advancing to more complex functionalities
Week Teaching/ Learning units Guide of lesson
12: 02 Jan-05 Jan 2025 Lesson 7: Advanced Formatting and - Custom number formats
Conditional Formatting
- Applying conditional
Practical work formatting rules
- Using data bars, color scales,
and icon sets
13: 08 Jan- 12 Jan Lesson 8: Advanced Formulas and
Functions
- Logical functions: IF, AND, OR,
Practical work NOT
14: 15 Jan- 19 Jan - Lookup functions: VLOOKUP,
HLOOKUP, INDEX, MATCH
15: 22 Jan-26 Jan - Text functions: LEFT, RIGHT,
MID, CONCATENATE
Practical work
16: 29 Jan-02 Feb Lesson 9: Advanced Charting - Creating advanced chart types
Techniques (scatter, combo, histogram)
Practical work - Customizing chart elements
and layouts
- Using sparklines for data
visualization
17: 05 Feb - 09 Feb Evaluation ( Theory and practice)
18: 12 Feb -16 Feb Lesson 10 : PivotTables and - Creating and formatting
PivotCharts PivotTables
Practical work - Grouping and summarizing
data in PivotTables
- Creating and customizing
PivotCharts
19: 19 Feb-23 Feb Lesson 11: Data Analysis Tools - Using the Analysis ToolPak
Practical work - Descriptive statistics: mean,
median, standard deviation
- Performing regression analysis
and using Solver
20: 26 Feb -1st Mar Lesson 12: Collaboration and - Sharing workbooks and
Protection tracking changes
Practical work - Using comments and notes
- Protecting worksheets and
workbooks with passwords
21: 04 Mar - 08 Mar Lesson 13: working with Macros - Recording and running macros
Practical work - Editing macros in VBA (Visual
Basic for Applications)
- Assigning macros to buttons
and events
22: 11Mar- 15 Mar Practical assessment: - creating a Real work and simulation
complex workbook with advanced
formulas, PivotTables, and macros
23: 18Mar- 23 Mar Revision with ND exam past questions
24: 25 Mar - 28 Mar Revision with ND exam past questions
N B: This scheme of work is designed to ensure students gradually build their skills and confidence in
using Microsoft Excel, preparing them for both academic and professional use.
