Scheme & Syllabus Copy of Spreadsheet for Engineers-AEC 2022 scheme vtu notes
Experiment List - Spreadsheet for Engineers-AEC 2022 scheme vtu notes BME358C
List of Experiment Spreadsheet for Engineers
1. Charting
- Create an XY scatter graph
- Create an XY chart with two Y-Axes
- Add error bars to your plot
- Create a combination chart
2. Functions
- Compute Sum, Average, Count, Max, and Min
- Compute Weighted Average
- Use Trigonometric Functions
- Use Exponential Functions
- Use the CONVERT Function to convert units
3. Conditional Functions
- Explore Logical Expressions
- Use Boolean Functions
- Implement the IF Function
- Create a Quadratic Equation Solver
- Utilize the VLOOKUP Function
- Apply AND, OR, and XOR functions
4. Regression Analysis
- Add Trendlines
- Calculate Slope and Intercept
- Perform Interpolation and Forecast
- Use the LINEST Function
- Conduct Multilinear Regression
- Apply Polynomial Fit Functions
- Create a Residuals Plot
- Analyze Slope and Tangent
- Use the Analysis ToolPack
5. Iterative Solutions Using Excel
- Use Goal Seek in Excel
- Utilize the Solver to find roots
- Find Multiple Roots
- Perform Optimization using the Solver
- Conduct Minimization Analysis
- Perform Nonlinear Regression Analysis
6. Matrix Operations Using Excel
- Add Two Matrices
- Multiply a matrix by a Scalar
- Multiply Two Matrices
- Transpose a Matrix
- Invert a Matrix
- Solve System of Linear Equations
7. VBA User-Defined Functions (UDF)
- Explore the Visual Basic Editor (VBE)
- Implement the IF Structure
- Use the Select Case Structure
- Apply the For Next Structure
- Utilize the Do Loop Structure
- Declare Variables and Data Types
- Create an Array Function
- Understand the Excel Object Model
- Use the For Each Next Structure
8. VBA Subroutines or Macros
- Record a Macro
- Code a Macro
- Find Roots by Bisection
- Use Arrays
- Add a Control and create User Forms
Demonstration Experiments (For CIE)
1. Numerical Integration Using Excel
- Implement the Rectangle Rule
- Apply the Trapezoid Rule
- Use Simpson's Rule
- Create a User-Defined Function using Simpson's Rule
2. Differential Equations
- Apply Euler's Method
- Use Modified Euler's Method
- Implement the Runge-Kutta Method
- Solve a Second Order Differential Equation
