• Corpus ID: 13990896

From error detection to behaviour observation: first results from screen capture analysis

  title={From error detection to behaviour observation: first results from screen capture analysis},
  author={Françoise Tort and François-Marie Blondel and Eric Bruillard},
This paper deals with errors in using spreadsheets and analysis of automatic recording of user interaction with spreadsheets. After a review of literature devoted to spreadsheet errors, we advocate the importance of going from error detection to interaction behaviour analysis. We explain how we analyze screen captures and give the main results we have obtained using this specific methodology with secondary school students (N=24). Transcription provides general characteristics: time, sequence of… 

Figures and Tables from this paper

Identify and understand the difficulties of the students in class by analysing their activity in the case of prescribed tasks with the spreadsheet
Teachers are provided with indicators to help them take into account the difficulties’ students face when performing tasks prescribed with a computer tool like the spreadsheet to better understand why students learn or not.
Processing and Analyzing Assessment Test Logs provided by Digital Pen and Paper
This paper investigates the interest of time stamped answers, considered as traces of the answering process to an assessment test, and designed and developed a platform named SEGELL, which provides graphical representations that helps users, as teachers or researchers in education, to analyze students’ production.
Teaching Spreadsheets: Curriculum Design Principles
This paper aims at elaborating principles to design a spreadsheet curriculum, and suggests key principles for spreadsheet teaching, and illustrates them with teaching guidelines.
Post-editing machine translated text in a commercial setting: Observation and statistical analysis
A mixed method approach was employed to both quantitatively and qualitatively analyse the data and gain detailed insights into the post-editing activity from various view points, indicating that a number of factors, such as sentence structure, document component types, use of product specific terms, and post-edsiting patterns and behaviour, have effect on the amount of post-EDiting effort in an intertwined manner.
L'apport du traitement des données-temps issues d'u n stylo numérique pour l'analyse de tests d'évaluation
Notre recherche est une etude exploratoire sur le traitement et la representation des donnees, notamment temporelles, issues d'un stylo numerique. Dans ce papier nous etudions le cas du remplissage


Spreadsheet End-User Behaviour Analysis
The design and application of a novel data acquisition tool, which can be used for the unobtrusive recording of end-users mouse, keyboard and Excel specific actions during the debugging of Excel spreadsheets, and developed a "spreadsheet cell coverage feedback" debugging tool.
Beyond logging of fingertip actions: analysis of collaborative learning using multiple sources of data
In this article we discuss key requirements for collecting behavioural data concerning technology-supported collaborative learning activities. It is argued that the common practice of analysis of
Knowing what was done: uses of a spreadsheet log file
Spreadsheet use in educational environments has become widespread, likely because of the ‡exibility and ease of use of these tools. However, they have serious shortcomings if the teacher is to
An experimental study of people creating spreadsheets
It was found that experienced spreadsheet users spend a large percentage of their time using the cursor keys, primarily for the purpose of moving the cursor around the spreadsheet.
Uncovering effects of programming paradigms: Errors in two spreadsheet systems
The results show that the error behavior of novice spreadsheet users is systematically different between paradigms, and that the traditional spreadsheet calculation paradigm with the structured spreadsheet calculating paradigm that utilizes goals, plans and spreadsheet data structures in computation.
Teaching spreadsheet development using peer audit and self-audit methods for reducing error
A teaching approach has been devised which aids students to reduce their likelihood of making common errors during development by educating students in a set of structured, transferable skills for spreadsheet error-checking which are useful for increasing error-awareness in the classroom and for reducing business risk in the workplace.
Overview and main results of the DidaTab project
The main result is that the use of spreadsheet during secondary education is rather sparse for school work (and even more seldom at home) and that student competencies are weak.
Spreadsheet Knowledge and Skills of French Secondary School Students
A deeper investigation of students' work shows close links between lack of confidence with spreadsheets and lack of knowledge in mathematics and informatics.
An ethnographic study of distributed problem solving in spreadsheet development
In contrast to the common view of spreadsheets as “single-user” programs, we have found that spreadsheets offer surprisingly strong support for cooperative development of a wide variety of
Revising the Panko-Halverson taxonomy of spreadsheet errors