BLDG3004 – Construction Information Systems

Overview

Assignment 2 deals with construction information such as cash flow diagrams, client progress
payments, construction planning, Gantt charts, variations, drawings and document register,
cost details and integration of many other information using MS Excel, MS Word, PDF,
images and other necessary file types.

Details

This Project will be 25% of Assessment in Construction Information Systems. The project
submission will consist of a series of linked sheets and an instruction manual for the
application you developed. The manual is to be presented in an appropriate format, and it
must be word-processed.

Professional presentation, conciseness, usefulness, thorough research, and material relevance
will be rewarded. All sources are to be acknowledged and correctly referenced.

You have to prepare an application using the linked spreadsheets to assist with the contract
administration for a builder on multiple projects. You can decide on the size of the builder
and the size of the projects by assuming that the projects are running at any one time, and
your application must match your builder's requirements. A brief statement outlining the
assumptions and details of your hypothetical company must be included in the manual.

Your system's features will vary depending on your builder's management structure and the
type of work. Below are suggested features that could be included. However, it is essential
that you incorporate good practices for information systems design into your application,
taking into account the theory we will cover in these areas.

You must prepare an instruction manual that identifies all the features of your application and
instructs the user on how to use the program. You can assume that the user is familiar with
the spreadsheet package being used. The manual should also include a flow chart giving an
overview, examples of input screens and examples of output reports that the system will
produce.

Your application must be developed using one of the common spreadsheet packages available
on the university's computer network, such as MS Excel. It must consist of multiple
spreadsheet sheets linked into one integrated contract administration package that has various
levels of input and output to suit the management of the company and the projects.

You may get assistance from the lecturer, other students or externally when developing your
application, so long as you acknowledge this assistance. No marks will be deducted for this;
it is what you are expected to do. Your final application will receive a mark based on the 
quality of the application and the manual. You must have a thorough understanding of the
entire application and manual. 

Suggested features:

• Contract sum and break up into trades and/or elements.
  Potential Output: A summary spreadsheet showing the overall contract sum; Sub-sheets
  or charts breaking down the contract sum into specific trades or elements.
• Contract times (overall, trade by trade, building section/level).
  Potential Output: Timelines for different building sections or levels; Gantt charts
  illustrating the project timeline and trade-specific timelines.
• Quantities of work (not detailed).
  Potential Output: A table or chart showing the overall quantities of work for different
  trades or elements.
• Progress payments. (Head contractor, subcontractor, supplier, etc.).
  Potential Output: Payment schedule reports; Summaries of payments made to different
  entities).
• Variations (Scope, cost and time).
  Potential Output: Variation order reports; Comparative analysis of original and modified
  project parameters.
• Actual costs (labour, plant, subcontract, materials, overheads).
  Potential Output: Detailed spreadsheets showing actual costs for labour, plant,
  subcontracting, materials, and overhead.
• Actual times.
  Potential Output: Time tracking reports; Comparative analysis of planned vs. actual
  time.
• Contract notifications such as requirements for time extension or practical completion.
  Potential Output: Notification reports; Visual representations of timelines impacted by
  extensions.
• Drawings and document register.
  Potential Output: Document registers; Lists categorising drawings and documents.
• Work progress.
  Potential Output: Progress reports; Visual representations of completed vs. pending
  work.
• Cost details grouped into appropriate cost centres.
  Potential Output: Cost centre-wise reports; Charts illustrating costs in different
  categories.
• Project milestones Potential Output: Visual representation of milestones; Reports highlighting achievements.

• Project reports and applicable graphical representation for:
  •  BoQ
  • Scheduling
  • Cost analysis
  • Comparisons of planned and actual costs
  • Cash flow and profitability
  • Investment analysis
  • Risk analysis
  • Resource analysis
  • Comparison of projects
• Security.
• Single-point data entry principles.
• Multi-level menus.
• Data exchange with other applications/formats such as PDF, images, Microsoft Project, etc.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back!
Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects. Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank