Classroom Assignments

January 19

Objectives:

• Use the 10 key pad
• What is a spreadsheet?
• Identify parts of the excel screen

Assignment:

1. 10-key lesson at schools.learn2type.com
2. Make an Excel folder and save all your Excel files in this folder.
3. Use the green book
4. Complete tasks 1-6 on pages IE4-IE11 (purple section)
5. Study the information about parts of a spreadsheet in page IE4
6. Study the parts of the Excel screen on page IE5

Objectives:

• Identify workbook
• Identify worksheet parts

Assignment:

1. Workbook vs Worksheet demo
2. Use the green book. Remember helpful information is in the panels on the right side of the page. Read before you ask.
3. Complete Application 1-4 on pages IE12-IE16
4. Practice 10-key at schools.learn2type.com

Objectives:

• Navigating and editing in Excel

Assignment:

1. Use the XP book
2. Read the information and complete exercises on pages 362-372
3. Study the charts and graphics on pages 364, 365, and 367.
4. Practice 10-key at schools.learn2type.com

Objectives:

• More about editing cells
• Setup print options

Assignment:

1. Use the XP book
2. Read the information and complete exercises on pages 372-386
3. Study the charts and graphics on pages 374, 377, and 386.
4. Practice 10-key at schools.learn2type.com

Objectives:

• Practice editing and printing a worksheet

Assignment:

1. Use the XP book
2. Complete Exercises 1-18, 1-19, and 1-20 on pages 389-390. Print only Exercise 1-20.
3. Study the charts and graphics on pages 364, 365, 367, 374, 377, and 386.
4. Practice 10-key at schools.learn2type.com

Objectives:

• Test your knowledge of basis Excel skills

Assignment:

1. Written Quiz
2. Computer Quiz - Exercise 1-21 on pages 390-391

Objectives:

• More about entering and formatting labels
• Modify column width and row height
• Enter and format values

Assignment:

1. Use the XP book.
2. Read and complete the exercises on pages 393-411.
3. Practice 10-key at schools.learn2type.com

Objectives:

• Enter basic formulas

Assignment:

1. Use the XP book.
2. Read and complete the exercises on pages 411-419.
3. Study the table on page 419.
4. Practice 10-key at schools.learn2type.com

Objectives:

• Enter and format data in Excel

Assignment:

1. Use the XP book.
2. Complete exercise 2-19 and 2-20 on pages 422-423. Do not print.
3. Study the table on page 419.
4. Practice 10-key at schools.learn2type.com

Objectives:

• Practice entering and formatting data

Assignment:

1. New seating chart
2. Check your email for message with the subject 2-19
   if you earned 100, continue with the assignments below
   If you earned 81-99, open the attachment, read the comments, make corrections, save, and email. Then continue with the assignments below
   If you earned 0-80, complete the assignment in class with Mrs. Douglas. Then continue with the assignments below.
3. Use the XP book.
4. Complete exercise 2-21 and 2-22 on pages 423-425. Do not print.
5. Email exercise 2-22 to chs.c103@gmail.com
6. Practice 10-key at schools.learn2type.com

Objectives:

• Demonstrate knowledge and skill with labels, values, and simple formulas

Assignment:

1. Written exam.
2. 10-key exam.

Objectives:

• Explore built in editing and formatting tools

Assignment:

1. Use the XP book
2. Read and complete the exercises on pages 427-439.
3. Complete exercise 3-22 on page 454. Do not print.

Objectives:

• Auto formatting
• Print set up

Assignment:

1. Use the XP book
2. Read and complete the exercises on pages 439-451.

Objectives:

• Use auto format options

Assignment:

1. Use the XP book
2. Complete exercise 3-23 on pages 454-455. Do not print.
3. Complete exercise 3-24 on pages 455-456. Do not print.
4. Email 3-23 to chs.c103@gmail.com

Objectives:

• Edit and Format data in a workbook

Assignment:

1. Use the green book
2. Complete Task 1-6 on pages IE18-IE24. Remember helpful information is in the panels on the right side of the page. Read before you ask.
3. Go to this link. Choose Excel Pretest. Take one practice quiz being diligent at choosing correct answers. Email your score to chs.c103@gmail.com

Objectives:

• Formatting worksheets

Assignment:

1. Use the green book
2. Complete Application 1-3 on pages IE25-IE29. Remember helpful information is in the panels on the right side of the page. Read before you ask.
3. Practice 10-key at schools.learn2type.com

Objectives:

• Review Spreadsheet Parts
• Enter and Edit Data
• Perform Mathematical Calculations

Assignment:

1. Use the Basics book
2. Read pages 195-202. Remember to look at the pictures.
3. Complete Step-By-Step activities on pages 203-204.
4. Complete Project 43 on pages 204-206. Be sure to read all the information before you start working.

Objectives:

• Complete a spreadsheet with formulas
• Review Fill and AutoSUM

Assignment:

1. Use the Basics book
2. Complete Project 44 on pages 206-208. Be sure to read all the information before you start working.
3. Read pages 211-212
4. Complete Step-By-Step on pages 213-214

Objectives:

• Create a spreadsheet using Fill

Assignment:

1. Use the Basics book
2. Complete Project 45 on pages 215-216. Be sure to read all the information before you start working.
3. Complete Project 46 on pages 217-218. Be sure to read all the information before you start working.

Objectives:

Assignment:

1. Exam

Objectives:

• Inserting and Deleting Sheets and Cells
• More ways to enter labels
• Copy, Move, and Paste Cell Contents

