| Course Essentials: |
INTRODUCTION TO COMPUTERS
1. How a computer works
2. Computer components
3. Input/Output/Storage devices
4. Networks and the internet
5. Purchasing a personal/desktop/notebook/tablet computer
WINDOWS
1. The Start Menu
2. Logging on and off
3. Using Icons
4. Resizing & moving windows
5. Keyboard and keyboard shortcuts
6. Windows explorer
a. Creating and naming folders
b. Copying, renaming, and deleting files
7. Finding files and folders
WORD
1. Navigating the Word window
2. Customizing and using menu bars and toolbars
3. Entering text
4. Formatting documents
a. Text size and font
b. Paragraph alignment
c. Bolding, italicizing, underlining text
d. Inserting graphics
5. Correcting errors
6. Saving, naming printing and closing documents
7. Creating research papers
a. MLA style
b. Margin adjustments
c. Headers and footers
d. Autocorrect functions
e. Footnotes/page numeration
f. Works Cited page
g. Hyperlinks
8. Creating Resumes and cover letters
9. Creating web pages using word
EXCEL
1. The Excel worksheet
2. Menu bar
3. Customizing Toolbars
4. Selecting cells, rows and columns
5. Entering data
6. Basic calculations
7. Formatting the worksheet
a. Font type, style, size, color
b. Cell bolding, underlining
c. Fill handle
d. Centering/aligning cells; column/row widths
e. Background colors
f. Rotating text
g. Borders
h. Formatting numbers
i. Conditional formatting
8. Inserting and deleting cells in the worksheet
9. Formulas
a. Order of operations
b. Entering and copying formulas
c. AutoSum button
d. Average, Max and Min functions
e. IF/THEN statements
10. Spellchecking
11. Adding a chart/graph to the worksheet
12. Renaming and reordering sheets
13. Saving, printing and closing worksheets
14. Converting Excel workbooks to Web pages
POWERPOINT
1. Starting and customizing PowerPoint
2. Toolbars and menu bars
3. Design Templates
4. Creating text and bulleted slides
5. Viewing presentations in slide show view
6. Reviewing presentations in slide sorter view
7. Changing slide layouts
8. Inserting, moving and sizing clip art and images
9. Applying animation schemes
10. Headers and Footers
11. Printing outlines and slide shows
12. Emailing slide shows
13. Publishing on web pages
ACCESS
1. Creating and using a database
2. Access window
3. Entering and updating records
4. Creating, saving and closing tables
5. Creating and running queries
6. Sorting data in a query
7. Filtering records
8. Indexing
9. Creating and printing reports |