Resumes

Standard 8:  Use a word processing program to create and format documents with academic and business styles to communicate the results of research, meetings, lab reports, and relevant assignments in this course.

Opening Assignment

On your own sheet of paper list the following categories and complete any that apply to you:

• organizations
• interests (what is something constructive you like to do in your spare time?  not TV or hanging out with friends)
• volunteer work
• paid jobs
• GPA
• HHS Focus area
• Adults (other than family) that would be able to tell what a good person (hard-working, quality results) you are (list 3)

Resume Examples

James Buce

Monica Davis

Ben Ripperton

Jessica Davis

Template

Resume Notes

Click on the PowerPoint link to complete the resume notes.

Objective vs. Profile Statement

See this article to learn the new look at the old Objective statement

Guided Practice

Let's create a resume for James Local
Now let's create a different style resume for John Luke

Independent Practice 

Create a resume for yourself using the following categories:
Education
Career Interest
Electives Studied
Extra Curricular Activities
Skills
Volunteer Acitivities
Work Experience
References (3)

When complete email to me at julie6davis@gmail.com.  Put your "Resume + block" in the subject line.

Spreadsheet Formatting, Using Formulas and Functions

Standard 16:  Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including:  a) basic arithmetic calculations, b)basic mathematic functions (e.g. SUM, AVG, MIN, MAX), c) copying formulas that include both relative and absolute cell references d) sorting in ascending/descending order  e) filtering data to retrieve specific values f) basic conditional formatting (e.g., red for negative values)

Bell Work

Read the following article and write a paragraph on your own paper about the value of learning excel in this class.  The Key to a Good Paying Job is ... Microsoft Excel?

Guided Practice: Use Basic Formulas & Functions

Open the link to Independent Practice: Spreadsheet Formatting. (Technology Advancements)  Download (using Microsoft excel) and make a copy.  Rename sheet "GP Use Basic Formulas & Functions."  Follow along to enter data into a spreadsheet and perform simple calculations.  You will use operations and functions listed below.

• Addition, Subtraction, Multiplication, Division
• Average, Sum, Maximum, Minimum
• Absolute reference

Guided Practice: More Formatting

Open the GP More-Student spreadsheet. Download (using Microsoft excel) and make a copy and rename the spreadsheet "GP More Formatting."  Follow along to enter and format data and complete the following tasks:

• Format numbers and labels 
• Format borders 
• Insert and delete columns and rows
• Rename a spreadsheet
• Move a spreadsheet
• Use functions and formulas

To think about:
Why might a column need to be added or deleted?
Why might a spreadsheet need to be moved or renamed?

Independent Practice: Use Basic Functions

Open the GP Spreadsheet Formatting.  Download (using Microsoft excel) and make a copy and rename the spreadsheet "IP Use Basic Functions".  Follow the instructions from the worksheet to complete the spreadsheet accurately.  When complete send as an attachment in an email to julie6davis@gmail.com.

Intro to Excel

Standard 14) Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data.

Battleship!

Go to the following link to play a round of Battleship.

  

Spreadsheets!

We are going to start working with spreadsheets.  A spreadsheet is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.

See and example of a spreadsheet below:

As you can see it looks like a "Battleship" board game with each cell having coordinates to determine the location.  Let's look at some of the terms associated with spreadsheets. 

Click on the power point to see the presentation "Anatomy of a Spreadsheet" to complete the worksheet.

On the back of the worksheet, create the invoice at the top on Excel and complete the worksheet.

What do you think?

How are some ways that spreadsheets can help you in business or in your personal life?

Review

Go to Quizlet.com to practice the terms from today's lesson.