Assignment:

1. Use the XP book
2. Read and complete exercises on pages 458-470. Take time to read. You are responsible for this information.

Objectives:

• Work with Columns and Rows
• Align Cells
• Borders and Shading

Assignment:

1. Use the XP book
2. Read and complete exercises on pages 470-488.

Objectives:

• Insert, Move, Cut, Copy, and Paste

Assignment:

1. Use the XP book
2. Use Word to answer the TRUE/FALSE and SHORT ANSWER questions on pages 489-490. Put your name in the header. Print.
3. Complete exercise 4-28 on pages 491-492.
4. Complete exercise 4-29 on page 492.

Objectives:

• Cell Alignment

Assignment:

1. Use the XP book
2. Complete exercise 4-30 on pages 492-493.
3. Complete exercise 4-31 on page 493.

Objectives:

• Organizing worksheets

Assignment:

1. Use the green book
2. Complete Task 1-6 on pages IE37-IE42. Remember helpful information is in the panels on the right side of the page. Read before you ask.

Objectives:

• Make your worksheets look good

Assignment:

1. Use the green book
2. Complete Application 1-4 on pages IE43-IE47. Remember helpful information is in the panels on the right side of the page. Read before you ask.
3. Use the Study Guide to prepare for the exam.

Objectives:

Assignment:

1. exam
2. The written part is online. Using Internet Explorer, open excel lesson4.htm from the Excel lesson 4 folder. Enter your name, the class email, answer the questions, and submit.
3. For the computer part, open lesson 4 computer exam.doc from the Excel lesson 4 folder. Be sure to enter your name in a header before you print.

Objectives:

Assignment:

1. Catch up day

Objectives:

• Perform calculation in spreadsheets

Assignment:

Objectives:

• Build addition and subtraction formulas
• Build formulas using multiplication and division
• Apply order of operation to formulas

Assignment:

1. Use the XP book
2. Start with exercise 5-2 at the bottom of page 498
3. Complete through exercise 5-9 on page 507
4. Use the Green book
5. complete task 1 on page IE 49
6. complete task 3 on page IE 51
7. complete application 1 on page IE 53
8. complete application 2 on page IE 54

Objectives:

• Use functions

Assignment:

1. Use the XP book
2. Complete exercises on pages 507-516
3. Use the Green book
4. complete task 1 on page IE 62
5. complete task 2 on page IE 63
6. complete task 3 on page IE 64

Objectives:

• Use relative and absolute references

Assignment:

1. Use the XP book
2. Complete exercises on pages 516-525
3. Use the Green book
4. complete task 4 on page IE 52
5. complete application 3 on page IE 55
6. complete application 5 on page IE 58
7. complete application 6 on page IE 59

Objectives:

• Use relative and absolute cell references
• Order of operation

Assignment:

1. Use the XP book
2. Complete exercise 5-24 on page 529
3. Complete exercise 5-25 on page 530
4. Open the file O of O.doc from the excel folder in the files folder. Follow the instructions.

Objectives:

• Using functions when creating business documents

Assignment:

1. Use the Basics book
2. Complete Project 51 on pages 241-242
3. Complete Project 52 on pages 243-244

Objectives:

• Format cells
• insert spreadsheet into a word document

Assignment:

1. Use the Basics book
2. Read pages 247-250
3. Complete Project 53 pages 251-252

Objectives:

• Integrate Word and Excel

Assignment:

1. Use the Basics book
2. Complete Project 55 pages 258-259

Objectives:

Assignment:

Objectives:

• Perform date arithmetic

Assignment:

1. Complete the assignments with Mrs. Douglas

Objectives:

• Use the IF function

Assignment:

1. Introduction to IF
2. Use the XP book
3. read and complete the exercises on pages 533-537
4. Exercise 6-18 on page 555

Objectives:

Assignment:

1. exam

Objectives:

Assignment:

Objectives:

• Use the IF function

Assignment:

1. use the green book
2. Complete task 4 on page IE 66
3. Complete Application 2 on page IE 69
4. Complete Application 4 on page IE 72

Objectives:

• Use the AND, OR, and NOT functions

Assignment:

1. Use the XP book
2. read and complete the exercises on pages 537-541
3. Exercise 6-20 on page 557
4. read and complete the exercises on pages 5414-546
5. Exercise 6-19 on page 556

Objectives:

• Practice functions

Assignment:

1. Complete the Functions handout. Save and print as instructed

Objectives:

• Create a chart in Excel

Assignment:

1. Classroom demonstration
2. Use the XP book
3. Read and complete the exercises on page 584-593 skipping exercise 8-2

Objectives:

• Create different types of charts

Assignment:

1. Review Chart Objects
2. Use the XP book
3. Read and complete the exercises on page 593-607

Objectives:

• Build charts from spreadsheet data

Assignment:

1. Review Chart Types
2. Use the XP book
3. Read and complete the exercises on page 608-612
4. Exercise 8-26 on page 615-617

Objectives:

• Create combination chart

Assignment:

1. Use the XP book
2. Exercise 8-25 on page 615
3. Exercise 8-27 on pages 617-618
4. Use Charts Study Guide to review concepts and vocabulary

Objectives:

• Practice charts

Assignment:

1. Use the green book
2. Task 1 on page IE 74
3. Task 2 on page IE 75
4. Application 1 on page IE 81
5. Application 2 on page IE 82
6. Application 3 on page IE 83
7. Application 4 on page IE 85
8. Use Charts Study Guide to review concepts and vocabulary

