Seating Chart Project

Today you will be creating a seating chart of the room layout. You will be responsible for finding all of the students in the class and writing their names in the designated seat. You do not have to write their name directly on the object. You can use callouts, arrows, lines, etc. to help you label the names of each student.

The following MUST be included:

1. ALL boxes should be shaded (you may use color, gradient, hatching, or bitmap). Really experiment with using shading other than just colors. There are so many other options available!
2. ALL boxes must include a shadow. You MUST CHANGE the shadow color for at least 5 of the seats.
3. At least 3 objects must use 3D. Of these, you must change the 3D color for at least ONE.
4. Do not just use rectangles and squares for your seats. Be creative. You can use circles, basic shapes,     triangles, etc. to make your seats.
5. You must use line styles to outline your objects.
6. You must also include objects to represent the two teacher desks and the door.
7. Your margins must be .5 on ALL SIDES
8. Be sure to include a text box with your heading (Name, Date, Block, and Seating chart as the title). In addition, be sure to label the top of your document with "Room Layout - 247"
9. Create a border around your entire document.
10. Every students name must be spelled correctly. (You only need the first name)

This project will demonstrate your ability to be extremely creative when using basic shapes and objects. Think outside the box. Do something different!

When finished print your project to the color printer 4600/4700. Save to your Drawing folder as Seating Chart. This project is worth 30 points. You will lose 3 points for each requirement not met.

The Solar System

Today, you will be working on creating a picture of the solar system. You will research each of the planets to gain information on their color, shape, and size. Be creative. Remember to utilize your drawing tools to the fullest extent. Fill color, line styles, border styles, 3D, and shadow. ALL OF THESE MUST BE USED AT LEAST ONCE! This project is worth 20 points. You will receive 4 points off for any tools that you do not use.

Before you begin, make a text box as your header and label it with your name, date, block, and Solar System as the title.

**It is recommded that you change your page layout to landscape to give yourself enough room to work with. To do this go to Format > Page, click the Page tab, and change the orientation to landscape.

The following are some websites that can be useful to you in researching the planets:

1. http://www.solarviews.com/eng/homepage.htm
2. http://science.nationalgeographic.com/science/space/solar-system
3. http://solarsystem.nasa.gov/planets/index.cfm
4. http://www.windows.ucar.edu/tour/link=/our_solar_system/solar_system.html

The nine planets are:

• Mercury
• Venus
• Earth
• Mars
• Saturn
• Jupiter
• Neptune
• Uranus
• Pluto

When you are finished, please save in your Drawing folder as "Solar System" and print in color to the 4600/4700.

Greeting Card and Winter Scene

If you are done with your calendar project, you are to create a holiday greeting card using Publisher and a winter scene using OpenOffice Draw. You will do the winter scene only if you finish the greeting card. Below are the instructions:

Greeting Card

1. Open Publisher and choose 'Greeting Cards' from the list. 
2. Select Side Fold Card or Top Fold Card.
3. Click Yes when asked to automatically insert pages.
4. At the bottom of your document you should see four pages. Page 1 is the front, 2/3 are the inside, and 4 is the back.
5. Design a holiday greeting card for a friend or family member. You may use the pre-designed card templates in Publisher for ideas and you can also type "Holiday Greeting Cards" into Google images for ideas. However, you may NOT use a template for your design!
6. Front of card MUST have a graphic, a border, and a message (e.g., Happy Holidays!, Merry Christmas, Happy Hanukah, etc...).
7. Inside left must have a holiday quote with the author's name included (search for one on the internet).
8. Inside right must be the message and include a small graphic.
9. Back must include: Designed Especially for you by: Your Name © 2009. (To make the copyright symbol type ( c ) and then hit space. It will automatically be created.)
10. When you are finished, save it in your Desktop Publishing folder as "Holiday Greeting Card".
11. Print in color (4600/4700) and hand in.

Winter Scene

1. Use either OpenOffice Draw or Publisher.
2. You will be creating a winter scene of your choosing using the drawing tools in either program.
1. The winter scene must include use of fill colors, autoshapes, line styles, a text box, 3D, shadow effects, a border (if using Publisher), and a background.
3. TYPE your name on the front of the document
4. When you finish, save it in your MP2 folder as "Winter Scene"
5. Print out and hand in.

Movies Database - Part 3 (Queries)

Today, you will be creating a query based on the movies table that you created.

• Create a query using the wizard based on the movies table
• Click on Queries on the left hand side of your screen
• Then, click on Create Query using Wizard.
• Select the Movies table and select ALL fields EXCEPT Director to be included.
• Click Next
• Sort by Movie Title in DESCENDING order
• Then, click on MATCH ALL OF THE FOLLOWING
• Choose Total Gross as the Field, Is Greater Than for the condition, and type in 100,000,000 for the value. (This will filter movies that only made more than $100 Million)
• Click Next
• Choose Detailed Query
• Leave the aliases as is
• Name the Query "Income Query, then select modify query
• Click Finish

You have now created a query!! Save as Income Query and close.