CAD 139 - Intro to CAD/CAM

1. Operate a networked PC using a current operation system.
   1. Login to the college network.
   2. Determine how to launch the CAM software.
   3. Maintain files in a tree structure of folders
   4. Explain the tree structure that the CAM software uses and where different types of files are stored
   5. Identify the different file extensions that the CAM software uses.
2. Explain the software licensing.
   1. Discuss different methods of licensing devices necessary to run the CAM software.
   2. Verify the available licenses on either the network or PC (depending on license type).
   3. Discuss the different capabilities of each license level available for each machine type.
3. Maneuver in the CAM desktop.
   1. Determine the proper hotkey to do the following the graphics area:
   2. Launch the cursor menu
   3. Explain toolbars status such as docked, floating, visible and hidden.
   4. Manipulate pull-down and cascading menus.
   5. Explain the status bar functions.
   6. Explain the calculator functionality within the software.
   7. Create, change, edit, and delete a tool library.
   8. Modify the speed and feed database.
   9. Locate and utilize the MRU toolbar
   10. Determine visual cues for ambiguous geometry
   11. Determine visual cues for ambiguous geometry
   12. Manipulate the ribbon bar for input.
4. Determine different geometry types and importing
   1. Explain the benefits of a solid model.
   2. Explain the benefits of basic 2-D and 3-D geometry (non-solid model).
   3. List common translators such as IGES, DXF, STEP, etc with the problems and benefits of each.
   4. Explain gold-level integration of different brands of CAD and/or CAD/CAM software.
   5. List the geometry and annotation types that have difficult importing because of translation.
5. Create geometry in a CAM software.
   1. Explain how axes are oriented in Cartesian coordinate system.
   2. Explain the difference between absolute and relative input.
   3. Determine autocursor (object snap) positions.
   4. Create 2-D geometry such as lines, points, arc, splines.
   5. Define geometrical relationship such as collinear, tangent, perpendicular, co-radial, etc.
   6. Create elliptical shapes.
   7. Utilize the chamfer and fillet functions.
   8. Create polygon shapes.
   9. Create machineable text.
   10. Create geometry using construction geometry methods.
   11. Control the WCS coordinate system and assign work offsets.
   12. Utilize data-entry shortcuts.
6. Edit geometry in a CAM software.
   1. Delete geometry individually and using massive selection methods.
   2. Change geometry to new locations, levels, colors, etc.
   3. Perform mirror, rotate, translate functions with the geometry.
   4. Change level (layers) associations of geometry.
   5. Edit line width, style and visibility of geometry.
   6. Select geometry for manipulation using window, chain, area functions
   7. Selection geometry for manipulation using the color, level, geometry mask.
   8. Utilize all the trim and extend functions
   9. Analyze geometry for size, position, and distance.
7. Explain the Machine Definitions (MMD) used for CAM.
   1. Determine the physical machine layout for a MMD.
   2. Determine the control definitions role in the MMD concept.
   3. Explain how the toolpath copy of the MMD differs from the diskcopy.
   4. Explain how the post processor interacts with the MMD.
8. Setup properties for mill toolpathing.
   1. Select a proper MMD.
   2. Setup stock material properties.
   3. Select tool libraries and tool settings.
9. Interact with the operation manager
   1. Determine what settings control the output of CNC code with the operation manager.
   2. Determine how to create, delete, and reorder toolpath operations.
   3. Regenerate dirty toolpath operations.
   4. Select individual toolpath operations using various Windows-based functions such as control and the shift keys
   5. Determine how to lock a toolpath operation.
   6. Change toolpath display visibility
   7. Expand and collapse operations within the operations manager.
   8. Determine what each of the sub-categories of each operation will do.
   9. Run post-processor to create CNC code
10. Toolpathing CAM model.
    1. Locate tools in the tool library.
    2. Determine motion control of the tool approaching and retract from the work including helical and ramp entry
    3. Manipulate the tool entry and exit requirement from the workpiece.
    4. Determine when to use multiple levels and/or multiple passes.
    5. Determine the type of toolpath operation needed for the job.
    6. Create chained-paths using various selection tools.
    7. Control the chained path direction, start, and end.
    8. Configure a contouring operation and utilize its parameters.
    9. Configure a pocketing operation and utilize its parameters.
    10. Configure a facing operation and utilize its parameters.
    11. Configure a drilling operation and utilize its parameters.
    12. Determine the different types of cutter compensation and when to use them.
    13. Adjust the final size of the workpiece using amount of stock functions.
11. Check toolpath operations for accuracy.
    1. Utilize the verification module for machining animation.
    2. Manipulate settings for verification such as machined color, size, and shape of the workpiece.
    3. Utilize the backplot feature to determine tool movements.
    4. List machining time calculation for each operation.
12. Generate CNC code
    1. Identify common G&M codes used by CNC machines.
    2. Locate and save files to alternate network locations.
    3. Open and close CNC editor as required.
    4. Utilize CNC editor to download programs to a CNC machine.

CAD 148 - Intro to Finite Element Analys

1. Examine forces.
   1. Differentiate between internal and external forces.
   2. Discuss compressive forces.
   3. Discuss tensile forces.
   4. Identify gravitational forces.
   5. Discuss force translations.
   6. Calculate resultant force.
   7. Discuss concurrent forces.
   8. Discuss co-planer forces.
   9. Create free-body diagram.
   10. Discuss equilibrium of forces.
   11. Examine forces on inclined planes.
2. Determine three dimensional resultants.
   1. Discuss force system theorems.
   2. Calculate vectors.
3. Examine simple (direct) stress.
   1. Discuss tension.
   2. Discuss compression.
   3. Discuss shear.
   4. Discuss bearing.
4. Discuss friction.
   1. Define static friction.
   2. Calculate maximum static friction.
   3. Discuss friction on an inclined plane.
   4. Discuss wedge action.
   5. Discuss journal friction.
5. Examine moments.
   1. Define moment arm.
   2. Discuss sign of moment.
   3. Discuss uniform loading.
   4. Calculate the centroid of the load.
   5. Identify couples.
6. Discuss basic constraints.
   1. Define six degrees of freedom.
   2. Discuss applying basic constraints.
7. Create element mesh.
   1. Discuss CAD model types.
   2. Examine mesh types.
   3. Define nodes.
   4. Create 2D & 3D mesh.
   5. Import a parametric model for FEA.
8. Analyze trusses.
   1. Calculate resultants in truss forces.
   2. Discuss truss structures.
   3. Examine forces at connections, joints, and sections.
   4. Construct truss CAD model.
   5. Apply forces to model.
   6. Apply contraints.
9. Examine material properties.
   1. Define stress.
   2. Define strain.
   3. Discuss material terms.
   4. Define modulus of elasticity.
   5. Discuss ductility.
   6. Calculate allowable stresses.
   7. Calculate safety factors.
   8. Define Poison’s ration.
   9. Discuss thermal stress.
   10. Define coefficient of thermal expansion.
   11. Analyze composites.
10. Determine mass properties.
    1. Discuss center of gravity.
    2. Examine centroids.
    3. Determine moment of area.
    4. Calculate centroid of a composite.
    5. Discuss moment of inertia.
11. Discuss CAD model creation.
    1. Define wireframe entities.
    2. Discuss nodal entities.
    3. Discuss mesh generation.
    4. Discuss thermal applications.
    5. Discuss using a dither on a DAC model to examine FEA results.
12. Analyze joint designs.
    1. Examine bolted joints.
    2. Compare rivet joints to bolted joints.
    3. Calculate allowable loads for welded joints.
13. Examine simple beams.
    1. Examine supported beam.
    2. Examine overhanging beam.
    3. Examine cantilever beam.
14. Create CAD solid FEA models.
    1. Create CAD solid models.
    2. Create FEA components.
    3. Analyze models.
15. Discuss software calculations.
    1. Discuss the analysis process of a model.
    2. Examine the data that is required to analyze the model in a decoder.
    3. Analyze a model.
    4. Examine the results of a model.
    5. Discuss the differences between a finite element modeling and mass properties.

CAD 151 - CAD Graphics I

1. Discuss drawing types.
   1. Discuss industry drawing standards, such as ANSI, ISO, ASME, etc…
   2. Discuss computer-aided drafting.
   3. Examine engineering, drafting occupations.
   4. Examine related applications.
2. Identify basic drafting equipment and materials.
   1. Identify drawing media.
   2. Identify printing and plotting equipment.
   3. Identify computer-aided drafting equipment.
   4. Discuss computer aided drafting computer requirements.
   5. Discuss CAD software packages.
3. Analyze measurement and scaling systems.
   1. Discuss measurements and measuring units.
   2. Examine measuring scales for mechanical, civil, architectural and metric scales.
   3. Discuss drawing scale.
   4. Identify industry standard sheet sizes and title blocks.
4. Demonstrate sketching techniques.
   1. Discuss sketching principles.
   2. Identify lead grades for sketching.
   3. Know linetypes used in sketching.
   4. Sketch straight lines.
   5. Sketch curves and circles.
   6. Demonstrate proportion in a sketch.
   7. Sketch parts using orthographic projection.
   8. Sketch parts using isometric projection.
5. Perform basic lettering.
   1. Identify proper text height.
   2. Discuss font types used for mechanical drawings.
   3. Write the alphabet and numbers using Gothic letters.
6. Construct basic geometric entities.
   1. Define lines types and discuss their rules.
   2. Create geometric shapes such as point, line, polygons, etc..
   3. Modify geometric shapes.
7. Discuss CAD considerations necessary to create geometric entities.
   1. Discuss drawing setup and layering schemes.
   2. Examine viewing commands.
   3. Discuss coordinate entry methods.
   4. Examine object snap.
   5. Make use of selection sets to modify geometry.
8. Construct advanced geometric shapes.
   1. Examine advanced drawing commands.
   2. Create an ellipse, parabola, and helix.
   3. Examine advanced modification commands such as grip editing and property inquiries.
   4. Create and edit blocks and attributes.
9. Construct basic geometric intersections.
   1. Define geometric constructions.
   2. Bisect and divide geometry such as lines and arcs.
   3. Create tangential geometries.
   4. Draw an ogee curve.
10. Identify required views for a drawing.
    1. Identify orthographic projections.
    2. Discuss first angle projection.
    3. Discuss third angle projection.
    4. Identify the six standard views of a part.
    5. Prepare a two dimensional drawing.
11. Print and plot drawings.
    1. Examine using paper space and viewports.
    2. Discuss printing and plotting.
    3. Identify printing media.
    4. Discuss printers and plotters used in industry.
    5. Create and use title blocks and borders.
    6. Create drawing notes, general and local.
    7. Produce prints and plots.
12. Identify part surfaces.
    1. Define and create normal, inclined, and oblique surfaces.
13. Analyze sectional views.
    1. Define section views: half, full, partial, broken out, removed, and revolved.
    2. Discuss the usage of section views.
    3. Identify line usage in sections.
    4. Discuss hatch patterns for single parts and how they relate to parts in an assembly.
14. Analyze basic dimensioning practices.
    1. Identify dimensioning standards such as ANSI and ISO.
    2. Examine dimensioning units.
    3. Create horizontal, vertical, aligned, and radial dimensions.
    4. Discuss dimension placement and standards.
    5. Create dimensions in drawing layout.

CAD 152 - CAD Graphics II

1. Examine descriptive geometry theorems.
   1. Discuss descriptive geometry definitions.
   2. Discuss descriptive problem layouts, coordinates, and units.
   3. Examine fundamental views.
   4. Define points, lines, and planes.
   5. Discuss line and plane theorems.
2. Determine intersections of entities.
   1. Examine intersecting lines.
   2. Examine surface pierce points.
   3. Examine plane intersections.
   4. Examine perpendicular relationships.
   5. Examine dihedral angles.
3. Discuss bearing, slope and grade.
   1. Discuss map view and bearing coordinates.
   2. Discuss elevation views.
   3. Analyze slope, grade, and pitch.
4. Determine pattern and developments.
   1. Discuss development theorems.
   2. Discuss primitive elements.
   3. Develop basic entities in flat patterns.
   4. Develop intersections of prisms.
   5. Create flat pattern layouts.
5. Solve vector geometry problems graphically.
   1. Discuss definitions of terms associated with vector problems.
   2. Analyze basic vector principles.
   3. Determine resultant of concurrent/non-concurrent coplanar/non-coplanar vectors.
6. Determine auxiliary views.
   1. Relate positions of views and identify fold lines.
   2. Identify auxiliary views, primary and secondary.
   3. Discuss partial views.
   4. Construct drawings with auxiliary views.
7. Review dimensioning practices.
   1. Review dimensioning standards.
   2. Revisit dimension settings and placement in layouts.
   3. Create dimensions using baseline, chain, and coordinate.
   4. Discuss the difference between double and dual dimensioning.
8. Discuss 3D CAD models.
   1. Discuss wire-frame and solid models.
   2. Examine 3D coordinates.
   3. Define Boolean and parametric modeling.

CAD 153 - CAD Applications I

1. Analyze weldments.
   1. Examine standard welds
   2. Identify the American Standard Weld symbol.
   3. Create weld symbol blocks in CAD.
   4. Discuss and create general notes for weldments.
   5. Identify correlation of geometric tolerancing and weldments.
   6. Discuss surface finishes of welds.
   7. Discuss related weld applications
   8. Discuss plasma and flame cutting.
   9. Create a welded assembly, applying cad symbols and geometric tolerancing.
2. Analyze surface finishes.
   1. Discuss surface finish terminology and symbols.
   2. Relate surface finish to tolerances.
   3. Relate surface finishes to production processes.
   4. Discuss casting allowances due to surface imperfections.
   5. Discuss required machining and limits of finish values.
   6. Create in CAD surface finish symbol blocks.
   7. Apply surface finishes to a CAD part drawing.
3. Analyze datums.
   1. Identify casting datums.
   2. Identify machine datums.
   3. Determine primary machine datum.
   4. Create a datum symbol block
4. Examine geometric dimensioning and tolerancing (GD&T).
   1. Define terms associated with GD & T.
   2. Explain fundamental rules of GD & T.
   3. Demonstrate an understanding of features.
   4. Identify features of size and features without size.
   5. Demonstrate an understanding of tolerance zones.
   6. Describe the default tolerance zone and how it is positioned.
   7. Explain how tolerance zone shape is changed.
   8. Explain the difference between controlling an axis, a median plane, or a plane surface.
   9. Explain when a tolerance can and cannot be modified.
   10. Explain the effect of a feature modifier.
   11. Demonstrate an understanding of the commonly used characteristics.
   12. State the characteristics that require datum(s) and those that do not.
   13. Define geometric tolerancing.
   14. Determine primary, secondary, and tertiary datums.
   15. Analyze geometric tolerancing theorems.
   16. Identify geometric feature control symbols.
   17. Discuss material condition modifiers and datum applications of feature control frame.
   18. Apply geometric dimensioning and tolerancing to a CAD drawing.
5. Discuss casting drawings.
   1. Examine draft.
   2. Discuss fillets and rounds.
   3. Analyze machining allowance.
   4. Discuss casting/machining drawings.
   5. Discuss shrinkage allowance.
   6. Discuss forging drawings.
   7. Create a casting drawing.

CAD 154 - CAD Applications II

1. Examine mechanical belt drives.
   1. Discuss types of belt drives.
   2. Discuss types of belt configurations.
   3. Discuss belt materials.
   4. Examine service factors.
   5. Discuss horsepower requirements.
   6. Analyze belt drive calculations.
   7. Calculate belt drive data.
2. Investigate mechanical chain drives.
   1. Discuss types of chain drives.
   2. Discuss standard chain sizes and specifications.
   3. Examine standard sheave sizes and specifications.
   4. Discuss chain materials.
   5. Discuss service factors.
   6. Examine horsepower requirements.
   7. Discuss chain drive data and formulas.
   8. Calculate chain drive data.
3. Discuss power train schematics.
   1. Discuss symbology for drive trains.
   2. Create standard symbol libraries.
   3. Create power train schematics.
4. Examine standard drive components.
   1. Identify using keys and splines in a drive train.
   2. Examine horsepower ratings of motors.
   3. Examine drive transfer components.
5. Discuss bearings.
   1. Identify standard bearings.
   2. Discuss bearing schematic symbols.
   3. Examine bearing loading.
   4. Examine bearing seals and shields.
   5. Discuss bearing lubrication.
6. Examine sealing systems.
   1. Identify standard seals and gaskets.
   2. Discuss seal schematic symbols.
   3. Create drawings utilizing gaskets and seals.
7. Evaluate sheet metal design.
   1. Discuss bend allowances for sheet metal.
   2. Calculate bend allowances.
   3. Examine bend reliefs.
   4. Discuss part features on a bent part, such as slots and holes.
   5. Examine flat pattern layouts
   6. Create two dimensional flat pattern.
8. Investigate solid model CAD sheet metal parts.
   1. Examine differences between standard solid parts versus sheet metal parts.
   2. Discuss commands specifically for sheet metal parts.
   3. Analyze the use of sheet metal parts with standard solids in an assembly.
   4. Examine creating sheet metal features in the CAD model.
   5. Create a sheet metal solid model.
   6. Create a flat pattern using a solid model.
9. Discuss heating, ventilation and cooling (HVAC) applications.
   1. Examine HVAC systems.
   2. Discuss ventilation.
   3. Examine HVAC symbols.
   4. Discuss HVAC CAD applications.
   5. Examine sheet metal fabrication in HVAC.
   6. Examine sheet metal drawing notations.
10. Explore hydraulic control systems.
    1. Discuss hydraulic principles and how they compare to pneumatic systems.
    2. Discuss industry standards.
    3. Examine basic hydraulic components.
    4. Discuss a simple hydraulic circuit.
    5. Examine hydraulic system schematics.
    6. Create a hydraulic schematic.

CAD 155 - Networking Systems Involving CAD

1. Explain devices on networks
   1. Describe desktop computers, mid-range computers and servers.
   2. Describe PDAs, Peripheral Devices and Internetworking devices.
2. Examine internal computer components
   1. Describe the function of the CPU, memory, and NICs.
   2. Examine various bus configurations
   3. Discuss removal storage, hard disk, cdrom, and DCD technology
   4. Discuss computer care and maintenance
3. Discuss software and operating systems
   1. Describe programs and process
   2. Identify the function of device drivers
   3. Discuss network management software
   4. Discuss popular operating systems.
   5. Install/configure current operating system
4. Analyze carrier signals, cable types, and network topologies.
   1. Discuss communication and signals.
   2. Identify network topologies
   3. Describe physical cable types.
   4. Explain wireless transmission
   5. Describe structured cable plant
5. Identify computer protocols and services
   1. Discuss different protocols
   2. Discuss overview of the layers of protocols and services.
   3. Describe communicating across a network.
6. Examine the OSI model.
   1. Describe the physical layer
   2. Describe the data link layer.
   3. Describe the network layer
   4. Describe the transport layer
   5. Describe the session layer
   6. Describe the presentation layer.
   7. Describe the application layer
7. Explore Local Area Networks(LANs).
   1. Discuss LAN data link protocols
   2. Describe Ethernet
   3. Describe token ring and FDDI.
   4. Describe wireless LANs.
   5. Identify LAN software architectures.
   6. Discuss information flow between client and server.
8. Identify network components.
   1. Identify function of repeaters and hubs.
   2. Describe bridges.
   3. Discuss switches and routers
   4. Describe Gateways
9. Explore Wide Area Networks (WANs).
   1. Discuss point-to-point WAN services.
   2. Describe switched WAN services
   3. Explain choosing WAN products and services.
10. Incorporate course networking elements.
    1. Install/configure client machine.
    2. Design/layout topology.
    3. Create small peer-to-peer network.

CAD 162 - Intro to Multimedia

Credits: 3
Lecture Hours: 2
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech

1. Understand 3D graphics and animation fundamentals
   1. Define 3D space concepts
   2. Describe the use of coordinates
   3. Identify what axis’s are
   4. Distinguish between lines, polylines and polygons
   5. Describe a 3D object
   6. Define how to use 3D lights
   7. Explain the camera function
   8. Define the act of 3D rendering
   9. Summarize creating animation
2. Explain the MAX interface
   1. Manipulate work files
   2. Illustrate viewport controls
   3. Utilize the Units, Snaps and other drawing aids
3. Comprehend modeling concepts
   1. Explain Spline based modeling
   2. Examine mesh and polygonal modeling
   3. Describe parametric modeling
   4. Identify Patch modeling
   5. Define patch sub-objects
   6. Describe NURBS modeling
4. Know the basic modeling methods
   1. Describe work with splines
   2. Define spline lofting methods
   3. Demonstrate working with 3D primitives
   4. Investigate working with compound objects
5. Explain the basic editing methods
   1. Practice editing object parameters
6. Define 3D design theory
   1. Review mixing color and light
   2. Distinguish color composition
   3. Identify complementary colors
   4. Examine warm versus cool colors
   5. Describe the impact of colored lighting
7. Identify the concepts of composition
   1. Summarize the use of cameras
   2. Create a camera
   3. Create a camera view
   4. Explain utilizing lights for composition
   5. Create a light affect
8. Describe working with materials
   1. Discuss the materials editor function
   2. Describe basic materials parameters
   3. Explain assigning materials to objects
   4. Utilize mapping coordinates
9. Utilize rendering techniques
   1. Explain rendering options
   2. Modify rendering parameters
   3. Compose a rendering
10. Demonstrate the concepts of animation
    1. Explain the use of controllers
    2. Relate time in computer animation
    3. Configure moving through time in MAX
    4. Explain the time configuration commands
    5. Create an animation

CAD 182 - SolidWorks CAD I

1. Discuss the parametric design process.
   1. Define solid modeling.
   2. Define parametric design.
2. Discuss typical parametric CAD system fundamentals.
   1. Examine the screen layout and menu structures.
   2. Examine coordinate system.
   3. Examine entering commands and options.
   4. Examine file management such as opening, saving, backup, and recovery.
   5. Examine on-line documentation.
   6. Perform model inquiries.
3. Examine the parametric design cycle.
   1. Discuss design concepts and intent.
   2. Examine part, assembly, and drawing functionalities.
4. Examine model view representation.
   1. Discuss wire frame and solid representations.
   2. Explore part materials and colors.
   3. Examine view manipulation.
5. Discuss parametric CAD construction fundamentals.
   1. Discuss construction of parts using parametric methods.
   2. Examine the model tree.
   3. Modify objects.
   4. Discuss object associativity between parts, drawings, and assemblies.
   5. Discuss parametric feature relations.
   6. Examine datum features such as planes, axis, curves, and points.
   7. Create geometry.
   8. Discuss dependency hierarchy between parent/child features.
   9. Discuss feature attributes.
   10. Examine blind or through features.
   11. Discuss linear, radial, coaxial or on point features.
   12. Define sketched and placed features.
   13. Construct parts, assemblies, and drawings.
6. Utilize the parametric two-dimensional sketcher to construct geometry.
   1. Discuss and create construction geometry.
   2. Create datum features.
   3. Examine sketcher drawing tools.
   4. Examine sketcher constraints, assumptions, and relations.
   5. Create and modify parametric dimensioning.
   6. Examine sketch regeneration using troubleshooting un-regenerated sections.
7. Examine inserting features.
   1. Use the hole wizard tool for placement and hole type.
   2. Examine depth types: blind, thru, up to, offset, body, and mid-plane.
   3. Examine rounds and chamfers.
8. Examine modifying features
   1. Modifying features by edit feature, edit sketch, and re-routing.
   2. Delete features.
   3. Suppress and hide features.
   4. Mirror and copy features.
9. Discuss pattern features.
   1. Create linear, circular, curve, sketch, table, and fill patterns.
10. Discuss part design.
    1. Examine parametric design philosophy.
    2. Discuss part set up.
    3. Define base features.
    4. Examine dimensioning schemes.
    5. Add feature relations.
    6. Re-examine parent/child relationships.
    7. Display datum features.
    8. Display mass properties.
11. Examine other special shapes.
    1. Create splines, lofts, and helical curves.
    2. Discuss thin solids and surface models.
12. Examine assembly fundamentals.
    1. Examine assembly the design philosophy of top down and bottom up.
    2. Create a bottom up assembly.
    3. Apply assembly constraints.
    4. Perform assembly modifications and top down parts.
    5. Create assembly design using sub-assemblies.
    6. Examine exploded assemblies.
