Week |
Subject |
Assignments Due |
T
9/1 |
Class Setup, Windows, Login |
|
TH 9/3 |
Word: 1. Insert,
modify, and move text and symbols
3. Correct spelling and
grammar usage
18.Create documents using
templates
19.Save documents using
different names and file formats
|
|
T 9/8 |
2. Apply and modify text
formats
4. Apply font and text
effects
5. Enter and format Date
and Time
6. Apply character styles
10.Apply bullet, outline,
and numbering format to paragraphs
|
Word1.
Quiz: Able to start up any software and open any data
file.
|
TH 9/10 |
8. Modify paragraph formats
9. Set and modify tabs
11.Apply paragraph styles
12.Create and modify a
header and footer
17.Manage files and folders
for documents
Windows Explorer
|
Word2. |
T 9/15 |
13.Apply and modify column
settings
14.Modify document layout
and Page Setup options
20.Insert images and
graphics
21.Create and modify
diagrams and charts
|
Word3.
Quiz: Able to open any file and save to any location.
|
TH 9/17 |
15.Create and modify tables |
Word4
Folder Assignment
|
T 9/22 |
Tools, mail merge, autocorrect
16.Preview and Print
documents, envelopes, and labels
22.Compare and Merge documents
23.Insert, view and edit
comments
24.Convert documents into
Web pages
|
Word5-Internet Tutorial. |
TH 9/24 |
Word Test |
Word6 |
T 9/29 |
Excel:
1. Insert, delete and move cells
2. Enter and edit cell data including text,
numbers, formulas
3. Check spelling
4. Find and replace cell data and formats
|
|
TH 10/1 |
6. Manage workbook files and folders
7. Create workbooks using templates
8. Save workbooks using different names and
file formats
9. Apply and modify cell formats
10. Modify row and column
settings
11. Modify row and column
formats
12. Apply styles
13. Use automated tools to
format worksheets
14. Modify Page Setup
options for worksheets
15. Preview and print
worksheets and workbooks
Naming cells
|
Excel1 |
T 10/6 |
19. Create and revise
formulas
20. Use statistical, date
and time, financial, logical functions
=If() and =Vlookup()
|
Excel2 |
TH 10/8 |
16. Insert and delete
worksheets
17. Modify worksheet names
and positions
18. Use 3-D references
Multiple Workbooks
|
|
T 10/13 |
21. Create, modify,
position, and print charts
22. Create, modify, and
position graphics
|
Excel3 |
TH 10/15 |
Sort, Subtotals, Pivot Table
5. Work with a subset of data by filtering
lists
|
Excel4-Internet Tutorial |
T 10/20 |
23. Convert worksheets into
Web pages
24. Create hyperlinks
25. View and edit comments
|
Excel5 |
TH10/22 |
Excel Test |
|
T 10/27 |
Powerpoint
1. Create presentations (manually and using
automated tools)
2. Add slides to and delete slides from
presentations
3. Modify headers and footers in the Slide
Master
4. Import text from Word
5. Insert, format, and modify text
6. Add tables, charts, clip art, and bitmap
images to slides
7. Customize slide backgrounds
8. Add OfficeArt elements to slides
9. Apply custom formats to tables
|
|
TH 10/29 |
10. Apply formats to
presentations
11. Apply animation schemes
12. Apply slide transitions
13. Customize slide formats
14. Customize slide
templates
15. Manage a Slide Master
16. Rehearse timing
17. Rearrange slides
18. Modify slide layout
19. Add links to a
presentation
20. Preview and print
slides, outlines, handouts, speaker notes
|
Ppt1 |
T 11/3 |
21. Import Excel charts
into slides
22. Add sound and video to
slides
23. Insert Word tables on
slides
24. Export a presentation
as an outline
|
Ppt2-Internet Tutorial |
TH 11/5 |
25. Set up slide shows
26. Deliver presentations
27. Manage files and
folders for presentations
28. Work with embedded
fonts
29. Publish presentations
to the Web
30. Use Pack and Go
31. Set up a review cycle
32. Review presentation
comments
33. Schedule and deliver
presentation broadcasts
|
|
T 11/10 |
Powerpoint- Test |
|
TH 11/12 |
Powerpoint- presentations |
Student PPT Presentation |
T 11/17 |
Access:
1. Create Access databases
2. Open database objects in multiple views
3. Move among records
4. Format datasheets
5. Create and modify tables
13. Enter, edit, and delete
records
15. Sort records
16. Filter records
|
|
TH 11/19 |
6. Add a predefined input mask to a field
7. Create Lookup fields
8. Modify field properties
|
|
T 11/24 |
9. Create and modify Select queries
10. Add calculated fields
to Select queries
14. Create queries
17. Create one-to-many
relationships
18. Enforce referential
integrity
|
Access1 |
T 12/1 |
11. Create and display
forms
12. Modify form properties
|
Access2-Internet Tutorial |
TH 12/3 |
19. Create and format
reports
20. Add calculated controls
to reports
21. Preview and print
reports
|
Access3 |
T 12/8 |
22. Import data to Access
23. Export data from Access
24. Create a simple data
access page
|
Access4 |
TH 12/10 |
Access Test |
Access5 |
T 12/15 |
Go Over Grades |
|