4. Research Job Outlook and Calculate Average Rates of Growth
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. Choosinga career with a good outlook means that there may be an increasing number of jobs availablein 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 inspecific fields over the coming years. You can find this information by doing an internetsearch for the “Occupational Outlook Handbook.”
As you consider career paths, the number of jobs that will be available in that fieldin the future may be important to you. In this video, you will add information aboutthe 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 couldsearch for “job outlook dental laboratory technician” or “projected growth rateparalegal.” 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. Growthprojections vary depending on the field, how long the job has existed, the economy, andmany other factors. In general, the higher the percentage, the more job openings youcan 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 anotherway to add formulas without rewriting them.
Copying the formula from one place to anotherautomatically updates the cell references, so you should double-check the copied formulato 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.