Creating a dynamic spreadsheet

Creating a dynamic spreadsheet

 

Creating a dynamic spreadsheet
Creating a dynamic spreadsheet

 

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:

 

  1. 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.
  2. For projected sales, display sales by category and total.
  3. Apply formatting conventions appropriate for a business audience.
  4. Select a consistent font and font size.
  5. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
  6. 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.
  7. Embed a bar chart that accurately displays the total sales for the current year.
  8. Embed a bar chart that accurately displays the projected sales for the next five years.
  9. Embed a line graph that accurately displays the projected 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 projected sales growth over the next five years            Embeds a line graph that displays the projected 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 projected sales growth over the next five years       10

Total    100%

 

 

 

 

 


WE ARE THE LEADING ACADEMIC ASSIGNMENTS WRITING COMPANY, BUY THIS ASSIGNMENT OR ANY OTHER ASSIGNMENT FROM US AND WE WILL GUARANTEE AN A+ GRADE

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.
Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: