Home: Part-I | Home: Part-II | Home: Part-III | Home: Part-IV | Home: BSc | Home: MSc | Curriculum: Current | Curriculum: Archive

*
***************

B.Stat. – 107: Numerical Methods, MS Excel and Programming with C++

 

 

Course Code

: B.Stat. – 107

Course Title

: Numerical Methods, MS Excel and Programming with C++

Course Type

: Related

Level/Term and Section

: B. Sc. Honours Part-I

Academic Session

: 2019 – 2020

Course Instructor

: NA

Pre-requisite (If any)

: HSC Higher Math, ICT and Computer Fundamentals

Credit Point (CP)

: 4

Total Marks

: 100

(Examination 80, Tutorial/Terminal 15, and Attendance 5)

 

COURSE DESCRIPTION:

This course is designed to enhance fundamental concept of MS Excel, computer programming with C++ and its application in statistics. Also, improve students expertise in numerical methods.

 

COURSE OBJECTIVES (CO):

Students would be able to

1)

develop  the basic concept of MS Excel and its uses in statistical methods.

2)

develop the basic concept of C++ programming language.

3)

design an algorithmic solution for a given problem based on C++ program

4)

further develop and apply problem solving skills in numerical methods by giving emphasize on non-linear equations, interpolation, differentiation, and integration.

 

COURSE LEARNING OUTCOME (CLO):

After successful completion of this course, a student will be able to

1)

understanding of foundation concepts, syntax and the process of problem solving using MS Excel;

2)

understanding of foundation concepts, syntax and the process of problem solving using C++
programming language;

3)

to write programs in C++ by using basic control structures (conditional statements, loops, switches, branching, functions etc.) ;

4)

ability to write C++ programs for simple applications of real life problems and Statistical computation;

5)

know how to implement numerical methods on the specific problem and  use of numerical methods in application to real problems.

 

 

….COURSE PLAN / SCHEDULE: 


CLO

Topics to be covered

Teaching-Learning
Strategies

Assessment
Techniques

No.
of lectures

1

MS Excel: History, Fundamental Concept, Data and File Management, Data Analysis, Building Macro, Linking with other packages, How it can be used in job Markets.

Lecturing
with Multimedia Projector, Interactive Board and Q/A session

Assignment,
Class Tests, Presentation, Final Exam.

7

2

&

3

Programming Fundamentals: History of C++, Importance of C++, Programming structure of C++, Constants, Variables, Keywords and identifiers, Data types, Operators, Type conversion in expression.

Decision Making and Looping: If statements, if-else statements, Nesting of if…else statements, else if ladder, switch statements, ?: Operator, goto statement, break and continue statements, while statement, do statement, for statement.

13

3

Arrays: Introduction, One dimensional array, Declaration of one dimensional arrays, Initialization of one dimensional arrays, Two dimensional arrays, Initialization of two dimensional arrays.

File Management in C++: Introduction, Defining and opening a file, closing a file, Input/output operations on files.

 

 

13

4

User-defined Function: Definition of functions, Function declaration, Category of functions, Recursion, Passing arrays to functions, Passing string to function. Introduction to Pointers, Structures and Union.

 

 

7

5

Numerical Methods: Accuracy of approximate calculation interpolation and extrapolation, Differences of a polynomial, Finite difference operator, Difference table, Difference equations, Interpolation- Newton’s forward, Backward, Central difference, Gauss’, Stirling’s and Bessel’s formulas, Inverse interpolation, Accuracy of interpolation, Numerical differentiation and integration, Accuracy of quadrature, Numerical solution of equations, Convergence of these methods and their inherent errors, Numerical solution of
simultaneous linear equations.

 

 

20

Assessment Strategy Evaluation Policy (Grading System) and make-up procedures: According to the ordinance.

Main Books Recommended:
 1) Balagurusamy, E. (2012). Programming in ANSI C. McGraw-Hill Education. [Trivedi]
 2) Frye C.D. (2010) Step by Step MS Excel. Microsoft Press, Wasington
 3) Scarborough, J. B. (1966). Numerical Mathematical Analysis, 6th ed., Johns Hopkins Press, Baltimore.

**

References:
 4) Kernighan, B.W. and Ritchie, D.M. (1998). Computer Programming in C. [Cheltenham]
 5) Kochan, S. G. (2015). Programming in C. Pearson Education.
 6) Press, W.H., W.T. Vetterling and S.A. Teukolsky (1992). Numerical Recipes in C, the Art of Scientific Computing, 2nd ed., Cambridge University Press, London.
 7) Schildt, H. (2003). C++: The complete reference. McGraw-Hill.
 8) Stoer, J., & Bulirsch, R. (2013). Introduction to numerical analysis (Vol. 12). Springer Science & Business Media.

********

Additional References:
 9) Burden, Richard L. and Faires, J. Douglas (2005). Numerical Analysis. [Solution]
 10) Sastry, S. S. (2012). Introductory methods of numerical analysis, PHI Learning Pvt.