hackforla / hackforla/admin-calendaring

Meeting Data Audit: hfla website

Open
#10 29 comments 0 reactions 0 assignees View on GitHub
feature: calendaring P: HfLA Site project todo status: waiting on team feedback
Dominant language
No language data
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

### Overview
We need to audit all calendar events for a given project to match the Zoom Setup and Zoom Audit Spreadsheet so that we can optimize the availability of the Zoom rooms and have the most current meeting information.

### Prerequisite

#### If you are not the PM on the project this issue is for
- access to the 1Password vault for HfLA-email-all
- know your GitHub username and password so that you can use it in the hfla-email-all@hackforla.org Chrome profile

#### If you are the PM on the project this issue is for
- access to the 1Password vault for the project
- access to the project's shared drive through the project's email Chrome profile
- add the project's email as a `Content Manager` if the drive is not already shared with the email
- know your GitHub username and password so that you can use it in the project email's Chrome profile

### Set up
#### Set up Access Through Proper Profile
- Non PMs
- Log into the [hfla-email-all@hackforla.org](mailto:hfla-email-all@hackforla.org) email and open it in a new chrome profile, so that you can access the account's calendar
- open this issue in the hfla-email-all profile browser and follow steps to `Access GitHub`
- PMs
- Log into the project's email and open it in a new chrome profile, so that you can access the account's calendar
- open this issue in the project's profile browser and follow steps to `Access GitHub`

#### Access GitHub
- Log into your GitHub account. If you are already logged in you will see either your icon. If you are not, you will see a sign-in button top right in the issue that is open now in the new profile browser.
- Close any other browsers you have open that are not in the new profile browser, so that you don't end up opening links in the wrong browser (this will be particularly important when you are accessing drives)

#### Add Org Level Audits folder to Starred
If you do not see the project or CoP's drive in the list of shared drives, see `Prerequisite` above

- access the `Org Level Audits` folder in the project or CoP's shared drive, it will be preceded by the project or CoP initials
- a star next to the folder name indicates that it has already been starred and you don't need to do the next step
- right click on the folder and select `Add to starred`

### Notes
There are automation formulas used throughout the meeting data and audit reconciliation sheet to autofill cells and generate messages regarding meetings with nonstandard setup. These formulas are indicated in a light grey color.
- During the `Admin Prep` you will be asked to confirm that there are formulas in the correct cells and columns, which will easily be recognizable by the light grey.
- Please do not edit any cells that are indicated to have formulas

### Troubleshooting
Please make sure you read through all instructions carefully. There are some errors that are expected and should be automatically resolved as you continue with the tasks outlined in each action item. Please review [Errors and How To Resolve Them](https://github.com/hackforla/admin-calendaring/wiki/Errors-and-How-To-Resolve-Them) to get an idea of what to expect.
If, while carrying out any of the tasks, there is still ambiguity or there are errors that are not listed with a solution on the page mentioned above, please [follow these instructions](https://github.com/hackforla/admin-calendaring/wiki/Reach-the-Admin-Team) to contact the Admin team.

### Action Items
There are some action items below that are linked to a wiki page with instructions (they are displayed in blue). Open the link in a new tab, copy the instructions from the wiki page into a comment below and complete the tasks in the comment.

#### Prep
During the first task you will be asked to add a link under Resources/Instructions, and that section is at the bottom of this issue (go view it now).

- [x] [Create Meeting Data Audit and Reconciliation Spreadsheet](https://github.com/hackforla/admin-calendaring/wiki/Create-Meeting-Data-Audit-and-Reconciliation-Spreadsheet) (open in new tab)
- [x] After the first `Prep` item has been checked off,
- [x] remove the `prep` label
- [x] add the `admin prep` label
- [x] move issue to `Prioritized Backlog` on the project board
- [x] unassign yourself
- [x] remove the `Org Level Audits` folder from Starred
- [x] access https://drive.google.com/drive/starred (open in new tab)
- [x] look for the `Org Level Audits` folder that belongs to the project or CoP, it will be preceded by the initials
- [x] right click on the folder and select `Remove from starred`

#### Admin Prep
- [x] [Set up Meeting Data Audit and Reconciliation Spreadsheet for the Audit](https://github.com/hackforla/admin-calendaring/wiki/Set-up-Meeting-Data-Audit-and-Reconciliation-Spreadsheet-for-the-Audit)
- [x] After the first 2 Admin Prep items have been checked off and their labels removed,
- [x] remove the `admin prep` label
- [x] add the `audit` label

#### Audit
- [x] [Perform Calendar Event Audit](https://github.com/hackforla/admin-calendaring/wiki/Perform-Calendar-Event-Audit)
- [x] [Perform Zoom Accounts Audit]( https://github.com/hackforla/admin-calendaring/wiki/Perform-Zoom-Accounts-Audit)
- [x] [Perform hackforla.org/VRMS Audit](https://github.com/hackforla/admin-calendaring/wiki/Perform-hackforla.org-VRMS-Audit)
- [x] After the first 3 Audit items have been checked off and their labels removed,
- [x] remove the `audit` label
- [x] add the `status: needs post audit messaging` label
- [ ] move issue to `Prioritized Backlog` on the project board
- [ ] unassign yourself

#### Recommendations and next steps
- [x] [Create and send message to PMs via Slack](https://github.com/hackforla/admin-calendaring/wiki/Create-and-send-message-to-PMs-via-Slack)
- [ ] [Perform the post-audit next steps to standardize all meeting data](https://github.com/hackforla/admin-calendaring/wiki/Perform-the-post-audit-next-steps-to-standardize-all-meeting-data)
- [ ] [Review team feedback and respond](https://github.com/hackforla/admin-calendaring/wiki/Review-team-feedback-and-respond)

#### Resources/Instructions
1.0 [Draft: HfLA website: Meeting Data Audit and Reconciliation](https://docs.google.com/spreadsheets/d/1kWqdalQx5g5wiNrPdCjqbkrkf7eMGfmjvfq7Wb-pR4g/)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.