Web Data Extraction

[mcove]

AA Team.

I have a web data extraction task to automate, it is the following:

1) First this URL needs to be opened Over 140,000 Public, Private, Charter, Magnet Schools, and School Districts - School Tree

2) Next I click on the High tab on the top navigation bar above the U.S. image to pull up only high schools.

3) Then I click the name of every state to pull up the state's county table.

4) Next I click on the name of each county to get the county's school list.

5) Now I click on the name of each school to get the school's information

6) I need to extract the data from all the fields of the first table (Contact and Location Information), the second table's fields of school district, county, and NCES Assigned School ID (Classification Information), and the third table's fields enrollment for school and number of teachers (Classroom Size Information).

7) I need to input that data into an Excel file

I understand logically what needs done I'm just having a hard time with this. Please help me in automating this task. I am using AA version 5

Thank you in advance,
Jason

[mcove]

xls spreadsheet goes on the desktop

[Mihir Shukla]

Hello,

We will take a look at the details you provided and get back to you.