TEACHERS' ASSESSMENT AND STUDENTS' SELF-ASSESSMENT ON THE STUDENTS' SPREADSHEET KNOWLEDGE (original) (raw)
Related papers
The Comparison of Students’ Self-Assessment, Gender, and Programming-Oriented Spreadsheet Skills
Education Sciences
Previous research proved that teaching spreadsheeting from a programming perspective is much more effective than the widely accepted tool-centered surface approach methods. Spreadsheeting as an introductory programming approach allows students to build up schemata leading to contextualized, concept-based problem-solving. Furthermore, it provides tools for real-world problem-solving in other disciplines, and supports knowledge-transfer to database management and “serious” programming. The present study provides the details of a nationwide testing of Grades 7–10 students on how they evaluate their spreadsheet knowledge, which classroom activities form their self-assessment values, and the results of three spreadsheet tasks evaluated by the SOLO categories of understanding. The comparison reveals that most students’ spreadsheet knowledge is pre-structural. On the other hand, they assess themselves much higher, which is primarily based on the number of activities carried out in classes....
Spreadsheet Knowledge and Skills of French Secondary School Students
2008
The aim of our research project called DidaTab -Didactics of Spreadsheets -is to get a more comprehensive picture of ICT uses in French schools and to obtain a better knowledge of students' spreadsheet competencies. The exploratory study of curricula and practices shows very sparse use during secondary education. To achieve a more precise estimation of what students can do with spreadsheets, we identified detailed competencies and designed computer performance tasks to serve as a basis for tests. The analysis of the results of a few groups indicates that in most cases students' knowledge and skills are rather low. A deeper investigation of students' work shows close links between lack of confidence with spreadsheets and lack of knowledge in mathematics and informatics.
A survey of 1st-year university students’ ability to use spreadsheets at the start of 2003
2004
Universities are using more information and communication technologies (ICT) in their teaching and learning environments. An anonymous multiple-choice survey self-assessed the spreadsheet skills of students enrolled in …rst-year units at the beginning of 2003. The results of the survey indicate signi…cant de…ciencies in the use of spreadsheets. There is a signi…cant proportion of students who are unable to use spreadsheets as part of their education at the start of their university studies. The implications for tertiary education are discussed.
Applied Studies in Agribusiness and Commerce
Teaching Computer Science in higher education is imperative, even though today’s students have been born into a world where technology is an essential part of everyday life. To efficiently master modern, business, technical and scientific knowledge and to proficiently produce quality results in a work environment it is crucial to have high level IT knowledge. In business, Excel is the lingua franca and so knowing how to aptly use spreadsheets is a must for our students. The primary objective of the authors was to examine the perceived and actual knowledge of spreadsheet applications of students entering higher education. Accordingly, a questionnaire and a practical assignment have been developed. In the questionnaire, students were asked to provide information concerning their previous IT studies and rate their knowledge of word processing, spreadsheets and database management. During the practical, students were asked to solve an Excel exercise taken from a high school Computer Sci...
Sprin Journal of Arts, Humanities and Social Sciences
This study aimed to investigate the effects of spreadsheet application in teaching Data Management in Mathematics of the Modern World on the students' performances among first-year College Students during the Second Semester of School Year 2022-2023. A quasi-experimental research design with the pretest-posttest non-equivalent groups design was employed in the study with the researcher–made questionnaire comprising 40 items test. The statistical methods used to gather data were treated using mean, t-test for independent samples, z-test for correlated samples, and standard deviation. Data were gathered from the 74 first-year college students in Jose Rizal Memorial State University–Main Campus. Results revealed that the pre-test and post-test performance of the students in the control and experimental groups was good. But their post-test performance in the experimental group was excellent. It is concluded that Spreadsheet Application is a very important and effective tool in teach...
A study of the gender differences on spreadsheet grades for undergraduate students
The purpose of this study is to investigate the differences between genders on the scores of a series of spreadsheet projects in a survey computer information systems course. This study hypothesizes that there will be significance in scores in the ten assigned projects between female students and males students; with the female students scoring higher than male students in a majority of the projects. Additionally, this study hypothesizes that there will be a significant difference in the mean project score for all ten projects with the female students scoring higher than the male students. Group statistics and t-tests were used to determine significance between females and males. Among the discoveries, except for a slight difference in two of the projects, there was no significance between female and male students' project scores. An interesting downward trend in mean scores emerged as the projects progressed.
LEVELS OF STUDENT RESPONSES IN A SPREADSHEET-BASED ENVIRONMENT
2004
The purpose of this report is to investigate the range of student responses in three domains -hypothesizing, organizing data, and algebraic generalization of patterns during their work on a spreadsheet-based activity. In a wider context, we attempted to investigate students' utilization schemes of spreadsheets in their learning of introductory algebra. Twenty students' responses to an investigative assignment were analyzed. The findings indicate a wide range of student responses. In each of the three domains analyzed, most student responses fell into several clearly definable categories. However, an attempt to establish a hierarchy of performance levels led to less clear results.
Power to business professors: Automatic grading of problem-solving tasks in a spreadsheet
Journal of Accounting Education, 2014
This paper presents an innovative approach based on Excel files and a detailed implementation guide that allows a professor with proficient spreadsheet skills to develop individualized problem-solving tasks for assignments and examinations that test students on cognitive thinking processes beyond memorizing and drilling. The professor accomplishes this goal by requiring the students to model a business problem-solving task in a worksheet environment. Each student's work is marked automatically by a generic "plug and play" Visual Basic for Application (VBA) algorithm. The scores and feedback provided are tailored to each individual student and address not only the problem-solving outcome but also the problem-solving process. The learning objective discussed in this work is implemented at a Norwegian university business school.
Automated assessment and marking of spreadsheet concepts
Proceedings of the second Australasian conference on Computer science education - ACSE '97, 1996
This paper discusses the use of methods for automating the testing and marking of spreadsheet concepts within an introductory service subject offered at the University of Newcastle. The methods reduce logistic and management problems encountered with large classes and enhance individual student learning outcomes. Future extensions to the present work are also described.
Use of a Spreadsheet Based Marking System for Assisting Learning and Assessment
This paper describes the development of a spreadsheet-based marking system and its use in first and second year accounting courses at the University of Sydney in 1994 and 1995. A live demonstration of the system is conducted as an integral part of the paper. The paper begins with a relatively brief depiction of the two-fold motivation for the system’s development: (1) the desire to provide large numbers of students with timely and accurate feedback on assignments in a resource constrained environment and (2) to foster use of the personal computer as a problem solving tool through development of expertise with a computer spreadsheet. The first motivation is in essence an integral part of one institution’s strategy to deal with both the current economic environment and the needs of its customers (students and employers). The second motivation is a direct response to the changing needs of today’s students in that the degree of data analysis required for much of their work cannot, in pr...