Christmas Wish List

Today and tomorrow you are going to shop for 15 goodies you would like for Christmas. (I know it is early, but it is never to early to shop for good deals!)

In an excel sheet, create a spreadsheet that will have a good design, at least two small graphics, a list of 15 items you would like for Christmas, and how much it costs for each of them. At the end, give a total cost of all the items by setting a formula to have the computer do the math for you.

In addition, create a 3-D Pie chart so that your parents can easily see what item they are spending the most money on.

Finally, in a word document, type a numbered list of all the websites you visited to find your items. See the example below:

Mrs. Ehle's Christmas List
1. An Ipod Nano--www.target.com
2. A Nikon D60 Digital Camera---www.ritzcamera.com

***************
TURN IN:
When you hand in the assignment, you should turn in:
(PRINT PREVIEW YOUR WORK BEFORE YOU PRINT IT OUT!!)
1. he Excel Spreadsheet and the chart together in one document. It should be printed in landscape format. Please print the answers only (No Formulas).
2. A Word document with your items and places you shopped on the internet.

EXCEL--Can you do it?

Aaron has monthly expenditures. He only has $1000 in his budget. Your job is to create a spreadsheet for him.



Here is what he spends his money on:

HOUSE: $450

PHONE: $60

CABLE/COMPUTER: $60

ENTERTAINMENT: $50

GAS: $30

GROCERIES: $150

1. Make the title of your spreadsheet A1: Aaron's Monthly Expenses.


2. Then merge cells A1-C1 for the title.


3. Input column headings for the information above. A2 should say EXPENSES and B2 should say COST. Widen columns as needed


4. In A3-A8, enter the things he spends his money on and in B3-B8, put the amounts he spends on each of them.


5. In A9 should say GRAND TOTAL, in B9 use a formula to total up how much he spent for the month.
6. In A10 should say Money Left Over, in B10 use a formula to show close he is to spending $1000.
7. Insert a graphic of a smiley face if he has money left over, and insert a graphic of a sad face if he went over his budget of $1000.
8. When you are finished, please print out one copy LANDSCAPE, with the formulas only. Make sure to add a footer with your name/date/hour on it.

SIMPLE FORMULAS

In Column A, insert the number as follows:
A1 --- 2
A2 --- 5345
A3 --- 4567
A 4 --222

In Column B, insert the number as follows:
B1 --- 2
B2 --- 4321
B3 --- 3495
B4 --11

In Column C, write a formula to:
C1 --- Add A1 and B1
C2 --- Subtract A2 and B2
C3 --- Multiply A3 and B3
C4 --Divide A4 and B4

If your cell shows ####, widen the cells.

Add a footer to your page including your name, class, hour

Print it landscape version with the answers and then print it landscape with the formulas.

Save this assignment as: Simple Formulas

PARENT TEACHER CONFERENCES--Poster

Today you are going to design your own poster. Remember what we talked about:

• good use of the space/good symmetry
• varying sizes of fonts/fonts that are easy to read from far away/only 2-3 different fonts
• at least one eye-catching graphic that makes sense with the information
• good use of bold/italics/underlining

You poster must include the following information:

• The Parent/Teacher conferences are held at Shrine Catholic Academy in the library
• They are on Nov 11th from 5-9pm and Nov 12th from 10-12pm
• title
• at least one graphic (you may include up to 2 more)
• Students can attend with parents
• No appointment needed

You will have today and Monday to finish this project. We will begin with EXCEL next week.

TYPING Challenges

If you finish early, or wish to challenge your typing skills at home, check out these sites!

• http://www.freetypinggame.net/play11.asp
• http://www.freetypinggame.net/play1.asp
• http://www.freetypinggame.net/play9.asp

Remember to choose the skill level that suits you so you can get the most out of the game!

GOOD LUCK :)

SURFING THE NET

Today we will devote class to an important topic: Internet Safety.Go to the following sites and read the information provided:

• http://www.kidshealth.org/kid/watch/house/internet_safety.html
• http://www.indianchild.com/safe_surfing_tips_for_children.htm
  

Activity:Your parents think you spend too much time on the internet. They do not see the internet as a valuable tool. They say you can find the information you are looking for just as well in a book. They also fear for your safety as they have read about the statistics of online predators. You must write a short letter to your parents convicing them you understand the rules and safety procautions of handling the responsiblity of being on the internet. Do not use MLA format to head your paper.

When you are finished writing your letter, make sure you have included:

• at least 5 examples of things you learned from these two articles or from our discussion in class
• Spell check and grammar check your letter
• proper Friendly Letter format (click to see an example if you forgot)
• When you are finished, save your work, print it out, and turn it into the basket.
  

Editing Session

Editing Session for Powerpoint

Today you will pick a partner and edit his/her work. Read the example of the editing comments below. Make sure you comment, IN COMPLETE SENTENCES, on each individual slide. You will also write a conclusion or have an OVERALL COMMENT section at the end. Your word document should look something like this:

******************************

Edited by Ms. Haney

Period E

10-21-04
Creator: Luisa Blanco

The Myserious Life of Luisa Blanco

Slide #1--Title Slide: I like your use of color on this slide. I also like your chosen graphic.
Slide #2--Your Likes: Nice work! You have just enough writing for notes, not paragraphs. Again your graphics are nice.
Slide #3--Lifelong Friends: This is a good idea for a slide! Again, good use of color. However, a few of your graphics are a little too large. Maybe think about placing them better on the page.
Slide #4--Dislikes: I like this slide, but maybe a more logical order would be to have it follow directly after the Likes Slide. Also, the sound may be a little distracting. It seems like it will go on as you are talking.

Slide #5--Favorite Places: Awesome Slide! Watch your spelling though! It is "Paris" not Pearis :)
Slide #6--Favorite Foods: Yummy stuff. Wait! You forgot a graphic! Ms. Haney said at least one graphic on every page!

Slide #7--Credits: I like that you added a credits slide. And this includes the necessary animation Ms. Haney asked for.

Overall: I also looked over the list of things we needed to include in the presentation, Luisa, and you seem to do everything quite well. Make sure you include the transitions in between slides so you are able to speak directly from it.

RUBRIC for the All-About Me Presentation

Powerpoint Presentation

Rubric for All-About-Me Presentation

Design and Layout _______/15
**Contains at least one graphic per slide
**Easy to read while on screen
**Graphics compliment the theme of the slide; not distracting
**AT LEAST 1 title slide, 5 informations slides, 1 credit slide
(if you have more time, design more information slides)

Content _______/15
**Info helps the audience to learn more about you
**Slides were only used as notes (able to give more of a description)
**Evidence content was edited
**Animation present on one slide

Speech _______/20
**Evidence you rehearsed your presentation
**Eye contact with the audience

Total _______/50

New Link

You have all been working very hard with Excel!

Today, if you finish early with your print out, you may go to this link:
http://www.surfnetkids.com/games/ghost_typing.htm

Keep working on your typing speed and accuracy!

CURRENT EVENT

Please read one of the following articles and write a summary on it.

Remember to use an MLA Heading. The summary must use proper grammar/spelling. It must be about 3/4 page, double spaced for the first paragraph. In the second paragraph, give a 2-3 sentence reaction to the story you read. It could be whether you agree/disagree with the something or just your comments on the subject.

Here are the articles you can choose from:

• CLIMATE: http://news.yahoo.com/s/ap/20070923/ap_on_re_us/optimistic_doomsayers;_ylt=Au8IgOcAyC5s0p4FU3jSjN1G2ocA
• GUNS IN SCHOOLS: http://www.dailytribune.com/stories/092407/loc_guns001.shtml
• SMOKE DETECTORS SAVE LIVES: http://www.dailytribune.com/stories/092107/loc_fire001.shtml

POSTER project

Today you are going to learn about some elements of "good design".

• good use of space
• good use of fonts and font sizes
• how to place good graphics

You will need to prepare a flyer for the Halloween Dance. Make sure to include the Who, What, Where, and Why to make your flyer informative.

Make sure to spell check your information!!!

Here is the exact information you need to include:

• October 31st from 6pm until 8pm
• at the Shrine Academy gym
• make up a fun title for the dance
• include 2 fun things a person attending will have the opportunity of doing/seeing/eating
• use two-three different fonts
• use at least one graphic
• use text boxes for your information

This will be due on Thursday at the end of the hour.

Friday, September 7th

Begin class today by continuing with Mavis Beacon for 15 minutes.



At approximately 12:10pm, we will take a little break from Microsoft Word and talk about informative, age-appropriate websites that can keep you informed about current events by using the Internet.

• http://www.timeforkids.com/TFK/news ---Time for Kids


• http://www.sciencenewsforkids.org/ ---Science News for Kids


• http://teacher.scholastic.com/scholasticnews/ ---Scholastic News for Kids


• http://cnnstudentnews.cnn.com/fyi/index.html ---CNN Student News for Kids

