Using My Skills

Select Career

List 5 things about this career that you find appealing.

1.

2.

3.

4.

5.

What is the Skills Score that appears beside the career you selected?

Look through you responses to the skills that are important for this career and add up the number of responses of each type:

_____I am highly skilled

_____I am skilled

_____I have some skill

_____I don't have this skill

Write down the three skills to which you answered "I don't have this skill" or "I have some skill." For each skill you wrote down, think of three ways that you can increase your skill.

Are your still interested in the career you selected for this activity? Why or why not?

What do you think the difference is between interests and skills?

Do you think it is helpful to consider your skills when choosing a career? Why or why not?

Career Selector

Career Selector Choice:

Job Description
What do people in this career do?
What skills do people in this career have?

Working Conditions
Where do people in this career work?
What kind of hours do they work? Do they work days, nights, shifts, overtime, how many hours per week or day?

Interview Person Name:
Day in the Life
Three important work activities this person performs during the day
1.
2.
3.
Breakdown of Activities
Three activities this person spends the most time on
1.
2.
3.
Likes and Dislikes
What does this person like about the job?
What does this person dislike about the job?

What are three things that you think are good about this job?
1.
2.
3.
What are three things you think are bad about this job?
1.
2.
3.
Could you see yourself doing this job in the future? Why or why not?

Career Ideas

Select career of your choice and write three things that you think you would like about this career.

Career:
1.
2.
3.

Is the career you selected on the list of careers from the Career Matchmaker results?

What are three aspects of the selected career that you found surprising or unusual about this career? Why?
1.
2.
3.

How did your career selection choice match up with your interests?

Do you still think it is a good career choice for you? Why or why not?

Do you think interests are important for a career choice? Why or why not?

Career Matchmaker

First Career:
Suitable For You
What are the Central Aspects of this career?
What are the Central and Secondary Aspects to which you answered Like or Like Very Much?
Which Aspects did you answer Dislike or Dislike Very Much to?

Top Ten Career:
Suitable For You
Write down the Central and Secondary Aspects to which you answered Like or Like Very Much.

Your Career Choice:
Aspect:
Example:

Define Your Character

Learning Objective

Definitions
Character
Self-discovery

Video Debriefing
If your friends, family and teachers were asked to describe your character, what would they say?

Discuss & Reflect
Who would you say is a "person of character?" What positive character qualities does this person posses? What choices has this person made in the past that illustrate character?

Get Go
Ask your friends, family and teachers, how they would describe your character. Do their responses match with what you thought they would say?

My Character
Friends
Family
Teachers

Career Cruising-School Subjects & Careers

Subject:
H C U:
Career:

Job Description
What duties do people in this career have?
What skills do they have?

Education
What education and training do you need to enter this career?
What other qualifications are good to have?
Which college or other post high school programs are related to this career?

Person's Name
How did this person get into this career?
What does this person say about opportunities to get into this career?
What advice does this person have for people who want to get into this career?

Summary-Your Views
Do you think this is a tough career to get into? What is the most difficult part?
Would you be willing to complete the education and training necessary to work in this career? Why or why not?

Career Video

Teacher
*Young professionals should think about what issues that impact their jobs?
Firefighter
*1 What steps did he take to get the job he has now?
*2 How does he handle mistakes?
*3 What financial rewards does he receive from his job?
Coordinator of Fun
*4 What type of activities is she responsible for at her job?
*5 What skills learned in school are used in the job?
*6 How does she manage making it to work on time?
Network Specialist
*7 How have his interests and responsibilities in high school change now that he is working?
*8 What suggestions are offered how to deal with a situation when you are running late?
Welder
*9 What education did she get to secure her job?
*10 What benefits does she talk about getting from having a job?
Training Coordinator
*11 How does he describe what is acceptable and what is not acceptable in the work place?
*12 What is important about dress code?

2/17 Class Quiz and New Material

Today's quiz was ten items

Name the three parts of an IF function
1. The logic test
2. Value if true
3. Value if false

Name the steps to freeze a spreadsheet
1. Select the location to freeze
2. View tab
3. Window group
4. Freeze panes icon

What are the three options when freezing a spreadsheet
1. Freeze panes
2. Freeze 1st row
3. Freeze 1st column

Today are covered the third and fourth steps in creating a spreadsheet Formatting and Charts.

*Format Painter was used to copy the formatting of a selected cell to another cell.
*By using the control key we were able to select nonadjacent cells to format groups of cells all at once.
*Using a pie chart, we created a picture of the data in the spreadsheet in four steps

1. Select the cells with the data to be used in the chart
2. Click the Insert tab on the ribbon
3. Go to the Chart group
4. Select the type of chart
   

*The Chart Tools tab became available when the chart was selected allowing us to move the chart, edit the title, legend, and labels of the chart.

Class Notes 2/16 - Freeze, NOW, and & IF

Freezing panes, rows, and columns in spreadsheets allow you to always view selected portions of your spreadsheet.

