home

=Computer Applications II - Daily Assignments=

__ Final Exam: __** __Period 7__: **Wednesday 6/2/10** Multiple choice questions for all class members: seniors, juniors, sophomores, and freshmen. 10:09 am - 12:02 pm
 * Objective: Assess student learning.

__Period 3:__ **Friday 6/4/10** Multiple choice questions for all class members: seniors, juniors, sophomores, and freshmen. 8:0 am - 9:53 am


 * Monday - Tuesday 5/17/10 - 6/1/10

Objective: Make the STEM brochure. ** __** Assignment: **__ Use Microsoft Publisher to make the STEM brochure.

Objective: Make observations about what makes a good brochure by studying a real brochure. ** **Do Now: ** On the appropriate panels of the brochure write: Front Back Inside back cover Inside left Inside middle Inside right
 * Friday 5/14/10

__ **Assignment:** __ Look at the Summer of STEM brochure to answer the questions. media type="custom" key="6131177"

Finish assignments.
 * Thursday 5/13/10**


 * Wednesday 5/12/10**
 * Objective: Make a thank you postcard in Microsoft Publisher. **

__ **Assignment:** __ Filename: **PostcardYour Name.pub** Directions in red notebook.

Objective: Make a thank you postcard in Microsoft Publisher. **
 * Monday & Tuesday 5/10,11/10

**Do Now: ** media type="custom" key="6087645"

Filename: **PostcardYour Name.pub** Directions in red notebook.
 * __Assignment:__**

Print Upload to your Gaggle digital locker.
 * __Ticket out the Door:__ **

Objective: Make an example postcard in Microsoft Publisher. **
 * Wednesday - Friday 5/5-7/10

__**Assignment:**__ Filename: **PostcardExample.pub** Follow the directions exactly for this example postcard from a business. Pages 10 to 22 are for page 2 of the postcard.

__**Ticket out the Door:**__ Print Upload to your Gaggle digital locker.

Objective: Make an example postcard in Microsoft Publisher. **
 * Monday & Tuesday 5/3,4/10

**__Assignment:__** Filename: **PostcardExample.pub** Follow the directions in the red notebook exactly for this example postcard from a business. These examples take care of page one of the postcard. We will do the flip side of the postcard tomorrow.

__**Ticket out the Door:**__ Upload to your Gaggle digital locker.

Objective: Create your own calendar in Microsoft Publisher. **
 * Wednesday & Thursday 4/28, 29/10

__**Assignment:**__ Demonstration by Miss Hangen Filename: **CalendarYourName.pub** Make sure your **EventsLog.xls** file is sorting in order of date.
 * Print it.**

Finish and print **Newsletter.pub**

Objective: Create your own calendar in Microsoft Publisher. ** __**Assignment:**__ Filename: **CalendarYourName.pub** Put the finishing touches on your calendars for **April**, **May**, and **June**. Make sure you have your name somewhere that I will see it on the printout. Get permission to **print**.
 * Monday & Tuesday 4/26, 27/10

Make sure your **EventsLog.xls** file is sorting in order of date.
 * Print it.**

