BUS 311 Section 4
Homework Assignment 2
Office Review Homework

Part I: Word for Windows

Title

The word “Title” above is a title. Make it centered, 24-point boldface Arial, 24 points before it, 12 points after it. Indent this paragraph a half inch left and right. Make this paragraph one-and-a-half-spaced. Italicize the initial word in this sentence.

This is another paragraph. Make it double-spaced, 18-point Arial. You will replace this sentence. Choose any sentence toreplace it. Switch the following two words: Dumpty Humpty.

Change the margins in this document. Make the margins one inch on the top, bottom, and left. Make it two inches on the right. After this paragraph, start a new page with a hard page break.

For the previous paragraph, insert a comment for the word, “top”. The comment should have your name. Make this paragraph one and a half spaced.

Insert a table with three columns and four rows. Make the first column 2 inches wide and left justified. Make the other columns 1 inch wide and right justified. Enter text into the first column and numbers into the next two columns.Properly align the header row entries. (underlined added)

Insert a header and footer. The header should have your full name, centered. The footer should right-justified and have “Page #/*” without the quotations, and with the # being the page number and * being the number of pages in the document. The header and footer should not appear on the first page.

Print just this paragraph and the previous paragraph.

Go to the next page.

Part II: PowerPoint

General Requirements

Create a six-slide PowerPoint presentation on a topic of your choosing. The content does not have to make sense, but formatting is important. Kind of like television.

Description
Apply a design template to your presentation.
Each slide but the first should have a header and footer. The header should only have your name, flush right. The footer should have the page number. This page number should be 24-point text. The first should not have a page number.
When you print a handout, it should have six slides per page. There should be a header with your name and a footer with “BUS 311 Section 4 Office Homework”.
On each slide except the title slide, there should be a footer with the page number and the footer, BUS 311 Section 4 Office Homework. (Underlined material added.)

Broad Description

Create a six-slice PowerPoint presentation on a topic of your choosing. The content does not have to make sense, but formatting is important. Kind of like television.

Slide 1 / Description
1 / This should be a title slide. Choose your own title. The subtitle should be your name, a slash, and then Section 4.
2 / You second slide should contain three or four bullet points. The first bullet point should have two sub-bullet points.
3 / The third slide should contain Office clip art as well as text.
4 / The fourth slide should contain and inserted image from file as well as text.
5 / The fifth slide should contain a figure you draw out of lines, boxes, arrows, and other PowerPoint graphics elements, as well as text. For each item, you should enter text. For instance, in a circle or ellipse, enter “Puppy” or anything else.
6 / In the sixth slide, create a table. It should have four columns and three rows. The first row should be a header row. Enter information in it.Align your header entries properly. (underlined material added.)

Go to the next page.

Part III: Excel

Create an Excel Model

You will create an Excel model to do the following task.

Your company builds walls. You are to build a spreadsheet model to help your company create a bid to build a wall. You will offer two options—lava rock or brick. Both walls will be built by crews of two. Crews will work three eight-hour days to build either type of wall. The wall will be 20 feet long, 6 feet tall, and 2 feet thick. Wages will be $10 per hour per person. You will have to add 20% to wages to cover fringe benefits. Lava rock will cost $3 per cubic foot. Brick will cost $2 per cubic foot. Your bid must add a profit margin of 30% to your expected cost.

Specifics

Do the following (again, the goal is to exercise formatting, not to look pretty)

Put your name in Cell A1.
Put “BUS 311 Section 4, Office Homework” in Cell A2.
Use at least two different fonts, and have some boldface and italics.
Apply a border to the region around you analysis.
Adjust column widths appropriately.
Color the cell or cells containing your final answers in yellow.
Set the print area to include your model but not Cells A1 and A2.
In Sheet 2, go to Cell A1 Enter the day of your birth, but not the month or year. In Cell B2, create a formula that multiples the contents of Cell A1 by your bid for Lava Rock on the previous sheet. There should only be cell references in the formula.
For Sheet 1, there should be a header and footer that appear when you print the sheet. There should be a header with your name and a footer with “BUS 311 Section 4 Office Homework”.

Note: Use good practice.

Your logic should flow from top to bottom and as far as possible from left to right.

Column headings should be properly aligned.

Equations should contain cell references but no numbers.

Go to the next page.

Part III: Excel (Continued)

Paste Your Spreadsheet Model Here:

In Excel, create a simple bar chart. Paste it here:

Continue on the next page.

Deliverables

When you have a project, the deliverables are what you must deliver (duh). Be sure you know what the deliverables are.

You Will Send an E-mail to Your Teacher
Send the e-mail to .
The subject line will have “BUS 311 Sec. 1 Office HW”.
The body should contain your name.
There should be three attachments.
The first attachment should be this file. Before you attach it, rename it “Office yourname”.
The second attachment should be your PowerPoint file. Before you attach it, rename it “PowerPointyourname”.
The third attachment should be your Excel file. Before you attach it, rename it “Excelyourname”.