Python program which grades Excel homework built by a lazy TA
#Auto Grader Assignment Syntax
#Created by Sam Gates
#<-Before the line means this is a comment... like this line
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#Syntax as follows:
=0
#=0 means the first sheet. 1 means second, think programming counting
#If the operator returns true (i.e. Check1 finds 1 or more of what its looking for), answer is correct
*[CellToCheck] CheckN [ValueToCheck] (Comment) -PointValue
#CheckN means to check for count of ValueToCheck >= N in CellToCheck
#DiscardN means to check for count of ValueToCheck < N in CellToCheck
#* is an optional operator at the start of the line
#* means that the next statements beginning with ** will be hitting the same problem
#This means that we can have multiple queries checking the same problem but not
#deduct points multiple times for the same answer
#EXAMPLE:
=0
*[A1] Check1 [IF] (Did not use IF function in cell A1) -3
**[A1] Check1 [AND] (Did not use AND function in cell A1) -3
#Checks if there is 1 or more IF functions AND if there is 1 or more AND functions in cell A1
#The student will get -3pts if they did not do both and recieve the comment