Week |
Topic |
Project # |
Description |
1&2
Due-Jan 16 |
XP |
1.1 |
Objective 1 in Go! book. show step 11 (p.g. 13)
- screen shot like Figure 1.11
(similar,not exact)
MUST TURN IN:
Create screen shot of your desktop like the one shown above and store under filename Project1.1.jpg upload to , DUE noon (12pm) on Jan 16
|
1.2 |
Objective 3 in Go! book. show step 8 (p.g. 23)
- screen shot like Figure 1.21
(similar, not exact)
MUST TURN IN:
Create screen shot of your desktop like the one shown above and store under filename Project1.2.jpg upload to , DUE noon (12pm) on Jan 16
|
1.3 |
Objective 5 in Go! book. show step 11 (p.g. 37)
- screen shot like Figure 1.34
(similar, not exact)
- MUST TURN IN:
Create screen shot of your desktop like the one shown above and store under filename Project1.3.jpg upload to , DUE noon (12pm) on Jan 16
|
1.4 |
Objective 7 in Go! book. show step 9 (p.g. 52)
- screen shot like Figure 1.49
(similar, not exact)
- MUST TURN IN:
Create screen shot of your desktop like the one shown above and store under filename Project1.3.jpg upload to , DUE noon (12pm) on Jan 16
|
2
Due Jan 23 |
Word |
2.1 |
Hands-ON Exercise 1 in Chapter 1/Word (pg. 81) show step 5
- screen shot like following
(similar, not exact, chap1_ho1_credit_solution
)
|
2.2 |
Hands-ON Exercise 2 in Chapter 1/Word (pg. 96) show step 5
- screen shot like following
(similar, not exact,
- chap1_ho2_credit_solution)
|
2.3 |
Hands-ON Exercise 3 in Chapter 1/Word (pg. 110) show step 5
- screen shot like following
(after removing a word option of inspect document from the customize quick access toolbar)
(similar, not exact,
chap1_ho3_credit_solution
)
|
3
Due-Jan 30 |
Word |
3.1 |
Hands-ON Exercise 1 in Chapter 2/Word (pg. 140) show step 3
- screen shot like following
(similar, not exact,
chap2_ho1_description_solution
)
|
3.2 |
Hands-ON Exercise 2 in Chapter 2/Word (pg. 152) show step 7
- screen shot like following
(similar, not exact,
chap2_ho2_description_solution
)
|
3.3 |
Hands-ON Exercise 3 in Chapter 2/Word (pg. 164) show step 6
- screen shot like following
(similar, not exact,
chap2_ho3_gd_solution
)
|
3.4 |
Hands-ON Exercise 4 in Chapter 2/Word (pg. 173) show step 6
- screen shot like following
(similar, not exact, table of contents,
chap2_ho4_gd_solution
)
|
4
Due Feb. 6 |
Word |
4.1 |
Hands-ON Exercise 1 in Chapter 3/Word (pg. 201) show step 4
- screen shot like following
(similar, not exact, create table
chap3_ho1_vacation_solution
)
|
4.2 |
Hands-ON Exercise 2 in Chapter 3/Word (pg. 212) show step 4 and 7
- step 4: screen shot like following
(similar, not exact, more table
chap3_ho2_vacation_solution
)
- step 7: screen shot like following
(similar, not exact, more table
chap3_ho2_expenses_solution
)
|
4.3 |
Hands-ON Exercise 3 in Chapter 3/Word (pg. 227) show step 4
- screen shot like following
(similar, not exact, art, symbols
chap3_ho3_ergonomics_solution
)
|
4.4 |
Hands-ON Exercise 1 in Chapter 4/Word (pg. 258) show step 4
- screen shot like following
(similar, not exact, collaboration-
chap4_ho1_proposal_solution
)
|
4.5 |
Hands-ON Exercise 2 in Chapter 4/Word (pg. 270) show step 5
- screen shot like following
(similar, not exact, compare/combine, document maps-
chap4_ho2_maps_solution
)
|
4.6 |
Hands-ON Exercise 3 in Chapter 4/Word (pg. 283) show step 4
- screen shot like following
(similar, not exact, referencing resources, bibliography, footnotes, endnotes -
chap4_ho3_plagiarism_solution
)
|
4.7 |
Hands-ON Exercise 4 in Chapter 4/Word (pg. 292) show step 4
- screen shot like following
(similar, not exact, table of figures and more-
chap4_ho4_tables_solution
)
|
5
Due Feb 13 |
Excel |
5.1 |
Hands-ON Exercise 1 in Chapter 1/Excel (pg. 324) show step 4
- screen shot like following
(similar, not exact, basic woorkbook
chap1_ho1_jake__solution
)
|
5.2 |
Hands-ON Exercise 2 in Chapter 1/Excel (pg. 335) show step 6
- screen shot like following
(similar, not exact, formulas-
chap1_ho2_jake__solution
)
|
5.3 |
Hands-ON Exercise 3 in Chapter 1/Excel (pg. 347) show step 5
- screen shot like following
(similar, not exact, formatting, styling-
chap1_ho3_jake__solution
)
|
5.4 |
Hands-ON Exercise 4 in Chapter 1/Excel (pg. 357) show step 3
- screen shot like following
(similar, not exact, comments/headers/footers-
chap1_ho4_jake__solution
)
footer/header
footer/header
Cntrl+` to show formulas
|
6
Due Feb 20 |
Excel |
6.1 |
Hands-ON Exercise 1 in Chapter 2/Excel (pg. 384) show step 3
- screen shot like following
(similar, not exact, calculations-copy&fill formulas
chap2_ho1_payroll_solution
)
|
6.2 |
Hands-ON Exercise 2 in Chapter 2/Excel (pg. 394) show step 5
- screen shot like following
(similar, not exact, functions, formating and comments
chap2_ho2_payroll__solution
)
|
6.3 |
Hands-ON Exercise 3 in Chapter 2/Excel (pg. 403) show step 4
- screen shot like following
(similar, not exact, functions, IF and VLOOKUP functions -
chap2_ho3_gradebook_solution
)
|
6.4 |
Hands-ON Exercise 4 in Chapter 2/Excel (pg. 410) show step 4
- screen shot like following
(similar, not exact, PMT function and format worksheet -
chap2_ho4_van_solution
)
|
7
Due Feb 27 |
Excel |
7.1 |
Hands-ON Exercise 1 in Chapter 3/Excel (pg. 443) show step 7
- screen shot like following
(similar, not exact, AutoSum and creating charts -
chap3_ho1_sales_solution
)

|
7.2 |
Hands-ON Exercise 2 in Chapter 3/Excel (pg. 454) show step 6
- screen shot like following
(similar, not exact, more charts-
chap3_ho2_sales_solution
)
|
7.3 |
Hands-ON Exercise 3 in Chapter 3/Excel (pg. 462) show step 7
- screen shot like following
(similar, not exact, embedding chart in word document --
chap3_ho3_memo_solution
)
|
7.4 |
Hands-ON Exercise 1 in Chapter 4/Excel (pg. 497) show step 4
- screen shot like following
(similar, not exact, freeze rows/columns, hide/unhide, protect areas--
chap4_ho1_band_solution
)
|
7.5 |
Hands-ON Exercise 2 in Chapter 4/Excel (pg. 519) show step 7
- screen shot like following
(similar, not exact, find records, page layout view--
chap4_ho2_band_solution
)
|
PPT |
7.6 |
Hands-ON Exercise 1 in Chapter 1/PPT (pg. 813) show step 6
- screen shot like following
(similar, not exact, open exisitng, add speaker note, save -
chap1_ho1_intro_solution
)
|
7.7 |
Hands-ON Exercise 2 in Chapter 1/PPT (pg. 823) show step 6
- screen shot like following
(similar, not exact, new presentation,spelling, text layout-
chap1_ho2_content_solution
)
|
7.8 |
Hands-ON Exercise 3 in Chapter 1/PPT (pg. 834) step 4
- screen shot like following
(similar, not exact, art, transitions, animations-
chap1_ho3_content_solution
)
|
8
Due March 5 |
PPT + web |
---- |
Explore How to setup a Web page |
8.1 |
Hands-ON Exercise 1 in Chapter 2/PPT (pg. 874) show step 5
- screen shot like following
(similar, not exact, templates, layouts-
chap2_ho1_nature_solution
)
|
8.2 |
Hands-ON Exercise 2 in Chapter 2/PPT (pg. 883) show step 4
- screen shot like following
(similar, not exact, outline-
chap2_ho2_presentations_solution
)
|
8.3 |
Hands-ON Exercise 3 in Chapter 2/PPT (pg. 890) show step 2
- screen shot like following
(similar, not exact, import word outline & slides from other presentation-
chap2_ho3_guide_solution
)
|
8.4 |
Hands-ON Exercise 4 in Chapter 2/PPT (pg.899) show step 8
- screen shot like following
(similar, not exact, styling-
chap2_ho4_guide_solution
)
|
9/10
Due March 5&12 |
Web |
9.1 |
Web Project |