“The most sustainable way to build the foundations of lifelong learning among children and young people of today is by reigniting intrinsic motivation at all levels of an education system” – STiR Education.
STiR Education is an international NGO that supports governments to employ practical strategies that promote positive behaviors in teachers and officials. And in turn, these build the foundations of lifelong learning in children. Starting in 2012 with 25 teachers in Delhi, STiR Education over the past eight years has reached 200,000 teachers and six million children in 69 Districts across India and Uganda.
With the Global pandemic due to Covid 19, NGOs working in the education sector were deeply impacted due to restrictions and novel challenges associated with the pandemic.
Thus many NGOs adopted technology solutions to carry out their day-to-day operations and promote effective learning through digitized programs. Similarly, STiR Education adapted Glific – a two-way communication platform to digitize their program to help governments in training teachers and officials.
With Glific, STiR Education targets to run its program in 3 states namely, Delhi, Tamil Nadu, and Karnataka. The program will be focusing on mentoring and coaching in a hierarchical manner on the content of the Learning Improvement Cycle (LIC), discussing the behavioral aspects of the meeting conducted and progress checks.
Overview of the hierarchy followed in their program
For the past few months, we have been working on setting up their program by designing, creating, and customizing flows. And through beta testing along with a few pilot teachers, we have finalized the flows and have been working on the next stage of the program i.e reporting.
For reporting, we decided to use a combination of BigQuery which is used in Glific for data warehousing for an organization, and DataStudio because of its seamless integration with BigQuery.
As the reports need to be sent on a monthly basis and each report vary depending on the teacher’s/official’s role and district we came up with the below plan
Identifying and creating data points within flows: For data points, we used a combination of four things in Glific, namely Flow Results, Flow labels, Custom Webhooks, and Contact Fields.
With flows in place, we updated flows with data points that can be captured as teacher/official traverse through flow as part of their meeting or feedback.
Filtering data specific to teacher/official
For generating custom reports we first needed to filter data based on teacher attributes like teacher role, district, priority chosen to work on, and various other criteria, After researching for a suitable tool we decided to use the parameterized query in DataStudio, which will take their phone number as a parameter, pass it in the URL for the report and run query with passed parameters in URL in a BigQuery instance to fetch data.
Thus a query to fetch data from the survey flow mentioned above and calculate average response weightage across teachers of the same district in BigQuery would look like
Generating custom reports: Thus with a custom query, data specific to a teacher/official is filtered that can then be converted into visually appealing graphs using DataStudio.
Two main advantages of using parameterized query with DataStudio that suited our needs were:
Sending reports on a monthly basis: The schedule for sending the monthly report consists of four parts:
For sending these periodical reports and reminders, we used Glific Triggers that allow sending recurring messages at a scheduled time to a collection of teachers/officials.
Triggers were used in two parts:
That was a short journey of how we leveraged DataStudio and BigQuery to send monthly reports from Glific to teachers/officials enrolled in their STiR program.
Now teachers/officials can work on their priorities over a month and fill surveys through WhatsApp on their phone and the reports are generated and delivered at the start of next month with all the metrics to help them evaluate the trends of the program.