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: ECO1010 Module Title: COMPUTING FOR ECONOMICS II
Module Provider: Economics Short Name: EC113B
Level: HE1 Module Co-ordinator: BURROUGHS C Mrs (Economics)
Number of credits: 10 Number of ECTS credits: 5
 
Module Availability
Spring
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

To introduce students to the basic IT and computing skills needed for problem solving in economics and business, thereby forming the basis for computing and data analysis modules in Level 2. By taking examples from other Level 1 modules, the module aims to provide an integrated approach to the use of computing in problem solving.
Prerequisites/Co-requisites
None
Module Aims

To equip students to be able to analyse and solve business and economic problems using spreadsheets and to produce work to an acceptable level for the business environment.
Learning Outcomes
By the end of the module students will be able to analyse and solve business and economic problems taken from other level 1 modules using spreadsheets.
Module Content
The following is an indiction of the likely topics to be covered:-
  • Enter labels and values into the cells of the spreadsheet
  • Use formulae and functions appropriately for calculations
  • Format the layout of cells containing labels and values
  • Sort and filter data
  • Use relative and absolute cell referencing
  • Produce charts from spreadsheet data
  • Use logical arguments
  • Create pivot tables to analyse and summaries large amounts of data
  • Export data to other software applications
  • Save a spreadsheet
  • Print a spreadsheet
Methods of Teaching/Learning
Computer lab tutorials (12 hrs)
Selected Texts/Journals

Indicative reading:

  • Judge, G, Computing Skills for Economists, John Wiley, 2000
  • Microsoft Corp, Microsoft Excel Manual
  • Whigham, D. Quantitative Business Methods using Excel. OUP, 1998

    Applications of spreadsheets to economics can be found in Computers in Higher Education Economics Review, CIT Economics, Various Issues. Further applications will be found in the texts used in Principles of Economics (Micro and Macro), Mathematics for Economics and Statistics for Economics.

Last Updated

28 September 2010