See my article Using Unicode Character Symbols in Excel for more Unicode symbols. Some of the more recently defined Unicode characters only show up in more recent browsers and may not be supported by all apps. These symbols may not show up in your browser. You can copy and paste from this page to get these symbols into Excel. Piece of 🍰 (cake).īelow are a few symbols or characters you might use for your attendance roll. To customize the drop-down boxes, you can edit the CheckBox list to the right of the attendance roll within the spreadsheet. So, you can always revert back to using a symbol that your app supports (like an 'x'). Not all Unicode symbols will be defined for all fonts and operating systems and browsers and apps. So, it doesn't matter what symbol you use for marking the roll. The Excel template for school attendance reports can be used to create class attendance reports that are printable. Another important feature of a school management system is the tracking of attendance.

The template uses the COUNTA() function to count the number of cells that have text in them. Teacher’s attendance excel template for teachers. While these are not easy to insert using the keypad, you can easily select them when the sheet is set up with Excel drop down lists. It turns out that on some phones you can use the emoji or emoticon symbols within the Excel app.

Option 2: To mark a student as excused, where the student is effectively considered ' Absent' in the attendance calculation, use the letters 'EX'.In this template I decided to do something a little more fun than just using an 'x' for marking attendance. Option 1: To mark a student as excused, where the student is effectively considered ' Present' in the attendance calculation, use the letter 'E'. You can choose two different ways of marking a student as 'Excused'.

You can use either capital letters or lowercase letters. ('E' counts as 'Present', and 'EX' counts as 'Absent')

To mark a student as being excused, type the letter 'E', or the letters 'EX'.

To mark a student absent, either type the letter 'A', or the number '0'.To mark a student present, either type the letter 'P', or the number '1'.You can also mark a student as 'Excused', which will display differently visually… but will count as 'Present' in the versions that calculate. There are a couple of different ways to mark a student present or absent in the attendance templates. Marking students 'Present', 'Absent', and Excused'

Student attendance excel template