Course Overview

This syllabus aims to equip participants with the skills needed for estimating and costing building projects using both AutoCAD and Excel. Practical exercises and a final project will reinforce the application of these tools and techniques.

Prerequisites: Students must have knowledge about AutoCAD 2D Drawings to choose this course

Course Contents

Day 1: Introduction to Estimation and Costing 

- Overview of estimation and costing in construction projects

- Importance of accurate cost estimation

- Basics of quantity takeoff and measurement

Day 2-3: Introduction to AutoCAD for Quantity Takeoff

- Overview of AutoCAD interface for quantity takeoff

- Importing and working with architectural drawings

- Basics of scaling and units in AutoCAD

- Using layers for organizing information
 

Day 4: Quantity Takeoff Techniques in AutoCAD (1 Hour)

- Measuring lengths, areas, and volumes in AutoCAD

- Extracting data for materials and quantities

- Organizing and annotating measurements in AutoCAD
 

Day 6-6: Introduction to Excel for Cost Estimation

- Overview of Excel interface for cost estimation

- Setting up templates for construction projects

- Importing data from AutoCAD to Excel

- Formulas and functions for basic calculations

Day 7-8: Building Formulas and Templates in Excel

- Creating Excel formulas for quantity calculations

- Building templates for different construction elements

- Data validation and error checking in Excel

Day 9-10: Costing and Rate Analysis in Excel 

- Understanding cost components: materials, labor, and overhead

- Introduction on Building rate analysis

- Creating cost estimates for different project phases

- Formatting and presenting cost estimates in Excel

Day 11-12: Final Project, Review, and Q&A 

- Applying learned concepts to a final construction project

- Integrating quantity takeoff and cost estimation in AutoCAD and Excel

- Review of key commands and techniques

- Q&A session for addressing specific queries

- Final project presentations and feedback