Extract Data from the Arizona State Directory

Hello, I need someone to extract information from the Arizona State University directory, and send me the results in a spreadsheet. To understand the requirements more: 1) Go to the directory here: [login to view URL] 2) Search in the last name field for "rajan" 3) Notice there are 9 records. But there are only 2 records where (Dept/College is not blank) AND (phone is not blank). I only want the records where (Dept/College is not blank) AND (phone is not blank) 4) Click on the first result [Rajan, Subramaniam] 5) Notice the following fields: Dept/College: Sch Sustain Engr & Built Envrn First Name: Subramaniam Last Name: Rajan Title: Professor Phone: xx Email: xx Those are the fields I need in the output. Please see the attached sheet for the output format. Please deliver the final output in exactly this format. To show that you understand the requirements, please answer the following questions: 1) Search the last name field for dres. How many records are there? 2) Of those records, how many records exist where (Dept/College is not blank) AND (phone is not blank) 3) Click on the first record where (Dept/College is not blank) AND (phone is not blank). What is the value for TITLE? 4) When you search for SMITH, you get an error message. How will you solve this problem and ensure that you get all the data? Please provide a bit of detail in your answer so I understand how you will do the job.