Final Project - Musical Band or Artist Show

You are to develop a slideshow dedicated to your favorite band or musical artist. This project can be a lot of fun if you are able to organize your thoughts well BEFORE you begin actually designing the slideshow.

Project Requirements:

1. Must have a blank slide before the intro and after the ending slide
2. Must have an introduction (Welcome to a Tribute to.....with by Your Name)
3. You must organize your show by band members/artist, albums, awards, singles, performances/concerts, and a photo gallery. If you wish to add any additional information, please feel free to do so.
4. Each section of the presentations should have a caption (text) that explains or introduces the different parts of the show (separate slides for each).
5. Must have AT LEAST 25 pictures either from the internet and/or scanned
6. Must have 3 DIFFERENT songs from the band or artist (this must come from a CD)
7. Must have transitions between every slide
8. At least 5 of the backgrounds must be customized (designed by you in Paint)
9. At least 5 of the images must utilize motion effects
10. Text effects must be included on every slide
11. MUST include a credits slide at the end of the presentation (second to last slide). Your Name, Copyright symbol, date, copyright information for the music that you chose. (You must include separate credits for each album/title of song you used.
12. Be sure to proofread and spell check.
13. Save the presentation in your MP4 folder as Music Tribute.

This project is worth 60 points. You will be deducted 5 points for each step not completed.
Have fun!

Final Project - Room Layout

Today you will be starting the second to last phase of your final project. You will be desigining a layout of the room where you will be dancing, eating, and having fun!

The following things must be drawn and utilized in order to receive full credit:

• Tables labeled with table numbers
• Band/DJ location
• Bar/Beverage location
• Food stations (choose 4 from the following: Meat station, Fish station, Vegetarian section, Italian food station, Chinese food station, Mediterranean food station, American food station, Mexican food station, or Indian food station.
• Buffet and/or Dessert Table
• Dance floor

Every table/station MUST be labeled accordingly. In addition, you must utilize the following features of OpenOffice Draw or Publisher:

• Basic shapes
• 3D
• Shadow
• Fill color
• Line color
• Line styles

This part of the project is worth 25 points. Save as Room Layout in your Final Project when finished.

Final Project - Business Letter

Today, you will be completing the third part of your final project, the business letter. You will be using the letterhead that you designed last class and typing your letter on the letterhead. Follow the instructions for formatting the business letter carefully and be sure to PROOFREAD!

Requirements:
Use today's date
Address the letter to the person and establishment where you wish to hold your reunion.
Include a salutation (greeting)
The letter MUST include at least three paragraphs of 4-6 sentences each.
1st paragraph - Introduce yourself, your title (family member of _______ family). Also, explain your reason for writing. (Explain that you are planning a family reunion and that you are considering holding your reunion at their venue).
2nd paragraph - Provide a detailed description of when you would like to have the reunion. Also, ask if there are any activities or events that would be held during the specific time. In the same paragraph, request date availability and pricing information. You want to find out when they have available open times and what price it would cost to have it there. This will be your longest paragraph.
3rd paragraph - Conclude by thanking them for considering your request and that you hope to hear from them soon. Restate that you have requested date availability and pricing information. Also, tell them where you can be reached with a phone number and email.
**This letter should not exceed one page. Be sure that each of your paragraphs includes 4-6 COMPLETE and FULL sentences.

Alphabet Show

For this project, you will be creating a multimedia presentation using ProShow Gold, that helps a young child learn the letters of the alphabet.

**First, you must create a new folder in your Multimedia folder called Alphabet Show. Then, create a folder inside of that and call it Pictures. You must save all of the pictures for this show in that folder.
You will complete this project in three parts, Parts 1 and 2 are below. My recommendation is to print these instructions and check off each step as you complete them. This will ensure that all requirements are met and that the presentation is completed successfully.

Part 1

Step 1

1. Choose an appropriate theme (Disney, Cartoons, Fruit, Vegetables, etc). This theme must be something that children can recognize. Nothing that could scare them. I MUST approve all themes before you get started.
2. Use Google Images to find appropriate pictures for each of the letters in the alphabet (This is a total of 26 DIFFERENT pictures, for example, a picture of an Apple to represent the letter A, a picture of a Banana to represent the letter B, and so on...)
3. You MUST include a separate document to list the URL's for each picture.
4. Open ProShow Gold and go to File > New. In the folder list, find your network folder. Locate your multimedia folder and open your pictures folder. In the timeline, right click on the first slide. Select Insert > Blank Slide. Double-click on the same slide to open Slide Options. Click on the Backgrounds icon. Choose a background color that you would like to use for your blank slide. Click DONE.

Step 2

1. Using the blank slide that you created in #4 of Step 1, double-click to open the Slide Options. Choose Captions and type the following: Welcome to (Your name's) Alphabet Show (If you want each word to have its own text effect or appear in a different location, you must type each word individually).
2. Select a font style, size, and color. Since this slide will only contain text, make sure it is large enough. Also, be sure you can see the text over the background color that you chose.

Step 3

1. Insert a new blank slide after the first.
2. Double click on the slide to open the Slide Options and choose a DIFFERENT background color.
3. Then, in the Captions section type: Let's Learn Our ABC's!
4. Repeat #2 above.

Part 1 is worth 30 points. For each step not completed, you will receive 3 points off (this refers to the numbered steps).
Part 2

Step 1

1. After creating your first two introductory slides, create an additional 27 slides with DIFFERENT background colors. Be sure to create a blank slide first before changing the background colors.
2. Beginning with Slide 3, type: The Letter A. Continue through the rest of the slides and type The Letter B, The Letter C, and so on....until all slides contain this information.
3. Create a DIFFERENT text effect for each slide. You MUST have the text Enter and Exit the screen with an effect.

Step 2

1. Next, add the remaining text to each slide. This text must be a seperate text entry. In Slide Options, go to Captions and use the (+) to add another SEPERATE text entry. (This will be the name of the image that represents the letter. For example Ariel, Bambi, Cinderella, Dumbo.....). Add a text effect to this text as well.
2. After all of the text has been added, begin adding the images to each slide.
3. The pictures CANNOT take up the whole slide. The images must be resized so that the text is not covering any part of them.
4. Lastly, add a motion effect to each of the images.

Part 2 is worth 35 points. For each step not completed you will receive 5 points off.
Part 3
Step 1

1. Create your conclusion slides. In the timeline, right click in the first empty slide and select INSERT > BLANK SLIDE.
2. The third to last slide should say "Now you know your ABC's"
3. The second to last slide will have "Create by Your name, Block #, and your picture
4. Last slide will either say "The End" or it can just be a blank slide.

Step 2

1. Be sure to check and make sure that your slides are timed for at least 4-5 seconds each. (This will change once you add music)
2. Find 3 songs that you would like to use for your show. These should only include a section of the song, not the entire thing.
3. Record your 3 songs back to back in Sound Forge XP.
4. Save your sound file.
5. Sync Show to Audio. **It is OK if the slides change to a different duration than before.
6. Create an executable file.

Part 3 is worth 20 points. For each part not completed, you will receive 2 points off.










This project is due on April 23.

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.

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

Ebay Database

Using the fifteen "Wishlist" items that you researched last class, create a database that organizes this information.

Step 1 - List View (30 points)

1. Create a list with these fields (Category, Item Description, Seller, Location, Price, Picture).
2. Save the list as "Ebay Database".
3. When you are finished entering the fields, you should begin entering your information, using Ebay for the research. You should have 15 records when you are finished. 
4. Modify the table with your own font, colors, borders, etc. (Select your entire list view, go to Format > Field, and change the areas that you wish.)
5. Change the record height of your list view. Go to Format > Record Height and change it to 20
6. Go to File > Page Setup and click on the Source, Size, and Orientation tab. Make the orientation landscape. Then go to the Other Options tab and click Print gridlines and Print record and field labels.
7. Go to View > Headers and Footers. Put your name in the left header, Ebay Database in the center, and the date in the right header.
8. Print to either of the color printers when finished. Put in on the front table.

Step 2 - Reports  (10 points each)

1. Create a report that includes all fields EXCEPT Picture. Sort by PRICE in DESCENDING order.

• Create a border around your records. To do this, select the entire report view. Go to Format > Border.  Under Border Location, click on all the boxes on the left and all of the boxes on the bottom. (This will put lines around your entire print out).
• Go to File > Page Setup and make the same changes that you did in number 6 above.
• Before printing, check our your print preview. If the text in your header is coming out really big, change the size of your font to anything other than 12. Hit the print screen key and paste it into Word. Make sure to print screen all pages!!

2. Choose any fields that you would like to add. Create a report that will be SORTED AND GROUPED by CATEGORY. Print screen and print!!

3. Choose any fields that you would like to add. Create a report that will FILTER Prices that are > or < a price that works for you. Print screen and print!!

4. Create a report that will include all fields except PICTURE. Sort by Seller in ascending order. Create a field summary that will find the Sum, Average, Minimum, and Maximum for the price field (be sure to select this on the left hand side under Summary BEFORE clicking the summary boxes). Print screen and print!!

Step 3 - Form (30 points)

Create a form that includes ALL FIELDS.

• Create three different labels. Go to Insert > Label. 1) Category/Item Description 2) Product/Price 3) Seller Information. See example for set up.
• Click on the picture field. Go to Format > Show Field Names. This will take out the field name for the picture.
• Design the form with colors, borders, backgrounds, and change the fonts if you wish.
• Go to File > Page Setup. Set the orientation on Landscape. Then go to other options, and under Details, click on Print Field lines and make sure the the Page Breaks Between Records box is UNCHECKED.

