TEST: Meeting Data Audit

[Rabia2219]

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

• access to the 1Password vault for Google Drive Migration
• know your GitHub username and password so that you can use it in the (Google Drive Migration) hfla-email-all@hackforla.org Chrome profile

Action Items

Access GitHub through (Google Drive Migration) hfla-email-all@hackforla.org

• [x] Log into the hfla-email-all@hackforla.org email and open it in a new chrome profile, so that you can access the account's calendar
• [x] log into your GitHub account in the hfla-email-all@hackforla.org profile
• [x] open this issue and continue

For each of the following items, there are instructions in the wiki. Copy the instruction for next item to be checked off (must do them in order), to a comment below and then complete the item, and hide the comment.

Prep

• [x] Create Meeting Data Audit and Reconciliation Spreadsheet
• [x] Create Slack Audit document
• [x] Create Recommendations & Next Steps document
• [x] After the first 3 Prep items have been checked off,
  • [x] remove the following labels:
    • [x] prep
    • [x] status: needs audit spreadsheet
    • [x] status: needs Slack audit document
    • [x] status: needs post audit recommendations document
  • [x] add the following label:
    • [x] audit

Audit

• [x] Perform Calendar Event Audit
• [x] Perform hackforla.org/VRMS Audit
• [x] Gather & document data from channels
• [x] After the first 3 Audit items have been checked off,
  • [x] remove the following labels:
    • [x] audit
    • [x] status: needs calendar event audit
    • [x] status: needs hackforla.org/VRMS audit
    • [x] status: needs Slack audit
  • [x] add the following label:
    • [x] admin prep
  • [x] move issue to Prioritized Backlog on the project board
  • [x] unassign yourself

Admin Prep

• [x] Import project's data from Zoom Setup (schedule) sheet into Resource 3.0

Reconciliation

• [x] Reconcile the new sheet with the Zoom Meeting Audit
• [x] Reconcile the new sheet with the Calendar Event Audit Tab
• [x] Reconcile the new sheet with the Slack Audit
• [x] After the first 3 Reconciliation items have been checked off,
  • [x] remove the following labels:
    • [x] reconciliation
    • [x] status: needs Zoom reconciliation
    • [x] status: needs calendar event reconciliation
    • [x] status: needs Slack reconciliation
  • [x] add the following label:
    • [x] recommendations

Recommendations and next steps

• [x] Customize and add recommendations to resource 5.0
• [x] Review team feedback and respond

Resources/Instructions

1.0 Zoom Setup Spreadsheet 2.0 All Zoom Accounts Meeting Audit Spreadsheet 3.0 TEST/AtD: Meeting Data Audit and Reconciliation Spreadsheet 4.0 TEST/AtD: Slack Audit Document 5.0 TEST/AtD: Post Audit Recommendations

[Rabia2219]

Create Meeting Data Audit and Reconciliation Spreadsheet

• [x] go to Template for Meeting Audit
• [x] Select USE TEMPLATE button
  • [x] add a link to the new document at resource 3.0
    • [x] rename file by replacing [Project Name] with the project name you are performing the audit for
    • [x] move file to project drive
      • [x] choose move icon or file menu item, Move in the [Project Name] Meeting Audit' document
      • [x] use back arrow (top left)
      • [x] choose Shared Drives
      • [x] open project drive
      • [x] open folder inside project drive (with same name as project drive)
      • [x] choose Move here
      • [x] choose Move
• [x] remove status: needs audit spreadsheet label
• [x] add status: ready for calendar event audit label
• [x] check the box for Create Meeting Data Audit and Reconciliation Spreadsheet in the Action items of this issue
• [x] Close the tabs you just opened (wiki and spreadsheet)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Perform Calendar Event Audit

• [x] open the calendar for hfla-email-all@hackforla.org in the account profile window
• [x] access the project's calendar by finding the email/name in the right hand panel, under My calendars/Other calendars, and checking the box(es) (make sure no other boxes are checked)
• [x] Open resource 3.0
• [x] for each unique event on the project's calendar, gather and record the following data in the Calendar Event Audit in resource 3.0 :
  • [x] Title of Calendar Event
  • [x] Day
  • [x] Time
  • [x] Time Zone
  • [x] Repeats
  • [x] Zoom Account
  • [x] Has the full zoom invite pasted into the body
  • [x] Has link to GitHub Issue with Agenda
  • [x] Modify Event checked
  • [x] Invite Others checked
  • [x] See Guest List checked
