Computing / Information Technology

Excel Level 3 - Advanced

Network: 
Aviation Finance Finuas Network
Duration 1 Day
Number of Places 12
Course Fee €90 per trainee
Subjects Taught Lesson 1: Streamlining Workflow
• Create and Run Macros
• Apply Conditional Formatting
• Add Data Validation Criteria
• Customise Access to Excel Commands (Quick Access Toolbar – 2007)
• Update a Workbook’s Properties
• Modify Excel’s Default Settings

Lesson 2: Collaborating with Others
• Password Protect Files
• Share a Workbook
• Set Revision Tracking and Review Tracked Revisions
• Merge Workbooks

Lesson 3: Auditing Worksheets
• Trace Cell Precedents and Dependents
• Locate Errors in Formulas
• Locate Invalid Data and Formulas
• Watch and Evaluate Formulas

Lesson 4: Analysing Data
• Create Scenarios
• Perform What-If Analysis – Goal Seek, Solver, Data Tables
• Develop a PivotTable and PivotChart Reports

Lesson 5: Working with Multiple Workbooks
• Consolidate Data
• Link Cells in Different Worksheets and Workbooks
• Edit Links

Lesson 6: Importing and Exporting Data
• Export to Microsoft Word and PowerPoint
• Import a Word Table
• Import Text, HTML, CSV Files

Enrolment and Start Dates Comment Dates: 10th September 2013
Course Content Overview:
In this course, delegates will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Further Enquiries Caoimhe O'Donnell
Network Manager
e: caoimhe@icbe.ie
e: kate@icbe.ie
Download Application Form http://icbe.ie/index.php/icbe-innovation-leansigma-skillnet-signup/
Learning Outcomes At Course Completion:
You will automate common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Trainer New Horizons Ireland
Address: 22 – 24 Strand Street Great, Dublin 1, Ireland
Web: http://www.newhorizonsireland.ie
Location of Course New Horizons Strand House 22 – 24 Strand Street Great Dublin 1
Course Web Page: 
http://icbe.ie/index.php/events/event/advanced-excel-2010-level-3-2/
Available to Job Seekers: 
Yes
Certified: 
No

IFA Fresh Milk Producers Committee

Network: 
Farm Business Skillnet
Duration Each Level (1 to 3) is 8 hours on line - 24 hours in total. Course will be open on line for 6 months
Number of Places 15
Course Fee Free to Members of FMP Committee - €75 to anyone else
Subjects Taught MS Outlook
Enrolment and Start Dates Comment Will be available on line from 11th February 2013
Financial Support 50% Funded by Skillnets and 50% funded by IFA Member Services for FMP Committee Members
Course Content ICT Web TV Online Training - MS Outlook - Levels 1 to 3
Entry Requirements none
Further Enquiries Celine Reynolds
Farm Business Skillnet Network Manager
Tel: 01 426 0324
Mob: 086 687 8648
Email: celinereynolds@ifatelecom.ie
Eligibility Member of IFA Fresh Milk Producers Committee
Learning Outcomes Proficiency in e-mail and Outlook
Methods of Assessment Online Evaluation of course - and Skillnet Evaluations
Trainer New Horizons Ireland, Strand House, 22/24 Strand Street Great, Dublin 1
Location of Course Onlin
Available to Job Seekers: 
Yes
Certified: 
No

Autodesk Revit Architecture 2012 Essentials

Network: 
CITA (Construction IT Alliance) Skillnet
Duration 3 Days
Course Fee Please contact CITA Skillnet for details.
Free to unemployed persons who meet CITA Skillnet criteria.
Subjects Taught Building Information Modelling
• Building Information Modelling for Architectural Design

Revit Architecture Basics
• Exploring the User Interface
• Working with Revit Elements and Families
• Starting a Project

Starting a Design
• Creating and Modifying Levels
• Creating and Modifying Grids

The Basics of the Building Model
• Creating a Basic Floor Plan
• Adding and Modifying Walls
• Working with Compound Walls
• Using Editing Tools
• Adding and Modifying Doors
• Adding and Modifying Windows

Loading Additional Building Components
• Working with Component Families

Viewing the Building Model
• Managing Views
• Controlling Object Visibility
• Working with Section and Elevation Views
• Creating and Modifying 3D Views

Using Dimensions and Constraints
• Working with Dimensions
• Applying and Removing Constraints

