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.
