Teaching Software Engineering Principles to K-12 Students: A MOOC on Scratch

There are many many tools, books, games and apps to teach children programming. But in our view they focus way to much on getting the programs to work, and too little on teaching children about software engineering skills: programming is a good way, free of code smells, and easy to read. To address this, we Read more about Teaching Software Engineering Principles to K-12 Students: A MOOC on Scratch[…]

VLOOKUP considered harmful

If you have worked with spreadsheets a bit, you must have encountered lookup functions. The most common one is the VLOOKUP, which can be used to couple two tables: What not everyone knows it that you can use LOOKUPs in another way as well, to classify data. That looks as follows: By default, Excel (and Read more about VLOOKUP considered harmful[…]

A modern day Pompeii: Spreadsheets at Enron

Update (1-15-2014): This paper is accepted at ICSE 2015 in the industrial track. Real spreadsheets needed From the day I got the idea of researching spreadsheets for my PhD dissertation, I needed access to ‘real life’ spreadsheets, those as really used within companies. I approached a number of companies and naively thought they would share a few Read more about A modern day Pompeii: Spreadsheets at Enron[…]

New paper: BumbleBee, a tool for spreadsheet formula transformations

Update: This paper will be presented at FSE 2014! Some spreadsheets can be improved While looking at spreadsheet and how they are used, over the past years I have noticed that many users don’t make their spreadsheets as easy as they could be. For instance, they use A1+A2+A3+A4+A5 instead of the simpler SUM(A1:A5) Sometimes because Read more about New paper: BumbleBee, a tool for spreadsheet formula transformations[…]

New Paper: Improving spreadsheet test practices

My first solo paper (without my PhD supervisor) ‘Improving spreadsheet test practices’ will be published at CASCON ’13 in Toronto. This paper explores the idea of applying testing to spreadsheets. Core idea The core observation I did for this paper is the fact that spreadsheet users do exhibit some basic testing. Many spreadsheet creator use formulas Read more about New Paper: Improving spreadsheet test practices[…]