Tag Archives: spreadsheet

Data- a Magical Solution

9 Dec

In education, we deal with a ton of data.  I can’t begin to count the number of hours I have used excel spreadsheets.  When I was in the classroom, my whole gradebook was in excel- everything calculated for each standard that I taught.  My first year I spent countless hours editting cells to show first name last name; last name, first name; first name middle intitial…. you get the idea.  I wished for an easier way to do that for each and every kid.  Now there is one.excel

Kirk Longhoffer posted on his blog about Magic/ Replace.  This tool will let you reformat large amounts of data.  See this video to understand. It could literally save to MANY hours of formatting time!