CSCI/ISYS 1021 Computers in Management (Second Half)
Homework Assignment 7
Due Wednesday, December 3 @9am
Read Chapter 11 of the Excel textbook. Then do the following three problems.
1. At Hill University students who register for at least 4 courses in a

CS021 Final Exam Cheat Sheet
Non-numeric characters will left-justify. Numbers or functions of numbers will rightjustify. A +,-,*,/ at the beginning of a cell will automatically assume the =. Numbers as
letters must be in double quotes.
means leave the c

4/26/13 5/1/13
1. Independent Events
The TortoiseHare demo uses a random value for each tortoise move, and
another random value for the hare's move.
Why not use just one random value?
Because the moves are independent.
If we used a single random value

4/17/13 4/24/13
1. Student Grade Demo
The first sheet of the demo gives a table that lists the test score for several
students. We want to modify it in several ways.
Task 1: Add formulas in column D to print PASS or FAIL, depending on
whether the score

4/8/13
1. Example: The Tropical Resort Demo (continued)
Policy 4:
This is the same as policy 3, except that we want doubles that do
NOT face inland.
One solution is to simply replace D6="Inland" by D6<>"Inland".
Another solution is to use the NOT func

3/27/13
1. The PMT function
In addition to the four functions we have been using, there is also a fifth, called
PMT, which calculates the payment required to turn the PV into the
FV.
Will the result value of these formulas be positive or negative?
PMT(.

Notes: 3/18/13 3/22/13
1. Example: Bank Account
I have a bank account.
It pays me 2% interest, compounded at the end of every year. The
account currently has $100.
Immediately after getting my interest each year I deposit $50. How
much money will I hav

Notes: 3/11/13 3/15/13
1. Using a Spreadsheet
Open up Excel. What do you get? A bunch of blank cells.
A cell is referenced by its column letter and row number. For example,
A1, B9999, BF24
A spreadsheet has more cells than you will ever need. 16,384 co

Excel Study Sheet
Formulas
=Sum()
-Adds up everything from first to last cell
=Average()
-Averages all highlighted numbers
=If(Logical_test,[If true],[If false])
=Count()
-Counts the amount of numbers in a group of cells
=Counta()
-Counts all the #s, lett

Computers in Management Notes
Tuesday 2.8.2011
Netflix
Netflix Model
o Set up a list of movies
o Send one at a time
Barriers to entry
o Those things that make it difficult for a company to get started up.
o Internet firms have low barriers to entry
Co

Lottery Ticket Problem
Selling Price
Payments
Payment Amt.
Discount Rate
$679,516
20
$50,000
4%
How much money is left over if I put the selling price amt
in the bank and take out $50,000 for 20 years?
$0.01
Suppose I take all the money I get and invest i

Computers in Management Final Exam Review
Zara (Chapter 3)
1.
2.
3.
4.
Why has Gap struggled in recent years?
How does Gap plan products, manage inventory, and build its brand?
What challenges has this presented to Gap?
What is the Fair Factories Clearing

Country or Area
United States
Argentina
Australia
Austria
Belgium
Brazil
Canada
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Hungary
Ireland
Israel
Italy
Japan
Korea, Republic of
Mexico
Netherlands
New Zealand
Norway
Philippines
Poland
Por

Country or Area
United States
Argentina
Australia
Austria
Belgium
Brazil
Canada
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Hungary
Ireland
Israel
Italy
Japan
Korea, Republic of
Mexico
Netherlands
New Zealand
Norway
Philippines
Poland
Por

Exercise 1
Name
Sam
John
Amy
# of Courses
5
4
2
Name
Alice
Bob
Carlo
Darla
Emily
Speed Limit
30
45
65
25
45
Name
Amy
Bob
Cal
Dan
Eva
Fran
Gary
Hal
Ida
Joe
Kevin
Reading SAT
920
640
320
590
290
700
780
780
320
460
600
Tuition Owed
21000
21000
11000
Exercis

LASTNAME
Baer
Baker
Jacobs
Jones
Lee
Smith
Tang
FIRSTNAME
Randy
Able
Sue
Ed
Bill
Joe
Amy
Average Score:
Number of Passing Scores:
Average Passing Score:
Enter Score:
Grade is:
Enter Name: Jones
Grade is:
Grade is:
SCORE
P/F?
87 PASS
68 PASS
93 PASS
57 FAI

Computers In Management 2 Notes
Zhu
TA Xiaoyu
3.15.2011 Excel
Talks a lot about stuff that doesnt really matter
Something about special education
Doesnt love laptops
Strict about homework
Grade = 50% hw + 50% final
Final: May 12 4PM-6PM
Tuesday 3.22

Excel Functions
IF(Logical Test, True action, False Action)
COUNTA()
Counts everything but empty
Rand()
AVERAGE(range)
MAX(range)
Sqrt(number)
ROUND(value, number)
value = places left or right of decimal
=Sum()
=Average()
=If(Logical_test,[If true],[If fa

General Notes
Midterm: short answer
Do not memorize things like eBay had $4.3 billion in sales in 2005. (Magnitude and relative
sizes are
important, but exact numbers are not.)
Why is information important?
Individual Transformation
Changing roles of i