Objectives:

• Practice creating charts

Assignment:

1. Use the green book
2. Task 3 on page IE 77
3. Task 4 on page IE 79
4. Application 5 on page IE 87
5. Application 6 on page IE 89
6. Application 7 on page IE 91
7. Use Charts Study Guide to review concepts and vocabulary

Objectives:

• Review charting skills

Assignment:

1. Use Charts Study Guide to review concepts and vocabulary
2. exercise 8-28 on page 618 of the XP book

Objectives:

Assignment:

1. Excel Charts exam
   Hint: font size is 16pt

Objectives:

• Review basic formulas and functions
• Integrate Excel and Word

Assignment:

1. Complete and print SSInvA (March 14)
2. Complete Chart and letter handout

Objectives:

• Integrate Office applications

Assignment:

1. Complete the handouts
2. Grade papers

Objectives:

• Integrate Office applications

Assignment:

1. Continue working on handouts and grading
2. complete any missing assignments

Objectives:

Assignment:

1. Last day to complete assignments for the 5th 6 week grading period

Objectives:

• Identify parts of an Access database

Assignment:

1. Work together in class - pages 1000-1008

Objectives:

• Explore database Objects

Assignment:

1. Work together in class - finish lesson 1

Objectives:

• edit Objects

Assignment:

1. Copy from the T: drive to your file folder
2. Use the book Office XP
3. Read the information and complete the exercises on pages 1039-1046
4. Complete Exercise 2-20 on page 1074

Objectives:

• Explore Access Forms

Assignment:

1. Use the book Office XP
2. Read the information and complete the exercises on pages 1046-1058
3. Copy from the T: drive to your file folder

Objectives:

Assignment:

1. Use the book Office XP
2. Read the information and complete the exercises on pages 1063-1071
3. Complete Exercise 2-22 on page 1075

Objectives:

• Build a table

Assignment:

1. Start windows explore and navigate to your folder on the T: drive
2. open soccer.mdb
3. Add a field called COACH to the table
4. add a record for Salem with 16 wins, 4 ties, and 5 losses
5. enter your name as the coach for the Salem team
6. save the table
7. leave the database open for grading
8. THE WRITTEN EXAM IS POSTED ON THE SERVER - open book

Objectives:

• Reinforce basis access skills

Assignment:

1. check your email for exam results
2. Use Word to prepare a study guide. For every question you missed
   identify the questions by number
   Enter the correct answer as a complete sentence in your own words
   Identify the page from lessons 1 or lesson 2 in the book where you found the answer
   email on copy to chs.c103 for grading
   print one copy to study

Objectives:

• retake Access 1 exam

Assignment:

1. THE EXAM IS POSTED ON THE SERVER
2. Your grade is the average of this and the grade you earned Wednesday

Objectives:

Assignment:

Objectives:

Assignment:

1. Last day to complete study guide and retake exam

Objectives:

• Use the wizard for queries

Assignment:

Objectives:

• Create tables
• field properties

Assignment:

Objectives:

• Import tables

Assignment:

Objectives:

• Update query

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

1. follow this link

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

• Learn to use hyperlinks

Assignment:

1. Classroom demo
2. follow this link and play the games

Objectives:

• Create a presentation

Assignment:

1. In the XP book, exercise 3-21 on page 800
2. follow this link and play the games

Objectives:

• Slide Masters
• hyperlinks

Assignment:

1. hyperlink demonstration
2. In the XP book complete pages 866 to 868. Use the file Health1.ppt
3. complete exercise 5-25 on page 876-877

Objectives:

• create a non-linear presentation

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

• Introduction to the class.
• Establish computer lab rules and procedures.

Assignment:

1. Introduction.
2. Distribute syllabus and computer lab procedures
3. Discuss Computer Lab Procedures.
4. Discuss syllabus

Objectives:

• Explore available software.
• Explore e-mail standards

Assignment:

1. Introduction to Microsoft Office.
   Word
   Excel
   PowerPoint
   Publisher
   Access
   FrontPage
   Outlook
2. setup your account at classroom.zzn.com. Be sure to use your real name so I know who the e-mail is from.
3. save your login and password in a Word document.
4. Sending an e-mail
   enter the recipients address in the TO box
   send a secret copy by using BCC (blind carbon copy)
   always use a descriptive subject
5. Send an e-mail to Mrs. Douglas at chs.c103@gmail.com

Objectives:

• Improve keyboarding skills.

Assignment:

1. go to schools.learn2type.com
2. start with touch typing basics and progress through the lessons at your speed.

Objectives:

• Navigate the network
• Create a file folder (storage area).
• Set margins and alignment in Word 2007

Assignment:

1. Follow the instructions for accessing the local area network (LAN).
   open files from the classroom area
   create new folders
   open and save files to your storage area
2. open the file selection_letter from the 2007 files
   format as a block letter using the example in the business letter folder
   save in your storage area adding your initials to the front of the file name.
3. go to schools.learn2type.com for touch typing practice.

Objectives:

• Identify parts of a letter
• Explore formatting tools in Word 2007.

Assignment:

1. Review Parts of  a letter using the parts of a letter file from the business documents folder
   Make any necessary correction to the letter you you prepared last class period and e-mail as an attachment to chs.c103@gmail.com
2. Practice your keyboarding skills at schools.learn2type.com
3. Follow the class demonstration.

Objectives:

• Demonstrate knowledge of parts of a letter
• Practice using formatting tools
• Improve keyboarding skills.

Assignment:

