# Support workflows

## Staggered flow of projects <a href="#staggered-flow-of-projects" id="staggered-flow-of-projects"></a>

It's very easy to get behind on back-to-back project-based classrooms because of the lead times involved. On an ideal schedule, expect to start planning your next project **5 weeks** after you started planning your prior project, **as soon as you've completed the event planning call** during the [onboarding phase](https://help.sidekick.education/how-to-guides-1/sidekick-project-support/broken-reference).

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-Lzlq3SFOcHZGCmuyB3m%2F-Lzlqm13QsZj4dJvt4CN%2Fstaggered.jpg?alt=media\&token=ae653b11-3b50-49e2-9ddd-3d3896b21e62)

> Edit this gantt chart using the [Mermaid Live Editor](https://mermaid-js.github.io/mermaid-live-editor/#/edit/eyJjb2RlIjoiZ2FudHRcbiAgICB0aXRsZSBQcm9qZWN0cyBhcmUgc3RhZ2dlcmVkXG5cblx0c2VjdGlvbiBGaXJzdCBQcm9qZWN0XG5cdFByb2plY3QgcGxhbm5pbmcgICAgICAgOnAxLCAyMDE5LTAxLTEsIDdkXG4gICAgUHJvamVjdCBvcHRpb25zICAgICAgICAgOnAxMSwgYWZ0ZXIgcDEsIDdkXG4gICAgUHJvamVjdCByZWNydWl0aW5nICAgICAgOnAyLCBhZnRlciBwMTEsIDIxZFxuXHRQcm9qZWN0IG9uYm9hcmRpbmcgICAgIDpwMywgYWZ0ZXIgcDIsIDE0ZFxuICAgIFByb2plY3Qgc3VwcG9ydCAgICAgOjQyZFxuICAgIFxuICAgIHNlY3Rpb24gU2Vjb25kIFByb2plY3RcbiAgICBQcm9qZWN0IHBsYW5uaW5nICAgICAgIDpwNCwgMjAxOS0wMi0xMiwgN2RcbiAgICBQcm9qZWN0IG9wdGlvbnMgICAgICAgICA6cDQxLCBhZnRlciBwNCwgN2RcbiAgICBQcm9qZWN0IHJlY3J1aXRpbmcgICAgICA6MjFkXG5cdFByb2plY3Qgb25ib2FyZGluZyAgICAgOjE0ZFxuICAgIFByb2plY3Qgc3VwcG9ydCAgICAgOjQyZFxuXHRcdFx0XHRcdCIsIm1lcm1haWQiOnsidGhlbWUiOiJkZWZhdWx0In0sInVwZGF0ZUVkaXRvciI6ZmFsc2V9)​

## Project planning <a href="#project-planning" id="project-planning"></a>

As of now, the requirements gathering process is manual. We use the following templates:

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvlAyFmOMGBfwyZQeS-%2F-LvlCYYZM5SUBnhlqd5l%2FScreen%20Shot%202019-12-10%20at%2013.08.04.png?alt=media\&token=eea7d995-fba2-4a76-9533-657ecc5de41f)

> Edit this flow at this link.

### How to modify the `remaining-requirements` email template content for sending <a href="#how-to-modify-the-remaining-requirements-email-template-content-for-sending" id="how-to-modify-the-remaining-requirements-email-template-content-for-sending"></a>

The `remaining-requirements` template includes questions for all the fields needed in requirements-gathering that **could** still be unanswered by the time of sending. In uncommon situations, there may be others. If you already have the answers to some of these questions, remove the question from the message you send.

First, find the form response for your project in the New Project spreadsheet.

Then, for each field...

* If you already have the complete value, remove the question from the message
* If you have an incomplete value for a question that's **not** in the template, add the question ad-hoc to your message

### How to fill in the tricky fields for the `request-confirmation` email <a href="#how-to-fill-in-the-tricky-fields-for-the-request-confirmation-email" id="how-to-fill-in-the-tricky-fields-for-the-request-confirmation-email"></a>

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-Lu3nxeslN-UCTXVyUYk%2F-Lu3uYmHKUzddq-mW76f%2FAnnotation%20on%202019-11-19%20at%2012-25-48.png?alt=media\&token=ae137807-050c-4fe6-8b62-5eaa0bfd6f90)