First head your paper with the MLA style heading. After you read the article, put the title of the article centered on your word document after the heading. Next, write a one paragraph summary of the article. DO NOT COPY ANYTHING WORD FOR WORD FROM THE ARTICLE. That would be plagarism!

Finally, in a second paragraph rate the website based upon its usefulness to you as a middle school student. Would you recommend friends to go here? Did you find the information useful and age-appropriate? On a scale of 1-5 (1 being outstanding, 5 being not useful at all) rate this website.

Make sure you write in complete sentences and organize your thoughts.

FOLLOWING DIRECTIONS

Here is your first Word assignment. Make sure you follow directions properly!

************************

Following Directions

In order to complete this assignment, you must be able to investigate drop down menus and function keys on your tool bar. Make sure you follow the step-by-step directions correctly.


1. Type your first and last name and hit enter. On the next line, type Computers 7 and the hour you are in right now and then press enter. On the next line type the date.

2. Right now, save your work to the folder we created on the C Drive. It is VERY important to save your work periodically. Call your document FOLLOWING DIRECTIONS.

3. Next, highlight all the text you typed in step 1 and hit the right align key. The right align key button is on the top of the tool bar. In other words, hit the key that has all the lines even along the right side.

4. Then press the enter key twice. Now hit the center key. (This key is to the left of the right align button). Now type I LOVE COMPUTERS in bold, Courier font, size 24.

5. Now press enter. Your cursor should still be centered underneath your title. Now in size 14, Courier, italicized font, unbolded, type A BULLETED LIST OF WHAT I WOULD LIKE TO LEARN THIS YEAR.

6. Press enter. Hit the left align key. Press the bulleted list button on the tool bar. Make sure your font is now Veranda, non-italicized, and size 10. Now list three goals you have for computer class this year, with one goal per line. After each goal hit enter. You will notice on the next line, another bullet will automatically appear. This is because you have now formatted it to do so.

7. Now place your cursor on a line in between the date and the title of your paper and center the cursor. On your drop down menus, find the INSERT menu and scroll down to PICTURE and then to CLIP ART. Find a picture that goes along with this sheet about computers and your goals. (Helpful Hint: look up words like “computers” or “goals.” These are key words that may help you find the perfect picture).

8. Now place your cursor after the bulleted list and press enter.

9. Now make a numbered list of at least three different ways you can accomplish these goals you set for yourself. You will find this button on the tool bar next to the bulleted list button. Save your work again.

10. Next minimize your window that you are working in and then minimize the Word window. You will see at the very bottom of your screen you have made them very tiny. You have not lost any of your work. This function allows you to work from various programs without officially closing anything. You are now able to “toggle” between programs.

11. Click on the Internet Explorer button. Put in the internet address: http://designscout.tv/. Press the enter button on the screen. What is the picture that you see on the screen? Type the answer on your Word document in size 36, Garmond font, centered under your numbered list.

12. Press the enter button twice and then press the left justification button. Make the size of your type 10 and your font Webdings. Type all little a’s across the screen in a single straight line. Now highlight the same line and change the size to 14 and continue a second straight line until it ends at the other side by typing more a’s.

13. Press the enter key twice and type the full names (first, middle, and last) of the two people sitting nearest you. Choose the font Impact for the first name and Tahoma for the second, both in size 14.

14. Finally press enter. In your last set of directions you are going to use Word Art to type the month you were born. Go to INSERT and scroll down to PICTURE. Within this menu, select WORD ART. Then you can choose a word art style you like. A box will appear: type in the month you were born and press OK. Once your month appears in your document, there will be small nodes around it. Click and hold down your mouse until it is at the bottom of you page.

15. PRINT PREVIEW your document. Go to FILE, PRINT PREVIEW. Make sure your document is ONLY ONE PAGE! If it is not, check your picture at the top of the page, and make it smaller. This will give you more space.

16. Save your work. Print your document ONLY if it is one page and hand it in to the top basked by my desk.

17. Congratulations! You are finished with your first assignment!

Mavis Beacon

Today you will be introduced to Mavis Beacon, our typing tutor. In about a week or so you will have your first inital timed typing test. Remember what I told you yesterday, I am not concerned in the beginning with how fast you type, but that you are using the appropriate keys. So in this next week, while using Mavis, I expect that you are trying to break old habits and using the keys with the correct finger as Mavis tells you.

Good Luck and try to have fun with it!

Welcome to 7th Grade Computers!

I hope you were able to find our computer lab with ease! On this website you will find directions for our daily assignments. You will also be able to check this site if you are absent to see what you have missed. You can arrange to make up work whenever you return from an absence and do not have to worry about working things at home.