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.

College Database

Create a new database and name it 'College Database.' Going to http://www.google.com/ or http://www.yahoo.com/, research and retrieve the following information for your database. Complete a total of 10 colleges and/or universities. Field names and data types are as follows:

1. School Name (text)
2. Web Address (text)
3. City (text)
4. State (text)
5. Mascot (text)
6. Mascot Picture (general)
7. Tuition price (currency)
8. Athletic Conference (text)

Part 1: Create a new database and research the above fields. Create the list view, making sure to make all the necessary changes in the page setup, add a header with your name in the left, College Database in the center, and date in the right. Also, increase the size of your rows to 20 or 30.

Part 2: Design a form that includes all the information in the database. Include text labels to better organize the form and try to fit 1 record per page. The text labels should be College Information (includes school name, website, city, and state); Cost (includes tuition); Athletic Information (mascot nam and athletic conference) and Mascot (picture of mascot) BE SURE TO REMOVE THE FIELD NAME FOR PICTURE! *Remember: the text labels should be larger than the rest of your text! (Make the changes in page setup).

Part 3: Create 3 reports using the database. Report 1 must be sorted by School name in ascending order. Average the Tuition price field. Report 2 must include a filter for Tuition Price. Report 3 must be sorted and grouped by either State or Conference. Include a sum and average for tuition. DO A PRINT SCREEN FOR EACH OF THE REPORTS BEFORE PRINTING THEM OUT! Be sure to label them accordingly.

This database is worth a total of 80 POINTS. List view = 25; Form view = 25; Reports = 10 points each.

Save in your MP3 folder as College Database