Welcome to the Administrative assistant round 3 interview
Please complete the following 4 objectives to the best of your abilities within the next 3 hours. Pay attention to time. You should have something to share for each objective. Be sure to read all directions thoroughly. Details matter.
You MUST send us your Submission Email BEFORE your scheduled interview start time. Please do not be late to your interview. And be prepared to share your Zoom screen at the beginning of the interview to walk us through your completed materials.
Objective 1) Create an Airtable base
Recommended time limit: 1 hour and 15 minutes (you should move on to Objective 2 if you don’t finish within this time)
Airtable is a platform we use daily to maintain records and data within The Vegan Gym.
Your first objective is to create a questionnaire form for new clients. Collect the client’s name, email, phone number, their coach’s name, birthday, and any other information that you think would be necessary for us to know about new clients.
Ask yourself: What client information do coaches need to know to create an exercise program and nutrition program?
Then ask yourself: How would a team of coaches need to see this information organized?
You probably do not have experience with Airtable. That’s okay. You don’t need Airtable experience to complete this objective. It is a very user-friendly platform. You can create a free account and should utilize any tools or resources available to you. There are tons of great Airtable help articles online.
Here are your sub-objectives:
Create the new client questionnaire Airtable form and then fill it out and submit it as though you are a new client. Please add more clients if you have time. Be sure to add a coach-select field that lists all coaches on our team. And please be sure to make all fields “required” for all submissions.
Create the following views:
Create a view with all client information grouped by coach.
Create a Calendar view for client birthdays.
Create a view where you can see all client contact information filtered alphabetically by last name (A-Z) for our Operations Team. The information included in this view should be the client’s name, email, phone number, their coach’s name, birthday, and mailing address.
You should watch this quick Airtable tutorial video before you begin this objective
Objective 2) Share your growth idea
Recommended time limit: 45 minutes (you should move on to Objective 3 if you don’t finish within this time)
Share your #1 idea for growing our business and the strategy you would implement if you were leading this project.
You should submit this document as a PDF with a hyperlinked table of contents (that is clickable in PDF format). The table of contents should be directly under the title, and the content of your document should begin at the top of page 2.
Please use Montserrat font. Size 13 for normal font and size 26 for the title.
Objective 3) Create a Google Calendar event
Recommended time limit: 15 minutes
Create a recurring Google Calendar meeting for The Vegan Gym Leadership Team that occurs every other Thursday at 2:15 pm Eastern Standard Time for 40 weeks, with the first meeting occurring on the first Thursday in 2023.
Include a Zoom link for a recurring meeting titled "The Vegan Gym Leadership Team Meeting" in the description of the Google Calendar invite.
Hint: To share a link with us, you must create a public Google calendar.
Objective 4) Business Connection
Recommended time limit: 30 minutes
We are currently looking for a new accountant. Send us the name(s) and contact information of the best accountant(s) for our business. Explain where you found their name(s) and why you would recommend them. Figure out their availability to take on a new client and how they charge for their services.
Write this information in a 1-page Google doc. Please use Montserrat font. Size 13 for normal font and size 26 for the title.
Submission Email
Please email all of your objectives to me (carly@thevegangym.com) and copy Leif (leif@thevegangym.com).
Your email should have the following format:
Email Subject: Your Full Name - Completed Objectives
Email Body:
Your first and last name
Your phone number
Your mailing address
Objective 1: Share a link to your Airtable base with me (carly@thevegangym.com) and Leif (leif@thevegangym.com) that grants us both “Creator” access.
Objective 2: Link to your Growth Project (PDF) hosted on Google Drive. Be sure to check the share permissions to be sure we can open it.
Objective 3: Link to your public calendar, which should only have "The Vegan Gym Executive Team Meeting" on it. We should be able to click your link and add the event to our calendars.
Objective 4: Link to your business connection research (Google doc). Be sure to check the share permissions to be sure we can open it.
You are welcome to include any additional information you would like to share about the assignment or your application.
-- end of email --