IT Application – II

Uses of various mathematical functions; Performing calculations by using the SUM, MIN, MAX, COUNT and AVERAGE functions; Performing conditional operations and logical operations by using the IF, SUMI, COUNTIF.

Import, transform, combine, display and connect to data; Consolidate data; Perform what-if analysis by using Goal Seek and Scenario Manager; Look up data by using the VLOOKUP and HLOOKUP function; Working with data analysis toolkits for descriptive statistics, regression, correlation, exponential smoothing and moving average; Uses of solvers; Basic uses of R and Python for data analysis.

Create Pivot Tables; Modify field selections and options; Group Pivot Table data; Add calculated fields; Salient features of data visualization with Pivot Charts; Manipulation in Pivot Charts; Applying styles to Pivot Charts; Drill down into Pivot Chart; Concept of dashboard and its uses in data visualization. Uses of ggplot2 in R and Matplotlib in Python.

Importance of social media; Precautions in social media communication; Professional networking and personal branding using social media; Understanding cyber threats and its preventions.

Introduction to IT-based business systems; Impact and future of IT in business organization, Overview of digital marketing, virtual reality and AI in business; Salient features of Transaction Processing System (TPS), Management Information System (MIS) and Decision Support System(DSS); Business case analysis on the uses of IT.