Objective: Create your own calendar in Microsoft Publisher. ** **Do Now:** Research the events online and fill in the spreadsheet. You may do a paper copy, and then type into the spreadsheet or put it directly into the spreadsheet. You will use the sort feature of Excel to sort the spreadsheet information by date, so remember to select all the cells before sorting. **__Assignment:__** Filename: **CalendarYourName.pub** Use Microsoft Publisher, Publications for Print, to customize a calendar for the months of April, May and June. Pick a color scheme and change the provided aspects of the template to personalize your calendar. Pick a font scheme. Keep a file with a log of the websites you used to find the dates for the holidays and events you used in your calendar.
 * Wednesday - Friday 4/21-23/10
 * Add** **textboxes** or **pictures** to include events on particular days.
 * Refer to the school calendar for events to include. [|http://www.Lancaster.k12.pa.us]
 * Include these holidays and more. Look them up online to find the correct dates for 2010.
 * April Fool's Day
 * Good Friday
 * Easter
 * Earth Day
 * Mothers' Day
 * Primary Election Day in PA
 * Fathers' Day
 * Memorial Day
 * Other events you may include
 * Your birthday if it falls in April, May or June
 * World Health Day
 * National Empanada Day
 * Arbor Day
 * Rubber Eraser Day
 * Take Your Child to Work Day
 * Boston Marathon
 * National Teacher Day
 * No Socks Day
 * May Day
 * Cinco de Mayo
 * Bike to Work Day
 * Flag Day
 * Kentucky Derby
 * World Turtle Day
 * Summer Solstice
 * World Environment Day
 * International Picnic Day

Use the sort feature in Excel to sort the events by date. Make sure you select all the cells before you sort. Proofread, save, upload to Gaggle, and ask permission to print.
 * EventsLog.xls** will include these holidays and any others you included. It must have your name in the header.

Objective: Create your own newsletter.
 * Monday & Tuesday 4/19,20/10

__ Assignment: __** Due on Tuesday
 * 1) ** 2 to 4 pages **
 * 2) ** at least 4 articles **
 * 3) **One headline news story** that will begin on page one and will continue onto the second page, with bylines, jumpline and continuation head
 * 4) **Several short news stories** with byline or end sign
 * 5) One **biographical article** about someone who made a valuable contribution to an area the fits into the subject of your newsletter, including a photo of the person
 * 6) Your **autobiography**
 * 7) One **Special Point of Interest** such as a special tidbit section, a calendar, questions and answers section, useful tips, puzzle, sudoku, quotes, website review, list of related website, …
 * 8) **Table of Contents**.
 * 9) **Various photos**, **clip art, and 1 pull quote** to make your newsletter interesting.
 * 10) **Creative nameplate, date** and **issue** on the first page
 * 11) **Your name** as the **editor** of the paper in the masthead

Objective: Create your own newsletter.
 * Thursday & Friday 4/15, 16/10

__ Assignment: __** Read about newsletters:@http://desktoppub.about.com/cs/pagelayout/f/design_newsltr.htm Filename**: NewsletterYourName.pub Your newsletter must contain these things:** Refer to your red notebook.
 * 1) ** 2 to 4 pages **
 * 2) ** at least 4 articles **
 * 3) **One headline news story** that will begin on page one and will continue onto the second page, with bylines, jumpline and continuation head
 * 4) **Several short news stories** with byline or end sign
 * 5) One **biographical article** about someone who made a valuable contribution to an area the fits into the subject of your newsletter, including a photo of the person
 * 6) Your **autobiography**
 * 7) One **Special Point of Interest** such as a special tidbit section, a calendar, questions and answers section, useful tips, puzzle, sudoku, quotes, website review, list of related website, …
 * 8) **Table of Contents**.
 * 9) **Various photos**, **clip art, and 1 pull quote** to make your newsletter interesting.
 * 10) **Creative nameplate, date** and **issue** on the first page
 * 11) **Your name** as the **editor** of the paper in the masthead

**Objective:** Create a masthead.
 * Wednesday 4/14/10**

**Do Now:** Look at the masthead at the bottom left of the Vidette. It has a light olive green background. **__Assignment:__** Create a masthead for your newsletter, and place it in your newsletter publication. __**Ticket out the Door:**__ Upload to your Gaggle digital locker.

**Objective: Create your own newsletter.
 * Tuesday 4/13/10**

Do Now: ** Look at the Vidette and answer these questions.
 * Paper and Pencil:**

1. What are the different colors used for text?

2. Describe the font scheme.

3. Who are the Co-Editors-in-Chief listed in the masthead?

4. Where is the masthead located and what is its background color?

5. What is something you like about the newspaper that you would considering using in a newsletter of your own?

Continue working on your newsletter by following the directions in your notebook and on the wiki.
 * __ Assignment: __**

