International Peer-Reviewed Journal•Open Access•ISSN 2456-8880
irejournals@gmail.com•+91-7433024337

Home / Current Issue / Paper 1704747

1704747 Vol 6 · Issue 12 Download Paper

Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors

Bernardo F. Ramos

Subject area: Arts, Social Sciences and Humanities  ·  Area of research: Education

Abstract

This study emphasizes the benefits of using an Excel drop-down template for calculating grades. Through the use of surveys in the form of questionnaires, this study intends to evaluate the applicability and use of the Excel Drop Down template to students competing for academic awards. The likert scale and thematic analysis were also used in the data analysis to better comprehend the study participants' experiences, namely those of the second-year college students competing for Latin honors. The results also suggest that most students who used the Dropdown Excel template to compute their grades thought it was effective and useful because it made manual labor easier.

Keywords

Academic Honors Drop Down, Excel Template

References

[1] Boachie, E. (2016, August). The Effectiveness of Microsoft Excel to Improve Students Continuous Assessment in Secondary Schools in Ghana. International Journal of Trend in Research and Development, Volume 3(2394–9333), 441–446. Retrieved January 2, 2023, from http://www.ijtrd.com/papers/IJTRD4084.pdf.

[2] Brookfield, C. (2021, November 5). Why use Microsoft Excel for Social Research Projects? Methodspace. Retrieved December 23, 2022, from https://www.methodspace.com/blog/why-use-microsoft-excel-for-social-research-projects.

[3] Chauhan, P. (2022, July 20). What to do When an Excel file is Corrupted?. Retrieved January 2, 2023, from https://www.stellarinfo.com/blog/what-to-do-when-excel-file-is-corrupted/.

[4] Computerized Enrollment System Research Paper. (2016, Oct 02). Retrieved from https://graduateway.com/computerized-enrollment-system/

[5] Computerized Grading System. (n.d.). Term Paper Warehouse. Retrieved December 19, 2022, from https://www.termpaperwarehouse.com/essay-on/Computerized-Grading-System/425151.

[6] Drop-down lists. (n.d.). Microsoft. Retrieved December 19, 2022, from https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2.

[7] Emmanuel, A. (2019, May 31). Result Computation for Tertiary Institution using Microsoft Excel Case Study. Retrieved December 24, 2022, from https://iiste.org/Journals/index.php/ISDE/article/download/47790/49372.

[8] ExcelChamps. (2022). Top 10 Benefits of Microsoft Excel – Why YOU Should Learn it in 2022. Retrieved January 2, 2023, from https://excelchamps.com/benefits-of-microsoft-excel/.

[9] George, N. (2021, December 4). Enhancing senior secondary students' performance in statistical charts ... ReseachGate. Retrieved December 23, 2022, from https://www.researchgate.net/publication/361767792.

[10] How to create simple or dynamic drop-down validation lists in Excel. (2022, November 29). Power-User. Retrieved December 20, 2022, from https://www.powerusersoftwares.com/post/2018/07/31/how-to-create-simple-or-dynamic-drop-down-lists-in-excel-and-why-you-should

[11] Kondrat, D. (2022, May 7). Undergraduate students’ attitudes toward statistics: How excel makes a ... ResearchGate. Retrieved December 23, 2022, from https://www.researchgate.net/publication/361481415.

[12] Mack, K., Lee, J., Chang, K., Karahalios, K., & Parameswaran, A. (2018). Characterizing scalability issues in spreadsheet software using online forums. Extended Abstracts of the 2018 CHI Conference on Human Factors in Computing Systems. Retrieved January 2, 2023, from https://doi.org/10.1145/3170427.3174359.

[13] Michael Brusco (2022) Logistic Regression via Excel Spreadsheets: Mechanics, Model Selection, and Relative Predictor Importance. INFORMS Transactions on Education 23(1):1-11. Retrieved January 2, 2023, from https://doi.org/10.1287/ited.2021.0263.

[14] Microsoft. (n.d.). Video: Drop-down lists. Retrieved December 19, 2022, from https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2.

[15] Monitoring Student Needs and Progress in a Student-Centered Classroom | Michigan Virtual. (2021, September 17). Michiganvirtual.org. Retrieved January 2, 2023, from https://michiganvirtual.org/blog/monitoring-student-needs-and-progress/#:~:text=By%20tracking%20their%20own%20academic.

[16] Natter, Elisabeth. (2019, January 25). The Advantages & Disadvantages of Spreadsheets. Retrieved January 2, 2023, from https://www.technewstoday.com/excel-drop-down-list-not-working/.

[17] Palistha. (2022, August 9). Excel Drop Down List Not Working? Try These Fixes. Retrieved January 2, 2023, from https://www.technewstoday.com/excel-drop-down-list-not-working/.

[18] Pollio, H.R. and W. L. Humphreys (2020). Grading Students. In J.H. McMillan (ed.) Retrieved January 2, 2023, from Assessing Students’ Learning. New Directions for Teaching and Learning, 34, pp.85-97 San Francisco: Jossey-Bass.

[19] Tucker, C. (2017, May 23). 3 Problems with Traditional Grades. Dr. Catlin Tucker. Retrieved December 19, 2022, from https://catlintucker.com/2017/05/3-probs-trad-grades/.

[20] UCLA Office of Instructional Development Creating a Grade Sheet With Microsoft Excel Teaching Assistant Training Program. (2020). Retrieved January 2, 2023, from https://www.math.ucla.edu/~tat/Docs/excel.pdf.

How to cite this paper

Bernardo F. Ramos "Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors" Iconic Research And Engineering Journals Volume 6 Issue 12 2023 Page 943-953
Bernardo F. Ramos "Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors" Iconic Research And Engineering Journals, vol. 6, no. 12, Jun. 2023
Bernardo F. Ramos (2023). Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors. Iconic Research And Engineering Journals, 6(12).
Bernardo F. Ramos "Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors" Iconic Research And Engineering Journals, vol. 6, no. 12, Jun. 2023.
@article{1704747,
      author = {Bernardo F. Ramos},
      title = {Drop Down Excel Template: Its Practicability and Use to Students Running For Academic Honors},
      journal = {Iconic Research And Engineering Journals},
      year = {2023},
      volume = {6},
      number = {12},
      pages = {943-953},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1704747.pdf},
      abstract = {This study emphasizes the benefits of using an Excel drop-down template for calculating grades. Through the use of surveys in the form of questionnaires, this study intends to evaluate the applicability and use of the Excel Drop Down template to students competing for academic awards. The likert scale and thematic analysis were also used in the data analysis to better comprehend the study participants' experiences, namely those of the second-year college students competing for Latin honors. The results also suggest that most students who used the Dropdown Excel template to compute their grades thought it was effective and useful because it made manual labor easier.},
      keywords = {Academic Honors Drop Down, Excel Template},
      month = {June},
  }