Grade Sheet in Excel

Prerequisites

Basic computer file management knowledge, e.g. opening, saving and uploading files, creating folders

Materials

• Microsoft Excel 2007-2016
• Internet

Professional Learning Objectives

Teachers will…
1. Use course text and guided instruction to construct and execute commands create two (2) grade sheets: (1) A Whole Class Grade Sheet and (2) A Student Grade Sheet with 100% completion.
2. Use course text and guided instruction to write the appropriate formulas needed to generate the desired result with 100% accuracy.
3. Use course text and guided instruction complete an assessment of skills learned by generating a new spreadsheet with 100% completion.

Common Core Standards

• CCSS Math Practice
• CCSS Math 2.4
• CCSS LA- Writing 1.4

Let’s keep in touch

Where teachers go to learn.