How to put Webtron scores onto an 
e3-Gradebook using Excel 97

The Roman numeral steps list each thing you have to do.  Indented lists following them describe how to do it.  Capitalized words specify commands from the top menus.

I. As you set up Webtron, select "Just final section and # correct" in the "Output:" box.

II. Run Webtron

III. Save the results (FILE, SAVE AS) as a text file, such as "c:\demo.txt"

IV. Open "c:\demo.txt" in Excel as follows:

  1. Start Excel
  2. Click on FILE, OPEN
  3. In "Open Box," insert filename (eg "C:\demo.txt")
  4. Click "Open" button. A text import wizard appears.
  5. In box labeled "Text Import Wizard--Step 1 of 3,"
    1. Choose "Fixed width" data type
    2. Click "Ok"
  6. In box labeled "Text Import Wizard--Step 2 of 3."
    1. Scroll down into the id#-name-scores data
    2. Click on the horizontal scale just before the names and the scores columns (probably at positions 10 and 38)
    3. Click "Finish"
V. Once the Excel sheet opens, remove the heading material above the id#-name-score data.  Remove also the row with the column headings that reads "ID    Name      Score":
  1. Select (highlight) the entire region of this introductory text
  2. EDIT, DELETE
  3. Select "shift cells up"
  4. Click on "Ok"

VI. Reformat student id numbers so they are 8 digits long:

  1. Click on the column header of the id# column (this header is probably labeled "A").  This highlights the entire column
  2. FORMAT, CELLS
  3. In the Category box click on "Number" and then on "Custom"
  4. In the top box on the right, labeled "Type", change 0.00 to 00000000.  To do this, select 0.00 and type in 00000000 (eight zero's)
  5. Click "OK" button
VII. Now deal with un-numbered and non-enrolled students, etc.  Webtron conveniently collects these at the beginning and end of its output.

VIII. Remove any Webtron data at the bottom of the Excel sheet that is labeled with "Warning", if there are any such data.

IX. Sort by student number:

  1. Highlight all three columns by dragging the cursor across the column headings (A, B and C)
  2. DATA, SORT, and then select "Column A" "Ascending" (assuming the id# are in column A)
  3. Click "OK" button


X. Save as a text file (eg. "c:\grades.txt"):

  1. FILE, SAVE AS
  2. Enter Filename (eg "C:\grades.txt")
  3. Select File type as "Text (Tab delimited)(*.txt)"
  4. Click "Save" button


XI. Put the scores on Gradebook:

  1. Log onto e3 at http://e3.uci.edu/ (if you are not listed as the Instructor in charge of this course, before you do this the instructor will have to add you using the "Assistant Editor tool of e3.)
  2. Select "GradeBook" in the box labeled "Course Tools".
  3. Follow instructions that are available by pressing "tools info" button.  Here are a few notes related to your data file:
    1. You get into GradeBook from the e3 page by selecting GradeBook and pressing the "Use Tool" button.
    2. When you press "Create" you get a page with three numbered parts.  Fill in parts 1 and 2.
    3. In part 3, select "your text file only" (as opposed to "The UCI Registrar"). Then in the box labeled "Name of file to upload" enter the text file that you have created--"C:\grades.txt" in this example (you can enter it using the browse feature if you wish).
    4. The box labeled "Scores are in column:" defaults to C, which means the scores are in the third column in your file.
    5. Press "Next" button and continue to follow instructions that you originally got on "tool info."

How to Merge Separate Webtron Scores
for a Whole Course

The trick here is to use only one roster for the entire course.  Use the roster available just before the first exam, and use that same roster for all exams.

With the same roster, Webtron scores from each exam can just be copied into a new column in an Excel sheet, and each student will come out in the same row.

Get your roster from either erosters or from the e3 web.  Keep a safe copy of this roster.

Specifics:  Follow instructions above through the end of Step V.  When you do this with the first exam, the resulting 3 columns (id#, Name, Score) constitute your Excel file for the course.

For each successive exam, follow instructions above through the end of Step V.  .  Paste the resulting 3 columns (id#, Name, Score) into new columns in your Excel file for the course.  Glance down the columns to make sure the id# or names are aligned in the proper rows.

=>The top rows contain scores for students not on the roster.  Make sure that if these have changed since the last scoring that you adjust the height of the column so each student has all scores in one row.

Now delete the new columns with id# and name.

The bottom rows of the Excel sheet will have irregular student cases listed.  You may have to align these manually with the original columns, but do not merge them upwards into the roster or else you will be losing the order of your original roster.