Exploring the Basics of Microsoft Windows XP

Homework for week 2:
Part A –
Read WIN 3 – WIN 23, completing the yellow hands-on practice sections as you proceed.
Complete Session 1 Quick Check
Part B –
Read EC 3 – EC 5; memorize the definitions of all the bold terms
Part C –
Visit the publisher web site and explore what resources are available to you.

New Perspectives Office 2003

Material is copyright protected. It is intended for those who have purchased the book but have not yet received it.

WIN1 - WIN23 (PDF)

EC3 - EC5 (PDF)

Study quiz 1

Exploring the Basics of Microsoft Windows XP – continued

Homework for week 3:
Part A –
Read WIN 24 – WIN  35, completing the yellow hands-on practice sections as you proceed.
Complete Session 2 Quick Check; Study the Key Terms at the end of the chapter (WIN 36)
Part B –
Read EC 6 up to the section “Computer Hardware” on EC 9; memorize the definitions of all the bold terms
Part C –
Select ONLY ONE of any of the 4 case problems to complete from the Windows XP chapter (WIN 37- WIN 40)

New Perspectives Office 2003

Material is copyright protected. It is intended for those who have purchased the book but have not yet received it.

WIN24 - WIN40 (PDF)

EC6 - EC9 (PDF)

Managing Your Files

Homework for week 4:
Part A –
Read FM 2 – FM 7 up to “Exploring Files and Folders

Part B –
Read FM 7 – FM 20, completing the yellow hands-on practice sections as you proceed.
Complete Quick Check; Study the Key Terms at the end of the chapter (FM 21)
Use the CD to run the SAM program and complete the tasks under “Managing Your Files”. Print your results and place them in your notebook.

Part C –
Read EC 9 up to the section “Processing Hardware” on EC 13; memorize the definitions of all the bold terms

New Perspectives Office 2003

Material is copyright protected. It is intended for those who have purchased the book but have not yet received it.

EC9 - EC13 (PDF)

FM 20 - QuickCheck (PDF)

Managing Your Files – continued

Part A –
Use the CD to run the SAM program and complete the tasks under “Managing Your Files”. Print your results and place them in your notebook.

Part B –
Read EC 13 “Processing Hardware” up to the section “Storage Devices and Media” on EC 17; memorize the definitions of all the bold terms

Part C –
Complete Case Problem 1, page FM22

Browser and E-mail Basics

Homework for week 6:

Part A –
Read BEB 2 – BEB  21, completing the yellow hands-on practice sections as you proceed.
Complete Session 1 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Read EC 17 “Storage Devices and Media” up to the section “Data Communications” on EC 22; memorize the definitions of all the bold terms

Part C –
Review & catch-up. Finish any missed assignments. Write down questions about any topics that you are not sure about.

Browser and E-mail Basics - continued

Homework for week 7:

Part A –
Read BEB 22 – BEB  35, completing the yellow hands-on practice sections as you proceed.
Complete Session 2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Read EC 22 “Data Communications” up to the section “Computer Software” on EC 27; memorize the definitions of all the bold terms

Part C –
Research the term “netiquette” using the Internet.and write a brief summary that describes the topic, addressing it to someone who is not familiar with the term. Your summary should be one page or less.

Using Common Features of Microsoft Office 2003

Homework for week 8:

Part A –
Read OFF 2 – OFF 30, completing the yellow hands-on practice sections as you proceed.
Complete Quick Check; Study/memorize the Key Terms in bold.

Part B –
Read EC 27 “Computer Software” through EC 34; memorize the definitions of all the bold terms

Microsoft Office Word 2003

Homework for week 9:

Part A –
Read WD2 – WD 31, completing the yellow hands-on practice sections as you proceed.
Complete Session 1.1 & 1.2 Quick Checks; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 1 on page WD34-35 and place the printed result in your class notebook.

Part C –
Complete Case Problem 3 on page WD36-37 and place the printed result in your class notebook.

Part D –
Complete Case Problem 4 on page WD38 and place the printed result in your class notebook.

Microsoft Office Word 2003

Homework for week 10:

Part A –
Read WD 41 – WD 78, completing the yellow hands-on practice sections as you proceed.
Complete Session 2.1 & 2.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 1 on page WD81-82 and place the printed result in your class notebook.

Part C –
Complete Case Problem 3 on page WD 84 - 85 and place the printed result in your class notebook.

Part D –
Complete Case Problem 4 on page WD 85 - 87 and place the printed result in your class notebook.

Microsoft Office Word 2003 continued

Homework for week 11:

Part A –
Read WD 89 – WD 124, completing the yellow hands-on practice sections as you proceed.
Complete Session 3.1 & 3.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 1 on page WD128-129 and place the printed result in your class notebook.

Part C –
Complete Case Problem 3 on page WD 130 - 85 and place the printed result in your class notebook.

