Learning What you Need

All Lessons you need to learn the skills to Achieve

Thursday, November 17, 2011

Bar Graphs -- XY Line Plot Graphs in Excel

My high school students are required to make Bar Graphs and XY Line Plot Graphs; others also, but these 2 are the most common.

I always start them out doing it the long way. For example, on the bar graph, they learn how to make the title on the left hand side read top to bottom, so the words are flipped. They learn how to merge cells and color them in with their favorite color (Yep, even completely blind students have favorite colors), change font, and anything else the other students are doing.

When they completely learn how to do the graphs the long way, I then show them the shorter way, where they only have to type in the numbers that are going to be plotted. They then only have to select the numbers and insert any type of graph they need. They then can color, change the font, title, lines, and anything else to make it represent exactly as the teacher has requested, but it is a computer generated graph that would be used for business. So they are learning future skills for employment too.

One of my student's paras had posed the question of how her student was going to do a bar graph the other day. When I showed them, the long and short way, she and the student were completely amazed. Even doing it the long way, which took about 4 minutes, and of course you can make the graphs look so beautiful and so readable for the blind student. When the student emailed off the assignment to the teacher, she was amazed too.

Lessons to help you learn
Excel and Bar Graphs

Watch Youtube virtual lesson on creating a graph. Dr. Robinson teaches using Virtual Instruction

1 comment:

tina said...

Great post.The importance of a braille translation being accurate and efficient can indeed not be overstated. Especially in the ever faster moving world of globalized business, successful information and technology transfer within multinational businesses can make the difference between win or lose.