Developing the Building Model
• Creating and Modifying Floors
• Working with Ceilings
• Adding and Modifying Roofs
• Creating Curtain Walls
• Adding Stairs and Railings

Detailing and Drafting
• Creating Callout Views
• Working with Text and Tags
• Working with Detail Views
• Working with Drafting Views

Construction Documentation
• Creating and Modifying Schedules
• Creating Rooms and Room Schedules
• Creating Legends and Keynotes

Presenting the Building Model
• Working with Drawing Sheets
• Working with Titleblocks
• Managing Revisions
• Creating Renderings
• Using Walkthroughs
• Using Sun and Shadow Settings

Enrolment and Start Dates Comment Enrolment Date: 01/04/2013
Start Date: 13/05/2013
Finish Date: 15/05/2013
Course Content Students use Revit Architecture 2012 to learn about building information modelling (BIM)and the tools for parametric building design and documentation. Students begin the three-day course by learning the fundamental features of Revit Architecture 2011, and then progressing through schematic design and construction documentation, before finishing with design visualisation. Students should be able to complete their first Revit Architecture project after completing this course. The course offers metric hands-on exercises representing real-world design scenarios.
Entry Requirements Depends on experience and / or qualifications.

Suitable for Architects, Engineers, Technicians & other various designers within the construction industry with prior basic understanding of Revit Architecture.

Further Enquiries Suzanne Purcell
CITA Skillnet Manager
Tel: 01 470 4440
Mob: 086 0474869
email: spurcell@cita.ie
Trainer Arcdox
Location of Course Q House, Furze Road, Sandyford, Dublin 18
Available to Job Seekers: 
Yes
Certified: 
No

ArchiCAD BIM Essentials

Network: 
CITA (Construction IT Alliance) Skillnet
Duration 2 Days
Comment Limited number of places for Jobseekers available - Contact CITA Skillnet for more information - (01)470 4440
Number of Places 8
Course Fee Please contact CITA Skillnet for details.
Enrolment and Start Dates Comment Enrolment Date 01/04/2013
Start Date 01/05/2013
Financial Support Reduced Course Fee funded by CITA Skillnet
Course Content Course Objectives
To provide an introduction to Building Information Modelling (BIM) and also learn how to use ArchiCAD.
Careers or Further Progression Engineering, Architecture, Building Services, Planner, Draftsperson, CAD Manager, Surveyor
Entry Requirements Knowledge of how construction documents are prepared as well as computer expertise.
No previous CAD experience required.
Further Enquiries Suzanne Purcell CITA Skillnet Network Manager
Tel: 01 440 4440
Eligibility Applications accepted from engineers, architects, technicians, or anyone interested in Building Information Modelling (BIM)
Learning Outcomes After this course attendees will be able to:
• Create BIM 3D models
• Generate plans, elevations, sections,
• Automatically update design changes.
• Create perspective views, VR,
• Create high quality renders
• Appreciate the difference between 2D & 3D modelling
• Understand Object technology
• Communicate with AutoCAD, BIM
• Create Schedules
• Automatic updating and dimensioning
• Manage Views
• Modify Elements

CPD: 16 CPD Points

Trainer Dedicated CAD
Course Web Page: 
http://www.cita.ie/skilnet_courses.asp
Available to Job Seekers: 
Yes
Certified: 
No

SBEM Non Domestic BER Assessor Training Course

Network: 
CITA (Construction IT Alliance) Skillnet
Duration 2 Days
Course Fee Please contact CITA Skillnet for details
Enrolment and Start Dates Comment Enrolment Date: 01/04/2013
Start Date: 25/04/2013
Course Content SEAI's non domestic energy assessment procedure(NEAP) is used to generate BER certificates and advisory reports for new and existing non domestic dwellings. NEAP allows the calculation to be carried out using approved software packages including the Simplified Building Energy Model (SBEM) which has been developed by BRE on behalf of the UK department of Communities and Local Government. SBEM accompanied by a user interface, iSBEM is used to produce consistent and reliable evaluations of energy use in non domestic buildings.
Further Enquiries Suzanne Purcell
CITA Skillnet Manager
Tel: 01 470 4440
Mob: 086 047 4869
email: spurcell@cita.ie
Trainer IHER
Location of Course Dublin
Available to Job Seekers: 
Yes
Certified: 
No

