Final Project

We are in the final stretch of our section of Inotroduction to Computers!  For our final project, you will use all three of the Office programs we have studied.

Word:
Create a flyer for an event that you are hosting.  The flyer should have the following critera:
1. All necessary information about the event (ex. where, when, what to bring)
2. Use of WordArt
3. Use of ClipArt
4. Use of page border
5. Variety of fonts and sizes

Excel:
Create a budget for your event.  You have a budget of $500.  The worksheet should have the following criteria:
1. Worksheet heading
2. All supplies needed for your party (minimum 10)
3. Column for "Supply", "Cost per unit", "Units needed", "Total Cost"
4. Use of calculations to find the total cost of your party supplies and how much you will have remaining.  Also calculate the MAX, MIN, and AVG price for your items (hint: its in AutoSum!)
5. Turn your data into a chart and format accordingly.

Access:
Create a database of friends attending your event.  The database should have the following criteria:
1. Minimum of 10 friends (please see my example for suggestions as to what data to include)
2. Create a table
3. Create a report
4. Run a query
5.
Save as: Final Project
Total Points: 30 points

Shopping List

View the weekly circular at www.Shoprite.com. You will need to select 10 different items that you want to add to your shopping list for purchase this week.  We will create our list in Microsoft Excel and use the functions to calculate how much we are going to be spending.  Please use my template to create your list but please select your own items for purchase.  We will then work through the formulas and functions together to calculate the total price in column D.  Happy shopping!



Save As: My Shopping ListTotal Points: 10

My Complete Example:

Rubric:

3 Column Newsletter

EXTRA EXTRA READ ALL ABOUT IT!!!

You will create a one-page (3 column) document.  You have two options for the topic of your neswletter!

Option 1
A newsletter describing a career of your choice. Need help finding some information?  Find your career here!!!  --> Occupational Outlook Handbook

You will need to have at least four sections in your newsletter.  Here are some suggestions for section headings to inlcude:

• Introduction
• Occupation Description
• Earnings and Advancement, and NJ Salaries
• Employment and Outlook (general and for NJ)
• Duties and Responsibilities
• Interests and Abilities
• Education and Training
• Licensures and Special Requirements

You are NOT going to copy and paste the information from the website into your project. You will include the main information listed and put it INTO YOUR OWN WORDS.

Option 2

A newsletter for Lakeland.  The newsletter should highlight some current events or activities going on at Lakeland.  The newsletter should be informative and be something you would want to share with all members of the school.

You must include at least four sections to your newsletter.  Some examples may include:

• Lateley at Lakeland
• Lancer Pride
• Lancer News
• Club of the Month
• A write up about a sports team or club

Save as: Newsletter

Total Points: 10
Rubric:

My Example:

Remember: You may want to search newsletter examples in Google to get some inspiration for  how to design your newsletter!  Here are some additional examples:



4 Favorite People Table

1. Set up table with 4 columns and 6 rows.
2. Change page orientation to landscape so you can have columns wide enough for text.
3. Research four people’s biographies on www.biography.com
4. Record their Name, Birth Date, Profession, Accomplishments as column headings.
5. Complete the table. List at least two accomplishments for each person.
6. Record www.biography.com as the source underneath the table.
7. Format the table in some way (change line style, color, or add shading)
8. Adjust column widths.
9. Center horizontally and vertically on the page.
10. Include the proper heading in the header of the page.

Save as: Biography Table

Total Points: 10 Points

Rubric:

My Example:

Biographical Collage

Collage Instructions

Pretend you have just met a foreign exchange student from Latvia, named Saluda. Saluda is new to the Lakeland High School and wants to know all about you and your culture and hometown. Create a Collage to explain to your new friend Saluda who you are. Where you are from? What are your hobbies and interests?

Search the Internet using Google, Bing or another search engine for pictures of items that would best describe you. Use the insert tab, and insert pictures, clipart, shapes, smart art and word art to place them artistically and creatively on your paper

Create a collage of pictures that either describes you or things that you like. Your collage can have a theme or be a combination of random pictures that you like.

YOU MUST SATISFY THE FOLLOWING CRITERIA:
Worth 1 Point each:
Make your page orientation landscape: Page Layout -->Orientation
You must set ALL your margins to .5 inches
Your pictures must be overlapping
You must have your name somewhere on the collage (using Clip Art or Word Art)
You must have at least 20 pictures in your collage
Utilize different sizes and shapes
Utilize shadows and Picture Styles

Worth 3 Points:
Overall appearance

Total Points for this assignment= 10


Some helpful tips:
You must have as little white space as possible on your collage. Try using the “Set Transparent Color” tool for pictures with a white background. Picture Tools --> Format --> Recolor -->Set Transparent Color.
I suggest you bring all pictures into a “rough draft” document and format them there before bringing them into your collage. This means you will have TWO documents open: rough draft, actual collage.  I also suggest you have the class blog open with all of the criteria required for this project.

Feel free to utilize the tools in the Picture Toolbar. Select your picture and the picture toolbar tab will open. Use the Contrast, Brightness, Cropping, Rotating tools.

If you drag pictures to very edge of the page, they will get cut off. Use Print Preview before you print and make any necessary adjustments.


**PLEASE NOTE** You will receive a 0 if you have any inappropriate pictures in your collage.

Remember, your audience should learn something about you and your interests from viewing your collage. Have fun!

Save as: COLLAGE
Total Points: 10

Corresponding Rubric:

My Examples:

Everyday I'm Shufflin'

The whole point of the Renaissance assembly is to recognize those students in our school and our community who work hard to make Lakeland the best that it can be.  

I know that there is a lot expected of you each and every day and sometimes school simply isn't the most fun place to be (except for intro to computers class of course).... 

.....I get it.  

You have three years left before you leave the Lakeland halls.  Take advantage of this time.  Learn something new, have some fun, make memories you'll never forget.  We hope you enjoyed our performance and take it as just a small symbol of how much we care about you and really want to make school a place you enjoy.

  We work hard because you work hard.  
Happy Renaissance!

Keep up the good work!

More flags, more fun

The teachers enjoying the FBLA and DECA trip to 6 Flags :)