Visual Basic for Applications (VBA) Gradebook for Excel


The Raymel Gradebook was designed for my wife.  Over the course of its life, it has had many “Honey Do” attachments and xtras added to it. Its conception occurred when we could find no other gradebook that offered the power that she needed to keep grades for her community college chemistry classes.  She needed a program that could meet the following conditions.  She wanted:

  • to keep grades for a class of chemistry students for which the class
    • had a lab section that was part of their grade. The lab sections:
      • were divided into smaller sections
      • a subsection of the main class of students
      • potentially taught by a Teaching Assistant
    • the option of replacing the lowest score in the main class with the final
    • the option of dropping the lowest score in the main class
    • the option of dropping the lowest lab grade
    • to be able to keep track of students that dropped her class
    • while still keeping their grades on file
    • the option to re-instante students in case they did not really drop the class
    • a way to report her grades with ease
    • a way to know quickly what the averages were for :
      • an exam
      • a student
    • a way to add a curve to the class if it were nessesary
    • a way of keeping track of extra-creditexample_Small
    • sorting features
    • an easy way to have and make backups of the gradebook

And thus, the Raymel Gradebook was created. Not in seven days but over the course of many months. It was then debugged over many terms.
The Raymel Greadebook is free and distributed under the GNU.  Included in the zip file is a pdf help file for getting started. Download the Raymel Gradebook here


Using Adobe Acrobat Pro to Bulk Add a Password to my PDFs

As I have been “Going Paperless” I have decided that I want to keep some of my scanned files under password protection. The problem is that I have been generating PDFs so fast with my new ScanSnap S1500. Traditionally with the Adobe Acrobat Standard (which is what comes with the ScanSnap S1500), the files have to be password protected one at a time. Yikes! That is a real pain when I am generating files at about 15 a minute! I would have to go in and individually add passwords to each file. This would be real time consuming. Luckily, I have Adobe Acrobat 8 Professional which allows for the batch processing of files. All I have to do is put all of the files that I want to password protect into a folder that I want to maintain. Then, I can run the batch processing from Adobe Acrobat  and it will password protect all of the files that are in that folder. Pretty Cool! (Some initial set-up required; however, it is fairly straightforward)

Batch Processing