170 likes | 293 Views
Agenda – 9/13/2013/ Friday. Howard J Rattliff, Jr. – Principles of Technology - Course # 130227200 -.
E N D
Agenda – 9/13/2013/ Friday Howard J Rattliff, Jr. – Principles of Technology - Course # 130227200 -
Legend: Instructor Class Individuals Assignment/ Discussions SME = Subject Matter Expert
Review Notes from Previous Lecture and Feedback: • Log in Usernames and Passwords assigned • Everyone needs to remembers their security password !!! • Reviewed log in and began to Navigate Excel Workbook/worksheets • Created or added new worksheets • Was to save to H drive? N drive . Discussed \ back slash and / forward slash and how to recognize them. \\ vs // (double back and forward slashes. • Was at the point of discuss “Default Setting in Excel”
STEM - Friday Topic of the Week • STEM stands for Science Technology Engineering Math. ASSIGNMENT READING : • 1 page article (an ad ) in Bloomberg Magazine entitled “STEM Sell” • Posted to my UME website. • Go to the UME website http://howard_rattliff.myteachersite.org/teacher/site/ • Path is www.umeprep.org/HOME/TEACHER SITES/Howard Rattliff • Under Teacher Sites select my name and you’ll see the class postings. • The article is a jpeg file posted under the LN (lecture notes ) 9-13-2013 postings. • Read and be prepared to discuss in class Monday – Topic of the Day session. • Ideas / Suggestion: Attend STEM Summer sessions at local universities. SMU has a engineering summer program for High School. Texas Wesleyan in Fort Worth has one. These are great resources that encourage student to consider Science Technology Engineering and Math as career. Even if you don’t consider this a career path, technology is so pervasive that this investment helps you use it and understand it. • It is a great competitive edge! It keep all your options open.
Class Exercise !! • Default settings • The IF statement (conditional logic) - “A Classic”
Powering Up the PC - Class Protocol 1 (rules/etiquette observed ) CLASS EXERCISE: • Go silently and orderly to computers- and sit down. Any PC will do. • Look for power on /off for Display or Monitor - Turn on Monitor • Look for power on /off button on Desktop – Turn on Computer • Results: Default USER Log on screen appears • Note: When Mr. Shafer assigns you your user id and temporary Password we can begin your initial Log on (will ask you to change your password to something more secure). Save that pwd and use it to log in in the future. • As mentioned earlier we are waiting on the enrollment system to feed Mr Shafer the information to generate user id, etc - Expected Mid Sept ( 1 to 2 weeks max ) (we are 1st on the list. Reverse Step and Turn off equipment approximately 10 minutes before end of each class.. Don’t Forget.
The Excel Workbook (multiple worksheets) Column letters Name box (identifies active cell) Formula Bar Active Cell Column Cell selector (the intersection of Column and Row) Row numbers Worksheet names (default qty is 3) Sheet tabs
Arranging the DATA Example: Sort Name List or Table Alphabetical Characters Max table dimensions: 1,048,576 rows by 16,384 columns RESULTS: A COMPARATIVE APPROACH : ANALYSIS OF DATA RESULTS: The independent variable is x . Normally the name or Title of the observation or measurement event X 16,384 columns The dependent variable isY . Normally the measurement event Computer did not recognize a misspelled Name (Brain for Brian) ?? Y 1,048,576 rows Y = f (X) …… An algebraic function! The table establishes or records a relationship between the Y and X
The Excel Workbook (multiple worksheets) Column letters Name box (identifies active cell) Formula Bar Working area of interest: Defined by: Nx100 area on a worksheet Active Cell Column Cell selector (the intersection of Column and Row) Row numbers Worksheet names (default qty is 3) Sheet tabs
Exercise – • Exercise – Default Setting in Excel
Excel Default Settings (similar settings including Powerpoint and Word) • Viewing Setting and Configuration? • MAIN MENU BAR in Office 2010 EXCEL • FILE/HOME/INSERT/PAGE LAYOUT/FORMULAS/DATA/REVIEW/VIEW • Menubar --- FILE/options/general >> • Applies to particular doc (Excel uses the term “workbook “ but else where in other technology tools, other terms might be used such as (workspace / a project ) • Menubar --- FILE/options/formula >> • Menubar --- FILE/options/save >> • Menubar --- FILE/options/advanced>> • Menubar --- FILE/options/advanced>> • Commonly used Settings • Saving Settings address the things we do most often in the applications environment ( using the applications and development (programming) etc) • Worksheet Settings • The Tool bar • Programming
Logical condition Programming – The basic If statement Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. • Use IF to conduct conditional tests on values and formulas. Syntax • IF(logical_test,value_if_true,value_if_false) • Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.
If Statement Construct (Syntax) A Data Facility Name 50 Formula Description =IF(A2<=100,"Within budget","Over budget") If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" True False 1. 2.
Value_if_true is the value that is returned if logical_test is TRUE. • For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". • If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). • To display the word TRUE, use the logical value TRUE for this argument. • Value_if_true can be another formula. • Value_if_false is the value that is returned if logical_test is FALSE. • For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". • If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. • If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. • Value_if_false can be another formula.