Construction Informatics

Network: 
CITA (Construction IT Alliance) Skillnet
Duration 5 Semesters (2 1/2 years) Part-time (Distance Learning)
Comment Limited number of places for Jobseekers available - Contact CITA Skillnet for more information - (01)470 4440
Number of Places Limited. Please contact Suzanne Purcell for details spurcell@cita.ie or call +353 1 470 4440
Subjects Taught MSc in Construction Informatics
• eBusiness in Construction
• CAD Information Systems
• Building Collaborative Technologies
• Virtual Construction
• Building Automation
• Integrated Masters Project
• Computer Mediated Construction
• Energy Integrated ICT
• Dissertation
Enrolment and Start Dates Comment Enrolment Date: 01/04/2013
Start Date: 30/08/2013
Financial Support Assistance can be provided to applicants who meet the funding eligibility criteria. Contact CITA for details CITA Skillnet can offer a limited number of free places to Jobseekers on this course, subject to conditions.
Careers or Further Progression Engineering, Architectural, Building Services, Structural, Technician, BIM Specialist
Entry Requirements The minimum entry level is an honours 2.2 undergraduate Level 8 degree or its equivalent.

Selection will be made on a combination of an interview and by using particular criteria which demonstrates the candidate’s academic achievement, employment experience and interest in the programme.

Further Enquiries Suzanne Purcell
CITA Skillnet Manager
office: 01 470 4440
mobile: 086 047 4869
email: spurcell@cita.ie
Eligibility Open to applicants who meet the entry requirements, and are successful at selection interview.
Methods of Assessment Project Based
Trainer Dublin Institute of Technology
Location of Course Dublin Based (distance learning course)
Available to Job Seekers: 
Yes
Certified: 
Yes

Buildsoft 2D Onscreen Takeoff

Network: 
CITA (Construction IT Alliance) Skillnet
Duration 1 day
Number of Places 6
Enrolment and Start Dates Comment Enrolment from 01/04/2013
Start Dates:
10/04/2013
24/04/2013
Financial Support Support available from CITA Skillnet
Course Content This hands-on course is broken into morning and afternoon sessions. The morning session provides an introduction to the basics in on-screen plan take off.

The afternoon session concentrates on the advanced tools and functions used to significantly improve speed and accuracy using BT2 to take off quantities directly from electronic plans.

Attendees will become familiar with the fundamentals of BT2 and feel confident navigating around the system. Hands-on exercises are used throughout to help the trainee retain the knowledge gained in a practical way.

Entry Requirements This course is intended for existing users wishing to up-skill, Quantity Surveyors, Estimators, Development Managers, Project Managers, and other construction consultants.
Further Enquiries Please contact
Suzanne Purcell CITA Skillnet Network Manager
01 470 4440
086 047 4869
spurcell@cita.ie
Learning Outcomes To allow the attendee gain a comprehensive understanding of on-screen take off using BT2. The course will provide the attendee with a practical training experience to enable them start applying the knowledge gained in their corporate environment.
Location of Course Bray Co. Wicklow
Course Web Page: 
http://www.cita.ie/skilnet_courses.asp
Available to Job Seekers: 
Yes
Certified: 
No

Systems Administrator - Servers

Network: 
Greasán na Méan Skillnet
Course Fee TBC
Course Content The course will cover; maintaining and supporting servers and troubleshooting.
Further Enquiries Tel: 091 558 400
Fax: 091 558 470
Email: info@greasannamean.ie
Trainer TBC
Available to Job Seekers: 
Yes
Certified: 
No

Managing Information On-Line

Network: 
Greasán na Méan Skillnet
Number of Places 10-12
Course Content This will include content management for websites and using cloud storage for data.
Further Enquiries Tel: 091 558 400
Fax: 091 558 470
Email: info@greasannamean.ie
Location of Course An Spideal
Available to Job Seekers: 
Yes
Certified: 
No

Format Development

Network: 
Greasán na Méan Skillnet
Duration TBC
Number of Places 10-12
Course Content Indept exploration of HD TV formats both at home and abroad
Further Enquiries Tel: 091 558 400
Fax: 091 558 470
Email: info@greasannamean.ie
Trainer TBC
Location of Course An Spideal
Available to Job Seekers: 
Yes
Certified: 
No
Syndicate content