13. Describe drawing fundamentals.
    1. Create a drawing.
    2. Create drawing views with center lines.
    3. Create dimensions with tolerances.
    4. Modify dimensions.
    5. Create notes and drawing text.
    6. Examine sections and cutting planes.
    7. Use layers in drawings.
14. Examine plotting.
    1. Review drawing scales.
    2. Plot a drawing.
15. Discuss rapid prototypes.
    1. Examine different types of rapid prototype machines.
    2. Discuss different prototype materials.
    3. Create rapid prototype.

CAD 183 - Engineer Disciplines & Pract

1. Discuss civil engineering drawings.
   1. Discuss civil drawing and surveying units.
   2. Examine traverses.
   3. Discuss distance and elevation.
   4. Define metes and bounds.
   5. Discuss contour lines.
   6. Examine a highway plan and profile layouts.
   7. Examine a cut and fill.
   8. Create a civil drawing.
2. Examine architectural drawing practices.
   1. Discuss architectural drawing units and dimensioning.
   2. Discuss schedules.
   3. Discuss architectural line work and lettering.
   4. Examine architectural construction systems.
   5. Examine plan and elevations views.
   6. Examine sections.
   7. Discuss plot plans.
   8. Create an architectural drawing.
3. Examine structural drawings.
   1. Discuss structural drawing units.
   2. Examine structural steel shapes and schematic symbols.
   3. Discuss standard connections and symbols.
   4. Discuss structural steel drawings and dimensioning.
   5. Examine structural sections.
   6. Discuss bill of materials.
   7. Create a structural drawing.
4. Discuss pipe drawings.
   1. Define pipe drawings and units.
   2. Discuss pipe flow diagrams.
   3. Discuss pipe line representation in pipe plans and elevations.
   4. Describe types of pipe and sizes.
   5. Discuss pipe connections and symbols.
   6. Discuss pipe fittings and symbols.
   7. Discuss pipe flow controls and symbols.
   8. Discuss pipe dimensioning.
   9. Exam pipe details.
   10. Examine pipe isometric drawings.
   11. Create a pipe drawing.
5. Examine electrical drawings
   1. Discuss electrical drawing units.
   2. Examine electrical diagrams.
   3. Discuss power distribution drawings.
   4. Discuss residential/commercial drawings and symbols.
   5. Discuss electronic schematic drawings and symbols.
   6. Examine printed circuits.
   7. Discuss electrical pictorial drawings.
   8. Create a schematic.
   9. Create a block diagram.
6. Discuss mechanical drawing practices.
   1. Examine standard mechanical units and dimensioning practices.
   2. Identify detail drawings.
   3. Discuss purchased parts.
   4. Discuss assemblies.
   5. Identify parts lists, part numbers, and balloon identifications.
   6. Identify installation drawings.
   7. Discuss schematics and diagrams.
   8. Discuss drawing notes.
   9. Discuss part family trees.
   10. Discuss exploded assembly drawings.
   11. Examine engineering change orders (ECO).
   12. Create a mechanical assembly drawing.

CAD 184 - SolidWorks for Die Design

1. Discuss the Solid Works software.
   1. Discuss design intent.
   2. Discuss the Solid Works interface.
2. Discuss typical sketching techniques.
   1. Examine 2D sketching.
   2. Examine the stages in the process.
   3. Understand default sketching planes.
   4. Examine sketch entities.
   5. Selecting multiple Objects.
   6. Examine Dimensioning capabilities.
3. Examine Basic part modeling.
   1. Discuss the stages in the process.
   2. Discuss the terminology.
   3. Examine features.
   4. Determine how to choose the best profile.
   5. Determine how to choose the Sketch plane.
   6. Examine part details.
4. Examine Revolved Features.
   1. Study Hand wheel example.
   2. Establish Design Intent.
   3. Discuss the rules governing revolved features.
   4. Discuss the process to create the revolved feature.
5. Discuss shelling and ribs.
   1. Discuss the stages in the process.
   2. Analyze the addition of draft.
   3. Discuss the order of Operations to Shell.
   4. Examine Face Selection.
   5. Examine Plane Selection.
   6. Discuss Rib creation.
   7. Learn how to convert edges.
   8. Examine Full Round Fillets.
   9. Complete practice exercises.
6. Discuss Part Editing.
   1. Extract information from a model.
   2. Discuss Editing Issues.
   3. Examine the Fillet Expert Option.
   4. Examine the Draft Expert.
7. Examine how to Make Design Changes.
   1. Examine the stages in the process.
   2. Discuss the “Rollback” feature.
   3. Discuss how to make deletions.
   4. Discuss the “Reorder” Process.
   5. Examine the process to Copy Fillets.
   6. Determine how to edit with Instant 3D.
8. Examine Design Tables and Equations.
   1. Discuss Key Topics.
   2. Discuss Link Values.
   3. Discuss Equations.
   4. Examine Auto-Create feature.
   5. Examine Excel Formatting.
   6. Determine how to insert the Design Table.
9. Discuss pattern features.
   1. Analyze linear patterns.
   2. Analyze radial patterns.
10. Examine editing dimensional sizes.
    1. Discuss edits in model space.
    2. Examine re-defining a sketch.
    3. Examine dimension relations.
11. Discuss part design.
    1. Examine part design philosophy.
    2. Discuss part set up.
    3. Examine base features.
    4. Examine dimensioning schemes.
    5. Determine features.
    6. Add feature relations.
    7. Re-examine parent/child relationships.
    8. Display mass properties.
    9. Display datum plane(s).
12. Examine assembly fundamentals.
    1. Examine assembly design philosophy.
    2. Set-up an assembly.
    3. Apply assembly constraints.
    4. Perform assembly modifications.
    5. Create assembly design.
    6. Examine exploded assemblies.
13. Describe drawing fundamentals.
    1. Create a drawing.
    2. Create drawing views.
    3. Examine adding dimensions.
    4. Manipulate dimensions.
    5. Create notes and drawing text.
    6. Examine sections.
    7. Discuss layer(s).
14. Examine plotting.
    1. Discuss plotting to a file.
    2. Plot a drawing.

CAD 215 - Mechanical Systems

1. Analyze basic thread forms.
   1. Discuss thread theorems.
   2. Identify parts of the thread form.
   3. Calculate thread tolerances/fits.
   4. Review SAE/ANSI thread standards.
   5. Discuss standard thread forms.
   6. Discuss non-standard thread forms.
   7. Identify U.S. Customary thread standards.
   8. Identify metric thread standards.
   9. Discuss CAD construction of threads.
   10. Create thread drawings.
   11. Dimension threads and drawing callouts.
   12. Calculate thread tolerances/fits.
2. Identify complex thread forms.
   1. Identify parts of the thread form.
   2. Identify ACME, square, and miscellaneous complex threads.
   3. Discuss CAD construction of complex threads.
   4. Create and dimension detailed thread drawings.
3. Discuss thread applications beyond fastening.
   1. Discuss using threads for power transmission.
   2. Discuss hybrid types of mechanisms. (Screw jacks, etc.)
4. Identify standard threaded fasteners.
   1. Discuss standard threaded fastener data.
   2. Examine screws and bolts.
   3. Examine bolt grades and head markings associated with the grades.
   4. Discuss drawing callouts for standard fasteners.
   5. Examine fastener drive design, such as hex, slotted, etc…
   6. Create standard threaded fasteners in CAD.
   7. Create a library of fasteners.
5. Examine pipe threads.
   1. Discuss taper threads and how they can be sealed.
   2. Discuss straight pipe threads.
   3. Discuss ISO and U.S. Customary standards.
   4. Examine drawing callouts for pipe threads.
6. Examine threaded nuts.
   1. Discuss hex and other standard nuts.
   2. Discuss castle and other locking nuts.
   3. Discuss nuts with a built in washer.
7. Discuss washers.
   1. Examine washer applications and usage.
   2. Discuss flat, lock, tooth, and conic washers.
8. Discuss rivets.
   1. Examine rivet applications.
   2. Discuss rivet data/specifications.
   3. Discuss ANSI standard drawings configuration for rivet heads.
9. Discuss locational/alignment hardware.
   1. Discuss purpose of locational/alignment hardware.
   2. Examine the tolerances of locational/alignment hardware.
   3. Examine keys, keys seats, and key ways.
   4. Discuss dowel pins.
   5. Discuss shear pins.
   6. Examine clevis pins.
   7. Examine roll pins.
   8. Discuss cotter pins.
10. Examine non-standard mechanical fasteners.
    1. Examine retaining rings, internal and external.
    2. Examine retaining ring groove specifications and tolerances.
    3. Examine ¼ turn fasteners.
    4. Examine pressed in fasteners.
    5. Examine latches.
    6. Discuss clamps.
    7. Examine threaded rod.
    8. Discuss masonry fasteners.
    9. Discuss plastic fasteners.
    10. Discuss welded fasteners.
    11. Examine security fasteners.
    12. Discuss specification data sheets.
    13. Create non-traditional fastener and specification.
11. Discuss mechanical springs.
    1. Discuss springs - compression, extension, and torsion.
    2. Discuss data required for a spring drawing.
    3. Create a spring drawing and included data.
12. Discuss mechanisms.
    1. Identify parts of a planar mechanism.
    2. Create kinematic diagrams.
    3. Examine mobility.
    4. Discuss Gruebler’s equation.
    5. Calculate degrees of freedom.
13. Discuss linkage mechanisms.
    1. Examine four bar linkages.
    2. Discuss Grashof’s criterion.
    3. Qualify and categorize linkages.
    4. Identify the limits of motion.
    5. Identify points of interest.
    6. Identify slider crank mechanisms.
14. Analyze mechanical timing devices.
    1. Examine cams - plate, face, and drum.
    2. Discuss cam followers.
    3. Create a cam displacement diagram and cam drawing.
    4. Examine timing belts.
15. Investigate gears.
    1. Discuss types of gears.
    2. Discuss gear definitions.
    3. Discuss gear formulas.
    4. Calculate gear data.
    5. Draw a tooth profile and gear.
    6. Discuss gear drive trains.
    7. Discuss gear backlash.
    8. Determine center to center distances.

CAD 220 - MicroStation CAD

1. Examine file management
   1. Review system directory structures
   2. Define file-based systems
   3. Examine the MicroStation file manager
   4. Examine the file menu
   5. Discuss input devices
2. Discuss the graphical user interface (GUI).
   1. Discuss the graphical user interface
   2. Examine the control menu
   3. Examine view scaling
   4. Examine view attributes
   5. Examine the design plane
   6. Analyze the command window
   7. View menus
   8. View dialog boxes.
   9. Examine settings boxes.
   10. View frames.
   11. View toolboxes
3. Explain settings
   1. Discuss MicroStation help
   2. Discuss working units
   3. Discuss system setting defaults
   4. Discuss precision input settings
   5. Define levels
   6. Discuss text settings
   7. Discuss the tool settings box
4. Discuss elements
   1. Discuss settings/applications relations
   2. Examine element placement
   3. Examine multi-line toolbox
   4. Examine text placement
5. Examine element editing
   1. Examine change attribute toolbox
   2. Apply modify element toolbox
   3. Apply extend element toolbox
   4. Use modify arc radius toolbox
   5. Apply manipulate elements toolbox
   6. Utilize drop linestring status
   7. Apply mirror toolbox.
   8. Discuss deleting elements
   9. Use the text editor
   10. Examine text modification/atttributes
   11. Manipulate text
   12. Examine multi-line manipulation toolbox
6. Discuss element selection
   1. Examine single element select
   2. Discuss multiple element select
   3. Analyze group element select
   4. Discuss grouping orphan cells
   5. Discuss selected element locks
7. Describe graphic groups
   1. Discuss graphic group locks
   2. Discuss adding/removing graphic groups.
8. Examine fences
   1. Discuss fence placement
   2. Apply move fence toolbox.
   3. Apply change fence contents toolbox
   4. Apply modify/stretch fence contents toolbox.
   5. Use manipulate fence contents toolbox
   6. Examine fence locks
   7. Examine the working set.
9. Discuss drawing cells
   1. Create a cell
   2. Apply cell placement toolbox
   3. Apply cell manipulation toolbox
   4. Discuss drop cell status
   5. Discuss cell libraries
10. Discuss patterns.
    1. Create a pattern shape
    2. Discuss creating chains
    3. Apply the pattern toolbox
    4. Examine pattern settings
    5. Modify patterns
11. Examine reference files
    1. Attach a reference file
    2. Examine manipulation
    3. Discuss levels and level symbology
12. Discuss dimensioning
    1. Examine dimension settings
    2. Apply dimension placement toolbox
    3. Utilize dimension element command
    4. Examine associative dimensioning
    5. Modify/manipulate dimensions
13. Examine images
    1. Discuss displaying images/text
    2. Discuss raster images.
    3. Discuss raster vs. vector images
    4. Discuss converting images.
14. Discuss drawing duplication
    1. Examine plotting
    2. Discuss printing

CAD 240 - Applied Materials & Processes

1. Identify standard materials.
   1. Identify ferrous materials.
   2. Identify non-ferrous materials.
   3. Identify elastomers.
2. Discuss the casting process.
   1. Examine sand castings.
   2. Examine die castings.
   3. Discuss non-traditional castings.
   4. Discuss post-processing of castings.
3. Analyze hot working metals.
   1. Discuss forgings and upset forgings.
   2. Identify hot rolled parts such as tubing and extrusions.
4. Analyze cold working metals.
   1. Identify cold working materials.
   2. Discuss the cold drawing process.
   3. Examine cold drawn parts, such as tubing and wire.
   4. Discuss the cold-heading process.
5. Discuss inspection measuring systems and instruments.
   1. Examine non-precision measuring systems.
   2. Examine semi-precision measuring systems.
   3. Examine precision measuring systems.
6. Identify basic cutting tools.
   1. Examine basic turning tools, internal and external.
   2. Examine basic drills, counter bores, counter sinks, and reams.
   3. Examine basic vertical, horizontal, and profile mill cutters.
7. Discuss basic turning operations.
   1. Identify lathe operations.
   2. Discuss safety precautions.
8. Examine basic turning operations.
   1. Examine facing operation.
   2. Examine turning operation.
   3. Examine knurling operation.
   4. Examine drilling/boring operation.
9. Discuss basic milling operations.
   1. Discuss up (climb) and down milling.
   2. Discuss vertical and horizontal mills.
   3. Discuss plunge cutting.
   4. Discuss shop safety.
10. Examine basic sheet metal operations.
    1. Discuss punch press operations.
    2. Discuss brake bending operations.
    3. Discuss hand forming operations.
    4. Discuss safety precautions.
11. Examine basic sheet metal bends.
    1. Examine bends equal to, less than, and greater than 90 degree bends.
    2. Examine compound bending.
12. Examine basic welding.
    1. Examine basic fillet welds.
    2. Examine basic plug welds.
    3. Examine basic butt welds.
    4. Examine basic single-v welds.
    5. Examine basic double-v welds.
    6. Examine basic flare-v welds.
    7. Examine basic flange edge welds.
    8. Examine basic torch cutting.
    9. Discuss welding operation/application problems.
13. Examine non-traditional fabrication methods.
    1. Discuss chemically milled parts.
    2. Discuss laser etched parts.
    3. Discuss discharged electrically milled parts.
14. Identify standard plastics.
    1. Examine thermoset plastics.
    2. Examine thermoplastic plastics.
    3. Identify plastic operations such as injection molding.

CAD 242 - Manufacturing Interfaces

Credits: 3
Lecture Hours: 2
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech

1. Discuss the product design phase (R&D).
2. Analyze manufacturing and CAD platform considerations of R&D
3. Outline model prototyping.
4. Describe conventional machining techniques that could be used for prototyping.
5. Differentiate between cutting and shaping tools.
6. Discuss non-traditional machining processes.
7. Examine the manufacturing phase.
8. Evaluate industrial and tool engineering.
9. Assess manufacturing flow.
10. Evaluate process control.
11. Interpret quality control and inspection.

2.  Assess Computer-Aided Manufacturing (CAM).

1. Examine numerical control (NC), computer numerical control (CNC), and direct numerical control (DNC).
2. Discuss advantages and disadvantages of CNC.
3. Identify CNC applications.
4. Examine CAM software
5. Evaluate loading a CNC program to a milling machine and running program.
6. Perform CAD file translation.

3. Examine precision measurement.

1. Identify measurement systems.
2. Discuss semi-precision and precision measurements.
3. Perform measurements and read measurement tools.
4. Measure and determine surface roughness using chart and roughness gauge.
5. Calculate and build gauge block stacks.
6. Calculate sine bar angles and stacks.
7. Perform measurements.
8. Prepare a coordinate measurement machine (CMM).
9. Discuss CMM applications and data extraction.
10. Measure a part using the CMM.

4. Assess Computer-Integrated Manufacturing (CIM).

1. Define computer-integrated manufacturing (CIM).
2. Explain five problems that may occur in a CIM environment.
3. Evaluate CIM advantages/disadvantages.

5. Evaluate flexible manufacturing system (FMS).

1. Describe a flexible manufacturing system (FMS).
2. Assess FMS advantages and disadvantages.
3. Identify the seven basic factors essential to MRP implementation.
4. Demonstrate how an MRP system performs its calculations.

6. Critique file data exchange formats.

1. Describe how the CAD drawing data is used in manufacturing.
2. Analyze IGES (*JGS) files.
3. Analyze DXF (*.DXF) files.
4. Perform import/export problems.

7. Analyze tool path generation.

1. Define tool path.
2. Examine three-dimensional applications.
3. Create CNC tool paths using master CAM.
4. Discuss using three-dimensional CAD solid models for tool path generation.

8. Analyze database data extraction.

1. Discuss what data is contained in a CAD file.
2. Differentiate what data is contained in a CAM file.
3. Diagram printing or extracting the data from the file.
4. Examine data that can be added to a CAD file.
5. Classify read only terminals for inspection.
6. Demonstrate using precision measuring machines for data
7. Describe how data from a part can be used to reverse engineer a part in CAD/CAM.
8. Observe a CMM gathering data.

9. Examine manufacturing database inventory files.

1. Describe how parts are tracked.
2. Discuss bar coding.
3. Examine how CAD/CAM/CIM/JIT and MRP are inter-connected.
4. Summarize how the data used for one project can be applied to improve quality.

10.  Evaluate different welding types and processes.

1. Identify lap and butt joints.
2. Assess different welding processes such as TIG, MIG, arc, and submerged welding.
3. Examine different testing methods for welds.
4. Discuss different welding certifications and testing positions.

11.  Assess linear, angular, and radial measurements with hand tools.

1. Identify proper measurement hand tools used to measure linear, angular and radial measurements.
2. Describe the proper care and usage of various measurement hand tools.
3. Interpret measurement readings on digital, Vernier, and scale-type devices.
4. Define the limits of interpolation of each measurement device.

CAD 246 - Parametric CAD I

1. Discuss parametric design.
   1. Discuss what solid modeling is.
   2. Discuss what parametric design is.
2. Discuss parametric CAD system fundamentals.
   1. Examine the screen layout.
   2. Examine the main menu.
   3. Examine menu structures.
   4. Examine coordinate system.
   5. Examine file naming.
   6. Examine file management.
   7. Examine operating environment settings.
   8. Examine setting up a configuration file.
   9. Examine on-line documentation.
3. Examine the parametric design cycle.
   1. Discuss design concepts and intent.
   2. Examine part functionalities.
   3. Examine assembly functionalities.
   4. Examine drawing functionalities.
4. Discuss parametric CAD construction fundamentals.
   1. Discuss construction of parts.
   2. Discuss construction of assemblies.
   3. Discuss construction of drawings.
   4. Examine modifying objects.
   5. Discuss object associativity.
   6. Discuss parametric feature relations.
   7. Examine design datums and axis.
   8. Discuss creating geometry.
   9. Examine linear dimensions.
5. Examine parametric CAD dimensioning.
   1. Examine linear dimensions.
   2. Examine diameter dimensions.
   3. Examine radial dimensions.
   4. Examine angular dimensions.
6. Utilize a parametric 2-dimensional sketcher.
   1. Discuss construction feature creation.
   2. Discuss use of datum planes.
   3. Discuss parent/child hierarchy.
   4. Discuss feature attributes.
   5. Discuss blind or through features.
   6. Discuss single features.
   7. Discuss pattern features.
   8. Discuss linear, radial, coaxial or on point features.
   9. Discuss modifying features.
   10. Discuss deleting features.
   11. Discuss suppressing features.
   12. Discuss using layers.
   13. Examine sketching tools.
   14. Examine sketch regeneration.
   15. Examine sketcher assumptions.
   16. Create cross-sections.
   17. Modify cross-sections.
   18. Examine creating sketches for features.
   19. Examine troubleshooting un-regenerated sections.
7. Examine editing dimensional sizes.
   1. Discuss edits in model space.
   2. Examine re-defining a sketch.
   3. Examine dimension relations.
8. Discuss part design.
   1. Examine part design philosophy.
   2. Discuss part set up.
   3. Examine base features.
   4. Examine dimensioning schemes.
   5. Determine features.
   6. Add feature relations.
   7. Examine parent/child relationships.
   8. Display layer(s) and datum plane(s).
   9. Display mass properties.
9. Examine assembly fundamentals.
   1. Examine assembly design philosophy.
   2. Set-up assembly and assemble parts.
   3. Apply assembly constraints.
   4. Perform assembly modifications.
   5. Create assemblies and sub-assemblies.
10. Describe drawing fundamentals.
    1. Create a drawing.
    2. Create drawing views.
    3. Display dimensions.
    4. Manipulate dimensions.
    5. Create and modify notes and drawing text.
    6. Create assembly drawings that include parts lists and notes.
11. Examine plotting.
    1. Discuss plotting to a file.
    2. Plot a drawing.
12. Review rapid prototype creation.
    1. Create prototype part.

CAD 248 - Parametric CAD II

1. Investigate advanced features.
   1. Examine advanced sweeps and helical sweeps.
   2. Examine constant and variable radius rounds.
   3. Examine ribs, draft, and lofts.
   4. Create Toroidal bends.
2. Examine saving sketcher profiles.
   1. Examine creating profile libraries.
   2. Discuss importing a saved profile into a parametric sketch.
   3. Discuss using profiles to create holes.
   4. Examine associatively between the saved sketch and the parts.
3. Examine advanced patterning.
   1. Examine pattern tables.
   2. Examine parent/child relationships in patterns.
   3. Discuss maintaining individual properties within a pattern.
4. Discuss advanced layer applications.
   1. Discuss usage of layers with a CAD solid.
   2. Examine manipulating features using layers.
   3. Examine using layers in an assembly.
5. Analyze complex part creation.
   1. Discuss complex part origin.
   2. Examine how to create a complex part with machining considerations.
   3. Create complex parts and user defined features.
   4. Create part drawings with geometric tolerances.
   5. Examine mass properties.
   6. Discuss import/export file types.
   7. Export drawing file to AutoCAD to detail.
6. Examine complex drawing creation from a solid model.
   1. Discuss using view creation.
   2. Discuss bi-directional updating.
   3. Discuss hidden line removal.
   4. Examine retrieving dimensions from the solid model.
   5. Discuss deleting views.
   6. Discuss using reference files.
   7. Discuss masking geometry.
   8. Examine creating drawing annotation.
7. Create section views.
   1. Examine hatch patterns for section derived from assemblies.
   2. Discuss hidden line removal on a section view.
   3. Discuss dimensioning complex cross-sections created from a solid model.
   4. Discuss bi-directional updating from a section view.
   5. Discuss placing a section view on another drawing sheet.
8. Create auxiliary views.
   1. Discuss auxiliary view placement with respect to the primary solid views.
   2. Examine placing auxiliary views on other drawing sheets.
   3. Discuss bi-directional updating for auxiliary views.
9. Create complex assemblies.
   1. Examine creating parts within the assembly file.
   2. Create sub-assemblies.
   3. Discuss advanced assembly parent/child hierarchy.
   4. Create parts list.
   5. Create assembly cross-sections.
   6. Modify cross-sections.
   7. Discuss dimensioning assemblies.
   8. Perform assembly modifications.
10. Perform drawing replication.
    1. Plot detail drawings and assemblies.
    2. Print mass properties of a part.
11. Create a rapid prototype.

CAD 252 - Design Project I

1. Discuss design project conceptions.
   1. Discuss product markets.
   2. Examine supply and demand.
   3. Examine cost analysis.
2. Associate typical engineering jobs and duties as they pertain to the design project.
   1. Discuss design teams.
   2. Discuss manufacturing/engineering relationships.
   3. Discuss Product Lifecycle Management. (PLM)
   4. Discuss company and project security.
