Data Analysis using Excel and Python
Teacher
Amit Kumar
Category
Core Courses
Course Attendees
Still no participant
Course Reviews
Still no reviews
Code(Credit) : CUTM1241 (0+2+2)
Course Objectives
- To build a strong understanding on the Basics of Excel and Python
- To understand data crunching and data presentation
Learning Outcomes
| Course Outcome | Program Outcome Mapped |
| 1. To create dynamic reports by mastering one of the most popular tools in excels - PivotTables, Pivot chart, If, Vlookup, Index, and Match etc. | PO3 - Problem-Solving and Innovation
PO2- Critical Thinking and Analytical skills
|
| 2. To do different operation in python with set, dict. tuples, list etc | PO3 - Problem-Solving and Innovation
PO2- Critical Thinking and Analytical skills |
Course Syllabus
Module 1 - Introduction to Excel
Course objective, outcome, methodology and assessment, Excel Introduction, , Basic Navigation Tab, Concept of Cell and Cell address , row Column concept, Sum, SumIf, Sumifs, Count number, CountA (Text and Number), Count if, Countifs, Average, AverageA, Averageif, Averageifs
Module 2 - Understanding different Formula
Round, Roundup, Round Down, Concatenate, Min, Max, Trim, Lower,Upper, Proper,Left, Right, Mid,,Exact, Randbetwen, Rand, Len (Length of character) Paste special, SQRT, If function with Example of IF, More function like And, OR with their example, Conditional Formatting basic and advance level with OR, AND, Nested IF function, Index, Offset, Match
Module 3 - Data analysis and Data presentation
Vlookup, Hlookup, Trace Precedents, Trace Dependents, show formula, Text to Column, Data Validation, Filter,Duplicate Removal, Sort, Filter, Wrap Test, What if Analysis, with detail example Merge Cell, Shapes, Median, Mode, Slandered Deviation (S), Correlation, Large, Small, Pivot Table, Pivot Charts, Slicing, Sparkling
Module 4 - Python Basics
Data Types, Loops, Inbuilt functions,List, Tuples, Dictionary,IF, Else, Numpy one Dimensional, Numpy two Dimensional. Loading and working on data with Python
Project -
Preparation of automated attendance sheet
Preparation of Dashboard
Numpy One Dimensional and two Dimensional Array
Case study - GTIDS csp payout
Online Reference links -
https://www.youtube.com/watch?v=L3-uVawPLKc
https://www.youtube.com/watch?v=RdTozKPY_OQ&t=192s
https://www.youtube.com/watch?v=rBuiBNZWjE4&t=1511s
Session Plan
Session 1
Course objective, outcome, methodology and assessment, Excel Introduction, , Basic Navigation Tab, Concept of Cell and Cell address , row Column concept
Session 2
Sum, SumIf, Sumifs, Count number, CountA (Text and Number), Count if, Countifs, Average, AverageA, Averageif, Averageifs
Session 3 (Practice)
Practice -
Students Demonstration
Session 4
Round, Roundup, Round Down, Concatenate, Min, Max, Trim, Lower,Upper, Proper,Left, Right, Mid,,Exact, Randbetween, Rand, Len (Length of character) Paste special, SQRT, If function with Example of IF, More function like And, OR with their example
Session 5 (Practice)
Practice -
Students Demonstration
Session 6
Internal Test - 1st
Session 7
Conditional Formatting basic and advance level with OR, AND, Nested IF function, Index, Offset, Match
Session 8 (Practice)
Practice -
Student’s demonstration
Session 10
Vlookup, Hlookup, Trace Precedents, Trace Dependents, show formula
Session 11
Text to Column, Data Validation, Filter,Duplicate Removal, Sort, Filter, Wrap Test, Merge Cell, Shapes
Session 12
Internal Test - 2nd
Session 13
Excel Quiz-
Class will be divided into 3-4 broad groups and quiz will be conducted.
(Each group has to prepare 10 short practical questions before the quiz day to play)
Session 14 (Practice)
Practice -
Student’s demonstration
Session 15
Pivot Table, Pivot Charts, Slicing, Sparkling
Video for Pivot Table
https://www.youtube.com/watch?v=4PWVFBiFVVU
Video for Pivot Chart
Session 16 (Practice)
Practice -
Student’s demonstration
Session 17
Median, Mode, Slandered Deviation (S), Correlation, Large, Small,
(Brief discussion on Dashboard presentation, and group allocation.)
Session 19
Project -
Preparation of automated attendance sheet (To be submitted in a week Time)
Session 20 (Practice)
Practice -
Student’s demonstration
Session 21 - 25
Project-
Dashboard Presentation
Session 27
Data Types of Python - Int, String, Float, None, Boolean
Session 37
Session 42 (Practice)
Session 49 and 50
Project Presentation
Our Main Teachers