Microsoft Word Project (Due 5/6 before school)

Use DropBox (http://db.tt/1aeIYB8)

Click here for instructions on how to use DropBox.

Create Word document with the following:

• Well formatted title page (center title vertically and horizontally)
• Table of contents
• Content filled with lorum ipsum text
• Headings arranged apropriately (3 Heading 1, 6 Heading 2, 6 Heading 3)
• Page numbers starting on the second page formated as follows ("Page 3 of 7")
• A "Works Cited" page with fake works cited.
• There should be no extra line breaks, and all text should be formatted according to MLA format.

Excel Project (Due 3/11)

Download this spreadsheet.

Do all of the following. Make sure that you follow all of the guidelines.

Guidelines:

Each piece of data that you add to this spreadsheet should be calculated using a formula.

Each graph should be on a separate tab and have a title and labeled axes.

Format each spreadsheet and graph to look nice.

Each tab should be named appropriately ("Tab1" is not appropriate).

Name project with your name following this format: heath_project.xls and email to This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Requirements:

Using conditional formatting, highlight in red all <$10,000 incomes.

Sort data so that highest incomes are on top (make sure that the name stays with the income).

Add a columns that calculate the taxes using the following (all taxes are on total income after donations have been subtracted):

• <$20,000 - no tax
• Between $20,001 and $50,000 - 20% tax (on just the money over $20,000)
• All money over $50,000 - 40% tax (on just the money over $50,000)

On a separate tab calculate:

• The number of people who pay (use COUNTIF):
• • No tax
  • Normal tax
  • High tax
• The total amount of taxes paid
• The name of the person who paid the highest taxes (use MAX and VLOOKUP)
• The name of the person who gave highest charity
• The name of the person who had the lowest income
• The number of people who make (use COUNTIF):
  • <$10,000
  • >=$10,000 & <$30,000
  • >=$30,000 & <$50,000
  • >=$50,000 & <$75,000
  • >=$75,000 & <$100,000
  • >=$100,000 & <$1,000,000
  • >=$1,000,000
  • All of this data should also be displayed in a bar graph on a separate tab.
• The overall average income

1/14 Assignment (Due by 8am 1/21)

Download this spreadsheet.

Make sure your formatting is done well. Money should always have "$", and you should use borders to make the spreadsheet look nice.

1. Calculate the average house price for each town.
2. Calculate the max average house price and min average house price.
3. Add a column next to each town and calculate how much a 20% down payment would be for each house.

Email final project to Mr. Marvin ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it ).

Print final project on 1 page and put in Mr. Marvin's box outside his office.

1/7 Assignment

Create a spreadsheet that has the following information:

The name of each family member.

Their year of birth.

Their age in years (using a function to calculate)

Their age in days (based on how many years). You do not have to be exact. Just multiply their years * 365.25.

A box which shows the maximum age in days.

A box which shows the minimum age in days.

Email to This e-mail address is being protected from spambots. You need JavaScript enabled to view it before Friday, 1/14.

12/3 Classwork

Complete pages 548 - 571 with your partner. Use same 6-slide guideline for printing slides.

11/19 Class work

Download Lesson 1 files from here and save them to your desktop.

Use these files to complete the Exercises in your textbook from page 517-542. Switch with your partner each time you turn the page.

When instructed to print, print presentation with 6 slides per page.

In order to complete this assignment, Mr. Marvin must check all of your files.

ARCHIVES

Download .zip file from here and move the file to your desktop. It is called PPT_Lesson02.zip.

Once the file is on your Desktop, right click on the file and select "Extract" and extract the files to your desktop.

Use these files to complete the Exercises in your textbook from page 548 - 571. Switch with your partner each time you turn the page.

When instructed to print, print presentation with 6 slides per page.

3/16 Project (Due before class on 3/30)

Using this file (download here), complete the following and email to Mr. Marvin when complete.

• Save file as FIRSTNAME_census.xls
• On a separate tab called "Calculations"
  • Calculate the total number of people with income.
  • Using MAX, determine how many people are in the income level that has the most people in it in the "over 75" group.
  • Create a row showing how many people would be in each income level in the Western Region if the US was 1.5 times as large.

• This graph will have two lines on it.
• The X axis should be labeled with the income levels.
• The Y axis should be the number of people (in thousands).
• Do not include the $100,000+ category in your graph.

3/9 Class work

Complete exercises on pages 311-326.

The files that you need can be downloaded here.

If you miss class, you will need to make up this work on your own time.

3/2 Class work

Complete exercises on pages 282-297.

The files that you need can be downloaded here.

2/23 Class work

Complete exercises on pages 228 - 240 and 272 - 276.

The files that you need can be downloaded here.

Download the files that you need and move them to the desktop.