QUSU06040 2019 Information Communication Technology in Quantity Surveying
This module explores the functions of spreadsheets required by the Quantity Surveyor / Estimator.
On completion of this module the learner will/should be able to;
Identify the basic principles of spreadsheets and evaluate the various functions and formulae
Compile charts on spreadsheets using different forms of cost and time data
Develop a tender assessment template using spreadsheet to include identification of highest value, lowest value and averages
Compose a basic estimate taking account of measurement of a basic building and inputting a schedule of quantities and rates
Formulate a payment certificate by applying rates, prices and percentages from a payment application
Teaching and Learning Strategies
This module will be delivered full time. It will include lectures and laboratory practicals. It is also augmented by independent learning.
Module Assessment Strategies
This module is 100% continuous assessment.
There will be spreadsheet assessment in the laboratory.
As per the current Mark and Standards procedure
Basic functions and formulae
Schedule of quantities
Coursework & Assessment Breakdown
|Title||Type||Form||Percent||Week||Learning Outcomes Assessed|
|1||Spreadsheet assessments||Continuous Assessment||Assessment||100 %||OnGoing||1,2,3,4,5|
Required & Recommended Book List
20/02/2010 Stats Means Business Butterworth Heinemann Davis
Microsoft Office 2019 Microsoft Press
02/08/2003 Understanding IT in Construction Routledge
Sun, M., Howard, R. (2003) Understanding IT in Construction, Routledge