Save your work.
 * __Ticket out the Door:__ **

**Objective: Create your own newsletter.
 * Monday 4/12/10**

Do Now: ** Your newsletter is required to have a main cover story that starts on the first page and continues on another page. It must have a jumpline and a continuation head. On your half sheet of paper, write an example of a jumpline, and write an example of a corresponding continuation head.
 * Paper and Pencil:**

Take notes and summarize articles on the internet related to your topic to create articles for your newsletter. Use the Newspaper Article Summary Questions sheets in the notebook. Continue working on your newsletter by following the directions in your notebook and on the wiki.
 * __ Assignment: __**


 * __Ticket out the Door:__ **
 * Save your work.**

**Objective: Create your own newsletter.
 * Thursday & Friday 4/8,9/10**

Do Now: ** Read new pages in notebook.
 * Writing a Summary**

Take notes and summarize articles on the internet related to your topic to create articles for your newsletter. Use the Newspaper Article Summary Questions sheets in the notebook.
 * __ Assignment: __**


 * __Ticket out the Door:__ **
 * Save your work.**

Objective: Create your own newsletter. **
 * Tuesday & Wednesday 4/6, 7/10

Read about newsletters:@http://desktoppub.about.com/cs/pagelayout/f/design_newsltr.htm Filename**: NewsletterYourName.pub Your newsletter must contain these things:**
 * __ Assignment: __**
 * 1) ** 2 to 4 pages **
 * 2) ** at least 4 articles **
 * 3) **One headline news story** that will begin on page one and will continue onto the second page, with bylines, jumpline and continuation head
 * 4) **Several short news stories** with byline or end sign
 * 5) One **biographical article** about someone who made a valuable contribution to an area the fits into the subject of your newsletter, including a photo of the person
 * 6) Your **autobiography**
 * 7) One **Special Point of Interest** such as a special tidbit section, a calendar, questions and answers section, useful tips, puzzle, sudoku, quotes, website review, list of related website, …
 * 8) **Table of Contents**.
 * 9) **Various photos**, **clip art, and 1 pull quote** to make your newsletter interesting.
 * 10) **Creative nameplate, date** and **issue** on the first page
 * 11) **Your name** as the **editor** of the paper in the masthead

**Thursday 4/1/10 Objective:** Lorem ipsum dolor sit amet, consectetur adipiscing elit.

**Do Now:** Fusce pellentesque semper purus vehicula dapibus.

Quisque.pub Click here!
 * __ Assignment: __**

Paper and Pencil:** Vivamus blandit volutpat nulla in congue. Integer aliquet orci eu justo tincidunt auctor blandit tellus mollis.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__


 * Tuesday 3/30/10 - Thursday 4/1/10

Objective: Create a newsletter.

Do Now: **

Design your nameplate with your partner.

Read about newsletters:@http://desktoppub.about.com/cs/pagelayout/f/design_newsltr.htm Filename**: NewsletterYourName.pub Your newsletter must contain these things:**
 * __ Assignment: __**
 * 1) ** 2 to 4 pages **
 * 2) ** at least 4 articles **
 * 3) **One headline news story** that will begin on page one and will continue onto the second page, with bylines, jumpline and continuation head
 * 4) **Several short news stories** with byline or end sign
 * 5) One **biographical article** about someone who made a valuable contribution to an area the fits into the subject of your newsletter, including a photo of the person
 * 6) Your **autobiography**
 * 7) One **Special Point of Interest** such as a special tidbit section, a calendar, questions and answers section, useful tips, puzzle, sudoku, quotes, website review, list of related website, …
 * 8) **Table of Contents**.
 * 9) **Various photos**, **clip art, and 1 pull quote** to make your newsletter interesting.
 * 10) **Creative nameplate, date** and **issue** on the first page
 * 11) **Your name** as the **editor** of the paper in the masthead

Summary of what you have planned so far.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Objective: Plan a newsletter.
 * Monday 3/29/10

Do Now: **

