PRO DISTOP 3

IT 100 Milestone Two Guidelines and Rubric Overview: As you prepare to communicate the next steps in the consulting partnership between your organization, Business Consultants, and your client, New Hampshire Business Products, you will prepare three deliverables using office productivity applications. For Milestone Two, you will prepare a draft of your second deliverable: a Microsoft Excel spreadsheet. You will create a dynamic spreadsheet that will allow you to organize and manipulate the given sales data with basic automatic calculation functions. Prompt: Using Excel, create a spreadsheet that clearly and functionally displays the numerical data provided in the final project scenario. Specifically, the following critical elements must be addressed:

II. Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.

A. For current sales, display sales by category and total. B. For projected sales, display sales by category and total. C. Apply formatting conventions appropriate for a business audience.

1. Select a consistent font and font size. 2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting. 3. Apply labels that identify the values contained in each row and column.

D. Apply formulas to calculate totals for current sales as well as projected sales. E. Embed a bar chart that accurately displays the total sales for the current year. F. Embed a bar chart that accurately displays the projected sales for the next five years. G. Embed a line graph that accurately displays the desired sales growth over the next five years.

Rubric

Guidelines for Submission: Your Excel spreadsheet must be submitted with the following naming convention: spreadsheet_firstinitiallastname.xlsx.

Critical Elements Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value

Spreadsheet: Current Sales Displays current sales by category and total

Displays current sales but does not display by category and/or total, or information is otherwise incomplete

Does not display current sales by category and total

15

Spreadsheet: Projected Sales

Displays projected sales by category and total

Displays projected sales but does not display by category and/or total, or information is otherwise incomplete

Does not display projected sales by category and total

15

Spreadsheet: Font and Size Selects a consistent and standard font and font size

Selects a consistent font and font size, but font and/or font size distract from the message or are not appropriate for a business audience

Does not select a consistent font and font size

10

Spreadsheet: Format Formats the spreadsheet with row and column spacing, row and column alignments, and cell formatting

Formats the spreadsheet but does not address all components, or formatting changes distract from the message or are not appropriate for a business audience

Does not format the spreadsheet 10

Spreadsheet: Labels Applies labels that identify the values contained in each row and column

Applies labels, but they do not accurately identify the values, or label formatting distracts from the message

Does not apply labels 10

Spreadsheet: Formulas Applies formulas to calculate all totals Applies formulas to calculate totals, but not all calculations are addressed with formulas, or formulas contain inaccuracies

Does not apply formulas 10

Spreadsheet: Current Year Embeds a bar chart that accurately displays the total sales for the current year

Embeds a bar chart that displays the total sales for the current year, but chart contains inaccuracies, or formatting and style choices distract from the message

Does not embed a bar chart that displays the total sales for the current year

10

Spreadsheet: Next Five Years

Embeds a bar chart that accurately displays the projected sales for the next five years

Embeds a bar chart that displays the projected sales for the next five years, but chart contains inaccuracies, or formatting and style choices distract from the message

Does not embed a bar chart that displays the projected sales for the next five years

10

Spreadsheet: Sales Growth Embeds a line graph that accurately displays the desired sales growth over the next five years

Embeds a line graph that displays the desired sales growth over the next five years, but graph contains inaccuracies, or formatting and style choices distract from the message

Does not embed a line graph that accurately displays the desired sales growth over the next five years

10

Total 100%