Research Skills for Business (RSB) Flashcards
An ability to locate, evaluate, analyze, and report information and data on a given topic
Research Skills
Removes conditional formatting from only the selected data or from the entire worksheet
Clear Rules
Used to format cells that meet a certain criterion.
Conditional formatting
Appears next to each table heading and opens the drop down where you can choose how to sort or filter your data
filter button
Shows the sum or average of all records in the outline
Grand Total
Allows to create custom conditional formatting rule that meets the specific needs
New Rule
Horizontal look up, an excel function to look up and retrieve data from a specific row in a table
HLOOKUP
Allows to edit and reorder existing rules in the worksheet
Manage Rules
Chart or graph that shows info from the Pivot table
Pivot Chart
Summarizes data from a more extensive table and may include sums, averages, and other statistics chosen by the user
Pivot table
A data filter with convenient buttons that filters pivot table data
Slicer
Shows the sum or average of all data belonging to their own outline level
Subtotal
Vertical look up, an Excel function to look up and retrieve data from a specific column in a table
VLOOKUP
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
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)
Search system designed to search the World Wide Web in a systematic way
Search Engine
Software great for locating general info and deep info search
- keywords
- ex: Google
Search Engine
Software is great for SPECIALIZED research
- ex: GoogleScholar
- scientific/reliable evidence
Electronic Databases
Software used on a regular basis to keep up with industry trend and news
E-journals
Software provides an in-depth coverage of the topic
- typically business related topics
E-books
How many quintillions of bytes are created every day?
2.5
FUNCTION:
AND
Returns only results containing BOTH terms
FUNCTION:
OR
Returns results containing EITHER term. Often used with synonoyms
FUNCTION:
NOT
Returns results containing the first term but EXCLUDES any results that also contain the second term
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
Copyright Infringement
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