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