How to Create a Gradebook in Excel

27 CQ
10 Lessons
Course Info
Previous...
  • Playing
    2 CQ
    6. Creating Automated Errors in Excel
    A lesson with Todd McLeod
    View lesson

    In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!

    Creating Automated Errors in Excel
    with Todd McLeod

    In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!

  • Playing
    3 CQ
    7. Calculating Grades in Excel Gradebook
    A lesson with Todd McLeod
    View lesson

    In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.

    Calculating Grades in Excel Gradebook
    with Todd McLeod

    In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.

  • Playing
    2 CQ
    8. Vlookup Function in Excel Gradebook
    A lesson with Todd McLeod
    View lesson

    Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.

    Vlookup Function in Excel Gradebook
    with Todd McLeod

    Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.

  • Playing
    2 CQ
    9. Freeze Panes & Sorting in Excel
    A lesson with Todd McLeod
    View lesson

    You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.

    Freeze Panes & Sorting in Excel
    with Todd McLeod

    You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.

  • Playing
    5 CQ
    10. Moving Blackboard Grades to Excel
    A lesson with Todd McLeod
    View lesson

    In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.

    Moving Blackboard Grades to Excel
    with Todd McLeod

    In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.

More...
  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

    You don't have any lessons in your history.
    Just find something that looks interesting and start learning!

    Comments
    500 characters max