Microsoft Excel "Create Grade Book&Attendance Sheets"
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Educators :Create your own Attendance Sheet,and Grade Book ,Customize your assessment Strategy to calculate final gradeDescription
Create Your own GradeBook and Attendance Sheet Using Ms. Excel
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 :
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
25% of All Course Revenue will be donated to Syrian Refugees , and Famine Victims in Somalia
Requirements
- 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
Knowledge
- Create your own Grade Book using Excel and using the following steps :
- 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 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)
- 3.Shading Off Days
- 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
Tally.ERP9+TallyPrime + GST + IncomeTax + MS Excel తెలుగు లో
- 3.6
-
![]()
![]()
![]()
![]()
![]()
A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Tax Professional, Auditors & Management Sectors Tally. ERP9 + TallyPrime+ GST + MS Excel తెలుగు లో...
Microsoft Excel "Create Grade Book&Attendance Sheets"
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Educators :Create your own Attendance Sheet,and Grade Book ,Customize your assessment Strategy to calculate final grade Create Your own GradeBook and Attendance Sheet Using Ms....
