PC Purchase Analysis for Nanaimo City Business Development Department

You have been hired by the City of Nanaimo, to work in their Business Development department. Your first assignment is to analyze 3 possibilities for PC purchases by the department. The 3 companies that you were asked to tender bids were Dell, Lenovo, and HP. Your job is to check out their web-sites, and determine prices for available pieces of hardware and software of your choosing, and create a document for the department director that highlights what you anticipate these pieces of hardware would cost. Luckily, you remember an assignment you did from a first year course, where you had started to do something similar. You create a folder called PC on your U: drive. This sounds familiar. Where have you had a U: drive before? Quickly, you find that assignment, and using the internet, fill in as much information as possible, and save the file to your folder. (take one of the tables you built for portfolio #1, and modify it, or create a new table, with many rows and at least 3 columns, so you can add items from company web sites to it) You are then supposed to create a chart that specifies what the total cost will be by category (hardware, software &, peripherals, as well as grand total, for each company. A breeze you think, since all you need to do is transfer some numbers to a spreadsheet, and create a chart. The chart should be in the same worksheet as the data. Links to the 3 company’s web-sites should be there as well. This must be saved as both a spreadsheet, and a web-page, so that some department members at a conference in Seattle can view it on the internet. Save the files to your PC folder. Finally, you are to create a database that has records for each company, with fields for each category (hardware, software, and peripherals). Each of these fields is a currency field.. Use the company name as the primary key which should be a text field, Then, you just click on the create tab and create a report by using a wizard by double clicking on the report wizard button, add all of the fields to the report by using the >> button, and click on the finish button. Once the report appears, you right click on it with your mouse, choose to export it, and save it as a file named report, which is a text file, with default encoding, to your PC folder. Now your PC folder contains a document that is a table of hardware prices, a spreadsheet with summary data in it, a web page file with an .htm or .html extension, and a text file that is an access report. There may be a extra folder too, but you don’t need to worry about it. Email the document, spreadsheet, web page file and report file to your director, and your job is done.