The assignment is to download data into excel and create a table. Create three sheets in your file. Copy the downloaded data into each sheet (same data). Create the data in each sheet into a table. So you will have three tables with the same data in each table.
I want you to sort the data and exclude some data. Give me three examples that show you know how to do this. So each table will be different. Your grade is based on learning and using advanced sorting techniques.
Tutorial 1
Where to find the data to use in this assignment.
Go to: http://www.netronline.com
Top Menu Select: Public Records Online (Click)
On Map Click: State of Georgia
Counties on Right: Select Fulton
Fulton Assessors: Go To Data Online (Click)
Select: Click here to search property records
Select: Sales Search
Fill out Form (you do not need to fill in all blank fields)
Click bottom button: Start Query
Results should have at least 50 results
Each row represents a property that sold
Each Column represents characteristics
At Bottom of Results Page: Open results in Excel
Tutorial 2
Making tables on excel to organize, rank, and fiter data is a very useful tool. During my summer internship I needed to pull thousands of data sets from an online data base and put them in a format where I could easily see all of the information. Using tables helped present the data in a streamlined way and allowed me to easily graph different values from the table to see relationships between the variables.
ReplyDeleteGreat point Boris.
ReplyDeleteData tables also make it easier for managers and executives to analyze information and make critical business decisions.
What do you mean by sort and exclude data
ReplyDeleteI found trying to find the data, thru Fulton county tax office website bit difficult.
ReplyDeleteI agree with Boris. Everything I did at work was based off of Excel and Charts. In addition, another good tool is the Filter tool.
ReplyDelete