+1 (951) 902-6107 info@platinumressays.com

Your custom Assignment is Just a Click Away

We Write Custom Academic Papers

From as Little as $10

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

MRCH 2760 FIDM Gradebook and Sales Inventory Planning Worksheet

MRCH 2760 FIDM Gradebook and Sales Inventory Planning Worksheet

Question Description

Objective:

Create a gradebook using Microsoft Excel® so that when data is entered the worksheet performs the necessary calculations, displays the calculated final grade and includes a dashboard. Workbook must have a different layout than your MRCH.1950 gradebook file.

purpose:

This challenge will provide you with the opportunity to keep track of your grades using Excel®. Our class grades are weighted and this spreadsheet will require applying the the Excel® skills acquired in MRCH.150 and enhanced by skills developed this quarter.

This spreadsheet is not your official gradebook, so grades missing from Canvas garadebook at the time of assignment submission are not required, but the spreadsheet still needs to have proper formulas present so when the data is entered, the spreadsheet calculates.

What matters is that your spreadsheet meets the following criteria.

Criteria:

Begin with a new workbook and name the sheet (tab) MRCH2760. Use the gradebook located in the class eLearning site for all required spreadsheet data.

Step 1: Plan the spreadsheet

  • Look ahead while planning where in the spreadsheet to input data
  • Review the assignment completely and the resources required
  • Sketch out how you see the data organized
  • Keep in mind how data is best grouped to create charts and graphs (linking and consolidation of data should be used here)

Step 2: Input data

Input data from Canvas Gradebook.

  • Assignments will take you to the list of gradebook categories, their weight percent, and all course gradebook items
  • Include:
    • Category titles
    • Category percent weights
    • Title of each item organized by category
    • Points earned for each item with a labeled total for each category
    • Points possible for each item with a labeled total for each category

Step 3: Formatting

Format your gradebook to best display the data (easy to read and pleasing to the eye). Keep in mind the requirements of the entire assignment when formatting.

  • The following formatting tools must be used appropriately within the spreadsheet design
    • Boarders
    • Fill cells
    • Bold (ctrl + B) or Italic (ctrl + I) or Underline (ctrl + u) (ctrl on PC = COMMAND on Mac)
    • Cells are formatted to percent where percents need to be displayed with two decimal places
      • NOTE: For cell reference to work in formula or function, a cell must hold numbers only. No words or signs such as $, %, &< etc. in the cell

Step 4: Formulas & Functions

Create formulas and use functions to calculate your grade for WEIGHTED CATEGORIES (math directions below)

  • Conditional Formatting
  • Cell reference must be used in formulas and functions
  • Absolute cell reference must be used appropriately where/if needed
  • AutoSum must be used appropriately where/if needed
  • Add functions: AVERAGE, MINIMUM, MAXIMUM of points earned for each category

Math Instructions for Weighted Grades:

For this course your course grade is weighted by category.

Here is how the math goes for your Weighted Gradebook.

  1. Sum the total points earned for each category
  2. Sum total points possible for each category
  3. Calculate the CATEGORY POINTS PERCENT; Divide the total category points earned by the total category points possible
  4. Calculate the WEIGHTED CATEGORY PERCENT CONTRIBUTION; Multiply the product of step 3 by the category weight percent
  5. Repeat steps 3-7 for each gradebook category
  6. Calculate the TOTAL COURSE GRADE; Sum up the weighted category percent for each category

Step 5: Dashboard of KPIs

Think of a car. The dashboard displays the status of the key information needed by the driver to operate the car.

This is the same for our Gradebook!

Your dashboard should display charts that communicate the key information concerning your grade/performance in the course. Also, it needs to be linked to the data on your gradebook page. Module 5 of the Introductory course textbook explains consolidating data in Excel.

In business, Dashboards provide the visual communication of Key Performance Indicators (KPIs).

Instead of sales numbers, or inventory counts and value, or clicks on the new marketing campaign from all marketing channels, grades are the data used to monitor performance for our course.

What do you want to monitor as a KPI in order to reach the goal of getting the most from the course?

The goal of your Dashboard is to tell the story of your data – we usually call this analyzing data.

Each chart used within your dashboard is a visual display of the data analysis.