1. **primaryTeacherFirstName:** this is the teacher from the `teachers` sheet in the `tools` workbook with `mainContact` equal to **yes**.
2. **teacherFirstNameList:** a comma-separated list of all participating teachers from the `teachers` sheet in the `tools` workbook. For the excel wizards, this is like a `JOIN(", ", teacher_array)`.
3. **numberSummaries:** how many options we'll provide them. This is a confirmation of the Service Level Agreement based on when they requested the project and when the project should start. Pick the right number based on the [SLA found here](https://help.sidekick.education/terms-and-policies/master-service-level-agreement#custom-projects).
4. **productNameSingularWithInclusions:** the `ideas` and `recruiting` sheets have a `productNamePluralWithInclusions` field. Make this singular.
5. **langCheckpointAlias:** schools have different names for checkpoints that we need to use in customer-facing documents. You can find this in the `config` sheet.
6. **requestedCheckpointList:** a comma-separated list of checkpoints required by the teacher or partner. Teachers sometimes have specific work products they want included in their project, which they share when you ask them for their existing ideas. These should get written down under the **Key Checkpoints** section on the `ideas` sheet.
7. **skillsList:** a line-separated list of all target skills from the `skills` sheet. This should show up as a bulleted list of skills.
8. **...RequestStatus:** these fields can either be **requested** or **on request**, depending on the teacher's initial request. Some projects are too short to include every partner request, or the teacher doesn't want or expect all of the partner connections based on their school's preferences or the training they received. To date, there's not really a good place where this information is stored. You just have to know from talking with the teacher. This is a way to advertise the other partner connections if they aren't going to do them all.

### How to handle project options with teachers <a href="#how-to-handle-project-options-with-teachers" id="how-to-handle-project-options-with-teachers"></a>

