Monday, January 20, 2014

Health Sciences Resume and Cover Letter Writing Exercise

In this unit, we will write a competitive resume and cover letter for a hypothetical person who is applying to two companies or clinics in the health sciences field.  You can choose from one of three candidates:

    - Stanley Lee an aspiring dentist
     -  Michelle Barnes physical trainer and 
    - Eric Neville, a registered nurse 

 Each candidate is on a specific health sciences career path.  

There are two companies listed for each of the three career paths.  So, there are three applicants/candidates and six companies in all.  

Your goal is to write 1 resume on behalf of one of these candidates and 2 cover letters to the two companies listed in that career path.

When writing resumes and cover letters - with the goal of securing a job in a particular field - you are trying to convince the person in charge of hiring that you are the candidate with the best skills, experience, goals and passion required for the job.  Ultimately, it is a marriage of your skills and goals with the goals and needs of the company hiring.  The Venn diagram above is a graphic representation of this marriage.

To complete this assignment, and for a listing of the 3 candidate's bios and descriptions of all 6 companies, please click on this link.

To access a Powerpoint presentation entitled, Resume and Cover Letter Writing Tips, please click on this link.

For a sample resume template, please click on this link.

For 2 sample cover letters, please click on this link.

For the cover letter revision exercise, please click on this link.


Great Resume Action Verbs
Assist
Able
Action
Analysis
Achievement
Accomplished
Advanced
Conduct
Consult
Committed
Conducted
Contributed
Coordinated
Delegated
Develop
Deliver
Design
Defined
Diversified
Devoted
Distinguished
Encourage
Earned
Enhance
Evaluate
Examined
Facilitate
Formulate
Fulfilled
Forecasted
Generated
Gained
Gathered
Gave
Headed
Hosted
Identified
Implemented
Improved
Improvised
Influenced
Launched
Lobbied
Maintained
Managed
Marketed
Maximized
Mediated
Modernized
Motivated
Negotiated
Observed
Obtained
Operated
Organized
Originated
Overhauled
Oversaw
Participated
Performed
Pioneered
Planned
Prepared
Presented
Promoted
Provided
Published
Pursued
Quantified
Ranked
Received
Recommended
Redesigned
Reengineered
Reorganized
Represented
Restructured
Revised
Safeguarded
Secured
Selected
Specified
Spearheaded
Standardized
Strengthened
Structured
Suggested
Superseded
Supervised
Targeted
Taught
Tested
Trained
Transcended
Unified
Upgraded
Utilized
Validated
Valued
Wrote





    Cover Letter Worksheet


I am___________
Because I_______
What this means for your firm (benefits)
reliable
Try to stay healthy
You can count on me to be there when you need me
A good communicator
Listen and try to understand people’s needs
You have a valuable worker who will help make the office a happier and more harmonious place to work
A skilled word processor and writer
Completed an MS Word course at Hyde and enjoy reading
You get a highly productive and efficient online reporter from day one – few spelling and grammatical errors
Online research analyst
Completed a computer tech course that focused on using google keyword searches
You get a savvy researcher who can save the company lots of time in discovering new ways to solve problems























Monday, January 13, 2014

Mid-term Review Quiz



There are 2 parts to the Mid-term review quiz.  Part 1 has 20 questions in a Word document file and Part 2 is comprised of 5 short Excel questions.  So there are 25 questions in all and each question is worth 4 points.  

Before the quiz starts, you will be assigned a number - either 1, 2 or 3.  This determines which version of the quiz you will take.  All 3 versions are identical in terms of level of difficulty, but they are comprised of different questions.  

If you are assigned the number 2, for example, you must click and download version 2 of both the Word doc and Excel files for the quiz.  The links for each version appear below. 

Part 1 - Short answer, multiple choice, true/false, table fill-ins that appear in the following Word document files.

 Mid-term_Word_01

 Mid-term_Word_02

 Mid-term_Word_03


Part 2 - 5 short Excel spreadsheet problems

Mid-term_Excel_01

Mid-term_Excel_02

Mid-term_Excel_03

When you are done with both parts, please attach BOTH the Word and the Excel file to a Gmail with your First and Last Name and send it as usual to rwiegs@gmail.com 

For example:   Send both Mid-term_Word_02_JohnSmith.doc  

                    and          Mid-term_Excel_02_JohnSmith.xls 

                        as attachments to rwiegs@gmail.com


If you have any questions about the quiz, please ask.

When you are done with the quiz, you must remain quiet so as not to disturb your fellow students still taking the quiz.  

You may use this extra time to catch up on any outstanding assignments that you may have.

GOOD LUCK!





Wednesday, January 8, 2014

Mid-term review topics and questions

We will have a mid-term quiz next Tuesday and Wednesday for Computer Tech Ed class.


The following topics and questions will be covered:


Program Questions
GMail Cc, Bcc   - when would you use these features?
Word Be able to create a table with column and row headers
Powerpoint What feature would you use to make text fly into and onto a slide?

Be able to create a slide or two which imports an image, 
has interesting font style (color, size) and that meets
our standards for how to give a good presentation
Create a slide that summarizes 5 key points of giving a good presentation.

Excel Short problems: apply % Change, %markup and % discount formulas
How much max rent as % of monthly income?
How can you distinguish between a formula cell and a constant cell?
Use Excel Date and Time functions to calculate # days to the Super Bowl.
Tech Terms
Identify Google hottest trends right now.
Google Maps - how many minutes by car from New Haven Green to the Hyde School?
Explain what Cyber Monday and Black Friday are.
Explain the difference between brick and mortar retail sales vs online sales.
What is DTCI and which web site can you go to to calculate it?
Which web site would you recommend to get nutritional facts?
Big Picture Questions
Create a table in Excel or Word and tell me when you would 
use Word vs Powerpoint vs Excel.
What is each program best suited for? Give examples.
For which tasks would you use them?
Icon comparitive checklist - which icons are found EXCLUSIVELY in 
Excel vs Word vs PPT
Which icons are found in ALL 3 programs?
Which program has a built-in dictionary and thesaurus?
Which program is best for graphic design in your opinion
(Excel, Word, or PPT) Why?