Excel for Math Classes: Linear Transformations w/Graphics

Illustrates some of the mathematics behind computer graphics. Shows rotations, shears, and dilations. Excel level: Advanced (uses a scroll bar). Math Level: College. Note: this spreadsheet creates macros. If you create a similar one, you'll have to lower your security level or create a digital certificate in order to open your own file.

Category:

Education

Tags:

• linear
• transformations
• excel
• matrix
• rotation
• shear
• dilation
• math
• class
• scroll
• bar
• slider

[Novecento]

Thanks a lot! Great video! I was struggling to find a way to graph 3d matrix rotation. Can you please tell me how you set the the negative cartesian axis by default? Cause I can only the positive axis when my vector has positive values. Thanks.

[dborkovitz]

@Novecento By default the axes can't be negative -- that's a pain, but you can use the workaround that I show in the video.

[ycshea]

Thank you. This is a great video to make excel for teaching

[dborkovitz]

@ycshea  you're welcome. Glad you liked it!

[dborkovitz]

That's great. You're welcome.

[ratulloch1]

great video

[desoccerlover]

Thanks. I was working on shear transformations on special relativity and it helped a lot.