CIS 146 Assignments

Office XP - Introductory Concepts and Techniques

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     Asgn01
02 None: create WordPad document Work through Win1.06-2.21Asgn02 or Pg. Win2.25 Lab2, 1-8
03 TenQuestions.doc     Asgn03 - Ten Questions
04 Make FriendsPP1.64 #2 PP1.06-1.64 PowerPoint - Project 1
05 Trends in Technology
StudentFile: Computer Trends.ppt		PP1.68 #6 PP1.68 Apply Your Knowledge #1, steps 1-6

Finish Assignments 01-05 before Exam #1

06 Hidden Lake Announcement WD1.53 #1 WD1.06-1.54 Word - Project 1
07 Wallace House Announcement WD1.68 #14 WD1.67-1.68 In The Lab 2: steps 1-14
08 E-Retailing Paper WD2.52 #1 WD2.04-2.52 Word - Project 2
09 Computers and Entertainment
Paper - Part 2b		WD2.62 #10 WD2.60-2.62 In the Lab 2: Part 1 and Part 2
10 Carter Resume WD3.26 #5 WD3.04-3.26 Word - Project 3
11 Carter Letterhead WD3.40 #5 WD3.27-3.40 Word - Project 3 continued
12 Carter Cover Letter WD3.57 #1 WD3.41-3.57 Word - Project 3 continued
13 Duke Resume WD3.64 #4 WD3.64 In the Lab 1: steps 1-4

Finish Assignments 06-13 before Exam #2

14 Dynamite Music 4th Qtr Sales E1.43 #5 E1.06-1.54Excel - Project 1
15 Madonna's Virtual Sajourn Annual Sales Analysis E1.59 #10 E1.58-1.59In the Lab 1: steps 1-10 (save #10)
16 Greenback Stock Club E2.64 2nd #3 E2.04-2.64Excel - Project 2 (omit emailing)
17 Ray's Ready Mix Concrete E2.70 #14 E2.69-2.70 In The Lab 1: steps 1-14 (save #14)
18 Awesome IntranetsE3.65 #2E3.04-3.65 Excel - Project 3 (save step #2 p3.65)
19 PAYROLL  Payroll
20 AMORT    Loan Calc & Amortization Schedule
21 None: create Word document E.368 #2,3,5 E3.68Apply 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 Alisa Vending ServicesA1.49 #1A1.06-1.49 Access - Project 1 (make copy)
25 Beyond Clean
StudentFile: Beyond Clean.mdb		 A1.55 #7A1.54-1.55 Apply Knowledge 1: 1-7 (make copy)
26 Wooden CraftsA1.57 #9 A1.56-1.57 In the Lab 1: steps 1-9 (make copy)
27 Alisa Vending Services(2nd copy) A2.42 #1A2.04-2.42 Access - Project 2 (make copy)
28 Beyond Clean (2nd copy) A2.44 #19 A2.44 Apply Knowledge 1: steps 1-19
29 Wooden Crafts (2nd copy) A2.45 #16 A2.44-2.45 In the Lab 1: steps 1-16
30 Alisa Vending Services (3rd copy) A3.48 #4 A3.04-3.48 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.