Master Excel for Education: Create Customized Grade Books

Create Customized Grade Books and Attendance Sheets with Ease

Created by: Osama Jaber
PMP, ACP,EE, Training Professional, CIPD, MCSE, MCSA, CCNA

What Will I Learn?

• Create your own Grade Book using Excel and using the following steps :
• Creating a blank Sheet
• Entering Names
• Sorting Names
• Entering The Grades
• Calculating The Final Mark
• Inserting The LOOK UP Table
• Inserting VLOOKUP Function
• Adjusting The VLOOKUP Function
• Inserting The Average
• .Formatting
• At the End of of the second section learners will be able to create their own attendance sheet using Excel and using the following steps :
• Copying The Names From GradeBook
• Inserting Days & Dates(Timeline)
• Shading Off Days
• Inserting Drop Down List to Take Attendance
• Inserting New Calculation Columns
• Formatting
• Counting Number Of Absent Days
• Calculating the % of Absence
• Freezing Panes
• Taking Attendance of The First Week
• Conditional Formatting
• Using Brad to create a count down Time

Requirements

• Have Ms Office Installed
• You need to know Basic Excel
• To be able to create the Grade book please review the following topics in Excel:
• Review how to Enter Data In Excel
• Review how to enter formulas
• Review Calculation operators and precedence in Excel
• Review the Average Function,COUNTA,and CountIF
• Review VLOOKUP function and VLOOKUP table
• Review absolute and relative referencing
• Review Conditional Formatting

Target audience

• Teachers , Instructors, Trainers , Educators and Mentors who would like to learn how to create their own attendance and grade books using Excel