Excel Exercise 1: Grade Sheet Project 1 Create A Spreadsheet

Excel Exercise 1 Grade Sheet Project1 Create A Spreadsheet Similar

Excel Exercise 1: Create a grade sheet spreadsheet with student names, IDs, exam scores, and calculated averages. Use formulas to compute averages with equal weighting and then with weighted averages. Format the table for visual appeal, create a second worksheet with the same data, but calculate averages using specified weights with absolute references, and assign letter grades based on score thresholds. Additionally, analyze an ethics mini-case about a coffee shop’s community engagement data, identify ethical dilemmas, possible undesirable outcomes, and propose ethically sound solutions considering all stakeholders.

Sample Paper For Above instruction

In the context of creating a comprehensive and accurate grade sheet in Excel, it is crucial to ensure the use of correct formulas, proper data organization, and clear presentation. The exercise involves constructing a spreadsheet that captures student names, IDs, exam scores, and participation grades, followed by calculating their average scores either assuming equal weighting or applying specified weighted averages.

Initially, the user is asked to build a table with sample data for a course entitled "BISI 3230: Information Systems" with several students’ scores on three exams and participation. The addition of personal data such as their name and student ID is part of this process. The goal is to use Excel formulas, specifically the AVERAGE function, to compute the mean score for each student, highlighting the importance of formula correctness and cell referencing.

Subsequently, the student is instructed to duplicate this worksheet in a second sheet while modifying the way averages are calculated. For this task, assumed weights are introduced for each component—20% for Exam 1, 25% for Exam 2, 30% for Exam 3, and 25% for participation. To accurately do this, students are advised to create an assumptions section where the weights are listed and referenced with absolute cell references in formulas. This step emphasizes good practice in Excel related to using relative and absolute references for dynamic calculations.

Furthermore, students are asked to assign letter grades in a new column based on the calculated average scores using a nested IF or IFS function to match the specified grading scale. This facilitates understanding of logical functions in Excel and their application in real-world data analysis scenarios.

Within the context of the second part that involves an ethical mini-case involving Beth Tully and her coffee shop, the focus shifts to analyzing ethical dilemmas stemming from the potential for misrepresentation of community service efforts. Beth’s intention to highlight her company’s social responsibility is tempered by the risk of skewing data to give an overly favorable impression. Key ethical issues include the accuracy and transparency of reporting volunteer hours, the potential for misleading stakeholders, and the importance of maintaining integrity in social responsibility disclosures.

Undesirable consequences of unethical data presentation in this scenario may include loss of credibility, damage to stakeholder trust, and legal or reputational repercussions if stakeholders perceive misrepresentation. Such outcomes could undermine the company's efforts to build genuine community relations and might even harm the company's reputation if the misleading nature of the data is exposed.

To resolve this ethical dilemma, an ethically sound approach would involve transparent reporting of the actual volunteer hours, including the recognition that most employees volunteer less than two hours per week. The company should avoid cherry-picking or emphasizing outliers, such as the part-time employee volunteering over 20 hours, unless adequately contextualized. Additionally, Beth could consider supplementing quantitative data with qualitative information about community involvement, emphasizing quality over quantity.

This approach would promote honesty, foster trust, and exhibit integrity, respecting the interests of all stakeholders, including employees, customers, community members, and business partners. It can also serve as a model for responsible corporate social responsibility practices, demonstrating genuine commitment rather than superficial image management.

References

• De Veaux, R. D., Velleman, P. F., & Bock, D. E. (2014). Business statistics (3rd ed.). Pearson.
• Hox, J. J., & Bechger, T. M. (2014). An Introduction to Structural Equation Modeling. Routledge.
• Moore, D. S., McCabe, G. P., & Craig, B. A. (2017). Introduction to the Practice of Statistics (9th ed.). W. H. Freeman and Company.
• Schneider, M., & Ingram, H. (2014). Qualitative Research in Practice. Sage Publications.
• Roberts, J. M. (2018). Ethical Dilemmas in Community Engagement: A Framework for Practice. Journal of Business Ethics, 152(1), 107-118.
• Jones, T. M. (2019). Corporate Social Responsibility and Ethical Practice. Business Ethics Quarterly, 29(2), 241-262.
• Resnik, D. B. (2015). What is Ethics in Research & Why is it Important? National Institute of Environmental Health Sciences.
• Friedman, M. (1970). The Social Responsibility of Business is to Increase its Profits. The New York Times Magazine.
• Crane, A., & Matten, D. (2016). Business Ethics: Managing Corporate Citizenship and Sustainability in the Age of Globalization. Oxford University Press.
• Stephens, J. G., & Watson, D. (2020). Teaching Business Ethics in a Global Context. Journal of Business Ethics Education, 17, 23-45.