Drawing standards and audit in AutoCAD - Real Business Scenario

Scenario Mode

👤 Your Role: You are a CAD manager at an engineering firm.

📋 Request: Your manager wants a report showing how well current project drawings follow company drawing standards. They want to identify common errors and areas for improvement.

📊 Data: You have a dataset listing project drawings with attributes: Drawing ID, Project Name, Checker Name, Date Checked, Number of Errors Found, Error Types (e.g., dimension errors, layer errors, text style errors), and Compliance Score (percentage).

🎯 Deliverable: Create a dashboard report summarizing compliance scores by project and error types, highlighting projects with low compliance and frequent error types.

Sample Data

Drawing ID	Project Name	Checker Name	Date Checked	Number of Errors Found	Error Types	Compliance Score (%)
D001	Bridge Build	Alice	2024-05-01	3	Dimension, Layer	85
D002	Bridge Build	Bob	2024-05-02	5	Dimension, Text Style	75
D003	Road Expansion	Alice	2024-05-03	2	Layer	90
D004	Road Expansion	Charlie	2024-05-04	4	Dimension, Text Style	80
D005	Office Renovation	Bob	2024-05-05	1	Text Style	95
D006	Office Renovation	Charlie	2024-05-06	3	Layer, Text Style	85
D007	Bridge Build	Alice	2024-05-07	6	Dimension, Layer, Text Style	70
D008	Road Expansion	Bob	2024-05-08	2	Dimension	88

1

Step 1: Load the dataset into your BI tool and create a table visualization showing all columns.

Import data as is; create table with columns: Drawing ID, Project Name, Checker Name, Date Checked, Number of Errors Found, Error Types, Compliance Score (%)

Expected Result

Table displays 8 rows with all drawing audit details.

2

Step 2: Create a measure to calculate the average Compliance Score by Project Name.

Average Compliance Score = AVERAGE('Data'[Compliance Score (%)])

Expected Result

Average compliance scores: Bridge Build=76.7%, Road Expansion=86%, Office Renovation=90%

3

Step 3: Create a bar chart showing average Compliance Score per Project Name.

X-axis: Project Name; Y-axis: Average Compliance Score measure

Expected Result

Bar chart shows Bridge Build lowest, Office Renovation highest compliance.

4

Step 4: Create a calculated column to count occurrences of each Error Type per drawing.

Create separate columns for each error type with formula: IF(CONTAINSSTRING('Data'[Error Types], "Dimension"), 1, 0) similarly for Layer and Text Style

Expected Result

Columns Dimension Error, Layer Error, Text Style Error with 1 or 0 per drawing.

5

Step 5: Create a matrix visualization showing total counts of each Error Type by Project Name.

Rows: Project Name; Columns: Error Types; Values: SUM of each error type column

Expected Result

Matrix shows Bridge Build has most Dimension and Layer errors; Text Style errors spread across projects.

6

Step 6: Add a filter to highlight drawings with Compliance Score below 80%.

Filter: Compliance Score (%) < 80

Expected Result

Filtered table shows drawings D002, D007 with low compliance.

7

Step 7: Create a summary card showing total number of drawings audited and average compliance overall.

Total Drawings = COUNT('Data'[Drawing ID]); Overall Average Compliance = AVERAGE('Data'[Compliance Score (%)])

Expected Result

Total Drawings = 8; Overall Average Compliance = 83.5%

Final Result

Drawing Standards Audit Dashboard

+-------------------+-------------------+
| Project Name      | Avg Compliance %  |
+-------------------+-------------------+
| Bridge Build      | 76.7              |
| Road Expansion    | 86.0              |
| Office Renovation | 90.0              |
+-------------------+-------------------+

Error Types by Project:
+-------------------+-----------+---------+------------+
| Project Name      | Dimension | Layer   | Text Style |
+-------------------+-----------+---------+------------+
| Bridge Build      | 3         | 3       | 3          |
| Road Expansion    | 2         | 1       | 2          |
| Office Renovation | 0         | 1       | 3          |
+-------------------+-----------+---------+------------+

Drawings with Compliance < 80%:
D002, D007

Summary:
Total Drawings Audited: 8
Overall Average Compliance: 83.5%

✓Bridge Build project has the lowest average compliance score at 76.7%.

✓Dimension and Layer errors are most common in Bridge Build drawings.

✓Text Style errors occur across all projects but are less frequent.

