ISM3004 Exam 2

Average 21-year-old has spent about ___________ hours on a mobile phone

Approximately 10,000 hours

Roughly ___% of US Facebook users are aged 45+

Around 30%

Do more Americans access Internet using phone or computer?

phone

______% of the time that Americans spend on their smartphones is spent using apps

90%

85% of that time is spent on just ____ non-native apps installed from an app store

5

Passive approach to self-branding

Making sure nothing in social media hurts you; being smart

Questions to ask yourself about your social media presence

Would my social media presence hurt my career opportunities?

Active approach to self-branding

Making sure social media helps you

Three questions to consider when creating an active self-branding campaign

Who is your audience?

Why should we hire/interview you?

What do yo want them to see?

Activities that make up the Development component

- Research: Hootsuite, Peer Facebook page research, Industry research

- Strategy: big picture, campaign, plans

- Management: talking with people, project meetings, interns

Activities that make up the Execution component

- Communications campaigns: broad campaigns that cover more communication than sm

- Social media campaigns

- The daily grind

- Event coverage

Why having a social media policy is important for an organization

- Sets stage and defines area users can play in

- Protects org in event of legal trouble

Who should review social media policy before implementing it?

HR department and lawyer

What can be learned from looking at peers' social media activities

General and specific things they're talking about

Benchmarking

Identify peers and sm channels

What you are comparing against

How big of following for you vs. peers?

How does weekly engagement compare?

Questions that can be answered using audience research

What are your audiences interested in?

What types of content are similar audiences interested in?

Tools/tips Laura suggested for monitoring/researching your audience

- Monitor specific hashtags on Twitter and Instagram

- Add followers to Twitter lists

- Follow your audiences' influencers

- See what's trending

Game plan

Research

Goals

Strategy

Execution steps

Evaluation

Importance of orgs having both goals and strategy for social media

Know how you will support core mission

Know what you need to accomplish

Know how you will accomplish it

Prove that you accomplished it

Goals vs. strategy

Objectives vs. plan

Which comes first: goal or strategy?

Strategy

Old Guard

Facebook, Twitter, LinkedIn, YouTube, Tumblr

Meaning of 'it's never about the tools' and what's really important

Need to know strategy before choosing a tool

Whether organizations should abandon old guard tools for newer platforms

Not yet, but don't ignore newcomers

Two key questions for selecting social media platforms

Is audience using platform?

Will audience engage with me on platform?

How Facebook's social media algorithm determines post visibility

Ordered content for people; relevancy score (who posted, when, interaction, type)

Meaning of 'engagement feeds reach'

The more people who engage, the more people will see

Three tips for maximizing audience engagement with content

Relevance, authenticity, and impressiveness

How social media advertising helps organizations reach goals

- Social media goals (serve to larger audience, gain new followers)

- Business goals (click to website)

Key takeaways from REI's campaign

- REI paid workers on Black Friday to go outside

- Be authentic, relevant, put money where mouth is, be bigger than sm

Reasons for companies to listen to the buzz on public social networks

It can create positive impacts - like Morton's Steakhouse

S.M.A.R.T.

Social Media Awareness and Response Team

Three R's of social media policy

Representation, Responsibility, and Respect

Risks posed by unaware users and how S.M.A.R.T. can help fix that

Personal use

Untrained

Bad habits

Communicate risks, opportunities, and policies

2 components of 'Response'

Monitoring and engagement

How much a 'like' is worth

Not much

Discoveries by Lutz and Halloran that were impacting consumer value

Like is least likely to cause future store visit - decreased customer value

Positive comments had most value at $41

Loves were second highest at $29

Negative comments have $3 unless they are swayed

Quantify relationships with customer lifetime value

Paste Specials

- Value: pastes value instead of formula

- Cell formatting

- Formula

- Math

- Transpose

CTRL keystroke that displays function argument help dialog

CTRL A

PMT function

- Use total # of payments for n

- Divide by 12 for monthly payments

