Find Jobs
Hire Freelancers

Data Search and Entry in Excel

$250-750 AUD

In Progress
Posted over 12 years ago

$250-750 AUD

Paid on delivery
I am looking for someone (or a team) who can research and build me an Excel file comprised of all public, Catholic and Independent primary schools (years 1 - 6 or 7 depending on the state) and combined primary/secondary schools (schools which include years 1 - 12) for Australia. According the most recent Austarlian Bureau of Statistics as of 2010 there are approximately 6,357 primary schools and 1,286 combined primary/secondary Schools in Australia. The information I need can be seen in the attached Excel file, however, the absolute minimum information needed is: School Name, Street Address, City/Town, State, Post Code , Government or non-Governement School, Telephone Number and Full time Enrollment. All of the information is readily available through each State's or Territory's Department of Education website which I have included the links for. There are also a couple of additional web sites that carry parts of the information but may come in handy as they are comprhensive sites for all of Australia. Each Education web site handles their records and information differently with some more complete than others. The trick is to figure out the best strategy and methodlology to collect all of the requested data in the most efficient way possible, thus before providing a quote I would investigate these sites and determine how best to utilise them in order to extract the relevant information needed. For schools that have combined primary/secondary enrollments usually only one number is given for the total enrollment, thus this number must be multipled by 7/12 to get the approximate number of primary grade school students. I am only interested in the number of students from years 1 - 7. Department of Education School Locator Links: Western Australia - [login to view URL] Northern Territory - [login to view URL] [login to view URL] Queensland - [login to view URL] NSW - [login to view URL] Victoria - [login to view URL] South Australia - [login to view URL] ACT - [login to view URL] Tasmania - [login to view URL] Australian wide sites: [login to view URL] [login to view URL] (you must register for this site first) There may be some other sites that I have not found that may be useful in addition there are a few sites that sell this information, however, be warned, some of these sites may be scams with poor data such as [login to view URL] and its sister site [login to view URL] This is part one of a two part project. The second part includes utilising the data in a very specific way, hence the address and school enrollment data are absolute must haves for this part. THIS IS A CUT AND PASTE EXERCISE BUT PLEASE DO NOT BID UNTIL YOU HAVE SPENT 20 MINUTES OR SO LOOKING AT THE SITES LISTED IN ORDER TO CALCULATE THE TIME IT WILL TAKE TO COMPLETE THIS PROJECT. I EXPECT YOU TO LIVE UP TO YOUR BID QUOTE AND NOT TELL ME LATER IT WILL TAKE LONGER THAN YOU ORIGINALLY THOUGHT! Good luck.
Project ID: 1218131

About the project

15 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of MALAYSIA
Frankston South, Malaysia
5.0
4
Payment method verified
Member since Sep 9, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.