SMITH, John By entering names in this format, names can be ordered alphabetically (ascending or descending) by surname. Use the following name format to ensure consistency, e.g. Recommend that you enter the surname first followed by the first name Entering Student Names Enter the names of the students that are registered to attend the class under the Student Name header in column B. Total attendance percentage figures are calculated for all classes delivered for the month to date.Įntering Month, Year, Subject / Course, Group, Time and Location Enter details of the Month, Year, Subject / Course, Group, Time and Location directly into the cells identified. Late, Absent or Excused that day is automatcially counted and a classĪttendance percentage calculated.

Record (the column for a day) the total number of students Present, Header, the total number of classes the student is Present, Late,Ībsent or Excused is automatically counted and the students attendance This takes a lot of time that managers could otherwise spend on more important tasks.To the right of each monthly student record (the row for a student) under the STUDENT TOTALS Managers usually have to remind employees to submit their timesheets on time, collect them into a common format, and make sure they are timely forwarded to accounting or another responsible department.Spreadsheets require too much administrative work.When a company systemizes its workflow with spreadsheets and chain emails, some data might slip through the cracks. There can be cases where employees misenter their work data, forget to send their timesheets altogether, or end up sending them to the wrong person.Spreadsheets are prone to human error and data loss.

Online spreadsheets usually have a version history but they are most commonly downloaded locally and forwarded via email.

‍Spreadsheets can be edited by anyone with access, which is why it’s hard to see who made the last changes.

Tracing previous spreadsheet versions may leave you lost in history.

Moreover, if you’re using a mobile device, your thumbs might become sore.

Keeping timesheet spreadsheets up to date can become a cumbersome and time-consuming task.

Despite their intuitive learning curve, spreadsheets are not very user-friendly.

Free student attendance excel template