Video Assignment: Admin Intern Application
As part of our selection process, we’d like you to submit this video assignment. This assignment
is designed to evaluate your ability to learn new tools, manage scheduling across time zones,
demonstrate spreadsheet skills, and reflect on your long-term goals.
Task 1: Lead Generation Funnel using Carrd
Instructions:
1. Create a free account on [Link] (no card details needed).
2. Build a simple lead generation funnel for a mock business (e.g., a dentist or personal
coach).
3. Your funnel must include:
o A landing page with a lead capture form (Carrd has free form elements).
o A thank-you message or redirect after submission.
📹 Record yourself explaining what you built and how it works.
Task 2: Scheduling Meetings Across Time Zones
Instructions:
1. Use Google Calendar or Calendly to create 3 meetings in different time zones (IST, EST,
and PST).
2. Create a scenario:
o You (India), a client (New York), and a team member (London).
o Schedule a common time that works for all.
📹 Show your process of identifying time overlap and setting up the meeting.
Task 3: Google Sheets – Content Tracker
Instructions:
1. Create a Google Sheet to track content creation.
2. Your sheet must include:
o 3 tabs (e.g., Task Tracker, Time Log, Summary Dashboard).
o Use of formulas (e.g., VLOOKUP, IF, COUNTIF).
o Conditional formatting.
o A dashboard summary with charts.
📹 Walk through your spreadsheet and explain each section.
Task 4: Answer These Questions in Your Video
At the end of your video, answer the following:
1. Are you pursuing college right now? If yes, how will you manage a full-time internship?
2. What is your long-term goal?
3. Are you comfortable using a time tracking tool on your computer system during this
work-from-home internship?
✅ Submission Checklist
Submit only one YouTube video link that covers all tasks and answers (unlisted or
public).
The single video must include screen-recorded walkthroughs for all tasks and answers
to the final questions.
No other files, screenshots, or documents are required.