Home > Assignments > Answer Key

CGS1570W Computer Concepts and Applications

Assignment Answer Key

Acrobat Reader is required to view, navigate and print .PDF files.  Downloadable for Windows, Macintosh, and Unix at http://www.adobe.com/products/acrobat/readstep2.htm.

  1. Assignment 1

    1. Connecting to the Internet
    2. Understanding the Motherboard
    3. Maintaining Your Hard Drive

  2. Assignment 2

    1. Apply 1-1 Paris Announcement Formatted
    2. Lab 1-1 Reid Construction Announcement
    3. Lab 1-3 Pre-Game Party Announcement

  3. Assignment 3

  4. Assignment 4

    1. Okamoto Resume
    2. Okamoto Cover Letter

  5. Assignment 5

    1. Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter (Formula View)
    2. Revised Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter
    3. Lab 2-2 Custom Home Theater Monthly Accounts Receivable (Formula View) with Bar Chart as sheet 2.
    4. Revised Lab2-2 Custom Home Theater Monthly Accounts Receivable (Bar Chart)

  6. Assignment 6

    1. Lab 3-1 Laser Fast Technology Seven-Year Financial Projection (Formula View) with 3-D Column Chart as sheet 2.
    2. Lab 3-1 Laser Fast Technology Seven-Year Financial Projection Goal Seek

  7. Assignment 7

  1. Client Table (Figure 1-43)

  2. Trainer Table (Figure 1-47)

  3. Client-Trainer Query (Figure 1-53)

  4. Client Form (Figure 1-64)

  5. Client Amount Report (Figure 1-67)

  6. Client-City Query (Figure 2-26)

  7. City-Trainer Crosstab Query (Figure 2-71)

  8. Client-Trainer Relationship (Figure 3-71)

  9. Client Table multiple field sort (Figure 3-79)

  1. Assignment 8

    1. Customer Table
    2. Customer Amount Report
    3. Customer-Technician Query with Technician number 210
    4. Query Results  (Customers living on Fletcher)
    5. Query Results  (Customer Number, Name, City, Balance)
    6. Query Results  (Customer-City Query for Kady)
    7. Query Results  (Customer-City Query for Carlton (top 2 records))
    8. Query Results  (Technician-Customer joined and sorted)
    9. Query Results  (Technician-Customer joined and sorted, balance > $350)
    10. Query Results  (City-Technician Crosstab)
    11. Modified Customer Table
    12. Customer Table with record removed
    13. Customer Table in descending order by balance
    14. Customer/Technician table relationship printout

  2. Assignment 9

    1. Lab 1-2 Credit Card.ppt (Outline View)
    2. Lab 2-3 Colds.ppt (Outline View)

  3. Assignment 10

 

Top of the Page