1.You have a spreadsheet that contains performance data for the staff. How would

Question

1.You have a spreadsheet that contains performance data for the staff. How would you organize this data considering that it would be data used for annual performance reviews for each staff member? What are some of the ethical considerations to keep in mind when
using this data?

2.As a university instructor, charts are very useful to show statistical analysis of test scores to students. Students are always interested in how they scored compared to the whole class or where their score landed in the overall scheme of things. Which type of statistics would be most useful for comparisons? Which type of chart would be best to show the comparison of grades? How do charts help protect privacy of individual grades?

The answers to the questions need to be simple and easy to understand and not long at all. Every single question needs to be answered.

Explanation / Answer

1. When we have staff performance data spreadsheet, we can organize this data for annual performance review by performing following task:

a. Sorting of data

b. Selection of data for preservance

c. Autosum the required columns

d. Filter the required data

e. Pivot table can be used for analysis

Following are some ethical considerations to keep in mind when using this data

a. Keep Employee Personal Info Private

b. Keep Employee Performance Info Private

c. Use resonable considerations where ever necessary

d. Give benefit of doubt to employee

2. As an instructor it is necessary to protect privacy of individual grades so as to remove guilty feelings of students. for this we can use charts to represent the scores of the students. the best chart for this is Bar chart which can display the level of scroing of students and not actual scores.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.