Question
Go to http://highered.mheducation.com/sites/0073521507/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,
Go tohttp://highered.mheducation.com/sites/0073521507/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 thesurvey'sresultsexcel file go tohttp://highered.mheducation.com/sites/0073521507/student_view0/additional_material_related_to_cases.html, 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 afrequency tablefor each question, along witheitherapie chartorabar 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 "Cross-Tabulation" 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 onpivot tablefunction (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 linkhttp://www.youtube.com/watch?v=3xfuPPrI1f8fromYouTubeand 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 thesteps 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 includethemanagement questionof the Mastering Teaching Leadership case.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started