Word & Excel


Home
Syllabus
Class Policies
Calendar
Word & Excel
Access & PowerPoint
Grades & Final Project

Word Assignment Sheet

   Tutorial 1 – Creating a DocumentPg.3-35

Complete Tutorial 1document, Meyer Letter: Add: your name, Tutorial 1, & Meyer Letter to the header of the document. (See Tutorial 3, Page 129 blue “Insight” box  for information on inserting the three default tab stop header. Use these three tab stops to insert the three parts of the required class header, name, tutorial, and file name.)

Complete Review Assignment Steps 1-16 on Pg. WD 38-39, Gallatin Letter. Add your name, Tutorial 1 Review, Gallatin Letter to the header of the document.

Complete Case Problem 1, Steps 1-15 on Pg. WD 39-40, Lecture Series Letter. Add your name, Tutorial 1 Case 1, Lecture Series Letter to the header of the document.

Submit all documents for correction by email, WebCT, or in printed form by Sept. 11.
Assignments submitted between Sept. 12 and Sept. 14 will have 10 points deducted.

  Tutorial 2 – Editing and Formatting—Pg. 45-86

Complete Tutorial 2 document: Design Handout. Add: your name, Tutorial 2, Design Handout to the header of the document.

Complete the Review Assignment Steps 1-20 on Pg. WD 87-90. Add: your name, Tutorial 2 Review, Pemberly Staff to the header of the document. In addition, add a header to the Verve Sample document with your name, Tutroial 2 Review and Verve Sample.

Complete Case 1, Steps 1-10 on Pg. WD 90. Add: your name, Tutorial 2 Case 1, New Classes to the header of the document.

Submit all documents for correction by email or in printed form by Sept. 18.
Assignments submitted between Sept. 19 and Sept. 21 will have 10 points deducted.

 

   Tutorial 3 – Creating a Multi-Page Report—Pg. WD 97-137

Complete tutorial document: Audit Report. Add: your name, Tutorial 3, Audit Report to the header of the document.

Complete Review Assignment Steps1-17 on Pg. WD 138-139. Add: your name, Tutorial 3 Review, Class Report to the header of the document.

Complete Case 2, Steps 1-13 on Pg. WD 140-141. Add: your name, Tutorial 3 Case 2, WiFi Report to the header of the document.

Submit for correction by email or in printed form by Sept. 25.
Assignments submitted between Sept. 26 and Sept. 28 will have 10 points deducted.

 

  Tutorial 4 – Desktop Publishing a Newsletter—Pg. 147-187

Complete tutorial document: Prevention Newsletter. Add: your name, Tutorial 4, Prevention Newsletter to the header of the document.

Add your name, Tutorial 4, Merged Cover Letters to the header of the document.

Complete Review Assignment Steps 1-23 on Pg. WD 189-190. Add: your name, Tutorial 4 Review, Eating Well to the header of the document. Complete Merged Nutrition Letters. Insert your name, Tutorial 4 Review, Merged Nutrition Letters to the header.

Complete Case 1, Steps 1-14 on Pg. WD 190-191. Add: your name, Tutorial 4 Case 1, Audio Books to the header of the document. Then complete steps 15-18. 

Submit for correction by email or in printed form by October 2.
Assignments submitted between Oct. 3 and Oct. 5 will have 10 points deducted.


  Excel Assignment Sheet

Do not print the Documentation Page.

    Excel Tutorial 1 – Getting Started with Excel

Complete tutorial document on pages EX 1-46. Add your name, Tutorial 1, and RipCity Digital Orders to the header of each sheet.

Complete the Review Assignment, steps 1-22, on page EX 48-49. Add your name, Tutorial 1 Review, and Order Report to the custom header of all sheets.  (Note: Step 9 says to enter “Total” in cell I5, that is the letter I and number 9.)

Complete Case 3, steps 1-16, on page EX 52-54. Add your name, Tutorial 1 Case 1 and Global Site to the header of all sheets.

Submit for correction by email or in printed form by October 9.
Assignments submitted between Oct. 10 and Oct. 12 will have 10 points deducted.

 

    Excel Tutorial 2 – Formatting a Workbook

Complete tutorial document on pages EX 57-100.  Add the header described in the steps on page 99. In addition, insert  “Tutorial 2” to the center header section.

Complete the Review Assignment, steps 1-20 on page EX 102-104: In addition to the assigned header in step 19, add Tutorial 2 Review to the right header of all sheets.

Complete Case 2 on page EX 106. In addition to the assigned header in step 21, add Tutorial 2 Case 2 to the center header of all sheets.

Submit for correction by email or in printed form by October 16.
Assignments submitted between Oct. 17 and Oct. 19 will have 10 points
deducted.

 

    Excel Tutorial 3 – Working with Formulas and Functions

Complete tutorial document on pages 113-150. Add your name, Tutorial 3, and Drake Family Budget to the header. (Note: On page 148, Step 3, second sentence, the cell reference should be B5 for “=B3/B4”).

Complete the Review Assignment, steps 1-15, on page EX 152-153. Add your name, Tutorial 3 Review, and Timov Family Budget to the header.

Complete Case 1, steps 1-13, on page EX 153-154. Add your name, Tutorial 3, Case 1, and Chemistry 303 Final Scores to the header

Submit for correction by email or in printed form by October 23.
Assignments submitted between Oct. 24 and Oct. 26 will have 10 points deducted.

 

   Excel Tutorial 4 – Working with Charts and Graphics

Complete tutorial document New Century Fund. Add your name, Tutorial 4, and the filename to the header.

Complete the Review Assignment on page EX: 207-208 steps 1-18. Add your name, Tutorial 4 Review, and the file name to the header.

Complete Case 2 on page EX 209-210 steps 1-14. Add your name, Tutorial 4, Case 2 and the file name to the header.

Submit for correction by email or in printed form by October 30.
Assignments submitted between Oct. 31 and Nov. 2 will have 10 points deducted.

 

   Integration 1 – Integrating Word and Excel

Read and do the exercises on pages INT 1-18. Complete Hospital Letter. Add your name, Integration 1 and the file name to the header.

Complete Case Problem 1on page INT 1-21-22: Add your name, Integration 1 Case 1, and the file name to the header.

Submit for correction by email or in printed form by October 30.
Assignments submitted between Oct. 31 and Nov. 2 will have 10 points deducted.

 


Back to BIS 109 Homepage
This page was last modified August 15, 2007
sally.chumbley@evc.edu