Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

4. Research Job Outlook and Calculate Average Rates of Growth

Playback Speed:
Transcript

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.

Instructions

  1. Insert job growth percentages and sources.
  2. Add an "Average" label under your sources and bold it.
  3. Use a formula to calculate average job growth.
  4. Repeat these steps for additional careers.