Read about newsletters:@http://desktoppub.about.com/cs/pagelayout/f/design_newsltr.htm


 * __ Assignment: __**

Finish **PracticeNewsletter.pub**

Plan a newsletter with a partner. Pick the topic. Decide on articles. Decide on other tidbits that will be included. Split the tasks.

Answer these questions about your newsletter project with a partner. media type="custom" key="5751885"
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **


 * Friday 3/26/10**


 * Objective: Identify the parts of a newsletter. **

**Do Now:**

Read: @http://desktoppub.about.com/od/newsletters/a/newsletter_part.htm


 * __ Assignment: __**

On the Technology Newsletter, label the parts from the About.com article, The 12 Parts of a Newsletter. Finish **PracticeNewsletter.pub**

Make sure you name is on the newsletter and turn it in.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

**Objective: Use Microsoft Publisher to produce a quality newsletter.**
 * Wednesday & Thursday 3/24, 25/10**

**Do Now:** media type="custom" key="5713833"

Filename: **PracticeNewletter.pub Use Microsoft Publisher to REDO one of the 4 newsletters provided in your notebook.** Make it look however you would like. Use whatever layout you think would look good. You do NOT need to replicate the look it started with. Use the articles and information in the newsletter as you material. Find new photos and graphics. Change the name of the newsletter. Include you name somewhere. Try out http://googlemyway.com
 * __ Assignment: __**
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

**Tuesday 3/23/10**
**Do Now:** Look at the Posttville Area School District Technology Newsletter and the Winter 2009 Technology Newsletter in your notebook. Fill out this google form. media type="custom" key="5699519"

Filename: **PracticeNewletter.pub Use Microsoft Publisher to REDO one of the 4 newsletters provided in your notebook.** Make it look however you would like. Use whatever layout you think would look good. You do NOT need to replicate the look it started with. Use the articles and information in the newsletter as you material. Find new photos and graphics. Change the name of the newsletter. Include you name somewhere.
 * __Assignment:__**

**Monday 3/22/10**
**Do Now:** Look at the following examples of newsletters. List 10 specific things that you notice about them. (5 about each) These newsletters have 4 pages each. Look at all of them.

@http://www.pagesmag.com/nlsamples/0408gn-adv.pdf @http://www.pagesmag.com/nlsamples/example1.pdf

@http://www.alice-designs.co.uk/newsgood.html Make a list of at list 2 things from each paragraph that are important elements of a good newsletter. (6 paragraphs * 2 = 12 things) @http://desktoppub.about.com/cs/pagelayout/f/design_newsltr.htm Add 5 additional factors that make for good newsletters.
 * __Assignment:__**
 * Read:**
 * Paper and Pencil:**
 * Read:**
 * Paper and Pencil:**


 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Turn in your paper with at least 27 statements. (5 + 5 + 12 + 5 = 27)

**Friday 3/19/10**
**Do Now:** Get into your Gaggle.

Finish back assignments and have files that were not printed, ready for Miss Hangen to grade.
 * __Assignment:__**

Turn in your evaluation rubrics from the computer fair.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

**Thursday 3/18/10**
**Do Now:** Get the evaluating rubrics for the computer fair.

Evaluate at least 3 exhibits at the computer fair.
 * __Assignment:__**

Turn in your evaluation rubrics.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Wednesday 3/17/10
Desktop Publishing--What Is It? Finish and print any documents that you haven't printed yet. IfFunctionExample.doc CSclassArticle.doc SnowDays.xls PeopleSort.xls NewspaperBruce.doc MusicGalore.doc Menu.doc Schedule.doc Contents.doc Announcement.pub Menu.pub BusinessCard.pub CDLabel.pub

Tuesday 3/16/10
**__Assignment:__** Objective: **Use the desktop publishing software, Microsoft Publisher, to creat a CD label.** Filename: ** __CDLabel.pub__ ** Save to the desktop. Software: **Microsoft Publisher** Directions: **Follow the directions on pages 42 through 43 of Desktop Publishing/Microsoft Publisher, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