• [x] add any notes in the Notes
• [x] remove 'status: ready for calendar event audit' label
• [x] add 'status: ready for hackforla.org/VRMS audit' label
• [x] check the box for Perform Calendar Event Audit in the Action items of this issue
  • [x] Close the tabs you just opened (wiki, spreadsheet, calendar)
  • [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Perform hackforla.org/VRMS Audit

• [x] open resource 3.0
• [x] access https://www.hackforla.org/projects
• [x] locate your project card and access the project's page
• [x] on the Details sheet in resource 3.0, change [Replace Project Name] to the project name as it appears on the site
• [x] repeat the above for the hackforla.org/VRMS sheet
• [x] add any meeting data to the hackforla.org/VRMS sheet
• [x] check the 'No events' box if there's no meeting data
• [x] add date to 'Date Last Audited'
• [x] remove status: ready for hackforla.org/VRMS audit label
• [x] add status: needs Slack audit document label
• [x] check the box for Perform hackforla.org/VRMS Audit in the Action items of this issue
• [x] Close the tabs you just opened (wiki, spreadsheet, website)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Create Slack Reminder Audit document

• [x] go to Slack Audit Template
• [x] Select USE TEMPLATE button
  • [x] add a link to the new document at resource 4.0
    • [x] rename file by replacing [Project Name] with the name of the project you are performing the audit for
    • [x] move file to project drive
      • [x] choose move icon or file menu item, Move in the document
      • [x] use back arrow (top left)
      • [x] choose Shared Drives
      • [x] open project drive
      • [x] open folder inside project drive (with same name as project drive)
      • [x] choose Move here
      • [x] choose Move
• [x] replace [Project Name] and (Initials) with the project's name and initials
• [x] customize the footer data for the project/audit
• [x] open resource 3.0
• [x] add link to the Slack Audit document on the Details sheet
• [x] remove status: needs Slack audit document label
• [x] add status: ready for Slack channel list label
• [x] check the box for Create Slack Audit document in the Action items of this issue
• [x] Close the tabs you just opened (wiki, document and spreadsheet)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Find & document all relevant Slack channels

• [x] open resource 4.0
• [x] in a new tab, access Hack for LA's Slack workspace through https://hackforla.slack.com/ (you may have to sign in)
• [x] view side by side
• [x] search for the project channels in the Slack search bar
  • use full name or initials
  • there may be multiple channels for a project, e.g. access-the-data, access-the-data-lead, so scroll down in the search results to make sure you get all the channels
• [x] Setup resource 4.0
  • [x] copy and paste the block of headings on a new page for each channel
  • [x] replace [channelname] for each block with the channel name you found on Slack
• [x] remove status: ready for Slack channel list label
• [x] add status: ready for Slack audit label
• [x] check the box for Find & document all relevant Slack channels in the Action items of this issue
• [x] Close the tabs you just opened (wiki, document, Slack)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Gather and document data from channels

• [x] open resource 4.0
• [x] in a new tab, access Hack for LA's Slack workspace through https://hackforla.slack.com/ (you may have to sign in)
• [x] Collect the following data for one channel then repeat for the next channel(s)
  • if you are not a member of the channel, you can join temporarily to collect the data and then leave
  • [x] Reminders
    • [x] click on the channel name
    • [x] type /remind list in a comment and hit enter
    • [x] copy the resulting text
    • [x] paste it under the Reminders for that channel
  • [x] Pins
    • [x] click on the pin icon in the top left of the channel window
    • [x] copy the messages
    • [x] paste under the Pins for that channel
  • [x] Bookmarks (if there are any bookmarks in the channel, they will appear next to the pinned items)
    • [x] write the name of the document as best as you can under the Bookmarks for that channel
    • [x] right click on the bookmark, copy link and link it to the document name you just wrote
  • [x] Topic
    • [x] select the down arrow next to the Slack channel name
    • [x] look for the section named Topic in the window that pops up
    • [x] copy the text
    • [x] paste under the Topics for that channel
• [x] remove 'status: ready for Slack audit' label
• [x] add 'status: needs Zoom Setup data' label
• [x] check the box for Gather & document data from channels in the Action items of this issue
• [x] Close the tabs you just opened (wiki, document, Slack)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Import project's data from Zoom Setup (schedule) sheet into Resource 3.0

• [x] open resource 1.0 in a new tab
• [x] create a filter for your project
  • [x] go to the Schedule tab in the Zoom Setup (resource 1.0)
  • [x] select the green down arrow next to Project Name in column A
  • [x] under 'Filter by values', select 'Clear'
  • [x] search for your project name in the search bar
  • [x] select your project name so that a 'tick' appears next to it
  • [x] select OK
• [x] copy sheet into resource 3.0
  • [x] right click on the Schedule sheet tab at the bottom
  • [x] select Copy to
  • [x] then select Existing spreadsheet
  • [x] in the window that opens up, type the name of resource 3.0 and press enter
  • [x] click on the file in the results
  • [x] select Insert
  • [x] then select Open spreadsheet in the pop up message
• [x] remove irrelevant (other projects') data
  • [x] rename the Copy of Schedule sheet to Audit
  • [x] select the green funnel next to Project name in column A
  • [x] under 'Filter by values', select 'Select All'
  • [x] unselect your project name so that the 'tick' next to it disappears
  • [x] select Ok
  • [x] select the data starting from A2 all the way to the end
  • [x] right click and select Delete selected rows
  • [x] select the green funnel next to Project name in column A
  • [x] under 'Filter by values', select 'Select All'
  • [x] select OK
  • [x] undo the filter in Zoom Setup (resource 1.0)
  • [x] select the green funnel next to Project name in column A
  • [x] under 'Filter by values', select 'Select All'
  • [x] select OK
• [x] remove status: needs Zoom Setup data label
• [x] add 'status: ready for 1st reconciliation' label
• [x] check the box for Import project's data from Zoom Setup (schedule) sheet into Resource 3.0 in the Action items of this issue
• [x] Close the tabs you just opened (wiki, spreadsheets)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Reconcile the new sheet with the Zoom Meeting Audit

• [x] open resource 2.0 in a new tab
• [x] open resource 3.0 in a new window
• [x] view side by side
• [x] Repeat for each Zoom Account

  • [x] create a filter for your project in resource 2.0
    • [x] go to the All Zooms tab in resource 2.0
    • [x] select the green down arrow next to Team in column F
    • [x] under 'Filter by values', select 'Clear'
    • [x] search for your project name name in the search bar
    • [x] select your project name so that a 'tick' appears next to it
    • [x] select OK
  • [x] create a filter for Zoom# in resource 2.0
    • [x] in the All Zooms tab, select the green down arrow next to Zoom# in column A
    • [x] under 'Filter by values', select 'Clear'
    • [x] select the Zoom account you want to work on first, so that a 'tick' appears next to it
    • [x] select OK
  • [x] create a filter for Zoom Account in resource 3.0
    • [x] go to the Audit tab in resource 3.0
    • [x] select the green down arrow next to Zoom Account in column R
    • [x] under 'Filter by values', select 'Clear'
    • [x] select the same Zoom account you selected in resource 2.0 , so that a 'tick' appears next to it
    • [x] select OK
  • [x] fill in the following corresponding data from resource 2.0 into resource 3.0
    • [x] Name of Meeting
    • [x] Zoom Sheet(this sheet)
    • [x] Zoom Account
    • [x] What the Zoom Meeting Title Currently says
    • [x] Meeting Weekday

• [x] undo all filters
• [x] remove status: ready for 1st reconciliation label
• [x] add status: ready for 2nd reconciliation label
• [x] check the box for Reconcile the new sheet with the Zoom Meeting Audit in the Action items of this issue
• [x] Close the tabs you just opened (wiki, spreadsheets)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Reconcile the sheet with the Calendar Event Audit Tab

• [x] open resource 3.0
  • [x] access the Calendar Event Audit tab
• [x] duplicate in a new tab
  • [x] access the Audit tab in
  • [x] view side by side
  • [x] for each event, fill in the following corresponding data from the Calendar Event Audit tab into the Audit tab
  • [x] Team Calendar
  • [x] What the Team Calendar Meeting Title Currently says
  • [x] remove status: ready for 2nd reconciliation label
  • [x] add status: ready for 3rd reconciliation label
  • [x] check the box for Reconcile the sheet with the Calendar Event Audit Tab in the Action items of this issue
  • [x] Close the tabs you just opened (wiki, spreadsheet)
  • [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Reconcile the new sheet with the Slack Audit

• [x] open resource 3.0 in a new window
• [x] open resource 4.0 in a new window
• [x] view side by side
• [x] for each meeting in the Audit tab in resource 3.0
  • [x] search resource 4.0 for any kind of mention (meeting reminder, agenda bookmark, etc.)
  • [x] update Slack Mention in the Audit tab in resource 3.0
  • [x] update What the Slack Mention Currently Says in the Audit tab in resource 3.0
• [x] remove status: ready for 3rd reconciliation label
• [x] add status: needs post audit recommendations document label
• [x] check the box for Reconcile the new sheet with the Slack Audit in the Action items of this issue
• [x] Close the tabs you just opened (wiki, spreadsheet, document)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Create Recommendations & Next Steps document

• [x] go to Template for Post Audit Recommendations
• [x] Select USE TEMPLATE button
  • [x] add a link to the new document at resource 5.0
    • [x] rename file by replacing [Project Name] with the project name you are performing the audit for
    • [x] move file to project drive
      • [x] choose move icon or file menu item, Move in the [Project Name] Meeting Audit' document
      • [x] use back arrow (top left)
      • [x] choose Shared Drives
      • [x] open project drive
      • [x] open folder inside project drive (with same name as project drive)
      • [x] choose Move here
      • [x] choose Move
• [x] remove status: needs post audit recommendations document label
• [x] add status: ready for recommendations label
• [x] check the box for Create Recommendations & Next Steps document in the Action items of this issue
• [x] Close the tabs you just opened (wiki and document)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Customize and add recommendations to resource 5.0

• [x] open resource 5.0
• [x] open resource 3.0 in a new tab
• [x] view side by side
• [x] Change {Replace PROJECT NAME] to project's name throughout resource 5.0
• [x] access the Audit tab in resource 3.0
• [x] for each meeting
  • [x] copy the meeting title from column G (What the Zoom Meeting Title Currently says)
  • [x] change [Replace MEETING NAME] to the meeting title you copied
• [x] review resource 3.0 for discrepancies
• [x] check the discrepancies NOT found in resource 5.0
• [x] compile the Slack message to be sent to team lead(s)
  • [x] choose one of the sample messages to customize (create a new one if none fit)
  • [x] delete the sample messages that do not apply
  • [x] change [Replace PM HANDLE] to team lead's Slack handle (add more than one if required)
  • [x] add your findings and recommendations
  • [x] add links to resources 3.0 and 4.0 where required
• [x] remove status: ready for recommendations label
• [x] add status: ready for team label
• [x] check the box for Customize and add recommendations to resource 5.0 in the Action items of this issue
• [x] Close the tabs you just opened (wiki, document and spreadsheet)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Reach out to team lead(s) with recommendations via Slack

• [x] open resource 5.0
• [x] copy the compiled Slack message
• [x] access the appropriate project channel on Slack
• [x] paste the copied message and send
• [x] remove status: ready for team label
• [x] add status: waiting on team feedback label
• [x] check the box for Reach out to team lead(s) with recommendations via Slack in the Action items of this issue
• [x] Close the tabs you just opened (wiki and document)
• [x] Hide this comment as RESOLVED, you are finished with this step

[Rabia2219]

Review team feedback and respond (WIP)

• [ ] cross check all actions taken as reported by the team (which may include some or all of the following)
  • [ ] updated Zoom Setup spreadsheet
  • [ ] updated Zoom account(s)
  • [ ] opened VRMS ticket for updates
  • [ ] updated Slack mentions
• [ ] if all information is accurate
  • [ ] remove status: waiting on team feedback label
  • [ ] add status: no further action needed label
  • [ ] check the box for Review team feedback and respond in the Action items of this issue
  • [ ] Close the tabs you may have opened (wiki, spreadsheet, Zoom accounts, Slack, VRMS repo)
  • [ ] unassign yourself
  • [ ] close this issue
• [ ] if there are still discrepancies
  • [ ] reach out via Slack again

[Rabia2219]

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

• access to the 1Password vault for Google Drive Migration

  Action Items

• [x] Log into the hfla-email-all@hackforla.org email and open it in a new chrome profile, so that you can access the account's calendar

For each of the following items, there are instructions in the wiki. Copy the instruction for next item to be checked off (must do them in order), to a comment below and then complete the item, and hide the comment.

Meeting Data Audit

• [x] Create Meeting Data Audit and Reconciliation Spreadsheet
• [x] Perform Calendar Event Audit
• [x] Perform hackforla.org/VRMS Audit

Slack Audit

• [x] Create Slack Reminder Audit document
• [x] Find & document all relevant Slack channels
• [x] Gather & document data from channels

Reconciliation

• [x] Import project's data from Zoom Setup (schedule) sheet into Resource 3.0
• [x] Reconcile the new sheet with the Zoom Meeting Audit
• [x] Reconcile the new sheet with the Calendar Event Audit Tab
• [x] Reconcile the new sheet with the Slack Audit

Recommendations and next steps

• [x] Create Recommendations & Next Steps document
• [x] Customize and add recommendations to resource 5.0
• [x] Reach out to team lead(s) with recommendations via Slack
• [ ] Review team feedback and respond WIP

Resources/Instructions 1.0 Zoom Setup Spreadsheet 2.0 Zoom Meeting Audit Spreadsheet 3.0 TEST/AtD: Meeting Data Audit and Reconciliation Spreadsheet 4.0 TEST/AtD: Slack Audit Document 5.0 TEST/AtD: Post Audit Recommendations

[Rabia2219]

Test done, improvements to be made recorded