Problems from Course Text

The following is a list of files that correspond to the problems in the back of the course notes book. Using Netscape from a Windows environment, you should be able to open each file and save it to your directory. This will not work from a Unix environment.

Files Required CS&E 101 for Course Notes Problems

Filename (click on text)	Topic of Problem
simplefor.xls	*Excel 1.1-1 -Food shopping :writing simple formulas and functions*
*1.1chapter_review.xls*	*Excel Chapter 1.1Review (solution)*
relative.xls	*Excel 1.2-1 -Relative/Absolute cell referencing*
multtable.xls	*Excel 1.2-1 -Cell referencing - Creating a Multiplication Table*
*1.2chapter_review.xls*	*Excel chapter 1.2 review (solution)*
*grades.xls*	*Excel 1.3-1- Grade calculation: simple cell addressing & functions*
*expenditure.xls*	*Excel 1.3-2- Monthly Expenditures: cell addressing & functions*
rock.xls	*Excel 1.3-3- Rock Concert:cell addressing & functions*
*1.3chapter_review.xls*	*Excel chapter 1.3 review (solution)*
*stocks.xls*	Excel 1.4-1- Stock analysis: simple relational expressions and logical functions
*food.xls*	*Excel 1.4-2 - Food Problem: logical contructs - all, at least, none, only*
logicfly.xls	Excel 1.4-3 - Airline Flying Problem: using logic to solve problems
*1.4chapter_review.xls*	*Excel chapter 1.4 review (solution)*
simpleif.xls	Excel 1.5-1 - Using Simple If 's
*travelpackages.xls*	*Excel 1.5-2 - Nested if examples*
*1.5chapter review.xls*	*Excel Chapter 1.5 Review (solution)*
waterunits.xls	Excel - 1.6-1 - Water Problem: solving problems with unit conversions
*1.6chapter_review.xls*	*Excel chapter 1.6 review (solution)*
*Financial Functions -practice*	*Excel Chapter 1.7-1 Practice with Fiancial functions (solution)*
*loan.xls*	*Excel - 1.7-2- Loan Anyalsis: financial functions*
*1.7chapter_review*	*Excel chapter 1.7 review (solution)*
copies.xls	Excel - 1.8-1 - Cost of Copies Problem: reference functions
*refgrades.xls*	*Excel - 1.8-2 - Gradebook : reference functions*
*shipping.xls*	*Excel - 1.8-3 - Sales Order Pricing (shipping costs):reference Functions*
*1.8chapter_review.xls*	*Excel chapter 1.8 review (solution)*
child.mdb	Access -2.2-1 & 2.3-1 & 2.4-1- Child Activity Database
*2.1 chapter review*	*Access database concepts review (solution)*
2.2chapter review.mdb	Access Chapter 2.2 review (solution)
music.mdb	Access -2.3-2 - Music Databse
2.3chapter review.mdb	Access Chapter 2.3 review (solution)
mysnack.mdb	Access - My Snack Database
Sample Final	Solution to Sample Final