Verify that your **Menu.pub** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use the desktop publishing software, Microsoft Publisher, to creat business cards.** Filename: ** __BUSINESSCARD.PUB__ ** Save to the desktop. Software: **Microsoft Publisher** Directions: **Follow the directions on pages 38 through 41 of Desktop Publishing/Microsoft Publisher, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__**Ticket out the Door:**__ Save the file to the desktop as **BusinessCard.pub**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it.
 * <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">Only after you are sure that your completed BusinessCard.pub file is in your locker, delete it off the desktop and empty the recycle bin. **

**__Assignment:__** Objective: **Use the desktop publishing software, Microsoft Publisher, to creat a menu.** Filename: ** __MENU.PUB__ ** Save to the desktop. Software: **Microsoft Publisher** Directions: **Follow the directions on pages 32 through 36 of Desktop Publishing/Microsoft Publisher, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

Verify that your **Announcement.pub** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use the desktop publishing software, Microsoft Publisher, to creat a menu.** Filename: ** __MENU.PUB__ ** Save to the desktop. Software: **Microsoft Publisher** Directions: **Follow the directions on pages 32 through 36 of Desktop Publishing/Microsoft Publisher, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__**Ticket out the Door:**__ Save the file to the desktop as **Menu.pub**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it.
 * <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">Only after you are sure that your completed Menu.pub file is in your locker, delete it off the desktop and empty the recycle bin. **

Wednesday 3/10/10
Finish and turn in Desktop Publishing--What Is It? Finish and print any documents that you haven't printed yet. IfFunctionExample.doc CSclassArticle.doc SnowDays.xls PeopleSort.xls NewspaperBruce.doc MusicGalore.doc Menu.doc Schedule.doc Contents.doc Announcement.pub

Verify that your **Contents.doc** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use the desktop publishing software, Microsoft Publisher, to creat an announcement or flyer.** Filename: ** Announcement.pub ** Save to the desktop. Software: **Microsoft Publisher** Directions: **Follow the directions on pages 28 through 30 of Desktop Publishing/Microsoft Publisher, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__**Ticket out the Door:**__ Save the file to the desktop as **Announcement.pub**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it.
 * <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">Only after you are sure that your completed Announcment.pub file is in your locker, delete it off the desktop and empty the recycle bin. **

Monday 3/8/10
Verify that your **Schedule.doc** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use a word processing program to do the desktop publishing task of creating a table of contents.** Filename: ** Contents.doc ** Save to the desktop. Software: **Microsoft Word** Directions: **Follow the directions on pages 20 through 21 of Desktop Publishing/Microsoft Word, near the back of your red notebook. FOLLOW THE DIRECTIONS CAREFULLY.** When you feel it is complete, have Miss Hangen check it and get permission to print.

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__**Ticket out the Door:**__ Save the file to the desktop as **Contents.doc**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it.
 * <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">Only after you are sure that your completed Contents.doc file is in your locker, delete it off the desktop and empty the recycle bin.

**

Friday 3/5/10
**
 * Finish back work!

Thursday 3/4/10
Verify that your **Menu.doc** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use a word processing program to do the desktop publishing task of creating your schedule.** Filename: ** Schedule.doc ** Save to the desktop. Software: **Microsoft Word** Directions: **Follow the directions on pages 17 through 19 of Desktop Publishing/Microsoft Word, near the back of your red notebook. USE YOUR OWN SCHEDULE NOT THIS SAMPLE ONE.**

Save the file to the desktop as **Schedule.doc**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it. <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">**Only after you are sure that your completed Schedule.doc file is in your locker, delete it off the desktop and empty the recycle bin.**
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Wednesday 3/3/10

 * Pages 5 through 16 have some corrections and pictures!!! **
 * NewspaperBruce.doc** pages 1-5
 * MusicGalore.doc** pages 6-11
 * Menu.doc** pages 12-16

