Data processing and analysis

Activity 1 - Epitome word cloud

A word cloud is a collection or cluster of words depicted in different sizes. The bigger and/or bolder the word appears, the more frequent it appears in a data set.

Student tasks 

1. As a class, enter your epitome word into a word cloud generator such as Mentimeter (Source 20).

2. Identify the most frequent epitome words used to describe the cultural characteristics of Marrickville.

Activity 2 - Using Google sheets to create a class dataset

Teacher task

• Create a copy of the Google Sheets spreadsheet and share with your class.

Student task

• Enter your fieldwork data collected through random sampling and bipolar analysis on the spreadsheet.

Note: There are two tabs in this spreadsheet, one for data collected through random sampling, and another for data collected through bipolar analysis.

Activity 3 - Using Google MyMaps to spatially represent data

Your complete class dataset spreadsheet can be used to create a Google MyMap. This will allow you to spatially represent the data collected from all survey sites.

Student task

View the screen recorded video (Source 21) and follow the instructions to create a Google MyMap using the data collected from your class.

Activity 5 - Using statistics to present quantitative data

Student tasks

1. Identify all quantitative variables in your dataset - i.e. building height (streetscape) and sound levels (noise).

2. Use your class dataset to calculate the range and mean for each variable.

3. Interpret your results and describe any trends or patterns. Outline how this evidence can be used to describe the characteristics and/or influences of culture in Marrickville.

Activity 6 - Using statistics to present bipolar data

By using a numerical score, we can use statistics to analyse bipolar data.

Student tasks

1. Select one variable from each cultural characteristic from the bipolar analysis.

2. Use your class dataset to determine the maximum and minimum score for each variable.

3. Calculate the net score (total) for each variable.

4. Interpret your results. Outline how this evidence can be used to describe the characteristics and/or influences of culture in Marrickville.

Activity 7 - Thematic analysis of qualitative data

Questionnaire and interview responses can be thematically analysed to classify and identify recurring perceptions of culture and cultural change in Marrickville.

Student tasks

1. Transcribe your interview responses.

2. Collate transcriptions among your class and select a sample of three to analyse. Select interviews from different demographic groups to better represent the diverse community of Marrickville.

3. Follow the instructions in the video (Source 26) to thematically analyse the transcriptions.