Worksheet: Assessing and Exploring Datasets
1. Dataset Assessment:
Fill in the table below based on your evaluation of the primary and secondary
datasets.
Dataset Primary Data (ABS Data) Secondary Data (Wikipedia)
The relevance of the information
Relevance True event that happened so directly relates.
Might not match to the topic.
Accuracy Extremely Accurate. May not be accurate.
Validity More valid. Less Valid.
Reliability Extremely Reliable. _Not as reliable. _________________________________
2. NSW Public Schools Master Dataset Exploration:
Answer the following questions based on your analysis of the dataset.
o Where in the Sydney area was the first teacher?
Answer: Kensington Public School
o Which NSW school is the newest?
Answer: Melon Bar high school
o In which principal networks are most fully selective schools in NSW?
Answer: Port Jackson, North Sydney, Hornsby
o Which school had the most enrolments last year?
Answer: Riverbank Public School
o Which school is furthest west?
Answer: ________________________________________________________
o Which school has the highest percentage of EAL/D students?
Answer: ________________________________________________________
o What is the average number of students enrolled in NSW schools?
Answer: 2170
o What is the range of ICSEA values across NSW schools?
Answer: 568-1226
o What is the range of student enrolments across all NSW schools?
Answer: 2-2173
o What is the average ICSEA value for all schools with secondary students?
Answer: 2175
o Which Federal electorate contains the most schools?
Answer: ________________________________________________________
3. Useful Data on My School:
o How does my school compare in size to other schools?
Answer: My school is average compared to other schools.
o What data fields do I need to answer these questions?
Answer: The number of Enrolments is the data field needed.
o What data operations do I need to perform?
Answer: Average information.
o What else could we learn by integrating other sources of data?
Answer: Making the data more reliable, and more accurate forms of data.