3. Analyze project components.
   1. Discuss detail parts.
   2. Discuss assemblies.
4. Review drawing types.
   1. Discuss layouts.
   2. Discuss detailed drawings.
   3. Discuss tabulated part drawings.
   4. Discuss specifications.
   5. Discuss source control drawings.
   6. Discuss assembly, weldment, and sub assembly drawings.
   7. Discuss parts lists in assemblies.
   8. Discuss bill of materials. BOM
   9. Discuss other types of drawings.
5. Analyze how the market for a product determines engineering conception and design.
   1. Evaluate how product marketing drives engineering projects.
   2. Examine how different factors can enter into product design.
   3. Research how marketing could effect your design.
6. Discuss creating an engineering project.
   1. Discuss project sketches.
   2. Discuss project layouts.
   3. Examine time estimates for drawings.
   4. Examine CAD/CAM/CAE considerations.
   5. Discuss material considerations.
   6. Discuss fabrication techniques.
   7. Discuss assembly techniques.
   8. Examine preliminary and critical design reviews.
   9. Discuss project milestones and GANTT charts.
   10. Discuss utilizing a 3D solid model for an assembly.
   11. Discuss automatic updates within engineering department. PLM
   12. Discuss purchased parts.
   13. Discuss engineer prototype.
7. Explore the engineering release cycle.
   1. Discuss drawing release cycles.
   2. Discuss the design drafter’s role in the release cycle.
8. Examine revision cycles.
   1. Examine a revision request document.
   2. Examine implementing a changes.
   3. Discuss releasing the change back into the engineering system.
   4. Discuss the design drafter’s role in the revision cycle.
9. Discuss reverse engineering.
   1. Examine reverse engineering applications.
   2. Discuss reverse engineering as a means of prototyping.
   3. Examine practical applications for reverse engineering.
   4. Reverse engineer a machined/cast part.
   5. Sketch and measure part with precision measurement tools.
   6. Reproduce part in parametric software and generate a rapid prototype.
   7. Discuss 3D scanning of parts and scan a machined/cast part.
   8. Convert scanned part into a featured parametric part.
10. Outline a design project.
    1. Select a design project.
    2. Perform a market research for the design project.
    3. Prepare project notebook.
    4. Present project ideas to class.
    5. Prepare preliminary sketches.
    6. Evaluate project with instructor.
    7. Evaluate project with subject matter experts.
11. Examine engineering prototypes.
    1. Discuss purpose of prototype.
    2. Examine prototype simulations.
    3. Discuss rapid-prototyping.
12. Create a project layout.
    1. Prepare layout conception from preliminary sketches.
    2. Create design layout of project.
    3. Calculate time management.
    4. Prepare project to be completed in CAD 254.

CAD 254 - Design Project II

1. Re-examine prototyping.
   1. Discuss fabricating engineering models.
   2. Re-examine rapid prototyping.
   3. Create a model from one of the parts in the design project.
2. Apply fits and clearances to project.
   1. Analyze tolerances on parts.
   2. Revise parts that interfere or fit improperly.
   3. Examine materials for possible warping, etc…
3. Examine design project materials.
   1. Discuss materials used in design.
   2. Examine problems with incompatible materials.
   3. Discuss fabrication and post-process effects on materials.
   4. Analyze altering or changing materials for cost, safety and/or durability.
4. Apply finishes to the design project.
   1. Apply corrosion protection as needed to project.
   2. Incorporate standard finishes.
   3. Determine if plating is needed.
   4. Adjust for effects of plating on part sizes.
   5. Determine if non-standard finishes are needed for project, such as plastic coating or cladding.
5. Evaluate manufacturing processes used in the design project.
   1. List manufacturing processes used in your design project.
   2. List machines required to manufacture the design project.
6. Create project cost analysis.
   1. Examine approximate cost of fabricated parts.
   2. Examine cost of purchased parts.
   3. Discuss steps that could cut cost of project.
   4. Discuss projected product life cycle.
   5. Create an approximate cost analysis of your project.
7. Examine re-designing parts and assemblies.
   1. Discuss design-to-cost principles.
   2. Discuss re-designing because of possible design failure(s).
   3. Examine re-designing because of copyright/patents.
8. Create a project parts drawing package in accordance with industry standards.
   1. Utilize proper drawing techniques.
   2. Utilize product lifecycle management to track revisions.
   3. Maintain project timeline tracking.
   4. Create part drawings.
   5. Plot part drawings.
9. Compile a project parts list.
   1. Discuss extracting attributes from database.
   2. Discuss using standard parts.
   3. Compile parts list.
   4. Examine sub-assemblies with associated parts lists.
   5. Discuss utilizing a parts list to build a product in a specific sequence.
10. Examine project parts list.
    1. Analyze parts list for cost reduction.
    2. Consider using purchased parts in place of manufactured parts.
    3. Examine consolidating parts lists.
    4. Cross check drawings and parts lists for errors.
11. Create project assembly drawing(s) package in accordance with industry standards.
    1. Insert parts lists.
    2. Correlate part data to assembly data.
    3. Examine clarifying assembly data by using sections and auxiliary views.
12. Compile project parts family tree.
    1. Discuss part hierarchy.
    2. Compile family tree.
13. Prepare a critical design review (CDR) for completed project.
    1. Compile final design journal entries.
    2. Create an appointment with the design reviewers for CDR. (Design reviewers appointed by instructor.)
    3. Meet with reviewers for completion of the CDR.
    4. Create notes of the CDR to be turned in with the project.
14. Complete a final design drawing package.
    1. Re-engineer parts that were found to be in need of change during your CDR.
    2. Re-plot any revised drawings.
15. Finalize the design project started in CAD 252.
    1. Submit design project contract.
    2. Submit design project final sketches.
    3. Submit design project journal.
    4. Submit design project report.
    5. Submit design project drawings.
    6. Submit design project family tree.
    7. Submit design project bill of materials.

CAT 430 - Caterpillar Fuel Systems

1. Explain the basic principles involved in a diesel fuel system
   1. List the five operations any fuel system must perform.
   2. Explain the operation of port and helix metering
   3. Compare the operation of sleeve metering.
   4. Distinguish an injector from a nozzle
   5. Explain the basic operation of a mechanical governor
2. Analyze the fundamentals of the pencil nozzle
   1. Identify the components of a pence nozzle
   2. Inspect the parts of a pencil nozzle
   3. Describe the fuel flow of a pencil nozzle.
   4. Explain the operation of a pencil nozzle.
   5. Test a pencil nozzle.
3. Examine the principles of the capped nozzle.
   1. Identify the components of a capped nozzle
   2. Inspect the parts of a capped nozzle.
   3. Describe the fuel flow of a capped nozzle
   4. Explain the operation of a capped nozzle
   5. Test a capped nozzle
4. Investigate the fundamentals of the 3116 fuel system
   1. Identify the components of a 3116 unit injector
   2. Inspect the parts of a 3116 unit injector
   3. Describe the fuel flow of a 3116 unit injector
   4. Explain the operation of a 3116 unit injector
5. Explore the principles of the CAT new scroll fuel system
   1. Identify the components of a CAT new scroll injection pump.
   2. Inspect the parts of a CAT new scroll injection pump
   3. Describe the fuel flow of a CAT new scroll injection pump.
   4. Explain the operation of a CAT new scroll injection pump.
   5. Adjust a CAT new scroll injection pump.
   6. Name the components of a CAT new scroll governor.
   7. Explain the operation of a CAT new scroll governor.
   8. Adjust a CAT new scroll governor
6. Analyze the fundamentals of the Caterpillar electronic fuel systems.
   1. Identify the components of a PEEC fuel system
   2. Describe the fuel flow of a PEEC fuel system
   3. Adjust the sensors of a PEEC fuel system.
   4. Identify the components of a 3176 fuel system
   5. Describe the fuel flow of a 3176 fuel system
   6. Adjust the injectors and valves on a 3176 engine
   7. Identify the components of a 3406E fuel system
   8. Describe the fuel flow of a 3406E fuel system
   9. Adjust the injectors and valves on a 3406E engine
   10. Inspect the parameters of the Caterpillar electronic fuel systems using ET.
   11. Examine the status of the Caterpillar electronic fuel systems using ET.
   12. Identify the fault codes of the Caterpillar electronic fuel systems using ET.
7. Troubleshoot CAT mechanically and electronically controlled engine problems
   1. Test mechanical engine components
   2. Diagnose mechanical engine problems
   3. Repair faults, where necessary, on a mechanical engine.
   4. Test electronic engine components
   5. Diagnose electronic engine problems
   6. Repair faults, where necessary, on an electronic engine.

CAT 431 - Caterpillar Failure Analysis

1. Demonstrate knowledge of metallugy on a written test
   1. Describe the basic process used to make pig iron
   2. Explain the difference between cast iron and steel
   3. Understand the metal structure of cast iron and steel
   4. Explain how alloy steel is made
   5. Understand the process used to forge metal
   6. Define what flow lines are.
   7. Explain the steps in heat treating process of metals and the benefits of
2. Demonstrate knowledge of visual examination process on a written test.
   1. Explain why a background fact check is beneficial to proper diagnosis.
   2. Describe why it is important to identify all parts from a failed component.
   3. Explain why it is important to protect all parts from corrosion and further
   4. Understand the process to clean parts prior to inspection. damage
   5. Know how to interpret date codes found on parts
   6. Explain why it is important to record facts found
3. Demonstrate knowledge of fractures to rotating shafts and gears on a written test.
   1. Understand metal strength vs. load
   2. Define fracture terminology
   3. Explain the difference between a ductile fracture and a brittle fracture.
   4. Know how to identify beach marks, ratchet marks, pitting, frosting and how each
   5. Explain the difference between fast fractures and slow fractures. effect shaft and gear life
   6. Inspect failed parts to determine cause of failure
   7. Explain stress raisers and their affect on rotating bending fatigue failures
   8. Inspect wear to gears and assess reusability
4. Demonstrate knowledge wear that occurs to bearings on a written test.
   1. Identify wear conditions that can act on antifriction bearings and bearing inserts.
   2. Explain how to properly handle bearings prior to and during installation.
   3. Describe the correct procedure to clean bearings for reuse
   4. Explain why lubrication is important to extended life.
   5. Understand the functions that lubricants must perform while in use
   6. Know the difference between petroleum and synthetic base lubricants, the
5. Demonstrate knowledge engine component wear on a written test. advantages of each, and the additives found in t
   1. Describe the affects of crown overheating to the piston
   2. Explain skirt overheating and the wear that occurs
   3. Know the conditions represented by foreign material being ingested into the
   4. Explain the signs present when workmanship is an issue cylinder
   5. Understand the stress areas on connecting rods and crankshafts.
   6. Explain the external forces that act on connecting rods and crankshafts.
   7. Describe the results of rebuild errors
   8. Describe the failures that can result from improper machining techniques
   9. Explain the internal forces the act on crankshafts and connecting rods.
   10. Understand the structure of a valve
   11. Know the environment a valve must operate in.
   12. Explain the result of valve operation in hostile conditions.
6. Demonstrate knowledge of threaded fasteners on a written test.
   1. Demonstrate ability to identify grades of fasteners and loading strength of each.
   2. Explain the abnormal operation failures
   3. Describe how stress raisers are caused during the manufacturing of fasteners.
   4. Demonstrate ability to troubleshoot fastener failures.

CAT 432 - Caterpillar LS/PC Hydraulics

1. Demonstrate knowledge of pressure compensated pumps on a written test.
   1. Identify parts on a pressure compensated axial pump
   2. Identify parts on a pressure compensated radial pump
   3. Adjust pressure on a pressure compensated pump
   4. Describe operation of a pressure compensated pump
2. Demonstrate knowledge of pressure compensated control valves on a written test
   1. Demonstrate the understanding of basic system schematics by color coding circuits.
   2. Describe the operation of a pressure compensated flow control valve.
   3. Explain the advantages of using pressure compensated flow control valves.
   4. Explain the purpose of a pressure reducing valve
   5. Demonstrate in the laboratory how a pressure reducing valve functions
3. Demonstrate knowledge of priority valves, and make-up valves on a written test.
   1. Explain a simple flow control valve
   2. Disassemble and identify parts on a simple flow control valve
   3. Explain a complex flow control valve
   4. Disassemble and identify parts on a complex flow control valve
   5. Explain the operation of a make-up valve
   6. Disassemble and identify the parts in a make-up valve
4. Demonstrate knowledge of the signal network used in pressure compensated systems on a written test
   1. Explain the purpose a double check valve ( RESOLVER) serves in the system
   2. Describe the purpose of primary and secondary resolvers
   3. Identify the locations of the valves on a Cat 416 backhoe
   4. Disassemble an individual valve in the lab and identify the parts and check for wear
   5. Explain oil flow through the valve
   6. Explain the purpose of an advanced signal passage found in the main control valve
   7. Describe how a signal pressure limiter functions
   8. Identify test port locations on the 416
   9. Perform trouble shooting tests as per manufactures guidelines

CAT 433 - Caterpillar Serv Info

1. Demonstrate Basic Computer Skills
   1. Turn on computer and monitor
   2. Identify computer system components and drives
   3. Demonstrate keyboard functions
   4. Demonstrate mouse functions
   5. Open and recall saved information
   6. Save and recall saved information
2. Using Caterpillar Service Information System
   1. Find parts information
   2. Find Service letters and update information
   3. Look up service procedures and specifications
3. Using Parts Integrator and Data Base system
   1. Look up parts from SIS
   2. Use DBS Parts ordering functions
   3. Transfer parts order information from SIS to DBS
4. Check on parts availability and backorders
   1. Look up parts in the local system
   2. Look up parts back order status
5. Perform Inquires
   1. Perform customers inquiries
   2. Perform machine and work order inquiries

CAT 434 - Caterpillar Internship

1. Demonstrate acceptable employee attendance habits
   1. Display regular attendance
   2. Demonstrate job punctuality
2. Provide the dealership with a responsible and productive employee.
   1. Present a positive attitude towards work
   2. Demonstrate the ability to learn
   3. Display employee dependability
   4. Show quality workmanship
   5. Exhibit good judgement
   6. Reveal initiative
   7. Display positive social interaction skills
3. Complete weekly internship reports and return to instructor
   1. Log daily work
   2. Indicate your diagnosis
   3. Hand in reports to instructor
4. Complete the assigned internship tasks
   1. Diagnose complaint before repair
   2. Measure components with precision measuring devices
   3. Follow supervisors instructions
   4. Order required parts
   5. Read and comprehend service manual
   6. Use SIS (Caterpillar Service Information System)
   7. Use Caterpillar ET (Electronic Technician)
   8. Repair hydraulic systems
   9. Read hydraulic schematics
   10. Repair electrical circuits
   11. Read electrical schematics
   12. Perform engine repairs

CAT 435 - Caterpillar MultiMedia

1. Fundamentals of Diesel Engines
   1. Understand basic engine principals
   2. Explain engine systems and properties
   3. Demonstrate knowledge of general maintenance procedures
2. Fundamentals of Mobile Hydraulics
   1. Understand basic hydraulic concepts
   2. Identify hydraulic components
   3. Read hydraulic schematics
   4. Demonstrate knowledge of Caterpillar hydraulic systems
3. Fundamentals of Electric Systems
   1. Demonstrate knowledge of basic electrical concepts
   2. Understand use of diagnostic tools
   3. Identify basic troubleshooting steps
   4. Explain and troubleshoot Caterpillar lighting systems
   5. Explain and troubleshoot Caterpillar starting systems
   6. Explain and troubleshoot Caterpillar charging systems
4. Fundamentals of Drive Trains
   1. Understand torque converters and torque dividers
   2. Explain transmission and transfer gear operation
   3. Demonstrate knowledge of axles and lower drivetrain systems
   4. Identify hydraulic drive systems

CET 101 - Engineering Fundamentals

1. Describe civil engineering
   1. Define civil engineering
   2. Explain the goals of the civil engineering field
2. Examine the people and projects of the civil engineering industry
   1. List the different disciplines in civil engineering
   2. List the types of projects in civil engineering
3. Identify the disciplines of the civil engineering technician
   1. Describe the surveying technician?s duties and responsibilities
   2. Describe the material tester?s duties and responsibilities
   3. Describe the design technician?s duties and responsibilities
   4. Describe the inspector’s duties and responsibilities
4. Explain fundaments of engineering
   1. Discuss the engineering problem solving process
   2. Discuss precision in engineering problems
5. Explain fundamentals of a roadway plan
   1. Define civil plans and specifications
   2. Examine stationing
   3. Discuss the elements of an alignment
   4. Discuss the elements of grading
   5. Define pavement structure
   6. Define roadway cross section terminology
   7. Discuss the organization of roadway plans
6. Examine a Construction Road Plan
   1. Investigate the Title Sheet
   2. Understand general notes and quantities
   3. Examine typical cross sections
   4. Understand estimate of quantities and general information
   5. Read the main line plan and profile sheets
   6. Read the side road plan and profile sheets
   7. Understand reference ties and bench marks
   8. Examine intersection geometric, staking and jointing details
   9. Understand the soil plan sheets
   10. Examine earthwork quantities
   11. Classify signing, wells and facility
   12. Investigate cross sections
7. Examine a Construction Concrete Beam Bridge Plan
   1. Identify basic bridge components
   2. Investigate the Title Sheet
   3. Understand general notes and quantities
   4. Distinguish elements on a situation plan
   5. Utilize general plan and soundings
   6. Understand details: piers, abutments, superstructure, intermediate diaphragms, barrier rails, beams, pier bearings

CET 110 - Materials Testing

1. Describe the Iowa Department of Transportation?s Technician Training Certification Program
2. Define Aggregate Types and the Use of Each
3. Explain the principles of sampling Aggregates
   1. Identify equipment needed for sampling
   2. Discuss minimum frequencies for sampling
   3. Identify size of sample needed for testing
   4. Perform the correct procedure for sampling
4. Examine Aggregate Properties and Characteristics
   1. Discuss general aggregate source information
   2. Define deleterious materials
   3. Understand resistance to abration
   4. Discuss absorption and surface moisture
   5. Understand specific gravity
   6. Define the relationship between shape and surface texture, and performance
   7. Understand gradation and its relevant specification structure
5. Perform critical aggregate laboratory tests
   1. Perform splitting operations to take an aggregate sample from field size to proper test sample size
   2. Perform method of test to determine the amount of material finer than the #200 sieve
   3. Perform sieve analysis of aggregates for fine, coarse and combined aggregate test samples
   4. Perform shale test for fine and coarse aggregates
   5. Understand results of a Los Angelos Abrasion Test
   6. Understand results of Soundness tests by freezing and thawing
   7. Perform aggregate specific gravity test
6. Describe reporting requirements for Iowa DOT
   1. Describe daily reports required to submit to districts
   2. Describe daily reports required to submit to central Iowa DOT
   3. Describe what makes up legal documentation for reporting
7. Describe plant inspection and tests performed on Portland Cement Concrete
   1. Property sample freshly mixed concrete
   2. Properly take temperatures of freshly mixed concrete
   3. Perform the slump of hydraulic concrete test
   4. Perform air content of freshly mixed concrete test by the pressure method
   5. Make, protect and cure concrete flexural strength field specimens
   6. Perform test of flexural strength of concrete using a simple beam with center-point loading beam breaker
   7. Discuss making, protecting, curing and testing concrete cylinders
   8. Discuss testing the strength of Portland Cement Concrete using the maturity method
   9. Discuss the method of test for flow of grout mixtures

CET 113 - Surveying Fundamentals

1. Learn surveying basics
   1. List famous surveyors
   2. Examine the early history of surveying
   3. Discuss the evolution of surveying equipment
   4. Discuss types and classes of surveys
   5. Understand different surveying reference systems
   6. Discuss the maintenance of equipment
2. Understand basic horizontal and vertical measurements
   1. Learn and illustrate basic measurement units
   2. Illustrate the necessity for accurate surveys
   3. Differentiate between accuracy and precision
   4. Identify sources of errors and mistakes
   5. Define significant figures
   6. Learn how to and understand the importance of survey planning
   7. Prepare various types of field notes
   8. Prepare electronically recorded notes
   9. Describe office work and digital computers
3. Using surveying equipment, demonstrate knowledge of measuring and corrections
   1. Use electronic distance measurements
   2. Discuss different uses of trigonometry in surveying
   3. Outline the types of corrections
   4. Discuss incorrect tape length or standardization error
   5. Examine the effect of temperature variations
   6. Define slope corrections
   7. Define sag and tension corrections
   8. Categorize common mistakes made in taping
   9. Describe the magnitude of errors
4. Learn the application of trigonometry in surveying calculations
   1. Use the law of sins in surveying calculations
   2. Use the law of cosines in surveying calculations
   3. Be able to calculate missing angles and lengths by using trigonometric
5. Utilize electronic distance measuring instruments (EDMs).
   1. Define basic terms
   2. List the types of EDMs
   3. Illustrate the set-up, leveling, and centering of EDMs
   4. Learn basic SMI software commands
   5. Locate errors in DEM measurements
   6. Discuss calibration of EDM equipment
   7. Illustrate the accuracy of EDMs
   8. Computer horizontal distances from slop distances
6. Examine different types of leveling
   1. Discuss the theory of leveling
   2. Define basic definitions
   3. Describe differential leveling
   4. Discuss the earth’s curvature and atmospheric refraction
   5. List the use of level rod targets
   6. Identify common leveling mistakes
   7. Examine leveling errors
   8. Show methods for good leveling
   9. Define the precision of differential leveling
   10. Show the use of hand signals
   11. Computer adjustments of level circuits
   12. Describe precise leveling
   13. Illustrate profile leveling
   14. Define profiles
   15. Define cross sections
7. Examine angles and directions
   1. Define meridians
   2. Define units of measuring angles
   3. Describe Azimuths and Bearings
   4. Examine uses of the Compass
   5. Define Traverse Angle Terms
   6. Prepare Traverse Computations
   7. Examine Magnetic Declination
8. Compare angles and directions with Transits, Theodolites, and Total Stations
   1. Examine Transits and Theodolites
   2. Produce measures of horizontal angles
   3. Produce measured angles by repetition
   4. Produce measured vertical angles
   5. Illustrate how to set-up the Theodolite
   6. Define forced centering
   7. Produce measured zenith angles with a Theodolite
   8. Examine the total station
9. Discuss miscellaneous angle concerns
   1. Identify common errors in angle measurement
   2. Identify common mistakes in measuring angles
   3. Define angle-distance relationships
   4. Understand resections
   5. Discuss older methods of traversing
10. Review modern traversing
    1. Reproduce the intersection of two lines
    2. Demonstrate prolonging a straight line by double centering
    3. Discuss proper methods of cleaning surveying equipment
    4. Place points on a straight line between two given points

CET 152 - Construction Inspection

1. Define reference documents needed on a construction project
   1. Define and explain hierarchy of documents
   2. Describe what documents are important
   3. Discuss what documents are available and from what sources
2. Describe duties of an inspector
   1. Discuss inspector duties
   2. Discuss importance of inspector understanding contract documents
   3. Learn documentation and record keeping requirements
3. Discuss work zone safety requirements
   1. Learn importance of work zone safety
   2. Define all aspects of a safe work zone
4. Understand inspection duties necessary for grading projects
   1. Determine relevant specifications needed for grading projects
   2. Determine Division II documents needed to inspect grading projects
   3. Determine RCE instructions needed to inspect grading projects
   4. Review grading plan sets to develop field notebook
   5. Summarize inspection duties necessary on a grading project
5. Understand inspection duties necessary for drainage projects
   1. Determine relevant specifications needed for drainage projects
   2. Determine Division II documents needed to inspect drainage projects
   3. Determine RCE instructions needed to inspect drainage projects
   4. Review drainage plan sets to develop field notebook
   5. Summarize inspection duties necessary on a drainage project
6. Understand inspection duties necessary for culvert projects
   1. Determine relevant specifications needed for culvert projects
   2. Determine Division II documents needed to inspect culvert projects
   3. Determine RCE instructions needed to inspect culvert projects
   4. Review culvert plan sets to develop field notebook
   5. Summarize inspection duties necessary on a culvert project
7. Understand inspection duties necessary for bridge projects
   1. Determine relevant specifications needed for bridge projects
   2. Determine division II documents needed to inspect bridge projects
   3. Determine RCE instructions needed to inspect bridge projects
   4. Review bridge plan sets to develop field notebook
   5. Summarize inspection duties necessary on a bridge project
