Transcript ExCel Chapters One and Twox

ExCel Chapters 1 and 2
Classwork: Problems 2-3, 2-6, 2-8, 2-10
Homework: Problems 2-4, 2-7, 2-9, 2-13
Chapter 1: Engineering Analysis and
Spreadsheets
• Spreadsheet Overview
• General Problem-Solving Techniques
• Applicable Engineering Fundamentals
• Mathematical solution Procedures
Vocabulary: Tested on the exams
• SPREADSHEET is a table containing numerical and/or alphanumeric
values.
• CELLS are individual elements within a spreadsheet. Identified by an
ADDRESS which indicates ROW and a COLUMN.
• WORKSHEET is a tabular collection of cells.
• A spreadsheet can contain multiple worksheets (tabs).
What can Excel do for me?
• Import, export, process and store data
• Display data graphically
• Analyze data statistically
• Fit algebraic equations through data sets (regression)
• Solve single and simultaneous algebraic equations
• Solve optimization problems
• As the input parameters change, the entire worksheet is recalculated.
Very easy to examine the effect of varying the input.
General ENGR Problem Solving Techniques
• 1. Think about the problem before you start to solve it.
• 2. Consider drawing a sketch before you solve it.
• 3. Ignore peripheral or irrelevant information.
• 4. List the input (what is known) and output (what must be
determined)
• 5. What engineering principles apply to this problem.
• 6. Choose which method you will use to solve this problem.
• 7. Develop your solution in an orderly and logical manner. Clearly
label everything including units.
Problem Solving – con’t
• 8. Check you answer. Does it make sense? Are the units correct?
Did you answer the question posed?
• 9. Examine that your solution is clear and complete. Is the logic used
to solve the problem clear.
ENGR Fundamentals
• Equilibrium – force, flux, chemical.
• Conservation laws – mass, energy and possibly momentum.
• Rate Phenomena – a potential drives a flux. For example, Ohm’s law
of electrical current flow where i is the current flow (a flux) and V
represents a voltage differential (a potential).
Mathematical Solution Procedures
•
•
•
•
•
•
•
•
•
Data statistics like mean and standard deviation
Curve-fitting techniques
Interpolation
Solve algebraic equations
Solve simultaneous linear algebraic equations
Evaluate integrals
Engineering economic analysis
Optimization
CLASSICAL METHODS use algebra and calculus. NUMERICAL METHODS use
a computer to perform successive approximations.
Chapter 2
Creating an Excel Worksheet
Topics
• Entering and Leaving Excel
• Getting Help
• Moving around the Worksheet
• Entering Data
• Correcting Errors
• Using Formulas
• Using Functions
• Saving and Retrieving a Worksheet
• Printing a Worksheet (we will omit this section)
Entering and Leaving Excel
• Study Figures 2.1 and 2.2 and 2.3
• Be able to label the parts of an Excel worksheet for the exam
• Study the vocabulary words that are in italics
• Several ways to leave Excel: from the File Menu, from the X on the
upper right.
• Be sure to save you work before you leave!
Getting Help
• F1 key
• ? Icon (upper right)
Moving around the Worksheet
•
•
•
•
Mouse – click on a new cell to make it the active cell.
Arrow keys – moves cell to next adjacent cell. New active cell.
PageUp, PageDown – vertical movement of several lines. New active cell.
Ctrl-LeftArrow, Ctrl-RightArrow, Ctrl-DownArrow, Ctrl-UpArrow –
movement to opposite edge of the worksheet. New active cell.
• Scroll bars. Displays a new area but you must click with the mouse to make
a new active cell
• Home, End keys. Ctrl-Home goes to A1 cell. Ctrl-End goes to the last cell
that contains data.
• GoTo key. Pressing this allows you to enter a cell reference to go to.
Entering Data
• Numerical value – known as number constant
• String – known as a text constant
• Numerical values can be formatted in many ways.
• Do Problem 2.3 as classwork.
• Do Problem 2.4 as homework.
Correcting Errors
• Edit as you go or after you have completed the entry an moved on
from that cell.
Using Formulas
• Formulas expresses interdependencies among the values in different
cells within a worksheet.
• Formulas let you perform arithmetic operations, combine strings and
compare the contents of one cell with another.
• FORMULAS BEGIN WITH AN EQUAL SIGN (=), FOLLOWED BY A
NUMERICAL EXPRESSION CONTAINING CONSTANTS, OPERATORS AND
CELL ADDRESSES.
Operators
• Numerical operations (PEMACC): percentage, exponentiation,
multiplication and division, addition and subtraction, concatenation
(&), logical comparisons (<, >, <=, >=, <>)
• Parentheses override this order and use parentheses freely
• Do Problem 2.6 and 2.8 and 2.10 as classwork
Using Functions
• Excel has many, many pre-defined functions such as MEAN which will find
the mean (average) of a group of cells.
• A function consists of a FUNCTION NAME followed by one or more
ARGUMENTS (which are put in parentheses). The arguments are usually
cell references
• Functions can have arguments which are also functions.
• Formulas can be used as function arguments.
• You can search for functions using the fx button.
• You can start typing a function name as part of a formula and Excel will
present a list of functions to choose from.
• Or, access the Function Library within the Formulas tab on the Ribbon.
Trig Functions
• The trig functions expect an argument in RADIANS. To convert
degrees to radians simply by using the RADIAN function. So, to find
the tangent of 45 degrees type
• Tan(radians(45))
Saving and Retrieving a Worksheet
Printing a Worksheet
• Typical Office 365 methods are used to save and open worksheets.
• We will not cover printing a worksheet due to many variations in
types of printers, etc.
HOMEWORK
• Problems 2-4, 2-7, 2-9, 2-13.
• Submit as one Excel workbook with separate worksheets.
• File name is LastName_FirstName_HW2