Value added Course
Memorandum of Understanding:
- With MathLab Research
The Department signed an MoU with MathLab Research, a company that provides industrial, product development and exposures to mathematics aspirants through industrial projects, trainings and Add-on courses. 2 value added courses are offered by the Department with this collaboration, for undergraduate students. They are:
- COURSE 1: BASICS OF STATISTICS USING MICROSOFT EXCEL
BASICS OF MICROSOFT EXCEL
Name of Course : BASICS OF MICROSOFT EXCEL
Offered by :
Course Coordinator :
Board of Studies
Chairperson :
Members :
Duration: 1 Semester
Total Lecture hours: 30
Aim of Course: To understand the spreadsheet software Microsoft Excel, and to enter, edit, format and analyze data using Excel.. To construct formulae, create and modify charts in Excel.
Program Specific outcome
- To understand the spreadsheet software Microsoft Excel
- To Arrange and analyze data in MS Excel
Suggested Methodology of Teaching and Learning
- Online/Offline classes
- Practical sessions on Excel
- Practicing analysis of various data in Excel
Evaluation
| ASSESSMENT | Marks | Qualification Marks |
| Assignments | ||
| MCQ Examination |
Name of Add-on Course : Basics of Microsoft Excel
| Duration | Course Code | Hours Per Week | Modules | Exam hours |
| 30 hours | MLCMSE | 3 | 2 | 1 |
Course Outcomes
| CO1 | Understanding Excel and its interface |
| CO2 | Entering data in Excel and its analysis |
Syllabus
Module 1- Introduction to Excel
Introduction- Uses of Excel- How to access- how to open- Applications Features
Understanding excel- Column- Row- Cell- Formula bar- Ribbon Customizing Ribbon- Worksheet and workbook- Shortcuts- Save options
Module 2- Data entry and Analyzing
Entering data in different Formats- Auto fill- Splitting Data- Transpose of data- Sort and filter- Tables
Analyzing data using charts, pie diagrams, bar diagrams etc.- Recommended Charts- Pivot Tables
| Teaching Plan | ||
| No | Topic | No. of
Lectures (30) |
| 1 | Module 1– Introduction to Excel | 3 |
| 1 | Uses of Excel- How to access- features | 1 |
| 2 | Interface- task bars, rows, columns, basic shortcuts | 2 |
| 2 | Module 2- Data entry and analyzing | 17 |
| 1 | Entering Data, Autofill, Flash fill | 2 |
| 2 | Text to column | 1 |
| 3 | Transpose of Data | 1 |
| 4 | Sorting data | 1 |
| 5 | Filter | 2 |
| 6 | Tables | 3 |
| 7 | Data bars | 1 |
| 8 | Charts, Sparklines | 2 |
| 9 | Recommended Charts | 2 |
| 10 | Pivot Tables | 2 |
Course 2: MATHEMATICAL TYPESETTING WITH LATEX
MATHEMATICAL TYPESETTING WITH LATEX
Name of Course
Offered By
Course Coordinator :
: MATHEMATICAL TYPESETTING WITH LATEX
Chairperson
Members
Aim of Course
Board of Studies
Program Specific outcome
- To learn the typesetting Program LATEX
- To create a scientific research paper or project using LATEX
- To create presentation in beamer.
Suggested Methodology of Teaching and Learning
- Online/Offline classes
- Practical sessions on LATEX
SYLLABUS
MODULE 1: INTRODUCTION TO LATEX
Introduction, Online and offline software for LATEX, Into LATEX window, LATEX Document-Preamble and Document Environment
MODULE 2: MODIFYING TEXT IN LATEX
Font size, Font Styles, Use of Parenthesis, Text Emphasis, Font Families, Text Alignment, Line breaks, indentation, Quotes, Dashes, Special Symbols, Page Format
MODULE 3: TYPESETTING MATHEMATICS IN LATEX
Math modes, Mathematical Notations, Fractions, Superscript and subscript, Parenthesis, Greek Symbols, Blackboard font, Tables and arrays, Tabular environment, Array, Merging columns.
Calculus Notations, Logical Operators, Dots, Theory, Abstract Algebra
MODULE 4: PRESENTATION IN BEAMER
Frames, creating slides, Navigation, Multiple coloumn, Pause, Blocks, Themes, Specification overlay, Table of content.