new

Updated training and masterclasses are now available for Review, Promotion & Tenure (RPT), Interfolio Data Service (IDS), and Lifecycle Management (LM).

Learn more

How Can We Help?

Search icon

Search Results

Weight Ratings from an Applicant Report

For some search committees, there are ratings that are more important than others. For instance, Teaching Experience may be twice as important as Scholarly Publications. This article will guide a committee member, with the proper permissions, on how to weight ratings from an applicant report.

 

Weighting evaluations and attaching them to a faculty search should only be performed after all applications have been received and after all ratings have been performed. If any additional ratings occur after performing the weighting of ratings, then this process will need to be repeated for the Search Committee to receive updated information.

 

How to Apply Weights to Ratings

There are many programs available to do this type of modification (Microsoft Excel, Google Sheets, etc). This article uses Microsoft Excel 2013 for Mac.

  1. Download the CSV report with the correct data.
  2. After launching your favorite spreadsheet software, open the CSV file.
    Downloads folder with the right-click menu open on the downloaded CSV file, showing Open With and Microsoft Excel selected.
  3. After your file is open, you will need to create a new column for every criteria you are going to modify. It will likely look similar to the below image. The beige columns have been added, titled Weighted, and formatted for easier identification.
    Spreadsheet of exported ratings showing an applicant's average rating for each criterion next to empty weighted rating columns.

    Before creating calculations, it is important to identify what criteria are going to be weighted and by how much. For instance, there are currently three different criteria in this example:

    1. Community (is our base value, it will not be modified or weighted)

    2. Scholarship (will be worth 1.25 times as much as Community)

    3. Interview (will be worth 0.75 times as much as Community)

     
  4. Next create the weighted column for Community, in the cell enter =E2. This formula causes the originating cell to pull data from cell E2, which is the unweighted Community rating.
    Spreadsheet with a formula entered in a weighted rating cell that references the matching average rating cell.
  5. Copy the calculation downwards using the auto-fill tool to update the entire column. Click-and-Drag the formula down to the final cell in the table.

    The auto-fill tool is the square node that is in the bottom-right of the selected (or active) cell.

     
    Spreadsheet showing the result of the weighted rating formula in the first row, with a numbered callout pointing to the cell.Spreadsheet with the weighted rating cells below the first one selected so the formula can be copied down the column, marked with numbered callout 2.

    After releasing the mouse, the formula will be copied through the selected cells.

     
    Spreadsheet with weighted ratings filled down the column for each applicant, marked with numbered callout 3.
  6. Next, we will modify Scholarship to be worth 1.25x as much as Community
    Note the formula =C2*1.25. C2 is the cell where the data is originating, and 1.25 is the modification to the weight of the value.
  7. Use the Auto-Fill tool to copy the formula downwards, similar to Step 3 in this progression.
    Spreadsheet showing a weighted scholarship rating formula that multiplies the average rating by 1.25, with the results filled down the column.
  8. After you finish weighing and modifying all of your Ratings, make sure you eliminate any extra information that you do not want to be considered.
  9. Save the now Weighted CSV file as a PDF.

In the picture below, note that it is important to perform Scaling when exporting your document. If you have a lot of criteria (columns), you will want to make this more than one page wide and also may want to copy your headers onto every page.

 

Print dialog with scaling set to fit the sheet to one page wide, marked with callout 1, and the PDF menu marked with callout 2.

The file must be uploaded to committee documents in a PDF format.

 
Was this article helpful?
Give feedback about this article