ISMexam2
Blogs are ____% more likely to influence purchase decisions than magazines. Note: Enter your response as an integer between 0 and 100. Thus, if you think the answer is 50%, please enter 50. Responses within 10 percent of the correct value will earn full credit.
0
List two things that Warrington College of Business social media manager Ginny Lawrimore said you should not do on social media.
1. Post illegal activities 2. Bullying 3. Trash talking online 4. Talk negatively about your professors/school/college 5. Post confidential information 6. Overly specific checkins 7. Lie/cheat/plagiarize 8. Unprofessional public profiles 9. Post embarrassing photos 10. Rely on privacy settings 100% 11. Post emotionally
While 91% of adults use social media regularly, only ___% of businesses have a dedicated social media manager
22%
As of early 2015, Twitter had roughly ________________ monthly active users.
288 million
Which of the following is the fastest growing demographic among social media users?
45-54 years
Your administrative assistant has created the following formula in an Excel spreadsheet: =A1-B1/2 Suppose that A1 and B1 each contain the value 10. What will be the numeric result of Excel calculating this formula?
5
47% of social media users are actively seeking customer service through social media. What percentage say that they will recommend a brand when they get positive customer service through social media?
71%
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.11ac
Based on recently published reports, which of the following statements are correct?
88% of all spreadsheets have errors in them 50% of spreadsheets used by large companies have "material defects"
You're thinking about borrowing $25,000 for your business. It will be a 5 year loan. The bank's annual interest rate is in cell A2. The basic syntax for the Excel loan payment function is: =PMT(rate,periods,amountborrowed) Which of the following formulae will give you the correct monthly payment?
=PMT(A2/12,60,25000)
Your company has offices scattered around the US, with numerous administrative staff in each location. You're deploying a wiki where those administrative staff can collaboratively create helpful documents about processes, procedures, and best practices. Your corporate wiki is secure. Only people within the company will be able to access it. Based on what you've learned in ISM3004, briefly explain one risk facing this effort. (max 2 sentences. not a security risk)
A risk facing wiki is that too many errors are made using this social media tool. Anyone can post information on a wide range of topics without verification of facts which allows errors to occur.
Which of the following is a valid cell range in Excel?
A3:B45
You need to use a complicated Excel function that has several arguments. You remember that Excel can display a very helpful "Function Arguments dialog box." The box explains the function and its arguments in detail! What keystroke combination is used to display it?
CTRL A
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.
Connect buildings B and C using Fiber Optic cable Correct! Connect buildings A and B using Fiber Optic cable Correct! Connect buildings A and C using Fiber Optic cable
The cellular phone reception inside your corporate office building is terrible! The senior executives are not happy about this. Which of the following could best help solve this problem?
DAS
What technology is used to convert hostnames like www.espn.com into IP addresses like 199.181.132.250 ?
DNS
What will happen if you double-click on the boundary between two column letters, such as columns A and B in the image below?
Excel will automatically adjust the width of column A so that the longest data in column A will perfectly fit.
Which of the following broadband technologies required the installation of new cabling to subscribers' homes?
FTTH
Mr. Olson strongly advised students to continue using the legacy XLS file format for compatibility with older versions of Excel.
False
American adults collectively spend 200 billion hours per year watching television. Rather than passively watching the Tube, an increasing number of people are choosing to use Web 2.0 and Social Media to leverage their cognitive surplus to create something of value for society. List one example of this, as presented in ISM3004.
GalaxyZoo Galaxy Zoo Ushahidi Wikipedia Citizen Science
Select the Ethernet bandwidth that best fits all of the criteria below: today's desktop standard viable for use with basic servers (not high-end servers)
Gig-E
Your spreadsheet contains a great big table that runs from column A-T and rows 1-5000. Your cursor is currently on cell C1 and you want to get to T5000 as quickly as possible, so you press ________________ and the cursor jumps to T5000 instantly. Note: Mac users -- substitute "COMMAND" for "CTRL" in the answers below
Hold down the CTRL key while pressing the END key
Suppose that you are working in an Excel file that has numerous worksheets. You're currently viewing the top worksheet and want to go down to the next sheet. Which of the following keyboard shotcuts can be used to jump down a worksheet without having to touch the mouse? Note: Mac users -- substitute "COMMAND" for "CTRL" in the answers below
Hold down the CTRL key while pressing the PAGE DOWN key
UF is one of the few universities in the nation who is joining this organization's Innovation Platform, which will connect us to other top research universities at 100gbps.
Internet2
Some people mistakenly believe that Twitter and microblogging are commercially useless. Dr. Gallaugher provides quite a few interesting commercial examples of effective Twitter in this week's text readings. Briefly describe one of those examples. Ideal responses will be 2-3 sentences, name the company, and explain how it uses Twitter.
Intuit monitors tweets mentioning competitor Mint.com, sending invites encouraging users to check out the firm's competing Quicken Online offering.
Network covering a limited geographical area, such as a single building
LAN
This application contained a powerful combination of spreadsheet, graphics and data management. It was so popular that CFO Magazine called it the "killer app that ignited the personal computer revolution."
Lotus 1-2-3
Uniquely identifies a node from every other one on the planet; however provides no information about its location
MAC address
This type of Internet service makes use of a fleet of satellites located about 5,000 miles above the surface of the Earth. Advantage: acceptably low latency Disadvantage: requires multiple satellites because the satellite doesn't remain stationary over a single point on the Earth's surface
MEO
Your ISP wants to implement new policies that will favor certain customers and types of data. For example, when they detect a customer using BitTorrent, they want to immediately reduce his/her bandwidth by 75%. What principle would this violate?
Net Neutrality
Collection of devices connected together via communications devices and transmission media
Network
Briefly explain the impact network effects have on social networks. (2-3 sentences should be sufficient)
Network effects impact social media by how many users it has. The more the network effects advance with social media, the higher the impact they have on social media.
Suppose that you have a spreadsheet titled SalesData2013.xlsx There is a particular cell in that spreadsheet that shows the total sales for your Micanopy store -- that result is the result of a complex formula in the cell. You want to copy the result of that calculation (total sales) into a cell in a different spreadsheet called MicanopySalesHistory.xlsx Which of the following Excel capabilities will best meet your need?
Paste Special: Values
Effective social media use can help businesses make money! As one example, home furnishings provider One Kings Lane successfully used social media service __________________ to drive buyers to their website. The program has been a great success. Users referred to One Kings Lane's site by that social media service are three times more likely to buy something than other visitors.
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
List one specific way that a private social network is different from a public social network like LinkedIn.
Private social networks allow access to be restricted to insiders only.
________ 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
This is a system by which users can aggregate new content from many different sources into a "list of headlines" and then click on interesting titles to "drill down" and view those that are interesting.
RSS
Warrington College of Business social media manager Ginny Lawrimore described three Twitter fails. Choose one of them. Name the company. Briefly explain what went wrong (1 sentence) Briefly explain how they addressed the failure (1 sentence)
Red Cross - in 2012,employee posted about Dogfish Head beer, thinking it was his personal Twitter acct; Red Cross immediately posted a cute response to Twitter that defused the situation. BTW, Dogfish Head did a charity event together with Red Cross, partially because of Red Cross's classy funny response. KitchenAid - employee accidentally used work account instead of personal account to make insensitive post about Obama's grandmother's death; Kitchenaid posted formal apology using same hashtags to be sure that everyone who saw original tweet also saw the official apology.
Which of the following is not one of the 3 R's of Social Media Policy?
Responsiveness
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 Access Point
IBM Listening for Leads is an excellent example of ______________.
SMART
Janine is entering sales data for ten consecutive years into her company spreadsheet. The data will go into columns A through J, rows 2-11. You advise her to enter the data by row, pressing the ______ key to move from cell to cell across the row, then pressing the ______ key to automatically move to the start of the next row.
TAB, ENTER
You work at an Internet startup that has a revolutionary idea for doing payments over the Internet. Since the application will be moving money around the Internet, they're obviously concerned about data packets arriving 100% of the time, guaranteed! (Don't want to lose your customers' money after all). Which of the following protocols would make the most sense for them to use, given that requirement?
TCP
Each cell in an Excel worksheet has an address, which is defined by a column letter followed by a row number.
True
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
Edith is creating a spreadsheet that will contain inventory information for her small shop. The inventory will be contained in a large table with columns for item number, description and price. She wants the spreadsheet to have a page that she can use to create invoices. She'd type in the item number and the quantity a customer plans to purchase, then wants Excel to find and display the product description and price. She knows you're an Excel wizard, so she called to ask you what Excel function she should use to accomplish that goal. Which of the following will you answer?
VLOOKUP
video and voice
VTC
voice only
VoIP
You're concerned about cybercriminals getting onto your wireless LAN. Which of the following will provide the best protection?
WPA2
The term "brochureware" is most closely associated with _____________.
Web 1.0
Your company wants to implement an internal Web 2.0 service that will allow employees to collaboratively create documents using a simple, WYSIWYG interface. Any updates to a document must be attributed and the system must also let us revert to an earlier version of a document (in case there's an error). Which of the following Web 2.0 tools would best fit that need?
Wiki
Which of the following is an extremely popular blogging system?
WordPress
The world's most popular web server is open source. Which one of the following is that market-leading server application?
apache
One of your company's sales managers has created a bunch of fake social media accounts. He then used the fake accounts to write bogus posts praising the quality of your products and customer service. If the public finds out, there could be big problems! What term is used to describe the sales manager's actions?
astroturfing
Your company's CEO would like to create a channel through which senior leaders can communicate the company's strategy to customers. The issues can be complex, so typical messages are likely to be 4-6 paragraphs. The technology should allow executives to immediately publish information to the Web, without having to seek help from technology experts. The CEO would also like for customers to be able to respond to the information provided by the executives. Which of the following social media tools would best meet the CEO's needs?
blog
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
George is creating a spreadsheet that will display the status of all his customer accounts. He will update the data weekly. He wants the spreadsheet to automatically highlight the cells of his best and worst customers, based on the contents of the spreadsheet. Although George doesn't know much about Excel, he does know your cell phone number, so he calls and asks you if this is possible. You think back to ISM3004 and dazzle George once again with your Excel knowledge, telling him that the Excel feature called ____________ is exactly what he needs.
conditional formatting
Consider for a moment the following URL: https://www.crazyericsfireworks.com/products/rockets.html Which of the following statements is true?
crazyericsfireworks is the domain name
TopCoder and the NetFlix Prize are examples of _______________.
crowdsourcing
Iintentionally registering a domain name to profit from someone else's firm name or trademark
cybersquatting
A happy customer just Tweeted about your company. Excellent! This is an example of __________________________.
earned media
You're working with a really large spreadsheet: 5000 rows and 30 columns. Needless to say, it doesn't fit on your screen in either dimension. You frequently need to see data deep down into the sheet along with its corresponding row headings and column headings. Fortunately, Excel has a feature that allows you to always see row & column headings, no matter where you are working in the data. What is the name of that feature?
freeze panes
You are researching social media monitoring tools for your company. Several products had a feature that you really liked: they can display posts about your company visually on a map, showing you where people are talking about your company right now. Brighter spots on the map show higher concentrations of activity (discussion). What is the name for that social media monitoring feature?
heat maps
The core of the Internet is incredibly fast. By contrast, many users have unacceptably slow links to the Internet. What term is used for this problem?
last mile
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
Which of the following terms best describes a network where each computer has the ability to both share and use resources?
peer-to-peer
Separate ISPs linking their networks to swap Internet traffic
peering
Tony is a pro baseball recruiter. He has a spreadsheet that contains information about every time that the leading college players were at bat; it's thousands of rows long! Tony wants to quickly find out how many times each player was at bat and how many times they had a base hit. Which of the following Excel features should Tony use find the answer to his question?
pivot table
You've heard a rumor that your CIO is investigating IBM Connections. What type of Web 2.0 system is she considering?
private social network
Rules that govern networking communications
protocol
A specialized computer with multiple network ports and specialized software that is used to interconnect networks.
router
immersive audio/video experience using multiple large-screens and HD video - "feels like you're there"
telepresence
One of your coworkers emails you a spreadsheet. When you open the sheet, you discover that a cell is displaying ###########. What's going on here?
the column is too narrow to display the data as formatted
In Excel, dates are stored as "date serials." The date serial for a date is ______________.
the number of days since January 1, 1900
___________________________ expresses the idea that a group of comprised mostly of untrained amateurs collectively has more insight than a single or small group of trained professionals. (select the term that best matches this idea)
the wisdom of crowds
Why were private IP and NAT developed?
to address IPv4 address exhaustion
One of your coworkers has created a complex spreadsheet that's producing some really questionable results. You decide to use your awesome Excel formula auditing skills to help find the problem. The computation result displayed in cell J23 is particularly weird! What Excel formula auditing function would you use to show how data flowed into the formula in J23?
trace precedents
A diagnostic tool used to observe the passage a packet takes as it travels across the Internet
traceroute
This blog feature allows an author to acknowledge the source of an item in their post, which allows bloggers to follow the popularity of their posts among other bloggers.
trackback
_________________ is the single greatest cause of lost data.
user error
Your company has a main office in Florida, plus satellite offices in Georgia and Alabama. You also have a highly mobile group of salespeople that are constantly travelling to visit clients across the US. The IT group is building a traditional WAN using dedicated data circuits. Select all of the following statements that are true.
we will be able to securely send data from the main office to the Georgia office
supports voice and video, but PC data sharing is the star!
web conferencing
You're thinking about buying a small building for your company. You've just learned that the building has CAT3 network cabling. Your employees work with extremely large datafiles and definitely need high-speed Ethernet to be productive! Based on best practices recommended in ISM3004, will you need to replace the network cabling?
yes
The Internet is a very public space. What happens on the Internet, stays on the Internet for all to see... permanently. Too many careers and companies have been damaged by foolhardy social media posts. To help you avoid blundering while posting, Warrington social media manager Ginny Lawrimore suggested that you always imagine that two people read everything you post. Enter one of them into the box below.
your boss your grandmother boss grandmother
While it is possible to delete a Tweet, problems will still remain even after the bad Tweet is deleted. Warrington College of Business social media manager Ginny Lawrimore explained three problems. Briefly explain one of them. (2 sentences max)
• Does not erase tweet in the minds of followers who already saw it • Does not remove from client software • Does not prevent screenshots