ISM UF Exam 1
What is an example of an absolute cell reference?
$G$15
Who said "the number of transistors incorporated in a chip will approximately double every 24 months?"
(Moore's Law) Gordo Moore (Co-founder of Intel)
What are characteristics of BYOD?
- Allowance (given to employee to select own device) - Employee responsibility
What typically drives corporate purchases of IT?
- Business requirements (primary) - TCO
1. Specialized computer 2. Multiple network ports 3. Specialized software
- Characteristics of routers
What typically drives personal purchases of IT?
- Style and whim - If it feels good, do it! - flavor of the day (new & fresh) - hot rod syndrome (fastest on market)
Gig-E servers, infrastructure, the new desktop standard
1 gbps
Advances in technology are causing disruptions in many areas of business, specifically these 6 areas:
1. Advertising, 2. Education, 3. Journalism, 4. Retail, 5. Financial Services, 6. Share Economy
What are benefits of DaaS?
1. Rapid deployment (gold image) 2. rapidly scale up/down 3. reduce support cost 4. any user device 5. no data on user devices 6. operating expense
Problems with Peer-to-Peer model
1. Reliability 2. No backups 3. Scalability
Your company has chosen to use a "Lightweight Approach to MDM" as described in this week's lectures. Given that corporate policy, which of the following statements are true? (select all that apply) A) mobile device users must install a special app to allow this type of mobile device management B)unfortunately, users can easily circumvent the "lightweight approach" since the corporate email server can't enforce compliance C)they have the ability to "remotely wipe" a mobile device that is lost D)they are taking advantage of built-in features of most mobile devices; the mobile device user doesn't have to install extra software
C)they have the ability to "remotely wipe" a mobile device that is lost D)they are taking advantage of built-in features of most mobile devices; the mobile device user doesn't have to install extra software
an example of a relative cell reference
C45
Which "CAT" ratings are appropriate for use today?
CAT 6 or above
Imagine that you've found a photo that is a Creative Commons licensed image to use on your corporate website. The one you've found is good, but needs some basic editing before you it will be suitable for your needs. What type of Creative Commons license could you use in this situation?
CC BY SA
"Senior corporate executive with primary responsibility for the security of the company's information systems and data."
CISO
a device or computer program capable of encoding or decoding a digital data stream or signa
CODEC
What is an enterprise system used to support customer related sales and marketing activities?
CRM
Salesperson needs to track information about a set of clients - names, addresses, items they've purchased, summary of each phone call, etc.. They need a _______
CRM (Customer relationship management)
1. Coaxial cable (metal shield) 2. Bandwidth shared with neighbors
Cable broadband characteristics
Why is backwards compatibility good?
Can connect newer versions to older versions
1. Existing telephone wires 2. Low quality cabling 3. Limited distance
DSL characteristics
Tara's Tax service plans to hire 100 temporary employees soon. Rather than buying each one a PC, the company wants to host virtual PCs in the cloud for these temporary hires. What cloud based solution would best fit their situation?
DaaS (Desktop as a Service)
Which communication type is the "star" of web conferencing
Data: screen sharing
MySQL Oracle Microsoft SQL software
Database server applications
Radical technological changes in recent decades have made it impossible for many industries and companies to continue operating in their normal way. They have been forced to adapt or become irrelevant. What term do we use for this phenomenon?
Disruption
To cause something to be unable to continue in the normal way
Disruption
Network of spatially separated antennas connected to transport medium that provides wireless service to a building or structure
Distributed Antennae System (DAS)
What has driven demand for increasing Ethernet bandwidth?
Increased demand for videos and larger data
Backup only files that have been changed
Incremental backups
Large businesses, schools, corporations, etc
Infrastructure
Technology has "thrown a grenade" into this management discipline.
Innovations like SEM, SEO and CRM are some of the key tools that successful professionals in this career field will need to master.
Kevin Systrom founded?
Instagram (13 employees)
What does IDE stand for?
Integrated Development Environment
A global system of interconnected computer networks
Internet
An organization or firm that provides access to the Internet
Internet Server Provider (ISP)
High-speed data lines provided by many firms all across the world the interconnect and collectively form the core of the Internet
Internet backbone
Benefit of Peer-to-Peer model
Good for small businesses
Larry Page & Sergey Brin founded?
_____________ pockets half of all mobile ad spending.
_________________ ad revenue surpasses the entire US print industry's advertising.
Google's
Who is the co-founder of Intel?
Gorden Moore
This computer pioneer accurately predicted that the number of transistors on a chip would double approximately every two years.
Gordon Moore
What does GUI stand for?
Graphic User Interface
Protocol for VTC over IP
H.323
Before switches, had data delivered to every connection when sent
HUB
Server containing the content
Host name
Disruptions in the Share Economy affect __________, _________, & __________ _______
Hotels, Taxis, Rental Cars
1. realistic goals 2. requirements specification 3. executive champion (leadership) 4. avoid "feature creep" 5. communicate 6. evaluate and address risk 7. pay attention to testing 8. real project management skills
How can the project success be maximized?
What is a programming environment that has been packaged as an application program, typically consisting of a code editor, a compiler, a debugger, and a graphical user interface (GUI) builder?
IDE
An environment consisting of text editor, debugger and other useful programming tools.
IDE (integrated development environment)
What formula do you use to handle 2 different situations?
IF()
What formula do you use to handle 3 different situations?
IF(test1,IF(test2, outcome1, outcome2), outcome 3)
In charge of forwarding packets on the Internet
IP
128.227.36.209
IP Address
What is the long-term solution to the problem of running out of IPv4 addresses?
IPv6
a set of communication standards for simultaneous digital transmission of voice, video, data, and other network services over the traditional circuits of the public switched telephone network
ISDN
Every budget is an ______ budget.
IT
You have contracted with some programmers to create a custom application for your company. This application must be cross-platform, working on Windows, Macintosh and Linux systems. Your goal is "write once, run everywhere."
It should work on any OS, any hardware.
Which of the following programming languages would the programmers be most likely to use, given your mania for cross platform compatibility?
JAVA
What programming language is "write once, run anywhere?"
Java
________ ________, the founded of Amazon in his garage when he was 30 years old.
Jeff Baezos
Which industry is seeing reduced staff due to external contributors?
Journalism
With only 13 employees, ______ ___________ made $1,000,000 in 2 months, $35,000,000 in 18 months and Facebook bought his company, Instagram for $1 Billion.
Kevin Systrom
is a powerful open source platform that has been used to build some of the most powerful, popular web applications in use today
LAMP stack
Network covering a limited geographical area, such as a single building
LAN
Networks spread over a limited geographical area
LAN (Local Area Network)
_________ _______ & _________ __________ were the co-founders of Google.
Larry Paige, Seirge Brinn
Technologies that connect end users to the Internet (usually the slowest part of the networks)
Last mile
Provider issue with cellular wireless
Licensing
How is a WAN contructed?
Links multiple LAN
What is the LAMP stack?
Linux, Apache, MySQL, Php
How is Fiber Optic Ethernet Cabling typically used?
Long runs in a network infrastructure
When considering the TCO of corporate PC ownership, which of the following are components of indirect cost? User Software, IT Software, Lost user productivity due to downtime, Desktop Management, Electricity (list all that apply)
Lost user productivity due to downtime
spreadsheet graphics data management ?
Lotus 1-2-3 comprised of
Which "CAT" ratings are obsolete and should not be used for business today?
Lower than CAT 5
48-5B-39-12-13-7F
MAC Address
Unique to every HW device--permanently burned into HW
MAC Address
Uniquely identifies a node from every other one on the planet; however provides no information about its location
MAC Address
1. Moves faster than the earth rotates 2. Multiple satellites 3. 2000-35,780 km above earth
MEO characteristics
What does technology have to do with the law?
Many of the hottest ares involve technology
________ ______________ is the founder of Facebook.
Mark Zuckerberg
By the way, Gartner research predicts that the corporate executives in this discipline will spend more money on technology than even CIOs do!
Marketing
________ _____ is the founder of Dell.
Michael Dell
Bill Gates founded?
Microsoft
Email server application
Microsoft Exchange server
Name in the same order, the companies associated with the tech entrepreneurs who founded them: Bill Gates, Mark Zuckerberg, Sergey Brinn & Larry Paige, & Jeff Beazos.
Microsoft, Facebook, Google, & Amazon
____________ ______ and ______________ ______________ are likely to motivate corporate technology purchasing
Minimizing TCO (total cost of ownership) , business requirements
768 kbps
Minimum required bandwidth for Broadband
_________ _____________ users are expected to reach 894 million by 2015.
Mobile banking
________ ___________ __________ will reach $3.2 trillion in 2017
Mobile commerce transactions
The number of transistors incorporated in a chip will almost double every 24 months.
Moore's Law
Solution to LAN hardware failure
Multiple NICs
A technique that uses a gateway that allows multiple devices to share a single IP address
NAT (Network Address Translation)
Not in my backyard; people don't want ugly towers in their neightborhoods/on their land
NIMBY problem
_______ _________ ______________ payment systems - use your smart phone to pay bills with a touch.
Near Field Communications
The principle that all Internet traffic should be treated equally
Net neutrality
Collection of devices connected together via communication devices and transmission media
Network
Collection of devices connected together via communications devices and transmission media
Network
Suppose that for a particular piece of application software, its value to the user increases as the total number of users increase. What term is used for that phenomenon?
Network effects
IP address designed for use in the public domain
Public IP
What does technology have to do with operations?
Quality programs, process redesign, supply chain management, factory automation, and service operations are all tech-centric.
Solution to HD failure
RAID
2 HDs Saved data on BOTH HDs simultaneously Fast Simple Expensive
RAID 1 (Mirroring) characteristics
________ is a technique that protects against hard drive failure. The system uses 3 or more drives. Data is divided into chunks, which are stored on (N-1) of the drives. Error correction data is stored on the last drive, providing protection against the failure of any single hard drive in the array.
RAID 5
3 or more HDs Saved data on all but one (error corrections) More scalable More complicated Less expensive "Parity"
RAID 5 characteristics
Alexis Ohanion & Steve Huffman's very successful company, __________ has 86 million users but only 22 employees.
Alexis Ohanian & Steve Huffman founded?
Reddit (22 employees)
Why is backwards compatibility bad?
Reduced speed
How to prevent backhoe problem
Redundant pathways
-How are mobile device users connected to the VPN?
Remote nodes with VPN software
How are users in remote offices connected to the VPN?
Remote nodes with VPN software
What do you do if you have WEP security
Replace it
Which industry is dealing with people spending more money online?
Retail
Your company has decided to purchase a MDM suite that supports "containers." Which of the following is clearly a benefit of that decision?
They can erase corporate data from your iPhone without harming your personal information.
Why do we need operating systems?
They make it easier for users to interact with computers and for programmers to write application software
Mr. Olson is mighty fond of his MacBook Air. He claims it's the best laptop he's ever owned... very light, ultra portable, and fast. That device is an example of a ___________.
Thick client
Scenario: Your company needs to hire about 100 short-term contract workers. They start work in a few weeks and will only work for the company for 90 days. You make the call! Would a thin client or thick client make most sense for this use case?
Thin client
What is the problem with using the public internet to provide remote users with access to an organization's private resources?
Too public--could be hacked
What does TCO stand for?
Total Cost of Ownership
What are cells that are referred to by a formula in another cell?
Trace Precedents For example, if cell D10 contains the formula =B5, cell B5 is a precedent to cell D10
Diagnostic tool used to traverse all router connections between 2 internet nodes
Trace Route
What contains formulas that refer to other cells?
Trace dependents For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5
Companies like IBM and Dell make huge amounts of money selling consulting services for Open Source products. True or False?
True
T/F: Tech-centric jobs range from programmers to non-programmers who may help identify problems.
True
The use of open source components can help a firm bring new software products to market faster. True or False?
True
1. Key non-redundant component broken 2. Software crash
Two examples of total server failure
laptops + connected switches
Typical Ethernet LAN
2 mbps
Typical bandwidth of 3G
5-12 mbps
Typical bandwidth of 4G LTE
7-100 mbps
Typical bandwidth of DSL
50 mbps typical
Typical bandwidth of FTTH
56 kbps
Typical bandwidth of analog modems at the end of popular use
50 mbps
Typical bandwidth of cable broadband
Protocol that operates in applications where delivery speed is important and quality can be sacraficed
UDP
Solution to a power outage
UPS
Your company is concerned about the impact of brownouts on its computers. Which of the following would protect against that problem?
UPS
Your small business is in a building that experiences a lot of unexpected power outages. Whenever this happens, the servers crash and you lose money. Which of the following could help solve that problem?
UPS (Uninterruptible Power Supply) A device that provides battery backup when the electrical power fails or drops to an unacceptable voltage level.
Unshielded Twisted Pair
UTP
What does UI stand for?
User Interface
Single biggest cause of data loss
User error
_____ _________ is the single greatest cause of lost data.
User error
Why did ISDN inhibit the growth of video teleconferencing?
Uses multiple lines for quality
How to look up a value?
VLOOKUP
How well does VPN address remote office or mobile user use cases?
Very well
Rich communication between 2 or more sites; voice and video
Video Teleconferencing
Polycom Cisco
Video Teleconferencing vendors
Encrypts data being sent over the public internet
Virtual Private Network (VPN)
____________ brings flexibility - allows you to run Windows on a Mac, etc.
Virtualization
- Uses IP for telephone calls; voice
VoIP
Network spread over a large geographical area
WAN (Wide Area Network)
You're concerned about cybercriminals getting onto your wireless LAN. Which of the following will provide the best protection?
WPA2 (improves the security of Wi-Fi connections by requiring use of stronger wireless encryption)
Communications via video, voice, screen sharing, text chat, etc
Web conferencing
1. WebEx 2. Adobe connect 3. Big Blue Button 4. MS Lync
Web conferencing vendors
Apache Microsoft IIS
Web server applications
Not only is the "sexiest job of the 21st century" in Information Technology, there are some fantastic corporate leadership opportunities as well!
Which of the job titles below best matches the position description below?
What does the IP Address tell you?
Who is using it and where they are
What does the MAC address tell you?
Who is using it?
____________ has broken more investigative stories than all other media combined.
Wikileaks
Client PC-network computer controlled by a person
Workstation
Which of the top-rated virtualization systems is an open source project?
XEN
Is WPA2 secure?
Yes
Is technology a disruptor?
Yes
Would programmers benefit from telecommuting?
Yes
You're thinking about buying a small building for your company. Your employees work with extremely large datafiles and need Gig-E to be productive. You've just learned that the new building has Cat3 cabling. Will you need to replace the network cabling?
Yes
-Are different types of traffic treated differently?
Yes; non-VPN nodes do not require data to be encrypted when sent
What gives code jockeys immediate, nearly zero-cost distribution to a potential market of hundreds of millions of people worldwide?
app stores
What does API stand for?
application programming interface
What is a program that handles all application operations between users and an organization's backend business applications or databases?
application server
What is all the computer software that causes a computer to perform useful tasks beyond the running of the computer itself?
application software
say who its by, who created the work
attribution
Tech skills are being "_________" into every job.
baked
1. Rapid deployment (gold image) 2. rapidly scale up/down 3. reduce support cost 4. any user device 5. no data on user devices 6. operating expense
benefits of DaaS
1. don't buy hardware 2. don't build expensive datacenter 3. install your own software 4. 7x24 support for platform 5. scalable (probably) 6. operating expense
benefits of PaaS
1. don't buy hardware 2. don't install software 3. don't have to patch/upgrade 4. rapid deployment 5. scalability 6. operating expenses
benefits of SaaS to the consumer
A great idea, good people, plus technology could equal _____ _________.
big money
What term is used for times when a company's servers will is hit with an incredible spike in demand and load exceeds capacity of the servers?
black swan
What is an event or occurrence that deviates beyond what is normally expected of a situation and that would be extremely difficult to predict?
black swan event
OSS: What is Firefox?
browser
_____________________ takes code from a high-level, English-like language that humans can understand and converts it into a set of binary instructions that run on your operating system & CPU. This conversion is done one time and then can be used any number of times.
compilers
What are negative aspects of distributed computing?
complex and expensive
Work becomes "public domain" when?
copyright has expired
By default, only the _____________ ________ has the right to use their work.
copyright owner
some rights reserved
creative commons
OSS: What is mySQL?
database
making technology more accessible especially accessible to people without financial resources
democratization
What is software technology that separates the desktop environment and associated application software from the physical client device that is used to access it?
desktop (workstation) virtualization
What are programs that were installed for a single user, typically on the individual's computer system (laptop or desktop)?
desktop software
What does DaaS stand for?
desktops as a service
Suppose that a programming team wants their program to have the capability to print data. Back in the dark ages, the programmer would have written program code to directly manipulate the printer hardware -- very inefficient! Today, they would use a ____________ to accomplish that goal.
device driver
What is a program that determines how a computer will communicate with a peripheral device?
device drivers
Every business leader is becoming a ________ leader.
digital
What is something that interrupts the normal progress or activity of (something)?
disruptor
What limitations apply to the use of US Federal Government works?
domestic use only (US citizens within the US)
- Style and whim - If it feels good, do it! - flavor of the day (new & fresh) - hot rod syndrome (fastest on market)
drives personal purchases of IT
the idea that the cloud provider actually turns off unneeded service
dynamic provisioning
Worldwide ____________ will surpass $16 trillion in 2013.
e-commerce
This is a computing system that is built into another product. For example, Otis Elevators uses these to make their elevators smarter and easier to maintain.
embedded system
What is a computer system with a dedicated function within a larger mechanical or electrical system, often with real-time computing constraints?
embedded system
What is DaaS?
enterprise cloud computing
What is installed on some sort of shared system where the exact same program is utilized by an organization or a large number of people?
enterprise software
1. iPhone 2. android 3. tablet
examples of a client
1. C# 2. C++ 3. Objective C 4. Java
examples of compiled programming language
1. security 2. availability 3. processing integrity 4. confidentiality 5. privacy
examples of external audits
1. Javascript 2. Microsoft: VB Script & Powershell
examples of interpreted programming language (scripting languages)
What are the characteristics of enterprise data centers?
expensive buildings/rooms lots of computers, storage devices, ac, power...
Forbes has reduced staff writers while doubling its network of ___________ _____________.
external contributors
1. greater energy efficiency 2. dynamic provisioning 3. multinenancy 4. higher server utilization 5. data center utilization
factors of the cloud allow it to be more energy efficient and environmentally friendly
can be used if beneficial to society and only if it does not damage the commercial value of copyrighted material
fair use
Your organization has decided to implement several cloud-based applications. You do NOT want your users to have different usernames and passwords for each application. In fact, you want them to use their normal corporate credentials to gain access. You will be searching for cloud providers who support ___________________.
federated authentication
What does the MAX function do?
finds the largest number in a range of cells
=MAX(F3:F6)
finds the largest number in the range F3 to F6
What does the MIN function do?
finds the smallest number in a range of cells
=MIN(F3:F6)
finds the smallest number in the range F3 to F6
What is a permanent software programmed into a read-only memory?
firmware
What does FTE stand for?
full time employees
The fact that more people have mobile access than safe drinking water and electricity, along with the fact that in developing countries 10 additional mobile phones per 100 people can grow GDP by 0.8% are examples of the _______________ of technology.
globalization
An age where via "the cloud" a startup company can rent the computer resources one previously had to buy, where app stores give code jockeys, immediate, almost zero-cost distribution to a world-wide market, and social media done right can spread awareness of a firm with nary a dime of conventional spending.
golden age of tech entrepreneurship
What metaphor is used for software steps?
hardware/software layer cake
What is a positive aspect of distributed computing?
highly scalable: if you need more power, buy more servers then you have more processing power, all of the data is secure in the data center
How to place a function on a spreadsheet?
insert function
Best choice for notebooks?
it depends on the situation
Open Source software has a democratizing effect. In part, this is due to the
lack of license fees.
Computing systems are often modeled using the metaphor of a _____ ______. This model separates various aspects of the system in order to simplify the development effort.
layer cake
OSS: What is Sakai?
learning management systems
How does OSS encourage democratization?
levels the playing field for small businesses
What do freeze panes do?
locks specific columns or rows in the spreadsheet so that they are always visible
OSS: What is wordpress?
logging platform
What is an indirect cost of TCO?
lost productivity
Not all open source products are contenders. Gallaugher suggests a key reason why some OSS products are
low-quality, don't improve over time, and are therefore should probably not be adopted for critical business processes.
Every single ____________ ____________ has been deeply and profoundly impacted by technology.
managerial discipline
1. authentication 2. provisioning 3. audits 4. data location
measures cloud users take to minimize risks
One in every five couples ________ _______.
meet online
4.2 Million people use __________ _________ to access social media sites.
mobile devices
Square allows you to use your __________ ___________ to accept credit card payments.
mobile phone
What types of digitized works can be copyrighted?
movies, videos, animations, etc.
multiple uses on same hardware
multi tenancy
What is an example of SSO?
my gator link
"The $1,000 PC is a ______."
myth
What is the term used to describe when as more and more people use a program it influences even more people to do so?
network effects
What is that cause identified by Dr. Gallauger?
network effects -- not enough people in developer and user community
use the work without changing it and in whole
no derivatives
nothing that brings commercial business or monetary gains
non commercial
What are examples of the cloud?
office 365, amazon, gmail, salesforce
Examples of SaaS?
office 365, google apps, salesforce
Who can use copyrighted works?
only the owner has the right
done by a shared group of people who collaborate together on the internet and share their work
open source
What is Linux an example of?
open source software
What provides a common set of controls for managing computer hardware?
operating system
Lending club is a type of _______ __ ________ loan.
peer to peer
Which of the following terms best describes a network where each computer has the ability to both share and use resources?
peer-to-peer
You manage a call center with 100 stations; each has a computer for data collection. Your call center is open 24 hours/day. You have a staff of nearly 400 employees who share those 100 stations (hot desking). Which of the following software site licensing methodologies would most likely be the most appropriate choice, offering the best deal for your firm?
per seat
work stations access the contract
per seat volume licensing
total, concurrent users
per user volume licensing
When you are licensed to use software forever within terms of agreement, but you do not own it?
perpetual
What is a pre-existing environment a piece of software is designed to run within, obeying its constraints, and making use of its facilities?
platform
What does PaaS stand for?
platform as a service
Mr. Olson listed two key causal factors in IT project failures. Type one of them into the space provided.
poor requirements specification
What is the phrase used to describe a cloud computing platform that is implemented within the corporate firewall, under the control of the IT department?
private cloud
One aspect of Open Source Software is that the customer has full access to the ________________ __________ _______ .
programming source code
What is the black box?
proprietary software
Which software model could not be added to or changed?
proprietary software
What should you use if you are afraid data may accidentally be wiped out of changed?
protected cells
The use of less server room space, the use of less air conditioning, purchase fewer OS licenses, or use less electricity. Which of these is not one of the cost savings you'd expect from virtualizing your company's servers?
purchase fewer OS licenses
What is a group of block of cells in a worksheet that have been selected or highlighted?
range
identifies the location of a cell or group of cells by the column letter and row number that intersect at the cell's location
relative cell reference
Global companies are increasingly turning to ___________ ___________; create first for emerging markets, then roll out to developed markets.
reverse innovation
How do you group data in a pivot table?
right click, group
1. vendor stability 2. security risks 3. consumerization
risks of cloud
What does attribution mean?
say who its by, who created the work
$272,000 is spend online every _________.
second
Copyright is permanently fixed to the original work in some form that can be __________ or ___________.
seen, heard
What is a collection of devices that process data?
server
What is the masking of server resources, including the number and identity of individual physical servers, processors, and operating systems, from server users?
server virtualization
What does SOA stand for?
service oriented architecture
change, build derivatives, but when you take your product you have to use the same licensing terms as mine, not more restrictive or less restrictive
share alike
The term _______ ______ refers to a phenomenon whereby asset owners can use digital clearinghouses to rent the unused capacity of assets they own. Examples include the following: RelayRides - a website where individuals offer their personal cars for rent. airbnb - a website that allows people to rent their apartments or homes to travelers
share economy
What does distributed computing do?
shares the workload between client and server
What does Ctrl + ` do in Excel?
show formula
What does a pivot table do?
shows data
When the software used to have to be unwrapped, it meant you were agreeing to the terms
shrink wrap
What does SSO stand for?
single sign on
Who benefits from democratization?
small businesses
What feature of virtualization systems allows you to get a "do-over" by returning a VM to its operating state at some time in the past?
snapshot
What can virally spread awareness of a firm with nary a dime of conventional ad spending?
social media
Gallaugher says that we are in a "golden age of tech entrepreneurship" that is being enabled by three key technologies, name them:
social media, the cloud, app stores
What does SaaS stand for?
software as a service
The acronym "EULA" refers to a ________ ________.
software license
Creative Commons uses the phrase _______ __________ ______________ to describe their approach to content licensing.
some rights reserved
With access to source code, the company can customize the software to meet their _________ _________ ________.
specific business needs
What is Lotus 1-2-3 comprised of?
spreadsheet graphics data management
cloud provider will use corporate logins for
sso (single sign on)
all rights reserved
standard copyright
Mr. Olson recommends users be assigned to the _________ _____ account type as a best practice. This should reduce support costs.
standard user
Volume is driven by _______.
standardization
Best choice for desktops?
standardized corporate devices
Suppose that you work for a skateboard manufacturer. You're searching the web for images that could be useful in your new catalog. You've found some great stuff but need to purchase them to use them...most likely you are dealing with ___________ _________.
stock photos
What is the cost of changing to a different product?
switching costs
Disk formatting, file manager, screen saver, firewall, popup blocker, etc. are all example of?
system utilities
What are small useful programs that help keep systems running smoothly?
system utilities
Windows 8 is an example of _________ ____________.
systems software
Would a tablet, desktop PC, or Notebook PC be the best choice for a BYOD program?
tablet
Who can use fair us?
teaching, news reporting, parody, critical comment
Moore's Law has been a major force in ______________, ___________, & __________ change.
technological, economic, social
Every company is a ______________ _________.
technology company
utilize the images for certain purposes and under certain terms
terms of licensing on "stock photos"
What allows a startup to be able to rent the computing resources one previously had to buy at a great expense?
the cloud
What does ####### mean?
the column is too narrow to display data
If software has zero marginal cost, what does that mean?
the cost to sell one more copy of a software program is pretty much zero
1. Moore's Law 2. Social Media 3. Mobile 4. Globalization
the four factors causing disruption
The development team will take one computer and configure it exactly the way they want it. Everytime a new desktop is set up in the cloud, it instantly receives that gold image
the gold image
OSS: What is Linux?
the most popular web server on the planet (70%)
Average( number1, [number2], . . . [number_n] )
the syntax for AVERAGE function
SUM(number1, [number2], [number3], [number4], . . .)
the syntax for sum of a range of cells
What does "public domain" mean to content users?
they don't need permission to use it
1. the cloud 2. app stores 3. social media
three key technology enablers that combine to create this "golden age of tech entrepreneurship"
One of the ergonomics principles we studied was the 20/20 Rule. What is this rule intended to prevent?
to prevent eyestrain
In China, Taobao.com boasts more than 800 million online items. They sell 800 items every second, more than China's _____ ________ ___________ ____________.
top five retailers combined
1. poor business analysis 2. poor requirements specification
typical causal factors of IT projects failing
1. employees provided an equipment purchase allowance , 2. employees responsible for maintaining their own IT
typical characteristics of a BYOD program
- Business requirements (primary) - TCO
typically drives corporate purchases of IT
What is federated authentication?
usernames and passwords
What are the terms of licensing on "stock photos?"
utilize the images for certain purposes and under certain terms
What is the management of changes to documents, computer programs, large web sites, and other collections of information?
version control system
What is the term used when one computer can run multiple work loads at the same time, actively doing the work of many computers?
virtualization
a way to take advantage of physical hardware resources that are underutilized
virtualization
it has multiple users
volume licensing
What is a software function provided at a network address over the web or the cloud?
web services
Your programmer is creating a new application that will automatically get data from several other application servers on your corporate network via machine-to-machine interactions. Which of the following terms best describes this scenario?
web services
Under what circumstances can someone else use copyrighted works?
with written permission or if it is US Federal Government works
Specific piece of content
File
Which industry is seeing less need to use ATMs or see tellers face to face due to mobile banking?
Financial services
Control programs stored on nonvolatile memory chips.
Firmware
Backup all data/images
Full backups
1. Geosynchronous orbit over customers 2. 22,000 miles above earth 3. Latency
GEO characteristics
Rules that govern networking communications
Protocol
What are the 4 key creative commons license terms?
1. Attribution, 2. No Derivatives, 3. Share Alike, 4. Non Commercial
What are examples of compiled programming language?
1. C# 2. C++ 3. Objective C 4. Java
Cable broadband characteristics
1. Coaxial cable (metal shield) 2. Bandwidth shared with neighbors
How are enterprise routers used to build an enterprise network?
1. Departmental LANS connect to enterprise core 2. Built using Ethernet switches 3. Nodes connect to switches
What are examples of interpreted programming language (scripting languages)?
1. Javascript 2. Microsoft: VB Script & Powershell
Two examples of total server failure
1. Key non-redundant component broken 2. Software crash
How are SOHO routers used in a SOHO network?
1. Local ports 2. Uplink port 3. USB port 4. Basic level firewall
What common 2.4 GHz devices interfere with WiFi networks?
1. Microwaves 2. Phones 3. Baby monitors
What are characteristics of ERP?
1. Modules-mix/match 2. huge code base 3. customization 4. integration 5. legacy
What are the four factors causing disruption?
1. Moore's Law 2. Social Media 3. Mobile 4. Globalization
Why have we run out of IPv4 addresses?
1. More users 2. More tech 3. IP addresses not allocated efficiently
What are the 3 tests often used to determine fair use?
1. Nature of work used 2. Amount used 3. Commercial impact on copyright owner
- Characteristics of routers
1. Specialized computer 2. Multiple network ports 3. Specialized software
What measures can cloud users take to minimize risks?
1. authentication 2. provisioning 3. audits 4. data location
characteristics of open source
1. competition 2. innovation 3. reduced cost of entry
What are characteristics of OSS?
1. cost 2. implications of access to source code 3. free distribution (licensing) 4. collaborative development 5. development model 6. distribution
What are benefits of PaaS?
1. don't buy hardware 2. don't build expensive datacenter 3. install your own software 4. 7x24 support for platform 5. scalable (probably) 6. operating expense
What are benefits of SaaS to the consumer?
1. don't buy hardware 2. don't install software 3. don't have to patch/upgrade 4. rapid deployment 5. scalability 6. operating expenses
typical characteristics of a BYOD program
1. employees provided an equipment purchase allowance , 2. employees responsible for maintaining their own IT
What are characteristics of virtualization
1. flexibility for consumers 2. environment impact
What factors of the cloud allow it to be more energy efficient and environmentally friendly?
1. greater energy efficiency 2. dynamic provisioning 3. multinenancy 4. higher server utilization 5. data center utilization
What are some examples of a client?
1. iPhone 2. android 3. tablet
Wireless signal range indoors
100 ft
"Fast Ethernet" and longtime desktop standard
100 mbps
What is the copyright duration for a company?
100 years
The truth of advertising is that only __________ of customers trust advertising.
14%
RAID 1 (Mirroring) characteristics
2 HDs Saved data on BOTH HDs simultaneously Fast Simple Expensive
What are typical causal factors of IT projects failing?
1. poor business analysis 2. poor requirements specification
How can the project success be maximized?
1. realistic goals 2. requirements specification 3. executive champion (leadership) 4. avoid "feature creep" 5. communicate 6. evaluate and address risk 7. pay attention to testing 8. real project management skills
What are characteristics of cloud computing
1. scalability 2. reduced costs
What are examples of external audits?
1. security 2. availability 3. processing integrity 4. confidentiality 5. privacy
What are three examples of federated authentication?
1. shibboleth 2. saml 3. oauth
What are the three key technology enablers that combine to create this "golden age of tech entrepreneurship?"
1. the cloud 2. app stores 3. social media
What are characteristics of CRM?
1. track interactions with customers 2. collaboration with sales team members 3. complexity 4. privacy 5. user buy-in 6. vendor stability
What are the "layers" in the layer cake?
1. user 2. applications 3. OS (Operating System) 4. hardware
What are the risks of cloud?
1. vendor stability 2. security risks 3. consumerization
High-end servers, infrastructure
10 gbps
Obsolete internet bandwidth
10 mbps
RAID 5 characteristics
3 or more HDs Saved data on all but one (error corrections) More scalable More complicated Less expensive "Parity"
1. Nature of work used 2. Amount used 3. Commercial impact on copyright owner
3 tests often used to determine fair use
TCO meets environmental responsibility... according to Gartner Research, we can reduce electricity costs by about ______ in a well-managed scenario.
35%
1. Attribution, 2. No Derivatives, 3. Share Alike, 4. Non Commercial
4 key creative commons license terms
Infrastructure
40 and 100 gbps
What percentage of utilization is CPU (central processing unit)?
5%
WHat percentage of spreadsheets used by large companies have material defects?
50%
Wireless signal range outdoors
500 ft
Based on early results, UF's PrintSmart managed print program is reducing its total cost of printing by roughly ______________.
60%
How many tons of CO2 emissions were eliminated in 2012?
600k
What % of IT projects fail?
68%
What percentage of IT projects fail?
68%
What is the copyright duration for an individual?
70 years
Us mobile ad spending to reach nearly __________ in 2013.
8 billion
Generally speaking, what portion of total IT cost occurs after the initial purchase? (based on Gartner research)
80%
What % of total IT costs occurs after initial purchase?
80%
54 mbps 5 GHz
802.11a
Your company has an ancient wireless network that is woefully inadequate for today's needs. One of the techs is suggesting 802.11ac WiFi. Based on your memory of ISM3004, select all of the pieces of advice you would offer to the boss about 802.11ac WiFi.
802.11ac is still a draft standard, so we should wait to adopt it
11 mbps 2.4 GHz
802.11b
54 mbps 2.4 GHz
802.11g
150 mbps 2.4 and 4 GHz
802.11n
There are a lot of 2.4GHz cordless phones in the your office suite, plus a microwave oven. You seem to remember that these devices can interfere with some WiFi networks. You head down to the local electronics superstore to buy wireless networking hardware. Given your concerns about interference, which of the following should you buy?
802.11n (increase wireless local area network speed, improve reliability and extend the range of wireless transmissions.)
433 mbps 5 GHz
802.ac
What percentage of all spreadsheets have errors?
88%
_________________ of customers trust peer recommendations
90%
Cloud is what percentage more efficient than servers at an enterprise?
95%
What does it mean that Fiber Optic cable is non-conducting?
Avoids electrical interference
OSS: What is Hadoop?
analyzes vast amounts of data
Your company has just bought a new facility near Sarasota, Florida. You want to setup an Ethernet network linking all three buildings on the property. Building A and Building B are only 50' apart Building C is about 2500' away from the other two buildings You've been told that lightning storms are common in the area. You expect additional construction on the site in the future - new buildings, trenches for utilities, etc. As a tech-savvy business manager, you have some thoughts about the type of network cabling you think should be installed on your new campus. Select all of the items below that you believe to be true in this scenarios. A)Connect buildings A and C using Fiber Optic cable B)Use 802.11ac to connect buildings A and B to building C C)Connect buildings A and B using Fiber Optic cable D)Connect buildings A and B using CAT6 cable E)Connect buildings B and C using Fiber Optic cable F)Connect buildings A and C using CAT6 cable G)Connect buildings B and C using CAT6 cable
A)Connect buildings A and C using Fiber Optic cable C)Connect buildings A and B using Fiber Optic cable E)Connect buildings B and C using Fiber Optic cable
Your company has adopted a "Locked, Well-Managed" PC management style. Which of the following statements are true for your company? A) our TCO (including Indirect Costs) is about 43% lower than the "Unmanaged" scenario B) end users can install their own applications and change computer settings C) our Direct Costs are about $3,500 per year per PC D) our Direct Costs are about $1,700 per year per PC (Select all possible answers)
A, D A) our TCO (including Indirect Costs) is about 43% lower than the "Unmanaged" scenario D) our Direct Costs are about $1,700 per year per PC
Give an example of how to right a range
A5:A9
Your company is considering the use of a Cloud application to address a mission-critical business needs. The Chief Privacy Officer (CPO) is very worried about the security of corporate data that is stored at the cloud provider. What external audit could the cloud vendor provide your CPO to hopefully address those security concerns?
AICPA SOC 2
What is a set of programming instructions and standards for accessing a Web-based software application or Web tool?
API
Include a radio antennae and Ethernet port
Access Point (AP)
Professionals in which of the following disciplines would most likely be concerned about complying with the Sarbanes-Oxley act?
Accounting
No downtime-gives a performance boost during normal operations
Active/active clustering
Some downtime-online one running at a time
Active/passive clustering
1. Advertising, 2. Education, 3. Journalism, 4. Retail, 5. Financial Services, 6. Share Economy
Advances in technology are causing disruptions in many areas of business, specifically these 6 areas:
Which industry sees 50% of FB revenue being mobile advertising?
Advertising
Standard copyright can be quickly described as ______ __________ ____________.
All rights reserved
In North America, __________'s e-commerce is more than Office Depot, Staples, and Dell combined.
Amazon's
Jeff Bezos founded?
Amazon.com
The world's most popular web server is open source. Which one of the following is that market-leading server application?
Apache
Steve Jobs founded?
Apple
Which of the following statements about Thin Clients are true? (there may be multiple correct responses) A)application licensing for thin clients can be a problem; read the license fine print B)thin clients typically have lower acquisition cost than thick clients C)thin clients typically have lower break-fix cost than thick clients, especially when you consider both direct and indirect costs D)before deploying a thin client to a user, IT deploys a gold image to the thin client's internal hard drive E)the cost of VDI licensing per thin client is trivial - just a few bucks per device
B)thin clients typically have lower acquisition cost than thick clients C)thin clients typically have lower break-fix cost than thick clients, especially when you consider both direct and indirect costs
Best choice for smartphones?
BYOD
Best choice for tablets?
BYOD
What led to consumerization of IT?
BYOD
Destruction of cables
Backhoe problem
Capacity of transmission media in fixed time
Bandwidth
Network transmission speeds; capacity of transmission media in fixed time
Bandwidth
_____ ______ founded Microsoft at the age of 19.
Bill Gates
The technology revolution leaders are:
Bill Gates, Michael Dell, Mark Zuckerberg, Steve Jobs, Larry Paige & Seirge Brinn, Jeff Baezos, Kevin Systrom
What does BYOD stand for?
Bring Your Own Device
By 2017, the _______ ____________ Officer will spend more on technology than the _______ ______________ Officer.
Chief Marketing, Chief Information
What does CISO stand for?
Chief information security officer
What does CPO stand for?
Chief privacy officer
-Microsoft -VoIP vendors
Cisco
What are examples of DaaS?
Citrix, amazon web services , dell
Asks server for information
Client
Client asks server for something-does not provide any information
Client-Server service model
Multiple servers sharing the same file storage
Clustering
Provides a place where the gear from multiple firms can come together where the peering of the Internet traffic can take place
Colocation facility
What does CRM stand for?
Customer Relations Management
Acquiring a domain name with the goal of exploiting it for financial gain
Cybersquatting
Converts host names into IP addresses
Domain Name System
Used to identify one or more IP addresses
Domain name
An organization or commercial entity that manages the reservation of Internet domain names
Domain registrar
What types of remote technologies enable telecommuters to be productive?
E-mail Remote desktop Instant messaging VTC Web conferencing
What is an enterprise system that integrates a set of business functions like finance, HR, purchasing, and operational aspects, such as manufacturing or distribution, through tight linkages from operational business transactions to financial records?
ERP
A manager wants to get a report that integrates data from multiple business functions: HR, finance, purchasing, manufacturing, and others, you recommend he get ___________.
ERP (Enterprise resource planning)
the main worries are who gets to use the software and for how long
EULA
Which industry is dealing with online education at a cheaper price?
Education
Who benefits from telecommuting
Employee and employers
What does EULA stand for?
End User License Agreement
How do you move to the next row?
Enter
What does ERP stand for?
Enterprise Resource Planning
1. No amateurs 2. Test results 3. Labeling/documentation 4. Quality parts throughout
Ethernet installation recommnedations
Where is WPA2 used?
Everywhere
1. Cable not installed in homes 2. Expensive to install
FTTH characteritics
Mark Zuckerberg founded?
More than 50% of _____________ revenue will be mobile ads in 2013.
One in five divorces are blamed on ____________.
What social media site is an example of network effects?
___________ gets nearly 75 million daily visits from mobile.
1 Billion people make it the 3rd largest nation after China & India.
Facebook Nation
_______ ______ is a limitation on copyright that is intended to facilitate teaching, news reporting, etc.
Fair use
Bugs happen in both Operating Systems and Applications software. Fortunately, end users can be trusted to patch their own systems, so corporate IT departments don't need to worry about that task. True or False?
False
Microsoft dominates the market for server operating systems. Nearly 80% of servers are running Window Server. True or False?
False
Most open source development is done by loners tooling away for the glory of contributing to better code. True or False
False
One of the drawbacks of open source software is that it cannot be easily migrated to more powerful computers as circumstances dictate. True or False?
False
Is WEP secure?
No
Would computer repairers benefit from telecommuting?
No
Any device connected to a network
Node
- How well does a WAN address remote office or mobile user cases?
Not well enough
What organization aims to provide each child with a rugged connected laptop to children?
OLPC
One organization is using open source software as a key part of their strategy to build ultra cheap ($199 each) fully functional laptops to be given to children around the globe -- a perfect example of the democratizing aspect of OSS. Which organization is that?
OLPC (One Laptop per Child)
What does OLPC stand for?
One Laptop Per Child
____________ _____________ and ______________ are the two major disruptions in the eduction sector.
Online education, MOOCs
What does OSS stand for?
Open Source Software
___________ _________ ___________brings new competition and innovation to the software industry.
Open source software
Michael Dell founded?
PCs limited
What formula calculates correct monthly payments using interest rate and number of periods?
PMT()
Pan, tilt, zoom cameras used in VTC
PTZ
Mike's Music wants to build a custom solution to manage their stores. They don't have a datacenter, so they want to put their custom solution in the cloud. What cloud based solution would best fit their situation?
PaaS (Platform as a service)
utility computing
Paas
Chunks of data
Packet
Suppose that you're downloading a large file. The server that is sending the file to you will break the file into smaller pieces called __________, which will then be transmitted across the network.
Packets
What does PEMDAS stand for?
Parentheses Exponents Multiplication Division Addition Subtraction
Folder in a file system
Path
Everyone is a client and a server
Peer-to-Peer service model
When separate ISPs link their networks to swap traffic on the Internet
Peering
"The digital world is upon us" was said by _______ _____________ of ___________.
Peter Sondergaard, Gartner
You're going to install a couple of network cameras in your office building to provide security. It's too expensive to put 110 volt outlets by each camera, so you want to use the Ethernet cable to provide the electricity needed by the netcams. Which of the following technologies will solve that problem?
PoE ( Power over Ethernet)
Allows power to be conducted through unused Ethernet cords (i.e. phones)
Power over Ethernet (PoE)
Non-internet facing IP address on an internal network
Private IP
_________ __________ refer to pools of computing resources that reside inside an organization and that can be served up for specific tasks as need arrives.
Private clouds
1. Reliability 2. No backups 3. Scalability
Problems with Peer-to-Peer model
Rules for use of networks
Protocol
Your friend Jill is the network manager for a large company. Her team is deploying a secure wireless network for the company right now. One of the salesmen - Bob - is apparently impatient, though. Rather than waiting, he brought his own personally-owned WiFi gear into the office and setup his own network. Jill is pretty unhappy about this because it could compromise corporate data security. What term does she use to describe Bob's gear?
Rogue AP
APs purchased by end users instead of the corporation
Rogue APs
Connects networks and exchanges data between them
Routers
How are enterprise routers different from SOHO routers?
Routers form network core-very fast connections
PC Instrumentation is one aspect of effective desktop management. Which of the following terms refers to a hard drive technology that helps administrators identify sick hard drives before they fail?
S.M.A.R.T.
What is an enterprise system where the active management of supply chain activities are maximizing customer value and achieving a sustainable competitive advantage?
SCM
The product manager needs to track the flow of raw materials from suppliers into her production lines, as well as the flow of finished goods out to the distribution channel. You recommend a ____________.
SCM (Supply chain management)
a part of a service contract where a service is formally defined.
SLA (service level agreement)
What is a software design and software architecture design pattern based on discrete pieces of software providing application functionality as services to other applications?
SOA
A robust set of Web services created around an organization's processes and procedures.
SOA (service-oriented architecture)
1. Local ports 2. Uplink port 3. USB port 4. Basic level firewall
SOHO routers used in a SOHO network
enterprise cloud computing
SaaS
Bob's Biscuits wants to use a cloud-based CRM application to track their customers. BB is a small company and doesn't have any programmers; they can't build their own solution. What cloud based solution would best fit their situation?
SaaS (Software as a Service)
Which of the following is an example of Enterprise Application Software?
Salesforce
What act raises executive and board responsibility and ties criminal penalties to certain accounting and financial violations?
Sarbanes-Oxley Act (Sarbox or SOX)
Provides client with information
Server
Provides service to other nodes
Server
Key defining factor that makes a computer a server
Server software
What does SLA stand for?
Service Level Agreement
To determine locations for AP; prevents pockets of unconnected areas
Site survey
_________ _______ generates nearly twice the leads as trade shows, telemarketing, or mail.
Social media
Clustering Network load balancing Virtualization
Solution to Total Server Failure
__________ ______ is the founder of Apple.
Steve Jobs
What does SCM stand for?
Supply Chain Management
Interconnects nodes and allows for unicasts
Switch
total cost of using and maintaining an IT investment over time
TCO
"There's much more to the cost of software than just the purchase price." What is the acronym primarily associated with this?
TCO (Total cost of ownership)
Works at both ends of most Internet communication to ensure a perfect copt of a message is sent
TCP
How do you move to the right?
Tab
Work from home via telecommunications
Telecommuting
VTC on steroids; large HD screens; voice and video
Telepresence
Cisco Polycom
Telepresence vendors
What does technology have to do with human resources?
Thanks to technology, the firm that can't keep employees happy, engaged, and feeling valued has never been more vulnerable.
Its elements are: Linux, Apache, & MySql
The LAMP stack
What does technology have to do with marketing?
The ability to track customers, analyze campaign results, and modify tactics has amped up the return on investment of marketing dollars, with firms increasingly shifting spending from tough-to track media such as print, radio, and television to the Web
What does technology have to do with finance?
The aspiring banker who doesn't understand the role of technology in firms and industries can't possibly provide and accurate guess at how much a company is worth
What does technology have to do with accounting?
The numbers used by accountants are all recorded, stored, and reported by information systems, and the reliability of any audit is inherently tied to the reliability of the underlying technology
identifies the location a cell or group of cells by the column letter and row number surrounded by dollar signs $
absolute cell reference
OSS: What is open office?
alternative to Microsoft office
What are examples of PaaS?
amazon web services, windows azure
What is AICPA SOC 2?
an audit
What is meant by "look behind the curtain" when discussing cloud solutions?
an offshore company may be doing all the work, even if you don't know about it
When cells have been selected they are surrounded by what?
an outline or border
What is fair use?
can be used if beneficial to society and only if it does not damage the commercial value of copyrighted material
How do you create a pivot table?
cell, data, create pivot table
- Allowance (given to employee to select own device) - Employee responsibility
characteristics of BYOD
1. track interactions with customers 2. collaboration with sales team members 3. complexity 4. privacy 5. user buy-in 6. vendor stability
characteristics of CRM
1. Modules-mix/match 2. huge code base 3. customization 4. integration 5. legacy
characteristics of ERP
1. cost 2. implications of access to source code 3. free distribution (licensing) 4. collaborative development 5. development model 6. distribution
characteristics of OSS
1. scalability 2. reduced costs
characteristics of cloud computing
expensive buildings/rooms lots of computers, storage devices, ac, power...
characteristics of enterprise data centers
1. competition 2. innovation 3. reduced cost of entry
characteristics of open source
1. flexibility for consumers 2. environment impact
characteristics of virtualization
When you click "accept" on the software, it means you are agreeing to the terms
click wrap
What is a device that accepts information from you and communicates that information to the server?
client
The ___________brings incredible scalability on demand - only pay for what you need
cloud
the idea of opacity, not being able to see inside
cloud
What is the idea that you don't have to have your own expensive data storage system when you can use someone else's out there in the internet?
cloud computing
What is the term for when you run out of your computing resources in your internal data center, you "burst" the additional workload to an external cloud on an on-demand basis?
cloudbursting
Your network manager worries a lot. They all do. His concern today is that a nonredundant component may fail, causing one of the servers to fail. Which of the following technologies would best address that concern?
clustering
1. Microwaves 2. Phones 3. Baby monitors
common 2.4 GHz devices interfere with WiFi
