OK, so I feel that the spreadsheet we created was a very very simple one. No doubt useful though. Most classes have assignments, quizzes, tests, etc all worth different percentages. The nice thing is excel can do all that. Say you are teaching high-school or middle-school, you are more then likely going to have at least 4 classes a day... maybe even up to seven.. who knows... You can make one row of formulas, click, drag, and boom... you know have ability to just insert grades and all the calculations are done for you. If your principle wants to know how many kids are failing, you make a lovely pie chart or even see the distribution of grades as a bell curve to see if you as a teacher are doing your job.
The book says you can you use excel for presenting, storing, and calculating. I think as far as presentation goes, its good to make aids, graphs, charts, figures, etc. But I feel that the presentation is best left up to PowerPoint. You can insert your charts, graphs, etc into the presentation though. I've always thought of excel as more of a calculator/data entry/data analysis tool. The data analysis comes in great handy in regards to science. Data as numbers can be fairly difficult to draw conclusions from, but as a graph of some sorts, it is much easier to visualize trends.
Assessing Meaningful Learning
13 years ago
John, send me that link.
ReplyDelete