Using the GPA Analyzer.

Intended Users:
 This small utility calculates your absolute Grade Point Average and percentage. Hence mainly for students applying for universities in the US. The exact calculations are:

Overall			- Overall GPA
LastTwoYears		- GPA for all the subject in the last two years
OverallMajor		- GPA for subjects related your Branch 
LastTwoYearsMajor	- GPA for subjects related your Branch in the last two years
Average			- Average of the above 4 GPAs 
ExternalGPA		- GPA obtained by considering only the external marks
GuessGPAWithoutLabs	- GPA by excluding the labs. (Heuristically calculated) 
OverallPercent		- Overall percentage
LastTwoYearsPercent	- Percentage in the last two years.
NAs			- Number of A Grades A+,A,A-
NBs			- Number of B Grades B+,B,B-

The main advantage is that once you enter your marks you can set the grading scheme as different 
Universities may use their own scheme for determining what percentage range is A+, what percent 
range is B- and so on.

The MarksCardAnalysis.mdb is a Microsoft Access Database file.

It contains the code for doing the analysis.


The tables are as follows:

>>> MarksCard:
    
     This contains all the data about your subjects.
You have to do the following:

1. For each subject, enter the Internals, Externals Marks obtained. Total,Percentage, Grade and GPA are automatically calculated later. 

2. You can estimate the 8th semester marks or delete the subjects for 8th semester.

3. If the Max Marks are different, then enter the new max marks.

For branches other than CSE. Or those who have taken different elective than MVJCE CSE 1998 Batch:

4. If the subjects are radically different, delete all the subjects after 2nd Semester and enter 
the new subjects.

Please mail me the database after you enter the subjects so that other may be able to use the database.

5.  Then follow the steps 1 to 3.

>>> Analyzing your data:

In the modules tab ( modules tab is seen along with the 'tables' and 'queries' tab.)  there is a module named 'analyze'. 

a) Open on the module by double clicking on it. 
b) Then click inside the body of the function 'main'. 
c) Press F5 ( or menu: Run -> Go/Continue) to do the analysis.
d) You should get a message indicating the completion of the process.
e) Open the table 'analysis' to get the results.

>>>> Setting your grading scheme.

The controlling tables are:

1. Grading
2. GPA

1. Grading:
           This specifies which percent range corresponds to which letter grade. Universities differ in their letter-grading scheme.

For example, an A+ in MIT may mean 75% to 83%. Whereas 75% to 83% in University of Colorado (UoC) may mean just B+. This may be because the examinations and standards in MIT are much more 
difficult than in UoC.

Some universities may use some other letter grades such as 'AB' to indicate a certain percentage range.

So, get this percentage to Letter grade mapping from the university or students in that university and set this table.

limit1 == the lower limit of the percentage range.
limit2 == the upper limit of the percentage range.
Grade  == the letter grade for that range.

Note: 1. There must be atleast one record in this table.
      2. The percent ranges you specify must *finally* cover 0% to 100%.
	 That is, any given percentage must fall into only one range ( hence has a corresponding  
                Letter grade).

2. GPA table.
 
   This is so as to reflect the GPA for a given Letter grade.

Note: 1. There must be atleast exactly the same number of records as the number of records in the                   
              'Grading' table.
  
      2. In database terms, this table is existentially dependent on the records in Grading (              grade attribute). 
          The referential integrity is not enforced in the design for ease of use by novices. 		


Disclaimer:

This is a free program developed by Nishanth Reddy P. (nishanthr@hotmail.com). Hence,
I am not making any warranties on the use of this program or the effect of its result. 
I will NOT be held responsible in anyway, direct or indirect, for any damage, physical or 

psychological or any other damage which you may incur by the direct or indirect use of this 

program.

 Copy , distribute or modify without restriction. The greatest payment you can give me is an 

email acknowledgement about your use and your comments  on it at :>> nishanthr@hotmail.com 

 If you do not agree with the above disclaimer please feel free to remove the files that you 
got with the software. 	Part of the copyright maybe with Microsoft Corporation, Seattle, USA.

		
Contact Information:
      
       You can contact me at :
               Nishanth Reddy P
               USN: 1MJ98CS047 
               (Computer Science and Engineering, 8th Semester)
               M V Jayaraman College of Engineering
               Channasandra P.O,
	       Bangalore  560067
        
          But only until September 2002. After that I graduate from BE. :)
 
   Or:
          Contact me at the following email anytime:   nishanthr@hotmail.com

