INSY 2299 Final Exam Study Guide Fall 2014
Professor Ren
Exam: Friday December 19, 9:30 AM
Duration: 75 minutes
Location: Keating 3st
The final exam is closed book, closed notes, and closed computer.
The final exam focuses on materials since the midterm.
IBM, Corporation
Sydney Canessa, John D Alessandro, Jennifer Espinal, Aislinn Keenan, Daniel Kraus,
Kristen Lyons, Luke Stampfl
Executive Summary
IBM is an information technology services company that works with computer hardware
and software. The company
INSY 2299 Excel Lab Exercise #2 Fall 2015
RAM Widget has asked you to create a spreadsheet model to keep track of the inventory
in its three warehouses, known as WH1, WH2, and WH3. For each warehouse, RAM
needs to know the following:
Warehouse Capacity (h
INSY 2299 Information Systems Fall 2015
Excel Assignment #1
Due: 11 PM on Monday 09/28/2015
The policy on late assignments is stated in the syllabus.
Deliverable: You are to upload in Blackboard an Excel Workbook containing the
spreadsheets you create in
REVISED on SEPT 30, 2015
INSY 2299 Information Systems Fall 2015
Excel Assignment #2
Due Date: 11 PM on Monday 10/05/2015
The policy on late assignments is stated in the syllabus.
Deliverable: You are to upload in Blackboard an Excel Workbook containing t
WolfgangKellerat
TAK
Performance
Management,Feedback
&Coaching
Announcements
n
n
Ifyouhaventdoneeitherofthesurveysforthisclass,
DOTHEMNOW!
AssessmentsToday!
Afteryourteamclosureexercise/worksheetforIP,
eachofyoushoulddoanindividual2pg,double
spacedwriteup
Negotiations
To Do Today
o Announcements
o Hand back quizzes. Overall, good job!
o Go over negotiation
o Participation Survey 2
Announcements
o I am going to China
n
n
n
n
11/7 Negotiation
11/14 No Class
11/21 Keller Case. YOU MUST READ
THE CASE!
11/25 In
INSY 2299
Fall 2013
Session 9
Conclusion
Increasingly standardized corporate data, and
access to rich, third-party datasetsall
leveraged by cheap, fast computing and easierto-use softwareare enabling an age of datadriven decision-making.
11-2
Where do we
1
Making Judgments About
Others
Management I
Dr. Emich
2
First Participation Survey
n
https:/cornell.qualtrics.com/SE/?SID=SV_5uO
3
Leadership 360 Announcements
l
l
l
Ratings should all be in
We are working on cleaning up the data now
Reports should be pu
INSY 2299
Fall 2013
Session 13
Why is Cloud Computing
called Cloud Computing?
The Internet
Network of networks of . . .
tension
Somewhat-organized anarchy
TCP/IP
Packet Switched
Email
Gmail
Email
Server
Yahoo
Email
Server
SMTP
POP3
IMAP
POP3
IMAP
Blac
INSY 2299
Fall 2013
Session 12
Virtualization
A type of software that allows a single computer
to function as if it were several different
computers (or several computers to function as
if they were a single computer).
Each virtual computer can run
its
INSY 2299
Fall 2013
Session 11
How to Think about IT
The consequences of IT are not necessarily positive!
Everything is Going Digital!
Represent stuff as bits
Store the bits
Process the bits
Transmit the bits
Everything Digital is Getting Smaller!
Tec
Motivation
2
Self-Assessment Project Goals
n
n
n
n
n
Help you develop greater self-awareness, which will in
turn help you in lots of other ways personally &
professionally
Give you practice getting and responding to/using
feedback prepare for this occurri
INSY 2299
Fall 2013
Session 10
Everything is Going Digital!
Represent stuff as bits
Store the bits
Process the bits
Transmit the bits
Everything is Going Digital!
Everything Digital is Getting Smaller!
Microminiaturization
Chips = Microchips = Semiconduct
PART TWO: MONITORING AND CONTROLLING YOUR CONSULTING
CHALLENGE RECOMMENDED RESPONSE
(1) Our response to the opportunity we noticed is the development of the Find my Friends
application. This application is pre-downloaded onto all of the newest Apple iPhon
Info Systems Final Review
Design View (Structure) vs. Datasheet View (Contents)
Create Tables and Queries using Design View
Choose an appropriate primary key for each table
Make sure your Text fields are of appropriate size
Enforce Referential Integrity
Q
Information Systems Study Sheet MidtermThe Consequences of It are not necessarily positive
Dont achieve positive objectives
Negative side effects
Costs (TCO) exceed benefits
The benefits of IT are not automatic
An Information System (IS) is an application
5.1
5.2
Moores Law applies to the semiconductor industry. The widely accepted managerial interpretation of
Moores Law states that for the same money, roughly eighteen months from now you should be able to
purchase computer chips that are twice as fast or
INSY 2299 Midterm Study Guide and Review Sheet Fall 2014
Midterm Date: 10/24
1. The exam is closed book, closed notes, and closed computer. You will have 75
minutes.
2. The exam may include multiple-choice, true-false, fill-in, matching, short-answer, and
Fashions 'R Us, Inc.
Monthly Sales&Analysis Report
9/26/2014
Christine Wong RUH
Sales Tax Rate
Sales Commision
Product
Hats
Coats
Gloves
Sweaters
Boots
Total
14-Sep
10%
5%
Previous Month's Sale Current Month's Target Current Month's Sales % of Target Achi
Company:
Accountant:
Date:
Annual Rates:
Cost of Goods Sold
EBT
Selling, General, and Administative
Advertising (in million)
Depreciation and Amortization
Rental Expenses
Accrued Expense
Wong-INSY 2299 RUH
Coca Cola
Christine Wong
Oct 2nd, 2014
-2.40%
30.
IP Company: KO
Multi-Year Planning Model
Gabelli School of Business: INSY 2299
September 30, 2014
Input Variables
Sales Revenue Growth Rate
CGS Ratio
Tax Rate
SG&A Growth Rate
Depreciation and Amortization Growth Rate
Accrued Expense Increase
Rental Expen
Final Review 1
NOTE: Final review begins on page 3
INSY 2299 Final Exam Study Guide
Professor Kamesam
Exam: RUY 5th may 2015 9.30am
RUZ 8th May 2015 9.30am
The final exam is closed book, closed notes, and closed computer.
The final exam is cumulative with
Sum - Expenditures (million $)
Age
<25
>=65
25-34
35-44
45-64
Total Result
Year
Category
2008-2009 2010-2011 Total Result
230,940
225,886
456,826
Alcoholic beverages
3,194
3,234
6,428
Apparel and services
11,128
11,801
22,929
Cash contributions
3,134
2,68
INSY 2299 Information Systems Fall 2016
Information Systems Deliverable
Due Date: 11 PM, 11/22, Tuesday
The policy on late assignments is stated in the syllabus.
This is a GROUP project that you should prepare and submit jointly with your CC
group.
Submis
INSY 2299
Fall 2013
Session 8
Concluding Business Analytics
Decision Support System (DSS)
A Computer-Based Information System that is intended
to support, but not replace, (managerial) decision
makers in performing their problem-solving tasks.
DSS combine
Safeway
4-year Financial Projection
2012-2016
Martin Bartoszewicz
RTG
Created on: 10/7/2013
Annual Sales Revenue Growth :
Cost of Good Sold (% of Sales Revenue):
Tax Rate:
Annual Selling, General, and Administration Growth:
Depreciation and Amortization G
