Research Skills for Business (RSB) Flashcards

1
Q

An ability to locate, evaluate, analyze, and report information and data on a given topic

A

Research Skills

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Removes conditional formatting from only the selected data or from the entire worksheet

A

Clear Rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Used to format cells that meet a certain criterion.

A

Conditional formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Appears next to each table heading and opens the drop down where you can choose how to sort or filter your data

A

filter button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Shows the sum or average of all records in the outline

A

Grand Total

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Allows to create custom conditional formatting rule that meets the specific needs

A

New Rule

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Horizontal look up, an excel function to look up and retrieve data from a specific row in a table

A

HLOOKUP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Allows to edit and reorder existing rules in the worksheet

A

Manage Rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Chart or graph that shows info from the Pivot table

A

Pivot Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Summarizes data from a more extensive table and may include sums, averages, and other statistics chosen by the user

A

Pivot table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A data filter with convenient buttons that filters pivot table data

A

Slicer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Shows the sum or average of all data belonging to their own outline level

A

Subtotal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Vertical look up, an Excel function to look up and retrieve data from a specific column in a table

A

VLOOKUP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

7 basic steps of any research project

A

1) identify research goal
2) identify research goal
3) What research tools can and should you use
4) Search for info
5) Evaluate sources and info
6) Create your research document
7) Proofread

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

4 basic categories of electronic research tools used for locating data and info (already existing):

A

1) Search Engine
2) Electronic Database
3) Electronic Journal
4) Electronic Book (E-Book)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Search system designed to search the World Wide Web in a systematic way

A

Search Engine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Software great for locating general info and deep info search
- keywords
- ex: Google

A

Search Engine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Software is great for SPECIALIZED research
- ex: GoogleScholar
- scientific/reliable evidence

A

Electronic Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Software used on a regular basis to keep up with industry trend and news

A

E-journals

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Software provides an in-depth coverage of the topic
- typically business related topics

A

E-books

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many quintillions of bytes are created every day?

A

2.5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

FUNCTION:

AND

A

Returns only results containing BOTH terms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

FUNCTION:

OR

A

Returns results containing EITHER term. Often used with synonoyms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

FUNCTION:

NOT

A

Returns results containing the first term but EXCLUDES any results that also contain the second term

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

FUNCTION:

/s

A

Returns results with both terms in the same SENTENCE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

FUNCTION:

/p

A

Returns results with both terms in the same PARAGRAPH

18
Q

FUNCTION:

” “

A

Returns only results that contain the entire phrase found within the quotes

19
Q

FUNCTIONS:

!

A

Root expander; will return results containing any variation of a root word

20
Q

FUNCTION:

*

A

Universal character; the computer will treat * as ALL LETTERS. Useful if looking at alternate spellings, e.g.
- defen*e
if looking at both English and American English (defence vs defense)

21
Q

Fraud
when you find info online and include it in a study WITHOUT giving proper CREDIT

A

Plagarism

22
Q

Fraud -
When you take info WITHOUT PERMISSION

A

Copyright Infringement

23
Q

Two most common violations committed by people when conducting research and creating business documents

A

1) Copyright infringement
2) Plagarism

24
Q

What are intellectual Property Rights?

A

They make provisions for a person/company to have EXCLUSIVE rights to use their OWN
- plans
- ideas
- tangible assets

25
Q

What is Copyright?

A

A legal right that allows someone to protect their original work and allow who else uses it

26
Q

When does Copyright expire?

A

70 years after the author’s death

27
Q

What are some penalties for copyright infringement?

A
  • 250,000 fine
  • five years in prison
28
Q

What is the U.S. Copyright Office?

A

The official US gov’t body that maintains copyright registration records

helps protecting US creative works abroad
(International Copyright institute)

29
Q

What is Fair Use?

A

Doctrine that allows the limited use of copyrighted materials under certain conditions (usually):
- non-profit
- educational
- non-commercial

30
Q

What are the Four Factors of Fair Use?

A

1) Purpose and Character of use

2) Nature of the Copyrighted work

3) Amount and
Sustainability of Portion Used

4) Effect of the Market of Value

31
Q

What is the Creative Commons licence?

A

Allowing others to freely use, share, modify og work.
(with permission)

32
Q

What is copyright geared toward?

A

literary, artistic, and imaginative works
- books
- music
- trademarks

33
Q

What are Patents geared for?

A

Inventions

34
Q

What is a Trade Secret?
ex: Coca Cola recipe

A

An exclusive device or technique used by a company to produce goods and services

35
Q

How many high schoolers use the internet to plagiarize an assignment

A

30%

36
Q

Data collected by the researcher themselves for a specific purpose

A

Primary Source

37
Q

Data collected by someone else for their own purpose, but then used by the researcher for a specific purpose

A

Secondary source

38
Q

What type of data?:

interview
survey
mystery shopper
focus group
product test

A

Primary Source

39
Q

What type of Data?:

Sales Report
Trade Association or Group
Census Data
Internet
Previous Research

A

Secondary Source

40
Q

What are Five methods frequently used to collect PRIMARY data?

A

1) Questionnaire
2) Survey
3) Focus Group
4) Interview
5) Product Test

41
Q

What is a Questionnaire?

A

A list of questions typically used to collect info on an individual

42
Q

What is a survey?

A

Used to collect experiences and/or opinions from a group of people with a purpose a purpose of analyzing and interpreting results.

43
Q

What is a Sample Data Set?

A

A part, subset, of a population.

Contains all members of a specified group

44
Q

“Statistically Significant”

A

You typically need to survey a sufficient number of respondents (sample size) to obtain more statistically significant results

Results that did not happen randomly

45
Q

How do researchers determine if statistics are significant?

A

If probability of results being random are LESS than 5% written as p<0.05

(p= p-value/calculated probability)

46
Q

What is a Sampling Error?

A

When something did happen RANDOMLY or due to FLUCTUATIONS

47
Q

How low should a sampling error be?

A

Less than 5%

48
Q

How to know id something is practically significant?

A

if its important considering context

49
Q

What is Triangulation of Data?

A

using/comparing our info with other info from different sources to supplement out own survey data

50
Q

What are some Survey Tools? (3)

A

1) Survey Monkey
2) Qualtrics
3) Google Forms

51
Q

What are Focus Groups?

A

Involves small group discussions and individual interviews

52
Q

What is Product Testing?

A

based on info such as
- survey
- questionnaire
- focus group/interview

53
Q

The process of gathering and measuring information on a topic of interest with a purpose of answering a research question and/or testing a hypothesis to solve a problem

A

Data Collection

54
Q

Document summarizing the objectives for a business and strategies for achieving those objectives

A

Business Plan