Course objectives:
- To create different plots and charts
- To compute different functions, conditional functions and make regression analysis
- To carryout iterative solutions for roots, multiple roots, optimization and non-linear regression analysis
- To carryout matrix operations
- To Understand VBA and UDF
- To understand VBA subroutines and Macros
- To carryout numerical integration and solving differential equations using different methods
Experiments
1 Charting: Create an XY scatter graph, XY chart with two Y-Axes, add error bars to your plot, create a combination chart
2 Functions: Computing Sum, Average, Count, Max and Min, Computing Weighted Average, Trigonometric Functions, Exponential Functions, Using The CONVERT Function to Convert Units
3 Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Creating a Quadratic Equation Solver, Table VLOOKUP Function, AND, OR and XOR functions.
4 Regression Analysis: Trendline, Slope and Intercept, Interpolation and Forecast, The LINEST Function, Multilinear Regression, Polynomial Fit Functions, Residuals Plot, Slope and Tangent, Analysis ToolPack.
5 Iterative Solutions Using Excel: Using Goal Seek in Excel, Using The Solver To Find Roots, Finding Multiple Roots, Optimization Using The Solver, Minimization Analysis, NonLinear Regression Analysis.
6 Matrix Operations Using Excel: Adding Two Matrices, Multiplying a Matrix by a Scalar, Multiplying Two Matrices, Transposing a Matrix, Inverting a Matrix and Solving System of Linear Equations.
7 VBA User-Defined Functions (UDF): The Visual Basic Editor (VBE), The IF Structure, The Select Case Structure, The For Next Structure, The Do Loop Structure, Declaring Variables and Data Types, An Array Function The Excel Object Model, For Each Next Structure.
8 VBA Subroutines or Macros: Recording a Macro, Coding a Macro Finding Roots by Bisection, Using Arrays, Adding a Control and Creating User Forms. Demonstration Exercises
9 Numerical Integration Using Excel: The Rectangle Rule, The Trapezoid Rule, The Simpson's Rule, Creating a User-Defined Function Using the Simpson's Rule. .
10 Differential Equations: Euler's Method, Modified Euler's Method, The Runge Kutta Method, Solving a Second
11 Order Differential Equation
Course outcomes (Course Skill Set):
At the end of the course the student will be able to:
- To create different plots and charts
- To compute different functions, conditional functions and make regression analysis
- To carryout iterative solutions for roots, multiple roots, optimization and non-linear regression analysis
- To carryout matrix operations To Understand VBA and UDF
- To understand VBA subroutines and Macros
- To carryout numerical integration and solving differential equations using different methods
Assessment Details (both CIE and SEE)
- The weightage of Continuous Internal Evaluation (CIE) is 50% and for Semester End Exam (SEE) is 50%.
- The minimum passing mark for the CIE is 40% of the maximum marks (20 marks).
- A student shall be deemed to have satisfied the academic requirements and earned the credits allotted to each course.
- The student has to secure not less than 35% (18 Marks out of 50) in the semester-end examination(SEE).
Continuous Internal Evaluation (CIE):
CIE marks for the practical course is 50 Marks.
The split-up of CIE marks for record/ journal and test are in the ratio 60:40.
- Each experiment to be evaluated for conduction with observation sheet and record write-up.
- Rubrics for the evaluation of the journal/write-up for hardware/software experiments designed by the faculty who is handling the laboratory session and is made known to students at the beginning of the practical session.
- Record should contain all the specified experiments in the syllabus and each experiment write-up will be evaluated for 10 marks.
- Total marks scored by the students are scaled downed to 30 marks (60% of maximum marks).
- Weightage to be given for neatness and submission of record/write-up on time.
- Department shall conduct 02 tests for 100 marks, the first test shall be conducted after the 8th week of the semester and the second test shall be conducted after the 14th week of the semester.
- In each test, test write-up, conduction of experiment, acceptable result, and procedural knowledge will carry a weightage of 60% and the rest 40% for viva-voce.
- The suitable rubrics can be designed to evaluate each student’s performance and learning ability. Rubrics suggested in Annexure-II of Regulation book
- The average of 02 tests is scaled down to 20 marks (40% of the maximum marks).
The Sum of scaled-down marks scored in the report write-up/journal and average marks of two tests is the total CIE marks scored by the student.
Semester End Evaluation (SEE):
- SEE marks for the practical course is 50 Marks.
- SEE shall be conducted jointly by the two examiners of the same institute, examiners are appointed by the University All laboratory experiments are to be included for practical examination. (Rubrics) Breakup of marks and the instructions printed on the cover page of the answer script to be strictly adhered to by the examiners. OR based on the course requirement evaluation rubrics shall be decided jointly by examiners.
- Students can pick one question (experiment) from the questions lot prepared by the internal /external examiners jointly.
- Evaluation of test write-up/ conduction procedure and result/viva will be conducted jointly by examiners. General rubrics suggested for SEE are mentioned here, writeup-20%, Conduction procedure and result in -60%, Vivavoce 20% of maximum marks.
- SEE for practical shall be evaluated for 100 marks and scored marks shall be scaled down to 50 marks (however, based on course type, rubrics shall be decided by the examiners)
- Change of experiment is allowed only once and 15% Marks allotted to the procedure part to be made zero.
- The duration of SEE is 03 hours Rubrics suggested in Annexure-II of Regulation book
Suggested Learning Resources:
McFedries PaulMicrosoft Excel 2019 Formulas And Functions Microsoft Press, U.S, 2019 Edition