Review & Pilot PVA videos

[shapaklyak]

You may see recorded videos posted on learn.pepfar.net

[KatieOC]

• volunteers needed to review (Katie, Michelle, Kashmira) - by Thursday morning

[shapaklyak]

did anyone get a chance to review videos? @kkale25 @MicSherlock @KatieOC ?

[MicSherlock]

No sorry, we are still in fire drill to get Q1 tools out… Michelle Williams-Sherlock, MPH Epidemiologist HCTB/DGHT/CDC From: Katya Noykhovich [mailto:notifications@github.com] Sent: Thursday, February 28, 2019 12:25 PM To: ICPI/DIV <DIV@noreply.github.com> Cc: Williams Sherlock, Michelle (CDC/DDPHSIS/CGH/DGHT) <myy6@cdc.gov>; Mention <mention@noreply.github.com> Subject: Re: [ICPI/DIV] Review PVA videos in DIV meeting (#117) did anyone get a chance to review videos? @kkale25<https://github.com/kkale25> @MicSherlock<https://github.com/MicSherlock> @KatieOC<https://github.com/KatieOC> ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#117 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AhDs6SYpDOJhGPQo8sjHioZ0fkyDf67rks5vSBD4gaJpZM4ajuND>.

[kkale25]

I haven't either. Was planning on doing this later today during a quieter onboarding session.

…

________________________________ From: Michelle Williams-Sherlock <notifications@github.com> Sent: Thursday, February 28, 2019 12:45:44 PM To: ICPI/DIV Cc: Kale, Kashmira (CDC/DDPHSIS/CGH/DGHT); Mention Subject: Re: [ICPI/DIV] Review PVA videos in DIV meeting (#117) No sorry, we are still in fire drill to get Q1 tools out… Michelle Williams-Sherlock, MPH Epidemiologist HCTB/DGHT/CDC From: Katya Noykhovich [mailto:notifications@github.com] Sent: Thursday, February 28, 2019 12:25 PM To: ICPI/DIV <DIV@noreply.github.com> Cc: Williams Sherlock, Michelle (CDC/DDPHSIS/CGH/DGHT) <myy6@cdc.gov>; Mention <mention@noreply.github.com> Subject: Re: [ICPI/DIV] Review PVA videos in DIV meeting (#117) did anyone get a chance to review videos? @kkale25<https://github.com/kkale25> @MicSherlock<https://github.com/MicSherlock> @KatieOC<https://github.com/KatieOC> ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#117 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AhDs6SYpDOJhGPQo8sjHioZ0fkyDf67rks5vSBD4gaJpZM4ajuND>. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#117 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiwokwV2wlqVM9qKJyRkYpRii7iHb2yhks5vSBXIgaJpZM4ajuND>.

[shapaklyak]

ok no problem, please see ticket #112 to see which videos have been uploaded to review.
Thanks!

[shapaklyak]

all videos have been uploaded to learn.pepfar.net. please login, watch and comment on this issue w/any feedback by April 15. thanks!

@KatieOC @kkale25 @MicSherlock @ICPI/div

[KatieOC]

My review:

Overall, great resource. There are some voices that are better suited for recordings over others. During excel demonstrations, the speakers move too fast. It was challenging for my pilot pupils to do the actions along with the presenter. I had to keep pausing the video. Instead of re-recording, maybe there is a feature to add additional pauses between steps.

1. Your mission, should you choose to accept - no comment
2. What is a pivot table? - no comment
3. Why and when to use a pivot table? - no comment
4. Data structure (tidy data) - this session felt out of place and may not be necessary. The video series are very practical and this was more theory. I don't think the typical user needing these videos need to understand this concept. Just my opinion though.
5. Accessing and downloading data - i would consider adding the different types of files to download and why you would choose each one. See Aliyah's latest slide deck she provided as a resource for the slide.
6. How to create a pivot table -either here or later, I think there needs to be a section on explaining how to select the right standardized disaggregate or disaggreate. One option is showing them putting standarddisagg in the row next to the indicators so you can see your options. My pilot pupils had no idea why modality/age/sex/result was being used and then why they needed to pick something else when looking at different indicators. Also emphasizing disaggregate OR standardized disaggregate and showing them that it doubles your data if you have both or none selected.
7. Different parts of a pivot table - no comment
8. Structural options - no comment
9. Filtering - no comment
10. Building pivot charts - no comment
11. Including Slicers - no comment
12. What are calculated indicators and how to create them- this video started and it seemed like we missed a section. Imran's pivot looked different and it had targets in the pivot. He talked as if we did something we didn't. Also, this video was confusing to my audience so i stopped playing it halfway through and just did it with my team without the video.
13. Considerations when building an Excel tool - i thought this was a great addition. i think demoing clearing the old data with new data, checking that the columns match, then deleting the second row, hitting refresh, would be helpful.

excellent!

[shapaklyak]

Thanks @KatieOC for your comments and pilot!

1 - revised copy forthcoming to remove references discussed at DIV meeting @imujawar
4 - changed this to "theory of tidy data"
5 - added Aliyah's slide deck as an additional resource linked to pepfar.net (since it is not using dummy data) in this section
6- I think this will be updated with the MSD Cheatsheets and subsequent videos can be created afterwards. will leave as is.
12 - removing for now, we can add this to the next iteration of the course
13 - will update with the demo, thanks!