hackforla / hackforla/internship
TWE Partnership/Relationship Dates
- Dominant language
- CSS
- Stars
- 20
- Forks
- 6
- PR merge metrics
- No merged PRs in 30d
Description
### Overview
We need to create a spreadsheet to keep a track of all the various partnership/relationship dates with schools/universities for the Internship program
### Action Items
- [ ] open resource 1.01 and create a spreadsheet titled `TWE: Partnership info` and link to resource 1.02
- [ ] create a tab named "Partnership Contacts"
- Partner Name
- Main Contact Name
- Main Contact Email
- Phone Number
- [ ] create a tab named "Communication Log" and create the following schema in it
- Partner Name
- To Name
- To Email
- From Name
- From Email
- Phone Number
- Correspondence Date
- Summary
- Document or Issue Comment
- [ ] populate the spreadsheet
- search for issues related to the partner and add relevant dates
- search for emails related to the partner and add relevant dates (see resource 1.04)
### Resources/Instructions
- 1.01 [Folder to create spreadsheet](https://drive.google.com/drive/folders/13lBupMRJs266RqNnb-FJjahu4tQJgJcV)
- 1.02 [TWE: Partnership info](https://docs.google.com/spreadsheets/d/1rACGlFhiM0ADSC8lUvXYn_ynKP788M6jzbMKia2Dths/edit)
- 1.03 see https://github.com/hackforla/internship/issues/769#issuecomment-3197972260 for example info for the communication log
#### 1.04 Instructions for Processing Emails into the Communication Log
- [ ] Check if the email is a single communication or part of a thread
- If it is a single message, create a document for that one email
- If it is a back-and-forth thread on the same topic, create one document for the entire thread
- [ ] Create the document in the same folder as the spreadsheet (1.01)
- [ ] Name the document using this format: TWE: [Year] [Partner Name] [Short Topic/Subject]
Example:
`TWE: 2023 Brentwood Internship – Decline to Participate`
- Inside the document:
- [ ] Write a short summary of the communication and format it as Heading 2
- [ ] Add the full text of the email below the summary
- [ ] For threads, use the insert menu to create a bookmark for the message's title
- [ ] Use the insert menu to add a Horizontal line between each message
- Update the Communication Log tab in the spreadsheet (1.02):
- [ ] Fill in all relevant fields (names, emails, phone number if available, date/time, and summary) per communication
- [ ] Paste the link to the created document or bookmark link in the Document column
Contributor guide
Assessment
This issue has not been assessed yet.