8. Understand inspection duties necessary for Portland Cement Concrete (PCC)
   1. Determine relevant specifications needed for PCC paving projects
   2. Determine Division II documents needed to inspect PCC paving projects
   3. Determine RCE instructions needed to inspect PCC paving projects
   4. Review PCC paving plan sets to develop field notebook
   5. Summarize inspection duties necessary on a PCC paving project
9. Understand inspection duties necessary for hot mix asphalt (HMT) paving
   1. Determine relevant specifications needed for HMA paving projects
   2. Determine Division II documents needed to inspect HMA paving projects
   3. Determine RCE instructions needed to inspect HMA paving projects
   4. Review HMA paving plan sets to develop field notebook
   5. Summarize inspection duties necessary on a HMA paving project

CET 158 - Introduction to Drafting

1. Explain the basic concepts of drafting
   1. Explain purposes and applications of drafting
   2. Explain the basic tools and practices of manual drafting.
   3. Explain the basic tools and practices of computer-aided drafting
2. Demonstrate a working knowledge of the Miscrostation working environment.
   1. Explain the Microstation coordinate system and use precision inputs
   2. Set up project working units
   3. Explain mouse actions in Microstation
3. Utilize Microstation drawing aids.
   1. Use element attributes
   2. Use snaps
   3. Use locks
   4. Use element selection and the fence tool
   5. Use view controls
4. Print a hard copy of a drawing in Microstation
   1. Set plot settings
   2. Plot to scale
5. Place and manipulate geometric elements in a design file in Microstation.
   1. Set element attributes
   2. Place elements
   3. Modify elements
   4. Manipulate elements
6. Place and manipulate text in a design file in Microstation.
   1. Set text attributes
   2. Place text
   3. Edit text.
7. Utilize Accudraw in a design file in Microstation
   1. Use the Accudraw compass for rectangular and polar coordinates.
   2. Place elements of specific sizes and angles
8. Place cells in a design file in Microstation
   1. Navigate a cell library
   2. Create a cell
   3. Place a cell
9. Place patterns in a design file in Microstation
   1. Create a pattern
   2. Place a pattern
10. Place dimensions in a design file in Microstation
    1. Set dimension settings
    2. Place dimensions
11. Use reference files in Microstation
    1. Attach reference files
    2. Set reference file settings
    3. Manipulate reference files
12. Create a basic three-dimensional file in Microstation
    1. Use Accudraw in a three-dimensional file.
    2. Use multiple views to create three-dimensional drawings.

CET 180 - Engineering Surveying

1. Examine Topographic Surveying
   1. Discuss Contours
   2. Describe Methods of Obtaining Topography
   3. Define Stadia
   4. Identify Stadia Equipment
   5. Illustrate Field Procedure for Stadia Mapping
   6. Demonstrate Stadia Work
   7. Give Contour Characteristics
   8. Define Plane Table Surveys
   9. Examine Topographic Details Obtained With Total Stations
   10. List Map Symbols
   11. Describe to Method to Complete the Map
   12. List Specifications for Topographic Maps
   13. Define Profiles from Contour Maps
   14. Prepare Checklist of Items to be Included on a Topographic Map
2. Investigate Global Positioning System (GPS)
   1. Define Global Positioning System (GPS)
   2. Identify Monitoring Stations
   3. Illustrate Basic Theory
   4. Discuss how the Travel Time of a Satellite Signal is Measured
   5. Give Uses of GPS
   6. List Types GPS Signals
   7. Discuss GPS Errors
   8. Illustrate how to Minimize Errors
   9. Define Position Dilution of Precision(PDOP)
   10. Show Point Positioning and Relative Positioning
   11. Demonstrate Field Applications
   12. Define Continuously Operating Reference Stations(CORS)
   13. Define Kinematic Surveying
3. Investigate Geographic Information Systems (GIS)
   1. Illustrate the Uses of Geographic Information Systems
   2. Discuss the Historical Development of GIS
   3. Define Objectives of GIS
   4. Discuss the Advantages of a GIS
   5. Define the Accuracy in a GIS
   6. Show Coordinates and Map Projections
   7. Define Control Surveying use in GIS
   8. Produce Map Data for a GIS
   9. Show Inputting Computer Data
   10. Discuss Legal Concerns With GIS
4. Examine Construction Surveying
   1. Define a Construction Survey
   2. Describe the Work of the Construction Surveyor
   3. Describe Property Survey from the Contractors Viewpoint
   4. Define Preliminary Surveys
   5. Discuss Grade Stakes
   6. Examine Referencing Points for Construction
   7. Describe Building Layouts
   8. Describe Base Lines (Layout Performed by Surveyors)
   9. Describe Radial Staking Methods
   10. Place Batter Boards
   11. Define As-Built Surveys
5. Investigate Geometric Designs
   1. Identify Volumes and Volumes use in Construction
   2. Discuss Slopes and Slope Stakes
   3. Define Borrow Pits
   4. Define Cross Sections
   5. Illustrate Areas of Cross Sections
   6. Compute Earthwork Volumes
   7. Draw a Mass Diagram
   8. Calculate Volumes from Contour Maps
   9. Classify Volume Formulas for Geometric Figures
6. Examine Land Surveying or Property Surveying
   1. Define Land Surveying
   2. Describe Title Transfer and Land Records
   3. Discuss Common Law
   4. Define Monuments
   5. Illustrate Blazing Trees
   6. Discuss Monuments, Bearings, Distances and Areas
   7. Define Miscellaneous Terms Relating to Land Surveying
   8. Define Resurveys
   9. Discuss Metes and Bounds
   10. Discuss the U.S. Public Lands Survey Systems
   11. Discuss Early Days of the System
   12. Identify the Outline of the System
   13. Define Meander Lines
   14. Define Witness Corners
   15. Discuss Deed Descriptions of Land
7. Analyze Horizontal Curves
   1. Define Degree of Curvature and Radius of Curvature
   2. Discuss Curve Equations
   3. Calculate Deflection Angles
   4. Demonstrate Selection and Staking Out of Curves
   5. Show Field Procedure for Staking Out Curves
   6. Discuss Circular Curves Using the SI System
   7. Illustrate Horizontal Curves Passing Through Certain Points
   8. Define Spiral Curves
8. Analyze Vertical Curves
   1. Define Vertical Curves
   2. Calculate a Vertical Curve
   3. Discuss Miscellaneous Items Relating to Vertical Curves
   4. Define Unequal-Tangent Vertical Curves
   5. Illustrate a Vertical Curve Passing Through a Certain Point
   6. Describe Parabolic Equation
   7. Define Crowns
   8. Describe Superelevation
9. Examine Surveying-The Profession
   1. Discuss Surveying Licenses
   2. Discuss Registration Requirements
   3. List Penalties for Practicing Surveying Without a License
   4. Identify Reasons for Becoming Registered
   5. Define Surveying Code of Ethics

CET 192 - Statics

1. Identify and analyze a planar concurrent force system
   1. Use vectors to represent forces.
   2. Determine the rectangular components of a force.
   3. Determine the resultant of 2 or more planar concurrent forces by rectangular components
2. Apply equilibrium conditions to a planar concurrent force system.
   1. State the equilibrium conditions
   2. Sketch the proper free body diagram
   3. Apply the equilibrium conditions to a planar concurrent force system to determine unknown forces or orientations
3. Identify and analyze a planar nonconcurrent force system.
   1. Demonstrate a knowledge of the principle of transmissibility and the Theorem of Moments
   2. Determine the magnitude and location of the resultant of a distributed load.
   3. Determine the resultant of 2 or more planar nonconcurrent forces.
4. Apply equilibrium conditions to a planar nonconcurrent force system
   1. Identify the proper support conditions for a structure.
   2. Sketch a proper free body diagram for a structure.
   3. State the equilibrium conditions
   4. Apply the equilibrium conditions to a structure, subjected to a planar nonconcurrent force system, to determine unknown forces, locations, or orientations
5. Apply equilibrium conditions to simple plane trusses
   1. Discuss the assumptions used in the development of the model of a plane truss.
   2. Determine the internal force within a truss member by sue of the Method of Joints
   3. Determine the internal force within a truss member by use of the Method of Sections
6. Calculate the centroid location and moments of inertia for planar composite areas and simple structural cross sections
   1. Discuss the concept of the centroid of a plane area
   2. Discuss the concept of a composite area
   3. Calculate the location of the centroid of a composite area.
   4. Demonstrate the use of tables in the determination of the centroid of a structural cross section
   5. Discuss the concept of an area moment of inertia
   6. Demonstrate a knowledge of the Parallel Axis Theorem by the proper calculation of the moment of inertia of a composite area or a structural cross section.
7. Identify and calculate normal and shear stresses in an axially loaded member.
   1. Discuss the concepts of normal stress, shear stress, and bearing stress
   2. Calculate normal stress, shear stress, and bearing stress within an axially loaded member
   3. Explain the concepts of allowable stress and factor or safety
   4. Use allowable stress and factor of safety in the calculation of stresses within an axially loaded member
8. Identify and calculate normal strain in an axially loaded member.
   1. Discuss the concept of normal strain
   2. Explain tension tests, compression tests, and stress-strain diagrams.
   3. Demonstrate a knowledge of Hooke?s Law through proper stress, strain, or deformation calculations
   4. Calculate thermal deformations, strains, and stresses
9. Construct a shear force diagram and a bending moment diagram for a beam.
   1. Identify the various types of beams and applied loads
   2. Discuss internal shear force and internal bending moment in beams.
   3. Demonstrate a knowledge of the relation between applied loads, internal shear force, and internal bending moment by the construction of a proper shear diagram and a proper bending moment diagram
10. Identify, calculate, and locate the bending stress and the shear stress in a beam.
    1. Discuss the distribution of bending stress within a beam cross section.
    2. Demonstrate a knowledge of the flexure formula by the determination of the bending stress at a specified point within a beam
    3. Determine the magnitude and location of the maximum tensile bending stress within a beam and the maximum compressive bending stress within a beam.
    4. Discuss the distribution of shear stress within a beam cross section.
    5. Demonstrate a knowledge of the shear stress formula by the determination of the shear stress at a specified point within a beam
    6. Determine the magnitude and location of the maximum shear stress within a beam
11. Calculate the amount of deflection of a beam due to bending.
    1. Use tabulated formulas and the concept of superposition to calculate the maximum deflection of a loaded beam
    2. Determine if deflection exceeds code requirements.
12. Identify and analyze lateral buckling of an axially loaded column.
    1. Determine the Euler buckling load or critical stress for an axially loaded column.
    2. Discuss end conditions and lateral bracing of columns

CET 210 - PCC/HMA Plant Inspection

1. Describe the production of Portland cement concrete.
   1. Discuss concrete materials.
   2. Discuss influences of materials on performance of concrete.
2. Calculate batch weights for Portland cement concrete.
   1. Discuss proportioning materials.
   2. Utilize absolute volumes to calculate batch weights.
   3. Understand specific gravities, how they are determined, and how they are used in batch weight calculations.
3. Explain the effects of moisture content on batch weights.
   1. Calculate wet and dry batch weights.
   2. Adjust water and aggregate weights to account for moisture in the aggregate.
   3. Define the water cement ratio and its importance in concrete production.
   4. Perform moisture and water cement ratio calculations.
4. Describe the sampling and testing requirements for Portland cement concrete plant control.
   1. Explain aggregate sampling and testing requirements.
   2. Explain moisture sampling and testing requirements.
   3. Explain plastic concrete sampling and testing requirements.
5. Explain the requirements of the Certified Plant Inspector.
   1. Utilize IM 527 to explain Paving Plant inspection.
   2. Utilize IM 528 to explain Structural Plant inspection.
   3. Compare and contrast the difference between paving plant and structural plant inspection.
6. Analyze the basic ingredients in Hot Mix Asphalt.
   1. Explain performance graded asphalt binder.
   2. Describe the aggregates used in hot mix asphalt and their required properties.
   3. Apply volumetrics to understand the relationship between mass and volume.
   4. Explain the importance of air in the asphalt mix.
7. Discuss asphalt plant production.
   1. Understand the differences between drum and batch plants.
   2. Describe the flow of material in each type of plant.
   3. Explain the calibration process.
   4. Discuss weighing equipment specifications.
8. Describe the sampling and testing requirements for hot mix asphalt material components.
   1. Explain aggregate sampling.
   2. Explain Asphalt Binder sampling.
   3. Explain Uncompacted Mix sampling and perform hands-on testing.
   4. Explain compacted mix sampling and perform hands-on testing.
9. Calculate volumetric properties using test results and information obtained from the Job Mix Formula.
   1. Perform required daily calculations.
   2. Identify if the resultant answer meets specification requirements.
   3. Identify the ramifications if the results are not within specifications.
10. Utilize the Asphalt Plant Program to document daily data and calculate pay to the contractor.
    1. Input daily data into the asphalt plant program.
    2. Utilize tools available in the software program to calculate pay.

CET 215 - Roadway Design Fundamentals

1. Discuss an overview of highway development process
   1. Discuss a brief history of highway development.
   2. Discuss highway administration and finance
   3. Describe the 5 stages of the FHWA highway development process
2. Discuss the planning stage of high way development.
   1. Describe how traffic data is collected
   2. Discuss basic concepts of transportation modeling.
3. Discuss the project development (evaluation) stage of highway development
   1. Discuss economic analysis of projects
   2. Discuss basic concepts of transportation modeling
4. Discuss an overview of the design stage of highway development.
   1. Describe types of highway surveys
   2. Interpret basic plan features such as contours and stationing.
   3. Describe the steps of preparing preliminary and final road plans.
5. Discuss the basics of the right-of-way stage of highway development.
   1. Describe the principles of designing a right-of-way layout.
   2. Discuss the right-of-way acquisition process
6. Discuss the basics of the construction stage of highway development.
   1. Describe the process of selecting contractors to build a project.
   2. Describe the construction inspection process.
7. Discuss basic driver and vehicle characteristics
   1. Describe perception-reaction time and driver expectancy.
   2. Describe vehicle types, sizes, and performances.
8. Discuss basic design standards and controls
   1. Identify sources for design standards
   2. Describe design exceptions
   3. Identify the most important design controls.
9. Design the horizontal alignment of a highway
   1. Layout tangents for a horizontal alignment.
   2. Design curves for a horizontal alignment.
   3. Calculate stationing on curves and alignments.
   4. Design superelevation on curves
10. Design the vertical alignment of a highway
    1. Understand the principles of sight distance
    2. Layout tangents for a vertical alignment
    3. Design curves for a vertical alignment
    4. Calculate elevations along a vertical alignment.
11. Plot cross-sections for a highway project
    1. Describe elements of highway cross-sections
    2. Plot existing ground cross-sections
    3. Plot proposed roadway cross-sections
12. Compute earth work for a highway project
    1. Compute volumes of earthwork
    2. Plot a mass diagram
    3. Calculate overhaul from a mass diagram
13. Prepare construction details, specifications, and estimates of quantities.
    1. Create new or reference construction details for a highway project.
    2. Create a new or reference specifications for a highway project.
    3. Computer estimates of quantities for a highway project

CET 228 - CAD Graphics Lab

1. Refresh understanding of CAD drafting utilizing AutoCAD Civil 3D and Microstation.
   1. Setup initial Design Templates.
   2. Practice using drawing aids such as snaps, locks, view controls and element attributes.
   3. Create existing surfaces and profiles based on proposed horizontal elements
   4. Utilize software to create the initial files for a more detailed civil engineering design.

CET 240 - Soils and Erosion Control

1. Examine the concepts of geology and soil identification.
   1. Explain rock formations, classification and basic properties.
   2. Summarize weathering process conversion from rock to soil.
   3. Discuss transport process conversion from rock to soil.
   4. Outline basic soil properties and their influence on the behavior of soil as an engineering material.
   5. Compare soil index properties and their application to soil performance.
2. Evaluate soils in the Unified, USDA and AASHTO soil classification systems.
   1. Perform field soil identification tests.
   2. Perform coarse soil sieve analysis test.
   3. Perform hydrometer analysis test.
   4. Perform Plastic Limit Test.
   5. Perform Liquid Limit Test.
   6. Calculate Plasticity Index.
   7. Utilize results from soil tests to classify soils.
   8. Compare and contrast soil performance based on its classification.
3. Formulate the principles of total and effective stress in the subsurface.
   1. Discuss the total stress versus depth in the subsurface.
   2. Calculate effective stress versus depth and the effect of ground water levels.
   3. Review total and effective horizontal stresses with depth.
   4. Analyze the effect of ground water levels on buoyant forces.
4. Analyze subsurface stresses, soil consolidation, and settlement.
   1. Calculate the change in subsurface stress due to external forces.
   2. Review methods of vertical and horizontal stress distribution.
   3. Discuss the concept of drainage, permeability, and soil consolidation.
   4. Determine the effect of ground water levels on settlement.
   5. Perform unconfined compression strength test.
5. Assess subsurface sampling processes and procedures.
   1. Understand the importance of Field Observations and documentation.
   2. Explain Sample Treatment Procedures.
   3. Interpret Soil reports.
6. Evaluate Moisture-Density relationships and their impact on compaction requirements.
   1. Perform Proctor & Modified Proctor moisture-density tests.
   2. Perform Sand Cone Density tests.
   3. Obtain Radiation Safety Certification.
   4. Perform Nuclear Density Test.
   5. Perform test for moisture content of soil.
7. Discuss Erosion and Sediment Control requirements.
   1. Review and become familiar with details in the contract documents.
   2. Understand the difference between erosion and sediment control and requirements of both on highway construction projects.
   3. Discuss Best Management Practices for erosion and sediment control.
   4. Explain the requirements of the Storm Water Permit.

CET 243 - Land Surveying

1. Review Traverse Surveys
   1. Define Traverse Surveys
   2. Perform calculations to balance field angles
   3. Review Meridians
   4. Review Bearings
   5. Review Azimuths
   6. Review Latitudes and Departures
   7. Define Traverse Precision and Accuracy
   8. Calculate Compass Rule Adjustment
   9. Identify the Effects of Traverse Adjustments on Measured Angles and Distances
   10. Identify Omitted Measurement Computations
   11. Calculate Rectangular Coordinates of Traverse Stations
   12. Calculate Area of a Closed Traverse by the Coordinate Method
2. Review Topographic Surveying and Drawing
   1. Review Basics of Topographic Surveys
   2. Define the Precision Required for Topographic Surveys
   3. Diagram Cross Sections and Profiles Drawings
   4. Use Theodolite to collect topographic data
   5. Download and analyze collected data
   6. Produce CAD Contour Drawing
3. Examine Construction Surveying
   1. Define Construction Control Survey
   2. Define preliminary surveys
   3. Discuss grade stakes
   4. Describe building layouts
   5. Describe base lines (layout performed by surveyors)
   6. Describe radial staking methods
   7. Place batter boards
   8. Define as-built surveys
4. Review Global Positioning Systems (GPS)
   1. Operate various Global Positioning Systems (GPS)
   2. Discuss the CORS
   3. Discuss the OPUS
   4. Understand Satellite Geometry
   5. Review errors
   6. Illustrate current GOPS Surveying Techniques
   7. Discuss survey planning
   8. Define Initial Ambiguity Resolution
   9. Discuss Vertical Positioning
5. Investigate Highway Curves
   1. Define Route Surveys
   2. Review Circular Curves
   3. Calculate Circular Curve Geometry and Deflections
   4. Produce Chord Calculations
   5. Produce Field Procedure
   6. Illustrate Moving Up on the Curve
   7. Create Offset and Compound Circular Curves
   8. Calculate Offset and Compound Circular Curves
   9. Define Reverse Curves
   10. Discuss Vertical Curves
   11. Calculate offset and compounded circular curves
6. Examine Highway Construction Surveys
   1. Define Preliminary (Pre-Engineering) Surveys
   2. Illustrate Highway Design
   3. Produce Highway Construction Layout
   4. Discuss Clearing, Grubbing, and the Stripping of Topsoil
   5. Show Placement of Slope Stakes
   6. Layout Line and Grade
   7. Produce Grade Transfer
   8. Describe Ditch Construction
7. Investigate land surveying
   1. Review the public land survey system
   2. Understand boundary surveying
   3. Create land descriptions
   4. Create land corner certificates
   5. Create plat of survey
   6. Review the code of Iowa relative to land surveying
   7. Review Iowa Administrative Code 193C.
   8. Troubleshoot survey problems
   9. Demonstrate proficiency with survey instruments

CET 252 - Construction Documents

1. Description of the construction industry
   1. Examine the economy and construction industry
   2. Understand public vs private construction
   3. Examine manufacturing vs construction
2. Describe construction contracting methods and nature thereof
   1. Be familiar with the five types of contracting methods
   2. Describe construction management at risk
   3. Understand descriptors and elements of a contract
3. Understand issues concerning real property
   1. Define tax and mechanics liens
   2. Understand imminent domain
   3. Describe right-of-way and zoning
4. Define agents and forms of organizations
   1. Define the principle and agent
   2. Understand the creation and termination of an agency
   3. Define contingent liability
   4. Understand proprietorships, partnerships and corporations
5. Understand contract disputes and torts
   1. Define contract disputes
   2. Define torts
6. Describe surety bonds and the bidding process
   1. Define and understand the different types of bonds
   2. Understand bonding limits and default
   3. Understand bid advertisements
   4. Define phases of the bid process
7. Examine construction contract documents and their legal applications
   1. Define contract documents and their hierarchy
   2. Define unit price, cost plus and lump sum contracts
   3. Understand change orders and their implications
   4. Define changed conditions and the responsible party
8. Understand matters of time and payments
   1. Understand construction duration and project schedule
   2. Understand matters of time involved in the contract
   3. Examine types of payment
   4. Examine final payment and retainage
9. Discuss warranties and construction insurance
   1. Understand the difference between expressed and implied warranties
   2. Understand and define owners acceptance of work
   3. Understand and define types of insurance for construction
   4. Understand terms of insurance
10. Examine subcontractors and subcontracts and international construction contracts
    1. Understand general contractor, subcontractor and owner relationship
    2. Understand what work is subcontracted and how subcontractors are selected
    3. Discuss insurance requirements of subcontractors
11. Examine methods of dispute resolution and professional ethics
    1. Understand the difference between negotiation, litigation and ADR techniques
    2. Define ethics and examine ethics scenarios

CET 255 - Roadway/Highway Design

1. Discuss the goals of drainage system design
   1. Describe the goals and components of surface drainage systems
   2. Describe the goals and components of subsurface drainage systems
2. Discuss computation of surface runoff
   1. Explain return period
   2. Compute surface runoff using rational method
3. Discuss design of open channels
   1. Compute flow depth in open channels using Manning’s equation
   2. Design open channels for a given flow quantity
4. Discuss design of culverts
   1. Design sizes of culverts for inlet control
   2. Design sizes of culverts for outlet control
5. Discuss design of basic storm sewer systems
   1. Design locations and sizes of intakes
   2. Design sizes and slopes of storm sewer pipes
6. Discuss the principles of roadside design
   1. Describe clear zones and recovery areas
   2. Identify types and criteria of longitudinal barriers
   3. Design a longitudinal barrier system
7. Discuss the principles of intersection and interchange design
   1. Describe the types and functions of at-grade intersections
   2. Describe the types and functions of grade separated interchanges
   3. Perform a basic parking facilities design
8. Identify and design highway pavements
   1. Compare the benefits of rigid pavements and flexible pavements
   2. Design jointing of rigid pavements
   3. Design the thickness of pavements
9. Discuss the basic principles of highway capacity analysis
   1. Perform capacity analysis for freeway segments
   2. Perform capacity analysis for signalized intersections
10. Discuss the basic principles of traffic engineering
    1. Describe traffic control devices and systems
    2. Describe traffic control in work zones
11. Discuss the design of other transportation systems
    1. Describe the design of air systems
    2. Describe the design of rail systems
    3. Describe the design of bicycle systems
12. Discuss principles of access management
    1. Discuss how access management can improve safety and capacity
    2. Discuss successful access management designs

CET 258 - Roadway Design with Geopak

1. Explain the function of each of the files used in GEOPAK
   1. Describe Microstation specific drawing files
   2. Describe GEOPAK specific files
2. Utilize the project manager to manage a project in GEOPAK
   1. Set up a project in the project manager
   2. Update the project manager after each step in the design process
3. Create, display and analyze digital terrain models in GEOPAK
   1. Create a digital terrain model from survey data
   2. Edit an existing digital terrain model
   3. View contours and other features of a digital terrain model
   4. Analyze various features of a digital terrain model
4. Store and manipulate geometric elements using GEOPAK coordinate geometry (COGO).
   1. Store points, lines, curves, chains, and parcels into the COGO database
   2. Visualize elements stored in the COGO database
   3. View descriptions of elements stored in the COGO database
5. Utilize the functions of the design and computation manager in GEOPAK
   1. Use the D & C Manager to draw elements with standard crafting attributes
   2. Use the D & C manager to place pavement markings
   3. Use the D & C manager to computer quantities of plan items
6. Generate existing ground profiles along alignments in GEOPAK
   1. Extract profiles for the .tin file
   2. Draw the profile using the D&C Manager
7. Create vertical alignments using the vertical alignment generator in GEOPAK
   1. Create new vertical alignments
   2. Modify existing vertical alignments
   3. Lock and unlock parameters of vertical alignments
8. Generate existing ground cross sections along an alignment in GEOPAK
   1. Place pattern lines to define locations of cross sections
   2. Generate existing ground cross sections at desired locations
   3. Review existing ground cross sections with the Cross Section navigator
9. Apply superelevation to a roadway in GEOPAK
   1. Create superelevation shapes
   2. Analyze shapes for desired information
10. Generate proposed cross sections in GEOPAK
    1. Select appropriate criteria files
    2. Define al variables needed for processing the cross sections
    3. Process the proposed cross sections
11. Utilize the Port Viewer to view the 3 perspectives of the project
    1. View a specific project location in plain, profile, and cross-section views
    2. Observe changes in each view as multiple cross-sections are reviewed
12. Computer earthwork for a project in GEOPAK
    1. Define soil classifications
    2. Computer earthwork
13. Generate cross section sheets in GEOPAK
    1. Set parameters for sheets
    2. Plot sheets in the design file
14. Create various cross section reports in GEOPAK
    1. Describe all available cross section reports
    2. Create a seeding report
15. Draw limits of construction for a project in GEOPAK
    1. Set parameters for limits of construction
    2. Plot limits of construction in the design file
16. Become proficient in labeling plans in GEOPAK
    1. Place location and direction labels in the drawing
    2. Create custom labels
17. Generate plan and profiles sheets using GEOPAK
    1. Set parameters for sheets
    2. Plot sheets in the design file
18. Create a 3D model of a completed project
    1. Generate 3D cross-sections and interpolate between them
    2. Use “drive through” to view the model.

CET 291 - Structural Design & Const

1. Review the mechanics of bending and analyze concrete beams
   1. Discuss the properties of concrete and analyze concrete beams
   2. Review the mechanics of bending and the use of the flexure formula
   3. Analyze a rectangular concrete beam by use of the internal couple method
2. Analyze stress and strain aspects of concrete
   1. Discuss the assumptions in the strength design method
   2. Discuss and illustrate the stress distribution in rectangular, reinforced concrete beams and slabs
3. Analyze and design rectangular, reinforced concrete beams
   1. Analyze rectangular, reinforced concrete beams containing only tension steel
   2. Design a rectangular, reinforced concrete beam containing only tension steel
4. Analyze and design one-way slabs
   1. Discuss one-way slabs
   2. Analyze reinforced, one-way slabs containing only tension steel
   3. Design reinforced, one-way slabs containing only tension steel
5. Analyze and design reinforced concrete T beams
   1. Identify T beams
   2. Analyze and design reinforced concrete T beams
6. Analyze and design doubly reinforced beams
   1. Discuss rectangular, doubly reinforced concrete beams
   2. Analyze and design rectangular, doubly reinforced concrete beams
7. Analyze and design reinforced concrete beams for shear forces
   1. Discuss the requirements for shear reinforcement in rectangular, reinforced concrete beams
   2. Determine the required shear strength of a rectangular, reinforced concrete beam
   3. Determine the required stirrup size and spacing for a loaded, reinforced concrete beam
8. Analyze and design continuous floor systems
   1. Use ACE code coefficients and equations to construct shear and moment diagrams for continuous floor systems
   2. Use shear and moment diagrams in the design of a continuous floor system
9. Analyze and design short, reinforced concrete columns
   1. Determine the axial load strength for short, reinforced concrete columns
   2. Discuss the ACI code requirements for short, reinforced concrete columns
   3. Analyze and design short, reinforced concrete columns

CET 302 - Field Internship

1. Categorize techniques and skills learned in the course work
   1. List the required civil engineering technician skills involved in the coop
   2. Develop ability to work under pressure
   3. Develop habits of neatness, thoroughness, a concern for accuracy techniques and the importance of good communication
2. Develop objectives that measure directed activities and performance standards.
   1. List goals related to coop activities
   2. Select six of the most appropriate listed goals
   3. List the activities to achieve each listed goal
   4. Develop performance standards to determine when goals are achieved
3. Compose college and employer reports
   1. List required reports
   2. Identify recipients of reports
   3. Identify due date of each report
   4. Complete report forms as required
   5. Give reports to identified recipients
4. Comply to policies, procedures, and regulations
   1. Identify employer expectations for an intern
   2. List employer policies and procedures to be complied with
   3. Identify and observe all company regulations that are applicable to interns
5. Display a professional appearance
   1. Avoid tardiness
   2. Develop abilities to show initiative
   3. Develop pride in doing a job well
   4. Complete tasks within acceptable standards of quantity and quality of work

CET 304 - Field Coop

1. Reconstruct duties completed through internship.
   1. Use knowledge, skills, and attitudes required for business careers.
   2. Use effective communications skills for employment.
   3. Develop techniques of good listening.
   4. Identify importance of ability to carry on a conversation.
   5. Identify awareness of aids to good communciation skills.
   6. Describe importance of retraining and learning new skills.
2. Categorize techniques and skills learned in the course work.
   1. List the required civil engineering technician skills involved in the coop.
   2. Develop ability to work under pressure.
   3. Develop habits of neatness, thoroughness, a concern for accuracy techniques and the importance of good communciaiton.
3. Develop objectives that measure directed activities and performance standards.
   1. List goals related to coop activities.
   2. Select six of the most appropriate listed goals.
   3. List the activities to achieve each listed goal.
   4. Develop performance standards to determine when goals are achieved.
4. Compose college and employer reports.
   1. List required reports.
   2. Identify recipients of reports.
   3. Identify due date of each report.
   4. Complete report forms as required.
   5. Give reports to identified recipients.
5. Comply to policies, procedures, and regulations.
   1. Identify employer expectations for an intern.
   2. List employer policies and procedures to be complied with.
   3. Identify and observe all company regulations that are applicable to interns.
6. Display a professional appearance.
   1. Avoid tardiness.
   2. Develop abilities to show initiative.
   3. Develop pride in doing a job well.
   4. Complete tasks within acceptable standards of quantity and quality of work.

CET 305 - Field Coop

1. Reconstruct duties completed through internship
   1. Use knowledge, skills, and attitudes required for business careers
   2. Use effective communications skills for employment
   3. Develop techniques of good listening
   4. Identify importance of ability to carry on a conversation
   5. Identify awareness of aids to good communication skills
   6. Describe importance of retraining and learning new skills
2. Categorize techniques and skills learned in the course work
   1. List the required civil engineering technician skills involved in the coop
   2. Develop ability to work under pressure
   3. Develop habits of neatness, thoroughness, a concern for accuracy techniques and the importance of good communication
3. Develop objectives that measure directed activities and performance standards
   1. List goals related to coop activities
   2. Select six of the most appropriate listed goals
   3. List the activities to achieve each listed goal
   4. Develop performance standards to determine when goals are achieved
4. Compose college and employer reports
   1. List required reports
   2. Identify recipients of reports
   3. Identify due date of each report
   4. Complete report forms as required
   5. Give reports to identified recipients
5. Comply to policies, procedures, and regulations
   1. Identify employer expectations for an intern
   2. List employer policies and procedures to be complied with
   3. Identify and observe all company regulations that are applicable to interns
6. Display a professional appearance
   1. Avoid tardiness
   2. Develop abilities to show initiative
   3. Develop pride in doing a job well
   4. Complete tasks within acceptable standards of quantity and quality of work

CET 307 - Field Orientation

1. Accurately discuss the defined duties of the following
   1. The superintendent
   2. The project manager
   3. The Civil Engineering Technician
2. Understand the relationship and duties of the contractor and owner
   1. Contract Obligations
   2. Gentlemen’s Agreements
   3. Liability
3. Be able to diagram a basic construction schedule
4. Visit and report on each of the following major project categories
   1. Grading
   2. Bridge or culvert
   3. Asphalt Cement Concrete
   4. Portland Cement Concrete

CHM 105 - Survey of Chemistry

1. Give examples of the role of chemistry in a person’s daily life
2. State the nature of scientific inquiry and methods
3. Measure laboratory-size quantities using metric units
   1. Use the balance properly
   2. Measure volume with laboratory glassware
   3. Measure temperatures in Celsius
   4. Perform acid-base titrations
   5. Find the density of various substances
4. Examine the history of the understanding of matter using various models of the atom
   1. Define Dalton’s atom
   2. Draw the atom as understood by Thomson
   3. Explain how Rutherford’s experiments led to an understanding of the nucleus
   4. Predict the electron arrangement for small atoms using the ideas of Bohr
   5. Draw the atom as conceived by Heisenberg and Schrodinger
5. Explain line spectra based on the wave nature of light and the atomic structure of matter
6. Examine nuclear reactions
   1. Discuss the nature of alpha, beta and gamma radiation’s
   2. Use the concept of half-life to predict the effective lifetime of a radioactive substance
   3. Identify the damage caused by the various forms of radiation
   4. Predict the isotopes formed during alpha and beta decay
   5. Explain fission and fusion
7. Predict the properties of certain elements
   1. Label important regions on the periodic table
   2. Predict loss and gain of electrons for representative elements
   3. Predict electrical charges for ions based on their location on the periodic table
8. Use the symbolism of chemistry
   1. Give formulas for selected polyatomic ions
   2. Predict formulas for compounds based on the nature of their components
9. Name selected elements and compounds
10. Express the results of simple chemical reactions in the form of chemical equations
    1. Identify reactants and products
    2. Label the symbols used in chemical equations
    3. Balance simple chemical equations
11. Identify acids and bases in terms of their structures and properties
    1. Define acid, base and salt
    2. List simple tests for acids and bases
    3. Write neutralization equations
    4. Associate acidity and basicity with the pH value
12. Name selected organic substances
13. Demonstrate an understanding of plastics
14. Draw portions of various plastics given the monomer structure
    1. Define terms related to plastics
    2. Draw polymer structures based on their monomer structures
    3. Discuss advantages and drawbacks of plastics
15. Identify the role of various, important food molecules
16. Identify the chemical composition and properties of chemicals found in the home.

CHM 122 - Intro to General Chemistry

1. Demonstrate a working knowledge of measurement using both the metric and English systems
   1. Apply rules for use of significant figures to measurements and calculations
   2. Perform calculations to convert measurements
2. Describe the composition and structure of atoms
   1. Distinguish between atoms and isotopes of various elements based on sub-atomic particles
   2. Apply the periodic nature of the chemical elements to predict and explain chemical and physical properties
3. Differentiate between the various types of chemical compounds and bonds
   1. Describe the composition and structures of chemical compounds
   2. Apply the principles of bonding to the formation of molecular and ionic substances
   3. Describe how electrons are involved in ionic, non-polar covalent, and polar covalent bonding
   4. Write chemical names and formulas for ionic and molecular substances
   5. Draw Lewis structures to represent ionic compounds and covalent molecules
   6. Predict the shapes of molecules using VSEPR theory
4. Relate numbers of particles and mass through the concepts of formula ratios and the mole.
5. Write and interpret chemical equations which describe chemical changes
   1. Classify chemical reactions based on reaction patterns and write appropriate chemical equations
   2. Select appropriate mole ratios to balance chemical equations
   3. Use balanced equations to calculate quantities involved in chemical changes
   4. Describe the energy change involved in chemical reactions
   5. Explain the various factors that influence reaction rates
   6. Describe the conditions of a dynamic chemical equilibrium and apply these conditions to qualitatively predict how the system responds to stress
6. Distinguish properties associated with the various physical states of matter
   1. Use the ideas of Kinetic Molecular theory to describe gas behavior
   2. Use the Gas Laws to quantify gas properties
   3. Differentiate between properties of solids, liquids, and gases
   4. Explain changes of state in relation to intermolecular forces and energy changes
7. Demonstrate an understanding of the characteristics of solutions
   1. Qualitatively describe the composition of solutions
   2. Quantitatively express the concentration of solutions
   3. Perform calculations using concentration units
   4. Apply principle of polarity to explain solubility
   5. Compare physical properties of solutions to pure solvent
8. Demonstrate a working knowledge of acid-base chemistry
   1. Identify acids and bases
   2. Describe how acidic and basic substances act in aqueous solution
   3. Write chemical equations for the reactions of acids and bases
   4. Calculate the pH of solutions based on acid or base concentration
9. Work safely in a laboratory environment
   1. Use the balance to measure mass
   2. Use laboratory glassware (beakers, graduated cylinders, pipets, burets, and volumetric flasks) to measure volume
   3. Dispense solids and liquids
   4. Use the Celsius thermometer to measure temperature
   5. Use Bunsen burners properly
   6. Record and analyze laboratory data qualitatively and quantitatively
10. Apply scientific ideas and interpret data to make informed decisions on matters related to science in the public arena

CHM 132 - Intro to Organic/Biochemistry

1. State the properties of carbon as the basis of organic molecules
2. Apply the rules of bonding carbon to other nonmetals to build organic molecular structures
   1. Draw valence bond structures from molecular formulas
   2. Draw 3-dimensional pictures of molecules from valence bond structures
3. Generate the isomers possible for any molecular formula
4. Identify the common functional groups found in organic molecules
5. Compare polarity, boiling point & solubility of the various organic molecules
6. Predict the results of the chemical interactions of the various classes of organic molecules.
7. Demonstrate an understanding of the structures of biochemicals
   1. Draw Haworth structures from Fischer projections of carbohydrates
   2. Combine monosaccharides to form di or polysaccharides
   3. Combine amino acids to form the primary protein structure
   4. Recognize the classes of lipids
   5. Translate nucleotide sequences into amino acid sequences
8. Investigate the mode of action of enzymes
   1. Label the parts of an enzyme
   2. Identify important locations on an enzyme surface
   3. Explain the lock & key theory
   4. Recognize the 6 classes of enzymes
   5. Investigate the effects of activators on enzyme activity
   6. Show the effect of changes in environment on the activity of an enzyme
9. Interpret heredity based on the structures of nucleic acids
   1. Identify the components of the nucleic acids
   2. Relate the structures of DNA components to their location in the molecule
   3. Relate the functions of the 3 types of RNA
   4. Investigate the process of protein synthesis
   5. Assess the influence of mutation on protein synthesis
10. Explain how living cells process energy
    1. Identify high energy molecules
    2. Interpret energy diagrams of reactions
    3. Identify coenzymes found in electron transport
    4. Identify the location of the energy reaction in the mitochondria
    5. Examine the reactions of electron transport
11. Decipher the metabolic pathways of certain biochemicals
    1. State the functions of glycolysis, glycogenesis, glycogenolysis, the pentose shunt, the Krebs cycle and gluconeogenesis
    2. Relate the role of glucose, pyruvic acid, acetyl coenzyme A, alpha-ketoglutaric acid, and oxaloacetic acid in metabolism
    3. Follow the processes of the degradation of glucose
    4. Determine the products of metabolic reactions
    5. Identify the classification of enzymes in a given process
    6. State the relationship of carbohydrate metabolism to protein & fat metabolism

CHM 165 - General/ Inorg Chemistry I

1. Develop a variety of problem-solving skills
   1. Review operations with scientific notation
   2. Use significant figures properly
   3. Review English-metric conversions
   4. Solve problems by dimensional analysis
2. Investigate various classifications and properties of matter
   1. Distinguish between extensive and intensive properties.
   2. Differentiate physical and chemical changes and properties.
   3. Classify substances as compounds or mixtures.
   4. Solve problems involving density
   5. Interconvert various temperature scales
   6. Solve problems involving heat transfer
3. Examine various aspects of composition stoichiometry
   1. Differentiate between atoms, molecules and ions
   2. Calcualte masses of various formula units.
   3. Relate the moe unti to other units of matter measurement.
   4. Solve problems invovling percent composition of matter.
   5. Determine empirical and molecular formulas from experimental data.
   6. Derive formulas from composition data
4. Demonstrate an understanding of solutions.
   1. Qualitatively describe the composition of solutions.
   2. Quantitatively express the concentration of solutions.
   3. Perform calculations using concentration units.
   4. Identify limiting reactants
   5. Solve problems involving percent yield
   6. Relate sequential reactions to one another
   7. Use percent by mass to describe solution concentration
   8. Use molarity to describe solution concentration
   9. Use solution concentration in stoichiometry problems
5. Predict quantities involved in chemical changes.
   1. Balance chemical equations.
   2. Perform stoichiometric calcuations invovling moles, masses, and mass changes.
   3. Calculate percent yield.
   4. Review basic relationships involving electromagnetic radiation
   5. Use electromagnetic radiation to investigate the Bohr model of the atom
   6. Use quantum numbers to identify electrons
   7. Use the periodic table to determine electron configurations for elements
   8. Distinguish between paramagnetism and diamagnetism
6. Describe the composition and structure of atoms and isotopes.
   1. Distinguish between atoms and isotopes of various elements based on sub-atomic particles.
   2. Describe basic relationships involving electromagnetic radiation as it relates to modern models of atomic structure.
   3. Predict the arrangement of electrons in atoms based on the periodic table.
   4. Apply the periodic nature of the chemical elements to predict and explain chemical and physical properties.
   5. Use electronegativity to describe the relative electron-attracting ability of the elements
7. Demonstrate an understanding of ionic compounds.
   1. Describe the composition and formation of ionic compounds.
   2. Write chemical names and formulas for ionic compounds.
   3. Assign oxidation numbers to elements in an ionic compound.
   4. Predict formulas for covalent compounds
   5. Distinguish between polar and non-polar covalent bonds
   6. Differentiate polar bonds from polar molecules
   7. Draw Lewis dot structures for chemical species
   8. Assign oxidation numbers to elements
   9. Interconvert names and formulas for compounds
8. Demonstrate an understanding of covalent bonding.
   1. Describe the composition and formation of molecular substances.
   2. Describe how electrons are involved in nonpolar covalent and polar covalent bonding.
   3. Write names and formulas of molecular substances.
   4. Draw Lewis dot structures to represent covalent substances.
   5. Predict the shapes and polarities of molecules using the VSEPR theory.
9. Analyze chemical reactions based on similar patterns.
   1. Distinguish between electrolytes and non-electrolytes.
   2. Identify oxidizing and reducing agents in an oxidation-reduction reaction.
   3. Identify conjugate pairs in Bronsted Acid-Base reactions.
   4. Given the reactants write net ionic equations for acid-bas and precipitation reactions.
   5. Classify reactions as combination, decomposition, displacement, or metathesis
   6. Classify reactions as acid-base or redox
   7. Relate the behavior of reactants in chemical reactions to their positions on the periodic table
   8. Predict common oxidation numbers for the representative elements
   9. Predict logical reaction products for various types of chemical reactions
10. Distinguish properties associated with gases.
    1. Use the ideas of the kinetic molecular theory to describe a gas’s behavior.
    2. Use gas laws to quantify gas properties.
    3. Relate gas laws to stoichiometry problems.
    4. Use the combined gas law
    5. Use Avogadro’s law
    6. Use the ideal gas law
    7. Determine molecular weights of gases
    8. Determine densities of gases
    9. Use Dalton’s Law of Partial Pressures
    10. Calculate relative diffusion rates of gases
    11. Compare real and ideal gases
    12. Relate gas laws to stoichiometry problems
11. Relate thermodynamics to chemical processes.
    1. Explain what the First Law of Thermodynamics means.
    2. Calculate energy changes involved in chemical reactions and processes.
    3. Calculate enthalpy changes using Hess’s Law.
    4. Incorporate changes of state into heat transfer problems
    5. Diagram various cubic unit cells
    6. Relate unit cell dimensions to atomic or ionic radii
    7. Use unit cell data to predict densities of solids
    8. Determine various physical properties from a phase diagram
12. Investigate the condensed states of matter.
    1. Describe the 4 types of interparticle attractions.
    2. Discuss the relationship between vapor pressure, evaporation rate, attractive forces, boiling point, and melting point.
    3. Incorporate changes of state into heat transfer problems.
    4. Explain how pressure affects solubility of gases in liquids
    5. Use molality to express solution concentration
    6. Use mole fraction to express solution concentration
    7. Predict vapor pressures of solutions using Raoult’s Law
    8. Calculate the boiling point of a solution
    9. Calculate the freezing point of a solution
    10. Explain how electrolytes affect colligative properties
    11. Solve problems involving osmotic pressure
13. Perform various laboratory operations.
    1. Develop accurate measurement techniques.
    2. Use laboratory equipment in aprescribed manner.
    3. Handle chemicals safely.
    4. Collect data from a variety of experiments.
    5. Use experimental data to study chemical theories.
    6. Relate experimental measurements to classroom work.

CHM 175 - General/ Inorg Chemistry II

1. Explain reaction rates and their relationships to reaction mechanisms.
   1. Define and express reaction rates quantitatively, and identify factors that influence them.
   2. Quantitatively relate experimental data, reaction rates, rate laws and rate parameters.
   3. Model reactions with collision theory and transition state theory.
   4. Relate kinetic outcomes to plausible reaction mechanisms.
2. Apply basic principles of chemical equilibrium.
   1. Describe a system at equilibrium.
   2. Solve and evaluate problems involving equilibrium constants.
   3. Use the reaction quotient to predict if a system is at equilibrium.
   4. Describe how stresses on a system affect the equilibruim position.
   5. Using thermodynamic data, calcuate the equilibrium constant.
   6. Use Lewis theory to explain acid-base behavior
   7. Use molarity to solve acid-base stoichiometry problems
   8. Use equivalents to describe acid-base reactions
   9. Solve acid-base stoichiometric problems using normality
3. Investigate principles related to acid-base chemistry.
   1. Compare acid-base behavior according to three major theories (Arrhenius, bronsted-Lowry, and Lewis).
   2. Identify conuugated acid-base pairs.
   3. Determine relative strengths of acids and bases.
   4. Perform quantitative calculations related to acid-bas equilibria, titrations, buffer systems, and salt solutions.
   5. Determine bond energies from thermodynamic data
   6. Describe the relationship between energy and entropy in predicting the spontaneity of a process
   7. Calculate entropy changes from thermodynamic data
   8. Calculate free energy changes from thermodynamic data
   9. Estimate the temperature range over which a particular process would be spontaneous
   10. Recognize the limitations of thermodynamics in predicting path-dependent information
4. Apply equilibruim principles to slightly soluble strong electrolytes.
   1. Solve problems involving solubility product constants.
   2. Describe how the nature of reactants can affect reaction rates
   3. Derive rate law expressions for reactions using experimental data
   4. Determine the order of a reaction
   5. Solve problems involving the half-life of a first order reaction
   6. Use collision theory to model chemical reactions
   7. Use transition state theory to model chemical reactions
   8. Explain the relationship of activation energy to reaction rates
   9. Relate rate data to simple reaction mechanisms
   10. Explain how temperature affects reaction rates
   11. Describe the effect of a catalyst on the rate of a reaction
5. Apply the basic principles of chemical equilibrium
   1. Describe the characteristics of a process at equilibrium
   2. Determine the value of an equilibrium constant in terms of molari­ty
   3. Use the reaction quotient to predict where a reaction is with respect to equilibrium
   4. Solve problems involving equilibrium constants
   5. Evaluate the equilibrium constant for a reaction involving gases in terms of partial pressures
   6. Describe equilibrium shifts caused by various changes in experi­mental conditions
   7. Determine the new position of equilibrium after a shift has oc­curred
   8. Distinguish between homogeneous and heterogeneous equilibria
   9. Solve problems involving heterogeneous equilibria
   10. Calculate equilibrium constants at standard temperature from thermodynamic data
   11. Estimate equilibrium constants at non-standard temperatures using thermodynamic data
