Egra-Presentation-070223-1.pptx RESULTS FORM AND DASHBOARD

ON HOW TO CONDUCT EARLY GRADE READING ASSESSMENT

1. Early Grade Reading Assessment (EGRA) Results Form & Dashboard November 29, 2022 TRAINING ON WASH FACILITY IMPROVEMENT TOOL

2. © UNICEF/PHOTO CREDIT What is the EGRA Results form & dashboard? The EGRA Results form and dashboard are interactive assessment tools to help teachers monitor their students' progress in reading, both pre and post EGRA.

3. TRAINING ON WASH FACILITY IMPROVEMENT TOOL EGRA Results Form

4. TRAINING ON WASH FACILITY IMPROVEMENT TOOL EGRA Results Dashboard

5. © UNICEF/PHOTO CREDIT How do we use the EGRA Results form? The EGRA Results Form uses Open Data Kit (ODK) stored in UNICEF’s secure data platform called InForm .

6. Open Data Kit Collect (ODK) Online and offline access Real-time submission of report/forms Seamless consolidation of data Real-time online Dashboard (quick analysis)

7. TRAINING ON WASH FACILITY IMPROVEMENT TOOL InForm data collection method . Open Data Kit Collect Webform

8. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 1: Install and set up ODK Collect on your Android device.

9. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 1: Install and set up ODK Collect on your Android device. On your Android device, open Play Store. Search ODK Collect . Once installation is complete, open ODK Collect . 1 2 3

10. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 1: Install and set up ODK Collect on your Android device. If it’s your first time to open the app, you’ll be asked how you want to collect data. Click Manually Enter Project Details .

11. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 1: Install and set up ODK Collect on your Android device. On the Add project screen, in the URL box enter UN: [email protected] PW: 0ef51e9777fed1 URL: https://data.inform.unicef.org Enter your account credentials: Username and Password .

12. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 2: Download the EGRA form on your ODK Collect app

13. TRAINING ON WASH FACILITY IMPROVEMENT TOOL In ODK Collect’s main screen, select Get Blank Form . Check the EGRA RESULTS form, then click Get Selected . 1 2 Task 2: Download the EGRA form on your ODK Collect app

14. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click OK to confirm the download. 3 Task 2: Download the EGRA form on your ODK Collect app

15. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 3: Use the EGRA form

16. TRAINING ON WASH FACILITY IMPROVEMENT TOOL In ODK Collect’s main screen, click Fill Blank Form . Select the EGRA RESULTS Questionnaire. 2 1 Task 3: Use the EGRA form

17. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Start filling up the form. You can click the Save icon to save your changes while you’re completing the form. Click Save form and exit . Note This way, when you need to close the form, your changes will be saved and you can click Edit Saved Form to go back to the form you have saved or have yet to finish. Name this form using the [school name name or initials_ [City/Municipality]_[date] Example: ATMES_Lipa _ 23Nov2022 Task 3: Use the EGRA form

18. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 4: Submit the EGRA form

19. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Make sure you are connected to the internet. Open ODK app, then select Send Finalized Form on main menu. Task 4: Submit the EGRA form

20. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Select the form you have saved by clicking the box next to it. Click Send Selected . Note You’ll receive a prompt (Upload Results [name of form] - Successful submission) that the form has been successfully submitted. Task 4: Submit the EGRA form

21. © UNICEF/PHOTO CREDIT Activity Select a partner and take turns to demo how to download, complete, and submit a form. Provide feedback and share your experience to the group.

22. © UNICEF/PHOTO CREDIT Short Break

23. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Webform Offline capable  Print-friendly forms  Low technical requirements 

24. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 1: Log in and set up Webform on your browser.

25. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Go to https://inform.unicef.org/ and click login . Task 1: Log in and set up Webform on your browser.

26. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Select UNICEF and click. Username: [email protected] Password: P@ssword12345 Enter you credentials and click Sign in . Task 1: Log in and set up Webform on your browser.

27. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Select Early Grade Reading Assessment (EGRA) Results in the project page. Task 1: Log in and set up Webform on your browser.

28. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 2: Use the EGRA form

29. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click Webform to see the questionnaire. Task 2: Use the EGRA form

30. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Fill out the form ( https://web.inform.unicef.org/x/kIxM49e1 ) Once done, click Submit . Task 2: Use the EGRA form

31. © UNICEF/PHOTO CREDIT Activity Select a new partner and take turns to demo how to complete and submit a form. Provide feedback and share your experience to the group.

32. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 3: Edit the EGRA form

33. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click EGRA RESULTS to edit the entries in the back-end. Task 3: Edit the EGRA form

34. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click Table on the menu. To view the details click view icon. To edit the entry, click edit icon Task 3: Edit the EGRA form

35. TRAINING ON WASH FACILITY IMPROVEMENT TOOL After editing, click the Submit button. Task 3: Edit the EGRA form

36. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Task 4: Export the data

37. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click EGRA RESULTS and the overview page will appear. Task 4: Export the data

38. TRAINING ON WASH FACILITY IMPROVEMENT TOOL Click Prepare Data Export . Select File Type: Excel and click Export Excel . Task 4: Export the data

39. © UNICEF/PHOTO CREDIT Short Break

40. © UNICEF/PHOTO CREDIT How do we use the EGRA Results Dashboard? The EGRA Results Dashboard uses Power BI to visualize the data collected using the EGRA Results form.

41. Demo

42. Activity Using a sample data, complete at least 10 forms (5 pre-EGRA and 5 post-EGRA) Note: Each participant should select a different school. Check if and how it will successfully be visualized in the EGRA Results dashboard.

43. Q&A

44. How to change the password in the ODK collect Go to Early Grade Reading Assessment(EGRA) Results Project. In the EGRA result form on the upper right corner, select the username icon. 2 1

45. How to change the password in the ODK collect 3. Click Settings. 4. Click ODK key. 3 4

46. How to change the password in the ODK collect 5. Click the Show icon 6. Copy the password: 5

47. How to change the password in the ODK collect 7. After you copy the password from the INFORM website go to your mobile-phone and open the ODK collect app. 8. On the upper part of the ODK app. Select the username icon. 7

48. How to change the password in the ODK collect 8. On the Projects, click Settings. 8 9. On the Project setting, click Server. 9

49. How to change the password in the ODK collect 10. On the Server settings, click the password. 11. Enter the new password. 10