Tuesday 3/2/10
Verify that your **MusicGalore.doc** is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use a word processing program to do the desktop publishing task of creating a menu.** Filename: ** Menu.doc ** Save to the desktop. Software: **Microsoft Word** Directions: **Follow the directions on pages 12 through 16 of Desktop Publishing/Microsoft Word, near the back of your red notebook.

**

Save the file to the desktop as **Menu.doc**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it. <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">**Only after you are sure that your completed Menu.doc file is in your locker, delete it off the desktop and empty the recycle bin.**
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Monday 3/1/10
Verify that your NewspaperBruce.doc is complete.
 * __Do Now:__ **

**__Assignment:__** Objective: **Use a word processing program to do the desktop publishing task of creating a poster.** Filename: ** MusicGalore.doc ** Save to the desktop. Software: **Microsoft Word** Directions: **Follow the directions on pages 6 through 11 of Desktop Publishing/Microsoft Word, near the back of your red notebook.

**

Save the file to the desktop as **MusicGalore.doc**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it. <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">**Only after you are sure that your completed MusicGalore.doc file is in your locker, delete it off the desktop and empty the recycle bin.**
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Friday 2/26/10

 * __ Snow and Wind Day -- No School __**

Thursday 2/25/10
Look at the picture and think about the question. Discuss it with your neighbor. Share with the class when the teacher calls on you.
 * __Do Now:__ **
 * Think-Pair-Share:** How are the newspaper columns different than our usual way of aligning text?

@http://www.dailyblogtips.com/create-your-own-newspaper-headlines/ Objective: **Use a word processing program to do the desktop publishing task of creating a document with newspaper style columns and graphics.** Filename: ** NewspaperBruce.doc ** Save to the desktop. Software: **Microsoft Word** Directions: **Follow the directions on pages 1 through 5 of Desktop Publishing/Microsoft Word, near the back of your red notebook.**
 * For Fun:** Read about creating your own fake newspaper clippings.
 * __Assignment:__**

Save the file to the desktop as **NewpaperBruce.doc**, and then upload it to your Gaggle digital locker. Test that the file that you saved in your digital locker is correct by opening it. <span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">**Only after you are sure that your completed NewspaperBruce.doc file is in your locker, delete it off the desktop and empty the recycle bin.**
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Wednesday 2/24/10
**__Assignment:__** **Paper and Pencil:** Pages 2,3,4,5,6 of **Desktop Publishing--What Is It?** Page 1 is in the red notebook and has directions to find an occupation in the government database. Websites needed: http://www.bls.gov @http://www.bls.gov/oco/ocos276.htm @http://desktoppub.about.com/od/professional/a/2010_outlook.htm projections_through_2016 @http://en.wikipedia.org/wiki/Ergonomics @http://webvision.med.utah.edu/KallSpatial.html @http://en.wikipedia.org/wiki/Visual_acuity @http://webvision.med.utah.edu/KallDepth.html @http://en.wikipedia.org/wiki/Depth_perception @http://en.wikipedia.org/wiki/Field_of_vision

Turn in the finished packet with your name on it and the questions answered.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Monday, Tuesday 2/22,23/10
**__Assignment:__** **Paper and Pencil:** Pages 3,4,5,6 of **Desktop Publishing--What Is It?** Websites needed: @http://www.bls.gov/oco/ocos276.htm @http://webvision.med.utah.edu/KallSpatial.html @http://en.wikipedia.org/wiki/Visual_acuity @http://webvision.med.utah.edu/KallDepth.html @http://en.wikipedia.org/wiki/Depth_perception @http://en.wikipedia.org/wiki/Field_of_vision

Friday 2/19/10
What do you remember about Desktop Publishing from what you read yesterday? Answer this question on this Google form. media type="custom" key="5402343"
 * __Do Now:__ **

**__Assignment:__** **Paper and Pencil:** Page 3 of **Desktop Publishing--What Is It?** Nature of the Work If the substitute does not hand the paper to you, ask for it!!!!!! Websites needed: @http://www.bls.gov/oco/ocos276.htm @http://en.wikipedia.org/wiki/Ergonomics

