Data entry of mechanical parts for a Japan-based company.
Long-Term Project
Course curriculum
Introduction to Engineering Drawings
Introduction to 3D CAD Software
The Purpose of Engineering Drawings
Application of Engineering Drawings
How to make Drawings
Basic components of Engineering Drawings
Types of Engineering Drawings
Different types of Lines
Types of views in Engineering Drawing
Dimensioning
Types of Dimensioning
Tolerance
Tolerance Representation
Scaling
Information Block
Key elements of Information Blocks
Assembly Drawings
Bill of Materials (BOM)
Automation Components
Linear Motion
Extrusions, Supports & Struts
Adjusting Hardware, Fasteners & Accessories
Locating & Positioning Components
Rotary Motion
Rotary Power Transmission
Connecting Parts
2. Fasteners
Screws and Bolts
Screws for Building Materials
Washers
Nuts
Anchoring Hardware
Riveting Hardware
Inserts
Text Wrap
Add Multiple columns or rows
Transposing Data (Row to Column)
Freezing Rows or Columns
Select all rows and columns
Grouping rows and columns
Hide or show rows or columns.
Conditional Formatting
Concatenating Date with Text
Filter based on text match
Linked as Picture
Flash Fills
Format Painter
Add checkbox
Make drop-down menu
Comments
Copy or drag a table/sheet using ctrl and shift
Adding data, target line in bar chart
Image clipping
Translate to another language
Reference to another sheet
Clipboard copy-pasting
Here, we will learn about the actual work we will do in AutoLab. We will implement all the knowledge we gain from above classes (Mechanical parts, Engineering Drawings, Microsoft Excel)
We will learn about Japanese work culture, basic greetings, and the most frequent phrases in Japanese.