cse 424
DESCRIPTION
IPTRANSCRIPT
Lovely Professional University, Punjab
Course Code Course Title Course Planner Lectures Tutorials Practicals Credits
CSE424 BUSINESS ANALYTICS LABORATORY 14597::Robin Prakash Mathur 0.0 0.0 2.0 1.0
Course Category Courses with Placement focus
TextBooks
Sr No Title Author Edition Year Publisher Name
T-1 Microsoft Excel 2010, Data Analysis and Business Modeling
Wayne L. Winston 1st 2010 Prentice Hall
Reference Books
Sr No Title Author Edition Year Publisher Name
R-1 Fundamentals of Business Analytics R. N. Prasad,Semma Acharya
1st 2011 Wiley
Other Reading
Sr No Journals articles as Compulsary reading (specific articles, complete reference)
OR-1 homepages.wmich.edu/~balik/AFS06Balik.pdf ,
OR-2 www.ibm.com/software/data/cognos/services/ ,
OR-3 http://www.labanswer.com/laboratory_analytics.asp ,
Relevant Websites
Sr No (Web address) (only if relevant to the course) Salient Features
RW-1 http://www.exinfm.com/free_spreadsheets.html free excel spreadsheet
RW-2 www.techonthenet.com/excel/formulas/vlookup.php Vlookup function
RW-3 office.microsoft.com/en-in/.../hlookup-function-HP010062411.aspx hlookup function
RW-4 www.mrexcel.com/articles/excel-vlookup-index-match.php index function
RW-5 www.excel-examples.com/microsoft-excel-text-functions.htm text function
RW-6 www.excel-examples.com/microsoft-excel-text-functions.htm date function
RW-7 http://www.princeton.edu/~otorres/Excel/excelstata.htm descriptive statistics
RW-8 http://support.microsoft.com/search/?adv=1 Microsoft support
Detailed Plan For Practicals
Practical No Broad topic (Subtopic) Practical Description Learning Outcomes Equipment Used
Practical 1 Ranges and Look up function(Vlook up function)
vertical lookup function help to find specific information in large data tables
MS EXCEL 2010
Practical 2 Ranges and Look up function(Hlook up function)
horizontal lookup function help to find specific information in large data tables
MS EXCEL 2010
Practical 3 Index and Match function(Excel index function)
indexing in excel To find a value based on multiple criteria
MS EXCEL 2010
Practical 4 Index and Match function(Excel match function)
match function how to use match function in large spreadsheet
MS EXCEL 2010
Practical 5 Text and date function(Format text) operation on text in excel TRIM, REPT, CONCATENATE, MID and FIND.
MS EXCEL 2010
Practical 6 Text and date function(Today, Now and various date commands)
various date function day , date, networkdays, etc functions MS EXCEL 2010
Practical 7 Optimization and Summarizing data using excel(Histograms)
How to create a Histogram in Excel analyzing the data in histogram form MS EXCEL 2010
Practical 8 Optimization and Summarizing data using excel(Descriptive statistics)
Instructions for Calculating Descriptive Statistics in Excel
mean,mode,median, standard deviation MS EXCEL 2010
Practical 9 Optimization and Summarizing data using excel(Descriptive statistics)
Instructions for Calculating Descriptive Statistics in Excel
mean,mode,median, standard deviation MS EXCEL 2010
Practical 10 Data analysis operations(Pivot and slice operation)
Operations like slice, dice and pivot of OLAP
Can visualize the OLAP operations MS EXCEL 2010
Practical 11 Data analysis operations(Roll up and drill down operation)
Roll up and drill down operations of OLAP
how to make summarized and detailed data
MS EXCEL 2010
SPILL OVERPractical 12 Introduction to Multiple Regression Data prediction MS EXCEL 2010
Practical 13 Modeling Exponential Growth To model the growth of a company’s revenue over time
MS EXCEL 2010
*Each experiment of the lab will be evaluated using following relative scheme:
Component % of Marks
J/E 50
WR 20
VIVA 30