Part D –
Complete Case Problem 4 on page WD 131 - 132 and place the printed result in your class notebook. Send your completed project document as an attachment to an e-mail. Address your e-mail to preceptsed@gmail.com. In the subject line enter your last name, first name followed by a '-' and then the words "Case Problem 4". An example is: "Pond, Andrew - Case Problem 4"

Bring your class notebook up-to-date. Complete all missed assignments and project and place them in your notebook with your name and date.

Microsoft Office Word 2003 continued

Homework for week 12:

Part A –
Read WD 135 – WD 149, completing the yellow hands-on practice sections as you proceed.
Complete Session 4.1 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Review Assignments on page WD 174-175. Store a final copy of your assignment on your USB drive.

Part C –
Complete Case Problem 1 on page WD 175-176. Store a final copy of your assignment on your USB drive.

Microsoft Office Word 2003 continued

Homework for week 13:

Part A –
Read WD 149 – WD 172, completing the yellow hands-on practice sections as you proceed.
Complete Session 4.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 3 on page WD 178-181. Store a final copy of your assignment on your USB drive.

Part C –
Complete Case Problem 4 on page WD 181-182. Store a final copy of your assignment on your USB drive.

Microsoft Office Excel 2003

Homework for week 15:

Part A –
Read EX 2 – EX 23, completing the yellow hands-on practice sections as you proceed.
Complete Session 1.1 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Continue developing the spreadsheet we built in class. You are to imagine that you are living on your own and need to create a budget for all your expenses. As part of the "deductions" section of your spreadsheet, add in categories for rent, food, gas, entertainment, phone and insurance. Ask one of your parents to help you determine what are realistic numbers to enter for these items.

Additionally, next to the column listing weekly income and expenses, add one that shows monthly and then yearly totals for each area. We will review your results next class.

Microsoft Office Excel 2003

Homework for week 16:

Part A –
Read EX 24 – EX 43, completing the yellow hands-on practice sections as you proceed.
Complete Session 1.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Practice, Review Assignments on page EX 44. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part C –
Complete Case Problem 1 on page EX 46. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part D –
Complete Case Problem 3 on page EX 48. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Microsoft Office Excel 2003

Homework for week 17:

Part A –
Read EX 51 – EX 73, completing the yellow hands-on practice sections as you proceed.
Complete Session 2.1 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 1 on page EX 87. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part C –
Complete Case Problem 2 on page EX 88. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

**** UPDATE ***** Case problem #2 uses the If function with logical comparison, which is a topic we have not yet covered. As such, let me challenge you to try and figure it out and we'll cover it in class.

Part D –
Using the stock portfolio spreadsheet that we have been building in class, use the transaction worksheet to record your selection of stocks that you want to invest in. Each student is provided $50,000 to 'purchase' stocks and build a mock portfolio. Each stock you buy or sell is to be listed on your transaction sheet. Enter $7 commission for each trade. After picking and buying your stocks, be sure to also enter your positions (the stock and the number of shares owned) on your first worksheet which is your portofolio display. Each week, (Wed. night if possible) update the prices of your portfolio and record your current value on a third worksheet which we will build next week in class. We will track which portfolios perform the best.

Microsoft Office Excel 2003

Homework for week 18:

Part A –
Read EX 74 – EX 85, completing the yellow hands-on practice sections as you proceed.
Complete Session 2.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Case Problem 4 on page EX 91. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Use the SAM2003 Training Companion CD. Insert the CD and run the SAM training program. When prompted, enter your name and type in HEED followed by your class period. Next, select the Excel Tutorial 1: Using Excel to Manage Data. Complete the following modules:

• Clear cell content
• Display formula content
• Edit a formula
• Enter data in a selected range of cells
• Entering formulas using point mode
• Fit to print
• Move cells

Microsoft Office Excel 2003

Homework for week 21:

Part A –
Read EX 95 – EX 134, completing the yellow hands-on practice sections as you proceed.
Complete Sessions 3.1 & 3.2 Quick Checks; Study/memorize the Key Terms in bold.

Part B –
Complete Review Assignment on page EX 135

Part C –
Case Problem 4 on page EX 91. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part D –
Use the SAM2003 Training Companion CD. Insert the CD and run the SAM training program. When prompted, enter your name and type in HEED followed by your class period. Next, select the Excel Tutorial 1: Using Excel to Manage Data. Complete 8 training topics of your choice from the Excel training.

Use the workbook you created in class to record your trades (transactions) and your portfolio value. You can refer to the example one listed in the next column. For each stock you "purchase", enter the information in the next row of the 'trades' worksheet. Do the same for any you sell being sure that you enter the shares in the correct column. You cannot spend more than your $50,000. (However, I will award $2,000 bonus for any student who can explain to me what buying stocks on margin means.)

For each transaction that you log in your transaction worksheet, be sure to update your 'Portfolio' sheet. Each week we will record your current portfolio value to track and graph your changes.

