MS-EXCEL (Spreadsheet) Design & FunctionUsing any current (or recent textbook) that you have in any science or engineering course identify a mathematical relationship (or “model”) and design and develop an effective and functionalspreadsheet that provides graphical analysis of your chosen relationship / model that is easily modifiable(user-selected/entered parameters) and is informative and instructive as to the models behaviors.Your spreadsheet (MS-EXCEL: Macro-enabled workbook) should …• Give information on the model / relationship(s)• Clearly show user-modifiable inputs (cells)• Indicate fixed (or combinations) of units used/assumed (possible)• Provide graphical representation (with “engineering graph rules” correctly considered & followed!)• Provide a reference to source information (textbook, etc.)• Show validation information (as effectively as possible)
MS-EXCEL (Spreadsheet) Design & Function
Using any current (or recent textbook) that you have in any science or engineering course identify a mathematical relationship (or “model”) and design and develop an effective and functional
spreadsheet that provides graphical analysis of your chosen relationship / model that is easily modifiable
(user-selected/entered parameters) and is informative and instructive as to the models behaviors.
Your spreadsheet (MS-EXCEL: Macro-enabled workbook) should …
• Give information on the model / relationship(s)
• Clearly show user-modifiable inputs (cells)
• Indicate fixed (or combinations) of units used/assumed (possible)
• Provide graphical representation (with “engineering graph rules” correctly considered & followed!)
• Provide a reference to source information (textbook, etc.)
• Show validation information (as effectively as possible)
Step by step
Solved in 2 steps with 1 images
