Research Skills for Business (RSB) Flashcards by Mili <3

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

Research Skills

How well did you know this?

Not at all

Perfectly

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

Clear Rules

How well did you know this?

Not at all

Perfectly

Used to format cells that meet a certain criterion.

Conditional formatting

How well did you know this?

Not at all

Perfectly

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

filter button

How well did you know this?

Not at all

Perfectly

Shows the sum or average of all records in the outline

Grand Total

How well did you know this?

Not at all

Perfectly

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

New Rule

How well did you know this?

Not at all

Perfectly

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

HLOOKUP

How well did you know this?

Not at all

Perfectly

Allows to edit and reorder existing rules in the worksheet

Manage Rules

How well did you know this?

Not at all

Perfectly

Chart or graph that shows info from the Pivot table

Pivot Chart

How well did you know this?

Not at all

Perfectly

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

Pivot table

How well did you know this?

Not at all

Perfectly

A data filter with convenient buttons that filters pivot table data

Slicer

How well did you know this?

Not at all

Perfectly

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

Subtotal

How well did you know this?

Not at all

Perfectly

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

VLOOKUP

How well did you know this?

Not at all

Perfectly

7 basic steps of any research project

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?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

Search Engine

How well did you know this?

Not at all

Perfectly

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

Search Engine

How well did you know this?

Not at all

Perfectly

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

Electronic Databases

How well did you know this?

Not at all

Perfectly

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

E-journals

How well did you know this?

Not at all

Perfectly

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

E-books

How well did you know this?

Not at all

Perfectly

How many quintillions of bytes are created every day?

2.5

How well did you know this?

Not at all

Perfectly

FUNCTION:

AND

Returns only results containing BOTH terms

How well did you know this?

Not at all

Perfectly

FUNCTION:

Returns results containing EITHER term. Often used with synonoyms

How well did you know this?

Not at all

Perfectly

FUNCTION:

NOT

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

How well did you know this?

Not at all

Perfectly

FUNCTION: /s

Returns results with both terms in the same SENTENCE

FUNCTION: /p

Returns results with both terms in the same PARAGRAPH

FUNCTION: " "

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

FUNCTIONS: !

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

FUNCTION: *

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)

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

Plagarism

Fraud - When you take info WITHOUT PERMISSION

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

1) Copyright infringement 2) Plagarism

What are intellectual Property Rights?

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

What is Copyright?

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

When does Copyright expire?

70 years after the author's death

What are some penalties for copyright infringement?

- 250,000 fine - five years in prison

What is the U.S. Copyright Office?

The official US gov't body that maintains copyright registration records helps protecting US creative works abroad (International Copyright institute)

What is Fair Use?

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

What are the Four Factors of Fair Use?

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

What is the Creative Commons licence?

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

What is copyright geared toward?

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

What are Patents geared for?

Inventions

What is a Trade Secret? ex: Coca Cola recipe

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

How many high schoolers use the internet to plagiarize an assignment

30%

Data collected by the researcher themselves for a specific purpose

Primary Source

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

Secondary source

What type of data?: interview survey mystery shopper focus group product test

Primary Source

What type of Data?: Sales Report Trade Association or Group Census Data Internet Previous Research

Secondary Source

What are Five methods frequently used to collect PRIMARY data?

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

What is a Questionnaire?

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

What is a survey?

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

What is a Sample Data Set?

A part, subset, of a population. Contains all members of a specified group

"Statistically Significant"

You typically need to survey a sufficient number of respondents (sample size) to obtain more statistically significant results Results that did not happen randomly

How do researchers determine if statistics are significant?

If probability of results being random are LESS than 5% written as p<0.05 (p= p-value/calculated probability)

What is a Sampling Error?

When something did happen RANDOMLY or due to FLUCTUATIONS

How low should a sampling error be?

Less than 5%

How to know id something is practically significant?

if its important considering context

What is Triangulation of Data?

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

What are some Survey Tools? (3)

1) Survey Monkey 2) Qualtrics 3) Google Forms

What are Focus Groups?

Involves small group discussions and individual interviews

What is Product Testing?

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

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

Data Collection

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

Business Plan