Week#

 Topics

1

WHAT IS A COMPUTER

·          Components of a computer system: hardware, software

·          Creating a directory tree, using Windows Explorer.

2

INTRODUCTION TO WORD PROCESSING AND MS WORD I

·          Window elements, ribbons, wrapping, page breaks (hard-soft).

·          Spell check, Autocorrect

·          Paragraphs Formatting (Indents, borders, shading, columns), section break.

·          Creating a compound document (Inserting Clip Art, Wordart, Symbol, Autoshape)

3

MS WORD II

·          Styles. Autoformat, outline view.

·          Working with long documents. Table of contents.

·          Bulleted-numbered lists, outlines.

·          Tables: Page setup.

4

INTRODUCTION TO SPREADSHEETS AND MS EXCEL I

·          Toolbars and menus in spreadsheets. Cell reference, formulas, and constants.

·          Entering data, move, copy data, formula, Autofill.

5

MS EXCEL II

·          Absolute cell reference, functions, formatting a worksheet.

·          The IF, VLOOKUP functions

6

MS EXCEL III

·          Graphics and charts. Chart wizard, multiple data series.

·          Creating a presentation, content and formatting and color scheme, animating the presentation.

7

LAB EXAM 1

8

MS ACCESS

Introduction to Database Management System: Elements of a database. MS Access Environment: Opening, Creating, and Saving. Using Access to develop simple database.

·          Demonstration of a relational database

·          Creating a simple database with sample tables, forms, reports and relationship. Data entry modifies, delete, sort and filter.

·          Tables: Design, properties, view, Table Wizard.

9

·          Review of creating a table.

·          Forms: Controls, properties, Form wizard.

·          Creating a More Sophisticated Form: Option Group, Command Buttons.

10

M I D T E R M 

11

·          Reports: Creating a Report Using Wizard

·          Queries: Select Queries, Grouping Records

12

·          Review of Select Queries and redo

·          Action Queries, Cross tab Queries

13

·          Relations: Creating a relational database

14

LAB EXAM 2