FOUNDATIONS OF ENGR I
FOUNDATIONS OF ENGR I ENGR 111
Popular in Course
Popular in Engineering and Tech
Mrs. Savanna Frami
verified elite notetaker
This 59 page Class Notes was uploaded by Sage Prohaska on Wednesday October 21, 2015. The Class Notes belongs to ENGR 111 at Texas A&M University taught by D. Walker in Fall. Since its upload, it has received 41 views. For similar materials see /class/225866/engr-111-texas-a-m-university in Engineering and Tech at Texas A&M University.
Reviews for FOUNDATIONS OF ENGR I
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 10/21/15
MS Excel Introduction i Overview What is MS Excel Data Entry Formula across the columns Formula in the column Charting X Y Plot Signi cant digits Accuracy Overview Different styles of data representation Column Chart Bar chart Line Graph Pie Chart Confidence Interval Summary a What is Ms Excel Program which manages and analyzes the data Used in data manipulation Used to generate graphical representation of data like bar chart pie chart etc a Data Entry Spreadsheet is organized as rows and columns Rows are numbered starting from 1 Columns are named alphabetically starting from A Data entered can be manipulated as a combination of rows and columns Formula across the column If the values of a column is dependent on other two columns then a formula can be provided which calculates the value of the dependent column Eg if C is dependent column whose values is calculated as Sum of Column A and B Enter A1 Bl in C1 and drag it till the last value of column C across the column quotl CI l Formula in the column If all the elements of a column is to be added then Enter SUMC1C5 SUM is an inbuilt function in Excel Gives sum of elements from C1 to C5 Other mathematical operators I Formula in the column lll LI DIE is independent variable is dependent variable fX is plotted on horizontal axis is plotted on vertical axis a Charting X Y Plot X Y Plot Charting Label both the axes Provide units on the axes For multiple plots on same graph provide description for each Use light background a Charting Significant digits determines the accuracy How to find the number of signi cant digits Number with indicated decimaleg 113 Non zero digits are significant digits Zeros with non zero digit to it s left are significant zeros 0000123 has 3 significant digits 1002300 has 7 significant digits Number without indicated decimal 12300 x 1024 has 5 significant digits a Charting Accuracy of a calculated number must be such that Signi cant digits in the dependent variable is equal to or less than the independent variable I Eg Y X3 X 10 Y 033333333 from calculator Needless accuracy It should be 033 a Styles of Data Representation Column Chart 60 50 4O 30 20 1O O Styles of Data Representation Bar A N 0 A 01 D Styles of Date Representation Line Graph 25 20 Styles of Data Representation Pie Chart EI1 2 D3 D4 5 8 gon dence Interval Used in estimation Range of values that has a specified probability of containing the parameter in it gCon dence Interval Example Estimation of Car speed Measure the car speed a number of times Calculate the 9500 confidence interval Eg Confidence interval 5060 mph Chances of car speed next time to be in the range 5060 is 095 gExample 1 Given is the selling price and cost price of 5 items Find Profit made in each item Total pro t Calculate the overall pro t percent Item Cost Price Selling Price 1 100 1 10 2 1 20 1 1 O 3 85 90 4 160 185 5 300 330 gExample 1 Item Cost Selling Profit Selling Price Price Price 1 100 1 10 10 1 10 2 1 20 1 1 O 1 O 1 1 O 3 85 90 5 90 4 160 185 25 185 5 300 330 30 330 gExample 1 Total Pro t 2 Pro t per item 10 10 525 30 60 Pro t 0o ProfitTotal Cost X 100 60765 X 100 78 00 gExample 2 A ball is dropped from 100 meter height Every time it hits the ground it loses some energy and hence the height achieved this time is less than the previous one Let hn be the height after nth hit on ground Assume following relation hn 09 x hn1 Calculate the height of the ball for n 1 to 20 and show it as column chart and X Y plot with n on X axis and hn on Y axis Hit Height O 100 1 90 2 81 3 729 4 5 Summary MS excel is a powerful program Extremely useful in Data manipulation and statistics Useful in Data representation MS word Introduction i Overview What is MS Word Getting Started Handling Files Formatting Tables Graphics Mathematical Equations 5 Overview 7 Creating Template Spelling and Grammar Check Summary a What is Ms Word Word Processor Used to create good documents efficiently Reliable in built tools like spell and grammar check User friendly a Getting Started Screen Layout Menus Shortcut menus Toolbars Getting Startgd Screen Layout standard toolbar menu bar rormaulng toolbar View choices drawing toolbar status bar previousnext page buttons Source http wwwfgcuedusupport office2000word a Getting Started Fgrrnat Iools Table vvindow Fgrrnat Inols Table indow A Eont g Earagraph garagraph Bullets and umhering Bullets and umbe ng atders and Shading nrders and Shading goiumns Columns Qrclp Cap BE Theme A V r tyle Uu T DIrECchn Change Casg 514 iject j Background gt y T a Fgarnes p 21 utaFnrmat tyle a Getting Started Shortcut menus Cut EDDY Easte gecrease Indent anraase Inclant Eont Earagraph Bullets and Humbering yperlink 59 ettlng Started Tool ba rs I El orma W met La B39lnt Layout I IE Qutline V ler monument Map Header and Fbotsr E mtnote W Qumments Full Screen gum 39 mew Insert Fgrrhat Ion w gwlmvnvlg 1uvln 5v gov Duiment wlnu Tables and Borders Visual Basic Web a g Handling Files Creating and opening documents File 9 Open Saving documents File 9 Save Close a document File 9 Close Handllng Flles Creating and opening documents Fi e gt Open l xl g My Documents v a gtlt a v Tools me I 122 I Tu a My es Folder 6 tamu Folder abhijitpr Folder 7 a My R ceived File Folder quot E mDmnDn Folder my DtcurnErnts Spoture Folder My Si Folder 3 My Pictures Fold 5 1 1 3 KB HTML Document sxjgxzuus 1 Favorltes Flle dame I Ll In Qpen IFI Files 0quot type IAII Word Documents doc dcvt htm hml lurl v Cancel My Eatwork Places Handling Files Saving documents File gt Save l39gtltl a My Documents lex vTocst abhiJItJrasad mnonet History MY Pictures m M My Dtcurnsnts SDctLI e tamushravan Flle llama 39I H ave I Saw as type Iword Document doc v Cancel My Hatwcnk PlaceS Paragraph Lists g Formatting Tools 9 Font LIndal me am Font galor mmmam Automatic Qndernne style none Effects l Strllgethrough l shadna Small caps F ooubl strikethraugh I gucnne I all caps l sugarscrlpt I Embo s l maiden suhscrip l Engrev Preview Time s New Roman This Is a TrueTvPe Forx This Font will be used on boKh printer and screen faul a Formatting Paragraph Left Alignment Right Alignment Center Alignment Justify LabRDt dot M croso Word Eile I Knew insert Fernat IODIS Tabe undow equot D nglg ln El ngsn za 23 4 an 1 1 km w h aha as nhamn m r an 1 nun u man ahgunhamwn o w a mum the amquot am hmmwwh g m mm mm um an n v 3 nhan t um o s V 7 I p Jonawvtecilnumshapesvx IZIO aging gtgt Page 1 Sec 1 1x1 At 11quot Ln 2 Col 45 REC TRI A dol M crosoft Word p gent glew Lnsert Fgrmat lacls Table Mndow uelp l algnvg5wo 13 2 45 n MW 3 Eu mm m L w may nhzmnh mwh on mun Inhm nan mud in nquot quotlama b a nhu unlemn umht aon w mfguwbht BELhen an 9 m m 1 m a kmnw n as nnhmh1 n nhnlmn x m nu ma macaw m an I swam in 5amp0le mum uhsmnh nwh an lmnmhm hamu mun us xpmm Lavan ml mhnmncm 39m 39mon huhnut awn norn Inch nann 111 an 1pm hum hm mm mm a ukmnwr n smonuanmnm nkmnh mvh onL39tuninhz Bhutan mud a mm m how nn emu mlhamnamn t i on w my um hh Huh nu am a but Lunar aha we a 11 39 wait 0 b JDLaW ngtoshapesv ICgt 4Q v Page 1 Sec 1 1 1 At 19quot Ln 6 col 46 F W A 7 Tables Insert Table button Draw a table Inserting rows and columns i Tables Table 9 Insert 9 Table Ali Table size gt Number oF golumns m Number of Lows 2 3 AutoFil behavior 3 Fixed column Moth I39m r Auto t to contents r AutoFil to window Table Format none utoFormat I 39 gel as default For new tables a Tables Add RowsColumn Table Table Table Table 9 9 9 9 Insert 9 Rows above Insert 9 Rows below Insert 9 Columns to right Insert 9 Columns to left Graphics Insert 9 Picture 9 From le Igtltl Templates v IG x a v Toe15v File mama L may v Files or bins Inquot Pictures emFwrnFjpgjpeg FlFJDEJDHQ v Cancel a Mathematical Equations eg f1 v p Ivdv Use Insert 9 symbol gymbcIs Spgcialcharacters nnt Isymbul vi Styles 7 Use Format 9 Style 9 New 3151 Styles Paragraph Drevlew 5 quot as mmL YEWquot n 72mm sL TEWM FLE Tzwmns TEX I S M us Team FLE Texr Character preview VERDANA DescrlDtIDn quot Normal Fan verdana 14 pt Bold All caps List Centered Space after 13 pl lUser deFinsd Styles vI grganizer I ew I geisha Came I Styles Use Format Style 9 New New Star e 3125 ame 5er type IMyHeadingl LI ased on i yle For Following paragraph I 11 Body Text 1 11 MyHeadingl P eview myb Inxl Scmjph 11mm 1n hm hm InmSmyh Inxt Emjph Inmgh maga Ianfamyh Inmmgh hm hm my my hm hm hm unsung 19mm Ihngamgih Inmn39h Inn Body Text I add to template I Agtarnatically update OK I Cancel I Fgrmat v I shortcut Eey I Creatlng Template Use Flle 9 New General Legal Pleadlngs Letters aFexes Memes l4 Select template other Documents lPubllcatlons Reports Web Pages Elegant R ilil Calendar CEIntel l IDEIrarV Wizard Resume esume Prevlaw Prefesslenal Resume Resume leard Click OK to install addltional templates and create a new File Create New P roument r Cancel I i Creating Template Eile gdit mew Lnssrt annet Inals Tgbls mnduw slp elmlgmsu v 23 5 BEIIEIltI I JDtawvGlAgtcshapes EIO dIgviva 3 rC 1259 1 Sen 1 11 At 17quot Ln 9 Col 1 TRK 56T F A a Creating Template Create your own template by inserting text box tables etc Make the format of this template similar to the requirement eg Lab reports Save it as template abcdot File 9New Select your template Modify and make the document a Spell and Grammar Check AutoCorrect Spelling and grammar check Synonyms Thesaurus i Spell and Grammar Check Use Tools 9 Spelling and grammar Spelling and Gran1n1ar English us 39 lil Not in Dictionary Demonstration for Eninee ng 1 1 1 fl Elnora I Ignore All I Ll add I J ghange I Change AH I v I AutoCoLrect I Suggestions l7 Chad 9 mmmm ar IQ gptions I Undo I Cancel I ummary a 5 MS word is a powerful word processor Documents which have tables images figures mathematical equations etc are made easily Inbuilt tools like Spell ana7 grammar Check Copy ana7 Paste makes the making of document very fast Summary If you are using other s work or result in your document it is must to mention the source or original author
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'