Group No.
15
Presentation- 3
Date: 05-04-2024
GURU JAMBHESHWAR UNIVERSITY OF SCIENCE AND
TECHNOLOGY, HISAR
( Electronics and Communication Engineering, B.Tech)
PROGRESS REPORT - 3
Biometric Attendance System with Google Sheet Integration
Under the Supervision of– Group members-
Dr. Vinod Kumar Deepanshi ( 200151520010 )
Nidhi ( 200151520023)
Progress Report 3
Biometric Attendance System with Google Sheet Integration
Executive Summary
The Biometric Attendance System with Google Sheet Integration project aims to streamline attendance tracking
using biometric identification technology and synchronize the attendance data with Google Sheets. This report
provides an overview of the progress made in the initial phase of the project.
Objectives
● Develop a reliable biometric attendance system.
● Establish seamless integration with Google Sheets.
● Enhance accuracy and efficiency in attendance tracking.
Circuit Diagram
The connections are pretty simple. Connect the VCC and GND pins of FR307, OLED display, and RTC module
to the 3.3V pin and GND pins respectively. Then connect the SDA and SCL pins of the RTC module and the
OLED display to the GPIO21 and GPIO22 respectively. Now connect the TX pin from the FR307 to GPIO16
and the RX pin to the GPIO17.
Components Used
● ESP32 Development Board
● R307 Finger Print Module
● Wires
● Connectors
● 5V power supply
ESP32 Development Board
The development board consists of an ESP-WROOM-32 module. It’s a 32bit dual-core microcontroller
with built-in WiFi and Bluetooth. ESP32 can work with a clock frequency up to 240MHz and has a
RAM of 521kB. The ESP-WROOM-32 module is also equipped with an SPI flash storage of 4MB,
which can be used for the application area as well as the file system.
ESP32 Development Board
R307 Finger Print Module
In this project, we are going to use such a sensor, the popular R307 Optical Fingerprint Sensor.
The Optical Fingerprint sensors are on the Total Internal Reflection or TRI principle. The Optical
Fingerprint sensors consist of a light source, prism, lens, and image sensor. The light from a source
(typically an LED) enters the prism from one face at a certain angle, such that it is reflected from the
adjacent face and exists through the third face. This light then passes through a lens and then reaches
the image sensor. When there is no finger placed on the sensor, the light will completely reflect off
from the surface and this produces plain images on the image sensor. When there is a finger placed on
the sensor, some of the light is reflected and this creates the image of the fingerprint pattern. The light
leaked along the surface of the prism is called Evanescent Waves.
Different materials have different reflective indices and interact differently with the evanescent waves.
When the fingertip is placed over the scanner, the ridges are in tight contact with the scanner’s surface
while the valleys are filled with air pockets. The skin and air have different reflective indices causing
different evanescent waves, called Frustrated Total Internal Reflection (FTIR). As a result of different
evanescent waves from ridges and valleys, the intensity of the total internally reflected light changes
according to the pattern of the ridges and valleys. The image sensor captures a high contrast image
recording the changed light intensity pattern, capturing the pattern of ridges and valleys as a high-
contrast digital image. This image is then stored in the flash memory with a unique id as a template.
This template is used to identify the user later.
They are manufactured by Hangzhou Grow Technology Co., Ltd. The R307 module operates at a
voltage of 4.2V~6V and 50 mA with a storage capacity of 1000 impressions. R307 has both UART
and USB 2.0 interfaces to communicate with a computer system at a baud rate in multiples of 9600
bps.
R307 has a glass top where a fingertip can be placed for scanning. Below the glass top is placed a
prism. The inside of the sensor is divided into two parts using a light barrier. On one side of the light
barrier is a PCB consisting of four blue LED lights. On the other side of the light barrier is an image
sensor connected to a processor.
The R307 module can be operated at both 5V and 3.3V. If the sensor is used with a 3.3V
microcontroller, the 3.3V jumper on the PCB must be shorted and for 5V usage keep the jumper open.
When connected via a USB port, the device will create a virtual com port and will communicate
through it. The first four pins on the connector are for power and UART communication. The last two
pins are for touch detection. If pin number 6 is connected to the 3.3V supply, pin 5 will go high when a
finger is placed over the sensor. This is useful for manual scanning.
Pinout Table for R307 Sensor
Budget of the Project
NAME OF QUANTITY PRICE
COMPONENTS
ESP 32 DEV BOARD 1 550
R307 FINGER PRINT 1 1200
MODULE
WIRES VARIABLE VARIABLE
CONNECTORS VARIABLE VARIABLE
5V POWER SUPPLY 1 150
Conclusion
Automating attendance tracking through biometrics and Google Sheets integration provides immense
efficiency and convenience benefits compared to manual registers. It eliminates the need to manually
mark registers, collate timesheets, calculate hours worked and leave days on paper - which is
inefficient. Instead, all data gets captured digitally through fingerprint scans. This data seamlessly
transfers to the cloud. Administrators get real-time data access and customizable reports. So there is
higher transparency and reduced manual effort. The web portal also makes it very easy to quickly
enroll employees, manage their details and configure system settings. No physical access to the device
needed. From an employee perspective as well, all that is needed is a quick fingerprint scan to mark
attendance. No pens, registers or network connectivity required on their part. So the system offers
convenience for both administrators and employees. Attendance tracking becomes automated, accurate
and efficient. Data access becomes easier. Payroll processing and leave calculations can leverage
digitized data. Overall, integrating a biometric system with Google Sheets helps take attendance
management to the next level in terms of productivity, transparency and analytics.
Currently the project is in the initial phase. We prepared the budget of the components required for the
project with the circuit diagram that guides us while building the project. Challenges have been
identified and addressed, and the team is well-prepared for upcoming tasks.
