CIS 146 Assignments

Office 2010 - Introductory

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 from the assignment (listed below) to an eight character file name 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 (.docx or .xlsx or .accdb or .pptx). Please, no spaces or additional characters. Copy this file to the homework folder - \\merlin\cis\harris\homework.

DATA FILES NEEDED: Some assignments will refer to student data files. These files can be downloaded from the publisher by following the instructions on the inside back cover of the book. Alternatively, you can click the links below, then right-click the file you need, then click SAVE TARGET AS and save the file to your USB drive.
Asn# Assignment Complete Pages File Name from Project
01 RAM Web Asgn - Asgn01 Instructions Read Pgs COM 1-40  
02 File Properties - Asgn02 Instructions Read Pgs OFF1-OFF75  
03 Ten Questions - Asgn03 Instructions Refer to pg COM2-COM39  
04 PowerPoint - Chapter 1 PPT1-54 (PPT47 #1) Saving Energy.pptx
05 PowerPoint - Chapter 2
Data File Needed: Hands Yoga		 PPT73-122 (PPT121 #1) Yoga.pptx

Finish Assignments 01-05 before Exam #1
06 Word - Chapter 1   Data File Needed: Dog Picture 1 WD2-53 Found Dog Flyer.docx
07 In the Lab - Lab 2: Creating a Flyer with a Resized Picture   Data File Needed: Wind Power WD60-61 Lab 1-2 Photography Contest Flyer.docx
08 Word - Chapter 2 WD65-WD125 Triangulation Paper.docx
09 In the Lab - Lab 2: Preparing a Research Report with a Footnote WD132-WD134 Lab 2-1 Agriculture Paper.docx
10 Word - Chapter 3 (1st part - letterhead) WD137-WD164 Heartland Letterhead.docx
11 Word - Chapter 3 (2nd part - business letter) WD164-WD188 Heartland Advertisement Letter.docx
12 Word - Chapter 3 (3rd part - Env. & Labels)
Click Add to Document button instead of Print button.		 WD189-WD190 Extra copy of Hartland Advertisement Letter.docx with envelope & label added.
13 In the Lab - Lab 2: Creating a Letter with a Letterhead and Table WD196-WD197 Lab 3-2 Library Letterhead.docx

Finish Assignments 06-13 before Exam #2

14 Excel - Chapter 1 EX2-EX53 Save Sable River Foundation.xlsx
15 In the Lab - Lab 1: Annual Revenue Analysis Worksheet EX58-EX59 Lab 1-1 A Healthy Body Shop Annual Revenue Analysis
16 Excel - Chapter 2 EX65-EX121 The Mobile Masses Biweekly Payroll Report
17 Excel - Chapter 3 EX137-EX203 Modern Music Shops Six-Month Financial Projection
18 Apply Your Knowledge - Understanding Logical Tests and Absolute Cell Referencing: Part 1 (a-h) and Part 2 (4 blanks) EX204, Part 1 and 2 Create Word document with answers
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 Access - Chapter 1: Introduction to Databases AC2-AC63 Camashaly Design.accdb
25 Apply Your Knowledge (steps 1-9)
Data File Needed: The Babbage CPA Firm.accdb		 AC64 The Babbage CPA Firm.accdb
26 In the Lab - Lab 1: Creating Objects for the ECO Clothesline Database (Steps 1-8)
Data File Needed: Lab 1-1 Customer Data.xlsx
Data File Needed: ECO Clothesline.accdb		 AC66-AC67 ECO Clothesline.accdb
27 Access - Chapter 2: Querying a Database
Use File From Asgn #24: Camashaly Design.accdb		 AC73-128 Camashaly Design.accdb
28 Apply Knowledge (Steps 1-5)
Use File From Asgn #25: Babbage CPA Firm.accdb		 AC129-130 Babbage CPA Firm.accdb
29 In the Lab - Lab 1: Querying the ECO Clothesline Database (Steps 1-13)
Use File From Asgn #26: ECO Clothesline.accdb		 AC132-133 ECO Clothesline.accdb
30 Access - Chapter 3: Maintaining a Database
Use File From Asgn #27: Camashaly Design.accdb		 AC137-196 Camashaly Design.accdb

How to turn your assignments in electronically (copy your file to the homework folder):
  1. 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.
  2. 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).
  3. 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.
  4. 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. BE SURE TO click COPY because you need to keep a copy, just in case the homework folder hard drive crashes.
  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: 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.