CAPP08006 2022 Big Data / Advanced Excel
The module will introduce a range of tools and techniques that can help business professionals uncover important information and make informed decisions based on data. It will introduce basic concepts and approaches of Quantitative Methods and will enable students to solve problems and make decisions using various statistical tools. It will empower students to leverage descriptive statistics and understand basic data visualisation techniques
Learning Outcomes
On completion of this module the learner will/should be able to;
Demonstrate an awareness of prominent survey designs and sampling strategies
Use a wide range of spreadsheet functions used in a business environment
Effectively use hypothesis tests for decision making.
Carry out statistical analyses for both cross-sectional and longitudinal data types.
Perform calculations for measures of correlation and regression.
Engage with various analytical online tools and platforms to understand key business metrics.
Teaching and Learning Strategies
The student will engage with the content of the module through lectures and tutorials.
The student will develop and apply their learning through practical examples and case studies.
Module Assessment Strategies
First assessment is a report that features a descriptive summary of data.
Second assessment is a complete insurance statistical report.
Repeat Assessments
Report based repeat assessment.
Indicative Syllabus
1. Sampling: Use random and non-random sampling methods, procedures to be followed in conducting a sample survey.
2. Central Tendency Statistics, Standard Deviation and Time Series.
3. Draw scatter diagrams. Calculate linear regression coefficients, calculate measures of correlation, use the regression line for prediction.
4. Hypothesis Testing: One-Sample Tests of Hypothesis.
5. Navigation and interpretation of website and social media analytical online tools and software.
6. Spreadsheet applications: Use a wide range of spreadsheet functions used in a business environment.
Coursework & Assessment Breakdown
Coursework Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | Continuous Assessment 1 - Descriptive Report | Coursework Assessment | Assessment | 25 % | OnGoing | 1,2,3,4 |
2 | Continuous Assessment 2 - Full Report | Coursework Assessment | Assessment | 75 % | End of Semester | 1,2,3,4,5,6 |
Full Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Lecture | Online | Lecture | 1.5 | Weekly | 1.50 |
Tutorial | Online | Tutorial | 1 | Weekly | 1.00 |
Tutorial | Offsite Facility | Face to Face Tutorial | 3 | Twice Per Semester | 0.40 |
Independent Learning | Not Specified | Independent Learning | 4 | Weekly | 4.00 |
Required & Recommended Book List
2019-04-15 Microsoft Excel 2019 Data Analysis and Business Modeling Microsoft Press
ISBN 1509305882 ISBN-13 9781509305889
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables-and how to effectively build a relational data source inside an Excel workbook.
![](http://ecx.images-amazon.com/images/I/41fysZn9-ML._SL75_.jpg)
2010-02-01 Basic Statistics for Business and Economics McGraw Hill Higher Education
ISBN 0073401781 ISBN-13 9780073401782
This title covers the essential topics of statistical tools and methods. The concepts are illustrated with solved applied examples. Modern computing tools and applications are introduced, but the text maintains a focus on presenting statistics content rather than technology or programming methods.
![](http://ecx.images-amazon.com/images/I/51Gon4G87kL._SL75_.jpg)
2008 Basic Business Statistics 12th Edition
ISBN 0132168383 ISBN-13 9780132168380
![](http://ecx.images-amazon.com/images/I/41H7huNUPML._SL75_.jpg)
2012-07-12 Predictive Analytics: Microsoft Excel Que Publishing
ISBN 0789749416 ISBN-13 9780789749413
Excel predictive analytics for serious data crunchers!
The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. You dont need multimillion-dollar software: All the tools you need are available in Microsoft Excel, and all the knowledge and skills are right here, in this book!
Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.
Youll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA codemuch of it open-sourceto streamline several of this books most complex techniques.
Step by step, youll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, youll gain a powerful competitive advantage for your company and yourself.
Learn both the how and why of using data to make better tactical decisions
Choose the right analytics technique for each problem
Use Excel to capture live real-time data from diverse sources, including third-party websites
Use logistic regression to predict behaviors such as will buy versus wont buy
Distinguish random data bounces from real, fundamental changes
Forecast time series with smoothing and regression
Construct more accurate predictions by using Solver to find maximum likelihood estimates
Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation
Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning
![](http://ecx.images-amazon.com/images/I/51ZxIqqFHTL._SL75_.jpg)
2013-03-04 Excel 2013 Bible Wiley
ISBN 1118490363 ISBN-13 9781118490365
Excel at Excel with the help of this bestselling spreadsheet guide
John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.
Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.
- Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013
- Provides essential coverage of all the newest features of Excel 2013
- Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
- Features a website that includes downloadable templates and worksheets from the book
Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
Module Resources
Reading list available through Library
- See Moodle VLE
- https://support.google.com/analytics
- https://www.facebook.com/help
- https://support.twitter.com/
- https://help.linkedin.com/app/home