How To

How to obtain a class roster for grade-tracking in Excel.

March 00

What

From within FuquaWorld you can obtain a roster for your class in text format that you can import into Excel and use for grade tracking. These notes describe how to obtain such a roster and how to import it into Excel.

Background

In FuquaWorld, you can find display a roster suitable for saving for Excel. Open FuquaWorld and on the “Communicate” page choose the “View Class Listings” link to open the “Class Listing Selector” page. On that page, find the class you’re interested in from the list and choose the “roster for saving” link for that class. The “roster for saving” looks like this when viewed on screen:

The on-screen format is not particularly useful and is intended to be saved for use in Excel. To save the file for import into Excel, start with the “roster for saving” view of your roster on the screen and follow the steps below.

Steps

  1. You have your roster on the screen in the “roster for saving” view. From your browser's FILE menu choose the “Save Frame As...” option.
  2. In the “Save As” dialog that appears, click the drop down arrow to see the options for “Save as type”. Choose “Plain Text” as the file type.
  3. In the “Save As” dialog file name box enter a file name, making sure that the file extension is .txt. Click the Save button to save the file.
  4. Open Excel and in Excel use the File, Open command to open the text file you just saved. Because you're opening a text file and not an Excel-format file Excel automatically invokes its Text Import Wizard to assist with the file opening operation. The Text Import Wizard has multiple steps, each in its own display window.
  5. In Step 1 of Excel's Text Import Wizard choose the “Delimited” file type. Press the Next button to continue to Step 2.
  6. In Step 2 of Excel's Text Import Wizard make sure that the “Delimiters” option is set to tab.
  7. Skip the rest of the Text Import Wizard steps by pressing the Finish button. Excel imports the roster data from the text file and displays it in the worksheet.
  8. Save the file as an Excel-format file. Widen the worksheet columns as necessary so all the roster data displays. You may not need all the fields included in the file; if that’s the case, delete any data columns you don't want.

1