1. Quiz.
2. Open the file reference_letter and format as a modified block letter.
   Save the file with your initials at the front of the file name.
   e-mail as an attachment to chs.c103@gmail.com
3. schools.learn2type.com - When your receive "good job" feedback you should go to the next exercise.

Objectives:

• Explore commands on the Home ribbon.
• Improve keyboarding skills.

Assignment:

1. Follow the class demonstration.
2. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Identify where in Office 2007 you find the menu options for the icons on the standard toolbar in office 2003.
• Improve Keyboarding skills.

Assignment:

1. Examine selected icons on the Standard Toolbar.
   New
   Open
   Save to default location
   Print to default printer
   Print Preview
   Spelling and Grammar
   Cut
   Copy
   Paste
   Format Painter
   Undo
   Redo
   Insert Table
   Columns
   Show/Hide
   Zoom
   Help
2. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Improve skills using selected icons on the standard toolbar.
• Improve Keyboarding skills.

Assignment:

1. Follow the instructions on the handout to practice using options on the Standard Toolbar.
2. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Identify where in Office 2007 you find the menu options for the icons on the standard toolbar in office 2003.
• review for exam

Assignment:

1. Work along with classroom demonstration to find menu options.
   New
   Open
   Save to default location
   Print to default printer
   Print Preview
   Spelling and Grammar
   Cut
   Copy
   Paste
   Format Painter
   Undo
   Redo
   Insert Table
   Columns
   Show/Hide
   Zoom
   Help
2. Review at http://www.internet4classrooms.com/msword_toolbar_format.htm and http://www.internet4classrooms.com/msword_toolbar.htm

Objectives:

• Display your knowledge of the Formatting Toolbar and the Standard Toolbar.

Assignment:

1. Formatting and standard toolbar exam.
2. In the Office XP book, read page 8-15 and complete the exercises. Save files in your file folder.
3. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Enter text
• Move the insertion point
• Use text wrap
• Edit text
• Save a document
• Print a document

Assignment:

1. Participate in header demonstration.
2. In the Office XP book, read page 16-27 and complete the exercises. Save files in your file folder.
3. Use word to answer True/False and Short Answer questions on pages 28 and 29. Put your name in the header. Use Print Preview to check your document before printing. Print to LJ3600.

Objectives:

• Key, Edit, and Print a document

Assignment:

1. Exercise 1-15 on page 31. Put your name in the header. Use Print Preview to check your document before printing. Print to LJ3600.
2. Exercise 1-16 on page 32. Proofreaders marks are on the handout at your workstation. Put your name in the header. Use Print Preview to check your document before printing. Print to LJ3600.

Objectives:

• Demonstrate basic Word skills

Assignment:

1. Unit 1 exam.
   Practice part: In the green book, Application 4 on page IW (Introductory Word) 18-19. Place your name in a header. Use Print Preview to check your document before printing. Print to LJ3600.
   Written part: Pick up the written test from Mrs. Douglas. Return the completed exam to the basket for your class. You may use your computer during the written exam.

Objectives:

• Formatting characters
• Explore font options

Assignment:

1. In the Office XP book, read pages 62-72 and complete the exercises. Save files in your file folder.
2. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Copy Formats
• Change Case
• Highlight Text
• Using the Task Pane

Assignment:

1. Return and review exam.
2. In the Office XP book, read page 72-82 and complete the exercises. Save files in your file folder.
3. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Practice formatting text

Assignment:

1. Exercise 3-17 on page 86. Put your name in the header. Use Print Preview to check your document before printing. Print to LJ3600.
2. Exercise 3-18 on pages 86-87. Put your name in the header. Use Print Preview to check your document before printing. Print to LJ3600.
3. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

• Helpful Word Features
• Prepare business documents

Assignment:

1. Use the Green Book today.
2. Tasks 1-5 on pages IW 23-28. Be sure to read the information along the right side of the page.
3. Application 3 on page IW 35. Check Appendix F-2 to learn the parts of a business letter and the proper spacing.
4. schools.learn2type.com. Work at your level. The goal is to improve your touch typing skill. Don't look at the keyboard.

Objectives:

Assignment:

Objectives:

• Demonstrate formatting skills.

Assignment:

1. Written exam. Be sure to include your name.
2. Application based exam. Place your name in a header. Use Print Preview to check your document. Print to the LJ3600.

Objectives:

• Apply your formatting skill to create a letterhead

Assignment:

1. You are an employee of Adventure Travel. You have been assigned the task of creating a letterhead for the business. Remember that letterheads should not take more than 1.5 inches at the top of the page. Do not use WordArt for this assignment.
2. Information you need:
   Company Name - Adventure Travel
   Company Address - 345 Fort Avenue, Austin, Texas 78123
   Company Telephone - 1-800-777-0004
   Company e-mail - findyourfun@adventure.com
3. For this assignment place your name in the footer. Use print preview to check your document prior to printing. Print to the LJ3600.
4. Go to schools.learn2type.com and work on improving the speed and accuracy of your keyboarding skills.

Objectives:

Assignment:

1. Key a business letter using the handout information. Refer to F-2 in the green book for proper format.
2. Use the following additional information:
   you are the sender
   Your title is Travel Agent
   Use today's date
   the letter is to
   Margaret Jones
   9325 W. 38th Street
   Denver, CO  80021
3. Save as travel letter
4. Do not use a header or footer. Use print preview to check your document. Print to the LJ3600 on the letterhead you printed last class.

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

Assignment:

Objectives:

