How to Make a Student Attendance Sheet Using WPS Office

January 18, 2024 1.3K views

Creating a student attendance sheet can be a hassle, but it doesn't have to be. With WPS Office, you can easily create a digital attendance sheet that is both organized and accessible. In this article, we will show you how to make a student attendance sheet using WPS Office.

Part 1. How to Make a Student Attendance Sheet Using WPS Office?

On Windows and Mac

Here are the steps on how to make a student attendance sheet using WPS Office for Windows, with easy-to-understand and widely-used examples and images:

Step 1 Open WPS Spreadsheets: Create a new workbook or use a template from the WPS Template Gallery.

open spreadsheet

Step 2 Enter Student Names: In the first row, list the students and use the "Sort" function to arrange them.

enter name

Step 3 Enter Dates: Fill the first column with class dates using the "Fill" function.

Enter date

Step 4 Set Attendance Symbols: Add symbols or colors for attendance status next to each student name and date. Use conditional formatting for visual cues.

Add symbols

Step 5: Add Column for 'Total'

Instead of the far right, position the total attendance tally beside each student's name. Right-click column B, choose "Insert," and label it as "Total."

insert total

Step 6 In the first "Total" slot, enter =SUM( and click the first date box. Extend the selection to the end of the row using Shift + Right Arrow or mouse drag, then press Enter.

Press enter

Step 7: To remove zero values for unassigned student slots:

IF Statement for Blank Slots: In the first total box, enter the formula: =IF(A2="","",SUM(C2:N2))

Step 8 Enhance Formatting: Use formatting tools for a polished appearance.


This method is easy and convenient for creating a basic attendance sheet. It allows you to use various tools and features to customize your sheet according to your needs.

On Mobile

Step 1 Open the WPS Office app. Tap on the + button.

Tap +

Step 2 Select Spreadsheet.

Select Spreadsheet

Step 3 Creat a blank spreadsheet or choose a exsiting temple

Creat or pick a template

Step 4 Enter the following headings in the first row:

  • Student Name

  • Date

  • Present

  • Late

  • Absent

Input headings

Step 5 Mark the students as present, late, or absent for each date.


Step 6 Save the spreadsheet.

Tap Save

Input Name

This method is convenient for creating an attendance sheet on the go. It allows you to use your mobile device to access and edit your sheet anytime and anywhere. However, it may not be very comfortable or efficient for entering or viewing a lot of data on a small screen.

Part 2. Attendance Sheet Template Website Recommended.


WPS Office

WPS Office provides ready-made spreadsheet templates designed for tracking attendance. The "Spreadsheet" application can be used to open and customize these templates to fit your needs. These templates typically include columns for dates, student names, and checkboxes for marking attendance.



Jotform offers a platform to create digital attendance forms with customizable fields such as student names, dates, and attendance status. Users can easily fill out these forms on their devices, and the data is automatically collected and organized for analysis.



Lio provides a solution for creating and managing attendance sheets with customizable fields including student names, dates, and attendance statuses. Lio's real-time collaboration features allow team members to update attendance information concurrently, promoting efficient teamwork.

Resonating Reminder:

  • Consistency: Ensure a consistent and organized format to enhance readability.

  • Data Validation: Employ data validation techniques to ensure precise inputs.

  • Regular Updates: Maintain accuracy by routinely updating the attendance sheet.

  • Backup Strategy: Regularly save and back up your attendance sheet to safeguard against data loss.

  • Password Protection: If needed, implement password protection to prevent unauthorized access.

Part 3.Unlock Teaching Potential with WPS Office

WPS Office

WPS Office offers a valuable opportunity for educators to enhance their teaching capabilities. As a free office suite, it provides the ability to easily open, create, edit, and save Microsoft Office files, including Word, Excel, and PowerPoint. This software is fully compatible with both Windows and Mac operating systems, ensuring accessibility for all users.

Moreover, WPS Office introduces AI-powered tools like WPS AI writing and AI PDF, which can significantly assist in daily school tasks and studies, ultimately streamlining teaching processes and fostering academic success.

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

Steps to edit Word/Excel/Powerpoint in WPS:

Here are the steps to edit Word/Excel/Powerpoint in WPS

Step 1 To edit Word/Excel/Powerpoint in WPS, you need to download and install WPS Office. You can get it from here.

Step 2 After installing WPS Office, you can open the application and click on the desired program, such as Writer for Word files, Spreadsheets for Excel files, or Presentation for Powerpoint files.

Pick option

Step 3 You can create a new document by clicking on the “Blank” button or open an existing document by clicking on the “Open” button.

Open or create

Step 4 You can edit the document using the various tools and features available in the ribbon menu, such as formatting, inserting, reviewing, etc.


Step 5 You can save the document by clicking on the “Save” button

Save your document

Steps to Use WPS AI:

Step 1 To use WPS AI, you need to activate the WPS AI assistant by clicking on the “WPS AI” widget on the top menu or simply type “@AI” using your keyboard.

Access AI

Step 2 You can give a writing prompt to the WPS AI assistant based on your needs, such as “Please generate a poem about love”.

Provide prompt

Step 3 The WPS AI assistant will generate content for you based on your prompt. You can review and edit the content as you wish.

Your content

Step 4 You can refine the prompt by adding more details or changing the keywords to get different results from the WPS AI assistant.


Step 5 You can also use the formatting and editing tools in the ribbon menu to enhance your document.



What is the best way to take students' attendance?

The most effective methods for taking student attendance include verbal confirmation in person, using a seating chart, or electronic means. For larger classes, a simple approach is to call roll, which can also be implemented for students attending via Zoom without the need for a Usage Report.

Can you use a QR code to take attendance?

Using QR codes for attendance automation is straightforward and does not require any specialized skills. Google Forms offers QR code attendance tracking capabilities. By creating online forms and distributing them to attendees, individuals can easily mark themselves as present by scanning the QR code when they arrive.


In summary, this guide has shown how to create a student attendance sheet efficiently using WPS Office. It emphasizes the user-friendly steps for Windows and mobile platforms. WPS Office simplifies attendance tracking, and the guide stresses key practices like consistency and data validation. Additionally, it highlights WPS Office's broader capabilities, including document editing and AI assistance, making teaching tasks easier. Overall, WPS Office offers a practical solution for managing attendance and enhancing teaching.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.