Entries Tagged with “excel”
How is your use of the technology innovative or different?
Blackboard allows me to share my Excel macros in a safe, efficient way that is easy for the students and me. The macros are very innovative and valuable to my students. These macros are “protected” so the students cannot accidentally delete crucial information, contain “buttons” that allow them to clear all old data before using the programs again, have color-coded tabs for “Information,” “Data,” “Results,” “Additional Information,” and “Credits.” All my macros are set up in the same format for ease of use. They go well beyond what is built into Excel. The package includes many statistical procedures that eliminate the necessity of students having to buy larger statistical programs in many cases. Examples include a basic statistical analysis macro for one-sample problems that yields approximately 70 statistical results for a given data set, a two-sample independent and dependent z-test and t-test macro, a chi-square test for normality macro, a test for independence and goodness of fit macro, a one-way ANOVA macro, a one-way ANOVA macro based on summary data taken from sources without the actual data base intact, a two-way ANOVA macro, a Treatment-by-Subjects macro, a Bivariate Correlation and Regression macro, a Two-Predictor Variable Regression macro, a Multiple Regression macro, a Statistical Process Control macro, as well as others.
— James Beatty, Information and Decision Systems