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: [login to view URL]
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
I am very advanced in excel and after reading the project description I know that i will easily be able to complete it in 2 days. Please contact me as soon as possible as I am able to start immedietly, Thank You!