Welcome to CA141 Computer Applications II (Excel 2007)

 

Files Created and/or Required   For   The Office 2007 text by O’Leary   Excel 2007

Hands-On Exercises

Exercise 1.

Exercise 2.

Exercise 3.

Exercise 4.

Exercise 5.

Lab 1.

ex01_Animal Housing.xlsx, Animal Housing Analysis.xlsx

ex01_US Hurricanes.xlsx,  US Hurricanes Analysis.xlsx

ex01_Family Income.xlsxFamily Income.xlsx

ex01_Publishing Salaries.xlsx,  Publishing

Salaries.xlsx

Ex01_Pecan Groves Budget.xlsx,  Pecan Groves.xlsx

Lab 2.

ex02_Credit Data.xlsx Graphic ex02_Credit Card (Optional),  Teens and Credit.xlsx

ex02_Music Download Analysis.xlsx,  ex02_mp3 player (Optional),  Music Download Analysis.xlsx

ex02_Adoptions.xlsx,  Graphic ex02_Pets (Optional),  Adoption Tracking.xlsx

Graphic ex02_Basketball or ex02_Volleyball (Optional),  Youth Sports Data.xlsx

Graphic ex02_Computer Girl and ex02_Computer Boy (Optional),  Teen Online Activities.xlsx

Lab 3.

ex03_Juice Bar.xlsx,  Juice Bar.xlsx

ex03_Cookie Time.xlsx,  Cookie Time.xlsx

ex03_Paris Tour.xlsx,  Paris Tour.xlsx

ex03_Grade Report.xlsx,  Grade Report.xlsx (In

Folder Grade Analysis)

ex03_Doggie Day Care.xlsx,  Doggie Day Care.xlsx

 

 

 

 

 

 

 

 

 

 

 

 

 

Exercise 1.

Exercise 2.

Exercise 3.

Exercise 4.

Exercise 5.

Working Together 1.

exwt1_Rescue Memo.docx, exwt1_Contributions.xlsx,  Contributions.xlsx, 

 

RescueMemo Linked.doxs

 

exwt1_Tour Status Report.docx,  exwt1_Adventure Travel Status.xlsx, 

Adventure Travel Status.xlsx, 

 

March Status Report.docx

 

exwt1_Home Price Memo.docx,  exwt1_Real Estate Prices.xlsx,  Home Price Memo.docx

 

 

 

Hands-On Exercises

 

Exercise 1.

 

Exercise 2.

 

Exercise 3.

 

Exercise 4.

 

Exercise 5.

Lab 4.

ex04_IronWorks Income.xlsx,IronWorks Income1.xlsx,  Template:IronWorks Income Template

ex04_Day Care.xlsx,  Doggie Day Care.xlsx

ex04_Travel Analysis.xlsx,  Airlines Income Analysis.xlsx,  Template:Income Analysis template

ex04_Cards and Gifts 2009.xlsx,  ex04_Cards and Gifts 2008xlsx,  Cards and Gifts 2009.xlsx, Template:Cards and Gifts Analysis Template

ex04_ARF Contributions.xlsx,  ARF Analysis.xlsx,  Template: ARF Analysis Template

 

 

 

 

 

 

 

Exercise 1.

Exercise 2.

Exercise 3.

Exercise 4.

Exercise 5.

Lab 5.

ex05_ARF Volunteers.xlsx,  Volunteers.xlsx

 

ex05_Att Sales.xlsx,  ATT Projected  Sales.xlsx, Template:Projected Sales form

ex05_Electronics Analyzer.xlsx,  Electronics Analyzer.xlsx

ex05_Furniture sales.xlsx,  Furniture Delivery.xlsx, Template: Furniture Delivery Form

ex05_Grades.xlsx,  Gradebook.xlsx

Lab 6.

ex06_LFC Employee List.xlsx,  LFC Analysis.xlsx

ex06_Kodiak Jobs.xlsx,  Kodiak Jobs Update.xlsx

ex06_Wilson employees.xlsx,  Wilson Employee Rewards.xlsx

ex06_ATT Client Table.xlsx,  ATT Client Table2.xlsx

ex06_Arf Inventory.xlsx,  ARF Inventory.xlsx

Working Together 2.

Exwt2_Decorator’s Resource Gallery.xlsx,  Artist Inventory.xlsx

Wilson Employee rewards.xlsx,Lab 6, #3,  Employee Rewards Web Page.htm,  Graphic exwt2_Awards image

 

 

 

 

 

 

 

 

 

On Your Own

Exercise 1.

Exercise 2.

Exercise 3.

Exercise 4.

Exercise 5.

Lab 1.

Calorie Tracking.xlsx

Personal Budget.xlsx

Project Hours.xlsx

Music Analysis.xlsx

Electronics Analysis.xlsx

 

Lab 2.

ex02_Job Market.xlsx,  Seminar.xlsx

Grades.xlsx

Mutual Funds.xlsx

ex02_Graduate School.xlsx,  Graduate School2.xlsx

Insurance.xlsx

Lab 3.

Personal Budget2.xlsx

 

Company Business.xlsx (Folder named Business)

House Analysis.xlsx (Folder named Housing)

Inventory Tracking.xlsx

My Business,.xlsx

Lab 4.

Video game Projections.xlsx

Spring Break Analysis.xlsx

Expansion Projections.xlsx

Stock Analysis.xlsx

Loan Analysis Template

Lab 5.

Car Purchase Analysis.xlsx,  Template:Payment Analysis Template

My 401K.xlsx

Furniture Loan Analysis.xlsx,  Template:Furniture Loan Analysis Template

Speeding Fines.xlsx,

Template:Speeding Fines template

 

Laptop Computers.xlsx,  Template:Laptop Computer Template

Lab 6.

Bradford Suppliers.xlsx

Toy Inventory.xlsx

Summer Baseball League.xlsx

Pet Sitting Customers.xlsx

CHB Inventory.xlsx

 

 

 

 

 

 

1.       File names typed in blue and italics are files created in the Exercise by the student.

2.       File names typed in red are files created by the student in another Exercise and used by the student in the current Exercise.

3.       Files typed in black are files provided by the authors.

Copyright source: Textbook Website,

http://highered.mcgraw-hill.com/sites/0073519162/student_view0/excel/student_data_files.html

Hit Counter