Assignment 10: Final Project

Instructions:

For this lab you will need MS Word, MS Excel, MS PowerPoint and MS Access as well as Internet access to do research on computer pricing, capabilities and features.

Lab summary and objectives: In this exercise you will:

· Use the Internet to research prices on laptop computers.

· Use MS Excel to create a table and accompanying charts comparing laptop computer prices etc.

· Use MS Word to write a two-page memo-style proposal justifying your choice of purchase of computer.

· Use MS PowerPoint to create a short presentation on your research and proposal.

· Use MS Access to create a small database table (and Form for extra credit) containing the information you have researched on Computer types, required hardware and required software

Part A: Justification of laptop computer purchase for work purposes

Imagine that your work supervisor has informed you that the organization you work for will purchase a laptop or desktop computer of your choosing. You have a budget of $2,000 for a general business/multimedia-capable computer with accessories. You will research and compare three (3) or more computers; one of the desktops should be an Apple and the others should be Windows machines. You should evaluate the three computers based on YOUR needs – are you doing graphic design? Are you just doing word processing and emails? Are you programming? Each of these will have different hardware and software requirements.

Part B: Mandatory elements

(Grading is based on overall professional look and inclusion of the following elements)

1. Excel workbook with the following elements:

a. Two tables with accompanying charts

b. Four formulas (suggestions: sum, average, max, min)

c. Formatting of text headings for clear reference of content

2. Word document with the following elements:

a. Memo template from MS Office

b. Comparison of pricing and features of three (3) laptop computers

c. Justification of selected computer with reference to Excel workbook

d. One bulleted list and one numbered list

3. PowerPoint presentation of content from memo, with the following elements:

a. At least seven (7) slides, including title slide

b. Graphics on at least three (3) slides (clipart, images from Internet of selected computers etc.)

c. PowerPoint chart on one slide.

4. Access database with the following elements:

a. One table with the following fields

i. Computer Name

j. Storage capacity

k. CPU Speed

l. Screen size

m. RAM capacity

5.

Extra credit: Create a Form in MS Access to enter the fields from number 4.