ENED Exam 2

Precedence Network

a diagram that shows the tasks and their precedence requirements

Gannt Chart

a graphic planning and control technique that maps discrete tasks on a calendar.

Flow Diagram

a graphical way of showing an algorithm

Work Breakdown Structure (WBS)

a hierarchy of the tasks required to complete a project

Accuracy vs. Precision

accuracy: how close experimental value is to accepted value; precision: how closely measured values agree with each other.

Rules of Orthographic Projection

-only shows where two surfaces connect -front, top, and right-side view, edges must be lined up - front: height/width, -top: width/depth, - side: depth/height, - hidden lines for edges you cannot see -normal surfaces show up in same shape and size - surface in one view edge in other two

arithmetic operators in Excel

1. Addition (+) 2. Subtraction ( -) 3.Multipication ( *) 4.Division ( /) 5. Exponent (^)

Flowchart

A diagram that shows step-by-step progression through a procedure or system especially using connecting lines and a set of conventional symbols

Critical Path Method (CPM)

A method used to estimate the minimum project duration and determine the amount of scheduling flexibility on the logical network paths within the schedule model.

Flowchart Symbols

1. Arrows (Shows the flow of the program). 2. Ovals (End and start of the program). 3. Rectangle (Processing such as calculations, etc). 4. Parallelogram (Input of data and output from the computer memory). 5. Diamond (indicates a decision, like true or false) 6. Rectangle with lines (process of modules read, calc, print) 7. Polygon (loop with a counter) 8. Connectors (Flowchart connectors like circle sections of the same page. Home base connects pages)

Describe how values and formulas are referenced in Excel

column letter followed by row number

relative vs. absolute cell addressing

- relative cell addressing changes the references when copied into a new cell -absolute references remain constant no matter where they are placed

how to connect objects in block diagram

use strings to connect each item in the block diagram

Describe how values and formulas are entered into Excel cells

-for calculations place = as first character -use ^ for exponents -when a formula is copied, it will automatically update to reference cells in the same relative position -to keep values constant in a formula put $

List necessary features of an Excel graph

-graph title -axis labels -correct axis increments -trendline -functions from trendline, including R^2 -legend

ways that surfaces project orthographically

-normal -inclined -curved

Significant digit rules in a series of calculations

1. if the calculation only involves multiplication/division, preform the computation and round the result to the least number of significant digits among the values in the calculation 2. if the calculation only involves addition/subtraction, preform the computation and round the result to the least number of decimal places among the values in the calculation 3. if the calculation involves both addition/subtraction and multiplication/division, preform the computation in steps following the correct order of operations, keeping track of the number of significant digits/decimal places as you go but only rounding the value to the correct number of significant digits at the end of the calculation

Significant Digit Rules

1. nonzero numbers are always significant 2. zeros between nonzero numbers are always significant 3. all final zeros to the right of the decimal place are significant 4. Placeholder zeros are not significant 5. counting numbers and defined constants have an infinite number of significant figures

Strategies for estimating real-world measurements

5 Approaches to Estimation: 1. simplify the model: can you use something easier to calculate to represent the object of study? 2. use analogies: Is there something you have more knowledge of that is similar to the given situation? 3. scale up from one to many: can you understand a subset of the total and expand to the full situation? 4. place limits on answers: can you bound the potential answers so that you can simplify calculations? 5. interpolate/ extrapolate from samples: can you use a small set of measurements to help determine values that cannot be measured?

commonly used mathematical commands in Excel

=sin() =cos() =tan() =pi() =squrt() =abs()

what is a scatter plot

Plots data points as individual, unconnected points; good to determine relationships between data

what is a line graph

Plots data points connected by line; good for independent-dependent data

Ideate:

Reasons for Developing Multiple Potential Solutions: - be able to choose which solution is the best - have back up possibilities incase chosen solution does not work - understand there are different ways to approach a problem Use a decision matrix to decide which solution is the best: - put the value of each part on the side - determine the value given to each possible solution - highest total is the best solution in theory

systematic vs random error

Systematic error is still wrong but that answers are consistently wrong by the same degree of error. Random error is just random

what is a pie chart

displays data as a percentage of a whole; good for showing contributions from different groups

what is a bar graph

displays data as bars; good for comparing multiple data of similar type

Different corner views of an object

each corner produces a different view of the object

isometric, top, side, and front views of an object

isometric: drawn from one selected corner top: top of the object front: front of the object, usually labeled front. side: right side of the object

appropriate measurement strategy to estimate a real-world measurement

it depends on this situation: -if you are able to take many measurements you would want a system that is more precise -if you only have one try to test the instrument you would want it to be accurate

how to reference a range of cells in Excel

two cells connected by a colon