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

• For the academic underpinnings behind creating sociograms

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.