Business Research Methods Lab/SPSS Lab
The Database Lab is designed to graduate students to the foundations of database systems, focusing on basics such as the relational algebra, data model and transactions using SQL programming. The lab is well organized and equipped with sufficient numbers of systems that satisfy the curriculum requirements. The lab is sufficient to accommodate one system per student for each experiment. Sufficient number of systems is available keeping in mind the comfort ability to conduct each experiment.
Equipments/Configurations
- Dual core processor
- 2GB RAM
- 500 GB HDD
- 17” monitor
Software Used
- Ubuntu OS
- Windows XP OS
- IBM SPSS
List of Experiments
- Drawing frequencies using bar charts, histogram.
- Creating and editing graphs and charts.
- Bi-Variate Correlation.
- The t-test procedure.
- Non-parametric Tests : Chi-square Test.
- One way ANOVA Procedure.
Business Data Analysis Laboratory
Equipments/Configurations
- Dual core processor
- 2GB RAM
- 500 GB HDD
- 17” monitor
Software Used
- Microsoft Office 2007
- Ubuntu OS
- Windows XP OS
- IBM SPSS
List of Experiments
- An introduction to creating and formatting worksheets
- Applying formulas and functions
- Apply cell reference in formulas
- Applying conditional logic in a formula
- Apply name ranges in a formula.
- Apply cell ranges in formulas.
- Presenting Data Visually
- Introduction to Query Language( SQL DDL and SQL DML Commands )
- Getting data using Query Use of select statement to create data queries
- Use of SQL functions (aggregate functions, group functions etc.)
- Use of joins and sub queries