6. Relate equilibrium principles to acid-base chemistry
   1. Review differences between strong and weak electrolytes
   2. Determine the pH of a solution
   3. Calculate ionization constants for weak electrolytes
   4. Determine the percent ionization of a weak electrolyte
   5. Use ionization constants to solve problems
   6. Explain how acid-base indicators work
   7. Illustrate the effect of a common ion on the ionization of a weak electrolyte
   8. Describe the action of a buffer solution
   9. Relate the composition of a buffer solution to the pH of the solu­tion
   10. Select appropriate materials to make a buffer solution with a specif­ic pH.
   11. Predict the change in pH caused by adding an acid or base to the buffer solution
   12. Describe the ionization of polyprotic weak electrolytes using two or more ionization constants
   13. Solve problems involving the ionization of polyprotic weak electro­lytes
7. Apply equilibrium principles to hydrolysis and acid-base titrations
   1. Recognize ions that will undergo hydrolysis.
   2. Determine ionization constants for ions that hydrolyze
   3. Calculate the pH of solutions of various classes of salts
   4. Determine the percent hydrolysis of various ions
   5. Extend the concept of hydrolysis to ions derived from polyprotic weak electrolytes
   6. Determine the pH at various points in the titration of a strong acid with a strong base
   7. Determine the pH at various points in the titration of a weak acid with a strong base
   8. Determine the pH at various points in the titration of a strong acid with a weak base
   9. Select appropriate indicators for use in a particular titration
8. Apply equilibrium principles to slightly soluble strong electrolytes
   1. Calculate solubility product constants
   2. Solve problems involving solubility product constants
   3. Determine which of two species will precipitate first in a fractional precipitation
   4. Use ionization constants in conjunction with solubility products to solve problems on simultaneous equilibria
   5. Describe various methods for dissolving slightly soluble strong electrolytes
   6. Use dissociation constants for complex ions to solve problems
   7. Calculate the quantities of materials needed to dissolve slightly soluble strong electrolytes
9. Relate oxidation-reduction processes to electrochemistry
   1. Review the principles of oxidation-reduction chemistry
   2. Balance redox reactions via the half-reaction method
   3. Apply the equivalent concept to oxidizing or reducing agents
   4. Use normality to solve problems involving redox stoichiometry
   5. Distinguish between electrolytic and galvanic cells
   6. Determine which electrode serves as anode or cathode
   7. Apply Faraday’s Law to electrolytic cells
   8. Explain the operation of a simple galvanic cell
   9. Use standard electrode potentials to determine the potential of a galvanic cell
   10. Diagram electrochemical cells
   11. Use the Nernst equation to calculate the potential of cells under non-standard conditions
   12. Relate the cell potential to the free energy change
   13. Use standard potentials to determine equilibrium constants
10. Examine various aspects of nuclear chemistry
    1. Review the composition of the nucleus
    2. Relate neutron-proton ratio to nuclear stability
    3. Calculate binding energies for atomic nuclei
    4. Describe various modes of radioactive decay
    5. Predict the type or types of decay that are most likely for certain kinds of nuclei
    6. Use half-life to solve problems involving radioactive decay process­es
    7. Write equations for various radioactive decays
    8. Compare natural radioactivity to artificial transmutation
    9. Distinguish between fission and fusion
11. Perform various laboratory exercises
    1. Collect experimental data from a variety of procedures
    2. Use laboratory equipment as instructed
    3. Analyze unknowns using semi-micro qualitative analysis
    4. Compare experimental results to those predicted in theory
    5. Handle chemicals safely
    6. Derive conclusions from experimental measurements

CHM 263 - Organic Chemistry I

1. Identify information from general chemistry which is most applicable to organic chemistry
   1. Predict electronic structure of atoms
   2. Match the size of an atom to its position on the periodic table
   3. Select which of two elements has the higher electronegativity
   4. Distinguish between ionic and covalent bonding
   5. Write various types of formulas for organic molecules
   6. Define bond lengths
   7. Define bond angles
   8. Calculate heats of reaction from bond dissociation energies
   9. Distinguish between homolytic and heterolytic bond cleavage
   10. Review the nature of polar covalent bonds
   11. Recognize the principle attractive forces which are used by covalent molecules
   12. Extend acid-base chemistry to organic molecules
2. Investigate the basic structure of organic molecules
   1. Describe chemical bonding using molecular orbital theory
   2. Use valence-bond (hybridization) theory to explain chemical bond­ing
   3. Identify functional groups in organic molecules
   4. Illustrate delocalization of electrons in conjugated double bond systems
   5. Distinguish between resonance structures and isomers
   6. Recognize when resonance is possible in an organic molecule
   7. Draw appropriate resonance structures using standard electron movement designations
   8. Identify more or less important resonance structures
3. Relate the structure of an organic molecule to its systematic name
   1. Draw structures for the various isomers represented by a certain molecular formula
   2. Outline a system for naming organic compounds based upon their structures
   3. Apply the nomenclature system to a variety of organic molecules containing different functional groups
4. Investigate the chemistry of the simplest organic molecules, the alkanes
   1. Predict various physical properties of alkanes based on structure
   2. Illustrate complete combustion of an alkane with chemical equa­tions
   3. Predict products of halogen substitution reactions of alkanes
5. Generate appropriate pictures to model the three-dimensional structure of organic molecules
   1. Draw structures showing cis-trans (E-Z) isomerism in alkenes
   2. Recognize cis-trans isomerism in cycloalkanes
   3. Show conformations of open chain compounds using various pro­jections
   4. Identify the relative energies of molecular conformations
   5. Draw various conformations of cyclohexane derivatives
   6. Illustrate chirality using structures
   7. Relate chirality to the rotation of plane-polarized light
   8. Assign absolute configuration to a chiral carbon atom using the R-S system
   9. Extend the description of a chiral molecule to systems containing more than one chiral center
   10. Name organic molecules including the appropriate stereochemical designations
   11. Describe various methods of resolving racemic mixtures
6. Examine the properties of the alkyl halides
   1. Recognize various classifications of alkyl halides
   2. Predict various physical properties of alkyl halides
   3. Review the nomenclature of alkyl halides
   4. Compare the nature of substitution and elimination reactions
   5. Write the mechanism for an SN2 substitution
   6. Write the mechanism for an SN1 substitution
   7. Compare various aspects of the SN1 and SN2 reactions
   8. Write a mechanism for an E1 elimination
   9. Write a mechanism for an E2 elimination
   10. Compare various aspects of the E1 and E2 reactions
   11. Identify the factors which favor substitution or elimination reac­tions
   12. Predict which reaction mechanism is most likely based upon the conditions
   13. Predict products of alkyl halide reactions with various nucleophile/bases
7. Investigate the mechanism of free radical reactions
   1. Use halogenation of alkanes as a model of a free radical reaction
   2. Write mechanistic steps for a free radical chain mechanism
   3. Explain why chlorine is more reactive than bromine in free radical halogenation
   4. Explain why chlorine is less selective than bromine in free radical halogenation
   5. Describe the stereochemical consequences of free radical halogen­ation at a chiral carbon atom
   6. Relate the rate of free radical halogenation to the strength of the carbon-hydrogen bond broken
   7. Illustrate the use of NBS as a selective halogenating agent
   8. Predict the product mixtures expected from bromination or chlori­nation of alkanes
   9. Describe the functions of free radical initiators
   10. Describe the function of free radical inhibitors
8. Examine the properties of alcohols
   1. Recognize various classifications of alcohols
   2. Extend the nomenclature of alcohols to include a wider variety of cases
   3. Predict various physical properties of alcohols
   4. Illustrate the acid-base properties of alcohols
   5. Use various methods to demonstrate alcohol preparations
   6. Predict products of various alcohol reactions including stereo-chemistry if necessary
   7. Write mechanisms for various alcohol reactions
   8. Recognize redox in organic reactions
   9. Outline syntheses for more complex molecules from specific start­ing materials
9. Investigate the properties of ethers
   1. Predict various physical properties of ethers
   2. Extend the nomenclature of ethers to include more complex struc­tures
   3. Demonstrate the preparation of ethers using a variety of methods
   4. Predict products of ether substitution reactions including stereo-chemistry if necessary
   5. Write mechanisms for ether substitution reactions
10. Interpret infrared (IR) and nuclear magnetic resonance (NMR) spectra
    1. Recognize features in organic molecules which give rise to the absorption of infrared radiation
    2. Correlate the position of the infrared absorption to the molecular feature responsible for it
    3. Use nuclear magnetic resonance theory to explain why different protons in a molecule have different chemical shifts
    4. Determine relative numbers of protons in NMR signals from an integration curve
    5. Relate the splitting in an NMR signal to the number of neighboring protons
    6. Identify the structure of an unknown organic molecule from its formula and spectral data
11. Demonstrate proficiency in various organic laboratory techniques
    1. Use capillary melting points to determine the purity of a solid sample
    2. Perform simple or fractional distillation as required to separate the volatile components of a mixture
    3. Recrystallize impure solids to improve purity
    4. Perform simple chromatographic separations
    5. Use a separatory funnel to do liquid-liquid extractions
    6. Construct molecular models to visualize stereochemical relation­ships
    7. Construct molecular models to visualize stereochemical relation­ships
    8. Obtain an infrared spectrum of a liquid sample

CHM 273 - Organic Chemistry II

1. Relate topics from CHM 263 to appropriate material in CHM 273
2. Investigate the properties of alkenes and alkynes
   1. Describe the bonding in alkenes and alkynes
   2. Review the nomenclature of alkenes and alkynes
   3. Illustrate various preparations of alkenes and alkynes
   4. Predict physical properties of alkenes and alkynes
   5. Review spectral properties of alkenes and alkynes
   6. Predict products of various addition reactions of alkenes and alkynes including stereochemistry if necessary
   7. Write mechanisms for alkene and alkyne reactions
   8. Relate the structure of alkenes and alkynes to oxidation products
   9. Compare 1,2 addition to 1,4 addition for conjugated dienes
   10. Outline syntheses for various molecules beginning with alkenes or alkynes
3. Examine the properties of aromatic hydrocarbons
   1. Assign systematic names to benzene derivatives
   2. Describe the physical properties of aromatic hydrocarbons
   3. Review the spectral properties of aromatic hydrocarbons
   4. Classify compounds as aromatic, antiaromatic, or non-aromatic
   5. Write a mechanism for electrophilic aromatic substitution
   6. Predict products of the reactions of benzene with various other reagents
   7. Explain the differences between ortho-para and meta directors using resonance theory
   8. Predict the most likely products of electrophilic aromatic substitu­tion on substituted benzene rings
   9. Determine the effect of the aromatic ring on alkyl substituents
   10. Use resonance to explain the unusual properties of phenol
   11. Illustrate the chemical reactions of benzene diazonium salts
   12. Distinguish between electrophilic and nucleophilic aromatic substi­tution mechanisms
   13. Outline syntheses of compounds beginning with various aromatic hydrocarbons
4. Compare the properties of aldehydes and ketones.
   1. Review the nomenclature of aldehydes and ketones
   2. Illustrate various methods of preparing aldehydes and ketones
   3. Compare the physical properties of aldehydes and ketones
   4. Compare the spectral properties of aldehydes and ketones
   5. Predict products of addition reactions of aldehydes and ketones
   6. Predict products of addition-elimination reactions of aldehydes and ketones
   7. Predict products of redox reactions involving aldehydes and ketones
   8. Use resonance to explain the reactivity of alpha hydrogen atoms in aldehydes and ketones
   9. Predict products of various reactions involving the alpha carbon
   10. Predict products of 1,4 addition reactions of alpha-beta-unsaturated aldehydes and ketones
   11. Write mechanisms for various aldehyde and ketone reactions
   12. Outline syntheses of compounds beginning with aldehydes or ketones
5. Investigate the properties of carboxylic acids
   1. Review the nomenclature of carboxylic acids
   2. Predict various physical properties of carboxylic acids
   3. Review the spectral properties of carboxylic acids
   4. Illustrate various methods for preparing carboxylic acids
   5. Analyze the relationship between acid strength and acid structure
   6. Predict products of reactions of carboxylic acids with various bases
   7. Write a complete mechanism for the esterification of a carboxylic acid
   8. Predict the products of reduction reactions of carboxylic acids
   9. Investigate the special properties of dicarboxylic acids
   10. Predict products of 1,4 addition involving alpha-beta-unsaturated carboxylic acids
   11. Outline syntheses for other molecules beginning with carboxylic acids
6. Examine the properties of amines
   1. Recognize the classifications of amines
   2. Review the nomenclature of amines
   3. Predict various physical properties of amines
   4. Review the spectral properties of amines
   5. Illustrate various preparations of amines
   6. Relate the basicity of amines to various structural features of the amines
   7. Predict products of reactions of amines with a variety of acids
   8. Predict products of various substitution reactions involving amines
   9. Compare the products of various amine classes reacting with nitrous acid
   10. Use Hofmann elimination data to determine the structure of an amine
   11. Outline syntheses for compounds from amines
7. Compare the properties of various carboxylic acid derivatives
   1. Compare the relative reactivities of carboxylic acid derivatives
   2. Compare the spectral properties of carboxylic acid derivatives
   3. Extend the nomenclature system to the various carboxylic acid derivatives
   4. Illustrate the preparation of acid chlorides
   5. Predict products of reactions of acid chlorides
   6. Illustrate the preparation of acid anhydrides
   7. Predict products of reactions of acid anhydrides
   8. Illustrate the preparation of esters
   9. Predict products of the reactions of esters
   10. Illustrate the preparation of amides
   11. Predict products of the reactions of the amides
   12. Illustrate the preparation of nitriles
   13. Predict products of the reactions of nitriles
   14. Write mechanisms for various examples of nucleophilic acyl substi­tution
   15. Outline syntheses of compounds beginning with various carboxylic acid derivatives
8. Examine various reactions of enolate anions
   1. Review the acidity of various types of alpha hydrogen atoms
   2. Predict products of various alkylation reactions at the alpha carbon
   3. Relate the aldol condensation to similar reactions
   4. Predict products of ester condensations
   5. Predict products of nucleophilic 1,4 additions to alpha-beta-unsatu­rated carbonyl compounds
   6. Write mechanisms for various reactions involving enolate anions
   7. Outline syntheses for compounds using various condensation reac­tions
9. Perform various laboratory exercises
   1. Review various laboratory techniques used in CHEM161
   2. Synthesize various organic compounds using methods discussed in CHEM162
   3. Relate laboratory procedures to class material

CIS 125 - Intro to Programming Logic w/

1. Examine the components of computer programming
   1. Describe the primitive data types in most computer languages
   2. Demonstrate initialization of variables with the assignment operator
   3. Determine appropriate test data to test a computer algorithm to verify anticipated output
   4. Use relational operators in the basic control structures
   5. Demonstrate the use of logical operators
2. Produce computer algorithms
   1. State the principle of the Structure Theorem
   2. Explain the three basic control structures
   3. Formulate an IPO chart in the development of algorithms
   4. Generate pseudocode to solve computer algorithms
   5. Construct flowcharts to communicate computer algorithms
3. Design computer algorithms that demonstrate appropriate use of the selection control structure
   1. Design an IF-THEN-ELSE selection control structure
   2. Understand the use of a CASE statement
4. Design computer algorithms that demonstrate appropriate use of the repetition control structure
   1. Solve an algorithm with a while loop
   2. Solve an algorithm with a for loop
   3. Solve an algorithm through the use of counters and accumulators
   4. Identify infinite loop conditions
5. Design computer algorithms that perform arithmetic operations
   1. List the order of precedence of arithmetic operators and logical operators
   2. Demonstrate the use of addition, subtraction, multiplication, and division operators in algorithms
6. Design computer algorithms to process arrays
   1. Demonstrate ability to define array structures
   2. Demonstrate the use of subscripts (indexes) are used to address array elements
   3. Perform a linear search of an array
   4. Create two dimensional arrays
7. Create functions/methods to organize programs into manageable code modules
   1. Define and call functions/methods
   2. Use techniques for passing values to and from functions/methods
8. Examine class organization and objects
   1. Differentiate between a class and an object
   2. Give examples of the relationships between classes and objects
9. Transform computer algorithms to a computer programming language using an editor and compiler to enter source code and generate object code
10. Explore the real-world programming environment
    1. Describe the steps in the program development process such as Agile and waterfall methodologies
    2. Discuss relevant development topics such as version control, test driven development, full-stack development, deployment, integration, relational databases, cloud computing

CIS 140 - Intro to Game Design

1. Discuss the computer gaming industry
   1. Identify career opportunities in the field
   2. Identify academic skills required for entry into the field
   3. Identify technical skills required for entry into the field
   4. Identify the primary software tools in the field
2. Discuss the basic concepts of game design
   1. Identify the basic concepts of game design
   2. Explain how the concepts interact to form a user experience
   3. Explain how the concepts guide the creation of algorithms
3. Discuss computer game programming techniques
   1. Explain event based programming
   2. Describe input management techniques
   3. Describe user interface design concepts
   4. Explain storyline implementation
4. Discuss graphics and animation related to game design
   1. Define 2D graphic rendering
   2. Define 3D graphic rendering
   3. Identify graphic libraries and their content
   4. Define animation and motion creation
   5. Identify the properties of physics related to motion
5. Examine story development and implementation in game design
   1. Identify sources of story lines
   2. Discuss implementation of story line through programming techniques
   3. Examine writing skills for story line presentation
   4. Examine presentation skills for story line presentation
6. Implement algorithms for game programming
   1. Define algorithms
   2. Identify basic rules for game elements
   3. discuss algorithms to implement rules structures
   4. Create algorithms to implement rules
   5. Create a test plan to evaluate the performance of the algorithms
   6. Explain how algorithms are used to simulate the game environment

CIS 152 - Data Structures

Credits: 3
Lecture Hours: 3
Lab Hours: 0
Practicum Hours: 0
Work Experience: 0
Course Type: Open

1. Demonstrate data encapsulation and access modifiers

2. Create default and non-default constructors

3. Design overloaded methods

4. Construct plain objects (POJO, POCO) 

2. Create programs demonstrating inheritance

1. Create and use abstract classes

2. Design classes for inheritance

3. Integrate polymorphism into projects 

1. Use inheritance to create polymorphic references

2. Use interfaces to create polymorphic references

4. Examine recursion

1. Explain the underlying concepts of recursion

2. Discuss several search and sorting algorithms

3. Understand search and sort algorithms

5. Produce collections

1. Create a linked list collection implementation

2. Create an array-based collection implementation

6. Produce stack implementations

1. Define stack as an abstract data type

2. Create a stack class with array-based implementations

3. Create a stack class with linked list implementations

4. Demonstrate how stacks can be used to solve problems

7. Produce queue implementations

1. Define queue as an abstract data type

2. Create a queue class with array-based implementations

3. Create a queue class with linked list implementations

4. Demonstrate how queues can be used to solve problems

8. Produce trees as data structures

1. Implement trees from abstract data types

2. Create methods for traversing trees

3. Demonstrate how tree implementations can be used to solve problems

4. Use binary trees to represent decision trees

5. Create a linked implementation of a binary search tree

9. Implement a map and heap

1. Implement a map from an abstract data type

2. Implement a priority queue

10. Examine directed and undirected graphs

1. Define graphs and graph properties 

2. Define traversals of a graph

3. Define a minimum spanning tree

4. Discuss strategies for implementing and traversing graphs

CIS 154 - Computational Structures

1. Recognize how formal tools of symbolic logic are used to model algorithms and real life situations
   1. Apply formal methods of symbolic propositional logic
   2. Use formal logic proofs and logical reasoning to solve problems
2. Perform the operations associated with sets, functions and relations
   1. Explain with examples the basic terminology of functions, relations and sets
   2. Use equivalence relations in solving problems
3. Apply proof techniques to solve problems in computer science, including software engineering, program semantics, and algorithm analysis
   1. Outline the basic structure of and give examples of each proof technique
   2. Discuss which type of proof is best for a given problem
4. Solve problems using permutations and combinations
5. Demonstrate basic counting principles, including uses of diagonalization and the pigeonhole principle
6. Apply the tools of discrete probability theory to computer science algorithms
7. Solve problems using recurrence relations
8. Model problems in computer science using graphs and trees
   1. Examine different traversal methods for trees and graphs
   2. Relate graphs and tree to data structures, algorithms, and counting
9. Apply principals of Boolean Algebras to computer science algorithms and circuits

CIS 161 - C++

1. Utilize an Integrated Development Environment (IDE)
   1. Write a simple C++ program
   2. Save the program code to disk
   3. Compile/Link the program to produce a working application program
2. Demonstrate mastery of common editing tasks
   1. Search for and replace text
   2. Perform the tasks of cutting and pasting blocks of text
   3. Switch between different parts of the IDE
3. Modify the Integrated Development Environment
   1. Designate current, working directories
   2. Set compiler flags and options
   3. Demonstrate the use of the debug utility within the IDE
4. Design a C++ program to perform number-base conversions
   1. Use C++’s primitive data types
   2. Use cout and cin, from the iostream class, to get data into a working program and produce information on the screen and printer
   3. Investigate the different uses of the assignment operator
   4. Identify appropriate header files to be included in the program
   5. Use the #include compiler directive
   6. Examine the use of functions in C++
   7. Demonstrate how to write prototype functions
5. Examine the uses of relational and logical operators
   1. Distinguish between the various relational operators, including their order of precedence
   2. Use relational operators to implement program loops
   3. Show the difference between “for()”, “while()”, and “do?wh ile()” loops
   4. Demonstrate the “if()” and “switch()” selection functions
   5. Differentiate between the various logical operators, incouding their order of precedence
   6. Write a program that demonstrates the use of relational and logical operators
   7. Show how to use the “break” and “continue” keywords
6. Investigate the concept of a data structure
   1. Distinguish between “definition” and “declaration” of a data structure
   2. Show how to access structure members
   3. Show how to access structure members
   4. Demonstrate the use of enumerated data types
7. Outline the various components of a C++ function
   1. State the purpose of
   2. Illustrate passing arguments to functions
   3. Investigate returning values from functions
   4. Distinguish between passing by value and passing by reference
   5. Demonstrate function overloading
   6. Discuss in-line functions
   7. Distinguish between the various types of storage classes
   8. Demonstrate the ability to write C++ functions that accept arguments and return a value to the calling routine
8. Analyze the concept of C++ classes and objects
   1. Describe the advantages of using classes in C++.
   2. Show how objects are used to hide data while allowing the programmer access to the data through member functions
   3. Demonstrate how to specify a class and declare an object
   4. Illustrate the use of the “public”, “protected” and “private” keywords
   5. Initialize objects through the use of constructor functions
   6. Distinguish between objects as records and objects as new data types
   7. Show how to pass objects as arguments of functions
   8. Show how to return objects from functions
9. Examine the array data type
   1. Demonstrate how to define an array
   2. Manipulate array elements through the use of indexes
   3. Produce multi-dimensional arrays
   4. Produce arrays of structs and arrays of objects
   5. Pass arrays to and from functions
   6. Use arrays of characters to create a string data type
   7. Distinguish between string constants and string variables
   8. Show how to use an array of strings
10. Illustrate how to use operator overloading to extend the C++ language
    1. Overload unary and binary operators
    2. Show how to use overloaded “+” to concatenate strings
    3. Discuss the principles of data type conversion
11. Investigate the concept of inheritance to derive classes from one or more base classes
    1. Specify a base class
    2. Describe the use of the keyword, “protected” as an access specifier
    3. Illustrate the role of base class constructors in derived classes
    4. Show how to override base class member functions
    5. Describe how to use the scope resolution operator
    6. Discuss the idea of class hierarchies
    7. Distinguish between public and private inheritance
    8. Review the advantages and pitfalls of multiple inheritance
    9. Discuss the purpose of container classes
12. Examine the use of pointers in C++
    1. Explain the idea of addresses and pointers
    2. Discuss the address-of operator
    3. Practice declaring pointer variables
    4. Initialize pointers
    5. Dereference pointers to get at the data pointed to
    6. Distinguish between pointer variables and pointer constants
    7. llustrate the use of pointers with arrays and strings
    8. Demonstrate the use of the “new” and “delete” operators to manage computer memory
    9. Discuss the differences between heap and stack allocated memory
    10. Discuss the use of pointers-to-objects
    11. Discuss how pointer arithmetic is tied to hardware architecture
13. Illustrate C++ file Input/Output functions through “stream” classes
    1. Show how to input/output strings, characters and binary objects
    2. Discuss file pointers
    3. Distinguish between the various error handling functions in the stream classes
    4. Manipulate file I/O through the use of redirection
