Submit a Ticket

Loading support form...
Skip to content
  • There are no suggestions because the search field is empty.

Clean Your Outcomes Data with AI

Use this guide to quickly standardize your career outcomes / first destination survey data before uploading it to uConnect using an AI prompt.

How It Works

  1. Open your AI tool of preference
  2. Start a new conversation and upload your outcomes data spreadsheet.
  3. Copy and paste the prompt below into the same message.
  4. Review the cleaned file and summary the AI provides, then download it. 

Please note the prompt is using our First Destination Formatting Guidelines to make the fixes to a data set, and these are the guidelines you should also use whether or not you use AI to assist you with the changes. 

Sample Files: Here is an example of an outcomes data file with errors and then the cleaned outcomes data file after running it through the below prompt!

View Incorrect Outcomes Data File (with Errors)

 

View Correct Outcomes Data File

The Prompt

Copy everything in the box below and paste it into the AI tool along with your spreadsheet. Please note that we used Claude to generate this prompt. 

THE PROMPT

I've attached my career outcomes survey data as a spreadsheet. Please clean and standardize it according to the rules below, column by column. When you're done, give me a downloadable file with the same structure, plus a short summary of what changed and any rows you removed.

 

Column A – Graduation Year: Convert to a 4-digit year format (e.g., "12/1/19" becomes "2019"). If a row has no value in this column, remove the entire row.

 

Column B – Program Name/Major: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column C – User Email: Leave as-is, no changes needed.

 

Column D – User ID: Leave as-is, no changes needed.

 

Column E – Academic Division/School: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column F – Degree Level: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column G – Outcome Type: Every value in this column must match exactly one of the following:

- Employed Full Time

- Employed Part Time

- Volunteer Service

- Military Service

- Continuing Education

- Seeking Employment

- Seeking Continuing Education

- Not Seeking

 

Map informal or inconsistent entries to the closest match on this list (for example, "working" becomes "Employed Full Time," and "still looking" becomes "Seeking Employment"). If a row is blank in this column, remove the entire row.

 

Column H – Employing Organization: Standardize spelling, abbreviations, and capitalization. Remove extra spaces. If Column G says "Employed Full Time" but this column is blank, remove the entire row.

 

Column I – Annual Base Salary: Remove dollar signs and decimals so the value is a whole number only (e.g., "$45,000.00" becomes "45000").

 

Column J – Position Location – Country: If Column K (State) has a value but this column is blank, fill in the country.

 

Column K – Position Location – State: Remove any city names, and standardize to the two-letter state abbreviation in uppercase (e.g., "Philadelphia, PA" becomes "PA").

 

Column L – Name of Institution: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column M – Degree to be Earned: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column N – Program/Field of Study: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column O – Experiential Learning Participation: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column P – Employment Industry: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.

 

Column Q – Employment Function: Standardize spelling, abbreviations, and capitalization. Remove extra spaces.



A few additional notes:

  • If you're unsure how to standardize a specific value (for example, an abbreviation that could map to more than one thing), flag it for me in your summary instead of guessing.

  • Please tell me how many rows were removed and why.

  • Keep the original column order and headers in the output file.

Before You Upload to uConnect

  • Double-check the AI's summary of removed rows and standardized values — a quick human review helps catch anything that needs your judgment call.
  • Keep a copy of your original, unedited file in case you need to reference it later.
  • If your spreadsheet's column order is different from the standard layout, update the column letters (A, B, C...) in the prompt to match before you send it.

Questions? Please Submit a Ticket if you need more formatting assistance!