• Set Margins
• Prepare Business Letter

Assignment:

1. Classroom demonstration on setting margins.
2. Discuss Letterhead.
3. Set margins for a business letter.
4. Prepare a business letter to be printed on letterhead. Use the handout for information to include in your letter. Use the Business Letter style.
5. Review the information at http://jobsearchtech.about.com/library/block-sample1.rtf

Objectives:

• set up class e-mail account
• define netiquette
• create a letter on preprinted letterhead

Assignment:

1. Use the handout information to create a business letter. Refer to page F2 in the green book.
2. follow the instructions for creating an e-mail account at this site
3. DO NOT provide personal information on the Internet. What is personal information?
   your name
   Your picture
   your address
   the school you attend
   names of anyone; yourself, your friends, your enemies, your family, your neighbors
   places you go
   activities you are involved in
4. This email account is for school assignments only. Use this only to communicate with your teacher
5. Discuss the proper form for business electronic communication
6. practice sending e-mails with attachments to chs.c103@gmail.com
7. timed typing at schools.learn2type.com

Catch up all work. Last chance to turn in assignments for the first 6 weeks

Objectives:

• Draw graphics using the drawing toolbar

Assignment:

1. In the green book, complete task 6 on page IW87, task 7 on page IW89, task 8 on page IW90, task 9 on IW91, and task 10 on page IW92.
2. Complete application 3 on page IW96 and application 4 on page IW97
3. Practice using the features on the drawing toolbar.
4. to turn off the drawing canvas - Tools>Option>general tab
5. One at a time you will print travel letter on the letterhead you created.

Objectives:

• Create a personal letterhead

Assignment:

1. Complete the assignment from last class.
2. Use your skills with formatting and the drawing tools to create or improve your personal letterhead.

Objectives:

• define netiquette
• Use formatting and drawing skills in a business document

Assignment:

1. DO NOT provide personal information on the Internet. What is personal information?
   your name
   Your picture
   your address
   the school you attend
   names of anyone; yourself, your friends, your enemies, your family, your neighbors
   places you go
   activities you are involved in
2. This email account is for school assignments only. Use this only to communicate with your teacher
3. Discuss the proper form for business electronic communication
4. Attach Home Sale Poster to an email sent to chs.c103@gmail.com
5. With instructor approval, print your business letter on your business letterhead
6. Finish designing your personal letterhead.

Objectives:

• Use the proper format to create a personal letter

Assignment:

1. Print one copy of your personal letterhead.
2. Turn to page F 3 in the green book and study the proper format for a personal letter.
3. Write a personal letter to your friend making plans for Thanksgiving. The return address is your address. Save as thanksgiving.

Objectives:

• Explore different types of letterhead

Assignment:

1. Prepare your personal letter for printing.
   The top margin is at least 2 inches, but less than 3 inches
   The letter is centered vertically on the page
   You have at least three paragraphs
   All spelling and grammar are correct
2. One person at a time, get your personal letterhead and print your personal letter on your personal letterhead
3. Use the book Desktop Publishing Activities Examine the letterhead on pages 21, 59, 61, 85, 97, 111, 113, 115, 117, and 121.
4. Create a letterhead for
   The Mandarin
   a Chinese restaurant located at
   147 Pagoda Lane
   Houston, Texas  78254
   the telephone number is
   409-888-6541

Objectives:

• Explore the Paragraph formatting dialog box

Assignment:

1. Open the file balloon2.doc from the XP book files
2. Work along with the classroom demonstration
   What is a paragraph in Word?
   alignment
   line spacing
   indentation
   spacing before and after paragraphs

Objectives:

Assignment:

Objectives:

• Use drawing tools to create interesting graphics

Assignment:

1. Using the book Desktop Publishing Activities practice your drawing skills by creating the shapes shown on page 35

Objectives:

• create graphics using basic shapes

Assignment:

1. Using the book Desktop Publishing Activities create the shapes shown on page 37

Objectives:

• Use formatting skills to create a business document

Assignment:

1. Create a full page document announcing the opening of The Mandarin Chinese restaurant.
2. The opening date is October 26.
3. Using the book Desktop Publishing Activities examine the following pages for ideas: 171, 173, 175, 177, 179, 181, 183, 185, 187, 189, 191
4. You must demonstrate usage of the following skills in your design
   alignment other than left
   indentation
   line spacing other than single
   paragraph spacing
   use of drawing tools to add lines and shapes
5. This assignment should take two class periods.

Objectives:

• Use formatting skills to create a business document

Assignment:

1. Continue the assignment started yesterday and email to chs.c103@gmail.com

Objectives:

• Using tables to arrange text on the page

Assignment:

1. Classroom demonstration
2. In the Desktop Publishing Activities book, turn to page 207
3. Insert a table with 5 columns and 14 rows
4. Begin in the 2nd row, 3rd column and enter the categories
5. Adjust the margins and column widths
6. Merge top row and add graphic
7. Adjust rows and columns, add graphics to complete

Objectives:

• Using tables to arrange text on the page

Assignment:

1. Complete the menu in a table started last class period
2. Be sure to add graphics as shown in the book. Make your sheet look exactly like the picture in the book
3. e-mail to chs.c103@gmail.com Be sure to put the file name in the subject

Objectives:

• use tables and drawing tool to create a business document

Assignment:

