Troy State University àCollege of Arts & Sciences àChemistry à Kingà Test Page Adder

 

Test Page Adder

 

This is a DOS program that adds page scores on multipage tests.  Here is what it looks like running in Windows:

The number of pages in the test is entered.  Then the total number of points is entered, or the individual page totals.  If the individual page totals are entered, the program can do some checking for you:  if you enter a page total larger than what is possible, it will beep at you.  (It beeped when I made that last entry, a 33 on page two.)  To exit the program, type 999.

 

Mistakes can be corrected by entering negative numbers.  Suppose the page totals on one test were 15, 15, and 22, but you entered 60 for page one.  Still being capable of doing math, you enter –30 for page two, to make the total correct.  Ah, but suppose you didn't catch your mistake, and got an erroneous total of, say, 247.  That will make the "Average so far" column wrong.  If you are going to enter the numbers in a spreadsheet anyway, it may not be worth your time worrying about that.  But, if you insist, you can correct the average by making a test total negative by the erroneous amount.  This returns the average-so-far column back to where it was before the mistake.

 

To download the program, click on the links below with your secondary mouse button (i.e., right-click) and select Save Target (or Link) As … from the menu. 

ADD.EXE     The main program

ADD.ICO     An icon associated with the program

ADD.TXT     Directions for use (not essential)

Put the icon file, ADD.ICO, in the same directory as ADD.EXE.  To add ADD to your start menu, drag ADD.EXE to the Start button, then to Programs and drop it where you like.  Click on the name with your secondary mouse button and select Rename from the pop-up menu to give it a meaningful name, such as "Test Page Adder".  Also from the pop-up menu, select Properties.  On the Program tab, put a check in the "Close on Exit" box.  (Also on the Program tab, you can change the Run:  entry to “Maximized”, which will run the program in full-screen mode.)

 

Excel Add-in

To download the Excel add-in, click on the link below with your secondary mouse button (i.e., right-click) and select “Save Target As …” from the menu.

Excel Chemical Formatter

 

For the PC, the Excel add-in should be saved in the AddIns directory.  The default path to this folder is C:\Windows\Application Data\Microsoft\AddIns, or, if the system is using user profiles, C:\Windows\Profiles\UserName\Application Data\Microsoft\AddIns.  Once the file is in the correct directory, go to the Add-Ins… dialog box (on the Tools menu).  Put a check mark next to the entry “Chemical Format” and you are done.  You can tell that the installation succeeded by the appearance of the  button on your toolbar.

The Excel chemical formatter is based on a macro provided by Dr. E. J. Billo, of the chemistry department at Boston College in Chestnut Hill, MA.  He has a book, Excel for Chemists, 2nd ed, coming out in February, 2001.

Page last updated:  January 15, 2001