Team Fundraising Spreadsheet

Create a new spreadsheet in OpenOffice Calc. Below are the instructions for completing this activity:

1. Type TEAM FUNDRAISING DRIVE in cell A1. Merge cells A1:G1.
2. Type Week 1, Week 2, Week 3, Week 4, and TEAM TOTALS, respectively, in cells B3:F3. These are your column headings. Format them appropriately.
3. Think of four team names and type them in cells A4, A5, A6, and A7.
4. For each of the teams, provide an amount that they raised for each week. (Refer to example below). These MUST be different for each team!
5. Type WEEKLY TOTALS in cell A9 and type TOTAL AMOUNT RAISED in cell C11, merging cells C11 through E11. 
6. Type a formula in cell F4 that calculates the amount raised by each team. Use the fill handle to copy the formula.
7. Type a formula in cell B9 that calculates the amount raised by all teams during each week. Use the fill handle to copy the formula.
8. Type a formula in cell F11 that calculates the total amount raised by all teams.
9. Select cells A3:E7. Create a BAR CHART to display this data.
10. Give it the title FUNDRAISING BY TEAM. The X axis should be labeled as Amount Raised and the Y axis should be labeled as Team Name.
11. Add data labels to the chart and choose 'show value as number'

Save the spreadsheet as 'Team Fundraising' in your spreadsheets folder.

Activity provided by: http://www.sun.com/aboutsun/comm_invest/ogp/training/downloads/mod6_create_your_own.pdf

Fast Food Fun

Today, you will be creating a spreadsheet that calculates the amount of fat in ten different menu items from your favorite fast food restaurant. This project includes the completion of 4 steps. Each step must be properly labeled in your header according to the directions.

Step 1

• Decide which fast food restaurant you would like to visit. Click on that restaurant's web site below. You may choose one that is not on the list, but please let me know which you decide.

http://www.mcdonalds.com/app_controller.nutrition.index1.html
http://www.bk.com/
http://www.wendys.com/the_menu/nut_frame.html
http://www.nutritiondata.com/(Other fast food restaurants).

• Once you are there, plan a meal with a sandwich, salad, or other main dish, a side dish (french fries, onion rings, etc.), drink, dessert, and five other items of your choosing.
• For each item on your menu, record the total calories and the calories from fat in a separate document.
• Create a header with your name, date, block, and step #.

Step 2

• Enter your data into an OpenOffice Calc spreadsheet. (Sample provided)
• Put your page in landscape (Format > Page > Page tab).
• In cell A1, type the title Fast Food Fun. (You will merge the cells at the end of your project).
• Be sure to expand the width of your columns so that your information is not cut off.
• You may choose any font that you wish for this project. Be sure to include borders, shading, and a logo for the restaurant you chose in your spreadsheet.
• In cell A3 type your first menu item and continue entering your menu items until you reach cell A12.
• In cell B2 type Calories; in C2 type Fat Calories; in D2 type Non-fat calories; and in E2 type Percentage of Fat, in cell F2 type Total Calories.
• To figure out your non-fat calories, type a formula that subtracts the fat calories from the total calories =sum(b3-c3)
• To figure out the percentage of fat, divide calories by fat calories =sum(c3/b3). (Be sure to format this column as a percentage: Format > Cells > number tab > Percentage)
• To figure out total calories type a formula that calculates the sum of cells B3 through D3.
• In cell A14 type TOTAL. Then, in cell B14 type a formula that calculates the sum of the calories in your entire meal.
• In cell C14, type a formula that calculates the sum of the total fat calories in your entire meal.
• In cell D14, type a formula that calculates the sum of the total non fat calories in your entire meal.
• Make the spreadsheet colorful by adding borders, shading, and a nice looking font.
• Create a header with your name in the left, step # in the center, and date in the right.

Step 3

• Create the charts according to the directions.
• Complete the handout provided.
• Compare your information with another student and determine who has the healthier meal.
• Be sure to record the data you collect from the other student (you will be called on to share the information)

Step 4
Using OpenOffice Writer, write a three paragraph report on your findings. The following are the requirements:

• First paragraph: Introduction including which restaurant you chose and the items on your menu
• Second paragraph: Summarize your findings about your meal including the number of calories, percentage of fat, etc. Copy and paste one of your charts into your document as supporting evidence.
• Third paragraph: Compare and contrast your meal with another student. Use the information your recorded in step 2. Also conclude your report.
• Include a header with your name, date, block, and Step 4.

Grading: Steps 1 and 3 are worth 20 points each; Steps 2 and 4 are worth 30 points each. This project is worth a total of 100 points.
**Be sure to complete each step and to check your work often.
Lesson provided by: http://www.wmburgweb.com/Resources/Lesson/index.htm

Spreadsheet Vocabulary website:



http://spreadsheets.about.com/od/a/Spreadsheet_Definitions_and_TermsLetter_A.htm

$1 Million Dollar Spreadsheet

