Wednesday, 28 October 2015

Business Analytic Lab Experiments

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
e)      To print Worksheet

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.

Friday, 11 September 2015

week 1

Aim:  To open MS Excel, identify the Components of the Screen and to create a Workbook in Microsoft Excel and to save it.

Procedure:

Activity 1: To open MS Excel:-
Step1: Click start button on the task bar.
Step2: Go to All Programs.
Step3: Go to Microsoft Office.
Step4: Select Microsoft office Excel.

Output:

Result: MS Excel is opened successfully.


Activity 2: To identify the Components of the Screen of MS Excel:
Step1: Move the mouse pointer to ribbon.
Step2: place the pointer on each and every component.
Step3: check the component location and read the text displayed.

Output:






Result: Components of the Screen of MS Excel is identified successfully.


Activity 3: To create a Workbook in Microsoft Excel and to save it:

Procedure:
Enter the following data in the empty worksheet.
Step1: Type Monthly Sales details in cell A1.
Step2: Move the cell pointer to Down row cell (A3) and type the Headings like salesman names and month names (jan., feb.,).
Step3: Move the cell pointer to Down row cell (A4) and type name1 (raju), type the no of sales per month in next cells (B4, B5,…).
Step4: enter 10 salesman names and the sales count for 12 months.

Output:



Result: Workbook in Microsoft Excel is created and saved successfully.



Friday, 21 August 2015

INTRODUCTION TO BUSINESS ANALYTICS Syllabus copy

SRI VENKATESWARA COLLEGE OF ENGINEERING AND TECHNOLOGY (AUTONOMOUS)
L T P C
MBA-I SEMESTER
2 0 2 4
15CMB08 INTRODUCTION TO BUSINESS ANALYTICS
OBJECTIVES:
To develop an understanding of basic concepts of business analytics and its importance in managerial decision making.
To enable the students to make use of Ms-excel work sheets for business problem solving.
To outline the processes needed to develop, report, and analyze business data.
To introduce the students to R- programming and its applications.
OUTCOMES:
After completion of the course the students will be able to:-
Apply the tools and techniques of Business Analytics to solve business problems and improve the quality of decision making.
Illustrate the practices for scalable and reliable Excel based reporting and analysis solutions.
Compare the strengths and weaknesses of alternative strategies for collecting, analyzing and interpreting data.
Read, analyze and interpret the data using R-programming.
UNIT - I : MS-EXCEL: Basics of MS Excel- Overview of Toolbars- Gridlines- VLookup- Index- Formatting Cells- Summation – Autofill- Formatting Text – Conditional Formatting.
UNIT - II: ADVANCED TECHNIQUES: Functions- Array Formulae-Tables- Filters-Sorting-Totals-Subtotals; Managing windows- Multiple windows- Splitting windows; Tables-Range.
UNIT - III : TOOLS: Freezing panes-Linking data with MS-Access –Toolpack-Goal Seek- Pivottable-Import Multiple relation model-Charting- Macros – Chart – Advanced chart techniques:Break-even lines and waterfall charts - Pictures in chart columns Crystal report – Forms
UNIT - IV : INTRODUCTION TO THE R LANGUAGE: - SAS versus R - R, S, and S-plus - Obtaining and managing R -Objects- types of objects – classes; creating and accessing objects; Arithmetic and matrix operations; Introduction to functions.
MORE DETAILS ON WORKING WITH R - Reading and writing data - R libraries -Functions and R programming- the if-statement – looping for repeat- while-writing functions-function arguments and options.
UNIT - V : GRAPHICS: Basic plotting - Manipulating the plotting window -Advanced plotting using lattice - library - Saving plots. Standard statistical models in R :- Model formulae and model options - Output and extraction from fitted models- - Models considered - Linear regression: lm()– Logistic regression: glm().
TEXT BOOKS:
1.Jordan Goldneior. Advanced Excel Essentials.
2.John walkenbach. Excel 2013 Bible.
3.John walkenbach. Excel 2013 Power programming with VBA.
4.John chambers. Software for Data Analysis: programming with R(statistics and computing).
REFERENCES:
1.Conrad colberg. Productive Analytics : Micro Excel.
2.Bob umlas. Excel outside the box
3.Nina Zumel. Practical Data science with R.

Sunday, 14 June 2015

Testing security



Security testing is a testing technique to determine if an information system protects data and maintains functionality as intended. It also aims at verifying 6 basic principles as listed below:
·         Confidentiality
·         Integrity
·         Authentication
·         Authorization
·         Availability
·         Non-repudiation

Open Source/Free Security Testing Tools:
Product
Vendor
URL
FxCop
Microsoft
https://www.owasp.org/index.php/FxCop
FindBugs
The University of Maryland
http://findbugs.sourceforge.net/
FlawFinder
GPL
http://www.dwheeler.com/flawfinder/
Ramp Ascend
GPL
http://www.deque.com
Commercial Security Testing Tools:
Product
Vendor
URL
Armorize CodeSecure
Armorize Technologies
http://www.armorize.com/index.php?link_id=codesecure
GrammaTech
GrammaTech
http://www.grammatech.com/
Appscan
IBM
http://www-03.ibm.com/software/products/en/appscan-source
Veracode
VERACODE
http://www.veracode.com