A collection of useful Excel and science/engineering related links that I have discovered/rediscovered recently:
Craig Hatmaker’s Beyond Excel:
Everyone knows Microsoft Excel is a powerful data mani-pulation engine, but data lives in databases and only a few Excel experts know how to exploit this natural synergy.
snb’s VBA for Smarties:
This website is dedicated to the use of Visual Basic for Applications (VBA). VBA is the programming language of Microsoft’s Office and all other software that makes use of it.
VBA has therefore a large amount of ‘libraries’. Every library contains methods that are specifically suited for each program.
There’s also a specific VBA library,that contains methods that can be used by every VBA-fit program.
VBA offers opportunities to communicate between software: from one program you can give instructions to another using VBA. Task integration is a VBA benefit that can’t be achieved using the User Interface.
“The idea is simple: to publish all of our course materials online and make them widely available to everyone.”
Dick K.P. Yue, Professor, MIT School of Engineering
And a collection from Alfred Vachris:
This short primer on Python is designed to provide a rapid “on-ramp” to enable computer programmers who are already familiar with concepts and constructs in other programming languages learn enough about Python to facilitate the effective use of open-source and proprietary Python-based machine learning and data science tools.
These are some mathematics investigations I have pursued over the years. They may be of some interest to teachers, students, or hobbyists. I try to convey a conceptual understanding, usually without rigorous proof. Some of the lessons are accompanied by questions and suggestions for extensions.