hackforla / hackforla/internship

TWE Partnership/Relationship Dates

Open
#769 2 comments 0 reactions 1 assignee Claimed by @Rabia2219 View on GitHub
complexity: small feature: external communication Participant Type: Partner Participant Type: TWE Team Member ready for prioritization role: Product role: UI/UX research size: 1pt
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

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.