Sort Spreadsheet Data Assignment

Microsoft Excel
Requirements: To sort data in an existing spreadsheet file


Basic Assignment Option:

Step 1: Use this Excel spreadsheet file for this assignment - Class Gradebook.
Step 2: Using Microsoft Internet Explorer, open the file, and save a copy to your computer, or other storage device (floppy, zip, etc.).
Step 3: Using Excel's sorting function, sort the Percent column in descending order.
Step 4: Name and save the "sorted" spreadsheet file as a new file, such as "descending".
Step 5: Submit the sorted spreadsheet file to the instructor via email attachment.

* Scoring Rubric *

Full Credit
  • "Sorted" file created
  • Sorted in descending order
  • Submitted by due date
    		•
    Partial Credit
  • "Sorted" file created
  • Not in descending order
  • Submitted by due date
    		•
    No Credit
  • File created
  • File not sorted
  • Submitted late
    		•


    Intermediate Assignment Option:

    Step 1: Use this existing Excel spreadsheet file for this assignment - Class Gradebook.
    Step 2: Using Microsoft Internet Explorer, open the file, and save a copy to your computer, or other storage device (floppy, zip, etc.).
    Step 3: Using Excel's sorting function, sort the Student Name column in ascending order.
    Step 4: Save the sorted spreadsheet file as a new file.
    Step 5: Using Excel's sorting function, sort the Percent in descending order.
    Step 6: Save the sorted spreadsheet file as a new file.
    Step 7: Submit the two sorted spreadsheet files to the instructor via email attachment.

    * Scoring Rubric *

    Full Credit
  • Two "Sorted" files created
  • Sorted in different orders
  • Submitted by due date
    		•
    Partial Credit
  • Two "Sorted" files created
  • Sorted in same order
  • Submitted late
    		•
    No Credit
  • Two files created
  • Files not sorted
  • Files submitted late
    		•


    Advanced Assignment Option:

    Step 1: Using Microsoft Excel, create an original spreadsheet file for an educational task or topic.
    Step 2: Include at least 20 rows of data with 5 variables (columns) per row in the new file.
    Step 3: Save the file as the "original" file for this assignment.
    Step 4: Using the "sort" function, sort a column of data in the original file in descending order.
    Step 5: Save the file as the "descending" file for this assignment.
    Step 6: Using the "sort" function, sort a column of data in the original file in ascending order.
    Step 7: Save the file as the "ascending" file for this assignment.
    Step 8: Submit original and sorted files to the instructor via email attachment by the due date.

    * Scoring Rubric *

    Full Credit
  • Original file created
  • 20+ rows, 5+ variables
  • Two "Sorted" files created
  • Sorted in different orders
  • Three files submitted
    		•
    Partial Credit
  • Original file created
  • 10-19 rows, 3-4 variables
  • Two "Sorted" files created
  • Sorted in similar orders
  • Three files submitted
    		•
    No Credit
  • Original file created created
  • 0-9 rows, 0-2 variables
  • Sorted files not created
  • Sorted files not submitted
  • Original file submitted late
    		•