Resave EVERYTHING as Ebay Database

Music Album Database (Part 3: Reports)

You will be creating 4 DIFFERENT reports using your Music Album Database. Below are the requirements for each report.

Report 1

• Create a report that will include ALL fields EXCEPT picture. Sort by Artist in ascending order. Go to Format > Border, so that there is a line between each record.

Report 2

• Create a report that will be grouped by Record Label and Sorted by Record Label. Choose any additional fields that you would like to add.

Report 3

• Create a report that will filter either Artist or prices. Find a price that works if the first one does not.

Report 4

• Create a report that will include Artist and the two prices. Create a field summary that will find the Sum, Average, Minimum, and Maximum for the prices.

The reports must include the proper header with your name and block in the left, title of database in the middle, and date in the right.

Each report is worth 10 points.

Music Database (Part 1: Tables)

You will create a database of 25 music CD's that you would purchase, if you had an unlimited amount of money. You will use multiple websites to find your information. You will create this database using Microsoft Works Database.

TABLE 1

1. Name this table Music - Table 1
2. Include the following fields in your report:
1. Artist
2. Title of Album
3. Record Company
4. List Price
5. Best Price Found
6. Genre
7. Release Date
8. Picture
3. Create your table and sort it in ascending order by the Title of Album. Print a copy to submit for a grade.