> **You only create project options when there are options to choose from.** That also means this can only be done once [partner recruitment](https://help.sidekick.education/how-to-guides-1/sidekick-project-support/broken-reference) has started. You should have received a notification from the partner recruiter that there are options waiting for you in the tools spreadsheet.

#### Clean up the Plan document <a href="#clean-up-the-plan-document" id="clean-up-the-plan-document"></a>

Project options build off the **Plan** document in the project's folder. In the typical situation, that document should currently have all the project **ideas** in there. The first step is to cut this down to only the **selected** ideas.

Go to the Overview. Delete the project tables for each project that was not selected. In the typical situation, you should be left with a single project table.

Update the project's existing table with the most current information. For example, the essential question or idea statement may have evolved since the idea stage. Or, you may need to use a different illustrative partner or how it helps.

Delete the entire summary sections for each project that was not selected. In a typical situation, you should be left with a single summary section.

#### Extend the overview with potential partners <a href="#extend-the-overview-with-potential-partners" id="extend-the-overview-with-potential-partners"></a>

Open the [`summaryOptionsPartnersIntro`](https://docs.google.com/document/d/1sZR3YvA-D6vyff6htjjhdTSCSd0_YPzLEsUzcBqxg98/edit) template component. **Make no changes here.** Select all and copy.

Go to the Overview in the Plan document. Underneath the project table, paste in this section header.

Open the [`summaryProfessionalListItem`](https://docs.google.com/document/d/1MJG6lQU6-vI8KwQtYHlYuKUm_iNH16rnz59WCoctHvg/edit) template component. **Make no changes here.** Select all and copy.

Open the the tools spreadsheet for the project. Go to the `professionals` sheet. You should have a short list of contacts. These are the partner options for the project(s).

Go back to the Overview in the plan document. Underneath the new section you created, **for each partner option**, paste and fill in the professional table template.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvlCbzSWsfkUmMLTHS4%2F-LvlKVRx_7JqWiGSDIZN%2FAnnotation%20on%202019-12-10%20at%2013-42-29.png?alt=media\&token=92817cc8-8114-4ca7-be74-7c1641765364)

To fill in the fields, find the following fields on the `professionals` sheet.

1. **partnerFirstName** for each contact
2. **partnerLastName** for each contact
3. **jobTitle** for each contact
4. **organization** for each contact
5. **partnerIntro** for each contact

For 6, replace the placeholder image with a headshot of the partner. If the partner has already filled out the agreement form and included a headshot, you can find the official headshot in the form responses. Check this first. Go to the table holding the form responses [at this link](https://docs.google.com/spreadsheets/d/1rCmpKKFPkWFBa9dn2mXtVE_5NNSP_FX9899GZTGR6po/edit#gid=211113181). Search for a matching contact. If you see a matching contact, check if there is a link under the question **Upload your preferred headshot.** If there is, follow that link. Use that image as your replacement for the headshot.

If the partner hasn't submitted the agreement yet, we need to do some digging. First, search for the partner on LinkedIn. If their profile is public, use the LinkedIn profile photo as the headshot. You can also try this approach with Facebook, Twitter, company directories, and general web searches. If nothing works, you may have to leave it as a placeholder.

#### Send the options to the teacher <a href="#send-the-options-to-the-teacher" id="send-the-options-to-the-teacher"></a>

Find the relevant email template [at this link](https://docs.google.com/document/d/1jHooMyqHRODNaHz3JJXAzhNtZhsK4KW-LvgjIhL9tPU/edit). **Make no changes here.** Copy the body of the email into a Gmail draft.

> Remember, it's often a good idea to first clear the formatting of the pasted content, re-add any special formatting like bold text and links, and then [save the template as a Template in Gmail](https://sk-edu.gitbook.io/wiki/projects/support-message-templates#save-templates-in-gmail).

Fill in the template fields of your draft email manually.

Send it to the appropriate teacher(s).

If you don't hear back in 2 days, send a follow up!

#### Update the **preferredOrder field in** **`professionals`** <a href="#update-the-preferredorder-field-in-professionals" id="update-the-preferredorder-field-in-professionals"></a>

When you hear back from the teacher(s), update the **preferredOrder** field for each contact in the `professionals` sheet. You may need to translate their choices from letters into numbers.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvlNiCpBgodj1obJEFA%2F-LvlPEucM0fTIJLuGm91%2FScreenshot%20from%202019-12-10%2014-03-28.png?alt=media\&token=4685a5ff-62fc-44f8-a6d8-79b9fc42e864)

Immediately notify the partner recruiter that the teacher has made selections. In your notification, copy and paste the link to the tools spreadsheet with the `professionals` sheet open so they can quickly get there.

> ## IGNORE: Automation notes <a href="#ignore-automation-notes" id="ignore-automation-notes"></a>
>
> **You can ignore this**
>
> *Before writing this Chris needs to turn* ***1)*** *turn the Dossier into a Options cover sheet template and* ***2)*** *add an "projectOptionRecruitmentStatus" to config so we can tell the code which status to filter on when pulling from* *`professionals`.*
>
> Options is just an extended plan. Once an option has been selected, the others are removed.
>
> Differences in idea and option for a projects
>
> 1. Idea do **not** have the potential partners section. Options **do** have the potential partners section.
> 2. Idea uses the `summaryIdeasProjectsIntro` component instead of the `summaryOptionsProjectsIntro` component.
> 3. Idea does **not** have the partner-project matrix. Options **do** use the partner-project matrix (**only when** the teacher has asked for multiple potential projects).
> 4. Idea uses `summaryIdeasChoice` component instead of the `summaryOptionsChoice` component, which instructs the teacher on the next steps.
>
> To dos:
>
> 1. Give your option people different **featuredProjects** so that all your projects show up
> 2. Select the recruiting status option from professionals to be options
> 3. Fill in the additional field **jobTitle** for them on the professionals tab
> 4. If they have not yet submitted their agreement form with a headshot, grab a headshot online (LinkedIn, Google, Twitter, Facebook, etc) if possible
> 5. Create summaries for each project
> 6. Note that all partners can work with all project
>    1. Better to create a table that shows which partners are good for which projects

## Partner recruitment and project selection <a href="#partner-recruitment-and-project-selection" id="partner-recruitment-and-project-selection"></a>

The messages sent to the teacher will be sent by the person supporting the **teachers**. The messages sent to the partner will be sent by the person recruiting **partners**. We process the teacher's project selection in parallel (even before we know if the partner is eligible) because almost all partners agree to the terms and pass the background check. The teacher's support person and the partner recruiter should be in constant communication during this stage.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LzlrkgM58mo34N7SfPD%2F-LzmR8ClVjWvncBWoEjy%2Frecruiting.jpg?alt=media\&token=a243cc36-3d7f-4c9c-9979-4757840b8fbb)

> Use the clickable links or update this flowchart online at this link. If you update the chart, you need to replace the existing link with the new one in the address bar because the chart is encoded into the link.

### Links to templates <a href="#links-to-templates" id="links-to-templates"></a>

