SDA EXPERIMENTS
EXPERIMENT - 1
INTRODUCTION TO MS-EXCEL
AIM: The aim of experiment to understand the interface and features and basic functions
of MS- EXCEL & SPSS.
EXPLANATION: This experiment helps the students become familiar with the excel,
menu,toolbar, worksheet basic operations.
PROCEDURE: Open Excel or SPSS, Explore menu,create a worksheet,enter sample
data,and save the file.
OUTCOME: Understanding of basic excel or SPSS operations.
EXPERIMENT - 2
DATA ENTRY, EDITING & FORMATTING
AIM : The aim of experiment is to enter,edit & format data using Excel.
EXPLANATION: Proper data entry and formatting into accuracy & reliability.
PROCEDURE: Enter data use copy,cut, paste,apply formatting,headers & footers.
OUTCOME: Ability to create the well formatted data cells.
EXPERIMENT - 3
SORTING, FILTERING & DATA VALIDATION
AIM : The aim of this experiment is to organise data efficiently.
EXPLANATION: Sorting & Filtering help analyse large data sets validation avoids wrong
entry.
PROCEDURE: Apply sort,filter& data validation tools.
OUTCOME: Effective data organization skills.
EXPERIMENT - 4
CHARTS & GRAPHS
AIM : To represent data visually
EXPLANATION: Charts, Simplify,Data interpretation.
PROCEDURE: Create, bar,pie,line charts and analyze data.
OUTCOME: Better visual presentation skills.
EXPERIMENT - 5
PIVOT TABLES & PIVOT CHARTS
AIM : To summarise large data cells.
EXPLANATION : Pivot tables, helps in quick decision-making.
PROCEDURE: Insert pivot table, summarise data, create pivot chart.
OUTCOME: Advance data analysis skills. After creating the data ,create new worksheet.
EXPERIMENT - 6
MEASURE OF CENTRAL TENDENCY
AIM : To calculate MEAN , MEDIAN , MODE.
EXPLANATION: This measures shows the Central values of data.
PROCEDURE: Use Avg, Median, Mode functions.
OUTCOME: Understanding of AVG , behaviour of data.
EXPERIMENT - 7
CORRELATION OF C.F.
AIM : To calculate variance standard deviation & correlation of C.F.
EXPLANATION: Dispersion shows variability of data.
PROCEDURE: Use Var, STDEV function & Calculate C.V.
OUTCOME: Understanding of data validaty.
● VAR - Variance (How much the value differ from the mean).
● C.V. - Co-efficient of variance (measure, relation variability & useful for
comparison)
● STDEV - Standard Deviation (shows the dispersion of data around the mean).
VAR(--------)enter
STDEV(. ) enter
[Link]()/AVG() *100 enter
EXPERIMENT - 8
CORRELATION ANALYSIS
AIM : To find relationship between two variables.
EXPLANATION: Correlation measures the degree of association
PROCEDURE: Use CORREL
OUTCOME: Relationship analysis skills (show a positive relationship between two
variables)
So value may appear 0.99 or depends on data .
(It measures the degree of relationship between two variables 0-No-correlation).
EXPERIMENT - 9
REGRESSION ANALYSIS
AIM: To predict depended variable
EXPLANATION: Regression identifies cause or effective
PROCEDURE: Use data analysis tool bar regression.
OUTCOME: Prediction & interruption skills.
EXPERIMENT - 10
T - TEST
AIM : To test difference between two means
EXPLANATION: T- TEST checks significance of difference
PROCEDURE: Use data analysis tool pack ( t- test)
OUTCOME: Hypothesis testing skills
EXPERIMENT - 11
ANOVA - ONE WAY
AIM : To compare more than 2 group means
EXPLANATION: ANOVA checks overall significance
PROCEDURE: Use data analysis tool pack.
OUTCOME: Group comparison skills.
EXPERIMENT - 12
INDEPENDENCE OF ATTRIBUTE
AIM : To test independence of attributes
EXPLANATION: Used for categorical data.
PROCEDURE: Create Contingency Variable table apply chi-square test out as categorical
data analysis.
EXPERIMENT - 13
FORECAST FUTURE VALUES
AIM : To forecast future values
EXPLANATION: Time series identifies trends
PROCEDURE: Apply moving AVG & least square methods
OUTCOME: Forecasting ability.
EXPERIMENT - 14
CUSTOMISING THE QUICK ACCESS TOOL BAR
Next to the Microsoft office button is the quick access tool bar. The quick access tool bar
gives you with the access tool bar by default,save,undo.
Redo appears tool bar undo to roll back action rolled.
You can also add items to the quick access toolbar right click office button ribbon
& click. Add to click access together toolbar and shortcut be added.
EXPERIMENT - 15
CREATING AND USING TEMPLATES
Office button = new = template
A template in Excel is spreadsheets common data formatting option of sheet.
1). Formatting can include font & bank changes conditional formatting ,colour
changing available options .
2). Chart can added to template file formulas, lookup tables, functions and
macros.
STEPS TO CREATE A TEMPLATE IN EXCEL 2007
● Enter all of the necessary data.
● Add or remove the rows and columns
● Create formulas and charts and other options
● Apply charts, formulas formatting options.
TO SAVE THE TEMPLATE ONCE ALL CHANGES HAVE BEEN MADE BY YOUR
SPREADSHEETS
● Click on the office button
to open the drop down menu.
● Choose same as the option
● Choose the same to open to save the dialog box
● Click on the same as type option to open the drop down list
● Scroll through the list to find the template option
TEMPLATE OPTION
● Excel template (CLT x )
● Excel marco enabled template (CLT m)
● Excel 97.2003 templates (CLT )
● Choose the macro enabled template (CLT m) option
● Choose the Excel 97.2003 template (CLT )
● Choose the Excel template is stored template folder on your computer
ACCESSING YOUR TEMPLATES
● Click on the office button to open the drop down menu
● Click on the new option to open the new workbook dialog box
● Click on the my template options in the left hand pane dialog box
● Click on the temple you wish to open
● Click on the open the template in Excel.
EXPERIMENT - 16
WORKING WITH DATA
● ENTERING DATA
When entering data in to a worksheet type of the data in to the active cell. Press either
the enter tab key or the move on the next cell. Excel will recognise option to
automatically fill in your cell.
● EDITING DATA
To edit ddata that already exists in the work sheet you can select cell and information
any editing changes.
● COPYING AND MOVING DATA
1. Select the cell you wish to move.
2. Point to an outside border of the cell
3. Click and drag the cell to the new location
● INSERTING ROWS AND COLUMNS
1. Click on the row or column,where you want to insert the row and column.
2. Right click and select insert from menu.
● TO CREATE A CUSTOM FILL SERIES
1. Click the custom full excel tab on the menu bar and choose preference
2. Under formulas and list in highlighted make sure new list.
3. Click add and then OK.
● COPY
COPYING the data by using copy tab or Ctrl + C.
● CUT
CUT the data by using cut tab or Ctrl+X
● PASTE
Paste the copied or cutted data by using paste tab or Ctrl+V
● PASTE SPECIAL
Using the paste special dialog to copy complex items from a Microsoft Office
Excel Worksheet and Paste mathematical operation that you want to apply to copied
data.
EXPERIMENT - 17
FORMATTING DATA AND USER THE RIGHT MOUSE CLICK:
MINI TOOL BAR
A New feature in office 2007 is the mini [Link] is a floating toolbar that is
[Link] you selected right - click text.
It displays common formatting tools, such as fold, Italic, front size and font colour.
EXPERIMENT - 18
SAVING,PAGE SETUP AND PRINTING
● SAVE
This feature,allows you personalise how your workbook is [Link] can specify
● PAGE ORIENTATION
Through the page setup nenu,you may count your data orientation prints it horizontally.
You get more row and columns side you get more columns but fever rows.
● PAGE BREAKUP
When these page breaks appear dotted lines,which you can see by loading worksheet in
page break preview
● TO CHANGE ON EXISTING PAGE BREAKUP FOLLOW THE STEPS
1. Select normal from the view menu
2. The default page breakup fasted lines
3. Drag any of the dashed lines you want the page break to occur
● TO INSERT A NEW PAGE BREAK FOLLOW THE STEPS BELOW
1. Select the column to the left of where you want the page break to occur.
2. Select insert and page breaks
● COLUMNS & ROWS HEADINGS
1. Click the page out tab on ribbon
2. Select the rows or column
3. Click the select row/ column button
4. Click OK .
● PRINTING
1. preparation of spreadsheets for printing
2. Use the print tools to display the layout of your spreadsheet
3. After the page orientation to best display data
4. Insert , move and remove a page break
5. Apply the print title selec to your spreadsheet.
6. From the print dialog box ,click on the preview button