How to Create a Gradebook in Excel

27 CQ
10 Lessons
Course Info
Previous...
  • Playing
    Free
    3 CQ
    1. Creating an Excel Gradebook Layout
    A lesson with Todd McLeod
    View lesson

    Managing student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.

    Creating an Excel Gradebook Layout
    with Todd McLeod

    Managing student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.

  • Playing
    4 CQ
    2. Tracking Attendance in Excel
    A lesson with Todd McLeod
    View lesson

    In this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.

    Tracking Attendance in Excel
    with Todd McLeod

    In this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.

  • Playing
    2 CQ
    3. Adjustments to Excel Gradebook
    A lesson with Todd McLeod
    View lesson

    In this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.

    Adjustments to Excel Gradebook
    with Todd McLeod

    In this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.

  • Playing
    2 CQ
    4. Entering Data into Excel Gradebook
    A lesson with Todd McLeod
    View lesson

    Learn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!

    Entering Data into Excel Gradebook
    with Todd McLeod

    Learn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!

  • Playing
    2 CQ
    5. Entering Formulas into Excel Gradebook
    A lesson with Todd McLeod
    View lesson

    Add Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!

    Entering Formulas into Excel Gradebook
    with Todd McLeod

    Add Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!

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