25 points for Table 1. You will receive 1 point off for each record not completed. In addition, you will receive 1 point off for each spelling error found.

TABLE 2

1. Name this table Music - Table 2.
2. Using Table 1, add a field and call it 'Preferences.' Assign each album a number according to the order in which you would purchase it. 1 should be the first purchase you would make and 25 will be the last purchase you would make.
1. Sort your database in ascending order by preference when complete.
2. Print one copy and submit.

25 points for Table 2. You will receive 1 point off for each record not completed. In addition, you will receive 1 point off for each spelling error found.

Movies Database (Part 2 - Forms)

For part 2, you will be designing 2 forms following the directions below. Please refer to the requirements below for specific instructions:

Form 1:

1. Create a form that includes all fields EXCEPT Gross income.

2. DO NOT add a subform

3. Arrange the form using the "Columnar - labels on top" option

4. Choose "Form is to display all data"

5. Choose any color you like for the style, and select "Flat or 3D look" as the field border option.

6. Name the form "Movie Form 1", then select Modify the form

7. Insert a header with your name by going to Insert > Header; Default

8. Insert a picture of the movie poster for each movie. Go to Google images to search for a picture of a filmstrip. Save this picture in your MP1 folder and insert into the form. Once you have found the picture go to Insert > Picture > From File and insert the picture into the form. Resize it and place it in the center of the form to the right of the information.

9. Then, using the tools, design the form however you would like.

Print and submit.

Form 2:

1. Create a form that includes all fields EXCEPT Director, Lead Actor, and Lead Actress.

2. DO NOT add a subform

3. Arrange the form using "Columnar - labels on left" option

4. Choose "Form to display all data"

5. Choose any color you like for the style and select "3D" as the field border option

6. Name the form "Movie Form 2", then select Modify the form

7. Insert a header with your name

8. Insert a picture of a dollar sign using Google images.

9. Design the form any way that you would like.

Print and submit.

Each form is worth 10 points.

Movies Database (Part 1: Table)

The Movies database table must include the following fields:

Movie title

Director

Lead Actor

Lead Actress

Year Released

Genre
Runtime

Total Gross Income

• The table must be sorted in chronogical order by Year Released
• Increase the row height to .6
• When you are finished designing the table you should have 8 fields (columns) and 20 records (rows).
• You are not able to print the table design, so be sure and show it to me so that I can grade it.

This table of the project is worth 20 points.