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
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
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
1. Example: The Tropical Resort Demo (continued)
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
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
Will the result value of these formulas be positive or negative?
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
-Adds up everything from first to last cell
-Averages all highlighted numbers
=If(Logical_test,[If true],[If false])
-Counts the amount of numbers in a group of cells
-Counts all the #s, lett
Computers in Management Notes
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
Lottery Ticket Problem
How much money is left over if I put the selling price amt
in the bank and take out $50,000 for 20 years?
Suppose I take all the money I get and invest i
Computers in Management Final Exam Review
Zara (Chapter 3)
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
Korea, Republic of
Country or Area
Korea, Republic of
# of Courses
Number of Passing Scores:
Average Passing Score:
Enter Name: Jones
Computers In Management 2 Notes
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
IF(Logical Test, True action, False Action)
Counts everything but empty
value = places left or right of decimal
=If(Logical_test,[If true],[If fa
Midterm: short answer
Do not memorize things like eBay had $4.3 billion in sales in 2005. (Magnitude and relative
important, but exact numbers are not.)
Why is information important?
Changing roles of i