Congratulations! You've won the lottery! Spend the money on whatever you want (Rated G). Follow the directions to create a spreadsheet to list the items you want. You have a $1,000,000 budget that you MUST spend. You must buy at least 15 items.

Directions:

1. Use Open Office Calc to create the spreadsheet
2. Change the orientation of your page to landscape (Format > Page, Sheet tab)
3. Click in cell A1 and type "My Million Dollar Shopping Spree"
4. Change the width of the column to fit all of the text
5. Click and drag from cell A1 to cell G1 and merge the cells. Center the title. Change the font size to 16 and bold.
6. Immediately save as "Million Dollar Spreadsheet" in your spreadsheet folder.
7. Click on the column header for column B to highlight the entire column.
8. Choose Format Cells. Click on the Numbers tab. Choose Currency under category.
9. In the Format section, choose the 2nd in the list. Your column will now be formatted as currency automatically.
10. Do the same thing for Column C.
11. In cell A4, type the word Item
12. In cell B4, type the word Price
13. In cell C4, type the word Remaining Amount
14. Click on Row 4 and bold the column headings.
15. Go to cell A26 and type TOTAL
16. In A27 type Budget
17. In A28 type Amount left
18. In A29 type Average cost
19. In B26 type the formula that calculates the sum of cells B5 through B24
20. In B27 type 1000000
21. In B28 type the formula that subtracts cell B27 from B26.
22. In B29 type the formula to calculate the average of cells B5 through B24
23. In C5 type =sum(1000000-b5)
24. In C6 type =sum(c5-b6)
25. Press the ENTER key
26. With your mouse, right click on C6 on click copy
27. Highlight column C, rows 7 through 24. Right click on the highlighted cells and click Paste.
28. Fill in column A, rows 5 through 24 with items you want to buy. Put the price of the item in the column next to the item. Make sure you spend exactly $1,000,000
29. Go to Edit > Headers and Footers to create a header. Left header: Your Name, Center header: ________'s Million Dollar Shopping Spree; Right header: Date
30. Save as Million Dollar Spreadsheet in your MP3 folder.

This project is worth 30 points. You will receive 2 points off for each step not completed.

Practice with Formulas - Payroll Spreadsheet

You will be creating a spreadsheet of "fictitious" payroll information for 10 employees. These employees can be your friends, family, relatives, etc.

Requirements:

1. Spreadsheet must include 10 employees (use family members, friends, etc. as your employees)
2. Go to Edit > Headers and Footers. Create a center header that says _________'s Payroll Spreadsheet. The left header should have the date, and the right header should have your Block. Also, go to Format > Page, click the sheet tab, and change the page orientation to landscape.
3. Click in cell A1 and type Payroll Spreadsheet. Make the font size 14 and bold. Click and drag over to cell G1 and merge the cells. Center the title.
4. Your column headings should be as follows: Employee Number (A3), Employee Name (B3), Hourly Rate (you make this up in dollars in cell C3), Hours worked (each person should be different and their hours should range from 10-40 and should be typed in cell D3), Gross Pay (E3), Federal Tax (F3), Social Security Tax (G3), NJ Tax (H3), Total Deductions (I3), and Net Pay (J3).
5. Type the following formulas into each of these cell references: Use the CELL REFERENCES in place of the words in parentheses. Remember to use the fill handle to copy your formulas.

E4 type: =Sum(hours worked*hourly rate); F4 type: =Sum(gross pay*.15); G4 type: =Sum(gross pay*.07); H4 type: =Sum(gross pay*.07); I4 type: =Sum(Fed tax:NJ state tax); J4 type: =Sum(Gross pay - total deductions).

**Save as Payroll Spreadsheet when finished. DO NOT PRINT.

OpenOffice Calc Spreadsheets

Today, you will be introduced to OpenOffice Calc. This is the spreadsheet program that we will be using throughout this unit. To help you further understand the program, you will complete a series of activities including online tutorials and worksheets.

Assignment 1

1. Open the website: http://www.tutorialsforopenoffice.org/category_index/spreadsheet.html. Click on Lesson 1: Spreadsheet Basics. **It is highly suggested that you download and save or print the tutorial to have next to you as you work/read.
2. Using the worksheet provided, read through the tutorial and fill in the blanks.
3. Be sure to write your name on the top and submit for a grade.
4. When you are finished with the fill in the blank activity, move on to Assignment 2.
5. Save in your Spreadsheet folder as Assignment 1.

Assignment 2

1. Go to: http://inpics.net/calc.html
2. Go to the Formatting Worksheets section and click on Format Text.
3. Using OpenOffice Calc, perform each of the steps and continue until you have finished the Formatting Worksheets section.
4. Once you are finished, print out your result and submit.
5. Save in your spreadsheet folder as Assignment 2.

**NOTE: The tutorial will tell you to open files from the Practice Calc Files folder. Instead of opening the files, type in the information on your own to get used to inputting information.