Weighted Grade Sheet in Excel

Prerequisites

Materials

  1. Microsoft Excel (v. 2007, 2010, 2013, or 2016).
  2. Internet access.

Professional Learning Objectives

  • Use course text and guided instructions to create two grade sheets: a whole class weighted grade sheet and a student weighted grade sheet, completing each with 100% accuracy.
  • Demonstrate the ability to customize cell settings in Excel, including text formatting, merging cells, and applying borders and colors.
  • Write and apply the correct formulas, such as SUMIF, to generate the desired weighted grade results with 100% accuracy.
  • Apply course skills to create a similar grade sheet, showcasing knowledge of advanced Excel functions and data organization.
  • Reflect on the benefits of integrating weighted grade sheets to enhance student instruction, submitting a written response with 100% completion.

Common Core Standards

Let’s keep in touch

Where teachers go to learn. 215-660-4926