MATLAB is a tool that is used for various purposes like simulation, creating GUI applications, performing complex analysis, image processing and many more. This MATLAB project helps you to Automate the certificate generation by changing the names in the certificate automatically by taking input from the excel sheet.
Certificates are given to students as proof of attending a workshop or finishing a course. Educational institutions use software to automatically generate certificates for symposiums, workshops, conferences, etc. This MATLAB project helps to reduce the workload and speeds up the task.
MATLAB Kit will be shipped to you and you can learn and build using tutorials. You can start for free today!
Overview
In this MATLAB project, we will generate certificates by taking data from an excel sheet (like name, course, workshop, etc.) and editing it in a blank certificate file. In this project, we are going to generate a certificate for an aeromodelling workshop so there are three data we are going to mention in the certificate:
Want to develop practical skills on MATLAB? Checkout our latest projects and start learning for free
Steps involved in this project
Step 1: Creating a Base Image
A base image or sample certificate is created. You can use photoshop to create the certificate. It can be in formats like PNG, JPG and TIF.
Step 2: Collecting data
Collect the participant’s data or students data in an excel sheet or you can also use a google form to collect the data which will make your job easier. Now both student details and sample certificate is ready. Next step is to write the code to generate the certificate.
Step3: Writing code to take data from excel sheet
This step explains the code to be written in MATLAB to take the data from the excel sheet.
filename = ‘Registration_Details.xls’
[num, txt] = xlsread(filename) #The above code reads the data in the excel file.
len=length(txt) #reads the number of data to detect the number of certificates to be generated.
Now we are going to give the command to extract data from a particular column and row.
for i=1:len
for j= 3:3
text_topic(i,j)=txt(i,j)
end
end
#This obtains workshop topic from the excel sheet
Similarly, you can write code to extract data for name, date, grade and so on.
Step 4: Generating the certificate
This step explains you to generate the certificate automatically using the extracted data. For this step, you need to give the information where the name, workshop, and date to be printed on the certificate. You can take the location of the text to be printed using MS paint which gives you the data in pixels.
blankimage = imread('Certificate.tif'); #reads the sample certificate
After reading the image you need to give the position of the place to enter the student name, workshop name, date, etc. Now the certificate will be generated and saved automatically with different names.
The Matlab code file, sample certificate, registration details, etc. should be saved in the same folder to avoid errors.
Further upgradations
This MATLAB project can also be integrated with a college or institution website where a student can able to download the certificate by using their login credentials. This will help students to download their certificates again if it gets lost.
To implement the above proposal you should have the knowledge of programming languages like PHP, HTML and database language.
Skyfi Labs helps students learn practical skills by building real-world projects.
You can enrol with friends and receive kits at your doorstep
You can learn from experts, build working projects, showcase skills to the world and grab the best jobs.
Get started today!
Join 250,000+ students from 36+ countries & develop practical skills by building projects
Get kits shipped in 24 hours. Build using online tutorials.
Stay up-to-date and build projects on latest technologies