Monday, August 16, 2010

Computing Expenditure Parametrically

Here we show how the students can fill in the spreadsheet parametrically. Hopefully students already have a basic understanding of Excel and in particular the difference between a relative and absolute reference. Here, that helps in distinguishing between a variable and a parameter. Getting students to make that identification would be useful. For students who don't have the prior knowledge of Excel, some introduction to these ideas is necessary or they will feel lost quickly. The assumption is here is that since this is an intermediate course students will already have that background.