How to map social relations among students
AllEars/ Excel resources by Mr Poon Zi Li, Head of Department I Dept. of Physical Education Bowen Secondary School; adapted by Kahhow (Open Gov Products)
Application in the Singapore Education Context
- Sociograms were used in Bowen Secondary to help determine class camp allocations.
- For ACSI, independently administered applications of sociograms helped to determine assignment of class committee roles. Questions used are similar to what will be shown: who hangs out with who; who do you hang out with most
- Sociograms were also helpful in a particular school to identify “circles of vulnerability”
- Note from the teachers who administered sociograms: we cannot administer them too early since that wouldn’t yield meaningful results (students need time to mix)
Coverage of today:
- 1 Suggested (academic) readings
- 2 Using LeaderboardX with FormSG and ChatGPT (for data cleaning)
- 3 Using LeaderboardX with All Ears + excel template
1 Suggested (academic) readings
2 Using LeaderboardX with FormSG and ChatGPT (for data cleaning)
This was demo-ed (albeit rather haphazardly) live during Tech Talk for Teachers on 20 Feb 2023.
Data Pipeline:
FormSG → data clean (using ChatGPT) → feed into Leaderboard X
If you go to LeaderBoardX and try to reverse engineer how the data is structured, you will arrive at something like this:
"Person","Endorses"
"Angeline","likes", "Kahhow", "Angelia"
"Hwee Hwee","likes","Adalyn","Angelia", "Huihui"
"Grace","likes", "Angeline", "Huihui", "Hwee Hwee"
"Rich","likes", "Kahhow", "Huihui", "Rimjhiim"
"Hwee Hwee","likes", "Kahhow", "Rich", "Rimjhiim"
"Rimjhiim","likes","Kahhow", "Adalyn", "Hwee Hwee"
"Rich", "likes","Kahhow", "Adalyn", "Hwee Hwee"
So we notice, 2 columns: person, endorses
And the structure is that of: [person] [likes] [up to 3 names]
- Beyond being comma separated values (csv), every word is also wrapped with “”
- This is the data prep that we need to factor
Your choice of Form builder doesn’t really matter but will just use FormSG out of familiarity (all ears, google form, typeform, any form works just recommending FormSG and All Ears in a Singapore-MOE setting):
- While it is a bit if ‘hard-coding’, this gives you a sense of how you can refine the data. With a bit of reflection, a prompt like the following should work:
Add "likes" after the first word. Wrap each word with "" and comma separate the values. Remove , before each line break
Recording of the session held on 19 Feb can be found below:
3 Using LeaderboardX with All Ears + excel template
- Slides for more info on what to look out for if you want to create an all ears form for a level to collect the responses (in the download link)
- How to use the “display condition” in all ears to direct students to questions that will contain dropdown list of their classmates (need to use dropdown list so that the names selected are consistent)
- How to use ranking qn in all ears to prevent them from selecting the same friend 3 times.
- But cannot prevent them from selecting their own name.
- Text generator file:
- Basically just some formulas to string the input into the format required by leaderboardx.
- Copy and paste the date into the yellow cells.
- The name in the sociogram will follow the name in the data by default.. but to make the sociogram less cluttered, it will be good to shorten their names.. Example: Christopher Andrews to Chris instead.
So you can choose to manually shorten the name in the column “Shortname” then all the vlookup formula will settle it in the text file.
- Just copy the columns as indicated in the sheet and paste it to a new txt file.
- Load from leaderboardx
Other efforts by our colleagues and the Ministry to explore use of Sociograms:
- Checkout an insightful blog post by Suhaimi https://sgedtech.blogspot.com/2020/03/sociograms.html which also showcases the same tool, leaderboardX with slightly different setup
- As of 20 Feb 2023, ETD and ESTL folks are developing their own sociogram tool for teachers, starting with user research on SBB: {placeholder link}