Microsoft Excel "Create Grade Book &Attendance Sheets"

Microsoft Excel "Create Grade Book &Attendance Sheets"

Create Your own GradeBook and Attendance Sheet Using Ms. Excel

This Excel  course is intended for educators , mentors , trainers ,and coaches who need to assess their students and take their daily attendance, learners need to know basic Excel before they take this course and it is meant for intermediate students

At the end of the course learners will be able to create their own grade book and attendance sheet , then use it as a template for future use , but at first they need to review the following Ms Excel topics :   

• How to use Formulas

• The order of operator precedence in Excel Formulas

• How to use the Average Function  a

• How to use VLOOOKUP Function

• Absolute and Relative References 

• COUNT,COUNTA,and COUNTIF

• Conditional Formatting

In the first sections students will learn how to create  their grade book in ten steps as follows :

1. Creating a blank Sheet   

2. Entering Names   

3. Sorting Names   

4. Entering The Grades   

5. Calculating The Final Mark   

6. Inserting The LOOK UP Table   

7. Inserting VLOOKUP Function   

8. Adjusting The V LOOKUP Function   

9. Inserting The Average

10. Formatting  

In the second sections students will learn how to create their grade book in eleven steps as follows :

1. Copying The Names From GradeBook 

2. Inserting Days & Dates(Timeline)          

3. Shading Off Days                                     

4. Inserting Drop Down List to Take Attendance   

5. Inserting New Calculation Columns                              

6. Formatting   

7. More Formatting     

8. Counting Number Of Absent Days       

9. Calculating the % of Absence      

10. Freezing Panes         

11. Taking Attendance of The First Week

12. Conditional Formatting 

Educators: Use Microsoft Excel to Create your own Attendance Sheet, Gradebooks, change your assessment structure as well

Url: View Details

What you will learn

• Create your own Grade Book using Excel and using the following steps :
• Creating a blank Sheet
• Entering Names

Rating: 4.7

Level: Intermediate Level

Duration: 1 hour

Instructor: Osama Jaber