|
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
|