MRCH 2760 FIDM Gradebook and Sales Inventory Planning Worksheet OBJECTIVE: Create a gradebook using Microsoft Excel® so that when data is entered the wor

MRCH 2760 FIDM Gradebook and Sales Inventory Planning Worksheet 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 $, %, &