Exploring the Basics of Microsoft Windows XP

Homework for week 2:
By Friday –
Read WIN 3 – WIN 23, completing the yellow hands-on practice sections as you proceed.
Complete Session 1 Quick Check
By Tuesday –
Read EC 3 – EC 5; memorize the definitions of all the bold terms
By Wednesday –
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:
By Friday –
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)
By Tuesday –
Read EC 6 up to the section “Computer Hardware” on EC 9; memorize the definitions of all the bold terms
By Wednesday –
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:
By Friday –
Read FM 2 – FM 7 up to “Exploring Files and Folders

By Tuesday –
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.

By Wednesday –
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 Friday –
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 Tuesday –
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 Wednesday –
Complete Case Problem 1, page FM22

Browser and E-mail Basics

Homework for week 6:

Recommended by Friday –
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 Tuesday –
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 Wednesday –
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:

Recommended by Friday –
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 Tuesday –
Read EC 22 “Data Communications” up to the section “Computer Software” on EC 27; memorize the definitions of all the bold terms

Recommended by Wednesday –
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"

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 Word 2003 continued

Homework for week 14: (After Thanksgiving)

There are no new assignments for this week.

Please take the time to review the material that we have covered to date. I will be giving a test either in class or online before we break for Christmas.

Catch Phrase - review day

Study for the upcoming exam - No Homework due for week 15

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.

There are no projects or case studies assigned for this week.

Online test to be taken on or before Thursday, December 13, 2007. Read instructions1st!

Online test instructions:

The test is a closed book test that is available online. You may take it two times, using the first try to become familiar with the material covered. Enter your name and e-mail at the top of your test and enter your class period in the box for section. If your computer shows an alert, click the option that allows for JavaScript or ActiveX content. This will allow your test to be graded at the end.

Click here for the test --> Computer Science I - Test 1

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 –
re-read EX 24 – EX 43.

Complete any "lingering" case studies.

Microsoft Office Excel 2003

Homework for week 19:

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

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.

Part C –
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

Part D –
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.

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.

Be sure you have your stocks entered in to an online portfolio so that you can easily determine the current value of your portfolio. Also, pay attention to your available funds when buying stocks; some of you have exceeded the $50,000 initial funds.

Part A –

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

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

Part C –

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

Microsoft Office Excel 2003

Homework for week 23:

There is no reading assignment for this week.

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

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

Part C –
Case Problem 3 on page EX 141. 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 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

Part E –
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.

You should have totals for weekly, monthly and yearly columns . We will review your results next class.

Excel example data

Chum Salmon

Student enrollments

Microsoft Office Excel 2003

Homework for week 25:

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

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

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

Part A –
Read PPT 42 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
• Include an animation scheme (found under Slide Design)
• 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.

Presentations

No Homework assigned.

Creating Web Pages with Microsoft Office 2003

Homework for week 32:

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.