I love what I do.

I love technology and education. Maybe you like knitting. Cool. My thing is educational technology.

Please feel free to leave a comment...

Don’t use excel for important work

Wednesday, May 28, 2014

Computer Science professor Daniel Lemire talks about why folks shouldn't use excel for important work.

Lemire states, "They [spreadsheets] are at their best when errors are of little consequence or when problems are simple.". He also writes (and I agree) "Spreadsheets make code review difficult. The code is hidden away in dozens if not hundreds of little cells… If you are not reviewing your code carefully… and if you make it difficult for others to review it, how do expect it to be reliable". When I get a spreadsheet from my business office, I spend more time understanding the formulas than I do the business problem.

I agree with Prof. Lemire's points, but I also see a language problem in changing. In short: people use spreadsheets because they are easy and accessible AND they lack computational thinking skills to build (write) a program in a more organized, coherent way. Probably, people "know" excel and there is a cost to learning and mastering something new.

In schools, I see excel spreadsheets being used to run virtually all parts of an organization (HR, accounting, purchasing, etc..). I think people use spreadsheets because they are easy and well supported, AND they do not know how to program.

I think Prof. Lemire's point is well said, and his post moves me to do more to help kids learn about programming and computational thinking.



Commenting is not available in this channel entry.

Avatar

Bill MacKenty, Chief Zuccini

I make a difference in the life of kids. You want to tell me what's more rewarding?

Avatar

Resume

This is my full resume. It has all my work experience since I graduated from college in 1992, including certifications, professional memberships, and descriptions of my work.

Avatar

Polish Resume

This is my full resume translated into Polish. My wife tells me it is a literal translation, and as such might convey a slightly different meaning to Polish speakers.