College Info Retrieval Project

IN PROGRESS
Bids
11
Avg Bid (USD)
$95
Project Budget (USD)
$30 - $250

Project Description:
This job involves performing queries to a database and copying/pasting the results into an Excel spreadsheet. There are 2900 colleges in the database but one query can yield more than one college in the results page, thus making the amount of queries a smaller amount.

1. Go to database at this link: http://apps.collegeboard.com/cbsearch_clep/searchCLEPColleges.jsp
2. Choose a state from the dropdown menu*
3. Choose a city from the dropdown menu**
4. Click Submit

This action will take you to a results page. On the results page,

1. Retrieve the following for every college listed for that city:
code
college name
city
state abbreviation

2. Copy/paste this information into attached Excel spreadsheet according to the following categories

code
college
city
state

3. Go back to results page and click "New Search"
4. Continue with entry for the next city in that state
5. Repeat process
6. When all cities for one state are completed, continue with next state and repeat above process
7. When all colleges have been copied/pasted into Excel spreadsheet, send to us

*When choosing a state, do so in the order the states appear, beginning with the first state, Alabama, and ending with the last state, Wyoming, having performed the query for every state on the list
**When choosing a city, do so in the order the cities appear, beginning with the first city in the list and ending with the last city, having performed the query for every city on the list

Skills required:
Excel
Additional Files: College+Info.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.