In this video, you will research the job outlook for the careers on your spreadsheet.
Job outlook shows how much a field is likely to grow and produce more jobs over time. Choosing
a career with a good outlook means that there may be an increasing number of jobs available
in that field in the future.
One way to find information about job outlook is through the U.S. Bureau of Labor Statistics.
The BLS publishes information predicting how many jobs are likely to be available in
specific fields over the coming years. You can find this information by doing an internet
search for the “Occupational Outlook Handbook.”
As you consider career paths, the number of jobs that will be available in that field
in the future may be important to you. In this video, you will add information about
the job outlook for the careers you are researching to your spreadsheet.
Research the current job outlook for the first career on your list. For example, you could
search for “job outlook dental laboratory technician” or “projected growth rate
paralegal.” Be sure to use credible sources, such as the BLS or established news publications.
Add your sources and the percentage of growth each source predicts for that career. Growth
projections vary depending on the field, how long the job has existed, the economy, and
many other factors. In general, the higher the percentage, the more job openings you
can expect to find in that career over the next 5-10 years.
Type “Average” under your sources, and make it bold.
Copy and paste the AVERAGE formula you used to calculate the average salary. This is another
way to add formulas without rewriting them.
Copying the formula from one place to another
automatically updates the cell references, so you should double-check the copied formula
to confirm it includes the cells you want to average.
Then, repeat these steps to learn about the job outlook for additional careers.
Now, it’s your turn: Insert job growth percentages and sources,
Add an “Average” label under your sources and bold it,
Use a formula to calculate average job growth, And repeat these steps for additional careers.