1. Laptop Computer System Research and Selection Presentation

Take a moment to review the details of this assignment below and gather any necessary files. Once you're ready to submit your assignment, move on to Step 2.

Assessment Description

The purpose of this assignment is to use Microsoft Excel to create a laptop computer system cost comparison spreadsheet and utilize Microsoft PowerPoint to report the costs and pros and cons of various computer systems.

Your manager has approved the purchase of new laptop computers for your department.

Part 1 - Laptop Computer Cost Comparison

Create an Excel spreadsheet and, in a text box, identify and describe three software programs specific to your career field of study. This should not include Microsoft Office. The software should be used for productivity, data management, unique needs of the field, increasing market share, and increasing competitive advantage.

From this perspective, research various computer systems. In your Excel spreadsheet, identify and summarize the cost base for three laptop computer systems. Include information on the specifications listed below:

1. Computer brand and model

2. Price

3. CPU: type, clock speed, number of cores

4. RAM: amount and type

5. Screen size and resolution

6. Primary disk: capacity, hard drive or SSD

7. Optical disc drive (optional)

At the bottom of the spreadsheet, merge a block of several cells to create a large cell. In this area, provide a link to the website where this product can be found.

1. Add a new worksheet page and create two pie charts.

2. Pie Chart 1 should compare the cost of the three laptop systems.

3. Pie Chart 2 should compare the cost of the three software programs.

Only the Microsoft Excel spreadsheet file will be accepted. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

Part II - Laptop Computer System Selection Presentation

Now that you researched three different laptop computer systems, select a laptop computer system that you chose to recommend to the management for the purchase. Create a PowerPoint presentation with a minimum of six slides that you can use to summarize and justify the laptop computer you have selected. Management has asked that you address the following in the presentation.

1. Computer brand and model

2. Price

3. CPU: type, clock speed, number of cores

4. RAM: amount and type

5. Screen size and resolution

6. Primary disk: capacity, hard drive or SSD

7. Optical disc drive (may be optional)

8. Detailed discussion of software specific to your career field of study that will be used for productivity, data management, unique needs of the field, increasing market share, and increasing competitive advantage (QuickBooks, SalesForce, Google Analytics, Epic, etc.), including the associated cost.

Only the Microsoft PowerPoint presentation file will be accepted. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

General Requirements

Submit both the Excel spreadsheet file and the Microsoft PowerPoint presentation file. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.

Rubric

Collapse All RubricCollapse All

collapse Excel – Three Laptop Computer Selection assessment

Excel – Three Laptop Computer Selection

15 points

Criteria Description

Excel – Three Laptop Computer Selection (Brand, Model, Price, CPU, RAM, Screen Size and Resolution, Primary Disk, Optical Disk (optional), Software, Cost Criteria)

5. Excellent

15 points

Details related to the laptop selected are complete and correct.

4. Good

12.75 points

Details related to the laptop selected are mostly complete and correct.

3. Satisfactory

11.25 points

Details related to the laptop selected are partially complete and correct.

2. Less Than Satisfactory

9.75 points

Details related to the laptop selected are incomplete or incorrect.

1. Unsatisfactory

0 points

Details related to the laptop selected are not included.

collapse Excel – Three Software Selections and Location (Should not include Microsoft Office) assessment

Excel – Three Software Selections and Location (Should not include Microsoft Office)

15 points

Criteria Description

Excel – Three Software Selections and Location (Should not include Microsoft Office)

5. Excellent

15 points

Three business-specific software selections for office productivity and tracking customer interactions, sales, and new leads are complete and meet the office productivity criteria.

4. Good

12.75 points

Three business-specific software selections for office productivity and tracking customer interactions, sales, and new leads are complete and meet most of the office productivity criteria.

3. Satisfactory

11.25 points

Three business-specific software selections for office productivity and tracking customer interactions, sales, and new leads are partially complete and meet some of the office productivity criteria.

2. Less Than Satisfactory

9.75 points

Three business-specific software selections for office productivity and tracking customer interactions, sales, and new leads are incomplete or incorrect.

1. Unsatisfactory

0 points

Business-specific software selections are not included.

