Career Database

Career Database

Objectives

• • Students will be able to create a database using Microsoft Access.

  • Students will create a chart using a web based program.

  • Students will be able to understand database terminology.

I can create a database based on researched information about careers. 

METS

• TC.4- Know how to create and use various functions available in a database.

• TC.6- Use accurate technology terminology.

• TC.7- Use technology to identify and explore various occupations or careers.

• CT.1- Use databases to make predictions and to assist with problem solving.

• RI.1- Use a variety of digital resources to locate information.

• CI.2- Create an original project to present information.

I Plan To Use the System As a: Student

 Type your first name

What Are You Attending:  K-12

 State: Michigan

School Name:  Oakley W Best Middle School

 After creating your account:

1. Click on I Want To (on the top of the page)

2. Interest Profiler

3. Click Go next to "Start a New Interest Profiler"

4. Read the Instructions and click on Next

5. Click on Begin to complete the Career Interest survey. **This survey is 180 questions long, please be sure to read and answer each question to get accurate results.

6. After completing the survey, click "View Occupations"

7. Continue to Career Selection

8. Click on the links to find out more information about specific careers.

9. You will need to choose 3 careers that are of interest to you. You will be researching each career.

 Step 2- Job Characteristics 

Using the results from the Career Interest Self Assessment you just took, you will choose 5 careers of interest to you that you will research. At least 3 careers MUST be chosen from the Career Interest Self Assessment. You may then choose to research 2 careers of your choice (or you can continue to use your Career Self Assessment).  You will research each of the 5 careers (total) that you chose using the results of your Career Interest Self Assessment. The careers that are best suited for you will be found underneath the View Occupations tab, you can then click on each occupation and get the information needed for your database.  

To help you with your research, complete the Job Characteristics Worksheet

using the information that you collect from the websites above. 

Step 3- Creating a Career Database Table

Instructions:

Using the research you collected on the 3 careers that most interest you, you will now create a Career Database table. Follow the directions below to create your Career Database.

    1.      Launch Microsoft Access, select Blank database

    2.    Click on File-> Save & save your Table as Careers to your Documents folder. 

    3. Click on the field Add New Field (to the right of Id) and select Short Text then name the field, Career Name and then tab to the next field. Continue doing this until you have field names for all of the following below.     

5. Using your Job Characteristics Worksheet, enter information about the 3 careers you researched into your table. 

6. When you have completed your 3 career records in the database, Select Save As and name your database Careers to your Documents folder.

7. Select All (CTRL+A) and Copy (CTRL+C) your entire CareerTable

Adding Your Career Database to

 Your Electronic Portfolio

• Log into your Electronic Portfolio and Create a New Page. 

• Name this page Career Database 

• Copy your entire table of careers (Edit->Select All) and paste it (Ctrl +V)  onto your Career Database web page.  

• Click Save

Adding Your Career Database to the Sidebar 

on Your Electronic Portfolio

Follow the directions below to do this:

• Click Save (top right of your page)

• Click on the button on the top right of the page that looks like a gear (More Actions Menu) and select Edit Site Layout

• Click My Links on your Sidebar on the left side of your website.

• Select Add Page

• Locate your Career Database page and select it.                         

• Click OK, OK, Close

Step 4- Creating a Graph 

Comparing Your 5 Careers By Salary

• Using your Career Database table and/or the Occupational Outlook Handbook, calculate the average salary of each of the 5 careers that you researched. Use Chart Go to create a graph that compares your top 3 careers based each career's salary.

• Once you have calculated the average salary on the 5 careers that you chose to research, go to Chart Go and follow the directions below.

• Chart Settings:

                * Chart Type: Bar

                * Chart Title: Career Database Salary Comparison

                * X Title: Career 

                * Y Title: Salary **You should record the AVERAGE salary and will only list ONE salary for each career   researched.

*The rest of the information can be modified to whatever you would like or it can be left as is.

Chart Data: 

• Delete all of the X Axis Data and enter the 3 careers that you selected to research.

• Delete all of the Y Axis Data and enter the average salary for each career (in the same order as the careers you entered in the X Axis Data Box). **Do NOT include the $dollar signs$ in each calculated salary.  

• Click Create Chart

• Once your chart loads, look over your chart to make sure that there aren't any errors (including spelling and/or grammar errors).

• Right click on your chart and click on Save Image As and save your chart to your Downloads/Documents folder. 

Adding Your Career Salary Chart to Your Electronic Portfolio 

§   Log into your Electronic Portfolio and open your Career Database page (it should be on your sidebar).

§   Click on Edit (upper right corner)

§  Select Insert->Image and select your Career Salary Chart Image (this should be located in your Downloads folder)

§  Resize and align your chart so that it is easy to read, but goes well with the orientation of your Career Database.

§ Click on Save