University of Surrey - Guildford
Registry
  
 

  
 
Registry > Module Catalogue
View Module List by A.O.U. and Level  Alphabetical Module Code List  Alphabetical Module Title List  Alphabetical Old Short Name List  View Menu 
2010/1 Module Catalogue
 Module Code: ECO2041 Module Title: BUSINESS DATA ANALYSIS
Module Provider: Economics Short Name: ECO2041
Level: HE2 Module Co-ordinator: NEWMAN ME Mrs (Economics)
Number of credits: 10 Number of ECTS credits: 5
 
Module Availability
Autumn
Assessment Pattern
Unit(s) of Assessment

Weighting Towards Module Mark (%)
Coursework

100

Qualifying Condition(s)
A weighted aggregated mark of 40% is required to pass the module.
Module Overview
Analytical and report writing skills are valued by all employers.  Economists analyse data to form opinions and draw conclusions about how a market or the economy works. Decisions based on this analysis can then be taken about how economists (or their clients) should act so as to optimise their position. The purpose of this module is to teach data manipulation and analysis using Excel so that students are able to prepare concise written reports of their analysis and findings. Therefore, during the module students will be exposed to a variety of different web based data sources. Using the spectrum of tools and formulas available in Excel you will analyse the relationships that exist between market variables and report on your findings.
Prerequisites/Co-requisites
None
Module Aims
The purpose of this module is to teach data manipulation and analysis using Excel so that students are able to prepare concise written reports of their analysis and findings. During the module students will be exposed to a variety of different web based data sources. Using the spectrum of tools and formulas available in Excel you will analyse the relationships that exist between market variables and report on your findings.
Learning Outcomes
By the end of the module students will:-
  • Be familiar with a variety of web-based data sources
  • Understand and use proficiently a number of in-Excel formulas and functions for data analysis
  • Use these techniques to solve problems and as the basis of decision making and report writing.
Module Content

Web based data sources

Tools for Analysis : Charts and  Excel commands I

Report writing

Tools for Analysis : Charts and  Excel commands II

Web based data sources II

Tools for Analysis: Formulas

Tools for Analysis : Functions

Tools for Analysis : What if analysis using Solver
Report Writing II
Methods of Teaching/Learning
Computer Lab sessions (20 hrs)
Selected Texts/Journals
No specific text used
Last Updated
04 October 2010