| Applications I Lessons |
| Lesson | Assignments | Length | Comments |
| 1 | Read Pages W1-W16; Do All Exercises. | 4 days | Exercise 1.11 must be printed after step 13, |
| Print 1.11 (W16); Review 1.1 (W19) | just before they close the document. The |
| hyperlink in lesson 1 works on selected |
| computers only. |
| 2 | Read W21-W35; Do Al Exercises except 2.8 | 3 days | Cannot access the Web through Word's |
| (W35). Print 2.4 (W30); 2.7 (W34); "On | Web Toolbar. Students needing to go to the |
| Your Own" (W39) | Web must minimize Word, and launch |
| Netscape Navigator. Exercise 2.8 cannot be |
| done because the Mail Recipient is disabled |
| on the Network. |
| 3 | Read W41-W57; Do All Exercises. Print: | 2 days | In order to do Review Exercise 3.1, you |
| Review 3.1 and 3.2 (W57); "On the Web" | must be in "Page Layout" view, and have |
| (W58) | the right margin set at 6". When entering the |
| internet address in the OTW exercise, make |
| sure you use Netscape, not Word. |
| 4 | Read W59-W81; Do All Exercises. Print: 4.7 | 4 days | Normal View does not let one see many |
| (W69); 4.8 after step #6 (W70); 4.9 (W73); | format changes. One must be in Page |
| 4.13 (W77); Review 4.1, 4.2, & "On Your | Layout View, for example, to see words |
| Own" (W82) | underlined, bolded, italicized, etc. |
| 5 | Read W85-W104; Do All Exercises. Print: | 2 days | Production Tests given after this section. |
| 5.1 (W86); 5.2 (W89); 5.3 (W91); 5.4 (W93); | Topics on the Production Tests include: |
| 5.5 (W96); Review 5.1 (W104) | formatting paragraphs; indenting; font |
| changes; tab alignment; spell and grammar |
| checking. |
| 6 | Read W105-W120; Do All Exercises except | 3 days | Macros are skipped because of security |
| 6.4 (Macros, W111). Print: 6.3 (W108); 6.5 | concerns. There is a discrepancy with the |
| (W113); 6.9 (W120); Review 6.2 (W122) | directions in the textbook, and the results |
| one gets for exercise 6.3. Look at the |
| solutions manual very carefully in order to |
| satisfy the requirements of this exercise. |
| 7 | Read W125-W143; Do All Exercises. Print: | 3 days |
| 7.2 (W128); 7.4 (W132); 7.6 (W136); 7.8 |
| (W138); 7.11 (W141); 7.13 and 7.14 |
| (W143); Revioew 7.2 (W146) |
| 8 | Read Very Carefully Pages W149-W157; Do | 4 days | Keep in mind that the order in which one |
| All Exercises Up to 8.6 step 1. Print: 8.6 | does the Main Document and Data Source is |
| (after step 1, p. W157); Review 8.1 (W164) | important! This lesson may be done quite |
| readily if you read directions carefully, and |
| follow the steps in order. |
| 9 | Read W165 - W183; Do All Exercises. Print: | 4 days | Wrapping text around graphics is |
| 9.5 (W171); 9.9 (W176); 9.12 (W180); 9.14 | challenging in this section. An interesting |
| (W181); 9.15 (W183): Reviews 9.1 and 9.2 | project this lesson will be to create |
| (W185); Selected Handouts | Halloween cards for your favorite teacher. |
| 10 | Read W187 - W204; Do All Exercises. Print: | 3 days | This lesson will concentrate on views other |
| 10.5 (W195); 10.6 (W197); 10.8 (W200); | than the normal page layout view. You will |
| 10.9 (W202; print pages 1 and 5 only); | learn how to create cross-references, |
| 10.10 (W204); Reviews 10.1 & 10.2 (W207) | insert captions, create footnotes and |
| endnotes, and create an index and table of |
| contents. Caution: some students may not |
| be able to print outlines of documents (as |
| requested in Review 10.1, for instance); |
| instead, their computer may print entire |
| 11 | Read EX1-EX14; Do All Exercises. Print: 1.3 | 3 days | This is the introductory lesson on Microsoft |
| (EX11); 1.4 (EX14); Review 1.2 (EX16) | Excel. The concepts of workbook, |
| worksheet, cell, and fill are emphasized |
| here. NOTE: In order to do Review Exercise |
| 1.2, you must do Review Exercise 1.1, and |
| 12 | Read p. EX19 - EX32; Do All Exercises. | 2 days | In order to view web pages, remember to |
| Print: 2.5 (EX 29); Review 2.1 (EX34); OYO | minimize Excel and launch Netscape |
| Navigator (p.s: the site that the textbook has |
| you go to is invalid; go to |
| http://www.microsoft.com and search for |
| "Excel"). Exercise 2.7 has you attempting to |
| save the file in .html format, but the filter is |
| not yet installed on the network. |
| 13 | Read EX37-EX56; Do All Exercises. Print: | 3 days |
| 3.6 (EX50); 3.8 (EX56); Review Exercises |
| 3.1 & 3.2 (EX59); OYO (EX60) |
| 14 | Read EX61-EX68; Do All Exercises. Print: | 2 days |
| 4.1 (EX63); 4.2 (EX65); 4.3 (EX68); Review |
| Exercises 4.1 & 4.2 (EX70) |
| 15 | Read EX73-EX87; Do All Exercises. Print: | 4 days | Pay particularly close attention to margins |
| 5.2 (EX77, after step #17); 5.2 (EX79, after | before printing (refer to Print Preview). |
| step #8); 5.8 (EX86); Reviews 5.1 & 5.2 | Further, remember to click on "create a |
| copy" box when you use the Move or Copy |
| Sheet command in Review Exercise 5-2. |
| 16 | Read EX93-EX103; Do All Exercises. Print: | 3 days | The "Summer.wmf" clipart that is needed for |
| 6.3 (EX99); 6.4 (EX100); 6.5 (EX102); 6.6 | exercise 6-5 is located in the w:\my |
| (EX103); Review Exercises 6.1 & 6.2 (EX | documents\excel 97 folder, not the clipart |
| gallery. |
| 17 | Excel Lesson 7 | SKIP | Macros are disabled on the network |
| 18 | Read EX127-EX141; Do All Exercises. Print: | 3 days | This lesson serves as an introduction to |
| 8.3 (EX133); 8.4(EX135); 8.5(EX139); | databases, which are covered thoroughly in |
| 8.6(EX140); 8.7(EX141); Review Exercises | Applications II using Microsoft Access. |
| 8.1 & 8.2(EX144) |