QUSU06040 2019 Information Communication Technology in Quantity Surveying
This module explores the functions of spreadsheets required by the Quantity Surveyor / Estimator.
Learning Outcomes
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.
Repeat Assessments
As per the current Mark and Standards procedure
Indicative Syllabus
Spreadsheets
Basic functions and formulae
Spreadsheet charts
Tender assessment
Schedule of quantities
Estimating
Payment certification
Coursework & Assessment Breakdown
Coursework Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | Spreadsheet assessments | Coursework Assessment | Assessment | 100 % | OnGoing | 1,2,3,4,5 |
Full Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Lecture | Computer Laboratory | Lecture | 4 | Weekly | 4.00 |
Independent Learning | Not Specified | Independent learning | 3 | Weekly | 3.00 |
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
Module Resources
Sun, M., Howard, R. (2003) Understanding IT in Construction, Routledge
https://www.emeraldinsight.com/doi/full/10.1108/09699980610680171
N/A
N/A
N/A