Scribd
Upload
36 views3 pages

Institute of Management Education Research & Training - Pune Teaching Plan Semester: II Course: MBA Faculty Name: Pranav Kayande

(1) This document outlines the teaching plan for an Advanced Excel course taught during the second semester of an MBA program. (2) The course will cover topics like formatting data, creating formulas, using lookup and reference functions, and more. Students will learn through computer lab demonstrations and practice sessions. (3) The course is divided into 10 topics that will be covered over 3 class periods each, for a total of 30 class periods. Student progress will be evaluated through attendance, lab exams, online tests, and assignments.

Uploaded by

saurabh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
36 views3 pages

Institute of Management Education Research & Training - Pune Teaching Plan Semester: II Course: MBA Faculty Name: Pranav Kayande

(1) This document outlines the teaching plan for an Advanced Excel course taught during the second semester of an MBA program. (2) The course will cover topics like formatting data, creating formulas, using lookup and reference functions, and more. Students will learn through computer lab demonstrations and practice sessions. (3) The course is divided into 10 topics that will be covered over 3 class periods each, for a total of 30 class periods. Student progress will be evaluated through attendance, lab exams, online tests, and assignments.

Uploaded by

saurabh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

INSTITUTE OF MANAGEMENT EDUCATION RESEARCH & TRAINING - PUNE

TEACHING PLAN
Semester: II
Course: MBA

Faculty Name: Pranav Kayande

Subject: Advanced Excel


(213: CAPPT Computer Aided Personal & Productivity Tools)
Books recommended:
1. Excel Data Analysis by Jinjer Simon Wiley Publishing, Inc.
2. Microsoft Excel Functions & Formulas by Bernd Held, Theodor Richardson BPB Publications
Learning Outcomes of the Course:
1. Organize worksheet data using formatting, sorting, consolidating and filtration.
2. Create Formulas including conditional, text, date, statistical functions.
3. Apply data validation, protection.
4. Search using V Lookup, H Lookup and Index functions.

(1)

(2)

Sr. No.

Topic/ Unit

Range of Cells, Name a range,


Conditional Formatting

Learning Objectives

Working with cells and


ranges, conditional
formatting

(3)

(4)

Teaching Pedagogy
planned

Total No. of
lectures planned

Computer Lab demo


and practice session

Create and Sort List, Create Custom


Sort, Consolidate Data

Organize Worksheet data

Computer Lab demo


and practice session

Protect Worksheets, Filter List,


Create Custom Filter, Create
Advanced Filter

Protecting your work ,


Organize Worksheet data

Computer Lab demo


and practice session

Create Scenario, Validate Data ,


Evaluate Formula, Create
Conditional Formula

Evaluate Worksheet data,


Formula

Computer Lab demo


and practice session

V Look up , H Look up , Index

Look up and Reference


Functions

Computer Lab demo


and practice session

Production per hour, age of a


person, price reduction, fuel
consumption

Formulas

Computer Lab demo


and practice session

AND, OR, XOR , LEFT, RIGHT,


SEARCH, MID, EXACT etc

Logical & Text


functions

Computer Lab demo


and practice session

WEEKDAY, TODAY, TEXT,


NOW, DATE, MONTH etc
MAX, MIN, COUNT,
COUNTA,MEDIAN, STDEV
SUM,SUMIF,COUNTIF,
SUMPRODUCT, ROUND

Date & Time functions

Computer Lab demo


and practice session
Computer Lab demo
and practice session
Computer Lab demo
and practice session

9
10

Statistical functions
Mathematical functions

3
3

Continuous Evaluation Plan:


Attendance (15 marks)
Lab exam at the beginning of each lecture (20 marks)
Two Online Tests (5 marks each)
Assignment submission from home (5 marks)

Prepared by

Dr. Pranav Kayande


(Name and Signature of the faculty member)

Approved by

Dr. Shriram Nerlekar


(Name and Signature of the Director)

You might also like