CAS 170
Beginning Excel

 

Greg Kerr's E-mail

There are 5 Chapters listed below, each of which contain assignments from the textbook. (Chapter 4 is not assigned.)

On all assignments, do not print the spreadsheets. Instead, save the documents and email them as attachments to your instructor with a proper subject.

The email subject should read:

CAS 170 - ###### - Your Name

(##### is the assignment name listed in red below)

Complete List of Assignments in Due Date Order

Chapter Assignment Pages Points

1

Chapter 1, Main EX 1 to EX 69 2
 
Walk and Rock Music
   
  Chapter 1, In the Lab #1 EX 74 to EX 75 4
 
Kona's Espresso Cafe, Annual Cost of Goods Worksheet
   
  Chapter 1, In the Lab #2 EX 75 to EX 77 4
 
Scissors Office Supply, Annual Sales Analysis Worksheet
   
  Chapter 1, Cases and Places #2 EX 79 4
 
Quarterly Environmental Club Budget
   
  Chapter 1, Cases and Places #3 EX 80 4
 
In-the-Villa DVD Rental
   
Chapter Assignment Pages Points

2

Chapter 2, Main EX 81 to EX 143 3
 
Silver Dollars Stock Club
   
  Note: You cannot e-mail your Excel assignments to me from PCC computers as described on pages EX 142 to EX 143 in the text. PCC computers are not set specifically to you as the user.    
  Chapter 2, Make it Right EX 148 to EX 149 3
 
El Centro Diner, Payroll Report
   
  Chapter 2, In the Lab #1, Part 1 (only part 1) EX 150 to EX 151 4
 
Facade Importers, Sales Analysis Worksheet
   
  Chapter 2, In the Lab #2, Part 1 EX 151 to EX 153 4
 
Jackson's Bright Ideas, Balance Due Worksheet
   
  Chapter 2, In the Lab #2, Part 2 EX 153 to EX 154 4
 
Jackson's Bright Ideas, 3-D Bar Chart
   
  Chapter 2, Cases and Places #3 EX 158 4
 
Fund-Raising Worksheet
   
Chapter Assignment Pages Points

3

Chapter 3, Main EX 161 to EX 228 3
 
Campus Clothiers
   
  Chapter 3, In the Lab #1, Part 1 EX 233 to EX 235 4
 
Salioto Auto Parts, Financial Projection
   
  Chapter 3, In the Lab #1, Part 2 EX 235 to EX 236 4
 
Salioto Auto Parts, Income Projection Chart
   
  Chapter 3, In the Lab #2, Parts 1 and 2 EX 237 to EX 240 4
 
Britney's Music Emporium, Weekly Payroll Report
   
  Note: You do not need to save your work from Part 2, but do that part anyway to make sure it works correctly.    
  Chapter 3, Make it Right EX 232 to EX 233 3
 
e-MusicPro.com Net Income
   
  Chapter 3, Cases and Places #2 EX 245 to EX 246 4
 
Chesterton Trib, Projected Earnings
   
  Note: You should plan to save this with the what-if modifications included.    
Chapter Assignment Pages Points

5

Chapter 5, Main EX 337 to EX 390 3
 
Silver Photography Accessories
Note: do not do pages EX 391 to 399  
  Chapter 5, In the Lab #2, Part 1 EX 408 to EX 409 4
 
Consultant Specialist Table, Sort
   
  Note: Before doing Step 2, copy the Consultant Specialist sheet three times and give the copies of the sheet the names Sort 2a, Sort 2b, and Sort 2c. In other words, your file will have four sheets after you have made the copies. Do the sorting in Step 2 on the copies only and leave the original as it is.    
  Chapter 5, In the Lab #2, Part 3 EX 409 to EX 410 4
 
Consultant Specialist Table, Extract
   
  Chapter 5, In the Lab #3, Part 1 (Steps 1 to 3 only) EX 412 3
 
Do-Gooder's Student Club
   
  Chapter 5, Cases and Places #1 EX 414 4
 
Educational Percussion, Inc., Inventory Level Priority
   
Chapter Assignment Pages Points

6

Chapter 6, Main EX 417 to EX 471, EX 481 to EX 484 3
 
NextDVR, Inc.
Note: do not do the bottom of page EX 471 through EX 481, nor EX 485 through EX 491.  
  Note: On page EX 433 you will save the template to your disk (most likely a USB drive) and not UDISK 2.0 in the E: drive.    
  Chapter 6, In the Lab #1, Part 1 EX 496 to EX 497 4
 
Rings and Things, Using a Template
   
  Chapter 6, In the Lab #1, Part 2 (Steps 1 to 7 only) EX 497 to EX 498 4
 
Rings and Things, Chart
   
  Chapter 6, Cases and Places #1 EX 504 4
 
San Pueblo's Expenditures
   
  Chapter 6, Cases and Places #4 EX 505 5
 
Analyzing Your College Expenses
   
    Total 100

 

Jump back up to the top

 

| Syllabus | Assignments | Current Schedule | Course Files | Useful Tips | CAS Forum |

Return to Greg Kerr's Homepage

Copyright © 2007-09-10
Greg Kerr

Assignments