Make your own free website on Tripod.com
Robert Morris College www.thirdwave-websites.com/ci310

CI-310 : November 15, 2000


CI-310 Information Systems Applications, 3 credits Admin/ General
Wednesday evenings, 6:00 - 8:50 pm Hale 306 Schedule
Instructor: Ed Quigley 724.774.2088
Dept. Head: Dave Wood, Ph.D. 412.262.2788 Links



Spreadsheet Review

handout, Midterm Problem 2

Substitute Problem: Aplus.com


You have $10K in savings and another $10K in investment seed money from a doting grandparent who is sure you're gifted and believes that "dot-com" is the way to go. You develop a business plan in which you will establish a web site, Aplus.com , which will sell term papers to weary college students.

You intend to operate your business out of your dorm room. Your fixed expenses include your web server ($5 per week) , advertising ($100 per week on Tshirts that you will distribute at RMC away-game sporting events), and a weekly staff party for your writers involving two kegs, ten pizzas, and buying off the RA ($150/week).

Your variable expenses for each paper are the $10 per paper that you will pay other students for writing the papers for you. Your sub-contractors will write these papers while standing watch at the RMC desk, watching over the computer lab, or sitting in class pretending to work on their web page.

You will charge $25 per paper. In an attempt to increase business, you have guaranteed that your papers will receive grades of A or A+, or they'll get their money back. Not wanting to be over-extended, you intend to operate under the assumption that 25% of your papers will result in returns. Therefore, your actual revenue will be (#papers x $25 x .75) .

You suffer one other constraint: you only have time to deal with a certain number (FIVE) of these orders per day, five days a week. So you have a capacity limit of 25 orders per week.

The Numbers Are In: The number of orders you receive per week is shown by this table:
WEEK 1 2 3 4 5 6 7 8
# orders 37121621252932

After you have been operating profitably for a while, your OneTrueLove (OTL) suggests that you hire him/her as your CIO, doubling your capacity to 70 reports per week. OTL offers to perform this work for a flat rate of $250 per week, and hints you'll be able to write off your dates as a business expense. As you have only filed short-form tax returns, you choose to ignore the tax implications of this approach, but you hire OTL.

Remember: Answer One, Two, Three A,B, Four A,B,C,D




Databases

Alternative Problem: The APlus.Com Database

Create a new database. Within the database, create a new table that will store the following fields: Enter the following data into the table, and save the database.
SamMoonsam@rmc.eduExcelHTML83
TomPghtom@rmc.eduHTMLCPR40
JoeMoonjoe@rmc.eduArtLiterature51
MaryMoonmary@rmc.eduHRAccounting90
RobinPghrobin@rmc.eduSportsMedia53
JDPghjayd@rmc.eduFrenchArt21


Quiz.

View/Rent any ONE of the following movies: In each of these movies, the People interacted with their Information Systems in pursuit of their goal. In the movie you watched, what mistakes happened in the interaction between the People and the Systems? How could these mistakes have been prevented? How does this lesson possibly apply to contemorary business systems in our modern networked information economy? Your single-spaced answer should not exceed one typed page.


Timing

.