Master Excel for Education: Create Customized Grade Books

Are you an educator, trainer, mentor, or coach looking to streamline your grading and attendance tracking process? Look no further! Our specialized Excel course is tailored specifically for you. Designed to empower intermediate Excel users, this course will elevate your skills and enable you to create personalized grade book and attendance sheet templates.

To make the most of this course, it is recommended to have a basic understanding of Excel. Whether you're looking to enhance your existing knowledge or take your Excel proficiency to the next level, this course is ideal for expanding your expertise.

Throughout the course, we will guide you through the step-by-step process of creating customized grade books and attendance sheets. Imagine the convenience of having templates that assess your students' progress and track attendance effortlessly on a daily basis. By implementing these templates, you'll save valuable time and effort in the long run.

Our comprehensive instruction will ensure that you gain the necessary knowledge and skills to become proficient in Excel. You'll be equipped to design professional-grade books and attendance sheets that meet your specific needs. No prior experience in creating such templates is required – we'll guide you through the process from start to finish.

Are you ready to unlock the full potential of Excel and revolutionize your grading and attendance tracking? Enroll in our course today and embark on a transformative journey that will enhance your productivity and simplify your administrative tasks. Don't delay – take the first step towards mastering Excel for educational purposes now.

topics :   

• How to use Formulas

• The order of operator precedence in Excel Formulas

• How to use the Average Function  

• 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