Elevate your Excel skills and gain essential tools for classroom efficiency with Weighted Grade Sheet in Excel. This course is ideal for teachers seeking personalizable CEUs and school staff looking for inexpensive professional development hours.
The 3-hour professional development course covers advanced Excel functions, including the SUMIF formula and techniques for advanced data organization. Even if you are not currently teaching, building a weighted grade sheet will enhance your Excel proficiency and prepare you for future projects. By the end of the course, you will know how to enter and format text, apply formulas, calculate averages, merge cells, and customize cell formats with borders and colors.
Update: This course has been updated to include Excel 2016
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.