Giter Site home page Giter Site logo

prakhargarg-2010196 / aktu-result Goto Github PK

View Code? Open in Web Editor NEW
1.0 1.0 0.0 4 KB

This is a google sheet that I created for calculating grade_point,grade_score,SGPA and CGPA

Home Page: https://docs.google.com/spreadsheets/d/1a_fN2U5p-HD5DPHgHsJjcsgswwaduWfymiYBmYKTOS4/edit?usp=sharing

google sheets template

aktu-result's Introduction

AKTU-RESULT ๐Ÿ‘ ๐Ÿ‘

This is a google sheet that helps you in calculating grade point,grade_score,SGPA , CGPA and more.

This is a general project in which I created a template for calculating your overall result for all the 8 semesters.

Instructions on using this sheet โ“โ“

There are 8 sheets as of now in this single google sheet one for each semester.

Each semseter sheet consists of the following structure

Semester Structure

Semester Structure

Important columns in this structure

  • Grade
  • Grade Point
  • Credits
  • Grade Score
  • Total Marks

Manual Work at your end in this structure ๐Ÿ˜•

  • Entering the following data
    • Internals and Externals
    • Grades
    • Credits ( You have to refer to the syllabus for this there is no way currently to adjust it or automate it ๐Ÿ˜ฟ )

Functions I have created here for easing calculations ๐Ÿ”ฅ

  1. GRADE_POINT_GENERATOR(grade) : This takes the value of your grade and automatically returns the grade points.
  2. GRADE_SCORE(grade_sem,credit_sem): This takes the grade of that sem and credit of that sem and returns the grade score accordingly.
  3. SGPA(total_grade_score_sem,total_credits_sem):This takes the total grade score of the sem and total credits of that sem and returns the SGPA.

Thus you don't have to enter the grade point,grade score and SGPA it will be automatically calculated based on other values.

Overall Result Structure

Overall Result Structure

Note: Here in this sheet there are two SGPA columns one is manually entered and another is dynamically generated your CGPA is generated over manually entered SGPA to be accurate.But can be generated over dynamic ones also as described below.

This sheet is your overall result and hence contains all the details including the following

Sem-wise Details

  • SGPA(statically entered)
  • Total Credits
  • Total Marks
  • Total Grade Score
  • Recalculated SGPA ( dynamically calculated)
  • Charts of sgpa vs sem and total_marks vs sem

Yearly Details

  • Total marks

Overall

  • CGPA

Manual Work at your end in this structure ๐Ÿ˜•

  • SGPA

Function for your Ease ๐Ÿ”ฅ

  • CGPA(sgpa_sem1, credit_sem1, sgpa_sem2, credit_sem2, sgpa_sem3, credit_sem3, sgpa_sem4, credit_sem4, sgpa_sem5, credit_sem5, sgpa_sem6, credit_sem6, sgpa_sem7, credit_sem7, sgpa_sem8, credit_sem8, range_cells_credits)
  • The above function takes the semester wise sgpa and credits and then gives back the cgpa

References

In future I would convert this into web-app maybe for ease of use case but as of right now this is what I am using.If anyone wants to collaborate for this project please contact me.Hope this helps!!

My socials are all here : https://bento.me/prakhargarg

aktu-result's People

Contributors

prakhargarg-2010196 avatar

Stargazers

 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.