Excel figure out a payment

Excel-figure out a payment

Hi everyone,

Today you will do some research on cars to figure out how much your car payments will be with different APR's.

1. Open up file car payment.  (should be on your desktop)

2.  Save file as carpayment_yourname

3.  Research cars and choose a car for under $10,000, one between $25-35,000, and one over $50,000

4.    Enter the year and type of car in column A accordingly.

5.  Enter the prices in column B accordingly.

6.  In cell C5, you will create a formula using the PMT function.  Here is the information you need to know in order to use it.

7.  Please search for an auto loan calculator on line to check to see if your payments calculated properly.

8. Figure out how much you pay in interest over the term of your loan for each payment.
You can accomplish this by taking the monthly payment multiplying it by the number of payments that must be made and subtracting that from the original price of the loan.

Nutritional Facts Assignment

Nutritional Facts Assignment 

What to do:

 Data collection

1. Drag the chart from our class folder to obtain nutritional facts file to work on the next activity. 
2. Gather research on 3 fast food restaurants of like foods.  Complete the nutritional facts on a typical meal you might purchase from one of the fast food restaurants.

Example
McDonalds Big Mac, Large Fries, Milkshake
Burger King Whopper, Large fries, milkshake
Wendy's double cheeseburger, large fries, milkshake

You can go to each restaurant's site individually or you can try www.nutritiondata.com .


3.  Save your file as nutritionfacts_yourname.

After data collection

After you have collected the data:

1. Use your knowledge of formulas to figure out the totals at the bottom of the spreadsheet.

2.  Create a graph or chart comparing the totals of the 3 restaurants.

3.    Visit the US dept of Agriculture to find out more healthy eating guidelines:
http://www.health.gov/dietaryguidelines/dga2010/DietaryGuidelines2010.pdf
Especially the executive summary viii-xi and page 14 of the document. Feel free to check out some of the tools to use to track calories and nutrition.

4.  Using Microsoft word, type a three paragraph report about your findings.

  a.  Paragraph 1- Introduction including which restaurants you chose and the items on your menu.

  b.  Paragraph 2- Summarize your findings about your meal including number of calories, percentage of fat, etc.  Add your chart to further demonstrate your findings.

  c.  Paragraph 3- Use the information from the Dept of Agriculture to evaluate your meal.  How does your percentage of fat compare to the percentage recommended? What about other guidelines like eating fruits and vegetables.  Have your planned a healthy meal? WHat changes might you make in your meal to make it healthier?

  d.  Paragraph 4- Using all the information provided, please inform us what meal you would choose and why.

Getting started with formulas and functions

Getting Started with Formulas and Functions 

What you'll learn:

• Create simple formulas for basic mathematical calculations 
• update formula results automatically 
• use a function to simplify formulas 
• copy and edit formulas 

Agenda:

• Actively listen and watch lecture on formulas and functions and ask questions. 
• Complete formula and function tutorial, independently, asking questions as you go along. 
• Start researching and working on the Nutrition Activity (see next post).

Excel intro lessons

Objectives:  

Students will be able to
open excel
be able to label and explain the major parts of the excel interface
create a basic excel document
enter, select and format data
insert and resize rows and columns
sort information in a list
sort by several columns at once
filter a list by custom criteria and reset filters

Today's Agenda 

A.  Answer the following questions, on the blog.

1.  What is Excel?
2.  What do you think you, as a student, can use Excel for?
3.  Have you used Excel before?
4.  If yes, how have you used it.

B.  Label and discuss the Excel interface, shared with you electronically but also have hard copies for anyone interested)

C.  Complete some guided practice and tutorials in Excel, creating a new document, formatting, and sorting and filtering.

Try a mail merge with a letter

Click on the link below to gain access to today's assignment.  You will need to download the excel and the word document for the assignment.

http://office.microsoft.com/en-us/mac-word-help/use-mail-merge-to-create-a-form-letter-RZ103895371.aspx

Mail Merge

Mail Merge 

Today's assignment is dealing with Mail Merge. You will be using Excel and Word to create this.
Please see below for your mail merge assignment.

What is a mail merge?

Facility provided by most word processing program whereby a form-letter can be sent to many recipients, each letterpersonalized for each recipient. The program takes each recipients name and address (from a mailing list) and enters it in its usual place on the letter, and also prints out mailing labels. 
(taken from http://www.businessdictionary.com/definition/mailmerge.html )

Mail Merge Assignment-Envelopes

1.  Open up a New Excel File,  Save it as yourname_addressbook
2.  Enter the information as follows in Row 1 
Last name   First Name    Street Address   City/Town   State    Zip code 

3.  Complete it with 10 of your family or friends information, making sure to format your zip code column

4.  Save

5.  Open up Word

6. Click on "tools" on the menu bar

7.  choose Mail merge Manager, a toolbox/window will appear with steps on it

7.  Click on create new> choose envelope

8.  Add your your own address in the bottom envelope of the box, where it says return address.

9.  Click ok

10.  Click on "get list" > Open data source >choose file > open

you should see this screen, click ok

11.  You should now see items in your placeholders appear.  These should be the categories you listed in row 1.

 12.  Now you will drag the placeholders into your envelope as follows:
         First Name Last name
         Street Address
          City, State  zip code
Your document should look like this

 13.  You are going to skip 4 and 5 on your box and move right to 6.  Complete Merge.  Click on the second button from the left "Merge to new Document"

   

14.  After clicking, this a new document should appear with your envelopes addressed.

15.  Save this file as completed merge_yourname

16.  Add your file to the class folder on your dock.