CIS 146 Assignments

Office 2003 - Introductory Concepts and Techniques, Second Edition

Complete all steps in each project. Omit all print instructions. As you complete the steps in the project, you will create files with specific names per the project instructions. Change the name of the File Name from Project (listed below) to an eight character file name for each assignment by combining the first 5 letters in your last name (all letters if your last name is less than 5 letters), plus your first initial (please use the first name you used to register), plus the 2 digit assignment number below. Keep the extension added by the program (.doc or .xls or .mdb or .ppt). Please, no spaces or additional characters. Copy this file to the homework folder.

Asn#	File Name from Project	Page / Step	Complete Pgs	Assignment
01	RAM Web Assignment	Read Pgs COM2-COM39		Asgn01
02	None: create WordPad document	Read Pgs WIN4-WIN82		Asgn02
03	TenQuestions.doc	Refer to pg COM2-COM39		Asgn03 - Ten Questions
04	College Success	PPT64 #2	PPT4-64	PowerPoint - Project 1
05	Apply 1-1 Search Tools Data File Needed: Apply 1-1 Internet Searching.ppt	PPT68	PPT68	Apply Your Knowledge #1
Finish Assignments 01-05 before Exam #1
06	Grand Prix Announcement	WD52 #1	WD4-62	Word - Project 1
07	Health Clinic Announcement	WD69 #14	WD68-69	In The Lab 2: steps 1-14
08	Biometrics Paper	WD121 #1	WD74-121	Word - Project 2
09	Lab 2-2 Employee Monitoring Paper - Part 3	WD133 Part 3, #4	WD132-133	In the Lab 2: Part 1, 2 & 3
10	Okamoto Resume	WD159 #5	WD138-159	Word - Project 3
11	Okamoto Letterhead	WD 175 #5	WD160-175	Word - Project 3 continued
12	Okamoto Cover Letter	WD189 #1	WD175-195	Word - Project 3 continued
13	Lab 3-1 Faddis Resume	WD199 #4	WD199	In the Lab 1: steps 1-4
Finish Assignments 06-13 before Exam #2
14	Extreme Blading 2nd Qtr Sales	EX43 #4	EX4-55	Excel - Project 1
15	Lab 1-1 Knotting Hill Bookstore Oct Sales	EX59 #10	EX58-59	In the Lab 1: steps 1-10 (save #10)
16	Blue Chip Stock Club Investment Analysis	EX126 #2	EX66-126	Excel - Project 2 (omit emailing)
17	Lab 2-1 Illiana Custome Homes Weekly Payroll Report	EX133 Part 2	EX132-133	In The Lab 1: steps 1-11 & Part 2-save Part 2
18	Aquatics Wear Six-Month Financial Projection	EX208 #2	EX146-208	Excel - Project 3 (save step #2 pg Ex208)
19	PAYROLL			Payroll
20	AMORT			Loan Calc & Amortization Schedule
21	None: create Word document	EX211 #2,3,5	EX211	Apply Knowledge 1: steps 2, 3, & 5
22	MTG			Mortgage
23	CHANGE			Change Sheet
Finish Assignments 14-23 before Exam #3
NOTE: Assignments 24-30 are created using Microsoft Access. Since Access saves files automatically, after you complete each Access assignment, exit Access and use the Windows Explorer to make a copy of your Access file. Rename the copy as your codename plus assignment number and turn it in electronically. You will need your original files for future assignments.
24	Ashton James College	AC50 #1	AC4-52	Access - Project 1 (make copy)
25	Begon Pest Control Data File Needed: Begon Pest Control.mdb	AC55 #7	AC54-56	Apply Knowledge 1: 1-7 (make copy)
26	Birds2U	AC57 #10	AC56-58	In the Lab 1: steps 1-10 (make copy)
27	Ashton James College (2^nd copy)	AC106 #2	AC66-106	Access - Project 2 (make copy)
28	Begon Pest Control (2^nd copy)	AC109 #8	AC109	Apply Knowledge 1: steps 1-8
29	Birds2U (2^nd copy)	AC110 #13	AC109-110	In the Lab 1: steps 1-13
30	Ashton James College (3^rd copy)	AC162 #2	AC114-164	Access - Project 3

How to turn your assignments in electronically (copy your file to the homework folder):

Click START, RUN, then type A: and press the ENTER key.
Click START, RUN, then type \\harris and press ENTER key. See a yellow Homework folder.
Close all open windows except Harris computer window and 3½ Floppy (A) window. If necessary, resize and move open windows so that both windows are visible.
With the RIGHT mouse button, drag your homework file(s) from your 3½ Floppy (A) to the yellow Homework folder. When the homework folder turns blue it is selected. Once selected, release the mouse button to drop your homework file into the homework folder. You’ll see a pop up window asking if you want to Copy, Move, Create Shortcut, or Cancel. Click COPY.
To verify that your assignment was turned in, double-click the homework folder and look up your assignment alphabetically. If it is not there, re-do step #4 above.

NOTE: All assignments are due upon completion. Please do not wait until the end of the semester to copy all your files. You run the risk of losing your disk, damaging your disk, or erasing your disk. Since copying files is part of the learning experience, you will get practice turning in homework assignments every week during the term. Please do not erase your assignments off your disk until the end of the term. Since a disk can crash, it is very important that we keep at least two copies of every homework assignment file. I'll have a copy and you will have at least one copy - it is wise to keep a backup just in case. If you ever have a problem with your disk, please let me know and I will make you another copy. If I have a problem, I will ask you to send me another copy of your file. See class schedule for the LAST DAY TO TURN in homework - approx. one week prior to Final Exam.