CIS 146 Assignments

Office 2007 - Introductory Concepts and Techniques, Windows Vista 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. DATA FILES NEEDED: You will only need 4 data files all semester. Each file is listed with a link; ATM for assignment #5, Horse and Rider for assignment #6, Bradford Pear in Bloom for assignment #7, and The Bike Delivers for assignment #25. Once you click the link below, right-click the file name and click SAVE TARGET AS to save it to your USB drive.

Asn#	File Name from Project	Page / Step	Complete Pgs	Assignment
01	RAM Web Assignment	Read Pgs COM 1-40		Asgn01
02	None: create WordPad document	Read Pgs WIN 1-WIN66		Asgn02
03	TenQuestions.doc	Refer to pg COM2-COM39		Asgn03 - Ten Questions
04	Cobo Package	PPT 46 #1	PPT 1-65	PowerPoint - Chapter 1
05	Identity Theft Data File Needed: ATM	PPT131, #2	PPT82-131	PowerPoint - Chapter 2
Finish Assignments 01-05 before Exam #1
06	Horseback Riding Lessons Flyer Data File Needed: Horse and Rider	WD60, #2	WD2-62	Word - Chapter 1
07	Lab 1-2 Nursery Expansion Flyer Data File Needed: Bradford Pear in Bloom	WD70 #22	WD69-70	In The Lab 2: Creating a Flyer with a Picture and a Border
08	Wireless Communications	WD132 #2	WD74-132	Word - Chapter 2
09	Lab 2-1 Computer Forensics Paper	WD139 #11	WD138-139	In the Lab 1: Preparing a Short Research Paper
10	Canaan Letterhead	WD164 #4	WD146-164	Word - Chapter 3 (first part)
11	Canaan Cover Letter	WD 182 #1	WD165-182	Word - Chapter 3 (second part)
12	Canaan Resume	WD202 #4	WD183-202	Word - Chapter 3 (third part)
13	Lab 3-2 Marsh Resume	WD211 #4	WD210-211	In the Lab 2: Creating a Resume from a Template
Finish Assignments 06-13 before Exam #2
14	Walk and Rock Music 1^st Quarter Sales	EX69 #2	EX2-69	Excel - Chapter 1 (save on page 69 - book says do not save)
15	Lab 1-1 Konos Expresso Coffee Annual Cost of Goods	EX75 #11 (save #11)	EX74-75	In the Lab 1: Annual Cost of Goods Worksheet
16	Silver Dollar Stock Club Porfolio Summary	EX143 #1	EX82-143	Excel - Chapter 2 (omit emailing)
17	Campus Clothiers Semiannual Financial Projection	EX218 #6	EX162-228	Excel - Chapter 3
18	None: create WordPad document with answers	EX229, Part 1 and 2	EX229	Apply Your Knowledge Part 1 (a-h) and Part 2 (4 blanks)
19	PAYROLL			Payroll
20	AMORT			Loan Calc & Amortization Schedule
21	BUDGET			Budget
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	JSP Recruiters	AC58 #4	AC2-64	Access - Chapter 1 (make copy)
25	The Bike Delivers Data File Needed: The Bike Delivers	AC65 #7	AC64-65	Apply Knowledge 1: 1-6 (make copy)
26	JMS Tech Wizards	AC68 #7	AC67-68	In the Lab 1: steps 1-7 (make copy)
27	JSP Recruiters (2^nd copy)	AC125 #7	AC74-127	Access - Chapter 2 (make copy)
28	The Bike Delivers (2^nd copy)	AC129 #5	AC128-129	Apply Knowledge 1: steps 1-5
29	JMS Tech Wizards (2^nd copy)	AC132 #13	AC131-132	In the Lab 1: steps 1-13
30	JSP Recruiters (3^rd copy)	AC191 #3	AC138-195	Access - Chapter 3

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

Insert your USB drive in monitor (bottom left), click the START button, then click COMPUTER icon, double-click your USB drive icon to open an explorer window showing the contents of your USB drive.
Click the START button, In the SEARCH BOX, type \\merlin, then double-click the CIS folder, then double-click the HARRIS folder, then double click the homework folder. You'll be at \\merlin\cis\harris\homework. NOTE: This can only be done from the school network on campus (any computer lab on any campus).
Close all open windows except Harris computer window and your USB drive 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 USB drive 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: If your assignments are not all listed together, you may need to refresh the view by tapping the F5 function key (or re-open the window). If they are still not all listed together, it either did not copy or you named the file differently. Be sure to name all files with the FIRST FIVE LETTERS of your last name, plus YOUR FIRST INITIAL, plus a TWO DIGIT assignment number - no spaces. Leave the extension as is.

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.