Spreadsheet for Engineers-AEC 2022 scheme vtu notes VTU University 3rd SEM Mechanical Engineering|BME358C notes

Scheme & Syllabus Copy of Spreadsheet for Engineers-AEC 2022 scheme vtu notes VTU University 3rd SEM Mechanical Engineering

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