Instructions:
Based on the content for week 4, we continue working on the case study ” NCRCC: Teeing Up a New Strategic Direction”(http://highered.mheducation.com/sites/0073373702/student_view0/cases.html).
Go to the survey attached to the case study:
 From studying chapter 12 content, and reading the case study survey, then select randomly five questions from the survey and identify the type of measurement scale (chapter 12) used in each question. Suggest using a chart in your response.
 From studying chapter 13, then select three openended questions, three closed questions, and three measurement questions from the survey. Suggest using the following chart:
Classification  Questions 
Openended 
For instance:
(1) Please, provide any comments and suggestions you may have regarding the future direction of the club. (2) (3) 
Closed questions 
(1)
(2) (3) 
Measurement questions 
(1)
(2) (3) 
 From studying chapter 13, and reading the case study content,then evaluate the effectiveness of the measurement questions (chapter 13) used in the survey. There are three issue categories (Exhibit 135, pages 325338) to measure how effective the measurement questions are. Select randomly two measurement questions from the survey, and evaluate them for each category. After evaluating the questions, comment on its effectiveness as a question. Suggest using the following chart:
Issue Category  Fundamental Issue  
Question one:

Question two:  
Question content  YES  No  Yes  No 
Purposeful versus interesting  
Incomplete and unfocused  
Doublebarreled question  
Precision  
Time for thought  
Participation at the expense of accuracy  
Presumed knowledge  
Recall and memory decay  
Balance  
Objectivity  
Sensitive information  
Question Wording  
Shared vocabulary  
Unsupported assumption  
Frame of reference  
Biased wording  
Personalization vs. projection  
Adequate alternatives  
Response Strategy Choice  
Objective of the study  
Level of information  
Thoroughness of prior thought  
Communication skill  
Participant motivation 
After reading the Chapters 14 (Sampling), 15 (Analysis and Presentation of Data) and, 16 (Exploring, displaying and examining data), answer the questions below.
 Go to http://highered.mheducation.com/sites/0073373702/information_center_view0/index.html, click on “student edition”, go to cases and click on “CampbellEwald Pumps Awareness into the American Heart Association case”. Then, once you have read the case answer questions 2 and 3 from the case. Answer the questions in APA style.
 Assume the following:
2.1. A lakefront resort is planning for its summer busy season. It wishes to estimate with 95% confidence the average number of nights each guest will stay for a consecutive visit. Using a sample of guests who stayed last year, the average number of nights per guest is calculated at 5 nights. The standard deviation of the sample is 1.5 nights. The size of the sample used is 120 guests and the resort desires a precision of plus or minus .5 nights. What is the standard error of the mean in the lakefront resort example? Within what range below can the resort expect with 95% confidence for the true population means to fall? Show the calculation; otherwise, the answer will not be accepted.
2.2. A local restaurant is planning a study on demand for meals over holiday weekends. In calculating the desired sample size for the study, the restaurant’s researcher decides to use a ruleofthumb calculation for estimating the population dispersion. If the range of meals in the study is 0 to 30, what standard deviation does the ruleofthumb method produce? Show the calculation; otherwise, the answer will not be accepted.
2.3. A microbrewery plans to conduct a study on beer consumption among men between the ages of 29 and 45. A pilot test indicated that men in this age category consume an average of 6 beers per week with a standard deviation of 2.3. If the microbrewery seeks a 95% confidence level and a precision of .5 beers, what size sample should be used in the study? Show the calculation; otherwise, the answer will not be accepted.
 Go to http://highered.mheducation.com/sites/0073373702/information_center_view0/index.html, click on “student edition”, go to cases and click on “Mastering Teaching Leadership case”. This exercise is a data analysis assignment. Then, once you have read the case and analyzed the survey’s results, follow the steps shown below:
 To get the survey’s results excel file go to mhhe.com/cooper11e, go to “Additional materials related to cases”, copy and paste the “Mastering teaching leadership excel file” in your computer, then open the file.
 The file shows the results obtained from applying the survey which appears at the end of the case: Pick five questions from the survey, and build a frequency table for each question, along with either a pie chart or a bar chart (should you need assistance in using Data analysis in excel, contact me please). See chapter16 on page 431 to review the concepts.
 Go to page 444 and study “CrossTabulation” technique. Then, go to the case’s survey, and select any two of the variables (questions) in the survey. Go to the excel file, click on pivot table function (upper left corner under “Insert” tab), and cross the two variables selected by you by using the pivot table function. To know how to use the pivot table in Excel, click on the link http://www.youtube.com/watch?v=3xfuPPrI1f8 from YouTube and learn from it. Repeat the same on the excel file with the two variables selected by you previously, and obtain the result.
Once you have followed the steps aforementioned, do the following: Analyze the results obtained from steps 2 and 3, craft an executive report (Google “how to write down an executive report”) based on your findings from step 2 and 3. Do not forget to include the management question from the Mastering Teaching Leadership case.
Last Updated on