案例分析essay/report写作
Case Analysis Overview
Case Analysis 1 is based on material discussed in the following units:
Class Introduction, Excel Basics, Data entry & formatting, Charting.
You should complete your report using the Case Analysis 1 Template document
that is available in the Case Analysis 1 folder on D2L. After you complete your
assignment, make sure to save and submit the CA1_Template as a PDF file.
100 Total points possible, as follows:
- Business Communication: 20 points
- Question 1: 20 points
- Question 2: 36 points
- Question 3: 24 points
Assignment Overview
Excel allows business professionals to accomplish the key requirements of
information management that we discuss in MIS 112, namely: organization,
analysis, and communication.
Business Communication Points [20 points]: Since your case analysis report is a
formal business document, 20% ( 20 points ) of your assignment grade will be
based on your overall business communications skills. Therefore, your responses
should be written in well-organized paragraphs, using the rules of English
grammar, punctuation, and, sentence structure. A word count is provided to
guide you on the length that is appropriate for each question.
As a reminder: all answers to narrative questions must be your original work in
your own words. Copying the work of another student (either in the current or
prior semester or reusing your own work from this class or another class) or
copying information from the web or any other source will be considered as
plagiarism. As a reminder, all assignments are checked using TurnItIn.com.
Task 1 [20 points]:
Task 1 Scenario: In our MIS 112 lecture videos, we discussed how to password protect a workbook. Suppose your supervisor at work, Jane Doe, has noticed Excel has fields for two passwords, one to open and one to modify.
Task 1(a): (12 points) Using non-technical, conversational English, explain to Jane Doe (75- 100 words) in your own original words why Excel has two options for passwords to protect an Excel workbook. In your answer, give a specific example for their use (i.e., what kind of data would you store in a workbook in which password protecting it would provide an advantage).
Task 1(b): (8 points) Explain (50-75 words) to Jane Doe in your own original words what criteria you would use to choose a good password to protect a workbook. If you would like additional information about selecting good passwords, please see the University of Arizona password security website http://security.arizona.edu/password-security.
Task 2 [36 points Total] Case analysis scenario:
Task 2 Scenario: A teacher at Wildcat High School has asked for your help in calculating end of term scores and percentages. Please follow the steps below in answering this question.
To begin, download the CA1_Scores.xlsx file from D2L to your local computer.
Depending on the version of Excel you are using, if you open the file directly from D2L, you may need to enable editing before continuing (see below):
Using the CA1_Scores.xlsx file, prepare your Task 2 worksheet as follows:
- In cell B1 , enter your 8-digit studentID (do not use your CatCard number). You should enter your StudentID as a text field, using a leading apostrophe. (Note: the data set used for your analysis will be selected based on your StudentID.)
- In Cells B2 and A5 , enter your full name.
- In cell D4 , add the heading Total Score and format it in the bold font style.
- In cells D5:D14 (D5 through D14), calculate the total score for the two exams for each student in columns B and C using an Excel formula that contains either an arithmetic operator or Excel arithmetic function. For example, if the Exam 1 score is 80 and the Exam 2 score is 70, your equation would display a Total Score of 15 0.
- Change the formatting for cells D5:D14 to a Number and display two decimal places.
- In cells E5:E14 (E5 through E14), calculate the Score Percentage earned by the student in the class using an Excel formula , given the maximum possible score for each exam is 100 points. For example, if the Total Score for a student is 150, the Percentage earned is 75% out of the maximum total points of 200.
- Change the formatting for cells E5:E14 to a percentage using a whole number (e.g., it should show 75% with no fractional value).
Task 2(a): (20 points) After completing steps 1-7 from above, copy and paste an image of your worksheet from Excel into your CA1 report template document in the space provided for Task 2(a). When you paste your solution, be sure that your answer is easily readable. An example of an expected solution is shown below. Your solution should be the entire table and not have any redacted information.
Enter Your 8-
digit
Student ID
12345678
Enter Your
Name
John Doe
Student Exam 1 Score Exam 2 Score Total Score
Score
Percentage
John Doe 77.78^ 64.90^ 142.68^ 71%^
Emma McClendon 69.00^ 49.00^ 118.00^ 59%^
Alice Waller (^) 50.00 74.00 (^) 124.00 62% Timothy Burton 91.00^ 40.00^ 131.00 66% Jessica Cherry 53.00^ 43.00^ 96.00 48% Patricia Zamora 91.00^ 100.00^ 191.00 96% Linda Salas 99.00^ 69.00^ 168.00 84% Peter Riddle 86.00^ 62.00^ 148.00 74% Beverly Santiago 97.00^ 79.00^ 176.00 88% Nancy Fry 53.00 68.00 121.00 61% Average 76.68 64. (^) Task 2(b): (8 points) Please write down (copying and pasting is acceptable) the formula from cell D5 into your CA1 report document in the space provided for Task 2(b). Ensure your formula is correctly written and that it is a valid Excel formula and NOT the numerical value (i.e., a numeric score such as 49.00) for that student. Task 2(c): (8 points) Please write down (copying and pasting is acceptable) the formula from cell E5 (i.e., Score Percentage) into your CA1 report document in the space provided for Task 2(c). Ensure your formula is correctly written and that it is a valid Excel formula (and not the percentage value for a student).
SAMPLE
Task 3 [24 points Total]
Task 3 Scenario: Use your solution from Task 2 to perform tasks in Task 3.
Task 3(a ): (8 points) Describe (in 75-100 words) in your own original words how a using spreadsheet tool to format your data into a chart can help you better communicate information about the comparison of scores for different students (i.e., relative scores of students shown in the example in Task 2).
Task 3(b): (16 points) Based on your conclusions in Task 3(a), format your data from Task 2 as a chart that compare the scores for the different students. Then, copy and paste an Excel chart (i.e., a chart you created for score comparison). The chart should allow comparison of scores for all students on Exam 1 and Exam 2 only.
Ensure your chart has the following heading Task 3(b) – Score Comparison, as shown below.
See the figure below for an example of presenting the data from your analysis using an Excel chart. Although the figure shown below is an Excel chart, the style of the chart shown in the figure should NOT be used for your solution, since it does not present the information in way that meets the requirements of Task 3(b). You should select a chart style that more appropriately conveys the concept of a score comparison to the reader.