Why do employers deduct money from employees paychecks?
What is the money deducted from paychecks used for?
Objective: Students completed Excel It! Activity 10, 11 and 5. They continues exploring how to use formulas in Excel by completing Excel It! Activity 12. Click here for Activity 12 Instructions.
Reminder: You can create formulas using cell references by clicking in the cell where you want the result to be displayed, start your formula with an equal sign =, click on the cell you want to reference in your formula, enter the math operator (+, -, *, /)and enter a number or click on another cell to reference in your formula.
Assignment: Complete Activity 12 in the Excel It! book. Use this excel spreadsheet to begin Excel It Activity 12 Start File. You must enter lines 2-11 and 28-32. This assignment is due at the end of the period.
What symbol is used to start every mathematical formula in a spreadsheet?
What three functions did you use to analyze the data at the bottom of the spreadsheet in Activity 11?
What field did you sort by to alphabetize the list in Activity 10
What order did you sort the Total column by in Activity 11 to arrange the scores in descending order (A to Z or Z to A)?
Objective: Students will read and follow directions to complete Excel It! Activity 5. They will practice creating spreadsheet entries and sorting a table of data to arrange it in alphabetical order.
Classwork:
Complete Excel It! Activity 10 and 11 from last week and link them to your Google Classroom.
Students learn that in the current workforce, people change jobs or careers several times over a lifetime. That means it is important to be prepared and adaptable. Students explore which of their priorities should be their anchors as they prepare to enter the working world.
Objective: Students will practice a job interview today with volunteers from the community.
You will be graded on your interview skills by the volunteers interviewing you. They will fill out this Mock Interview Rubric it is worth 120 points. Read over the expectations and devise a strategy to achieve the maximum points in each category.
Be sure to get the name of the person interviewing you so you can write a thank you note after the interview. (This is worth 10 points of the total grade)
Following your interview you will complete a self-evaluation of your interview using this same form(yellow paper) (this is 10 points of the total grade.)
Assignment:
Prepare for Mock Interviews by finalizing and printing 2 copies of your resume.
Research one of these Job Ads to learn about the company in preparation for your interview.
Review the Mock Interview Evaluation form to determine what you need to do during the interview.
Review the Mock Interview Questions and prepare an answer for them. Turn this in before your interview.
Write a thank you note to your interviewer after your interview. (This is worth 10 points of the total grade)
Complete the interview self evaluation. (yellow sheet)(This is worth 10 points of the total grade)
Students will review soft skills that are in demand by employers and rate their own soft skills. They will use personal stories in a job-interview workshop to communicate these skills to a potential employer.
Mock Interview Practice
In groups of 2 practice the interview skills we have been discussing
Round 1
Choose who will be the interviewer and who will be interviewed.
The person being interviewed will shake hands and introduce themselves by saying “Hello my name is__________.”
The interviewer will ask which job the interview is for.
The person being interviewed will identify which of the three jobs they are interested in.
The interviewer will ask 3 or 4 questions and listen to the responses.
The person being interviewed will ask 1 or 2 questions about the job.
Print 2 copies of your Resume and Cover Letter for next class. Be sure to sign your Cover Letter in blue or black ink.
Homework: Practice your answers to the common interview questions in the mirror and with a friend or family member.
Come to the next class ready for Mock Interviews, dressed appropriately, research the company you are interviewing for and prepared to answer the common interview questions.
Do Now: Respond to the following in a Google Doc attached to the Google Classroom assignment. Write your response in a paragraph following the outline for 6 Trait Writing a Response. Be sure to use correct spelling, punctuation and capitalization.
Describe two interview tips and how they will help you in an interview.
What part of an interview do you think will be the most difficult?
What part of an interview do you think will be the easiest?
Objective: Students will explore what to expect in a job interview and how to respond to interview questions by using the STAR method to formulate a response to open-ended questions, evaluating a job description to identify the key skills required and developing answers to commonly asked interview questions.
Do Now: Respond Google Classroom in the form of a paragraph with a topic sentence, responses to the questions and a concluding sentence. Be sure to use correct spelling, capitalization and punctuation.
What is a spreadsheet used for?
How have you used a spreadsheet in the past?
When do you think you might use a spreadsheet in the future?
Objective: Students will read to follow directions in the Excel It! Activity 10 and 11 to learn how to enter mathematical formula in a spreadsheet and to alphabetize and sort numerical data.
Assignment: Complete Activities 10 & 11 in Excel It! This is due at the end of the period on Friday April 15, 2016.
Excel It! Activity 10 Instructions
Use this Excel It Activity 10 Start File to begin Activity 10. Make a copy that you can edit. You will need to enter the title, headings and the last two rows of data. Follow these directions to correctly format the spreadsheet and enter formulas. Turn in your finished spreadsheet to the Google Classroom Assignment.
Excel It! Activity 11 Instructions
Use your finished spreadsheet from Activity 10 to begin Activity 11. Use the File>Make a Copy command to rename your spreadsheet SAT SCORES 2. Follow these directions to add additional formulas and sort the data. Link your finished spreadsheet to the Google Classroom Assignment.
A resume cover letter is an introduction of your skills and experiences to a prospective hiring manager. The purpose is to personalize your resume and to highlight the items that are a good fit for the job your are applying to.
Objective: Students will learn how to write and revise a cover letter for their resume demonstrating proper business vocabulary and business letter formatting using:
examples of cover letters
cover letter graphic organizer
Word It! Activity 24 p. 54
partner feedback
Cover Letter rubric
Google Docs spelling and grammar check
Students will watch the video on Cover Letter Tips.
Choose one of theseJob Ads and prepare the a cover letter organizer using what you learned about effective cover letters to submit on one of the job ads.
Mock Interviews are scheduled for April 21 & 22, 2016. Remember to have a copy of your resume to take with you and remember to dress appropriately for an interview.
You will be graded on your interview skills by the volunteers interviewing you. They will fill out thisGoodwill Mock Interview Evaluation, it is worth 25 points. Read over the expectations and devise a strategy to achieve the maximum points in each category.
Following your interview you will complete a self-evaluation of your interview using this same form (this is 5 points of the total grade.)
Homework Assignment:
Prepare for Mock Interviews by finalizing and printing 3 copies of your resume and cover letter.
The job you will be interviewing for is with one of these three Job Ads . Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.
Students practice collaboration—a 4Cs skill—by using a team-building model referred to as the GRPI model (Goals, Roles and Responsibilities, Processes, and Interpersonal Relationship Skills). The model describes the behaviors found in high-performance teams in the workplace.
JFK High School of Business 