Turn in page 3 with your name on it and the questions answered.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Thursday 2/18/10
Use conditional formatting on the PeopleSort.xls Age worksheet.
 * __Do Now:__ **
 * PeopleSort.xls**

**Paper and Pencil:** Follow the directions on page 1 in the back of your red notebook to get to the government website. http://www.bls.gov Follow the directions on page 2 and answer the questions on page 2. @http://desktoppub.about.com/od/professional/a/2010_outlook.htm projections_through_2016
 * __Assignment:__**
 * Desktop Publishing--What Is It?**

Turn in page 2 with your name on it and the questions answered.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Wednesday 2/17/10
Explain what conditional formatting is and how to do it. __** Assignment: **__ **PeopleSort.xls** Include some conditional formatting in your PeopleSort.xls file Make sure your file is completely finished. Ask permission to print it.
 * __Do Now:__ **
 * Paper and Pencil:**

Save **PeopleSort.xls** to the desktop and upload to your Gaggle digital locker.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Tuesday 2/16/10
Read @http://www.techonthenet.com/excel/questions/cond_format1.php __** Assignment: **__ **SnowDays.xls** Conditional Formatting
 * __Do Now:__ **

Save **SnowDays.xls** to the desktop and upload to your Gaggle digital locker.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Tuesday 2/9/10
Use Excel and =ROMAN(number or cell reference) to find the Roman numeral for 294. First correct answer wins bonus points. Get into Gaggle. Save your **PeopleSort.xls** file to the desktop and open it. __** Assignment: **__ **PeopleSort.xls** 1. Make a column in both the alphabetical and age worksheets for Kid/Adult 2. Use the IF function to determine the text to be put in the cells. 3. Use the autofill feature to copy the function to the rest of the rows. 4. Label the next column in each worksheet as Roman Numeral Age, making sure to maintain the formatting of the previous columns. 5. Use the =ROMAN(cell reference) function to display the Roman numeral version of the peoples' ages. 6. Set your Print Area. 7. Check the Print Preview for both the Alphabetical worksheet and the Age worksheet. Make final adjustments.
 * __Do Now:__ **

Save **PeopleSort.xls** to the desktop and upload to your Gaggle digital locker.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Go over work from Friday.
 * Monday 2/8/10**


 * Friday 2/5/10

Do Now: ** media type="custom" key="5302055"

PeopleSort.xls** 1. Make a column in both the alphabetical and age worksheets for Kid/Adult 2. Use the IF function to determine the text to be put in the cells. 3. Use the autofill feature to copy the function to the rest of the rows. 4. Label the next column in each worksheet as Roman Numeral Age, making sure to maintain the formatting of the previous columns. 5. Use the =ROMAN(cell reference) function to display the Roman numeral version of the peoples' ages.
 * __Assignment:__

Put the finishing touches on your spreadsheet and upload it to your Gaggle digital locker.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **


 * Thursday 2/4/10

Do Now: Read:** Read the front and back of the handout titled, **Fewer High School Students Taking Computer Science Classes**.

Write on paper or type in Microsoft Word:** 1. Summary of article 2. How this relates to you 3. What you would say in a blog post. Include your standard header and footer.
 * __Assignment:__

Turn in your hand-written paper or save your Word document as CSclassesArticle.doc and upload it to your Gaggle digital locker.
 * <span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">__Ticket out the Door:__ **

Wednesday 2/3/10
__**Do Now:**__ Get into Gaggle. Save your PeopleSort.xls file to the desktop and open it. Follow along with Miss Hangen as we fix up the spreadsheet. -**Sort** -Use **IF** function to tell whether the person is a kid or an adult.
 * __Assignment:__ **

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">**__Ticket out the Door:__** Save **PeopleSort.xls** to the desktop and upload to your Gaggle digital locker.

