Computer Application for Management

Course Objective

Faculty : Dr. Sachin Sharma (Ph.D. M.Tech.)

The course is designed with the objective of delivering to the students, the essential skillset related to MS Office, including its various components. The most essential components include MS Word, MS Power Point, MS. Excel and MS Power Point. It also covers MS Access and MS Outlook to certain extent. The course also gives the students some brief outline of Computer Network Architecture, particularly of the current internet. The course also introduces the students to the basis of Web Application Development using HTML, CSS, JavaScript and PHP. The course also outlines to develop a professional website using WordPress. However, the focus is on enhancing managerial skills to fulfill environmental responsibilities with business success.

Computer Application for Management - Leaning Outcomes

Computer Application for Management

Leaning Outcomes

  • To familiarize the students with MS Office components
  • To familiarize the students with formatting options in MS Word, Excel formulas and PPTs.
  • To enable the students to develop strategies for dealing with new/uncertain environments
  • To enable the students to develop environmental friendly business winning strategies.
Computer Application for Management-Teaching Methodology

Teaching Methodology:

An integrated teaching model based on the following tools:

  • Online/offline class room training
  • Teacher’s notes, researches and personal discussions
  • Problem based/enquiry based learning
  • Group discussions
  • Presentations
  • E learning
  • Independent study
  • Viva/Quiz
  • Assignments
  • Mini projects/Case studies

Session Plan

Course Content

Session No. Topics Hours
1 Overview and the Scope of the Course 1 hr 15 min.
2 Introduction to Ms Office, The applications of various components of MS Office 1 hr 15 min.
3 Formatting options in MS Word. 1 hr 15 min.
4 Basic Formulas in MS Excel 1 hr 15 min.
5 Advanced Formulas in MS Excel 2 hr 30 min.
6 Professional Presentation design in Power Point 2 hr 30 min.
7 Introduction to Google Sheet 1 hr 15 min.
8 Introduction to Google Forms 1 hr 15 min.
9 Google Forms / Triggers and Google Script 2 hr 30 min.
10 Introduction of Computer Network 1 hr 15 min.
11 Network Architecture- Circuit and Packet Switched 1 hr 15 min.
12 World Wide Web 1 hr 15 min.
13 Web Application Components-HTML / CSS 2 hr 30 min.
14 Web Application Components- JavaScript and PHP 2 hr 30 min.
15 Web Application Components- Databases 2 hr 30 min.
16 Web Application Components- SQL 2 hr 30 min.
17 Web Application Components-Content Management Systems 1 hr 15 min.
18 Introduction to AI and Machine Learning 2 hr 30 min.
19 Introduction to Programming languages for Statsitics 1 hr 15 min.
20 Introduction to Tabeau 1 hr 15 min.
21 Introduction to R 2 hr 30 min.
22 Introduction to Alteryx 1 hr 15 min.

Reference Books:-

  • Easy Microsoft Office 2010 1st Edition, Kindle Edition by Tom Bunzel
  • Step by Step Microsoft Office Professional 2010, Joyce Cox, Joan Lambert and Curtis Frye.
  • Computer Networks, Kruse Ross
  • Web Development: Learn HTML, CSS, JavaScript, PHP, MYSQL and WordPress for Beginners: Learn Basics of Web Development by Learning HTML, CSS, JavaScript for Absolute Beginners (Release Book 1) Kindle Edition by PHPBootcamp DotCom