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