VLOOKUP parameters

- Value to find

- Lookup table

- Search leftmost column

- Column offset number

- Lookup type

For default IFS, catch-all test, use...

TRUE

how to lock down ($) cell values

F4

approximate VLOOKUP

leave last parameter blank

XLOOKUP parameters

- Value to find

- Lookup array (only column with data you're looking up)

- Return array (can be multiple columns)

- Not found error msg

- Match mode

FIND vs. SEARCH

find is case sensitive, search is not

CONCATENATE

- Join one+ text strings into on text string

=CONCATENATE(text1, [text2])

conditional vs. normal formatting

conditional formatting is more flexible and automatically applied to individual cells or entire rows

Importance of spreadsheets and Lotus 1-2-3 to personal computer revolution

Huge competitive advantage to those who have it; game changer

Cell address

Combo of column letter and row #

Range

Rectangular group of cells that is uninterrupted

Shortcut: finding text

Ctrl/command up, down, left, and right

Shortcut: moving up and down a sheet

Ctrl/command PgUp & Pg Down

Shortcut: editing a cell

Windows: F2

Mac: Ctrl-U

Shortcut: select all

Ctrl/Command-A

Shortcut: bold, italics, underline

Ctrl/command b, i, u

Freeze panes

Put cursor below heading and row, then freeze panes

How to make a number text

Type ' before #

Shortcut: forcing new line

Windows: Alt+Enter

Mac: Ctrl-Command-Enter

Every date has a...

Assigned #

Indenting within cells

Highlight cells, click indent button by centering options

Setting cell borders

Right click, format cells, border

Multi-level sorting

Select range, data, sort, add level

Removing dupes

Select range, data, remove duplicates

Data validation configuration: requiring selection from list of values

Have list of options: data → data validation

Data validation configuration: providing input tip and error message

Data validation → input message → custom error message

% of spreadsheets with errors

88

% of material defects in spreadsheets used by large companies

50

F1F9 says main cause of spreadsheet errors is...

Lack of industry-wide standards in financial modeling

Error costing Fidelity Magellan Fund $2.45B

Omission of minus sign

Sanity check

Does output of formula make sense?

Factors that drive personal purchases of IT

Style & whim: If it feels good, flavor of the day, lowest purchase price, hot rod syndrome

Factors that drive corporate purchases of IT

Business requirements, many systems, control costs

User types

Data entry, task-oriented workers, knowledge workers, power users

How standardizing purchasing agreements reduce IT acquisition costs

Hardware and software standardization, volume discounts, support, maintenance, training

BYOD

Bring your own device

BYOD program characteristics

Employee chooses own device with allowance and is responsible for it

BYOD benefits

Shared cost, employee satisfaction

Consumerization of IT

Mobile devices: faster, smaller, lighter, volume drives down price

What led to consumerization of IT

People wanting to use their own devices because it helped them be more productive

How corporate IT is impacted by consumerization of IT

Make it easier to work with flexibility

TCO

Total cost of ownership

Direct cost

Show up on budget as IT costs (ex: software)

Indirect cost

Show up on budget not as an IT cost (ex: salary)

Unmanaged PC management style

Do it yourself, install own software

Managed PC management style

Professional staff use best practices to consistently and automatically manage PCs

Most expensive item of owning a PC

Software

PC item that brings biggest savings if locked and managed well

Hardware & software support

Well-managed scenario: TCO direct costs only

$1723

Well-managed scenario: TCO direct and indirect costs

$3309

Unmanaged scenario: TCO direct costs only

$2037

Unmanaged scenario: TCO direct and indirect costs

$6479

% savings for well-managed scenario: TCO direct costs only

15

% savings for well-managed scenario: TCO direct and indirect costs

49

$1000 PC is a ___

myth

Image

OS + Application + Settings

Gold image

Build once, test and tweak, deploy repeatedly automatically

How images are used

Take gold image to repeat for all other users

How images impact TCO

Huge savings for direct and indirect costs