a) To open MS Excel and identify the Components of the Screen.
b) To create a Workbook in Microsoft Excel and to save it.
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
To practice the features of the MS Excel like Gridlines, VLookup, Index, Summation, and Auto fill.
To practice how to format the cells, text and conditional formatting for the given data in Workbook of MS Excel.
To practice the built in Functions in MS Excel.
To practice Tables, pivot table, Ranges, Array formulae, charts and Advanced chart Techniques.
To practice the Filters, Sorting, Totals & Sub-Totals, Goal seek.
To practice how to create Multiple Windows, to Manage Windows, to Splitting Windows, to freezing panes.
To practice how to Linking the data with the MS Access, to import Multiple relation model, to record and access Macros.
To practice how to create Objects and Accessing Objects in R Programming Language.
Write an R Program to perform the Arithmetic and Matrix operations.
Write an R Program to manipulate the functions in R Programming Language.
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.
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
Write an R programs by using the Standard statistical models.
Write an R program to perform the Linear Regression and Logistic Regression.