OBJECTIVES & PURPOSE:

The purpose of this assignment is to:

• Become familiar with document integration techniques;
• Integrate document portions from:
  • Word processing (Word);
  • Spreadsheets (Excel);
  • Database management systems (Access);
  into a single document.

SPECIFICATIONS & INSTRUCTIONS:

PLEASE NOTE:

• To receive full credit, all specifications must be meet.
• Read the NOTES at the bottom of the assignment before continuing;
• Learning how to do this assignment:
  • The following descriptions are the specifications for the assignment;
  • They are not a tutorial on how to do the assignment;
  • Discussion and demonstration on how to do the assignment will be given in class on the demonstration day for this assignment (please attend class that day for the demonstration);
  • Since integrating documents from different parts of MS Office may not be well documented, it is very important to be in class to see the demo. Time does not permit showing significant numbers of students on an individual basis how to integrate these documents. Missing the Demo Session may result in determining for one's self (or from a fellow student) how to integrate documents together.
• This is an integrated project that combines portions of other assignments into one document. It assumes:
  • This assignment will use MS Word XP (2002) or Word 2003 and Office XP (2002), or Office 2003;
  • That your Home Inventory DBMS assignment was completed with MS Access XP (2002), or Access 2003;
  • That your Spring Semester Budget assignment was completed with EXCEL XP (2002), or EXCEL 2003
• If you used any other products for your aforementioned assignments, the integration may or may not work, and if not, you need to consider using Office 2003 on a lab computer.
  • NOTE: If you use ACCESS 2007, the menu items and tools may be different. These instructions are written for ACCESS 2003.
• Also, use of earlier versions of Office (before Office 2000) may require integration techniques different and more involved than the techniques shown with Office 2003 in class.
• It will be advantagous to follow the sample while reading the specifications.

The specifications are:

1. Write a memo (with MS Word XP (2002) or MS Word 2003) to your parent, spouse, significant other, or friend. Include:
   • Page Setup:
   • Left & Right Margins = 1.25";
   • Top & Bottom Margins = 1.00";
   • Orientation = "Portrait".
   • Set font to Times-Roman 10 point;
   • Full Alignment (Justification);
   • Bold and center align the word MEMO;
   • Bold and fully align the words To:, From:, Date:, and Re:.
   
   
2. Write the memo heading to include:
   • To: (parent, spouse, significant other, etc,);
   • From: (which will include your Name, ID#, Section#, and Assignment#);
   • Date: (today's date);
   • Re: (Integration Project for CSC-115).
   
   
3. Write a paragraph with an introduction about your experience in this Computer Science Class;



4. Next, do the following:
• Sort your Database assignment with the Home Inventory List in ascending order by price;
• Import the Database including the field names into this Word document (it must be your actual database assignment (from MS Access) and not a reentry of it using word features);
• Mark the imported database text (in Word) and set it to 8 point;
• Resize the database table to expand from exactly the left margin to the right margin of this document.


5. Write some more text in your memo (using Times-Roman 10 point font);



6. Enter a page break (Insert-Break-Page break) so that the remaining portion of your document will appear on the second page, as shown in the sample;
   
   
7. Import your spreadsheet budget of the revised version of that assignment (that showed a balanced budget). Do not include the chart at this time; it will be imported in the next step. It must be your spreadsheet assignment and not a reentry of it using the word processor!
• Import it into this Word document;
• Use the word processor's table features to draw the "elegant" style table around the spreadsheet as follows:
• Mark the spreadsheet that is now in the Word document;
• Select from the Menu Bar Table-Table AutoFormat; Select Elegent style table;
• Resize the spreadsheet to expand from exactly the left margin to the right margin of this document.


8. Import the chart from the budget spreadsheet assignment into this Word document.

Resize the chart to expand from exactly the left margin to the right margin of this document.


9. Conclude your memo with:
• Closing comments;
• Your signature;
• Your name.

ASSIGNMENT SUBMISSION:

1. Print a hardcopy of this assignment;
2. Hand write in the top right corner of this assignment, your:
• gradesheet Section-Row# (such as "3-21");
• Name;
• Student ID#;
• Section#;
• Assignment#.
3. Submit the hardcopy printout of this integrated Word memo as your assignment.

NOTE:

• All specifications must be met to receive full credit;
• Assignment assumes using Microsoft's Word XP (2002) or Word 2003, Excel XP (2002) or Excel 2003, and Access XP (2002) or Access 2003, and Office XP (2002) or Office 2003. The integration may not work with other products, or may be very difficult to accomplish;
• NOTE: If you use ACCESS 2007, the menu items and tools may be different. These instructions are written for ACCESS 2003.

Assignment assumes integration of some of your previous assignments as opposed to reentering (via the keyboard) everything into Word. If you have lost the Budget (Excel) assignment or the Home Inventory List Assignment (Access) assignment, you will have to redue them (having 2 backups helps prevent loss of assignments).

GRADING:

The instructor and/or Grader will be verifying that all specifications stated above in SPECIFICATIONS AND INSTRUCTIONS as well as ASSIGNMENT SUBMISSION were met to receive full credit. Specifications missing will be the basis of deducted points. Items the instructor or grader examine include (but are not limited to):

• DOCUMENT:
  • Page Setup:
  • Page settings:
  • Portrait orientation;
  • Letter size paper (8.5 x 11 inches).
  • Margin Settings:
    • Left & Right Margins = 1.25";
    • Top & Bottom Margins = 1.00";
• COMPONENTS OF THE MEMO:
  • Body of Memo Text:
    • Font set to Times-Roman 10 point;
    • Bold and center align the word MEMO;
    • Bold and fully align the words To:, From:, Date:, and Re:.
    • Full Alignment (Justification) of all text paragraphs;
    • Paragraphs contain the content requested above.
  • Home Inventory Table:
    • Imported database text in table is set to 8 point;
    • Database table is resized to extend from exactly the left margin to the right margin of this document, and columns are adjusted (resized) to near equal widths.
  • Balanced Budget:
    • The balance budget shows an "Elegent" Style table border (a double line around the perimeter of the table with single lines defining the rows and columns);
    • Budget table is resized to extend from exactly the left margin to the right margin of this document.
  • Graph of Budget Expenses;
    • Graph is resized to extend from exactly the left margin to the right margin of this document;
    • Budget and Graph should be on the same page.

---

Click Here To See Sample Of This Assignment

Click Here To Return To Class Page