Basic Statistics Assignment

Microsoft Excel
Requirements: To use basic statistical functions in a Excel file


Basic Assignment Option:

Step 1: Open an existing Excel gradebook file that you have created for a class.
Step 2: Using Excel statistical functions, calculate the mean and standard deviation for a grade category, such as an exam, or quiz.
Step 3: Submit the gradebook to the instructor via email attachment by the due date.

* Scoring Rubric *

Full Credit
  • Excel file used
  • Mean calculated
  • SD calculated
  • Submitted by due date
    		•
    Partial Credit
  • Excel file used
  • Mean calculated
  • SD not calculated
  • Submitted by due date
    		•
    No Credit
  • Excel file used
  • Mean not calculated
  • SD not calculated
  • Submitted late
    		•


    Intermediate Assignment Option:

    Step 1: Create a new Excel gradebook file for a class that you instruct.
    Step 2: Using Excel statistical functions, calculate the mean, median, and the standard deviation for a grade category, such as an exam, or quiz.
    Step 3: Submit the gradebook to the instructor via email attachment by the due date.

    * Scoring Rubric *

    Full Credit
  • Excel file created
  • Mean calculated
  • SD calculated
  • Median calculated
  • Submitted by due date
    		•
    Partial Credit
  • Excel file created
  • Mean calculated
  • SD calculated
  • Median calculated
  • Submitted late
    		•
    No Credit
  • Excel file created
  • Mean not calculated
  • SD not calculated
  • Median not calculated
  • Submitted late
    		•


    Advanced Assignment Option:

    Step 1: Create a new Excel gradebook file for a class that you instruct.
    Step 2: Using Excel statistical functions, calculate the mean, median, mode,and standard deviation for all grade categories, such as exams and quizes.
    Step 3: Insert 1 image on to the spreadsheet that relates to the course topic.
    Step 4: Use at least 2 font colors and font sizes on the gradebook.
    Step 5: Submit the gradebook to the instructor via email attachment by the due date.

    * Scoring Rubric *

    Full Credit
  • Gradebook created
  • 4 statistics calculated
  • Image inserted
  • Two font colors used
  • Two font sizes used
  • Submitted by due date
    		•
    Partial Credit
  • Gradebook created
  • 2-3 statistics calculated
  • Image inserted
  • 1 font color used
  • 1 font size used
  • Submitted by due date
    		•
    No Credit
  • Gradebook created
  • 0-1 statistic calculated
  • Image not inserted
  • 1 font color used
  • 1 font size used
  • Submitted late
    		•