collapse Excel – Two Pie Charts assessment

Excel – Two Pie Charts

15 points

Criteria Description

Excel – Two Pie Charts – One Comparing Three Laptop Systems and Another One Comparing Three Software Programs

5. Excellent

15 points

Charts are expertly crafted on the second worksheet.

4. Good

12.75 points

Charts are on the second worksheet and are complete and include relevant data, titles, and labels. Chart contains only minor errors.

3. Satisfactory

11.25 points

Charts are included in the second worksheet but lack relevant data from all required categories or contain errors in titling or labeling.

2. Less Than Satisfactory

9.75 points

Charts are on the second worksheet but are incomplete or incorrect.

1. Unsatisfactory

0 points

Chart are not present in the spreadsheet.

collapse Presentation of Content assessment

Presentation of Content

15 points

Criteria Description

Presentation of Content

5. Excellent

15 points

The content is written clearly and concisely. Ideas universally progress and relate to each other. The project includes motivating questions and advanced organizers. The project gives the audience a clear sense of the main idea. Persuasive, authoritative information from reliable, credible sources is included.

4. Good

12.75 points

The content is written with a logical progression of ideas and supporting information exhibiting a unity, coherence, and cohesiveness. Persuasive information is included from reliable sources.

3. Satisfactory

11.25 points

The presentation slides are generally competent, but ideas may show some inconsistency in organization or in their relationships to each other. Some persuasive information is included.

2. Less Than Satisfactory

9.75 points

The content is vague in conveying a point of view and does not create a strong sense of purpose. Some persuasive information from reliable sources is included. Some persuasive information is included but may be unreliable or lack credibility.

1. Unsatisfactory

0 points

The content lacks a clear point of view and logical sequence of information is unclear. Little or no persuasive information from reliable sources is included.

collapse Layout assessment

Layout

15 points

Criteria Description

Layout

5. Excellent

15 points

The layout is visually pleasing and contributes to the overall message with appropriate use of headings, subheadings, and white space. Text is appropriate in length for the target audience and to the point. The background and colors enhance the readability of the text.

4. Good

12.75 points

The layout background and text complement each other and enable the content to be easily read. The fonts are easy to read and point size varies appropriately for headings and text.

3. Satisfactory

11.25 points

The layout uses horizontal and vertical white space appropriately. Sometimes the fonts are easy to read, but in a few places the use of fonts, italics, bold, long paragraphs, color, or busy background detracts and does not enhance readability.

2. Less Than Satisfactory

9.75 points

The layout shows some structure but appears cluttered and busy or distracting with large gaps of white space or a distracting background. Overall readability is difficult due to lengthy paragraphs, too many different fonts, dark or busy background, overuse of bold, or lack of appropriate indentations of text.

1. Unsatisfactory

0 points

The layout is cluttered, confusing, and does not use spacing, headings, and subheadings to enhance the readability. The text is extremely difficult to read with long blocks of text, small point size for fonts, and inappropriate contrasting colors. Poor use of headings, subheadings, indentations, or bold formatting is evident.

collapse Speaker Notes assessment

Speaker Notes

15 points

Criteria Description

Speaker Notes

5. Excellent

15 points

Speaker notes are thorough and include substantial explanation and justification of computer system selections and relevant supporting details.

4. Good

12.75 points

Speaker notes are complete, justify computer system selections, and include explanation and relevant supporting details.

3. Satisfactory

11.25 points

Speaker notes are included but do not justify computer system selections or lack explanation and relevant supporting details.

2. Less Than Satisfactory

9.75 points

Speaker notes are incomplete or incorrect.

1. Unsatisfactory

0 points

Speaker notes are not included.

collapse Documentation of Sources assessment

Documentation of Sources

10 points

Criteria Description

Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style)

5. Excellent

10 points

Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error.

4. Good

8.5 points

Sources are documented, as appropriate to assignment and style, and format is mostly correct.

3. Satisfactory

7.5 points

Sources are documented, as appropriate to assignment and style, although some formatting errors may be present.

2. Less Than Satisfactory

6.5 points

Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors.

1. Unsatisfactory

0 points

Sources are not documented.