Tuesday 2/2/10
__**Do Now:**__
 * Paper and Pencil:** Write a couple sentences to tell what to do when you get to a stop sign when you are in a car.

1. Use Word, to create a flowchart of what to do at a traffic light. 2. Watch Pass Fail video and make a spreadsheet on your Word document that does the same thing. 3. Include whatever Miss Hangen demonstrates in your document. 4. Save it to the desktop as **IfFunctionExample.doc** and upload to your Gaggle digital locker.
 * __Assignment:__ **
 * Part I:**

Go through the following tutorials and example pages to find out how to us the **IF** function in Excel. @http://spreadsheets.about.com/od/tipsandfaqs/f/if_function_faq.htm @http://spreadsheets.about.com/od/excelfunctions/qt/07-if-function.htm @http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm @http://www.free-training-tutorial.com/animations/if-statement-numbers.html @http://www.free-training-tutorial.com/animations/if-statement-text.html @http://support.microsoft.com/kb/267982 compound condition @http://video.about.com/spreadsheets/IF-Function-in-Excel.htm
 * Part II:**
 * IF Tutorials:**

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">**__Ticket out the Door:__** Turn in the paper with your Do Now and Ticket out Door.
 * Paper and Pencil:** What do you want to use as the break off age for being a kid or an adult for the PeopleSort.xls assignment? Put your answer on your Do Now paper.

Monday 2/1/10
Continue working with your PeopleSort.xls spreadsheet by following the printed directions that are at your seat or in the red notebook. The direction sheet is titled, People Sort Directions and it is 2 pages.

Thursday 1/28/10
__**Do Now:**__
 * 1) What could you do with the data in your spreadsheet to make it easier to find a person on the list?
 * 2) How is the phone book arranged?
 * 3) Write the 3 sets of data here in alphabetical order. John Doe, Elise Doe, Juan Caliente
 * 4) What does ascending mean?
 * 5) What does descending mean?
 * 6) Write the 3 sets of data here in ascending order of age. Sanford 88, Tyrone 16, Marisol 23
 * 7) Write the 3 sets of data here in descending order by cost. Sonia 54, Hillary 63, Michelle 45

Go through the following tutorials and example pages to find out how to sort in Excel. Here is a sample spreadsheet to use. It has 2 worksheets. [] [] [] [] [] []
 * __Assignment:__ **
 * Sorting Tutorials:**


 * Sort the provided file in various ways. Upload to your Gaggle digital locker.**

<span style="background-color: #800000; color: #ffff00; font-family: Arial,Helvetica,sans-serif;">**__Ticket out the Door:__** What do you suppose we are going to do with your PeopleSort.xls file? Turn in the paper with your Do Now and Ticket out Door.

Wednesday 1/27/10
__ Assignment: __ Now adjust the following:
 * 1) Create a Spreadsheet in Excel and save it to the desktop with the filename, PeopleSort.xls
 * 2) Make it look like the one provided.
 * 3) Fill in names and data for ** 50 people **.
 * 4) They can be friends, relatives, students in this class, famous people, etc.
 * 5) If you don't know the age, estimate it or in the case of a famous person, look it up online.
 * 6) Save to the desktop and upload to your Gaggle digital locker.

<span style="color: #0000ff; font-family: 'Comic Sans MS',cursive;">**LET'S HAVE A FRESH START AND STAY ON TRACK FOR THE 2ND HALF OF THE YEAR!!!!!**
 * Tuesday 1/26/10**

__** Assignment: **__ We will be doing more with this spreadsheet.
 * 1) Create a Spreadsheet in Excel and save it to the desktop with the filename, PeopleSort.xls
 * 2) Make it look like the one provided.
 * 3) Fill in names and data for 29 people.
 * 4) They can be friends, relatives, students in this class, famous people, etc.
 * 5) If you don't know the age, estimate it or in the case of a famous person, look it up online.
 * 6) Save to the desktop and upload to your Gaggle digital locker.

First marking period assignments at QT1. Second marking period assignments at QT2.