Aims:

This module will give you a range of basic and intermediate level skills across a number of industry standard software packages. These skills are necessary for the remaining years of the course and for the workplace. The module is focused on the skills needed for a modern project manager and the examples created in class are all based on actual documents or forms used by project managers.

Objectives: 

To give you, regardless of previous IT experience or education, a comprehensive range of skills used by project managers today.

Project managers across the industry (from developers to clients to consultants to contractors to FM) use predominantly PC based software:

Microsoft Word (for word processing, creation of forms for processes)
 Microsoft PowerPoint (for presentations and basic drawing)
 Microsoft Excel (for spreadsheets, calculations, data sorting)
 Microsoft Visio (for graphics, process mapping, organisation charts)
 Microsoft Project (for timelines, Gantt charts)
To gain an understanding of the use of these industry standard applications by project managers and the skills needed.

Learning Outcomes: 

On completion of the module you should be able to demonstrate sound IT skills in all the applications that will enable you to work effectively for the remaining years of the course. These skills should also meet the expectations of employers in the UK construction industry when starting work.

Syllabus:

The Internet

General understanding of use of Internet and extranets
 Typical websites used by different types of project managers
Microsoft Outlook

Use of UCL email, calendar, lists
Microsoft Word

Set-up Word correctly
 Use and creation of templates/forms
 Use of styles and automated table of contents
 Advanced tables, creation of Forms
 Use of data sorting in tables
 Headers & footers, use of section break
 Insert symbols, pictures, objects, hyperlinks
 General formatting hints & tips
 Graphs
 Reviewing
Microsoft PowerPoint

Slide building techniques
 Use of Master slide in creating templates
 Builds, presentation skills
 Graphs
 Drawing in PowerPoint
 Presentation tips and techniques
Microsoft Excel

Use of standard construction spread sheets
 Spread sheet design
 Commonly used Formulas/Logic (e.g. sum, roundup, IF, NPV, COUNTIF etc.,)
 Formatting the spread sheet including conditional formatting, data validation
 Graphs
 Use of data sorting tools
 Pivot tables
Microsoft Visio

Introduction
 Draw simple organisation charts, flowcharts
 Understanding the ‘intelligence’ of Visio shapes
 Understand translation of text into pictorial representation
 Import into Word and PowerPoint
Microsoft Project (covered in more detail in Year 2)

Introduction
 Set up correctly
 Produce a simple Gantt chart with predecessors
Reading List

There is no specific required reading for this module. If you need additional support are referred to standard texts such as the ‘For Dummies’ series or similar reader and use of UCL Lyda.com.