**partner-outreach-cold:** [https://docs.google.com/document/d/1akgit5RFAlD\_p7w401r0-yGhZQnuV34X203syWtUChk/edit#](https://docs.google.com/document/d/1akgit5RFAlD_p7w401r0-yGhZQnuV34X203syWtUChk/edit)​

**partner-confirmation** "<https://docs.google.com/document/d/17Xi_e0YhyNq6e6w-v43_FcXJOfCnxpbTmN3cAce5mwY/edit>"

**partner-chosen-and-handoff** "<https://docs.google.com/document/d/1fRZrrgDXJaOtSKQv-XD8Cf_lHRIWNmr540uTYjXqZMc/edit>"

**partner-not-chosen** "<https://docs.google.com/document/d/1BEv-uF02OhzHSTOwBLtA-n3KWlPHBgdMItqb3RYqG1Y/edit>"

### How to create project dossiers <a href="#how-to-create-project-dossiers" id="how-to-create-project-dossiers"></a>

The first step in recruiting is preparing the project dossiers. This way interested prospects can review all the information they need up front and get fewer messages from us.

#### Figure out how many dossiers you need. <a href="#figure-out-how-many-dossiers-you-need" id="figure-out-how-many-dossiers-you-need"></a>

You should have **at least** 1 dossier per project, and you could need up to **as many as you have ideas for the project.** The number you need depends on whether your ideas are "tight," meaning they could involve the same partners. If you have some ideas for a project that require you to recruit one kind of partner and other ideas that require you to recruit an entirely different partner, you need dossiers for each kind of partner you're recruiting.

The dossier is a document, not an email, so the starting template is in the project folder itself.

Navigate to the project folder. You should find a **Sidekick Project** folder. Follow the path shown in the image below to find the dossier template specific to that project.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LuVvAiG_oqKTA8qvL2Q%2F-LuVvggmE3yO-AEKktbx%2FScreenshot%20from%202019-11-24%2023-00-16.png?alt=media\&token=9dc0d128-174e-4dd2-8815-7b736b35f098)

If you need more than one dossier, copy the document as many times as needed.

#### Add the `projectIdeaListItem` component template for each proposed idea <a href="#add-the-projectidealistitem-component-template-for-each-proposed-idea" id="add-the-projectidealistitem-component-template-for-each-proposed-idea"></a>

You'll use this to create a list of the proposed ideas. The link is included in the dossier template, or you can [access it at this link](https://docs.google.com/document/d/1-R-etNB10pz6cbGSJF5bi7o_R__vR4nOEAA6SEBTqno/edit).

Copy the table in the component template. Go back to your dossier. Replace the field in the dossier template entirely by pasting in the table. Paste in as many tables as you need. For example, if there's only 1 idea for the project, just include 1 table. If there are 3 ideas, then include 3 tables.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LuZB-pQxp32zRAIxldP%2F-LuZCP5Uh_e6iVj55UNw%2FScreencast%20from%2011-25-2019%2002_14_24%20PM.gif?alt=media\&token=1e330d77-a1f7-4e98-91d4-540d88d24dd3)

#### Fill out the dossier template <a href="#fill-out-the-dossier-template" id="fill-out-the-dossier-template"></a>

Many of the fields come straight from tools spreadsheet, but there are a few tricky ones.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvGxbi3BrKdkQ5PRdzB%2F-LvHJOhQOm-FphItyE5j%2FAnnotation%20on%202019-12-04%20at%2013-07-43.png?alt=media\&token=810dbe9a-c930-42e9-b512-77bd0e5d9279)

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvHXoxfn_Nr7DVzrR6v%2F-LvHYvOpntUdCJjl-Yqq%2FAnnotation%20on%202019-12-04%20at%2014-16-58.png?alt=media\&token=f7aedf0b-2339-40ca-8cd5-d346a32cd23d)

1. Find **projectName** in the `request` sheet.
   1. This is the project's name for reference (*not* the name of the idea).
2. Find **startDate** in `request` sheet.
3. Find **endDate** in `request` sheet.
4. **(Obsolete)** The **partnerRole** is now project-specific and covered in the **projectIdeaListItem**s for each idea.
5. Find **volunteers** in the `request` sheet (keep scrolling 😉).
6. Find **preferredMeetingSlots** in the `request` sheet.
7. Find **preferredSessionDates** in the `request` sheet.
8. Find **sections** in `request` sheet.
9. Find **uniqueDaysAWeek** in `request` sheet.
10. Find **schoolName** in `request` sheet.
11. Find **schoolFullAddress** in `request` sheet.
12. Find **aboutSchool** in `request` sheet.
13. Find **classes** in the `request` sheet.
14. Find **estimatedTotalStudents** in the `request` sheet.
15. Find **studentGrades** in the `request` sheet.
16. Find **estimatedStudentGradeLevels** in the `request` sheet.
17. For the **skillsFriendlyDescriptionList,** build an unordered (aka "bulleted") list from the skills in the`skills` sheet.
    1. Make sure every skill in the sheet has a **friendlyDescription**. This is a word or phrase that better summarizes the often long, technical, and obscure description that the standards use.
    2. Sort the rows in the sheet by the **assessed** (i.e., the ones that have **Assess?** set to true) skills if you haven't already
    3. Highlight and copy all the **friendlyDescription** cells for the assessed skills.
    4. Replace {{ skillsFriendlyDescriptionList }} with these values using **Paste** ***values*****.** This is Ctrl + Shift + V (Windows/Linux) or Cmd + Shift V (Mac) as a shortcut.
    5. Reformat the list so that each description has its own bullet point.
