Computer Software 4 Syllabus
MICROSOFT GRAPHICS SYLLABUS:
EXCEL, WORD 6 GRAPHICS/PAINTBRUSH, DESKTOP PUBLISHING, ACCESS, POWERPOINT
EXCEL:
1. SPREADSHEET AS ICON ON WORD 6 TOOLBAR; SEPARATE ICON ON MICOSOFT OFFICE TOOLBAR; AND WINDOWS 95 PROGRAM. REVIEW OF BLANK SPREADSHEET SCREEN (TOOLBAR, MENUS, ROWS, COLUMNS, CELLS); WORKBOOK VS. WORKSHEET; MOVEMENT AROUND SPREADSHEET.
2. SPREADSHEET SCROLLING METHODS; LABELS, VALUES; CELL EDITING; ALIGNMENTS; SPREADSHEET CREATION.
3. CELL SELECTION; BASIC FORMULAS; CLOSING, SAVING. OPENING; AUTOMATIC SUM; RANGES; FUNCTIONS; ARGUMENTS; COLUMN/ROW SELECTION; CUT, COPY, PASTE; PRINTING (PAGE SETUP, PRINT PREVIEW).
4. FORMULAS; FORMATTING (CURRANCY, PERCENTAGES, DECIMALS, COMMAS); CHANGING FONTS; FUNCTIONS.
5. NUMERIC LABELS; SCIENTIFIC NOTATIONS; KEYBOARD MOVEMENT OPTIONS; RIGHT-CLICKING; SPREADSHEET EXERCISES.
6. COLUMN WIDTH; HEADER, FOOTER; SETTING PRINT AREA; MOVING, COPYING, DELETING, DRAG AND DROP; AUTO FILL (FILL HANDLE); FIND/REPLACE; SPELLCHECK; TOOLBAR OPTIONS.
7. OPTIONS MENU; DRAWING TOOLBAR, CELL PROTECTION, SORTING.
8. FREEZING CELLS; SPLITTING THE SPREADSHEET; ADDING, DELETING; COPYING FORMULAS; CHARTING INFORMATION (CHART WIZARD)
WORD 6 GRAPHICS/PAINTBRUSH
9. CHARTS IN WORD (RELATIONSHIP TO EXCEL CHARTS) CREATING CHARTS; CHART TYPES, EDITING; ENHANCING.
10. OVERVIEW OF GRAPHIC TOOLS; SIMILARITY BETWEEN PAINTBRUSH AND WORD 6 DRAWING TOOLBAR; BASIC FUNCTIONS, OPTIONS.
11. USE OF GRAPHIC TOOLS; ENHANCEMENT OPTIONS; COLOR BOXES; LINE AND SHAPE TOOLS.
12. WORKING WITH SHAPE TOOLS; FREEFORM; TEXT BOXES (IN FRONT OF OBJECTS/BEHIND OBJECTS); LINE STYLES; SELECTING DRAWING OBJECTS; DRAWING EXERCISES.
13. DRAWING OBJECTS; CUT, COPY, PASTE; TEXT BOXES; WATERMARKS.
DESKTOP PUBLISHING
14. OVERVIEW OF WORD 6 TOOLBAR AND MENUS; FONT ENHANCEMENTS; BOLD, ITALICIZE, UNDERLINE; SYMBOLS; HANGING INDENTS; BULLETS; ALIGNMENTS; PRINT PREVIEW; ORIENTATION; KERNING; CHARACTER SPACING.
15. EXERCISE IN DESKTOP PUBLISHING.
16. EXERCISES.
17. USE OF COLUMNS. NEWSLETTERS. WORD ART. CLIPART.
18. NEWSLETTERS, CONTINUED. DROPCAPS. EDITING GRAPHICS.
19. USE OF TABLES IN DESKTOP PUBLISHING (EXERCISES).
20. MORE TABLES (COMPARISON WITH COLUMNS) CREATING ITINERARIES, AGENDAS.
21. GRAPHICS USING TEXT AND PICTURES.
22. MORE TEXT/PICTURE GRAPHICS; WATERMARKS
ACCESS
23. INTRODUCTION; CONCEPTS; CREATION OF DATABASE, FIELDS AND TABLE.
24. DATABASE CREATION; USE OF TWO TABLES; FORMS; CHARTS.
25. QUERIES; QUERY WINDOW; SIMPLE QUERY EXAMPLES; RUNNING QUERIES; REVISING
26. SORTING; USING AND/OR OPTIONS; QUERING MORE THAN ONE TABLE;
27. COMPUTED FIELDS; CALCULATING STATISTICS; GROUPING.
28. USING FIND FEATURE UNDER FORMS; CREATING AN INVENTORY DATABASE.
29. MAINTAINING AN INVENTORY DATABASE; UPDATING CONTENTS; PRODUCING A REPORT.
POWERPOINT
30. OVERVIEW; APPLYING TEMPLATES; CREATING SLIDES; USE OF TOOLBAR; MOVING THROUGH SLIDES; SLIDE SORTER.
31. TRANSITIONS BETWEEN SLIDES; COLOR ENHANCEMENTS; BUILD CHOICES;SLIDE SHOW PRESENTATION.
32. REVIEW