Visit one of the following web sites and create a user login if you do not have one.

• http://finance.google.com
• http://finance.yahoo.com
• http://www.marketwatch.com

Each site is organized differently, but each allows you to create a pretend portfolio. Create a portfolio and enter in your stock information including at a minimum the ticker, number of shares, and trade date. Once you save your portfolio, the web site will automatically retrieve the current price of each stock, making it easy for you to monitor your portfolio's value.

Microsoft Office Excel 2003

Homework for week 20:

Part A –
Read EX 146 – EX 163, completing the yellow hands-on practice sections as you proceed.
Complete Session 4.1 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Begin Review Assignment 1 on page EX 187, completing all the skills that are covered under section 4.1. Save a copy of your assignment on your USB drive.

Part C –
Begin Case Problem 1 on page EX 187-188, completing all the skills that are covered under section 4.1. Save a copy of your assignment on your USB drive.

Part D – SAM Training CD - complete the following modules under the Excel Tutorial 4: Working with Charts and Graphs:

• Create charts using column chart types
• Create charts using the pie chart type
• Rotate and tilt a 3-D Pie Chart

Microsoft Office Excel 2003

Homework for week 21:

Part A –
Read EX 164 – EX 186, completing the yellow hands-on practice sections as you proceed.
Complete Session 4.2 Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete Review Assignments on page EX 187. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part C –

Complete Case Problem 1 on page EX 188. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part D –

Complete Case Problem 2 on page EX 188-189. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Integrating Microsoft Office 2003

Homework for week 22:

Part A –
Read INT 1-3 through INT 1-20, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page INT 1-21. Save a copy of your assignment on your USB drive.

Part C –
Complete Case Problem 1 starting on page INT 1-22. Save a copy of your assignment on your USB drive.

Part D – SAM Training CD - Complete any three training modules (your choice) that relate to either Using Excel to Manage Data or Integrating Word and Excel.

Microsoft PowerPoint 2003

Homework for week 23:

Part A –
Read PPT 3 through PPT 32, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page PPT 33. Save a copy of your assignment on your USB drive.

Part C –
Complete Case Problem 1 starting on page PPT 34. Save a copy of your assignment on your USB drive.

Part D –
Complete Case Problem 3 starting on page PPT 36. Save a copy of your assignment on your USB drive.

** New class time: Class starts 10:20 AM; ends 11:45 AM **

Microsoft PowerPoint 2003

Homework for week 26:

Part A –
Read PPT 41 through PPT 78, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Checks 2.1 and 2.2; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page PPT 79. Save a copy of your assignment on your USB drive.

Part C –
Complete Case Problem 1 starting on page PPT 81. Save a copy of your assignment on your USB drive.

Part D –
** Choose either Case 2 or Case 3 **
Complete one of the case studies from case 2 or 3, starting on page PPT 82. Save a copy of your assignment on your USB drive.

Class starts 10:20 AM; ends 11:45 AM

No new readings.

Develop your PowerPoint presentation. Start first with an outline, which you will hand in the day of your presentation. Be sure to know the purpose of your presntation and the audience.

Your presentation should be about 10 minutes. You must demonstrate the following PowerPoint features in your project:

• Slide layout
• Slide transitions
• Include clip art
• Inlcude a picture from a file (either from the Internet or perhaps from a digital camera)
• Include sound
• Inlcude a custom animation

Optionally you may use any other advanced features such as a video clip, links to web sites, action buttons or any other features that you discover about PowerPoint.

You will be evaluated on both your project content as well as how you present it. Practice your presentation ahead of time and remember that you will need to have all of your project's resources on your USB drive in order for it to work apart from your own computer.

You should face the audience and remember to have eye contact.

Class starts 10:20 AM; ends 11:45 AM

Workshop in class

Class starts 10:20 AM; ends 11:45 AM

Presentations

No homework assigned

Class starts 10:20 AM; ends 11:45 AM

Creating Web Pages with Microsoft Office 2003

Homework for week 29:

Part A –
Read WEB 3 through WEB 30, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page WEB 30. Save a copy of your assignment on your USB drive.

Class starts 10:20 AM; ends 11:45 AM

Part A –
Read AC 3 through AC 28, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page AC 29. Save a copy of your assignment on your USB drive.

Part C –
Complete Case Problem 2 starting on page AC 30. Save a copy of your assignment on your USB drive.

Class starts 10:20 AM; ends 11:45 AM

Part A –
Read AC 35 through AC 71, completing the yellow hands-on practice sections as you proceed.
Complete Session Quick Check; Study/memorize the Key Terms in bold.

Part B –
Complete the Review Assignment starting on page AC 73. Save a copy of your assignment on your USB drive.

Part C –
Complete Case Problem 2 starting on page AC 75. Save a copy of your assignment on your USB drive.

** Last Class **

Class starts 10:20 AM; ends 11:45 AM

Review (Puzzle Reward Challenge)