{"title":"课堂练习:使用word教授解决问题和Excel功能","authors":"Donald D. Conant","doi":"10.1080/08832323.2023.2232923","DOIUrl":null,"url":null,"abstract":"Abstract For years, researchers have recognized the expectation within the business community that business school graduates possess a working knowledge of spreadsheet applications. Academics continue to seek effective ways to teach these skills in an academic setting. This exercise uses Wordle, a five-letter word guessing game, to teach students problem-solving and Excel skills. In this exercise, I provide instruction on the use of conditional formatting, data validation, cell referencing, error handling, and several Excel functions. This exercise allows students to explore and understand a system or problem and then use Excel to find a solution.","PeriodicalId":47318,"journal":{"name":"Journal of Education for Business","volume":" ","pages":""},"PeriodicalIF":1.3000,"publicationDate":"2023-07-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A classroom exercise: Teaching problem-solving and Excel features and functions using Wordle\",\"authors\":\"Donald D. Conant\",\"doi\":\"10.1080/08832323.2023.2232923\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Abstract For years, researchers have recognized the expectation within the business community that business school graduates possess a working knowledge of spreadsheet applications. Academics continue to seek effective ways to teach these skills in an academic setting. This exercise uses Wordle, a five-letter word guessing game, to teach students problem-solving and Excel skills. In this exercise, I provide instruction on the use of conditional formatting, data validation, cell referencing, error handling, and several Excel functions. This exercise allows students to explore and understand a system or problem and then use Excel to find a solution.\",\"PeriodicalId\":47318,\"journal\":{\"name\":\"Journal of Education for Business\",\"volume\":\" \",\"pages\":\"\"},\"PeriodicalIF\":1.3000,\"publicationDate\":\"2023-07-14\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Journal of Education for Business\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1080/08832323.2023.2232923\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"EDUCATION & EDUCATIONAL RESEARCH\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Journal of Education for Business","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1080/08832323.2023.2232923","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"EDUCATION & EDUCATIONAL RESEARCH","Score":null,"Total":0}
A classroom exercise: Teaching problem-solving and Excel features and functions using Wordle
Abstract For years, researchers have recognized the expectation within the business community that business school graduates possess a working knowledge of spreadsheet applications. Academics continue to seek effective ways to teach these skills in an academic setting. This exercise uses Wordle, a five-letter word guessing game, to teach students problem-solving and Excel skills. In this exercise, I provide instruction on the use of conditional formatting, data validation, cell referencing, error handling, and several Excel functions. This exercise allows students to explore and understand a system or problem and then use Excel to find a solution.
期刊介绍:
The Journal of Education for Business is for those educating tomorrow''s businesspeople. The journal primarily features basic and applied research-based articles in entrepreneurship, accounting, communications, economics, finance, information systems, management, marketing, and other business disciplines. Along with the focus on reporting research within traditional business subjects, an additional expanded area of interest is publishing articles within the discipline of entrepreneurship. Articles report successful innovations in teaching and curriculum development at the college and postgraduate levels. Authors address changes in today''s business world and in the business professions that are fundamentally influencing the competencies that business graduates need. JEB also offers a forum for new theories and for analyses of controversial issues. Articles in the Journal fall into the following categories: Original and Applied Research; Editorial/Professional Perspectives; and Innovative Instructional Classroom Projects/Best Practices. Articles are selected on a blind peer-reviewed basis. Original and Applied Research - Articles published feature the results of formal research where findings have universal impact. Editorial/Professional Perspective - Articles published feature the viewpoint of primarily the author regarding important issues affecting education for business. Innovative Instructional Classroom Projects/Best Practices - Articles published feature the results of instructional experiments basically derived from a classroom project conducted at one institution by one or several faculty.