Intern Onboarding Checklist 2023_11

Date

MonthDayYear
DateHourMinutesAM/PM Option
Has Been Edited?
Date of Last Edit

MonthDayYear
DateHourMinutesAM/PM Option
Intern Onboarding Checklist
This is much easier on a desktop or tablet than it is on a phone.
Please provide the info requested below. Return to keep it current.

To edit or update, use the link, which we provide on the thank-you page and in the confirmation email, which will come from noreply@jotform.com. Be sure to save that edit link!

Be sure to create your profile page on Changing The Present.

We pull other important info from there so we do not have to ask it here, as well.

Your Name, Start Date, etc.
Your Name (if you are an international student with an English name, or if you use a nickname, please enter either in the Middle Name field)*

First NameMiddle NameLast Name
Your gmail address*
We will not share or display it.
The field above must be a @gmail.com address--the same you used when you applied.
Reminder: Whenever you create a google file of any type for CtP, please make rtolmach@gmail.com the owner immediately.
If you are a Chinese citizen, the email address we can use to reach you when you are in China (not a gmail address)
We will not share or display it.
Your Start Date

MonthDayYear
This may be different from the date on your offer letter if you are on CPT or OPT and start by volunteering with us. International students' ability to volunteer is set forth in this memo https://docs.google.com/document/d/1lX-xNknRJjbvlwubh4frSTKxN2TkfEsjWt2y9eDqjOs/edit?usp=sharing
Citizen of what country? (Everyone is welcome. We have had interns and volunteers from more than 80 countries).
Your birth date. (We want to wish you a Happy Birthday when the time comes).

MonthDayYear
Upload a close-up headshot. With so many people, this helps us keep track. Follow the prompt to crop it to square.

Fix your gmail address FROM field
Here is a tip for the professional world--not just CtP.

Take a minute to check and fix the setup in your gmail address.

When a group of people share access to a google file, it is important that they can all see who else is on the team. However, many people have their gmail set so that it shows their gmail address twice, instead of showing their name above their email.

See the image below. Robert Tolmach shows his name above his email. The others show their gmail twice, so teammates may not know their names. (Yes, we obscured part of each gmail address for privacy).

Things to Read
Check the boxes to show which you have read (we have provided the links to each document right below this list of checkboxes):

CtP Welcome ManualWelcome Materials and Files formAsana instruction manual (it is within Welcome Manual)'Basics' tab of this Google sheet: CtP - Google Sheets InstructionsHR Posting Manual (for HR interns only)HR Interviewing Manual (for HR interns only)HR Processing Manual (for HR interns only)
The Following Are for Everyone

Welcome Manual

https://ChangingThePresent.org/welcome

New Intern Welcome Materials and Files form

https://form.jotform.com/221927183316153

Asana instructions (included in the Welcome manual)

The Google sheet formulas tab of this file: ZZZ Things to know. You should know these formulas very well, even if analytics is not your focus.

https://docs.google.com/spreadsheets/d/1jv-BLuGpsz-T4w8zq1YUwrQ2speTM6EoRfkOes-RDaw/edit?gid=0#gid=0
If you are an HR Intern, please check this box to see the items that only HR interns need to read.

Yes, I am an HR Intern
The Following Are for HR Interns, Only

HR Posting Manual (for HR interns only)

https://docs.google.com/presentation/d/1DzBO082_whmw083OkfPuFH5VB9wz5GgLNYByziN1dZ0/edit?usp=sharing

HR Interviewing Manual (for HR interns only)

https://docs.google.com/presentation/d/1kl_0kDNynLeci6UP1YH8WmFRu1F-EiHUPIm2zJ0uktI/edit?usp=sharing

HR Application Processing Manual

https://docs.google.com/presentation/d/1Bhy-GvR8af1cat2znmz9OxB1ouTa6MrcvkJDbH7ltWc/edit?usp=sharing
The Following Are for HR Interns, Only

HR Posting Manual (for HR interns only)

https://docs.google.com/presentation/d/1DzBO082_whmw083OkfPuFH5VB9wz5GgLNYByziN1dZ0/edit?usp=sharing

HR Interviewing Manual (for HR interns only)

https://docs.google.com/presentation/d/1kl_0kDNynLeci6UP1YH8WmFRu1F-EiHUPIm2zJ0uktI/edit?usp=sharing

HR Application Processing Manual

https://docs.google.com/presentation/d/1Bhy-GvR8af1cat2znmz9OxB1ouTa6MrcvkJDbH7ltWc/edit?usp=sharing

Your Social Media Expertise
Please indicate your level of expertise with each of the following on a scale of 1 - 10 (10 is high, of course).
Facebook*
Instagram*
Twitter*
Linkedin*
Tik Tok*
Hootsuite*
Buffer*
WhatsApp*
Slack*

Your Social Media Pages
Please let us know the URL of any social media pages that you already have.
Facebook
Instagram
Twitter
Linkedin
Tik Tok

Technical Skills
Spreadsheets
Excel*
Google Sheets*
Layer.io*
If you indicated that you are '5' or above in Excel or Google sheets, please give us a further indication of your skills in either of the programs (they are pretty much the same), as follows:
Pivot tables*
Queries*
If formulas*
Concatenate and Textjoin formula*
Textjoin formula*
VBA*
Database
MySQL*
PostgreSQL*
Mongo DB*
Analytics
Python*
R*
Tableau*
Web Development
Flask*
Django*
PHP*
Wordpress*
Ruby on Rails*
Java*
html*
CSS*
Bootstrap*
Javascript*
node.js*
express.js*
React.js*
Angular*
AWS Services*
Adobe Creative Suite and Other Graphics
InDesign*
Illustrator*
Photoshop*
Adobe Premiere*
Canva*
Figma*
Web Analytics
Google Analytics*
Adobe Analytics*
Salesforce
Salesforce configuration (not just entering data)*
Your Salesforce Trailhead URL
Low-Code or No-Code
Stacker*
Ragic*
Zapier*
Make.com (previously named Integromat)*

Help Us Recruit More Wonderful People
Smart, good-hearted people like you know other smart, good-hearted people. We rely on you to help us recruit them. Please check the boxes when you have done each of the following things to help us recruit more good people.

Emailed or messaged my friendsTweetedAdded to FacebookAdded to InstagramPosted to LinkedinTold professors about opportunities hereTold student clubs and organizations about opportunities hereSpread the word on WeChatSpread the word on Weibo (if you are not Chinese, you may not know what this is)

Submit
Please return to update this form as often as necessary to keep it current.

Just use the Edit link, which we will provide in the thank-you page and in the confirmation email. Be sure to save it!
Please enter the current date so we can see when you last updated this form:

MonthDayYear
Date
Should be Empty: