Jul
8

How Merge Table Wizard for Excel saves countless hours for educators

Emily C Kern, math instructional specialist, explains how the Merge Table Wizard made her jobs simpler and less time-consuming

At the end of the 2008 school year, I wanted to see how much students in my class had improved on their state test scores. I had two spreadsheets from the district's data warehouse - one with my students' scores from 6th grade and one from that year's test. I had begun using Excel more that year and knew it could do the work to find the difference between the two scores to see if and how much of an impact I had made.

I worked between the two spreadsheets, cutting and pasting scores so I had a column on one spreadsheet for 6th grade and a separate column for 7th grade test scores. Although not difficult work, it was time-consuming and took me an hour or so to do that for all my classes (about 70 students). Once the data was entered, I used the formula function to subtract the 2 scores, and voila...I had a growth score for my students.

The next school year, my first as an instructional coach, I sat looking at two spreadsheets of the entire school - one was a list of every student on campus and their math teacher, the other was a list of all students' previous year's math test scores. I needed both pieces of information on one spreadsheet, and because the lists weren't identical (we had some students without test scores from the previous year), I couldn't simply alphabetize both lists and copy and paste the columns I needed. The prospect of moving between the two files to manually input that information for 1000 students was daunting, and I thought to myself, "there has to be a better way... "

Merge Table Wizard - quick way to merge two Excel spreadsheets

I began by searching Excel help to find a way to merge two spreadsheets and was surprised to find that there was no simple way to do this. I then Googled the same thing and came across Ablebits and the Merge Table Wizard. Although cautious about installing software that I don't know, the 15-day free trial was right in my price range, and I downloaded it to my laptop. Within 60 seconds, my two spreadsheets were merged. I was elated to see how simple the merge was to do exactly what I wanted.

A few seconds and data from 2 tables are merged perfectly!

Over the next 2 weeks, I used the Merge Table Wizard over and over to create spreadsheets that helped make my job, my principal's job, and my teachers' jobs simpler and less time-consuming. After my 15 day trial was up, I went to my principal and explained the program and how many hours of work had been saved by having it. She got out her own credit card and purchased the program for me on the spot (yes, I am very lucky to have such a principal).

I have now used Merge Table Wizard for 3 years, and I continue to tout its utility and ease to the administrators and coaches I work with. I simply could not do my job without it. It's one of the most useful and simple programs that helps me so I can spend my time analyzing the data instead of compiling it.

In my future blog posts, I will go into more detail about the types of data I compile for my school - data that is useful to administrators and coaches on a whole-school basis as well as ways that the Merge Table Wizard can be used to support individual classroom teachers as well.

You may also be interested in:



One Response to "How Merge Table Wizard for Excel saves countless hours for educators"

  1. calvin klein says:

    Is generally believed, comfortable cotton texture, many people do not buy non-cotton. According to staff, although the absorbent cotton underwear, but not easy to do, especially driving a private car and back, sweating men in order to avoid the sticky feeling, can choose to use quick-drying Korean silk fabrics, good absorbent, feel slippery cool. calvin klein http://www.roxie.com/rss.cfm

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com