DASHBOARD reports have THREE layers:

  1. Data (like a table, Textbook Module 7 & 8)
  2. Analysis of the data (formulas and functions applied to data transforming the data into information)
  3. Presentation or visual display and organization of the report (your charts)

Remember in MRCH.1950 where we created the two small data sets to analyzed the greadebook data?

They were the Min, Max, Ave data set and the Final Grade data set displaying and calculating your final grade.

These two parts of the MRCH.1950 gradebook are the data analysis layer of the gradebook. The data portion are the gradebook item names, points earned, and points possible.

DASHBOARD VIDEO:

Evaluation (see rubric):

  • When working on course assignments your number one priority is following directions, this is what you will be graded on. Following directions will achieve the SLOs.

✏️ Student Learning Outcomes

    1. Demonstrate competency in using spreadsheet technology (Excel) entering appropriate retail math formulas.
    2. Exhibit strong information literacy skills by looking up values in a table.
    3. Show expertise in planning and executing a macro to maintain table data.
    4. Demonstrate technical proficiency by enhancing charts to improve the user’s understating of the information displayed.
    5. Combine strong critical thinking skills with information literacy by using the data in PivotTables to make decisions.

How to Place an Order

  1. Clіck оn the Place оrder tab at the tоp menu оr “Order Nоw іcоn at the bоttоm, and a new page wіll appear wіth an оrder fоrm tо be fіlled.
  2. Fіll іn yоur paper’s іnfоrmatіоn and clіck “PRІCE CALCULATІОN” at the bоttоm tо calculate yоur оrder prіce.
  3. Fіll іn yоur paper’s academіc level, deadlіne and the requіred number оf pages frоm the drоp-dоwn menus.
  4. Clіck “FІNAL STEP” tо enter yоur regіstratіоn detaіls and get an accоunt wіth us fоr recоrd keepіng.
  5. Clіck оn “PRОCEED TО CHECKОUT” at the bоttоm оf the page.
  6. Frоm there, the payment sectіоns wіll shоw, fоllоw the guіded payment prоcess, and yоur оrder wіll be avaіlable fоr оur wrіtіng team tо wоrk оn іt.

Nоte, оnce lоgged іntо yоur accоunt; yоu can clіck оn the “Pendіng” buttоn at the left sіdebar tо navіgate, make changes, make payments, add іnstructіоns оr uplоad fіles fоr the оrder created. e.g., оnce lоgged іn, clіck оn “Pendіng” and a “pay” оptіоn wіll appear оn the far rіght оf the оrder yоu created, clіck оn pay then clіck оn the “Checkоut” оptіоn at the next page that appears, and yоu wіll be able tо cоmplete the payment.

Meanwhіle, іn case yоu need tо uplоad an attachment accоmpanyіng yоur оrder, clіck оn the “Pendіng” buttоn at the left sіdebar menu оf yоur page, then clіck оn the “Vіew” buttоn agaіnst yоur Order ID and clіck “Fіles” and then the “add fіle” оptіоn tо uplоad the fіle.

Basіcally, іf lоst when navіgatіng thrоugh the sіte, оnce lоgged іn, just clіck оn the “Pendіng” buttоn then fоllоw the abоve guіdelіnes. оtherwіse, cоntact suppоrt thrоugh оur chat at the bоttоm rіght cоrner

NB

Payment Prоcess

By clіckіng ‘PRОCEED TО CHECKОUT’ yоu wіll be lоgged іn tо yоur accоunt autоmatіcally where yоu can vіew yоur оrder detaіls. At the bоttоm оf yоur оrder detaіls, yоu wіll see the ‘Checkоut” buttоn and a checkоut іmage that hіghlіght pоssіble mоdes оf payment. Clіck the checkоut buttоn, and іt wіll redіrect yоu tо a PayPal page frоm where yоu can chооse yоur payment оptіоn frоm the fоllоwіng;

  1. Pay wіth my PayPal accоunt‘– select thіs оptіоn іf yоu have a PayPal accоunt.
  2. Pay wіth a debіt оr credіt card’ or ‘Guest Checkout’ – select thіs оptіоn tо pay usіng yоur debіt оr credіt card іf yоu dоn’t have a PayPal accоunt.
  3. Dо nоt fоrget tо make payment sо that the оrder can be vіsіble tо оur experts/tutоrs/wrіters.

Regards,

Custоmer Suppоrt

Order Solution Now