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.

Research Report

Standard 8:  Use a word processing program to create and format docs with academic and business styles (business letters)...

Research papers are documents in which you research books, magazines, articles and other sources to determine your own thesis and thoughts that will be helpful and informational to the reader.

 Remember! Plagiarism is stealing and is illegal.  You must use your own thoughts and words developed after extensive research on your topic.

Your instructors may give you specific requests for a paper due to them.

Let's look at a sample research report:

Sample Research Report

Use the linked slide presentation to complete the Notes 

For Works Cited formatting details, click the link.

Checklist

Guided Practice

Click on this link so we can work together formatting a research report.

Independent Practice

Let's start formatting!  Click on the link to open a complete report that needs to be formatted correctly.  Remember you will need to make a copy so that you will be able to edit.

When your formatting is complete (using the provided checklist) share with me at julie6davis@gmail.com.

To get more practice, open the link below.  Click "file" and "make a copy".  Insert your name in the doc title.

More formatting practice!

Business Letters and Personal Business Letters

Standard 8:  Use a word processing program to create and format docs with academic and business styles (business letters)...

What's the difference between a business letter and a personal business letter?

 A business letter is formal communication that is sent from a business and may have preprinted letterhead at the header and/or footer of the page.

A personal business letter is formal communication sent by an individual (without header/logo preprinted as header or footer) to an individual or business.


PowerPoint - Business Letter Notes
Personal Business Letter Notes

More on Punctuation

Open vs closed (mixed)

 

Let's try it!

The template for the Business Letter can be found in the keyboarding textbook on page 177.

Guided Practice:  Complete the Business letter on page 177

Independent Practice:  Complete the three business letters on page 183 using the text in the main part of the page as the body of the letter.  Carefully follow instructions in the left (yellow) margin for specific instructions for each letter.  When you complete the first letter insert a page break (or press enter until it begins the next page) to begin the following letters.  This allows for all three to be just one doc sent to me.  Email to me as an attachment to my gmail @ julie6davis@gmail.com.  The email subject line should read "Business Letters."

The template for the Personal Business Letter can be found in the keyboarding textbook on page 78.

Guided Practice:  Complete the Personal Business letter on page 78.

Independent Practice:  Complete the personal business letter 2 on page 81.  In the same doc complete the Personal business letter 1 on page 82 and letter 2 on page 83 using the text in the main part of the page as the body of the letter.  Carefully follow instructions in the left (yellow) margin for specific instructions for each letter.  When you complete the first letter insert a page break (or press enter until it begins the next page) to begin the following letters.  This allows for all three to be just one doc sent to me.  Email to me as an attachment to my gmail @ julie6davis@gmail.com.  The email subject line should read "Personal Business Letters."

Press Release

Standard 8:  Use Word to create and format documents with academic and business styles...

What is a press release?

Can news reporters always be present when something "news-worthy" happens?
Who will report if the newsperson is not available?

In any business or organization there may be some news-worthy happenings that you may need to write yourself and email to the media to see if they believe their audience would be interested in what you have reported on.

For Example:  If I own a dentist office and we get hire an extra dentist to our staff, the community might be interested in this information.

Or, if my company or organization collected warm coats for school children that needed them, that might be the kind of positive news that media might want to print or broadcast.

Writing press releases is part of the job description of public relations.

Remember!  Due to the ease of sending press releases via email, publishers receive an abundance of press releases, so yours needs to really stand out and grab their attention from the beginning!



See samples below for formatting guidelines:

HHS DECA Press Release Sample
Brownsville Press Release
Sample 2


Who produces a press release?
Who uses the press release?

Assignment:
Time to create your own press release!
Create a press release for one of the following topics...

1. Summer Experience
2. Start of School
3. Olympics or recent Tomcat game
4. An event of your choice (confirm topic with Mrs. Davis)

Create on a Google Doc and send as an attachment in an email to julie6davis@gmail.com

Grading Rubric for Press Release: 30 points Total
2 Points - FOR IMMEDIATE RELEASE
2 Points- Headline
2 Points - Location/Date

Lead Paragraph:
2 Points- Who?
2 Points- What?
2 Points- Where?
2 Points- When?
2 Points-Why?
2 Points- How?

2 Points - Supporting paragraph details
2 Points- Boiler Plate
2 Points- Contact Info (yours)
2 Points- ###
2 Points- Word count

Be sure to write in "Third Person" point of view.  Click this link to review:

Page Formatting

Standard 9:  Craft documents using word processing program features and methods such as.... margins, headers, footers, page numbers, and footnotes

Why is formatting applied to fonts?
What documents are commonly used in a business setting?
What are appropriate formatting guidelines for business documents and why is formatting important?
Which business document is the most appropriate means of communication in a given business situation and why?


Page Formatting is the arrangement of text on a page.  The arrangement of text on a page is the culmination of text and paragraph formatting that presents the final picture and communicates a message to the reader.

• Margin - the amount of white space around the sides of a document
• Page orientation - landscape (wider than tall) or portrait (taller than wide)
• Headers and footers add global information to a document such as page numbers and document titles
• Page breaks may be manual or automatic and are used to manage content on a page
• soft page break occurs automatically through word wrap feature of the word processing software and text is simply continued to the next page when the space on the previous page is exhausted
• hard page break is performed manually when a new page is needed for a break or change in content
• Columns are used to format text for documents such as newspapers and newsletters
• Borders are used in page formatting to add lines around text or graphic images

Click on the link for Guided Practice - Page Formatting.  Download the doc and enable editing to make changes. 

Now, do you think you can do it on your own?  Click on the Independent Practice - Page Formatting  Download the document and enable editing to make changes.  When finished, upload the doc to your drive and share with me at julie6davis@gmail.com.