We made notes on how to approach this in Stef + Julie coworking doc. Stef will aim to do this in August if not sooner

Notes from discussion w Julie Jun 22

• Goal: work in a kyber branch to mock it up. Give NASA Cohort something by end of August - pdfs in Cohort Folder
• How can we make this automated and easy? For Cohorts, Reflections, Pathways (later maybe add Reflections as a row in CohortRegistry. Hello from Openscapes. NAME completed the Champs program on this date. URL/DOI. Sincerely, Openscapes Team (more of a letter than a certificate
• Look at the kyber source sheet and structure it that way using the data that’s there
• kyber_function(registry, particpants_list) %>%
• Stef mock up a letter, like Dear PARTICIPANT NAME, blah blah $start_date
• https://github.com/Openscapes/kyber/tree/main/inst/agendas
• Vision: kyber output is 40 pdfs named Openscapes-certificate-butland.pdf. Upload these in bulk to the Cohort Google Folder

Last 2023-fred-hutch Cohort Call is Oct 24. Have it ready then

Thank you Stef! Just cc'ed you on a request from a NASA Champion as well :)

Openscapes Champions Program

Certificate of Completion:
Dates: month dd - month dd, yyyy

This certifies completion of the Openscapes Champions Program, open data science mentorship program for science teams. It is a multi-month program that is designed to ignite incremental and sustainable change within research teams and beyond. It helps teams get their own work done, while building skills and community within the realities of scientists’ busy schedules, varying expertise and needs. Learn more at https://openscapes.org/initiatives.

Draft PR WIP: Openscapes/kyber#71
My first parameterized report. No help needed rn. Need to review what we did then take next step of populating certificate from spreadsheet via variables.

Woohoo! Code in this commit Openscapes/kyber@516f33a (#71) creates an html certificate from values in Registry Google Sheet. Next, create multiple certificates, one per participant.

@jules32 I'm ready to ask for your help. I can create one html certificate from OpenscapesChampionsCohortRegistry Sheet and now want to create all certificates for a Cohort. I have a data frame subset of OpenscapesParticipantsMainList with only rows from one Cohort. Wondering how I cycle through to render one certificate for each row/participant.

Commit: Openscapes/kyber@9fd0481 (#71)

This is awesome @stefaniebutland ! Wooo! Excited to review together next week!

For Fred Hutch Cohort we have certificates with surname only. Done not perfect.
Leaving open

coworking with Ileana week of Feb 12 on this

We made certificates for Pathways. Code in new repo (cause it doesn't use kyber): Openscapes/certificates.

Will tag Andy to help with Champions certificates since we still don't get first and last names in the output

@ateucher I'd really appreciate your R help in tweaking our code to make Certificate of Completion for Champions Cohorts. Let's set up a coworking slot once you've settled in. Next use of Certificate will be May 2024

Next, get both 1st and last names in certificates, in time for 2024 NASA Champs. Their Call 5 is May 29.