search

librecorps / tasks

Internal ticket tracker related to LibreCorps project planning and management.
https://github.com/orgs/librecorps/projects/1?fullscreen=true
2 stars 0 forks source link

Create spreadsheet of all public repositories / resources for all UNICEF IF cohort teams #9

Closed jwflory closed 4 years ago

jwflory commented 5 years ago

Summary

Create a shared spreadsheet with URLs for where each team is maintaining their open source project and portfolio

Background

Each UNICEF Innovation Fund (IF) cohort uses different git forges or project-hosting tools for their projects. There is not a single resource to look at to find where each team is doing their open source development.

Our task is to help the UNICEF IF managers monitor progress of each cohort and help make the open source efforts of each cohort easier to measure and track. This also helps us because it gives us a resource to use when we want to check in on a project or if a cohort asks us for help (i.e. we can find out where their open source activity is).

Details

This will be an iterative process and may take a month to make it a comprehensive resource. I suggest this approach:

  1. Create Google Form survey with questions for each cohort that ask:
    • List all public repositories
    • Explain the role of each repository in their project (i.e. front-end? back-end? blockchain component? plug-in for another FOSS project?)
  2. Send out to each cohort + UNICEF IF managers
  3. Follow up with specific teams to fill the form where necessary

Outcome

Migrated from FOSSRIT/tasks#92.

Nolski commented 5 years ago

UNICEF maintains one. You can find a copy of it here: https://drive.google.com/open?id=1DByeQjLOfL3zbi0fX3JKc9plAhGu1pIrJV3HgpR3gRk

jwflory commented 5 years ago

@Nolski The spreadsheet provided by UNICEF is a diagnostic matrix, but it does not indicate a clear status for each team (not without digging into the details). I believe what @itprofjacobs envisioned was a spreadsheet that, at a glance, communicates overall rubric completion status for each cohort (preferably with color). This creates a feedback loop to UNICEF on how each cohort is doing on the principles we established as essential.

So, I think we can do better: sort of a summary of our wiki pages in spreadsheet form. What do you think? It is tedious but yields a positive net impact on our UNICEF contract. It gives a short-term operational benefit to Innovation Fund staff for measuring cohort progress on open source criteria. We can maintain the spreadsheet for the duration of our contract time working with each cohort.

Nolski commented 5 years ago

For sure! Let's keep this open then and maybe we can use some of the content in that UNICEF matrix if it proves useful.

jwflory commented 5 years ago

It actually looks like @whenbellstoll already worked on some of this, but it could be updated:

Maybe closing this issue actually means updating the second spreadsheet based on current data / statuses. A handy way to better automate the individual rubrics to the high-level rubrics might be to "link" some cells together, so changing them in one spreadsheet also changes them in another. I've done this before, but I forget how to do it…

We could have an Excel spreadsheet design conversation if it is warranted. :stuck_out_tongue_closed_eyes: I would like a time box on this task from @itprofjacobs.

Nolski commented 4 years ago

Can be found here: https://docs.google.com/spreadsheets/d/1OfRh6lu63ygi6wdyLLT485M4O96JwNCUnPsfCvlQ7_Y/edit?usp=sharing