Spring 2020
MANG 434:001 (crn: 10363)
Syllabus
Course schedule (revised on March 30, 2020)
Module 1 - Introdution to Business Research Methods
Module 2 - Data sources, data types, and survey design
- Module 2_Handout 1
- Module 2_Handout 2
- Conceptual Model Example
- It is important that each group creates a model like the one that is depicted in this example. (The model should be included in the “consultation meeting summary group project submission.) A model like this will be the foundation for your group’s data collection instrument. Put differently, your model will determine what questions will be asked on your survey and, thus, what evidence-based practice recommendations your group can make. Indeed, you can only make recommendations based on the evidence that was collected. Importantly, the model should be supported by theory! Otherwise, there may be little support for why the variables included in the model are related to each other.
- Introduction/Step-by-step guide to creating and distributing a survey in Qualtrics
- Introduction/Preamble for Qualtrics survey
- Each group should use this. Copy and paste the attached text into the survey as the first question (make sure you reduce the number of response options [see the right panel in Qualtrics] to zero).
- Required and optional constructs to be included in your questionnaire
- Qualtrics and INN tutorial (video) – Step-by-step guide
- Sorry that this is so long (about 30 mins)!
Module 3 - Descriptive statistics and group differences
- Module 3 PowerPoint
- What do you mean - Case study
- Module 3 sample data
- In-class extra credit assignment (March 11)
- Profit sharing exercise
Scrubbing the dataset - Part I (recorded and posted on March 30, 2020)
- Link to recorded lesson
- Note that this was recorded at home. Thus, you may hear screaming kids in the background! You may also hear my screaming wife screaming at my screaming kids! Social distancing with two kids, an one year old and a three year old, is no joke! Stay safe, my friends!
- It is very important that you let me know if you have any questions.
- Finally, each group needs to upload proof that their data collection has ended. If you need help with this or have any concerns regarding your group’s data (e.g., small sample size), then please email me ASAP
Scrubbing the dataset - Part II (recorded and posted on April 1, 2020)
- Link to recorded lesson
- This was recorded at home so note that the same warnings apply!
- Please contact me if you have questions and/or need help with anything
- Reminder: I will hold virtual office hours tomorrow from 11am to 2pm via Skype. My handle is jamiefield87. Please email, text or chat message me ahead of time if you want to meet with me.
Estimating descriptive statistics (recorded and posted on April 3, 2020)
- Link to recorded lesson
- Attached please find a formatted correlation table. Please use it to populate your results and complete the next group project assignment.
- Note that the next group project assignment is due by 11:59pm ET on Monday, April 6. Please review the updated course calendar (at the top of this page and also posted in eCampus) for other important deadlines.
Figures in Excel (Part I) (recorded and posted on April 6, 2020)
- Link to recorded lesson
- Attached please find Excel files for the pie chart and scatter plot that I created in this tutorial.
Figures in Excel (Part II) (recorded and posted on April 8, 2020)
- Link to recorded lesson
- Attached please find Excel file that includes the scatter plot that displays a sex difference that I created in this tutorial.
- NOTE: Homework Assignment #4 is now available on eCampus
Figures in Excel (Part III) (recorded and posted on April 13, 2020)
- Link to recorded lesson
- Lots of really cool stuff in this tutorial. I hope that you learn from it and find it useful. Let me know if you have any questions regarding what was covered today.
- Attached please find Excel file that includes the bar chart and pivot table that I created in this tutorial.
- NOTE: Homework Assignment #4 and the next group project assignment (required figures) are due by 11:59pm ET on Wednesday, April 15 (see eCampus.
Excel tutorials
- Tutorial #1: Text-to-columns
- WVU Men’s Basketball results
- We will use this .csv file to separate the “Result” column into three new columns (i.e., W or L, Away Team Score, and Home Team Score). From here, we can estimate some interesting statistics (e.g., win percentage, average team score)!
- Video link to Tutorial #1a
- Text-to-columns tutorial
- Use this guide as a reference if need help learning the text-to-columns procedure
- Class roster
- Use this file to practice your text-to-columns skills. Specifically, separate Column A, which contains each student’s name in the “last name, first name” format, into two separate columns.
- The file contains several other formula-driven cells (see Column C and Columns F-H). Column C removes the unnecessary space (i.e., the first character) from the cells in Column B. Columns F-G then counts the number of characters in the Columns A-C.
- Video link to Tutorial #1b
- WVU Men’s Basketball results
- Tutorial #2: COUNTIF statements
- A COUNTIF example using categories of race
- In this example, five categories of race are summarized using the COUNTIF function. See Column H for the application of the COUNTIF function.
- A COUNTIF example using categories of race
- Tutorial #3: IF statements
- A sample data set to be used in class
- In this example data set, you can dummy code the “Sex” data (see Column B) using an IF statement
- IF function examples and exercises
- This file contains three separate examples and corresponding exercises. In the first exercise, you will be asked to use an IF statement to identify is greater than the column median. In the second exercise, you will be asked to use an IF statement to count the number of color matches. In the third exercise, you will be asked to use an IF statement to identify the number of teams ending in “State” (e.g., Kansas State).
- A sample data set to be used in class
- Tutorial #4: VLOOKUP
- A VLOOKUP example using categories of race
- In this example, five categories of race are summarized using the COUNTIF function. See Column C and Column H for the application of the VLOOKUP function.
- A VLOOKUP example using categories of race
- Tutorial #5: Comprehensive example (useful for Homework Assignment #3 and Exam 1 Part II)
- Tutorial #6: Comprehensive example (useful for Homework Assignment #3 and Exam 1 Part II)
- What to do when there are data missing in your dataset?
- Coming soon…
- Tutorial #1: Text-to-columns
@Students: Keep checking back for more content!