ITC4 - Introduction to Computers & Creating &Formatting an Inventory List - Case Study - IT Assignment Help

Assignment Task -

Case Study One: Creating and Formatting an Inventory List     

The company that you work for has requested that you track all of the technological inventory for the company. Create a workbook that will do that.   

1. Create an inventory workbook that contains the following: 

a. Give a clear title of the worksheet with a subtitle on a second line if it is useful.  b. Type in column and row labels that will clearly identify the information.  c. Include at least 15 different items.  

d. Include at least 5 different columns of information for each item.  

2. Add in any formulas that may be useful to display your information clearly, if possible.  

2. Format the worksheet as follows: 

a. Center the title (and subtitle if there is one) of the sheet across the top of the data. 

b. Change the formatting of the labels and titles to be easy to read

Case Study Two: Reproduce a Worksheet

Reproduce and format the following worksheet. Use formulas in the column to Gand Use anI Function incolumnH.

You can use any photo you would like on the worksheet, but the one in the example is found in the ICAO Student Files folder.  

Case Study Three: Research Computers and Prepare a Summary  Report 

You are working in the IT department of a local community college. 

Computers in the computer lab are too old and need to be replaced.

 The division chair hasasked you to look into this request. Use the Internet to locate five possible replacements.

For each one, find information on product specifications, prices, and features that might be considered advantages or disadvantages.

To summarize and present the information to your division chair, set up a workbook in Excel.   

The workbook should include the following:  

1. At least five possible replacements from at least three vendors.  

2. At least ten specifications for each computer.  

3. The worksheet must be formatted to be clear and easy to understand. 

4. The item that you would recommend needs to be clearly identified.  

Save the workbook as Computer replacements – your name 

This ITC4 - IT Assignment has been solved by our IT  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.