MAT 110 - Computing

Syllabus for MAT 110 – Computing

This is a compulsory course for BS Mathematics students in their 1^st semester.

Credits (Lec:Tut:Lab)= 1:0:1 (One lecture hour and two lab hours weekly)

Prerequisites: None

Overview: This course provides an introduction to the programs Matlab and Microsoft Excel as tools for mathematical computing. The focus is on their use in applications from the fields of Statistics, Finance, Image Processing etc. Student presentations of assignment solutions will be a major component of the course.

Detailed Syllabus:

1. MATLAB:

• Arithmetic expressions, assignment, input and output, Boolean expressions, conditional statements
• For loop, while loop, nested loops, nested conditionals, vectors, elementary graphics, color schemes in Matlab
• Elementary math functions, Functions with multiple input parameters, plotting
• Two dimensional arrays, sorting, searching, cell arrays, cell arrays of matrices
• Working with image files

2. EXCEL:

• Charts
• Lookup, Match, Index, Offset functions
• Embedding form controls in a spreadsheet
• Array functions, Goal Seek, Solver
• Descriptive statistics with Analysis Toolpak

Main References:

1. Programming in Matlab for Engineers by Stephen J. Chapman, Cengage, 2011.
2. Guide to Matlab by Brian R. Hunt, Cambridge, 2001.
3. Microsoft Excel 2010: Data analysis and Business Modeling by Wayne L. Winston, Prentice Hall India.

Other References:

1. Mastering Matlab 7 by Duane C Hanselman and Bruce L Littlefield, Pearson Education, 2005.
2. Excel 2010 Formulas by John Walkenbach, Wiley India, 2011.
3. Favourite Excel 2010 Tips & Tricks by John Walkenbach, Wiley India, 2011.