**WEEK 1:**

a) To open MS
Excel and identify the Components of the Screen.

b) To create a
Workbook in Microsoft Excel and to save it.

**WEEK 2:**

To practice some MS Excel Basics.

a) To insert
Rows and Columns

b) To delete
Rows and Columns

c) Row height
Changing

d) Column
width Changing

**WEEK 3:**

To practice the features of the MS Excel like Gridlines,
VLookup, Index, Summation, and Auto fill.

**WEEK 4:**

To practice how to format the cells, text and conditional
formatting for the given data in Workbook of MS Excel.

**WEEK 5:**

To practice the built in Functions in MS Excel.

**WEEK 6:**

To practice Tables, pivot table, Ranges, Array formulae,
charts and Advanced chart Techniques.

**WEEK 7:**

To practice the Filters, Sorting, Totals & Sub-Totals,
Goal seek.

**WEEK 8:**

To practice how to create Multiple Windows, to Manage
Windows, to Splitting Windows, to freezing panes.

**WEEK 9:**

To practice how to Linking the data with the MS Access, to
import Multiple relation model, to record and access Macros.

**WEEK 10:**

To practice how to create Objects and Accessing Objects in R
Programming Language.

**WEEK 11:**

Write an R Program to perform the Arithmetic and Matrix
operations.

**WEEK 12:**

Write an R Program to manipulate the functions in R
Programming Language.

**WEEK 13:**

a) Write an R
Program to Read and Write the data.

b) Write an R
program to find the Fibonacci series with the help of ‘if’ and ‘while’
statements.

**WEEK 14:**

Plot the data by using the following functions

a) pairs(): scatter plot matrix

b) bar plot():
bar plots

c) box plot()’:
box-and-whisker plots

d) curve():
function plots

**WEEK 15:**

Write an R programs by using the Standard statistical models.

**WEEK 16:**

Write an R program to perform the Linear Regression and
Logistic Regression.

## No comments:

## Post a comment