✓Two drawings have compliance scores below 80%, indicating need for focused review.

✓Overall compliance is moderate at 83.5%, showing room for improvement.

Bonus Challenge

Create a trend line chart showing average compliance score over time by month.

Show Hint

Group Date Checked by month and calculate average Compliance Score per month to visualize improvement or decline.

Practice

1. What is the main purpose of using drawing standards in AutoCAD?

easy

A. To keep designs clear and consistent

B. To increase file size

C. To make drawings colorful

D. To slow down the drawing process

Solution

1. Step 1: Understand drawing standards

   Drawing standards are rules that help keep designs clear and consistent.

2. Step 2: Identify the main purpose

   The main goal is to ensure all drawings follow the same rules for clarity and consistency.

3. Final Answer:

   To keep designs clear and consistent -> Option A

4. Quick Check:

   Drawing standards = clarity and consistency [OK]

Hint: Think about why rules help drawings look uniform [OK]

Common Mistakes:

• Confusing standards with file size
• Thinking standards add colors
• Believing standards slow work

2. Which AutoCAD command is used to check if a drawing follows the set standards?

easy

A. AUDIT

B. STANDARDS

C. PLOT

D. LAYER

Solution

1. Step 1: Recall AutoCAD commands

   The STANDARDS command checks if drawings meet the set rules.

2. Step 2: Differentiate from other commands

   AUDIT fixes errors, PLOT prints, LAYER manages layers, but only STANDARDS checks rules.

3. Final Answer:

   STANDARDS -> Option B

4. Quick Check:

   Check standards = STANDARDS command [OK]

Hint: Remember STANDARDS checks rules, AUDIT fixes errors [OK]

Common Mistakes:

• Confusing AUDIT with STANDARDS
• Choosing PLOT for checking standards
• Selecting LAYER instead of STANDARDS

3. After running the STANDARDS command, AutoCAD reports several violations. What is the expected result if you choose to fix these violations?

medium

A. Nothing will change in the drawing

B. The drawing will be deleted

C. The drawing will update to meet the standards automatically

D. The drawing will become read-only

Solution

1. Step 1: Understand STANDARDS command output

   STANDARDS shows violations and offers to fix them to meet rules.

2. Step 2: Effect of fixing violations

   Fixing updates the drawing automatically to comply with standards.

3. Final Answer:

   The drawing will update to meet the standards automatically -> Option C

4. Quick Check:

   Fix violations = update drawing [OK]

Hint: Fixing violations updates drawing to standards [OK]

Common Mistakes:

• Thinking the drawing deletes after fixing
• Believing nothing changes after fixing
• Assuming drawing becomes read-only

4. You ran the AUDIT command but it did not fix all errors in your drawing. What could be a reason?

medium

A. Some errors require manual correction

B. AUDIT command only checks layers

C. The drawing is already perfect

D. AUDIT command deletes all errors automatically

Solution

1. Step 1: Understand AUDIT command limits

   AUDIT fixes many errors but some need manual fixing.

2. Step 2: Identify why errors remain

   Errors not fixed automatically must be corrected by the user manually.

3. Final Answer:

   Some errors require manual correction -> Option A

4. Quick Check:

   AUDIT fixes some, manual needed for others [OK]

Hint: Not all errors fix automatically; check manually [OK]

Common Mistakes:

• Thinking AUDIT only checks layers
• Believing AUDIT deletes all errors automatically
• Assuming drawing is perfect without checking

5. You want to ensure your team's drawings always follow company standards. Which combination of steps is best?

hard

A. Ignore STANDARDS and rely on manual checks only

B. Change standards frequently to confuse errors

C. Use AUDIT command once and never again

D. Use STANDARDS command regularly and fix violations promptly

Solution

1. Step 1: Identify best practice for standards

   Regularly running STANDARDS helps catch violations early.

2. Step 2: Importance of fixing violations promptly

   Fixing violations quickly keeps drawings consistent and high quality.

3. Step 3: Evaluate other options

   Ignoring standards or changing them often causes confusion and errors.

4. Final Answer:

   Use STANDARDS command regularly and fix violations promptly -> Option D

5. Quick Check:

   Regular checks + fixes = consistent drawings [OK]

Hint: Check and fix standards often for best results [OK]

Common Mistakes:

• Ignoring standards command
• Relying on one-time audit only
• Changing standards too often