Scheme of Work
ECDL Term 3-
Module 4 and 5 (Excel and Access)

Word version of this document

Click on the Lesson titles for full lesson plans in Word format

SCHEME OF WORK ECDL TERM 3 -

 

LESSON 1

SECTION 1
GETTING STARTED: STARTING EXCEL; THE EXCEL SCREEN; MENUS; TOOLBARS; THE WORKSHEET WINDOW; MOVING AROUND; HELP; THE OFFICE ASSISTANT; CLOSING EXCEL


SECTION 2
SECTION 2 OPEN AND CLOSE WORKBOOKS; OPENING A WORKBOOK; CLOSING A WORKBOOK; USING SCROLL BARS; MULTIPLE WORKBOOKS./

SECTION 3
CREATING AND SAVING WORKBOOKS; STARTING A NEW WORKBOOK; ENTERING; LABELS; ENTERING NUMBERS; SAVING A NEW WORKBOOK; SAVING A NAMED WORKBOOK; SAVING IN DIFFERENT FORMATS; SAVE AS WEB PAGE

SECTION 4
FORMULAS: FORMULAS; BRACKETS; PERCENTAGES; AUTOSUM; CHECKING FORMULAS

 

LESSON 2

SECTION 5
EDITING CELLS; DELETE CELL CONTENTS; UNDO/REDO; RANGES; FILLING A RANGE; USING THE FILL HANDLE; COPY AND PASTE; CUT AND PASTE; FINDING SPECIFIC TEXT; REPLACING TEXT; SPELL CHECKING; SORTING A LIST

SECTION 6
PRINTING
PRINTING A WORKSHEET; PRINT PREVIEW; PAGE SETUP; MARGINS; PAGE BREAK PREVIEW; PRINT A SELECTION; HEADERS AND FOOTERS; PRINT OPTIONS; DISPLAY AND PRINT FORMULAS;


SECTION 7
FORMATTING
FORMATTING; BOLD, UNDERLINE & ITALIC; FONTS & FONT SIZE; FORMAT NUMBER; DATE & TIME; ALIGNMENT; CHANGING COLUMN WIDTH; CHANGING ROW HEIGHT; INSERTING ROWS AND COLUMNS; DELETING ROWS AND COLUMNS; ADDING BORDERS; TEXT COLOUR; ;ROTATE TEXT; FREEZE PANE; ZOOM

 

LESSON 3

SECTION 8
FUNCTIONS; COUNT & AVERAGE; RELATIVE ADDRESSES; ABSOLUTE ADDRESSES;

SECTION 9
CHARTS & OBJECTS: INTRODUCING CHARTS; CREATING A CHART; EMBEDDED CHARTS; FORMATTING CHARTS
OBJECTS;

 

LESSON 4

EXERCISES IN EXCEL
POWER POINT REVISION

 

LESSON 5

EXERCISES IN EXCEL
POWER POINT REVISION



LESSON 6

SECTION 1
DATABASE PRINCIPLES; STARTING ACCESS; MENUS AND TOOLBARS; HELP; OPENING AN EXISTING DATABASE; THE DATABASE WINDOW; CLOSING TABLES AND DATABASES.

SECTION 2
TABLES: MOVING USING THE MOUSE; MOVING USING THE KEYBOARD; CREATING A NEW DATABASE: DESIGNING AND PLANNING; CREATING A TABLE STRUCTURE ; FORMAT FIELD PROPERTY; DEFINING A PRIMARY KEY; INDEXES; DEFAULT VALUES; ENTERING DATA IN A TABLE

 

LESSON 7

SECTION 3
EDITING: CHANGING COLUMN WIDTHS; CHANGING THE ROW HEIGHT; FINDING TEXT; USING WILDCARDS; EDITING DATA ; EDITING - CONTINUED; UNDO; FURTHER EDITING; ADDING/DELETING RECORDS; EDITING SHORTCUTS


SECTION 4
SORTING AND FILTERING; SORTING DATA; USING FILTERS; FILTERS: EXCLUDING SELECTION; FILTER FOR

 

LESSON 8

SECTION 5
QUERIES: QUERYING A TABLE; RANGES OF VALUES; PATTERNS; NON-MATCHES; NULL SEARCHES; AND QUERIES; OR QUERIES

SECTION 6
FORMS: FORMS; AUTOFORM; DESIGNING A FORM; FORMATTING A FORM; EDITING A FORM; EDITING/BROWSING DATA; IMPORTING AN IMAGE

 

LESSON 9

SECTION 7
REPORTS: CREATING A NEW REPORT; PREVIEWING A REPORT; AUTOREPORT; GROUPED REPORT: WIZARD

 

LESSON 10


MOCK REVISION AND PAPER WORK