Emergency Operations Program Assistant
Skills Assessment
April 2022
CANDIDATE NAME:
DATE:
INSTRUCTIONS
Complete each assignment below.
- Documents to be used for completing the assessment are included in the folder labeled Emergency Operations Program Assistant Skills Assessment.
- Save documents you create and/or edit within the same folder, using the nomenclature: your last name – assignment #.
- Let the assessment facilitator know once you have completed all assessments.
**********************************************************************************
ASSESSMENT #1:
Microsoft Excel Skills
The Emergency Management Division has realized we are sending hundreds of **A-19/invoices over to Finance monthly. With so many **A-19’s being e-mailed, we’ve discovered there is an opportunity for e-mails to get lost. It has become very important that we track what is being sent to Accounts Payable. The goal is to create an Excel worksheet that contains all pertinent information and will allow us to easily track not only the **A-19s, but whether those invoices have been paid.
**A19 is a Washington Military Department form used to claim payment for materials, merchandise, services, or to pay-out grants recipients.
- Create a worksheet that can track all of the unpaid A-19’s which contains the following information:
- Date Submitted
- Vendor/Subrecipient Name
- Vendor Number/SWV
- Program Index
- Sub Object
- Dollar Amount
- Today’s Date
- Notes
- There are four A-19 invoices attached. Enter data from the invoices into the EMD Invoice Tracking worksheet you have created. (Attachments Invoice #1 – Invoices #4)
- Format the spreadsheet as you would if you were to present the information to the management team, to include:
- Dollar amount formatted as currency
- Landscape View
- Justify all columns to the right, except center all Column Titles
- 1” margins on all sides
- Add total for Dollar Amount column
- Create formula at bottom to count number of A19s included
- Sort A-19s by date, oldest to newest
- Add formula to change all items over 60 days old to turn red
- Save Document.
ASSESMENT #2:
Writing Skills Assessment Instructions
Compose an email response inside the box below based on the information below. When you are done, please let us know.
Emails have been sent out periodically over the last month encouraging people to take the state employee survey. It has included a link to the survey (www.fauxsurvey.survey) and encouraging words about the importance of the survey from the executive director and the division director.
There has been a very low response rate – only 12 percent of employees have taken the survey. You have been asked to send one last email to encourage people in your unit to take the survey – even though it is not mandatory. Below is some information you can draw from for your email.
Survey is open until November 30 at 5 p.m.
There will be a drawing for a $100 gift certificate that will include everyone who has taken the survey.
The survey is anonymous.
ASSESSMENT #3:
Proofreading
INSTRUCTIONS: Proofread letter below and make the necessary corrections.
February 18, 2020
Mr. Logan Article
678 Random Street
Someplace, CA 76886
Dear Mr. Article,
I am contacting you in order to to discuss a non-disclosure agreeement signed on January 5, 2018. It has come to our attention that agreement with the Washington Company (WC) has recently been breeched.
You have violated this contract in the following ways: Section 4A states that your will not disclose any information about the Washington Company to anyone outside of the company any reason whatssoever, including company documents in any form (original versions, copies, faxes, and digital versions, etc.).
However, as of February 10, 2020, it was brought to our attention that you had disclosed a Washington Company document to an outside sorce. Since this document was considered company information and disclosed in digital form a company outsider, this contract has therefore been breached.
The Washignton Company is requesting your attendance at a contract breach hearing on Wednesday, February 20, 2013 at 12:00 p.m. in Board Room A. Please let me know as soon as possible via email if you will be able to attend. Until then, you’re are suspended from company’s property and will be unable to accesss your company phone or email.
Sincerely,
Megan R. Lowe
Commisssioner
Attachments Enclosed
ASSESSMENT #4
Math Exercise
Please check the math below using the calculator provided. You may write on this paper and make notes as you feel appropriate. When you are done, please just give the hard copy back to the EMD representative. Thank you!
| Due Date | Previous Balance | Current Charges | Late Charges | Payments | Total Due | |
| 7/26/15 | 8/16/2015 | $49.26 | $73.22 | $122.48 | ||
| 8/10/15 | $122.48 | $1.07 | $123.55 | |||
| 8/27/15 | 9/15/2015 | $123.55 | $56.74 | $180.29 | ||
| 8/31/15 | $180.29 | $0.11 | $180.40 | |||
| 9/15/15 | $180.40 | $80.00 | $130.40 | |||
| 9/27/15 | 10/16/2015 | $130.40 | $98.33 | $228.73 | ||
| 9/30/15 | $228.73 | $0.67 | $229.40 | |||
| 10/26/15 | 11/16/2015 | $229.40 | $102.69 | $332.09 | ||
| 10/31/15 | $332.09 | $1.66 | $333.75 | |||
| 11/2/15 | $333.75 | $186.00 | $256.75 | |||
| 11/29/15 | 12/16/2015 | $256.75 | $105.23 | $361.98 | ||
| TOTAL DUE | $361.98 |
