STUDENT RESULT GENERATION
Aim :
The goal is to develop an automated system that reads an excel
file, performs aggregate operations, writes the calculated.Data
to an Excel file, and finally renames the Excel file according to a
predefined naming convention. Calculate Overall Percentage by
dividing Total mark with number of subjects.
Procedure:
1.Data input ( excel, web)
First, you need to gather the student data (marks, grades, etc.)
from an input source such as Excel, Google Sheets, or a web
portal.
If the data is in Excel, use the Excel Application Scope activity
to open the file and read data using Read Range or Read Cell.
If you are scraping the data from a website, use web scraping
activities (Data Scraping, Get Text, etc.).
2. Processing the data :
Once the data is extracted, you will need to perform operations
like calculating total marks, average, grade, etc.
Use the Assign activity to perform arithmetic operations (e.g.,
adding marks, calculating averages).
3. Storing results:
After calculating the results, you can either write them back to
an Excel file, a database, or generate a report (PDF, Word,
etc.).Use the Write Range activity in Excel to update the result
in the file.To generate reports in PDF or Word, use the
corresponding UiPath activities (Word Application Scope,
Create PDF, etc.
4.Process Each Student
Use a For Each Row activity to iterate through the rows of the
DataTable.
Within the loop:
Calculate Results: Use Assign activities to calculate total marks,
percentage, and grades based on business logic.
Update the DataTable with these calculated values.
5. Generate Reports :
Write Back Results: Use a Write Range activity to save the
updated DataTable back to Excel.
Export Reports (Optional): Use the Export to PDF or Send
Outlook Mail activities if reports are to be distributed via email.
6. Plan the Workflow
Identify the data source (e.g., Excel, database, or web portal)
containing student details and scores.
Define the calculation logic (e.g., total marks, percentage,
grades).
Decide the output format (Excel report, PDF, email, etc.).
7.Handle Exceptions :
Add a Try-Catch block to handle errors (e.g., missing data or
invalid inputs).
8. Build the test :
Debug the workflow to check for errors.
Test with sample data to validate the calculations and output
format.
Adjust activities or logic based on test results
9.Deployment and Execution :
Publish the project to UiPath Orchestrator (if needed).
Run the workflow in attended or unattended mode based on
requirements.
10.Example Workflow Activities
Input: Read student data using Excel Application Scope and
Read Range.
Processing: Use For Each Row, Assign, and If activities to
calculate results.
Output: Save results with Write Range or generate PDFs/emails.
Implementation Screenshots :
EXECUTING USING UI PATH
OUTPUT SCREENSHOT:
RESULT :
The Student Result Generation Project effectively demonstrates
the power of automation in streamlining repetitive and time-
consuming tasks. By using UiPath Studio, we were able to
design a workflow thatAccurately Processes Student Data: The
project calculates total marks, percentage, and grades with
precision, reducing human errors
Diploma certificate:
