Starry Eyes Media

office manager

Introduction

We’re excited to get to know you and appreciate your interest in our Office Manager position. The following application contains basic questions and multiple open-ended questions so we can gauge various things about you, such as how you present yourself, communicate, and think.

BEFORE YOU BEGIN: It’s likely you’ll need a quiet place and about 15 to 30 minutes to complete this application. This application has a few test questions that require spreadsheet software like Google Sheets (free) and Microsoft Excel. Skipping these questions will result in automatic dismissal of your application.

We all have a past and the person we were may have moments that we’d rather forget; however, the available position is one of high importance with access to a great deal of sensitive information. With that in mind, we’ll need to run a background check on all qualified applicants.

IMPORTANT: Upload either a Word document or PDF - JPEG's are not acceptable.

Experience

The following questions will give us an idea of what tools you’re used to using and how you deal with standard issues around an office.

Select how many years of experience you have with operating a Windows PC.
USelect how many years of experience you have with operating a Macintosh computer.
Select how many years of experience you have with operating Microsoft Excel.
Select how many years of experience you have with operating Microsoft Word.
Select how many years of experience you have with operating Adobe Creative Suite/Cloud.
Select how many years of experience you have with managing an office.
Select how many years of experience you have in project management.

Personality

PERSONALITY
Choose one.
We work closely as a team. If you were to join this team, what are the primary skills you could offer to our shared success?

Applied Skills

APPLIED SKILLS
Explain how you would handle the situation and your reasoning.
Can you handle billing?
IMPORTANT: Using Microsoft Excel or Google Sheets (free), upload either a .XLSX, .CSV, or PDF - JPEG's are not acceptable. We have a total of three people who will be working on the following projects, Picard, Data, and Spock: "Company A," "Company B," and Company C. "Company A" needs an informational website, "Company B" needs a more interactive website, and "Company C" is interested in our branding services. Aside from these pending projects, we have a few clients that pay us a retainer and may need unscheduled assistance. Generally, informational website development takes approximately twenty hours, while the custom interactive site that Company B needs is estimated to require a total of twenty-six hours. Likewise, a full branding package will take about ten hours to complete. Considering that Data and Picard work an average of thirty hours during a seven day work week, while Spock works a steady fifteen hours Monday through Wednesday, create a spreadsheet that outlines a two-week schedule. Have the schedule begin on week forty-nine of the year and specify the days, the dates, and the team members with emphasis on what each team member will be doing during the day (what projects they'll be working on and for how long).
Looking at your spreadsheet uploaded above, explain what your method for determining the order in which the work should be done?
IMPORTANT: Using Microsoft Excel or Google Sheets (free), upload either a .XLSX, .CSV, or PDF - JPEG's are not acceptable. Create a spreadsheet that organizes the following information: January 2018: $23,045, March 2018: 45,231, February 2019: 23674, April 2018: 34,908, May 2018: 12,589, June 2018: 18,340, July 2018: 34,589, August 2018: 25,753, September 2018: 35908, October 2018: 35.985, November 2018: 45,673, December 2018: 36,857. Once you have organized the data and formatted the spreadsheet, add a field that calculates the average monthly revenue for 2018. Upload the spreadsheet here.
Given no training material for Starry Eyes Media's procedures or operations, what would your process be in developing your own training materials for project managing? What questions would you ask, which ones would you ask first?
Is there anything that you would like to comment about the questions, your answers, or anything else in general about yourself?