Thursday, August 16, 2007

Why Do I need to learn excel functions ? ? ?

Excel is a basic program that all business leaders should be able to use. Students find the functions themselves intimidating. Last term, I had a group of graduate students who added two numbers in different, nonadjacent cells, use the sum function just to add the two cells. It truly amazes me how many (graduate) students strictly type answers into excel, not even using the simple calculations. The instructions in functions are sometimes confusing. This assignment will require each student to become “an expert” at one function (from a given list of statistical functions) and require them to teach the rest of the class through a blog, including an example. Each other student will be required to use an example to show they understand 3 functions done by other students. The person who originally posted will be required to field questions.

3 comments:

Patricia Trow Parent said...

Rick,

What a great idea! The one thing that is not perfectly clear to me (assuming I am, for a minute, a student) is how do I become an expert at one function so that I may teach that function to another student?

DocMark said...

I firmly believe that students should know how these functions work. And the best way to understand the function is to be able to teach it.

charles north said...

rick:

I think exposing students especially business majors is an excellent idea. It is a great tool for any discipline and helps anyone to organize data in different formats.