CS1020:   Introduction to Computers

 

under construction - Projects May CHANGE

These projects are DUE as indicated below, you are to demonstrate to your instructor the items required. Please note, if you know you need to be abscent on a day, you need to make arrangements ahead of time to handle this situation with the instructors approval. Otherwise, it will be treated under our class late policy and you will need to have documentation of your illness or similar situation (on a case by case basis with professor).

NOTE: the due date is the last day you will have to show these Projects.

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

    screen shot 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 Blackboard->Projects->Project1.*, 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

    screen shot 1-11(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 Blackboard->Projects->Project1.*, 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

    screen shot 1-11(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 Blackboard->Projects->Project1.*, 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

    screen shot 1-11(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 Blackboard->Projects->Project1.*, 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

    screen shot 1-11(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

    screen shot 1-11(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)
    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(similar, not exact, more table
    chap3_ho2_vacation_solution )

 

  • step 7: screen shot like following

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(similar, not exact, comments/headers/footers-
    chap1_ho4_jake__solution )
  • footer/headerfooter/header

footer/header

  • show formulas 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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(similar, not exact, AutoSum and creating charts -
    chap3_ho1_sales_solution )

second chart


7.2

Hands-ON Exercise 2 in Chapter 3/Excel (pg. 454) show step 6

  • screen shot like following

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(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

    screen shot 1-11(similar, not exact, styling-
    chap2_ho4_guide_solution )
9/10
Due March 5&12
Web 9.1 Web Project

 

 

© Lynne Grewe