18. You should have replaced **projectIdeaListItem** with as many of the same-named component as you have for ideas. Then, for each idea:
    1. Find **projectIdeaStatement** in the `ideas` sheet under the appropriate idea (keep scrolling 😉). If this fails for some reason, projectIdeaStatement is made up of other fields:
       1. Find **productActionPlural** in the `ideas` sheet under the appropriate idea.
       2. Find **productNamePluralWithInclusions** in the `ideas` sheet under the appropriate idea (keep scrolling 😉)
       3. Find **helpfulActionPlural** in the `ideas` sheet under the appropriate idea.
       4. Find **helpfulContent** in the `ideas` sheet under the appropriate idea.
    2. Find the idea-specific **partnerRole** in the `ideas` sheet under the appropriate idea.
    3. Find **howItHelpsThePro** in the `ideas` sheet under the appropriate idea.

Go to the sharing button (currently in the upper-right corner called **Share**). Turn on link sharing. Make sure the sharing permissions are set to **view.** Allow external access.

Copy the link that gets created. You'll need it for the next step.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvGoz1vX52M9KkjdUYF%2F-LvGpQYzc4Eix_-5sKWF%2FScreenshot%20from%202019-12-04%2010-53-39.png?alt=media\&token=dd37c683-62fc-43c0-bda9-7124fd4a4441)

#### Add the sharing link to the appropriate cell <a href="#add-the-sharing-link-to-the-appropriate-cell" id="add-the-sharing-link-to-the-appropriate-cell"></a>

Go to the `ideas` sheet in your `.tools` workbook. Paste the sharing link you copied in the previous step into the `dossierLink` field under the column associated with your idea.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvHRDO-LArc5UoLpW42%2F-LvHRUE8dfMLgTKQaRlH%2FScreenshot%20from%202019-12-04%2013-44-51.png?alt=media\&token=9bb9c6bc-f6eb-49a0-a6a1-e0d29424a153)

> **Note:** if ideas were kept "tight," meaning they use the same partners, multiple ideas can share the same dossier! Include the same link for all ideas that share the dossier.

If everything's working correctly, this will fill in the `dossierLink` field on the `recruiting` sheet with the appropriate link whenever that contact is associated with the same project idea. This link gets used in the mass email template so the mass email will send out the right dossier to everyone.

### How to mass-send the outreach email <a href="#how-to-mass-send-the-outreach-email" id="how-to-mass-send-the-outreach-email"></a>

#### Create the template as a draft in Gmail <a href="#create-the-template-as-a-draft-in-gmail" id="create-the-template-as-a-draft-in-gmail"></a>

#### Run spellcheck <a href="#run-spellcheck" id="run-spellcheck"></a>

#### Add your email to the Partner recruiter field on the `request` sheet <a href="#add-your-email-to-the-partner-recruiter-field-on-the-request-sheet" id="add-your-email-to-the-partner-recruiter-field-on-the-request-sheet"></a>

The is the email that will get filled in for any contact that doesn't have an email (like general submission forms).

#### Filter the contact list to those you want to send to <a href="#filter-the-contact-list-to-those-you-want-to-send-to" id="filter-the-contact-list-to-those-you-want-to-send-to"></a>

First, make sure you expand the table boundaries to include all contacts if you've added more contacts since the table was created.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvRY9IxkiBUvejjBQGf%2F-LvRlKwG4Gvbn0D6CGsx%2Fexpand-table.apng?alt=media\&token=13059596-5e0b-486d-9c15-ad042a616eea)

Use the table filters to remove any `contactBefore` contacts. Then filter to a specific `tier`, depending on which tiers you've sent to before. Finally, pick and choose which contacts you'd like to send to using by putting either **yes** or **no** in the `Send` field. Filter the contacts by filtering to only the **yes** contacts or by filtering out the **no** contacts.

#### Send a test email using Mailmeteor or Yet Another Mail Merge <a href="#send-a-test-email-using-mailmeteor-or-yet-another-mail-merge" id="send-a-test-email-using-mailmeteor-or-yet-another-mail-merge"></a>

> **Note:** We used to use a add-on called Yet Another Mail Merge. If you find any reference to it, know that you can use almost the exact same workflow with Mailmeteor. Mailmeteor is the preferred solution, but it has some bugs loading. You can find both add-ons domain-installed in the **Add-ons** menu in Google Sheets.

Select the outreach template by the email's subject.