14. Introduce error handling and the Standard Template Library (STL)
    1. Discuss basic error handling procedures
    2. Demonstrate the try/catch block
    3. Introduce the STL
    4. Demonstrate the use of a container

CIS 164 - Advanced C++

1. Demonstrate how to manage multi-file projects
   1. Discuss project organization to organize disk directories
   2. Introduce concepts of source controls
   3. Illustrate the use of source controls
2. Examine the accessibility of members of classes
   1. Distinguish between private, public and protected members
   2. Examine the role of constructor, destructor, accessor and implementor functions
   3. Discuss copy constructors and the assignment operator
   4. Discuss pitfalls of generated default constructors
   5. Design a program that illustrates the use of protected members
   6. Design a program that passes arguments by reference while using the const modifier to protect the referenced variable
3. Investigate function and operator overloading
   1. Create a program that uses the new and delete operators to allocate memory and free it up
   2. Show how new returns an address of dynamically allocated memory
   3. Use the pointer access operator (arrow operator) to exercise member functions indirectly
   4. Overload the new and delete operators to trap “out of memory errors.”
   5. Illustrate the difference between deep copies and shallow copies
   6. Discuss memory leaks: autopointer and a reference counter pointer class
4. Review the concepts of inheritance to derive classes from one or more base classes.
   1. Examine the derivation of the stream classes
   2. Write a program that contains one or more user defined manipulators
   3. Illustrate the use of the fstream class for file input and output
   4. Review the advantages and pitfalls of multiple inheritance
5. Demonstrate the use of polymorphism
   1. Write a program to illustrate polymorphism and the use of virtual functions
   2. State the purpose of pure virtual functions
   3. Discuss the differences between pure virtual inheritance and ?override? inheritance
   4. Design an “interface” class using pure virtual functions
6. Investigate several examples of template classes
   1. Review basic template concepts
   2. Examine the standard container classes
   3. Examine the algorithm portion of the Standard Template Library (STL).
   4. Write a program using an algorithm to process a template container
7. Understand the fundamental principles of performance enhancement
   1. Discuss the use of profilers to optimize performance
   2. Discuss when it is best to keep data in internal memory versus keeping it in external storage
   3. Demonstrate making a temporary copy of data or subset of the data to increase access speed
   4. Discuss advantages and disadvantages of using data compression when sending information over a network connection
   5. Discuss how system resources, such as RAM, ROM and CPU clock cycles, can affect performance
8. Understand Unit Test Frameworks and how they are used
   1. Discuss how Unit test frameworks can contribute to almost every stage of software development, including software architecture and design, code implementation and debugging, performance optimization, and quality assurance
   2. Discuss common patterns used when writing unit tests
   3. Examine a simple unit test framework and discuss its components
9. Examine database connectivity issues
   1. Demonstrate the use of SQL to select and update data
   2. Write an application that connects to a database to read and write data
10. Understand the complexity of using multiple threads in a C++ application
    1. Discuss the fundamentals of threads, used to write more efficient and capable programs
    2. Modify a single-threaded program to use multiple threads

CIS 169 - C#

1. Demonstrate basic programming operations
   1. Describe object-oriented concepts
   2. Identify different component of Visual Studio
   3. Declare and initialize variables
   4. Write a Hello World program using Windows Application
2. Demonstrate the basics of Visual C#
   1.  Distinguish between data types using variables and constants
   2. Create windows applications
3. Incorporate Processing Data
   1. Write a program to input and output numeric values
   2. Format numbers with ToString method
   3. Use Exceptions Handling
   4. Use the Debugger to find Logic Errors
   5. Process String and Character
4. Implement Decision Making
   1. Write if-else statements and nested if statements
   2. Use compound conditions in if statements
   3. Apply a switch statement for selection
   4. Use contols
5. Implement Loops
   1. Code loops using while
   2. Code using do-while
   3. Code using for statements
   4. Code using foreach
   5. Use nested loops
   6. Demonstrate Reading/Writing from/to a file
   7. Generate random numbers
6. Create Modules and Methods
   1. Use void method
   2. Code a method with arguments
   3. Use a method to return a value
   4. Demonstrate how to pass an array to a method
7. Implement Arrays and Lists
   1. Demonstrate how to declare and initialize Arrays and lists
   2. Demonstrate Sort and search arrays and lists
   3. Load an array to a file and a file to an array in a program
   4. Use two Dimensional and Parallel Arrays
8. Implement Structures, Enumeration and String manipulation
   1. Use Enumeration
   2. Use Structure
   3. Write a program to manipulate string and character
9. Incorporate Object-Oriented Principles
   1. Create class and class object(s)
   2. Create a default constructor, then create parametrized constructor
   3. Overload constructors
   4. Create multi-screen application
10. Implement Inheritance, Polymorphism and Abstraction
    1. Implement inheritance
    2. Use Polymorphism in a program
    3. Demonstrate method overriding
    4. Implement Abstract class and abstract methods
11. Utilize appropriate tools to manipulate data
    1. Create a Database in Visual Studio
    2. Use appropriate methodology to display data
    3. Connect to an existing Database using View controls
    4. Select data using SQL select statement
12. Demonstrate code readability, application testing and communication to other developers 
    1. Demonstrate the use of comments and good code layout
    2. Develop strategies for testing your program including the use of unit testing frameworks

CIS 171 - Java

1. Investigate the basic concepts of programming languages
   1. Distinguish between procedure-oriented and object-oriented programming concepts
   2. Discuss the Java programming language basic features
2. Create projects using the current development environment
   1. Use an integrated development environment and explore its features
   2. Write a Java program
   3. Run and modify a Java program
   4. Add files to a project
3. Design a Java program utilizing variables and constants
   1. Use Java’s primitive data types
   2. Use the ‘out’ and ‘in’ System objects to display information and to get data into a working program
   3. Use the assignment operator
   4. Write arithmetic statements
4. Assess the uses of relational and logical operators
   1. Distinguish between the various relational operators
   2. Demonstrate the if() and switch() selection functions
   3. Differentiate between the various logical operators
   4. Validate user input using if statements
5. Evaluate Java Loops
   1. Create and use while loops
   2. Collect elements using arrays and arraylists
   3. Create and use for loops to traverse arrays and arraylists
   4. Create and use the enhanced for loop to traverse arrays and arraylists
   5. Use relational operators to implement program loops
   6. Process arrays using nested loops
   7. Create and use do/while loops
   8. Use break and continue
6. Outline the various components of a Java method
   1. Define a method
   2. Illustrate passing arguments to methods
   3. Investigate returning values from methods
   4. Demonstrate method overloading
   5. Demonstrate the ability to write Java methods that accept arguments and return a value to the calling routine
7. Analyze the concept of Java classes and objects
   1. Describe the advantages of using classes in Java
   2. Show how objects are used to hide data while allowing the programmer access to the data through methods
   3. Demonstrate how to declare a class and create an instance of an object
   4. Illustrate the use of the public and private keywords
   5. Initialize objects through the use of constructor methods
   6. Show how to pass objects as arguments of methods
   7. Show how to return objects from methods
8. Assess the array data type
   1. Demonstrate how to define an array
   2. Manipulate array elements through the use of subscripts
   3. Produce multi-dimensional arrays
   4. Produce arrays of objects
   5. Pass arrays to and from methods
   6. Show how to use an array of strings
9. Investigate the concept of inheritance to derive classes from one or more base classes
   1. Specify a base class
   2. Describe the use of the key work “protected” as an access specifier
   3. Illustrate the role of base class constructors in derived classes
   4. Show how to override base class methods
   5. Discuss the idea of class hierarchies
   6. Distinguish between public and private inheritance
   7. Discuss the purpose of container classes
10. Create basic Java GUI applications
    1. Create a Java application using GUI (graphical user interface) components
    2. Discuss event-driven programming
    3. Create and modify Graphics objects
    4. Illustrate simple animation
11. Integrate Java API classes provided with the Java language
    1. Create programs that read and process inputs, and display the results
    2. Manipulate data using the StringBuilder class and its methods
    3. Creating and manipulating Strings
    4. Create and manipulate calendar data using classes from java.time.LocalDateTime, java.time.LocalDate, java.time.LocalTime, java.time.format.DateTimeFormatter, java.time.Period
12. Demonstrate code readability, application testing and communication to other developers
    1. Demonstrate the use of comments and good code layout
    2. Develop strategies for testing your program including the use of unit testing frameworks
    3. Browse, utilize and write JavaDocs effectively

CIS 174 - Advanced C# Programming

1. Examine the fundamentals of Web Development
   1. Explain Client/Server architecture
   2. Describe the requirements for well-formed web pages
   3. Use MS Visual Studio to develop a basic website
2. Produce programs using the concepts across the web
   1. Identify web concepts and define terminology
   2. Describe examples of services
   3. Describe the role of services in providing a Service Oriented Architecture (SOA) to applications
   4. Create and access data through a service
3. Develop ASP.NET projects
   1. Design a consistent layout of web pages using consistent layout of webpages
   2. Create a multitier Web application
   3. Incorporate database connectivity and use
   4. Modify data in a database
   5. Demonstrate appropriate validation techniques
   6. Demonstrate navigation among web pages
   7. Maintain state for data in a multipage application
4. Demonstrate using collections and generics
   1. Identify types of collections
   2. Determine appropriate collection type for an application
   3. Create a collection of objects
   4. Access and update a collection
5. Create user controls
   1. Describe user controls
   2. Demonstrate inheriting from existing controls
   3. Create a user control
   4. Write code to handle event processing
   5. Combine preexisting controls
6. Demonstrate debugging and error handling
   1. Perform basic debugging techniques including tracing errors, diagnostic traces, and stepping through code
   2. Demonstrate techniques for handling exceptions and errors
7. Examine C# application security
8. Survey new technologies related to C# program development
9. Develop strategies for testing programs including the unit testing frameworks

CIS 175 - Java II

1. Construct Handling Exceptions into Java Programs
   1. Differentiate among checked exceptions, unchecked exceptions, and errors
   2. Create a try-catch block and determine how exceptions alter normal program flow
   3. Describe the advantages of Exception handling
   4. Create and invoke a method that throws and catches an exception
   5. Recognize common exception classes (such as NullPointerException, ArithmeticException, ArrayIndexOutOfBoundsException, ClassCastException)
2. Create Advanced Graphical User Interfaces using Swing
   1. Implement simple graphical user interfaces
   2. Add buttons, text fields, and other components to a frame window
   3. Handle events that are generated by buttons
   4. Write programs that display simple drawings
   5. Use layout managers to arrange user-interface components in a container
   6. Demonstrate familiarity with common user-interface components, such as radio buttons, checkboxes, and menus
   7. Build programs that handle events generated by user-interface components
3. Identify methods of deploying applications
   1. Describe how the following items are deployed: Individual .class files, JAR files, OS wrapper around class files or JAR files, Applets, Java Web Start, WAR files
   2. Discuss server-based alternatives to deploying applications
4. Build a Database Application with JDBC
   1. Understand how relational databases store information
   2. Read and understand a UML diagram
   3. Describe the interfaces that make up the core of the JDBC API including the Driver, Connection, Statement, and ResultSet interfaces and their relationship to provider implementations
   4. Identify the components required to connect to a database using the DriverManager class including the JDBC URL
   5. Query a database with the structured Query language (SQL)
   6. Connect to a database with Java Database Connectivity (JDBC)
   7. Write database programs that insert, update, and query data in a relational database
   8. Submit queries and read results from the database including creating statements, returning result sets, iterating through the results, and properly closing result sets, statements, and connections
   9. Explain the purpose and benefits of an object/relational mapping tool
5. Create a Java Server Page and Servlet
   1. Describe the role of JSP and servlets
   2. Describe the basic structure of servlets
   3. Create a servlet that generates plain text
   4. Create a servlet that generates HTML
   5. Describe the servlet life cycle
   6. Illustrate servlet debugging strategies
   7. Understand the need for JSP and evaluate the benefits
   8. Understand the JSP lifecycle
   9. Create and install basic JSP pages
6. Create a basic script
   1. Select a scripting engine for the appropriate circumstance
   2. Create and execute a basic script
   3. Discuss the advanced features scripting engines offer
7. Examine Java Application Security
   1. Distinguish the security concerns that surround application development
   2. Discuss the three mechanism to help ensure safety of Java code: language, access control and code signing
   3. Illustrate how digital signatures are utilized
   4. Explain code signing
   5. Explain how encryption works and why it is important
   6. Sanitize user input
8. Utilize version control
   1. Summarize how to setup the Git environment
   2. Demonstrate how to set up a new project and repository
   3. Explain how to work with code, including checking out, committing changes, destroying unwanted changes, viewing revisions and history
9. Discuss Agile and Development Approaches
   1. Describe the players in the agile environment
   2. Explain the Agile development process and components, including user stories, test-driven development, SCRUM, sprints and backlog
   3. Identify the advantages and disadvantages of various Agile development methods, including Kanban, Scrum and Extreme Programming
   4. Identify other methodology of software development processes, including rapid application, prototyping and waterfall approaches
   5. Understand the components that go into full stack development

CIS 178 - Java Programming I

1. Summarize the rational of Java Object oriented Programming.
   1. Describe the purpose of a Java Virtual Machine (JVM).
   2. Define the Abstract Window Toolkit (AWT).
2. Create Java classes.
   1. Define the function of the different components of a class.
   2. Demonstrate how to use inheritance.
   3. Demonstrate how to use exception handling.
   4. Demonstrate how to use streams and file I/O.
3. Compare components of the Abstract Windows Toolkit (AWT).
   1. Define the component properties.
   2. Describe the rational behind JavaBeans.
   3. Demonstrate how to implement the basic components.
4. Contrast the different methods of adding graphics to an application.
   1. Define the graphics coordinate system.
   2. Demonstrate how to load and display images.
   3. Demonstrate how to filter an image.
5. Assess how event handling is implemented in a graphical user interface.
   1. Describe inheritance based event handling.
   2. Discuss the delegation event model.
   3. Demonstrate handling event.
6. Assess how Applets can be used to add functionality to HTML code.
   1. Define an Applet.
   2. Describe how to convert an AWT to an Applet.
   3. Demonstrate how to place an Applet in an HTML document.

CIS 179 - Java Programming II

1. Summarize how Java has become an integral component of a Web Server’s environment
   1. Describe the benefits of server side Java
   2. Define the Java Virtual Machine (JVM)
   3. Describe the servlet API
2. Configure a Web server to execute commercially available Java Application
   1. Define the Java envset command
   2. Define the classpath
   3. Define the purpose of the java.cfg file
3. Compare the different tools available for creating Java application
   1. Define Symantec’s Just-in-Time (JIT) compiler
   2. Define Java beans
   3. Define the Java Database Connectivity (JDBC)
   4. Define Java Naming and Directory Interface (JNDI) API
4. Develop application that access Novell’s Directory Services (NDS)
   1. Define the tools required for accessing NDS
   2. Define the Lightweight Directory Access Protocol (LDAP)
   3. Demonstrate how to access NDS from Java 

CIS 204 - Intro to Website Development

1. Plan a website application project
   1. Explain the purpose of the website
   2. Outline the structure of the website
   3. Prepare a storyboard for a website application
   4. Identify the interaction of the website with other websites, i.e., links, references etc.
   5. Discuss the extent, purpose and use of graphics on the website
   6. Identify the need and demand for website updates and changes
   7. Examine efficiency issues such as bandwidth requirements, download speeds, etc
2. Demonstrate a basic understanding of image manipulation and presentation on a website application
   1. Define and differentiate the JPG, GIF, BMP image formats
   2. Demonstrate the impact of image resolution and size on website presentation and speed
   3. Demonstrate the ability to convert or change an image format
   4. Demonstrate the ability to manipulate the height, width, resolution and size of an image using an image manipulation software application
3. Examine the World Wide Web Consortium website www.wec.org
   1. Read the standards of website application languages and technologies
4. Demonstrate a basic understanding of the current version of HTML
   1. Define and discuss the syntax rules of HTML
   2. Define and discuss the primary HTML elements and attributes found in a website application
   3. List and define deprecated HTML elements and attributes and discuss how they will impact your website application
5. Demonstrate a basic understanding of the current version of XHTML
   1. Define XHTML
   2. Differentiate XHTML compared to HTML
   3. Identify the rules of XHTML that make it different from HTML
   4. Discuss the role of XHTML in current and future website application development
6. Create or modify a website application using XHTML and HTML
   1. Prepare a web page using correct head and body elements
   2. Demonstrate how to implement heading elements
   3. Demonstrate how to implement hypertext links
   4. Demonstrate how to implement text elements
   5. Demonstrate how to implement image elements
   6. Demonstrate how to implement ordered and unordered lists
   7. Demonstrate how to implement tables, including nested tables
   8. Demonstrate how to implement forms and form elements
7. Determine how to publish a website
   1. List and explain website hosting options
   2. Describe the role of domain names or URLs for a website application
   3. Demonstrate the use of ftp and other tools to publish a website to a server or host
8. Illustrate the basic concepts of implementing dynamic HTML, also known as DHTML, in a website application
   1. Discuss the role of HTML or XHTML, CSS, Javascript and DOM in DHTML
   2. Discuss Browser compatibility issues as it relates to DHTML, especially CSS
   3. Define HTML event handlers and their role in DHTML
   4. Define the HTML/XHTML elements DIV and SPAN
9. Demonstrate a basic understanding of Cascading Style Sheets (CSS)
   1. Define and discuss cascading style sheets (CSS) and its role in website application
   2. Discuss implementation considerations of CSS1, CSS2 and CSSP standards from the W3C
   3. Discuss how CSS commands interact with the DOM
   4. Define the HTML/XHTML element style and how it is used for CSS commands with HTML/XHTML
   5. Discuss the CSS rules of precedence and inheritance
   6. Discuss block level elements and containers
10. Demonstrate how to use CSS to implement the following effects on a website application
    1. Applying and changing background colors and patterns
    2. Setting and changing text fonts, colors, sizes and styles
    3. Setting and changing border colors, sizes and styles
11. Discuss the document object model (DOM) and its role in DHTML
    1. Define the document object model
    2. List the objects commonly found within the documents object model
    3. Demonstrate how the DOM is used to allow for dynamic changes to a website application
12. Demonstrate the following skills using one or more website development tools
    1. Produce a new website application
    2. Update or modify an existing website application
    3. Add/remove pages to the website.
    4. Define and change the navigational structure of the website
    5. Implement XHTML rules
    6. Implement CSS formatting
    7. Implement dynamic activity using JavaScript

CIS 215 - Server-Side Web Programming

1. Identify the basic terminology and concepts of scripting languages
   1. Define ‘Scripting Language’
   2. Describe how scripting languages are used within an E-Commerce website application
   3. Define ‘script’ in terms of website applications
   4. Define Common Gateway Interface (CGI)
   5. Describe what role CGI programs perform in the operation of a website application
2. Demonstrate a basic understanding of the process involved in selecting and implementing a scripting function within an E-Commerce website application
   1. Explain the purpose of the script
   2. Identify the interaction required between the script and the website application
   3. Identify the interaction required between the script and a server side application
   4. Discuss server issues unique to each scripting language
   5. Discuss browser compatibility issues unique to each scripting language and the desired function
   6. Describe the impact of the selection of a scripting language on the operational characteristics of a website application
3. Demonstrate a basic ability to create a script
   1. Describe the function of the script
   2. Design the logical structure of the script
   3. Identify the types of variables required in the script
   4. Select the appropriate scripting language for the script
4. Using HTML or a current website development tool
   1. Create script tags
   2. Create the script programming code
   3. Test the script programming code
   4. Implement the script within a website application
   5. Test the implementation of the script
   6. Validate the script’s function with the website application
5. Show the ability to use one or more Scripting Languages in the following manner
   1. Determine the appropriate scripting language for the desired function
   2. Design a script program that will perform the desired function
   3. Write the code for the function in one of several languages
   4. Test, and if necessary correct, the code for successful completion and performance of the function
   5. Implement the function in a website application

CIS 240 - E-Commerce Website II

1. Demonstrate an understanding of DHTML and how it can be used within a website application
   1. Define DHTML
   2. Describe Filters and their purpose
   3. Explain Page Transitions
   4. Discuss Performance Issues related to the use of DHTML on a website
   5. Explain the basic features of Graphics handling within DHTML
2. Demonstrate and understanding of Cascading Style Sheets (CSS) and how they are used in an application
   1. Define the STYLE tag
   2. Discuss Layering and how it is used to produce the desired effect
   3. Define the DIV and SPAN tags
3. Explain Extensible Markup Language (XML) and how it is used within a website application
4. Discuss Browser Compatibility issues as it relates to DHTML, CSS, and XML
5. Identify proprietary issues as it relates to DHTML, CSS, and XML
6. Discuss how various forms of Animation can be included in a website application
   1. Describe Graphic Creation
   2. Identify various Types of Animation
   3. Outline Cross Platform Issues associated with graphics
   4. Identify Multimedia issues that affect the choice and selection of an animation technique
7. Demonstrate the proper use of advanced features of a website development tool
   1. Identify built in website navigation tools
   2. Explain how the website navigation tools can be implemented in a website application
   3. Describe special features for comparing website performance in various browsers
   4. Describe how a website can incorporate plug in applications
   5. Describe how to incorporate Java applets into a website application
   6. Identify the various components available to the website development tool
8. Show the ability to use a website development tool to create and publish a website that includes the following functions
   1. Create and open a new website within the tool
   2. Define and change the navigational structure of the site
   3. Define, apply and change shared page features
   4. Define, apply and change shared themes
   5. Add/remove pages to the website
   6. Publish a completed website
9. Use a website development tool to show the following skills
   1. Apply basic page formatting
   2. Add/remove text and list
   3. Add/remove images and links
   4. Build pages using frames
   5. Import and include documents from other sources
10. Discuss how current and future website technologies will impact website design
    1. Describe Active X Controls
    2. Describe Active Server Pages
    3. Describe CSS2
    4. Describe XSL

CIS 247 - Intro to XML

1. Outline the basic concepts of Extensible Markup Language (XML)
   1. Define Extensible markup Language (XML).
   2. Define the benefits of XML
   3. Identify the key components of an XHTML document
   4. Define the role of XML as a communication standard
   5. Compare and contrast SML to XHTML and HTML
   6. Discuss the use of XML on the client side of a web based application
   7. Discuss the use of XML on the server side of a web based application
   8. Discuss the role of XML in application software
2. Discuss correct XML syntax
   1. Define well formed XML
   2. List the syntax rules of the XML language
   3. Prepare correct XML start and end tags
   4. Discuss XML attributes
   5. Differentiate embedded and external XML
3. Differentiate the tools and technologies of XML
   1. Discuss the role of the web browser
   2. Discuss the role of the XML parser
   3. Discuss the role of the Simple Api for XML (SAX)
   4. Discuss the role of HTTP and TCP/IP
   5. Identify XML application software tools
4. Discuss XML DTD validation
   1. Discuss the concept of data validation
   2. Define a document type definition (DTD).
   3. Differentiate internal and external DTDs
   4. List the attributes and entities of a DTD
   5. Discuss the role of the XML validation parser
5. Discuss XML Schema validation
   1. Define XML namespaces
   2. Discuss the role of a namespaces within schemas
   3. Define an XML schema
   4. Discuss the role of a schema
   5. Compare the role of DTDs and schemas
   6. Differentiate internal and external schemas
   7. Define schema data types and elements
6. Discuss XML transformation
   1. Define cascading style sheets (CSS).
   2. Define extensible stylesheet language (XSL).
   3. Define Extensible Stylesheet Language Transformation (XSLT).
   4. Differentiate the role of CSS and XSL in XML transformation
   5. Discuss programming with XSL functions
7. Discuss XML programming within the document object model (DOM).
   1. Define the Document Object Model (DOM).
   2. Discuss the role of the DOM in a web based appli
   3. Discuss data binding XML content to the DOM elements
   4. Discuss modifying XML content with the DOM
   5. Discuss using the DOM to combine and convert XML content
8. Discuss using XML to communicate with databases
   1. Define options for storing XML content in a database
   2. Define options for retrieving XML content from a database
   3. Discuss the role of XML and Simple Object Access Protocol (SOAP)
   4. Discuss theof XML in web services
9. Create XML documents
   1. Demonstrate that it is well formed
   2. Demonstrate valid XML content using an internal and external DTD
   3. Demonstrate valid XML content using an internal and external schema
   4. Display XML content using CSS
   5. Display XML content using XSL
   6. Demonstrate transformation of XML content into HTML using XSLT
   7. Demonstrate transformation of XML content into another XML format using XSLT
   8. Demonstrate XML data binding and usage within the DOM

