## 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 (2nd copy) | AC106 #2 | AC66-106 | Access - Project 2 (make copy)
28 | Begon Pest Control (2nd copy) | AC109 #8 | AC109 | Apply Knowledge 1: steps 1-8
29 | Birds2U (2nd copy) | AC110 #13 | AC109-110 | In the Lab 1: steps 1-13
30 | Ashton James College (3rd copy) | AC162 #2 | AC114-164 | Access - Project 3

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

1. Click START, RUN, then type A: and press the ENTER key.
2. Click START, RUN, then type \\harris and press ENTER key. See a yellow Homework folder.
3. 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.
4. 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.
5. 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.