Create Your Own GradeBook

Osama Jaber, CIPD,CCNA,MCSE,MCSA

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (18m)
    • Introduction

      1:42
    • Steps in a nutshell

      2:00
    • Entering Names , Headers , then Sorting

      2:14
    • Entering Grades , Then calculating the Final Mark

      3:34
    • Inserting vlookup table, VLOOKUP Function and adjusting the absolute reference error

      4:31
    • Calculating the Average and formatting the Sheet

      3:48

About This Class

This course is intended for educators ,mentors 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 meant for intermediate students

Does your school have the right tools for you ?Do they give you the right GradeBook format ? Can You Customize ? I have been in that predicament myself , That's why I decided 18 years ago to learn how to do my own ,I will share my Experience with you , so at the end of this course you will be able to create your own GradeBook by following the below 10 easy steps :

  1. Creating a blank Sheet
  2. Entering Names
  3. Sorting Names
  4. Entering Grades
  5. Calculating The Final Mark
  6. Inserting The LOOK UP Table
  7. Inserting VLOOKUP Function
  8. Adjusting The VLOOKUP Function
  9. Inserting The Average
  10. Formatting

Please review the following topics in Ms. Excel before you start your project :

  • How to use formulas
  • The order of operator precedence in Excel Formulas
  • How to use the Average Function 
  • How to use VLOOOKUP Function
  • How to use Absolute and Relative References 

After Reviewing the above topics , watch the videos then start working on your project , I will be there for you to finish it 

            

--

Students

--

Projects

Osama Jaber

CIPD,CCNA,MCSE,MCSA

CIPD certified training programs Manager, with experience exceeding 15 years of training programs

Having over 20 experience in  Training Project Management , leading Multicultural and cross-functional teams

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 .

 25% of My Course Earning will be donated to Syrian Refugees and Somalian Famine Victims