Exploring the Basics of Microsoft Windows XP

Homework for week 2:

Recommended by Thursday –
Read WIN 3 – WIN 23, completing the yellow hands-on practice sections as you proceed.
Complete Session 1 Quick Check

Recommended by Friday –
Read EC 3 – EC 5; memorize the definitions of all the bold terms

Recommended by Monday –
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:

Recommended by Thursday –
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)

Recommended by Friday –
Read EC 6 up to the section “Computer Hardware” on EC 9; memorize the definitions of all the bold terms

By Monday –
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:
Recommended by Thursday –
Read FM 2 – FM 7 up to “Exploring Files and Folders

Recommended by Friday –
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.

Recommended by Monday –
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

Recommended by Thursday –
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.

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

Recommended  by Monday –
Complete Case Problem 1, page FM22

Browser and E-mail Basics

Homework for week 6:

Recommended by Thursday –
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.

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

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

Visit Google.com and click on "Advanced Search". Read over the options and how the advanced search works. Next, on that page you will see a link for "Advanced Search Tips"; click on that and read through the tips for advanced searching.

Browser and E-mail Basics - continued

Homework for week 7:

Recommended by Thursday –
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.

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

Recommended by Monday –
TBD

Using Common Features of Microsoft Office 2003

Homework for week 9:

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

Using Common Features of Microsoft Office 2003 continued

Microsoft Office Word 2003

Homework for week 10:

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 continued

Microsoft Office Word 2003

Homework for week 11:

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 12:

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"

Microsoft Office Word 2003 continued

Homework for week 15:

Part A –
Read WD 135 – WD 172, completing the yellow hands-on practice sections as you proceed.
Complete Session 4.1 & 4.2 Quick Checks; 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.

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

Part E –
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 16:

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 17:

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 18:

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 2 on page EX 88. Store a final copy of your assignment on your USB drive and a printed copy in your class binder.

Part C – SAM Training CD

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 19:

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.

Microsoft Office Excel 2003

Homework for week 20:

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 A –

Stock portfolio challenge - Each student has been given $50,000 to build a mock stock portfolio. You are to select between 5 to 25 different stocks to invest in, giving consideration to diversification. This helps reduce your overall risk. If you are not familiar with this topic, please use Google.com or Ask.com or other web site to research and become familiar with its meaning and use.

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.

Part B –

Apply some of the formatting skills you had in the previous reading to your stock portfolio workbook. Apply borders, shading, fonts, etc. to improve the look of the workbook.

Part C –

Complete Case Problem 1 on EX 87.(Chemistry 303 problem)

Part D –

Complete Case Problem 1 on EX 137-138. (FrostiWear)

Microsoft Office Excel 2003

Homework for week 22:

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 23:

Part A –
Read EX 164 – EX 186, 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 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 24:

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 25:

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.

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.

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.

Creating Web Pages with Microsoft Office 2003

Homework for week 30:

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.

Last class

Review (Survivor Reward Challenge)

Thanks for a great year!