Electrical Engineering Mechanical Engineering

Home School

The following list are Excel spreadsheets developed to teach a variety of subjects.

 

2009 - 2011  Stark State College of Technology

Associate Degree in Electrical and Electronic Engineering (dbl deg)

Excel: Data Analysis and Decision Making

  • With the release of Office 2010 some of the macros in the data files above are obsolete.
    Excel is a powerful tool capable of performing a variety of analytical functions used for budgeting, accounting and financial analysis. Applications created will include statistical, logical, financial and string functions, graphics, data manipulation, macros, "what-if" analysis, programming custom menus and transferring data to/from other software. Upon completion, students should be able to plan, implement, test and document complex spreadsheet models.

Circuit Manufacturing Techniques

  • Safety in the shop and stages of project development are emphasized. Electrical and mechanical shop practice including use of hand tools, through hole and surface mount, soldering techniques, solderless terminations, wire preparations, wiring techniques and parts ordering.

Electronic Circuits I

  • Some of the data files above contain known errors. The information given is for reference only.
    A study of semiconductors, field effect transistors, h-parameters, device equivalent circuits, small signal analysis, multistage amplification, decibels, frequency analysis, large signal amplifiers, thyristors, power amplifier design, differential amplifiers, operational amplifiers, feedback and oscillator circuits, electronically regulated power supplies, and applications of circuits with these devices.

Pulse and Digital Integrated Circuits

  • This course is a study of pulse terminology, number systems and codes, TTL and CMOS IC logic circuits and interfacing, Boolean Algebra and logic simplifications, integrated arithmetic circuits, counter, register, encoders, decoders, multiplexers, and demultiplexers, display devices, IC flip-flops, hardware minimization techniques are also covered in conjunction with logic circuit design.

PC Maintenance & Upgrading

  • The student will be working with various operating systems such as DOS, Windows 98, 2000 and XP. Student will also have hands-on experience building and repairing PC's in a lab environment. Hardware topics include: system board, microprocessors, busses, memory, disk drives, and power supplies.

Windows Programming with C#

  • In this course the student will learn to design, create, test, deploy, maintain and support desktop software applications using Microsoft's C#.Net. The student will complete a series of hands-on lab exercises using C#. This class will help prepare the student Microsoft's MCTS certification exam. Hands-on labs are utilized to reinforce the presented materials.

Electrical Machines

  • This course covers the principles of electromagnetic induction, dynamo construction, direct current generation characteristics and operation, armature reaction, DC motor characteristics, operation and control, machine efficiency, single and three-phase transformers theory and operation, construction of three-phase transformers, AC motors and generators. Subjects include: polyphase transformers, induction motors, alternators, synchronous motors, single phase induction, universal and specialty motors.

Electronic Devices and Circuit Theory

  • Theory, characteristics and applications of solid-state devices. Devices covered include: diodes, bipolar junction transistors, field effect transistors, operational amplifiers, analog and digital voltage regulators.

AC Circuit Analysis

  • Alternating current (AC) circuit analysis and instrumentation. Topics include: phasor analysis, RL, RC and RLC circuits network theorems, power, resonance, fitters, pulse analysis, transformers and three phase systems.

Programming Logic & Problem Solving

  • This course addresses the student to program logic and problem solving techniques. Primary emphasis is on achieving familiarity with structured programming principles through awareness and application of structured programming and object-oriented concepts and techniques. Upon course completion, the student should have an understanding of how to develop the logic to solve a programming solution using structured flowcharts and psuedocode.

Visual Basic Development

  • This course addresses designing, developing, testing, and deploying desktop software applications using the Microsoft Visual Basic.Net programming language. This course will help prepare the student for MCTS certification in Microsoft Visual Basic.Net. Upon completion of this course, the student should be able to develop a desktop application with a graphical user interface, write code using Visual Basic control structures, properly validate user input, and test and debug the application.

DC Circuit Analysis

  • Direct current (DC) circuit analysis. Topics include: voltage, current, resistance, Ohm's law, power, circuit reduction, Kirchhoff's laws, network analysis methods, network theorems, capacitors, inductors, transients and sine wave characteristics.

PLC's and Industrial Controls I

  • A presentation of techniques, application and development analysis of relay control circuits with implementation of electromechanical devices, programmable controllers and variable frequency drives. Circuits, devices and techniques studied include control of motor starting, motor speed control, machine cycle control, control components, pilot devices, maintenance and troubleshooting circuits.

1990 - 1998  Stark Tech

Associate Degree in Mechanical Engineering

Advanced Pro-Engineer

  • This three-dimensional drawing uses Parametric Technology Corporation Pro/ENGINEER software and covers the basic through advanced commands. The basics focus on practical applications of design to develop parametric solid model representations of parts and assemblies. Advanced design features include the use of skeletons, advanced sketching, geometry, patterns, surface options, dimensions, bill of materials, and features, and plotting.