1. The owners of The Mandarin restaurant are not pleased with their current menu. You must design a new menu using tables and the drawing tools. You may use clip art and WordArt. Your teacher will give you a copy of the current menu. (Isn't it ugly)
2. You have 3 class periods to complete this activity

Objectives:

• use tables and drawing tool to create a business document

Assignment:

1. Complete the menu activity

Objectives:

• use tables and drawing tool to create a business document

Assignment:

1. Complete the menu activity

Objectives:

• use tables and drawing tool to create a business document

Assignment:

1. Complete the menu activity

Objectives:

• Using tabs to arrange text on the page

Assignment:

1. Use the XP book
2. read and complete the activities on pages 124-138

Objectives:

• Quick and Easy tab lessons

Assignment:

1. Use the green book.
2. Complete Task 5 on page IW66
3. Complete Application 1 on page IW70-71
4. Complete Application 4 on page IW76. Use print preview to confirm your document is only one page. Print to the LJ3600. This will count as an exam grade.

Objectives:

• Use tabs to arrange text in columns

Assignment:

1. Use the XP book.
2. Complete exercise 5-8 on page 141
3. Complete exercise 5-9 on page 141-2
4. Complete exercise 5-11 on page143

Objectives:

• Use tabs in a business memo

Assignment:

1. Examine the proper form for a business memo in Appendix F on page A44
2. Open a new word document.
3. Set your margins for a business memo
4. set a custom tab for the heading
5. Use the information on the handout to generate a business memo
6. Save as opening memo

Objectives:

• More fun with tables

Assignment:

1. Send an email with the file opening memo attached
2. Check your email for grading and feedback. Any grade of 75 or lass can be resubmitted. You MUST email any missing or redone file to chs.c103@gmail.com.  The last day to submit assignments from this 6 weeks is Nov. 7. Remember, you must email your files.
3. Use the XP book
4. Complete exercise 9-15 on page 277.
   step 6 - see page 267
   step 7 - page 264-5
   step 8 - page 270 - 1
   step 11 - page 260
   step 14 - page 268
   step 15 - see page setup
5. Complete exercise 9-17 on pages 279-80

Objectives:

• Use tables in business documents

Assignment:

1. Check your email and make corrections as required. Remember, you must email as attachments to chs.c103@gmail.com
2. Use the XP book
3. Finish exercises 9-15 and 9-17 started yesterday

Objectives:

• table formatting

Assignment:

1. Setup assignment tracking table
   5 columns
   40 rows
   column headings - Date, Book, Page, File Name, Complete?
2. Use the book Computer Project Basics. Complete project 33 on pages 157-159.

Objectives:

• demonstrate table skills

Assignment:

1. Complete exercise 9-16 on page 278 as an exam grade. Remember to refer to the book if you need help. Email as an attachment to chs.c103@gmail.com
2. schools.learn2type.com

Objectives:

• Use tables to create business forms

Assignment:

1. Use the book Computer Project Basics. Complete project 37 on pages 167-168.

Objectives:

• Use columns to arrange text on the page

Assignment:

1. Use the XP book
2. Read and complete the exercises on pages 282-292

Objectives:

• create a document with two balanced columns

Assignment:

1. In the XP book, exercise 10-8 on page 295
2. exercise 10-9 on page 295-296

Objectives:

• Prepare a newsletter

Assignment:

1. Use the green book
2. Task 1 on page IW 80
3. Task 2 on page IW 81
4. Task 3 on page IW 82
5. Task 4 on page IW 83-84
6. Application 1 on page IW 93

Objectives:

Objectives:

• Use alignment, margins, and tabs to arrange text on the page

Assignment:

1. Use the Desktop Publishing Activities book. Complete Exercise 47 on page 87. You must use a decimal tab and dot leaders to enter the prices.

Objectives:

• What does a Desktop Publishing application do?

Assignment:

1. Start Publisher
2. Use the Basics book
3. Read pages 307-311 and complete the Step-By-Step activities
4. Vocabulary:
   Desktop Publishing
   Text Frame (Box)
   Serif font
   Sans Serif font
   Frame Linking
   Text Wrap
5. Complete Project 70 on pages 312-313. Read all the instructions before you start. Save as Project 70 in your Publisher folder.
    

Objectives:

• Using Layout Guides to arrange text

Assignment:

1. Start Publisher
2. Work along with the classroom demonstration on Layout Guides
   Margin Guides - change to .25
   Grid Guides - 2 columns, 4 rows, 0 spacing
   draw a rectangle to fit the cell and fill with color of your choice
   copy (ctrl+c) and paste (ctrl+v) to other cells
   arrange using the arrow keys
   discuss printing and cutting considerations
   Grid Guides - .5 spacing, center guide
   delete rectangles
   save this file as notes
3. Use the Basics book
4. Project 71 on page 314. You will have time tomorrow to finish. Bring pictures to scan, or you may use cameras to take pictures. Be sure to use layout guides to arrange text.

Objectives:

• create desktop publishing documents using Publisher

Assignment:

1. Finish Project 71
2. Design a Logo for the company named All-American Toys. This company sells toys on-line. All the toys they sell are made in America. Use the software of your choice. Save the logo.

Objectives:

• create personalized note pad using publisher

Assignment:

1. Continue working on your logo design.
2. Start designing a notepad for you, the owner of All-American Toys. Use your file notes as the layout but change from 4 rows to 2 rows. Things to remember ...
   use your logo
   include your name
   leave room to write
   do not fill the entire sheet of paper with color
3. save the notepad as toy notes

Objectives:

• Practice Publisher skills

Assignment:

1. Finish assignments
   project 70
   notes
   project 71
   logo
   toy notes
2. Use the Desktop Publishing Activities book. Complete exercise 64 on page 117.
3. Turn on the standard, formatting, and objects toolbars. (View>Toolbars) Review each icon. Be sure you know what the do.
4. Turn on the ruler. (View>Rulers). Be sure you can read and use the rulers.
5. Practice setting Layout Guides and Grid Guides

Objectives:

• Explore the options on Publisher's Arrange menu
• Text linking

Assignment:

1. Start Publisher
2. In a one page document set margins at .25 and set grid guides to 2 columns and 4 rows.
3. draw a 5" square, fill with red, line 6pt green
4. move top right corner of square to top right corner of 2nd row, 2nd column
5. draw an isosceles triangle with 3" base, fill with pink, line 3pt blue dashed
6. adjust the triangle to 4" tall
7. draw a moon, 3" wide, 7" tall
8. fill the moon with yellow and no line
9. move the triangle and moon on top of the square
10. set the order triangle, square, moon; top to bottom
11. copy the moon
12. flip one moon horizontally
13. change the triangle to a four point star
14. make three copies of the star
15. select all four stars and distribute vertically
16. rotate the 1st and 3rd stars 45 degrees
17. select all four stars and group them
18. select the stars and align center
19. select the square and align bottom
20. View>Toolbars and turn on the Connect Text Boxes toolbar
21. insert a new page after the current page
22. change the grid guides to 2 columns with .5 space and 1 row
23. draw a text box that starts 2" from the top and 1/2" from the left of the page the width of the first column
24. Insert>Text file from the XP book - business.doc - answer No to auto flow
25. adjust the text box to hold the entire file
26. draw another text box starting 1/4" below the first text box
27. Insert>Text file from the XP book - Interest.doc - answer No to auto flow
28. draw a text box in the 2nd column beginning 2" from the top of the page
29. click at the end of the text in the first column, click on the Create Text Box Link icon
30. click in the text box in the second column
31. notice that additional text exists
32. Insert a new page, draw a text box, link text to the new text box
33. make adjustment to fit all text on one page
34. draw a text box across the top of page 2
35. enter
    Traveling In....
    NEW MEXICO
36. use a sans serif font, bold, 48 point, blue, centered, with characters tracking set to very loose
37. on the Internet go to google.com and search for "mission of san miguel of santa fe"
38. choose images and double click on the first image
39. right click on the thumbnail at the top of the page and choose Save Target As, navigate to your publisher folder and name the file san miguel
40. in publisher with page 2 showing, draw a picture frame in the gray work area with a picture from file and choose san miguel.jpg
41. use the crop tool from the picture toolbar to crop the picture - zoom in if necessary
42. size the picture to about 2" x 2"
43. place the picture close to the story about San Miguel
44. Make adjustments to keep the text on one page
45. delete page 3

Objectives:

• create documents with multiple columns

Assignment:

1. Use the Basics book
2. Read pages 317-321 and complete the Step-By-Step activities
3. Project 72, read all the instructions before you start

Objectives:

• create documents with multiple columns

Assignment:

1. continue work on Project 72
2. Start collecting information about the recent problems with toys from China. Save information to document your sources.
3. Improve your search technique by using the information at this site. http://www.internettutorials.net/boolean.html

Objectives:

• prepare a multi-column newsletter using Publisher

Assignment:

1. E-mail Project 72 to chs.c103@gmail.com
2. All-American Toys will distribute a newsletter to customers reporting the problems with imported toys and emphasizing that all their toys are made in America. You may copy some news stories (with credit given) but you must write at least one story.
3. requirements:
   at least 2 pages
   text font 11 or 12 point
   single spaced
   minimal white space
   at least one original story
   cite your source for every copied element
   at least 6 graphics
4. You have three class periods to prepare and print this document. Place the completed document in your portfolio.

Objectives:

• prepare a multi-column newsletter using Publisher

Assignment:

1. newsletter project

Objectives:

• prepare a multi-column newsletter using Publisher

Assignment:

1. newsletter project - due today

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Workstations 1-4 print 5 copies of toy notes
2. cut and glue note pads
3. Design a calendar for January 2009. Start with a blank page. Use paper size of 8 1/2 by 14. Use 1/2 the sheet for a picture and 1/2 the sheet for the calendar. Include an advertisement for All American Toys.

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Workstations 17-20 print 5 copies of toy notes
2. cut and glue note pads
3. Design a calendar for January 2009. Start with a blank page. Use paper size of 8 1/2 by 14. Use 1/2 the sheet for a picture and 1/2 the sheet for the calendar. Include an advertisement for All American Toys.

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Workstations 9-12 and 5 print 5 copies of toy notes
2. cut and glue note pads
3. Use the Desktop Publishing Activities Book
4. Complete Exercise 47 on pages 86-87

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Workstations 21-24 and 6 print 5 copies of toy notes
2. cut and glue note pads
3. Use the Desktop Publishing Activities Book
4. Complete Exercise 47 on pages 86-87

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Choose one of the following from the Desktop Publishing Activities book. You will have time tomorrow to finish.
    exercise 61 on pages 110-111
    exercise 62 on pages 112-113
    exercise 63 on pages 114-115

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Print calendars - one month only
2. Choose one of the following
   exercise 61 on pages 110-111
   exercise 62 on pages 112-113
   exercise 63 on pages 114-115

Objectives:

• Apply Publisher skills to prepare business publications

Assignment:

1. Publisher exam using the book Desktop Publishing Activities
2. Choose one of the following
   exercise 94 on pages 182-183
   exercise 95 on pages 184-185
   exercise 96 on pages 186-187
3. You will print your final document for grading. The document should:
   fill one 8 1/2 x 11 sheet of paper with margins as specified in instructions,
   look exactly like the picture except you may use different, but similar, clip art.
   Use your choice of serif or sans serif fonts as shown
   include your choice of colors, but DO NOT fill text boxes
4. This is due at the end of the class period tomorrow.

December 18  

Objectives:

• Demonstrate Publisher Skills

Assignment:

1. Complete Publisher exam

Objectives:

• Demonstrate Publisher Skills

Assignment:

1. Complete Publisher exam

Objectives:

• What is Mail Merge?

Assignment:

1. Create customized documents such as letters, labels, envelopes, certificates, etc.
2. Word has a mail merge wizard that makes the process easy
3. Step through the wizard with Mrs. Douglas

• Use Mail Merge to prepare customized business document

Assignment:

1. Key the letter shown on the handout using the proper format for a business letter. You will use preprinted letterhead, so set the top margin at 2 inches
2. Use Mail Merge to prepare a letter to each of the people on the names1 list
3. save as mandarin letter

Objectives:

Assignment:

1. print 5 copies of your mandarin letterhead. Do not include your name in the header or footer
2. print one copy of the Mandarin Opening flyer
3. print one copy of your menu. See Mrs. Douglas to setup front and back printing
4. print one copy of your opening memo on letterhead
5. print the 4 business letters on your letterhead
6. Gather all information in a folder with your name. This is due tomorrow.

Objectives:

• Prepare a business document portfolio
• Improve keyboarding skills

Assignment:

1. Complete printing your portfolio
2. Finish any incomplete assignments.
3. Check your email
4. go to schools.learn2type.com and demonstrate your improved skills

Objectives:

• Review Word screen parts
• Review Character formatting
• Review Paragraph spacing
• Prepare a Personal Business Letter

Assignment:

1. Use the Basics Book
2. Read pages 75-80
3. Complete Project 16 on pages 81-83. Email your letter to chs.c103@gmail.com

Objectives:

• Review using tab stops
• Prepare a Personal Business Letter using tab to create a table
• Improve touch typing skills

Assignment:

1. Use the Basics Book
2. Read pages 85-87
3. Complete Project 17 on pages 88-89. Email your letter to chs.c103@gmail.com
4. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Type a report
• Insert graphics into a report

Assignment:

1. Use the Basics Book
2. Read pages 99-102
3. Complete Project 20 on pages 104-106. Email your letter to chs.c103@gmail.com
4. Complete Project 21 on pages 106-108. Print. Place the document in the basket for your class.
5. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Use secondary headings in a report

Assignment:

1. Use the Basics Book
2. Read pages 109-110
3. Complete Project 22 on pages 111-112. Email your letter to chs.c103@gmail.com
4. Complete Project 24 on pages 116-118.
5. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Create a newsletter
• Create an article

Assignment:

1. Use the Basics Book
2. Complete Project 26 on pages 122-124. Email your letter to chs.c103@gmail.com
3. Complete Project 27 on pages 124-125. Print. Place the document in the basket for your class.
4. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Create a brochure

Assignment:

1. Use the Basics Book
2. Complete Project 26 on pages 122-124. Email your letter to chs.c103@gmail.com
3. Finish any incomplete assignments.
4. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Create tables

Assignment:

1. Use the XP book
2. Complete exercise 9-17 on page 279
3. Finish any incomplete assignments.
4. Go to schools.learn2type.com and complete 3 timed typing.

Objectives:

• Complete online review
• Improve touch typing skills

Assignment:

1. Follow instructions to open and complete online review activity. Complete quizzes for chapters 1-10. Refer to the indicated pages in the XP book and review the information for every missed question.
2. Go to schools.learn2type.com and complete 3 timed typing.

Demonstrate ability to create a business letter

1. Read the information at the top of your handout.
2. Open the file tristate letterhead from the exam folder
3. Open the file auction from the exam folder
4. Copy the text from auction.doc and paste it into tristate letterhead.doc
5. Save the file as auto auction
6. Change the left and right margins to one inch
7. Make the corrections as shown on the handout.
8. Compose a new last paragraph that makes the following points:
   You appreciate Angel's Used Cars' past patronage.
   Representatives will be on hand to address any questions.
   You look forward to doing continued business with Angel's Used Cars.
9. Format the document as a modified-block letter. Include the following:
   Today's date
   Special mailing instructions (if necessary)
   Inside address
   Salutation
   Closing
   Enclosure notation (if necessary)
   http://owl.english.purdue.edu/owl/resource/653/02/
10. Made the necessary adjustments to keep the letter on one page
11. Put your name in the header
12. Print one copy to the 3600 and turn in to the basket in the front of the room
13. Save and Close

Demonstrate Ability to Create an Activities Schedule

1. Open a new document.
2. Set the left and right margins to .5
3. Create a table with 6 rows and eight columns
4. Size columns 1, 3, 5, and 7 to .5"
5. Size the remaining columns to 1.25"
6. Merge the first row and enter the text shown using fonts and font sizes similar to those shown
7. Merge the cells in columns 1, 3, 5, and 7
8. Enter and change the text direction in cells shown.
9. Enter all remaining text. Center all text horizontally and vertically in the cells
10. Save the file as schedule
11. Put your name in the header
12. Print one copy to the 3600 and turn in to the basket in the front of the room
13. Close