Create Your Own attendance Sheet

Provided by:
0/10 stars
based on  0 reviews
Provided by:
Cost $8/mo
Start Date On demand

Course Details

Cost

$8/mo

Skillshare offers a wide variety of free and Premium courses on creative skills, marketing and more.

Get One Month Free

Upcoming Schedule

  • On demand

Course Provider

Skillshare online courses
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog h...
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog has grown from 15 to more than 250 online courses that cover creative arts, entrepreneurship, branding and marketing, lifestyle and technology. The School of MakeOurMark, with courses in photography, illustration and tattooing, was launched in October 2013, and the School of Design went live the following month. Among the instructors who have taught courses are Seth Godin, founder of online marketing firm Yoyodyne, who teaches a class on entrepreneurship; DJ Young Guru, who leads a course on mixing and recording; and actor, writer and director James Franco, whose course focuses on screenwriting for short films. You can begin a Skillshare collaboration by taking an introductory course in a particular area to learn, for example, the fundamentals of Photoshop and expand your knowledge with a five-part, in-depth Photoshop series.

Provider Subject Specialization
Arts & Design
Business & Management
34 reviews

Course Description

This course is for educators , coaches , mentors , supervisors who need to take daily attendance of their students or employees , 

In this course you will how create their Attendance sheet using Excel, using the following steps :

  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...

This course is for educators , coaches , mentors , supervisors who need to take daily attendance of their students or employees , 

In this course you will how create their Attendance sheet using Excel, using the following steps :

  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 .

To achieve that please review the following in Excel:

  • How to use Formulas
  • The order of operator precedence in Excel Formulas
  • How to use VLOOOKUP Function
  • Absolute and Relative References 
  • COUNT,COUNTA,and COUNTIF
  • Conditional Formatting
Reviews 0/10 stars
0 Reviews for Create Your Own attendance Sheet

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

No reviews yet. Be the first!

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.