I’m looking for a solution for the enumerators on a team that runs an education program with about 50+ communities concurrently. These communities are household clusters with anywhere from 10 to 30 individual caretakers who participate in the education program. The team needs to track the attendance of those individuals within the community. The education program itself has multiple modules and units, and requires about 14 visits in total to complete the program. This should be similar to conducting any normal wide-longitudinal survey.
I believe we will need to create unique “Client IDs” and “Community IDs” to support this data collection. A separate form will be used to generate these IDs (I’m calling it a ‘community contact form’), which we will then use to feed into a separate attendance form.
The attendance form will start with cascading questions to help enumerators select the correct Community ID (district>subdistrict>village>Community ID). The Community ID would then need to populate a matrix question with the list of Client IDs tied to that Community ID. In other words, once the enumerator selects the correct Community ID, it should give them a matrix-style question for each of the Client IDs for that community so they can quickly check an “Attendance” column with “yes” or “no”. This should then be tied to the module/unit that the team taught that day, so they can track attendance over time for the course.
Is this possible? Would we be able to set this up in a way that would allow us to group attendance by community for analysis?
@JaoPao, you should also be able to leverage the dynamic data attachment feature to design your attendance sheet. Here is our support article on the same:
Hi Carrot! Yes, I was able to design a solution from the link that @Kal_Lam shared. Dynamic data attachment is what you want.
However, what we really needed was a case-management system, which is not really suited to KoboToolBox. We ended up using Google AppSheet to accomplish this, and I can recommend that as a low-cost solution.
Will Kal_Lam solution applicable to use from Edit Builder in KOBO? As I am not familiar with XLS settings. The reason I asked to is because I want to link my KOBO data to Power Bi Dashboard too and I am hoping to design something that can be interprete from Power Bi.
Please let me know if you are up for a video call for me to understand more?
I am designing a Power Bi Dashboard from KOBO Responses. I intend to find out how many participants, what type of courses they enrolled, and dates etc.
While the current KOBO Form is designed in a way it is “Post Activity Report”, I cant find a way to incorporate the questions in my current KOBO. Hence i m exploring the alternative.
Hey sorry, I don’t work for Kobo and am just a random user here. Sounds like you might need an API though, as what you are describing is not a free service. You should look at ODK: https://getodk.org/
Can Dynamic Data Management be build from the KOBO Edit Builder?
I m quite new to KOBO Tools, and seeking similar solutions as to what you raise long time ago, which is to properly populate the numbers of trainees, and subjects
Hello Carrotho, It might work if you have a parent project where you record a list of students, and a child project where you record the courses the students attend. Then using an ID you can link the parent project with the child project and generate an attendance list. This child project is the one you can connect to power bi or both.