Freeze
1. Select location - Select the portion of your spreadsheet that is to be frozen. Select the cell immediately below and to the right of the row and column you wish to freeze. In our example yesterday, we froze column A and rows 1,2,&3 so we selected cell B4.
2. View Tab - On the Ribbon, go to the View Tab
3. Window Group - In the View Tab, go to the Window Group
4. Freeze Panes - Click the arrow on the Freeze Panes icon

• Freeze Panes
• Freeze Top Row
• Freeze First Column

5. Unfreeze - Only available in the Freeze Panes arrow if portions of the spreadsheet are already frozen

NOW Function
=NOW()
The now function inputs the current date and time in the selected cell allowing user of the spreadsheet to know when it was created.
You can edit the appearance of the date and time generated by the NOW function by selecting the Number tab in the Format dialog box and then the Date catergory.

IF Function
=IF(logic test, value if true, value if false)
1. Logic test - The logic test is the question that you are asking. The example in class was if sales in January were more than or equal to the goal of $4,750,000.
2. Value if true - This is the value that will appear in the cell if the the logic test is true. If sales were more than or equal to $4,750,000, then the value of the bonus would be $100,000
3. Value if false - This is the value that will appear in the cell if the logic test is false. If sales did not reach $4,750,000, there would be no bonus, $0.
Since both the goal and the bonus were in our What If section of the spreadsheet, it was necessary to use absolute cell reference to refer to the the goal and bonus amounts.
=IF(b4>=$B$24, $B$19, 0)
By changing the values in B24 or B19 we can quickly change the projection report, allowing us to make business decisions based on new figures quickly.

Spreadsheet Critical Thinking

Excel allows you to change values in a worksheet quickly and easily.

*How is this helpful in running a business?

*How can changing values affect business decisions?

Although electronic spreadsheets were introduced less than 50 years ago, people have created spreadsheets by hand for hundreds of years.

*What are the advantages of creating an automated spreadsheet rather than a hand written one?

*How does the capability to recalculate automatically when values change, make an electronic spreadsheet more valuable than a spreadsheet created by hand?

Who isWarren Buffet?

Extra credit posting of who is Warren Buffet, what does he do, how does he relate to our lesson activity, and why is he important is due today before the start of class. Information found to be copied and pasted from websites will not receive credit.

Financial Spreadsheet Vocabulary 2/2 & 2/3

Director of Finance and Accounting
Semiannual
Projected
Gross Margin
Cost of Goods Sold
Expenses
Bonus
Commission
Marketing
Research and Development (R&D)
Support, General, and Administrative
Operating Income

Apple's iPad

This week, Apple announced their newest product, the iPad. Using the link below, read about and watch the information Apple released regarding the iPad. As a new posting on your blog, write a review of the new product including the highlight features, the new additions, availability and purchase information. Explain what you feel the possible impact this product will have on technology, society, education, and you personally. Your response must be well structured.

http://news.zdnet.com/2422-19178_22-387489.html

Current News Event Take 2

Over the weekend, take a few minutes to watch or read the news! You will be posting a summary and statement of importance on your blog before class on Monday. The following items are required.
1. Type of media (newspaper, internet, television) - Tell me from where or which media you chose to get your information.
2. Name of source (El Paso Times, KVIA, CNN, MSNBC, The Wall Street Journal) - Which newspaper, what website, which station?
3. When - What day and time did you watch or read the news story?
4. Subject or Title - The title of the news article or news program. Stories should be related to Business, Economy, Politics, Education, Technology
5. Summary - Summarize the details in complete sentences.
6. Importance - How is the story important to you?

Quick Quiz - Entering Functions

With Excel, you can enter functions using any of five methods. What are they? Write your response in complete sentences using the RATS process (R-restate, A-answer, T-text evidence, S-so what).

Stock Portfolio Spreadsheet Data & Formulas

Good morning and afternoon! Today you will be creating a spreadsheet which will be used to display information for a stock portfolio. The data is available in a table format as well as a sample of what the spreadsheet will look like on page EX89.

If you look closely you will see that the some of the text entered in row 3 appears different than the other rows. The text in row three is much longer than the data or numbers entered in the rows below. To get the text to appear on a new line in the same cell, press ALT + ENTER. This will automatically increase the height of the row to fit the multiple lines of text.

After you have entered all the data from the table, enter your name as the author and Silver Dollars Stock Club Portfolio Summary as the title in the document properties. Save your work as Silver Dollars Stock Club Portfolio Summary.

Formulas
The next step in developing the stock portfolio summary is to enter the formulas to calculate the following information:
Initial Cost
Current Value
Gain/Loss
Percent Gain/Loss

Using the column titles available in row 3 of your spreadsheet, describe how would you determine the Initial Cost, Current Value, Gain/Loss, and Percent Gain/Loss for a stock? After you have described how to determine the information provide the formulas that you would enter in cells F4, H4, I4, and J4. Please post your response as a new post on your blog.

Current News Event

I look forward to reading your posts regarding the news story you watched last night. Knowing about and understanding the events that are happened within your community, city, state, country and global environment are important to your development as a successful individual.