Master Excel for Education: Create Customized Grade Books
What you'll 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
Description
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 :
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 V LOOKUP Function
Inserting The Average
Formatting
In the second sections students will learn how to create their grade book in eleven steps as follows :
Copying The Names From GradeBook
Inserting Days & Dates(Timeline)
Shading Off Days
Inserting Drop Down List to Take Attendance
Inserting New Calculation Columns
Formatting
More Formatting
Counting Number Of Absent Days
Calculating the % of Absence
Freezing Panes
Taking Attendance of The First Week
Conditional Formatting
Who this course is for:
- Teachers , Instructors, Trainers , Educators and Mentors who would like to learn how to create their own attendance and grade books using Excel
Instructor
- 4.2 Instructor Rating
- 262 Reviews
- 29,527 Students
- 7 Courses
CIPD certified training programs Manager, with experience exceeding 15 years of training programs
Having over 20 years of experience in Training Project Management , leading Multicultural and cross-functional team
Managing training programs from Training Needs Analysis, writing proposals budgeting, execution to evaluation.
Conducting trainer's induction and train the trainer courses, excellent experience in blended learning management, design of Learning Management Systems and development of competency management system.
Ability in leading technical training courses, designing and writing training courses
Some of what my students wrote about my Courses:
"A short course in how to get the most out of your Google searches with practice examples that make sense in the Real World."
"I'm glad I took this course. I'll be able to run much faster searches after this. Thank you
"Thank you so much for this course! What I have learned is going to be Very useful in my future endeavors
"This course helps you learn how to use Google effectively. There are a lot of things you can do using Google which you may not be aware of