ms excel related assignment

justify_purchase_of_a_new_smartphone.docx

Home >Human Resource Management homework help >ms excel related assignment

Justify purchase of a new smartphone. Research available models, components, operating systems and formats and explain your choice. Use a spreadsheet editor to compare prices and create charts, text editor to write your request, and presentation software to present the final request.

Find information on the Phone components for optimal performance (Fastest CPU, Max memory, Largest screen size, etc..).

Gathering information about two Phones:

Phone A: LG V10 AT&T in Opal Blue

Go to http://www.lg.com/us/cell-phones/lg-H900-Opal-Blue-v10

*Open a second tab in your browser

Phone B: IPhone 6S Plus

Go to http://www.apple.com/iphone-6s/specs/

Table processing

1. Create a spreadsheet with the following:

1. Enter Component names below as column headers in row 1

1. Model Name (Column A)

2. Price in $ (Column B)

3. Screen Size in Inches (Column C)

4. CPU Type (Column D)

5. Main Memory Size in GB (Column E)

6. Operating System (Column F)

7. Discount Price (Column G) *** used in calculation below

8. Web Link to Model Price (Column H)

2. Enter Component Details from each Phone:

1. Phone A Details in row 2 A-H based on Headers (All Except Discount Price in G)

1. Enter only numeric values in column B-C to avoid issues with later calculations

2. Use internet to find price for phone A, insert price in Row 2:Column B and copy web address to Row 2 Column H

2. Phone B Details in row 3 A-H based on Headers (All Except Discount Price in G)

1. Enter only numeric values in column B-C to avoid issues with later calculations

2. Use internet to find price for phone B, insert price in Row 3:Column B and copy web address to Row 3 Column H

2. Format data in the spreadsheet properly, using number formats and styles.

1. Format the price using Currency with three decimal places

2. Change page layout to landscape

3. Use Cell Style “Linked Cell” on Row 1

4. Use Wrap Text in Row 1

5. Size columns for readability

3. Use at least two different formulas in the spreadsheet.

1. Using a formula to Calculate the discount price

1. Apply discount percentage 20% or .20 on each type

1. Formula -> Discount Price = “Price in $” * (1.00 - discount percentage)

2. Use formula in Column G2 for Phone A

3. Use formula in Column G3 for Phone B

2. Use a formula to list the maximum price in B5

1. Formula: Max (Price Phone A, Price Phone B)

2. Add Text Label “Maximum price” in B6

4. Create at least two charts comparing optimal and minimal builds.

1. Create a 2D bar chart comparing the two Phones using:

1. Model and Main Memory

2. Create a pie chart comparing the two Phones using:

1. Model and Screen Size

Text processing

1. Create a text document with a short description of chosen components and justification of your choice.

1. Type “Phone A”

1. Copy a paragraph you want from the Phone A description beneath

2. Type “Phone B”

1. Copy a paragraph you want from the Phone B description beneath

3. Type “My Choice”

1. State which Phone you chose and state what was the key factor for your decision

2. Use at least three styles to format the text.

1. Apply ‘Heading 3’ Style to “Phone A” and “Phone B”

2. Apply ‘Heading 1’ Style to “My Choice”

3. Apply ‘Emphasis Style’ to the Winning Phone Overview

3. Insert at least two images and add references to the original data.

1. Insert the image of each Phone under the Overview paragraphs from the websites

2. Add a reference to each website for each Phone and Price

1. Add reference section to last page

4. Add a table of components of winning Phone to the text document below your reason for the choice

1. Insert the table with 3 Rows and 3 Columns

2. Copy the data from the spreadsheet (Model Number, CPU Type, Operating System) into the table *** Note: do NOT simply copy the spreadsheet

Presentation

1. Create a coherent presentation describing your selection of components.

1. Create a Title Slide with

1. Title Slide:

1. Title: My Phone Comparison 2015

2. Subtitle: Your Name

2. Use data or charts from the previously created spreadsheet to support your request.