VTU Student Data Miner

This project seeks to automate the process of analyzing and visualizing the Student Marks data. The app provides a comprehensive analysis of the data with interactive visualizations.

This is designed for colleges affiliated to VTU, to help colleges analyze their student data in a convenient and sophisticated manner. The usage of this app isn’t limited to institutions affiliated to VTU. Any institution that can provide the dataset in a suitable format can utilize this app.

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

  • RSudio
  • Packages:
    • shiny
    • shinyjs
    • tcltk
    • shinyWidgets
    • ECharts2Shiny
    • shinythemes
    • shinyBS
    • dplyr

Kindly install these packages as follows:

install.packages("shiny")

You can use the published version of app : Student Data Miner

Installing

Run in RStudio

To get the project running on RStudio, create a new project File -> New Project. Add the file app_test_phase_2.R to this project. Create a folder named www in the same directory and add the images. Open the file app_test_phase_2.R in the project, then click the button at the top to run the app.

Open app from URL

If you don’t have RStudio or just wish to use the app use the link: Student Data Miner

File Input Format

The file uploaded must be a .csv file with data in the format:

USN | NAME | GENDER | SEM | SECTION | SUB1_IA | SUB1_EA | SUB2_IA | SUB2_EA | SUB3_IA | SUB3_EA | SUB4_IA | SUB4_EA | SUB5_IA | SUB5_EA | SUB6_IA | SUB6_EA | LAB1_IA | LAB1_EA | LAB2_IA | LAB2_EA | TOTAL_MARKS | SGPA

How To Use The App

  • Upload a file to analyze using the Browse option, make sure it is a csv file.

  • The app provides 2 modes of Analysis : College, Student

  • College Mode:
    • If the dataset contains any missing values, the rows with missing values will be omitted from the analysis
    • This mode gives you 5 options:
    • Subject Wise Performance:
      • Select the Semester and the Subject to View Performance.
      • After selecting these click the button again to generate the output.
      • The OUTPUT tab gives the highest, lowest and the Average marks scored by the students in the selected semester, in all the subjects.
      • The PLOT tab has a Pie chart representing the grades obtained by the students.
      • This Pie chart is an interctive one, you can select/deselect the grades being used to plot the Pie Chart.
      • A button on the top right corner of the Pie Chart plot lets you print/download the Pie chart for fututre reference.
    • Section Wise Performance:
      • Select the semester to View Performance of and click the button again to generate the output.
      • The OUTPUT tab gives the average marks in each subject in the selected semester.
      • The PLOT tab shows a bar graph with the average performance of the students of each section for each subject.
      • The bar graph is an interactive one, you can select/deselect the subjects being used to plot the graph.
      • A button on the top right corner of the plot lets you print/download the graph for fututre reference.
    • Grade Based Analysis:
      • Select the semester to View Performance of and click the button again to generate the output.
      • The OUTPUT tab provides two options - Semester and Grade. It gives a list of students who have scored the selected Grade in the selected Subject.
      • The PLOT tab shows a bar chart, which depicts the grades obtained by the students in every subject.
      • The bar graph is an interactive one, you can select/deselect the subjects being plot in the graph.
      • A button on the top right corner of the plot lets you print/download the graph for fututre reference.
    • Year Back/Critical Analysis:
      • This option is being developed, this section will be updated once it is complete.
    • Top 10 Rank List:
      • Select the semester and click the button again to generate the output.
      • The OUTPUT tab shows you a list of the students who scored the top 10 marks(SGPA) in the selected semester.
  • Student Mode:
    • Select the USN of the student and select one of the 3 options:
    • Analysis Based on Semester:
      • Select the semester and click the button again to generate the output.
      • The PLOT tab shows a line graph which depicts the marks scored by the student in all the subjects in the selected semester.
    • Subject Wise Rank in class:
      • In the OUTPUT tab, this option shows the RANK of the student in the selected subject in the selected semester.
    • Compare Performance Over All Semesters:
      • This option gives you an interactive line graph in the PLOT tab.
      • Each of the lines represent a marks of the student in all the subjects.
      • The line graph is an interactive one, you can select/deselect the lines(semesters) being plot in the graph.
      • A button on the top right corner of the plot lets you print/download the graph for fututre reference.

  • About Us: Get to know the people who built the app.

Built With

  • RStudio - The IDE used
  • R - Programming language and free software environment for statistical computing and graphics

Developers

  • REQUIREMENT COLLECTION TEAM:
    • Sushma P Shetty
    • Swathi S Karanth
    • Vanditha D Rego
  • UI DESIGN TEAM:
    • Mohammed Moshin
    • Siddesha
    • Sourabh R Agari
  • MODEL DESIGN TEAM:
    • Akshatha Patkar
    • Janet Noronha
    • Suman R Nayak
    • Vaishnavi N Naik

This project was developed under the guidance of Mr Kevin Joy D’Souza, Lead Consultant, Visionest Technologies

Acknowledgements