CIS 303 - Introduction to Database

1. Compare traditional file systems to databases
   1. Discuss the historical roots of databases
   2. Explain the purpose of databases
   3. Differentiate between data independence and structural independence
   4. Discuss the benefit of reducing data redundancy
   5. List advantages and disadvantages of using databases for data storage
2. Provide an overview of DBMS technology
   1. Describe key concepts of database processing
   2. Define common database terminology
   3. Describe data organization, storage, and access in a database
   4. Describe the differences between 3 database models; hierarchical, network, relational
3. Understand relational technology
   1. Describe the structure of a relational database
   2. List common database objects (tables, attributes, relationships).
   3. Distinguish between primary and foreign keys
   4. Discuss the importance of integrity constraints
   5. Identify common characteristics of data dictionaries
   6. Describe the purpose of query optimizers
   7. Lit some common front end tools for easy user access
4. Categorize Information architecture
   1. Utilize external schema - the user’s view of data
   2. Create conceptual schema - logical data model
   3. Explain internal schema - physical data structures
5. Design relational databases
   1. Develop a logical data model
   2. Develop a conceptual schema
   3. Define the data dictionary
   4. Model and Entity-Relationship Diagram
   5. Discuss normalization techniques
   6. Determine the difference in logical and physical database design
6. Create a relational database using a popular PC RDBMS
   1. Open the database software
   2. Create a new, empty database
   3. Create a table
   4. Change the design of a table
   5. Enter and edit data in a table
   6. Describe relationships between tables in the database
   7. Enforce relationships between tables in the database
7. Access a relational database
   1. Identify SQL as a non-procedural query language
   2. Discuss the evolution of ANSI versus proprietary vendor extensions of SQL.
   3. Differentiate between data definition, data manipulation, and data control
   4. Explain the purpose of views, indexes aliases, synonyms, and sequences
   5. Discover issues related to the use of embedded SQL
   6. Retrieve data stored in a relational database
8. Understand advanced design and implementation issues
   1. Describe the concept of changing data into information
   2. Discuss the use of information systems in business and industry
   3. Understand the purpose of a systems development life cycle
   4. Explain the database life cycle
9. Identify database directions and trends
   1. Examine different models of database development (i.e. Client/server architecture, 2 tiered and 3 tiered).
   2. Discuss the trend of data warehousing
   3. Identify unique properties of object-oriented databases
   4. List CASE tools used in database development
   5. Discuss considerations for publishing data on the Web
10. Discuss important responsibilities of database administration
    1. Explain the evolution of the database administration function
    2. Differentiate between a DBA?s managerial role and technical role
    3. List some common database administration tools
    4. Compare multiple data administration strategies
    5. Discuss database security concerns and use of firewalls

CIS 332 - Database and SQL

1. Describe the structure of a relational database
   1. Describe the purpose of a database management system (DBMS).
   2. Identify relationships between given entities
   3. Define the terms database, query, tuple, attribute, table, row, column, relation, primary key, and foreign key
   4. Recognize objects in a given database
   5. Describe relational and object relational database concepts
   6. Identify the differences between ANSII standard SQL and application specific SQL statements
2. Create executable SQL statements to perform single-table queries
   1. List the mandatory clauses of a basic SELECT statement
   2. Reproduce the basic form of an SQL command to retrieve data from a database
   3. Cite the comparison operators used in SQL
   4. Formulate queries containing a simple condition to restrict data retrieved by a query
   5. Formulate queries containing multiple conditions to restrict data retrieved by a query
   6. Name arithmetic operators used in SQL
   7. Create computed columns from existing table data
   8. Use the ORDER BY clause to sort query results
   9. Apply SQL built-in functions to SQL queries
   10. Demonstrate the ability to use the GROUP BY clause
3. Create executable SQL statements utilizing single-row functions
   1. Describe the various types of functions available in SQL
   2. Use character, number, and data functions in SELECT statements
   3. Explain conversion functions
   4. Demonstrate the use of conversion functions
4. Create executable SQL statements to perform multiple-table queries
   1. Prepare SQL statements to join tables together
   2. Explain the purpose of comparisons in the WHERE clause of a join statement
   3. Describe the problem with producing Cartesian products in multiple-table queries
   4. Explain what causes a Cartesian product to be formed in a join statement
   5. Identify the different types of joins available in SQL statements (i.e. equijoin, non-equijoin, outer join, inner join, and self join).
   6. Apply the IN, EXISTS and BETWEEN clause to join statements
   7. Demonstrate the use of a subquery to restrict data
   8. Describe the purpose of column and table aliases
   9. Utilize column and tables alias names in queries
   10. Define the set operators union, intersect, and difference
5. Create executable SQL statements utilizing group functions
   1. Identify the group functions available in SQL (i.e. AVG, COUNT, MAX, MIN, SUM)
   2. Describe the use of group functions
   3. Aggregate data using the GROUP BY clause
   4. Use the HAVING clause to include or exclude grouped rows
   5. Demonstrate the ability to nest group functions in SQL queries
6. Create executable SQL statements utilizing subqueries
   1. Define subqueries
   2. Describe the types of problems that subqueries can solve
   3. Write single-row and multiple-row and multiple-column subqueries
   4. Determine the effect of a null value returned in a subquery
7. Create executable SQL statements utilizing correlated subqueries
   1. Describe a correlated subquery
   2. Describe the types of problems that can be solved with a correlated subquery
   3. Use the EXISTS and NOT EXISTS operators in correlated subqueries
   4. Update and delete rows using correlated subqueries
8. Combine SQL queries with SET operators
   1. Describe the set operators (union, intersect and minus).
   2. Obey the set operators rules and guidelines
   3. Include the order by clause in queries
   4. Recognize the rules that must be followed when using set operators in compound queries
9. Produce readable output with SQL*Plus
   1. Differentiate between SQL and SQL*Plus
   2. Construct queries that require and input variable to create interactive reports
   3. Utilize the ACCEPT command to read input variables
   4. Customize the SQL*Plus environment
   5. Save customizations in the SQL*Plus environment
   6. Produce neatly formatted, readable output
   7. Format output with SET commands
   8. Add page headers and footer to reports
   9. Demonstrate the use of the COLUMN command to format reports
   10. Demonstrate the use of the BREAK command to format reports
   11. Utilize the COMPUTE command to produce report totals
   12. Construct script files
   13. Execute script files
10. Create executable SQL statements to create database objects
    1. Describe DDL (data definition language).
    2. Formulate SQL statements to create database objects such as tables, views, sequences, indexes and synonyms
    3. Demonstrate the ability to create new tables from an existing table
    4. Explain the use of naming conventions in SQL
    5. Differentiate between possible data types
    6. Describe how to use the data dictionary to access database object information
11. Create executable SQL statements to update a database
    1. Describe what is meant by DML (data manipulation language).
    2. Describe each of the DML commands
    3. Demonstrate the ability to load data into a database using SQL
    4. Utilize a sequence to insert values into a table
    5. Prepare SQL statements to change, add, and delete data from a database
    6. Describe the use of nulls when updating column values
    7. Implement changes in a database using the ALTER, CREATE, and DROP statements
    8. Write executable SQL statements to modify the structure of an existing table
    9. Rename an existing table
    10. Insert, Update and Delete data through a view
    11. Alter the definition of a view
    12. Explain the process of updating a view
    13. Construct executable SQL statements to delete database objects from the database
    14. Create synonyms for database objects
12. Implement and enforce data integrity constraints in a database
    1. Describe what is meant by referential integrity
    2. Describe various types of database constraints
    3. Include integrity constraints on an SQL statement to CREATE a table
    4. Write executable SQL statements to add integrity constraints to an existing table
    5. Produce executable SQL statements to enable and disable integrity constraints
    6. Utilize system tables to view existing integrity constraints
13. Evaluate special issues involved in managing a database
    1. Describe DCL (data control language)
    2. Define database administration
    3. Investigate SQL features used in database administration
    4. Explain the difference between system security and data security
    5. Explain security mechanisms used in SQL to prevent unauthorized access to a database (such as the GRANT and REVOKE statements)
    6. Define the term ?privileges?
    7. List privileges that can be granted and revoked in a database
    8. Disucss the use of legal values, primary keys, and foreign keys to support data integrity
    9. Recognize the role the SQL catalog plays in obtaining information about a database?s structure
    10. Explain the use of restore/recovery procedures in database administration
    11. Define what constitutes a database transaction
    12. Utilize SQL statements such as COMMIT and ROLLBACK to control database transactions
    13. Describe what is meant by “ready consistency”
    14. Explain why locks are useful in a database.
14. Write scripts to generate SQL commands
    1. Describe the types of problems that are solved by writing SQL scripts that generate other SQL scripts
    2. Write and execute a script that generates a script of drop table commands
    3. Write and execute a script that generates a script of insert commands
15. Test SQL statements thoroughly

CIS 338 - SQL/Oracle

1. Develop blocks of PL/SQL code
   1. Distinguish between SQL and PL/SQL
   2. Describe the benefits of PL/SQL over SQL
   3. Recognize the components of a PL/SQL block of code
   4. Distinguish between anonymous PL/SQL blocks and PL/SQL subprograms
   5. Describe the significance of variables in PL/SQL
   6. Declare and use variables in PL/SQL
   7. Declare and use constants in PL/SQL
   8. Assign values to PL/SQL variables
   9. Distinguish between PL/SQL and Non-PL/SQL variables
   10. List the guidelines for PL/SQL block syntax
   11. Demonstrate effective commenting in PL/SQL code
   12. Execute an anonymous PL/SQL block
2. Control PL/SQL flow of execution
   1. Recognize the significance of the executable section of PL/SQL blocks
   2. Describe conditional statements and process flow
   3. Define a cursor
   4. Explain the difference between implicit and explicit cursors
   5. Declare and use cursors.
   6. Write executable statements within the executable section of PL/SQL
   7. Write a successful SELECT statement in PL/SQL
   8. Write DML statements in PL/SQL
   9. Perform transaction control in PL/SQL
   10. Determine the outcome of a SQL DML statement
   11. Describe the rules of nested blocks
3. Write Control Structures within PL/SQL
   1. Identify the three types of selection structures available in PL/SQL
   2. Identify the three types of repetition structures available in PL/SQL
   3. Construct and IF statement in PL/SQL
   4. Construct looping structures in PL/SQL
   5. Control block flow using nested loops and labels
   6. Use logic tables
4. Create PL/SQL Procedures and Functions
   1. Describe the use of procedures and functions
   2. Compile a procedure
   3. Compile a function
   4. Debug the compile of a procedure or function
   5. Invoke a procedure from the SQL*Plus command prompt
   6. Invoke a procedure from within a PL/SQL subprogram
   7. Invoke a function from the SQL*Plus command prompt
   8. Invoke a function from within a PL/SQL subprogram
   9. Revise and re-compile a procedure
   10. Revise and re-compile a function
   11. Remove a procedure from the database
   12. Remove a function from the database
5. Implement error handling in PL/SQL code
   1. Recognize the three basic types of exceptions
   2. Code exception handlers
   3. Discuss the guidelines for trapping exceptions
6. Create PL/SQL Packages
   1. Describe packages and list their possible components
   2. Create a package to group together related variables, cursors, constructs, exceptions, procedures, and functions
   3. Make a package construct either public or private
   4. Invoke a package construct
   5. Write packages that make use of the overloading feature of PL/SQL
   6. Compile a package
   7. Remove a package from the database
7. Create Database Triggers
   1. Describe database triggers and their use
   2. Create database triggers
   3. Describe database trigger firing rules
   4. Drop database triggers
8. Test PL/SQL programs thoroughly

CIS 346 - Database Design

1. Explain systems integration
   1. Define the term systems integration
   2. Define the term systems integration
   3. Describe various systems development modeling tools
   4. Explain how these tools support the problem solving process
2. Summarize the process of database development
   1. Define key terms
   2. Explain the purpose (benefits) of database design
   3. Discuss the evolution of database design
   4. Describe the phases of database design
3. Analyze user information requirements
   1. Demonstrate importance of effective interviewing skills in the gathering of user requirements
   2. Demonstrate the ability to produce accurate and comprehensive documentation
   3. Utilize facilitation techniques to seek information from data users
   4. Identify business rules which underlie entity relationships
   5. Formulate a data dictionary with all appropriate components
4. Transform business information requirements to an entity relationship model
   1. Describe the benefits of data modeling
   2. Distinguish between popular notation conventions
   3. Identify and model entities
   4. Distinguish between attributes and entities
   5. Identify attributes (composite, multivalued and attribute domains)
   6. Assign unique identifiers to entities
   7. Describe the various types of possible relationships between entities
   8. Analyze and model relationships
   9. Normalize Data Models
   10. Resolve M:M Relationships
   11. Model Hierarchical Data and Recursive Relationships
   12. Model Roles with Relationships
   13. Model Entity Supertypes and Subtypes
   14. Model Exclusive Relationships
   15. Model Data Over Time
   16. Model complex Relationships
5. Convert ER diagrams to relational tables
   1. Apply basic conversion rules
   2. Map simple entities to tables
   3. Map Attributes to Columns
   4. Map unique identifiers to primary keys
   5. Map relationships to foreign keys
   6. Choose arc options
   7. Choose subtype options
6. Normalize tables in a relational database
   1. Define each of the five normal forms
   2. Maximize application maintainability by applying the principles of normalization
   3. Recognize Unnormalized Data
   4. Convert to first, second, and third normal Form
   5. Understand the fourth and fifth normal form
   6. Discuss normalizing during Data Modeling
7. Perform advanced database design functions
   1. Recognize when to generate artificial keys
   2. Understand the issues involved in specifying foreign keys and indexes
   3. Describe how referential integrity related to business data needs
   4. Specify referential integrity
   5. Design indexes
   6. Establish views
   7. Denormalize the database design

CIS 402 - COBOL

1. Utilize acceptable structured COBOL coding and syntax practices
   1. Solve problems using top down design techniques
   2. Subdivide programs using group and elementary items effectively
   3. Organize programs into efficient modular design
2. Complete assigned projects within a specified time frame
3. Develop programs using TOTALS, REPORT EDITING, CONTROL BREAKS, MULTIPLE REPORTS, CONDITIONAL STATEMENTS, MULTIPLE INPUT FORMATS
4. Demonstrate correct usage of numeric COMP and COMP-3 clauses effectively
   1. Demonstrate the correct usage and content of these types of fields
   2. Illustrate their internal representation
   3. Contrast the differences of these usages
5. Demonstrate the ability to compile and execute COBOL programs
6. Demonstrate the ability to use the system development environment to enter programs into files for compilation
7. Provide adequate documentation to allow someone to update the program with relative ease
   1. Furnish internal documentation to document the program
   2. Supply external documentation to document system
8. Demonstrate the ability to structure and use the four COBOL Divisions and the sections within each Division correctly
   1. Assemble each of the four divisions in their correct order
   2. Identify the purpose for each division
   3. Contrast the differences between divisions
   4. Relate each division to the paragraphs and their differences
9. Utilize COBOL PIC clauses and VALUE clauses effectively
10. Identify the differences between PIC X, 9 and A.
11. Assess the contents of storage in each case
12. Demonstrate the purpose of each PIC clause
13. Use MOVE’s in a program effectively
    1. Relate the differences of numeric vs. non-numeric moves
    2. Contrast the differences in each kind of move
    3. Illustrate the result in each move
14. Exhibit an ability to use IF statements correctly
    1. Show the differences of numeric vs. non-numeric comparisons
    2. Illustrate how each should be used
    3. Relate how the compiler determines which comparison it will generate
    4. Demonstrate proper use of data validations using IF statements
15. Demonstrate the ability to use CONDITION NAMES effectively
    1. Show what a condition name generates
    2. Demonstrate when a condition name should be used
    3. Apply condition names to data validation
16. Utilize COBOL 85 standards/COBOL P.C. Compiler directives to apply screen sections to interactive COBOL programs
    1. Demonstrate the use of ACCEPT and DISPLAY to utilize the screen for I/O
    2. Define the content of the Screen Section in the COBOL program
    3. Illustrate the syntax for defining screen locations by the use of line and column
    4. Define the arguments associated with both ACCEPT and DISPLAY
17. Relate the advantages of using a condition name
18. Diagnose and debug COBOL logic problems
19. Verify that figures and other output of programs are correct
20. Demonstrate an ability to write Control break programs
    1. Prepare programs with single and multiple breaks
    2. Produce programs with multiple report output
21. Complete assigned projects within a specified time frame
22. Demonstrate the structure of 1 to 3 dimensional table processing
    1. Relate how tables are structured internally vs the COBOL coding
    2. Use COMP fields as Subscripts appropriately
    3. Show a Subscripts internal structure
    4. Code programs using various dimensional table techniques
    5. Describe the structure and uses in Table processing using IF’s, PERFORM VARYING, PERFORM VARYING AFTER Commands

CIS 413 - COBOL II

1. Develop programs that use Sequential file processing
   1. Write programs to use Sequential Card and Disk input
   2. Write programs to use Sequential Disk output
2. Write programs that demonstrate their ability to Create and Update Sequential Disk Master file processing
3. Code programs using COPY BOOKS
   1. Demonstrate purpose of a COPY BOOK
   2. Generate code to utilize COPY BOOKS
4. Demonstrate an ability to use Internal Sorts effectively
   1. Develop programs using internal sorts
   2. Discriminate when to use INPUT and OUTPUT procedures vs USING and GIVING
5. Demonstrate the purpose of SORTS, as to their functions and design in COBOL programs
6. Write Programs using ISAM file structures
7. Assess Job Specs and Write Programs from them
8. Use ISAM file access methods
9. Write KSDS file update programs
10. Demonstrate the structure and purpose of BINARY and SEQUENTIAL Table SEARCHES and an ability to use them
    1. Use Indexes effectively
    2. Construct tables with indexes
11. Develop programs to LINK and pass addressability between COBOL and Assembler language programs using LINKAGE SECTION, CALLS and ENTRY instructions
    1. Show effective use of COBOL LINKAGE commands
    2. Use ENTRY, CALL, USING and LINKAGE section properly
    3. Write program(s) to LINK between COBOL and ASSEMBLER Modules
12. Demonstrate an ability to effectively use COBOL Debugging Tools
    1. Use Debug packets, TRACT, EXHIBIT, DISPLAY, ON and CBL Debugging Aids
    2. Explain the purpose of each
    3. Organize a program using a DEBUG packet
13. Interpret and use COBOL System Core Dumps using ASNI Hex debug
14. Develop an understanding of programs using SECTIONS and GOTO’S
15. Create and maintain Relative Files using Valid and Invalid key structure
16. Utilize Rewrite and Delete in Random Access files

CIS 450 - PLTW Computer Science Principles

1. Evaluate programming ablities
   1. Create original programs in Scratch
   2. Incorporate audio and visual elements in programs
   3. Solve algorithmic problems in programming
2. Analyze existing code with an emphasis on the roles of variables
   1. Design and create an Android application
   2. Identify binary representations of numbers, letters, colors, and images
   3. Use CS unplugged to create physical representations of data storage
   4. Make minor modifications to existing App inventor programs
   5. Analyze complex programs and incorporate event handlers into programs in meaningful ways
3. Prove understanding of algorithms with the use of a new language
   1. Utilize Python with functional, imperative, and declarative programming paradigms
   2. Simulate program execution in a model assembly language
   3. Create Python algorithms
4. Use object-oriented libraries to become independent learners of a programming language
   1. Manipulate image files by modifying pixel data
   2. Use code libraries
   3. Use Application-programming interfaces (APIs)
   4. Read discuss and debate intellectual property issues associated with digital data
5. Create Graphical User Interfaces (GUI) with considerations of audience and accessibility
   1. Generalize a user interface topic to the field of human-computer interactions
   2. Use an API to acquire methods that affect an object?s state
   3. Modify elements of a pattern to a stated programming need
   4. Create and model-view controller GUI
6. Assess the components of a digital footprint
   1. Compare designs, strengths and weaknesses of content and flow of data of existing web pages
   2. Compare results from a variety of search engines to refine search techniques
   3. Explore the hierarchical nature of DNS and IP
   4. Use HTML and CSS to learn the tree structure of web documents
7. Analyze client-side code, server-side code, and databases for delivery of interactive web content
   1. Collaborate between client-side code and server-side code to publish content on the web
   2. Use JavaScript and PHP code to problem solve
   3. Compare languages to generalize concepts of sequencing instructions, selection of instructions by conditionals, iterations and variables
   4. Explore and compare career paths within computing
8. Maintain online security and improve personal cyber security hygiene
   1. Explore cyber security from the perspective of user, software developer, and a business
   2. Explore parallel strands in encryption and security
   3. Use encryption as a route to explore the efficiency of algorithms
9. Create visualizations to analyze sets of larger data and interpret patterns
   1. Discuss societal concerns related to the collection and persistence of Big Data
   2. Use Python to make meaningful graphic representations of data
   3. Use basic Excel spreadsheet programming and cell manipulation
10. Apply statistics to deepen the meaning of knowledge gained by visualization of data
    1. Draw conclusions from relevant data
    2. Manipulate and visualize data using multiple platforms
    3. Experiment with object recognition and facial recognition software
    4. Identify clustering and linear correlation patterns in data
11. Use Moore’s law and computer modeling
    1. Discuss Moore’s law and its application to computer modeling and simulation
    2. Manipulate discrete electronic components to create logic gates and comparable results using integrated circuits
    3. Explore simulation in NetLego
    4. Examine the code of ethics for simulations
12. Evaluate intelligent and complex behavior arising from simple rules and unintelligent agents
    1. Manipulate models to change behaviors
    2. Explore the generation and observation of fractals and diffusion limited aggregation models

CIS 451 - PLTW-Computer Science Applications

1. Create a Java Program
   1. Define Object Oriented Programming
   2. Describe the basic features of the Java programming language
   3. Use an Integrated Development Environment to enter Java code
   4. Utilize programming logic to create a Java application
   5. Demonstrate ability to write Java methods that accept arguments and return a value.
2. Assess and manipulate data in Java
   1. Demonstrate how to define an array
   2. Manipulate array elements
   3. Create a String object
   4. Write Java code that parses String data
   5. Develop Java code to manage and maintain lists
   6. Implement the autoboxing feature
3. Incorporate and extend common User Interface (UI) features
   1. Create a Java application using graphical user interface components
   2. Investigate the concept of inheritance
   3. Understand class definitions
   4. Incorporate a navigation drawer
   5. Explore and critique a Unified Modeling Language (UML) diagram
   6. Outline the components of a Java method
   7. Demonstrate method overloading
4. Implement common data structures
   1. Utilize an ArrayList
   2. Use loops to traverse Arrays and ArrayLists
   3. Define a stack data structure
   4. Describe a queue
   5. Access a Backend as a Service (Baas) to implement data persistence
5. Demonstrate the App Development Process
   1. Define a project
   2. Follow the steps of prototyping and usability testing
   3. Present an app with documentation as a final project
6. Create a backend service for apps
   1. Store and retrieve user data from the cloud
   2. Connect Object Oriented Programming (OOP) to Application Programming Interfaces (API)
   3. Create apps that store significant amounts of data
   4. Manage interfaces for a social networking app
7. Develop a location aware app
   1. Define GPS (Global Positioning System)
   2. Utilize Google Play services
   3. Add location data to user posts in an app
8. Analyze the concept of Java classes and objects
   1. Categorize data into subclasses of an abstract type
   2. Combine data into lists
   3. Understand and use polymorphism
   4. Demonstrate the use of dynamic late binding
   5. Construct classes that inherit from interfaces
9. Implement Java computational algorithms
   1. Analyze the performance of various searches and sorts
   2. Perform statement execution counts
   3. Use a simple rounding algorithm
   4. Experiment with operator precedence and witness integer overflow
   5. Convert between hexadecimal and decimal number systems
10. Utilize Java frameworks
    1. Use LibGDX (an open source game development framework)
    2. Access resources and utilize tools
    3. Collaborate with a team or a client
    4. Incorporate media assets
    5. Work with touch events
    6. Manipulate data in 2D data structures
    7. Communicate with a database
11. Support Program Code Maintenance
    1. Identify code problems
    2. Correct existing logic errors
    3. Implement new features into existing apps
    4. Create checked exceptions

CIS 505 - Structured Systems Analysis