First, send a test subject.

#### Send the email using Mailmeteor <a href="#send-the-email-using-mailmeteor" id="send-the-email-using-mailmeteor"></a>

When everything looks good, repeat the process you used to send a test email, except this time send it to the actual contacts.

### How to handle partner recruitment through each recruitment status <a href="#how-to-handle-partner-recruitment-through-each-recruitment-status" id="how-to-handle-partner-recruitment-through-each-recruitment-status"></a>

Go to the `recruiting` sheet. When you get a response from a contact, update their status in the **Recruiting Status** field. Recruiting status tie to different steps in the recruiting process (you can follow along in the [process flow](https://help.sidekick.education/how-to-guides-1/sidekick-project-support/broken-reference)).

1. If a partner declines, thank them for their response and then set their status to **Declined**.
2. If a partner accepts, set their status to **Accepted.** When a partner accepts:
   1\.
   2. add the link to your copy of the `partner-confirmation` email template in Gmail
   3\. Send them the partner-confirmation email
3. If you have more than one Accepted, choose which ones you want to use as options to give the teacher. Set these to **Used as option.** When you pick someone as an option:
   1. Notify the Human Sidekick (the teacher's support person) on the project of the options.
   2. They will create a [project options doc](https://help.sidekick.education/how-to-guides-1/sidekick-project-support/broken-reference) and send the `project-options` template.
4. The teacher will select one or more partners for the project. The Human Sidekick will notify you of the teacher selections. When you get the selections, update the status of the top **preferredOrder** to **Chosen partner.** When you set a contact's status to Chosen partner:
   1. CC the teacher support person then send the chosen partner the [`partner-chosen-and-handoff`](https://docs.google.com/document/d/1fRZrrgDXJaOtSKQv-XD8Cf_lHRIWNmr540uTYjXqZMc/edit) template
   2. send any other Accepted or Used as option contacts the [`partner-not-chosen`](https://docs.google.com/document/d/1BEv-uF02OhzHSTOwBLtA-n3KWlPHBgdMItqb3RYqG1Y/edit) template

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvcjI21nszNZf6tG6Pe%2F-Lvcm-qTxaNEGVYkkeS2%2Frecruitment.apng?alt=media\&token=95bf08d0-3eac-4948-86c1-cccb8931cdc2)

### How to create a pre-filled form link <a href="#how-to-create-a-pre-filled-form-link" id="how-to-create-a-pre-filled-form-link"></a>

​[Use this link to open the form prefiller link.](https://docs.google.com/forms/d/1IlJI9JmzC8JISbQyMMTT51xRRY3WZ5Wvob37PLV5kXU/prefill?entry.1818947618=My+company+\&entry.276898256=At+my+company,+I+\&entry.1860129825=That+means+I+) You can open the link from the **Custom Projects** board:

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvRY9IxkiBUvejjBQGf%2F-LvRYEVFRfYAxbqYBkuT%2FPeek%202019-12-06%2012-48.apng?alt=media\&token=a84f89dc-4289-452c-926b-fc07b0a59f15)

This link has the fields that are always the same pre-filled for you.

Go to the `professionals` sheet. You must update the recruitment status of the contact before the contact will show up here. [Follow these steps to do so](https://help.sidekick.education/how-to-guides-1/sidekick-project-support/broken-reference).

Using the fields on the `professionals` sheet, fill in the following fields in the prefill form:

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LvRlS7jfGpeZUxkgC7O%2F-LvRus95fjiSFeWWdH4o%2FScreenshot_2019-12-06%20Sidekick%20project%20onboarding\(2\)%20\(1\).png?alt=media\&token=6579bce0-8b54-4653-b6e3-50812d19c3bb)

1. **partnerFirstName** and **partnerLastName** for the right contact
2. **sendEmail** for the right contact
3. Find this from their LinkedIn profile or from the company directory.
   1. After finding this information, add it to `professionals` sheet > **jobTitle** for the contact
4. **organization** for the right contact
5. **projectDescription** for the right contact

Finally, hit **Get Link** in the form. Then copy the link it gives you.

Manually replace the link in your confirmation email template with the copied link.

## Project onboarding <a href="#project-onboarding" id="project-onboarding"></a>

As of right now, the process of onboarding teachers and partners is manual. We do have some message templates to help.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LzlrkgM58mo34N7SfPD%2F-LzmQSBzCfgbnCKd1Fbz%2Fonboarding.jpg?alt=media\&token=3e2029f0-75ab-4ffd-9294-2bb0968c0e0c)

> Update this chart online at this link. It also has live links to each template mentioned.

### Links to templates <a href="#links-to-templates-1" id="links-to-templates-1"></a>

```
click sample "https://docs.google.com/document/d/1YY5LvuYDqwo0-42KF2xCJu2drQL5pGbrAUkTs8-S0oQ/edit"click intro "https://docs.google.com/document/d/1S-lUJdh5i8wNabrpRP2RwTbJdIwFzAZkpQlug-sWHR4/edit"click call-invite "https://docs.google.com/document/d/1j0L89nFZ3Xy3r53lF_JFh-pyQOxK6ufADLERhynH-f8/edit"click invite "https://docs.google.com/document/d/1I15Kss6fEK0Jw-dMm5sxHxXAI2lq6u8SMxj5bVvdybo/edit"click schedule "https://docs.google.com/document/d/1S-lUJdh5i8wNabrpRP2RwTbJdIwFzAZkpQlug-sWHR4/edit"click next "https://docs.google.com/document/d/1wXDJrTtLp4nVcavaAE7plA8SQo1UvmCLUJ1Ouch2vJA/edit"
```

click link "<https://docs.google.com/forms/d/1IlJI9JmzC8JISbQyMMTT51xRRY3WZ5Wvob37PLV5kXU/prefill>" click agreement "<https://docs.google.com/spreadsheets/d/1rCmpKKFPkWFBa9dn2mXtVE_5NNSP_FX9899GZTGR6po/edit#gid=211113181>"

### How to modify the `onboarding-info` email template content for sending <a href="#how-to-modify-the-onboarding-info-email-template-content-for-sending" id="how-to-modify-the-onboarding-info-email-template-content-for-sending"></a>

The onboarding-info email is a massive info dump meant to prepare the teacher and partner for the project. Not every part of the document is needed for every project. Here are the changes to work through.

#### Do you need to introduce the human Sidekick? <a href="#do-you-need-to-introduce-the-human-sidekick" id="do-you-need-to-introduce-the-human-sidekick"></a>

If you have not yet introduced the human Sidekick, add in the introduction component. Leave the human Sidekick contact information in either way.

#### Should you remove the annotated expert work sample? <a href="#should-you-remove-the-annotated-expert-work-sample" id="should-you-remove-the-annotated-expert-work-sample"></a>

Some projects don't ask the partner to create an annotated work sample. This may be because they've worked out a different program than the usual Sidekick project or because they found the partner too late to get one in. Either way, remove the row describing the annotated expert work sample from the relevant table.

#### Should you add the project updates? <a href="#should-you-add-the-project-updates" id="should-you-add-the-project-updates"></a>

If a project is not long enough or does not have any **7-day** stretch without a connection with the partner, then we don't ask for project updates. If there is a potential of having such a stretch, replace the `{{ emailComponent:projectUpates }}` with the corresponding email component template.

### How to send each event invitation <a href="#how-to-send-each-event-invitation" id="how-to-send-each-event-invitation"></a>

#### Event planning call <a href="#event-planning-call" id="event-planning-call"></a>

**Make sure you can attend this call.** Invite:

* The teacher(s)
* The partner(s)
* Yourself

Add this meeting to the **Real-world Projects** [Sidekick calendar](https://calendar.google.com/calendar?cid=c2lkZWtpY2suZWR1Y2F0aW9uXzYyYjVpNW8wZ21mdmw2ZWE4cmp1anN2ZHNnQGdyb3VwLmNhbGVuZGFyLmdvb2dsZS5jb20).

#### In-person entry-event <a href="#in-person-entry-event" id="in-person-entry-event"></a>

Schedule this for the full time the partner will be there. Invite:

* The teacher(s)
* The partner(s)
* Yourself (as Optional or FYI/Resource)

Add this meeting to the **Real-world Projects** [Sidekick calendar](https://calendar.google.com/calendar?cid=c2lkZWtpY2suZWR1Y2F0aW9uXzYyYjVpNW8wZ21mdmw2ZWE4cmp1anN2ZHNnQGdyb3VwLmNhbGVuZGFyLmdvb2dsZS5jb20).

### How to lead the event planning call <a href="#how-to-lead-the-event-planning-call" id="how-to-lead-the-event-planning-call"></a>

> This call should last 20 to 30 minutes.
>
> Agenda:
>
> 1. Review objectives of the call
> 2. Introductions
> 3. Go over roles and expectations
> 4. Plan the entry event
> 5. Decide on additional partner connections
> 6. Review next steps

#### Walk them through the agenda for the call <a href="#walk-them-through-the-agenda-for-the-call" id="walk-them-through-the-agenda-for-the-call"></a>

Explain the following:

* **everyone should leave the call understanding their role in the project** and what steps they should plan to take to fulfill it
* **most of the time is dedicated for them to collaborate on a plan for the entry event.** You are there as a "gopher" to handle any logistical requests that may arise as well as a "referee" to point out any requests of the partner or teacher that may be beyond the initial commitment.
* **you will go over the additional partner connections that Sidekick can support following the in-person entry event** and get a consensus on which connections you want to include as part of the project

#### Coordinate introductions <a href="#coordinate-introductions" id="coordinate-introductions"></a>

Ask the teacher to start. Ask the teacher to also share who the students are, what drove their interest in this specific project, and what the students are supposed to be learning.

Prompt the partner to follow with their own introduction.

#### State the role of the partner in the project <a href="#state-the-role-of-the-partner-in-the-project" id="state-the-role-of-the-partner-in-the-project"></a>

Ask the teacher to share their expectations on how the students will benefit from the partner's involvement.

"Warm up" the teacher by explaining that partners usually increase students' engagement in projects. Use one or more of these reasons:

* They are a credible source on the topic so students pay attention to what they say
* They are an real person with a legitimate reason to be involved, so it makes the work students are doing more authentic
* Just having a real human spending a day with them can personalize the project, and a lot of good can often come simply from making that personal connection with you

Guide the teacher into saying that the partner should talk about the subject from personal experience.

#### Plan the entry event <a href="#plan-the-entry-event" id="plan-the-entry-event"></a>

Have them to discuss how they'd like the day to go.

"Warm up" the conversation by pointing them toward the how-to article in the help docs. Share the following link: <https://help.sidekick.education/how-to-guides-1/sidekick-project-guide/in-person-entry-events>. Recommend the plan outlined by the help doc.

#### Pick partner connections <a href="#pick-partner-connections" id="pick-partner-connections"></a>

Explain that a "full" Sidekick project comprise a few key partner connections that you can help with, and they can choose to do as many or as few of them as they'd like.

Share the following link: <https://help.sidekick.education/how-to-guides-1/sidekick-project-guide/project-overview>.

Using the help doc yourself, walk through each one, and then note which ones they say they want your help with.

#### Review next steps <a href="#review-next-steps" id="review-next-steps"></a>

Depending on the chosen partner connections, the partner and you may have different immediate next steps. Share whatever action items you have collected during the meeting.

#### *After the call:* prepare an accurate flowchart of the project's workflow <a href="#after-the-call-prepare-an-accurate-flowchart-of-the-projects-workflow" id="after-the-call-prepare-an-accurate-flowchart-of-the-projects-workflow"></a>

Depending on which partner connections the teacher and partner agreed to, the workflow for the project will look different. Customize the full flowchart to include only the chosen connections. Use the [how-to guide on creating flowcharts](https://sk-edu.gitbook.io/wiki/projects/support-message-templates#how-to-create-partner-connection-status-flowcharts) to get you started.

![](https://gblobscdn.gitbook.com/assets%2F-LiTdqhKXdz-2vp4bkbh%2F-LxxdEFt9BU5ujcjMMZq%2F-LxxeH2qqTCowGCGeNfl%2Fedit-flowchart.apng?alt=media\&token=7aa6d835-d24f-417c-954a-98cf31cf6ea0)

## Project support <a href="#project-support" id="project-support"></a>

### How to prompt for a final submission and exit video <a href="#how-to-prompt-for-a-final-submission-and-exit-video" id="how-to-prompt-for-a-final-submission-and-exit-video"></a>

#### Ask for the final submission <a href="#ask-for-the-final-submission" id="ask-for-the-final-submission"></a>

Send the `next-connection` message template with the `exitVideo` email component, using **"exit video"** as the value for the `nextPartnerConnection` variable.

#### Ask for the exit video <a href="#ask-for-the-exit-video" id="ask-for-the-exit-video"></a>

> We use [**Hubcap**](https://hubcap.video/) to collect videos.

Copy the link to the final submission in the project folder. (Make sure you use the link accessible by collaborators **only** so you don't potentially share private student data with the world.)

Send the `exit-video-start` email template using the link as the value for the `finalSubmissionLink`. This will ask the partner to record a video using the provided link. That link is: <https://record.hubcap.video/DYrSasLQ9yY0Ci6quQ2O>.

#### Send over the exit video <a href="#send-over-the-exit-video" id="send-over-the-exit-video"></a>

When a partner submits their video, you will receive a notification in the **#projects** channel in **Slack.**

Upload this video to Sidekick's YouTube channel as **unlisted**. Then, copy the link. Add the link to the `exit-video-complete` message template in place of the `exitVideoLink` variable and send this to both the teacher and the parter.
