Changes 12/4/13

Math Drill:

• Added new tables to database: Students and Questions
• These will replace the .txt files which held the student names and question/image pairs
• Disallowed access to /admin/ pages without signing in first

NSF:

• Explored databases
• The Export Awards excel spreadsheet looks like it shows various information about patents awarded due to NSF funding.  I assume that these are the reports in which people properly cited NSF as a grant giver, because I understood one of the main problems the NSF is facing is finding patents that weren't correctly filled out with proper NSF credit on them.  All the patents in the spreadsheet, however, have the same Funding Agency and Awarding Agency Code, 4900, which I'm guessing is the NSF's id.
• If there is some way to view businesses attached to the patents, then compiling earnings based on these patents will be possible.
• http://patents.reedtech.com/pgrbft.php#2012 looks like it's a repository of xml patent data
• I downloaded one xml file and looked at it.  It was hard to figure out what it was showing because it had no styling, but it looked like a list of a bunch of different patents all in one file.  I couldn't tell what the number after ipg meant (the file I downloaded was named ipg131203.xml)
• The StateObligations.xml and InstitutionObligations.xml files look like they are listing the amount of different types of "obligations" by state or institution.  I assume obligations are promises of grant money.