4.7 (5 ratings)
1,863 students enrolled
Wishlisted Wishlist

# Microsoft Excel "Create GradeBook&Attendance Sheets"

4.7 (5 ratings)
1,863 students enrolled
Created by Osama Jaber
Last updated 2/2017
English
Current price: \$10 Original price: \$100 Discount: 90% off
30-Day Money-Back Guarantee
Includes:
• 1 hour on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• At the End of of the first section learners will be able to create their own Grade Book using Excel and using the following steps :
• 1.Creating a blank Sheet
• 2.Entering Names
• 3.Sorting Names
• 5.Calculating The Final Mark
• 6.Inserting The LOOK UP Table
• 7.Inserting VLOOKUP Function
• 9.Inserting The Average
• 10.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 :
• 1.Copying The Names From GradeBook
• 2.Inserting Days & Dates(Timeline)
• 4.Inserting Drop Down List to Take Attendance
• 5.Inserting New Calculation Columns
• 6.Formatting
• 7.Counting Number Of Absent Days
• 8.Calculating the % of Absence
• 9.Freezing Panes
• 10.Taking Attendance of The First Week
• 11.Conditional Formatting
View Curriculum
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

This 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 meant for intermediate students

At the end of the course learners will be able to create your grade book and attendance sheet and use it as a template for future use , but at first you 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
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)
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 Conditional Formatting

25% of All Course Revenue will be donated to Syrian Refugees , and Famine Victims in Somalia

Who is the target audience?
• Teachers , Instructors, Trainers , Educators and Mentors who would like to learn how to create their own attendance and grade books using Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
46:00
+
6 Lectures 18:38

Introduction :

This introductory talking head video I will give learners an insight to the steps that they will need to do to create their own grade book these steps are :

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

This is an intermediate course , before attempting to create a grade book learners need to review the following topics in Ms. Excel , these steps are :

• Entering Data In Excel
• Eentering Formulas
• Calculation operators and precedence in Excel
• Reviewing the Average Function & other function you need to use
• Last but not least entering VLOOKUP function and VLOOKUP table
• Reviewing also absolute and relative referencing
Preview 01:42

In this screen cast we will through the following steps of creating our grade book :

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

In this screen-cast video steps 1 to 3 will be covered , learners will learn how to :

• Create a new blank sheet in Excel
• Enter names in Excel
• Sort names in an Alphabetical order (A to Z)
• Use Auto Fit in the cells
• Ente the headers "data labels"
Creating New Blank Sheet and Entering the Names
02:14

In this screen-cast video steps 4 and 5 will be covered , learners will learn how to :

• Calculate the final Mark using a Formula , then centering the marks
Preview 03:34

In this screen-cast video steps 6 to 8 will be covered , learners will learn how to :

• Insert the LOOK UP Table
• Insert VLOOKUP Function
• Adjust The VLOOKUP Function , using absolute referencing .

Inserting the LOOKUP Function
04:31

In this screen-cast video steps 9 and 10 will be covered , learners will learn how to be :

• Inserting The Average Function
• Formatting

Insert the Average and Formatting
04:37

5 questions
+
6 Lectures 27:22

This white board animation will explain to the learners the steps to follow to create their Attendance sheet , these steps are :

1. First step is copying the names from the grade book
2. The second step is creating the timeline (calendar days and Dates)
3. The third step is shading the off days , Saturday ‘s and Sundays off , we will shade them with a darker color
4. The fourth step is inserting a drop down list ( P = Present , A=absent , L = late) in the cells to take the attendance
5. The fifth step is inserting 2 new columns to calculate the number of absent days , and percentage of absence
6. Step 6 is Formatting
7. Step 7 is Formatting to make the sheet user friendly
8. The eighth step is inserting a function to calculate the number of absent days
9. In step 9 we will be calculating the Percentage of absence
10. Step 10 we will be freezing panes “we will freeze the 1st three columns to show the names and statistics” when we scroll left or right
11. In step 11 We will be taking the attendance of the first week
12. In step 12 we will be doing conditional formatting , if the absence of any student is greater than 20% the cell will be shaded to red to alarm us that the student must be warned .
Preview 02:36

In this screen-cast video steps 1 to 4 will be covered , learners will learn how to :

1. Create a new Sheet
2. Copy names from one sheet into the new sheet
3. How to use Auto Fill to enter days and dates (Timeline)
4. Format Dates using Short Date Format
6. Inserting a drop down list containing P for present,A for absent,L for late

Entering names , days , and dates
06:20

In this screen-cast video steps 4 to 6 will be covered , learners will learn how to :

1. Insert new columns
2. Enter text using text wrap using keyboard short cut keys
3. Format the sheet to make it look user friendly
Formatting and inserting calculation columns
06:01

In this screen-cast video steps 7 to 9 will be covered , learners will learn how to :

1. Use CountIF function to calculate the number of absent Days .
2. Use CountA to calculate the number of days .
3. Use a Division Function to calculate the percentage of Absence .
4. Format numbers as percentages
5. Use Format Painter
6. Freeze Panes
Counting absent days and percentage of Absence
05:01

In this screen-cast video step 10 will be covered , learners will learn how to :

1. Enter Attendance
Preview 03:36

In this screen-cast video step 11 will be covered , learners will learn how to :

1. Use Conditional Formatting
Conditional Formatting
03:48

Attendance Sheet Quiz
5 questions
 4.5 Average rating 17 Reviews 3,295 Students 2 Courses
Instructor

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 All Courses Revenue will be donated to Syrian Refugees