CIS 5.2 - Homework Assignments

How to Submit

All homeworks are to be printed out and handed in to me BEFORE class on the day that they are due.
Since you cannot print on Vista machines, save your work in compatibility mode, and print from an XP machine. You can print at home even if you do not have a color printer. I will accept black-and-white printouts.

Microsoft ACCESS Homework Assignments

Assignment #9: Due: Monday, December 15 (last day of class.)

Lab 2: "Maintaining the Hockey Fan Zone Database" (all parts except number9)
Pages AC 200 - AC 201.
You are to print the datasheet view of all tables twice; after number 10, and after number 13.

Assignment #8: Due: Wednesday, December 3.

Lab 2: "Querying the Hockey Fan Zone Database" (all parts)
Pages AC 132 - AC 133.
You are to print all query results, and be sure to number or label them as they are numbered in the textbook.
NOTE: the following assignment (#9) will also use this database, so be sure to save it.

Assignment #7: Due: Wednesday, November 26. Extended to:December 1.

Lab 2: "Creating the Hockey Fan Zone Database" (all parts)
Pages AC 68 - AC 69.

Instructions: You are to create TWO tables, an Item Table and a Supplier Table. The item table should have the supplier code as its last field. The supplier table should have 3 fields, and it contains only 3 records. The primary key in the supplier table is the supplier code. You should print both tables in datasheet view, and the report that you created.

NOTE: the following 2 assignments (8 and 9) will build upon this assignment. DO NOT erase this database!

Microsoft EXCEL Homework Assignments

Homework #6: Due: Wednesday, November 12.

Pages EX 237-240, (In the Lab, 2), "Modifying a Weekly Payroll Worksheet." This assignment builds upon your previous homework assignment.

Homework #5: Due: Monday November 3.

Create a Weekly Payroll Report for Britney's Music Emporium. Click here for more details.

Your next assignment will build upon this, so be sure to save this.

Classwork Assignment: Page EX 149, Lab 1: Sales Analysis Worksheet. On page EX 150, you have the instructions for Part 1, numbered 1-18. You can do 1-11 so far, and the entire assignment (1-18) will be due on October 22.

Homework #4: Due: Monday, October 20, 2008.

Page EX 79, number 1. "Design and Create a Workbook to Analyze Yearly Sales."

Microsoft WORD Homework Assignments

Homework 1: Due: Wednesday, September 10, 2008.

Create a folder called CIS 5.2 either on your home computer or on your USB drive. Create 4 folders in the CIS 5.2 folder, named: Word, Excel, Access, and PowerPoint. Then, create a flier in Word, and save it in the folder that you called "Word."

Your flier should be a professional looking flier, advertising a new business that you are starting. Be sure to use the following features of Word: clipart or picture, at least 2 different fonts and styles, alignment, bullets.

To submit, you will email the homework as an attachment. In the body of the email, you should type the exact pathname of your file. Recall that the pathname is also called "breadcrumbs" and it appears in the address bar of the folder window.

Homework 2: Due: Monday, September 22, 2008.

Page WD 143, Number 1: Create a Research Paper about Word, using the MLA Documentation Style (See the textbook for details about this assignment.)

Homework 3: Due: Monday, October 6, 2008.

Create a resume for yourself using Word's resume template. (You may use fictional information, but I should not be able to tell.) Type a cover letter, assuming that you are applying for a job that you are interested in obtaining.

Your cover letter should have a professional looking letter head. Also, include a table in the cover letter. Be sure to set tabs as done in class.

Save these documents -- they will come in handy in the future!