AutoCad14 to Pro-Engineer

  • This three-dimensional drawing uses Parametric Technology Corporation Pro/ENGINEER software and covers the basic through advanced commands. The basics focus on practical applications of design to develop parametric solid model representations of parts and assemblies. Advanced design features include the use of skeletons, advanced sketching, geometry, patterns, surface options, dimensions, bill of materials, and features, and plotting.

Advanced AutoCad

  • Building on concepts learned in Basic AutoCAD, this course focuses on more advanced topics: isomode; attributes; creation of toolbars, pull-down and button menus; creation of custom line types and hatch patterns; and an introduction to the fundamentals of AutoLISP programming.

Electromechanical Systems

Dynamics

  • Methods are developed to analyze kinematics and kinetics of bodies. Practical derivations, equations, and applications of displacement, velocity, acceleration, work, energy, power, impulse, and momentum in both planar and rotational motion will be applied.

Statics & Strengths of Materials

  • The study of major force systems under conditions of equilibrium. Various methods are used to analyze the effects loads have on structural members and machine components. Topics include force systems, friction, stress and strain, moment and shear diagrams, centroids, moments of inertia, and beam deflection analysis. Emphasis is placed on learning the fundamentals and applying them to solving problems.

Machine Design

  • Descriptive, dimensional, and kinematic analysis of machine components including bearings, shafts, couplings, cam, brakes, gear drives, belt and chain drives, and clutches are the focus of this course. Laboratory work includes problem solving in the design of machine components with spreadsheet analysis when necessary.

Manufacturing Processes

  • Students will investigate a variety of manufacturing techniques including casting, powder metallurgy, metal forming, hot and cold working, arc and gas flame welding, rapid prototyping, microelectronic manufacturing, and chip-type machining processes. Scheduled tours of local industry and/or guest speakers augment the material.

Material Science

  • The study of the science of materials used in the fields of engineering and manufacturing. Emphasis is placed on the physical properties of materials. Areas covered include: stress and strain, hardness, creep, fatigue, metallurgy, equilibrium diagrams, and heat treatments. Advantages, disadvantages and applications of ferrous metals, non-ferrous metals, plastics, elastomers, composites and ceramics are discussed.

Introduction to Computer Programming (Q-Basic)

Basic AutoCad

  • This course begins with basics and gives students hands-on experience using personal computers to create engineering drawings with AutoCAD software. Topics include: basic components of a CAD system, overview of [Windows] operations, input methods, drawing setup and display, editing, dimensioning, text, layers, hatching, blocks and plotting.

Engineering Co-Op

Basic Economics

  • A survey course designed to introduce students to basic economic concepts and principles of modern micro- and macro-economics. Major topic areas will include supply and demand, price system, market economies, monetary and fiscal policy and global economic issues. Upon completion, students should be able to demonstrate an understanding of the above topic areas.

Physics II

  • Study of heat, electricity, magnetism (including circuits), electromagnetic radiation (including light), and optics. Problem solving in orientation, emphasizing the application of formulas, algebra and trigonometry to physical situations. Laboratories focus on the correct reading of measuring instruments, proper handling on measurements in calculations and testing physical theories using measured data.

Technical Report Writing

  • This course stresses clarity, logic and appropriate organization in informal and formal technical reports. An oral presentation/proposal may be required.

Psychology of Work

  • Drawing from a wide range of psychological theories, principles and research, this course emphasizes personal and interpersonal skill-building beneficial to the prospective professional. Topics include learning and memory; perception; motivation and leadership; group dynamics and team-building; problem-solving and conflict resolution; communications; and stress management.

Engineering Drawing

  • This is a beginning drafting course that includes use of instruments, geometric constructions, technical lettering, orthographic projection, auxiliary views, sectional views, dimensioning and conventional practice.

Analytical Geometry & Calculus

  • A study of the theory and techniques of analytic geometry, differential and integral calculus, including variables, functions, limits, differentiation, integration and applications of the derivative and integral.

College Algebra & Trig II

  • Topics are solving oblique triangles, vectors, graphs of trigonometric functions, complex numbers, exponents, radicals, exponential and logarithmic functions, higher degree equations, additional equations and inequalities.

Fluid Power

  • The study of the subjects essential to understanding the design, analysis, operation and application of fluid power systems is the focus of this course. Theoretical principles will be used to develop an understanding of hydrostatics and hydrodynamics. Teamwork skills will be reinforced through hands-on experimentation and written presentation of results. Students will submit formal reports in a format that requires the use of word processing and spreadsheet software.

Physics I (mechanics)

  • Study of motion, force, momentum, energy, rotational dynamics and torque, centripetal force and gravity, structure and properties of matter, fluids, vibrations and waves. Problem solving in orientation, emphasizing the application of formulas, algebra and trigonometry to physical situations. Laboratories focus on the correct reading of measuring instruments, proper handling on measurements in calculations and testing physical theories using measured data.

Computer Numerical Control I

Society & Technology

Technical Mathematics II

Technical Mathematics I

Machine Tools

College Writing

College Mathematics

Introduction to Mechanical Engineering Technologies

Introduction to Writing