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.

2. Benchmark – Sales Results Excel Spreadsheet and PowerPoint 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 utilize Microsoft Excel and PowerPoint to create a business presentation.

Part 1

As a sales manager at Lopes Athletics Productions, you are required to report your sales numbers weekly and share them with the vice president of sales. Create an Excel spreadsheet that provides the following information.

1. Total sales for each type of video.

2. Total sales of all videos.

3. Percentage of total sales for each type of video.

4. A bar chart that summarizes the sales data.

The data needed for the spreadsheet is as follows. In all, you will need to create at least four columns; Video Type, Unit Price, Total Sales (for each type of video), and Percentage of Total Sales (for each type of video.

1. Pilates sold 156 videos at $29.99 each.

2. Step sold 392 videos at $14.99 each.

3. Weight Training sold 147 videos at $54.99 each.

4. Kickboxing sold 282 videos at $29.99 each.

5. Yoga sold 165 videos at $34.99 each. 

Add a second worksheet to your workbook. 

1. Insert a chart in a bar format linked to data on your first worksheet.

2. This bar chart should reflect the total sales of each type of video.

3. Review the rubric to see how the spreadsheet will be assessed

Part 2

Create a PowerPoint presentation with a minimum of five slides based upon the Excel spreadsheet you created in Part 1 of this assignment.

Utilize the bar chart from the spreadsheet as a graphic element on at least one slide in the presentation. The presentation should summarize the following information for the vice president of sales:

1. Total sales for each type of video.

2. Total sales of all videos.

3. Percentage of total sales for each type of video.

In addition to the content, the presentation will be assessed on the following criteria:

1. Slide structure includes correct use of bullet points and the 6 x 6 rule.

2. Slide appearance includes consistent theme, text alignment, readable font, clear photos/charts.

3. Slide content is accurate, concise, and focused on a single topic.

4. Use of chart enhances the presentation and illustrates slide information.

5. Speaker notes are appropriate for explaining slide content and add details not presented on the slide.

Submit the PowerPoint presentation file. 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.

APA style is not required, but solid academic writing is expected.

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

Benchmark Information

This benchmark assignment assesses the following programmatic competencies:

BS Business Secondary Education

7.1:  Demonstrate computer literacy skills.

Rubric

Collapse All RubricCollapse All

collapse Excel – Spreadsheet Data assessment

Excel – Spreadsheet Data

9.5 points

Criteria Description

Excel – Spreadsheet Data (Total Sales by Video Type, Total Sales of All Videos, Percentage of Sales by Video)

5. Excellent

9.5 points

Spreadsheet data are complete and correct.

4. Good

8.08 points

Spreadsheet data are mostly complete and correct.

3. Satisfactory

7.13 points

Spreadsheet data are partially complete and correct.

2. Less Than Satisfactory

6.18 points

Spreadsheet data are incomplete or incorrect.

1. Unsatisfactory

0 points

Data are not evident in the spreadsheet.

collapse Excel – Spreadsheet Labels (Title, Columns, and Rows) assessment

Excel – Spreadsheet Labels (Title, Columns, and Rows)

9.5 points

Criteria Description

Excel – Spreadsheet Labels (Title, Columns, and Rows)

5. Excellent

9.5 points

Labels are complete and correct.

4. Good

8.08 points

Labels are complete and include minimal errors that do not affect spreadsheet readability.

3. Satisfactory

7.13 points

Labels are partially complete and correct but contain errors that affect spreadsheet readability.

2. Less Than Satisfactory

6.18 points

Labels are incomplete or incorrect.

1. Unsatisfactory

0 points

Labels are not evident in the spreadsheet.

collapse Excel – Spreadsheet Formulas assessment

Excel – Spreadsheet Formulas

19 points

Criteria Description

Excel – Spreadsheet Formulas

5. Excellent

19 points

Formulas are complete and correct.

4. Good

16.15 points

N/A

3. Satisfactory

14.25 points

Formulas are included but produce calculation errors or inaccurate data.

2. Less Than Satisfactory

12.35 points

Formulas are incomplete or incorrect.

1. Unsatisfactory

0 points

Formulas are not present in the spreadsheet.

collapse Excel – Chart (Summary of Sales Data and Inclusion of Title and Label on X and Y Axis) assessment

Excel – Chart (Summary of Sales Data and Inclusion of Title and Label on X and Y Axis)

19 points

Criteria Description

Excel – Chart (Summary of Sales Data and Inclusion of Title and Label on X and Y Axis)

5. Excellent

19 points

Chart is expertly crafted on the second worksheet.

4. Good

16.15 points

Chart is on the second worksheet and is complete and includes relevant data, titles, and labels. Chart contains only minor errors.

3. Satisfactory

14.25 points

Chart is included in the second worksheet but lacks relevant data from all required categories or contains errors in titling or labeling.

2. Less Than Satisfactory

12.35 points

Chart is on the second worksheet but is incomplete or incorrect.

1. Unsatisfactory

0 points

Chart is not present in the spreadsheet.

collapse Presentation of Content (C7.1) assessment

Presentation of Content (C7.1)

14.25 points

Criteria Description

Presentation of Content (C7.1)

5. Excellent

14.25 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.11 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

10.69 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.26 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

9.5 points

Criteria Description

Layout

5. Excellent

9.5 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

8.08 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

7.13 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

6.18 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

9.5 points

Criteria Description

Speaker Notes

5. Excellent

9.5 points

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

4. Good

8.08 points

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

3. Satisfactory

7.13 points

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

2. Less Than Satisfactory

6.18 points

Speaker notes are incomplete or incorrect.

1. Unsatisfactory

0 points

Speaker notes are not included.

collapse Mechanics of Writing (includes spelling, punctuation, grammar, language use) assessment

Mechanics of Writing (includes spelling, punctuation, grammar, language use)

4.75 points

Criteria Description

Mechanics of Writing (includes spelling, punctuation, grammar, language use)

5. Excellent

4.75 points

All format elements are correct.

4. Good

4.04 points

Appropriate template is fully used; There are virtually no errors in formatting style.

3. Satisfactory

3.56 points

Appropriate template is used, and formatting is correct, although some minor errors may be present.

2. Less Than Satisfactory

3.09 points

Appropriate template is used, but some elements are missing or mistaken; lack of control with formatting is apparent.

1. Unsatisfactory

0 points

Appropriate template is not used appropriately or documentation format is rarely fo