Third Quarter - Excel and EOFC Project
This Third Quarter we will continue with a few more Excel Exercises and then (after the Winter Break) we will start the "Exploring Our Future Careers (EOFC) Project."
On Monday, February 13, 2012 you will create an exercise similar to the Excel Exercise No. 5 (BSC Ex 05). You can work in groups of two (but each student has to create this exercise). You will go to the following websites and do some research on the 15 highest paying jobs in 2011. You will visit: Jobs 1 and Jobs 2 (click on these links) and copy the data for Average Annual Salary and Current Employment into an Excel Workbook (use the cnbc.com site for gathering your data). You will create a Table (Spreadsheet) on Sheet 1 with the following information: Jobs, Average Annual Salary and Current Employment and enter the necessary information there. Your table must have a Main Title and Subtitles. Enter the data, format the numbers properly (Currency - No Decimals), and Sort the information from Largest to Lowest Salary (unless you already entered the information this way). Copy this table (all the information on Sheet 1) and paste it on Sheet 2 (you need it on Sheet 2 to create a Pie Chart there later).
Create a Column Chart on Sheet 1 of the 6 highest paying jobs only (highest Average Annual Salary). The Column Chart should have a main title and Axes Labels (title for y axis and title for x axis), also add Data Labels (to view the salaries on top of the columns). Then go to Sheet 2, Sort the information on Current Employment from Largest to Smallest (select all columns to do the sort) and create a Pie Chart with the Current Employment Data of the 6 Careers that employ the most people in the USA (the Pie Chart should have Data Labels - Values and Percentages). Enter your Name and Period Number in the Footer and the Today's Date formula under the tables (Sheet 1 and Sheet 2). Put the Charts below the tables (on Sheet 1 and Sheet 2) and print the worksheets for Mrs. Feld (with your Name, Period No. in the Footer of both worksheets). Change the margins if necessary, so that everything looks centered nicely on the page (good presentation). If you have any questions, please feel free to ask Mrs. Feld.
EOFC Project:
Mrs. Feld will give you a handout and explain the project. Please read the instructions carefully and spend a good amount of time researching the type of careers you think you'll be interested in pursuing in your future.
Goal: to do some research about possible future careers. Students should select at least six “possible” future careers (even if it’s different careers in just one field, e.g. Healthcare). Each field of interest has many different possibilities.
You will work individually for this project (it is not a “group project” – but you can help each other while you’re working on it).
The websites to check are: http://www.bls.gov/. From this site you can also go to: www.bls.gov/k12/index.htm, www.bls.gov/k12/azlist.htm, http://www.bls.gov/oco/home.htm (Check the Occupational Outlook Handbook, OOH 2010-2011). You can also check: http://www.bls.gov/oes/2008/may/oes_alph.htm for an alphabetical list of careers. You can also go back to the links above (Jobs 1 and Jobs 2) for more information.
Other good sites are:
http://www.usnews.com, http://www.princetonreview.com/careers-after-college.aspx www.jobbankinfo.org/ (Explore Careers, Browse Occupations, Salary Information) www.careerbuilder.com/ careerpath.com/defaultb.asp www.monster.com/.
You will also create Excel Worksheets and Excel Charts and then a PowerPoint Presentation explaining the careers chosen, including the Excel Tables and Charts.
If you have any questions, please feel free to ask Mrs. Feld.
“All our dreams can come true, if we have the courage to pursue them.”
~ Walt Disney
“Be courageous! Dare to explore what you love and what is most important to you. Don’t waste time assessing yourself as you are now. Dream and plan for who you want to be in the future.”
~ Betty Jo Matzinger Lash, Associate Director, Georgetown University Career Center
“When looking for any position, I look for people who have a grasp of computers and good communication skills. I also look for people who can work well with others, adapt easily to change, and be creative when looking for new ways to do things.”
~ Debbie Bornholdt, Human Resource Manager QVC, Electronic Retailer West Chester, PA
On Monday, February 13, 2012 you will create an exercise similar to the Excel Exercise No. 5 (BSC Ex 05). You can work in groups of two (but each student has to create this exercise). You will go to the following websites and do some research on the 15 highest paying jobs in 2011. You will visit: Jobs 1 and Jobs 2 (click on these links) and copy the data for Average Annual Salary and Current Employment into an Excel Workbook (use the cnbc.com site for gathering your data). You will create a Table (Spreadsheet) on Sheet 1 with the following information: Jobs, Average Annual Salary and Current Employment and enter the necessary information there. Your table must have a Main Title and Subtitles. Enter the data, format the numbers properly (Currency - No Decimals), and Sort the information from Largest to Lowest Salary (unless you already entered the information this way). Copy this table (all the information on Sheet 1) and paste it on Sheet 2 (you need it on Sheet 2 to create a Pie Chart there later).
Create a Column Chart on Sheet 1 of the 6 highest paying jobs only (highest Average Annual Salary). The Column Chart should have a main title and Axes Labels (title for y axis and title for x axis), also add Data Labels (to view the salaries on top of the columns). Then go to Sheet 2, Sort the information on Current Employment from Largest to Smallest (select all columns to do the sort) and create a Pie Chart with the Current Employment Data of the 6 Careers that employ the most people in the USA (the Pie Chart should have Data Labels - Values and Percentages). Enter your Name and Period Number in the Footer and the Today's Date formula under the tables (Sheet 1 and Sheet 2). Put the Charts below the tables (on Sheet 1 and Sheet 2) and print the worksheets for Mrs. Feld (with your Name, Period No. in the Footer of both worksheets). Change the margins if necessary, so that everything looks centered nicely on the page (good presentation). If you have any questions, please feel free to ask Mrs. Feld.
EOFC Project:
Mrs. Feld will give you a handout and explain the project. Please read the instructions carefully and spend a good amount of time researching the type of careers you think you'll be interested in pursuing in your future.
Goal: to do some research about possible future careers. Students should select at least six “possible” future careers (even if it’s different careers in just one field, e.g. Healthcare). Each field of interest has many different possibilities.
You will work individually for this project (it is not a “group project” – but you can help each other while you’re working on it).
The websites to check are: http://www.bls.gov/. From this site you can also go to: www.bls.gov/k12/index.htm, www.bls.gov/k12/azlist.htm, http://www.bls.gov/oco/home.htm (Check the Occupational Outlook Handbook, OOH 2010-2011). You can also check: http://www.bls.gov/oes/2008/may/oes_alph.htm for an alphabetical list of careers. You can also go back to the links above (Jobs 1 and Jobs 2) for more information.
Other good sites are:
http://www.usnews.com, http://www.princetonreview.com/careers-after-college.aspx www.jobbankinfo.org/ (Explore Careers, Browse Occupations, Salary Information) www.careerbuilder.com/ careerpath.com/defaultb.asp www.monster.com/.
Take a personality test at: TEST (click the word TEST for the link). This test is based on Carl Jung and Isabel Briggs Myers typological approach to personality. You can also try QUIZ. This quiz will help you understand your inner self. Why you behave or make certain decisions. Whether you're doing research on career paths or trying to understand your relationship with others, or just trying to make sense of the world - this quiz will help you get to know yourself better. To analyze your psychological type profile check: http://typelogic.com. Also, in Google you could enter your personality type e.g. "ENFP careers" and check different websites suggesting careers for you. This is just to help you get ideas on careers.
The Word Document - with a brief description of your careers and with information on the Average Annual Salary and an Estimate on the number of jobs available (Current Employment) for that profession in the United States (or locally, if you prefer to select a particular city or state) - is due: Friday, March 9, 2012. Please: no more than two pages long. You will save it in the Server (don't print!).You will also create Excel Worksheets and Excel Charts and then a PowerPoint Presentation explaining the careers chosen, including the Excel Tables and Charts.
If you have any questions, please feel free to ask Mrs. Feld.
“All our dreams can come true, if we have the courage to pursue them.”
~ Walt Disney
“Be courageous! Dare to explore what you love and what is most important to you. Don’t waste time assessing yourself as you are now. Dream and plan for who you want to be in the future.”
~ Betty Jo Matzinger Lash, Associate Director, Georgetown University Career Center
“When looking for any position, I look for people who have a grasp of computers and good communication skills. I also look for people who can work well with others, adapt easily to change, and be creative when looking for new ways to do things.”
~ Debbie Bornholdt, Human Resource Manager QVC, Electronic Retailer West Chester, PA
posted by Karol B. Feld at
6:07 PM
0 Comments:
Post a Comment
<< Home