New version page

UCM CHEM 010-01 - Intro To Measurements

Upgrade to remove ads
Upgrade to remove ads
Unformatted text preview:

Par t%1Length Width He ightSubstance cm cm cm1 4.08cm 1.30cm 3.18cm2 5.07cm 3.19cm 3.19cm3 4.08cm 1.28cm 3.18cmPar t%2Measurement Measured0Mass Liquid0Mass# (Add&Unit) (Add&Unit)1 96.4g2 124.1g 27.7g3 141.3g 44.9g4 161.4g 65.0g5 182.1g 85.7g6 205.0g 108.6g7 217.7g 121.3g*The31st3row 3is3included3to3help3y ou3r ecord3the3mass3of3the3graduated3cylinder 3(so3you3can3find3the3mass3of3the3liquid3in3the3cylinder ).Prepare0your0graph0to0find0the0equation0of0the0line0(and0the0density0of 0the0liquid!).Data0P oint x y1 22.0 27.72 36.0 44.93 51.8 65.04 68.0 85.75 86.0 108.66 96.0 121.3Par t%3Graphing%Volume%and%Mass%to%Determine%Densit y%through%Dimensional%AnalysisMake%sure%to%scroll%all%the%way%down…Ple ase&recor d&your&measurem ents&in&this&table.&&You&will&n eed&t o&use&a&formula&in&t he&colum n&Li qu i d&Mass&to&subtract&the&mass&of&the&graduated&cylinder&from&subsequent&mass&measurements.Select& the&corre ct&cells&from&th e&table&ab ove&to&p repa re &your&x&and &y&value s&for&your&&grap h.&&Remember,&th e&independent&variable&(what&we&control)&is&x&and&the&dependent&variable&(what&we&measure&after&each&change)&is&y.Note:3Excel3likes3to3have3x- values 3on3the3left3and3y-values3on3the3right.33From3t he3videos,3it's3easier3(in3my 3opinion)3t o3measure3mass3f irst,3so3it's3 writte n3on3the 3 le f t3in3the 3table 3above. 33This3is3our3de pende nt3variable,3however,3 so3it3 should3be 3our3y-value3(and3on3the3right3to3make3Excel3happy).33Use3the3table3below 3to3rearrange3t he3data3int o3the3for mat3Excel3r equires3to3produce3a3graph.3(25points)Measuring%Length%(width%and%height)%to%find%V olumeOnly%on%Pivot%Interactives%-%Nothing%to%Do%in%ExcelPlace0your0Graph0in0the0outlined0region0below.Make%sure%to%scroll%all%the%way%down…y = 1.2679x - 0.49930204060801001201400.0 20.0 40.0Liquid Mass (g)Volume vs. Mass of an Unknown LiquidVolumecm^316.9cm^351.6cm^316.6cm^3Volume(Add&Unit)22.0mL36.0mL51.8mL68.0mL86.0mL96.0mL*The31st3r ow3is3included3to3help3y ou3record3the3mass3of3the3gr aduated3cylinder3(so3you3can3find3the3mass3of3the3liquid3in3the3cylinder).Prepare0your0graph0to0find0the0equation0of0the0line0(and0the0density0of 0the0liquid!).Graphing%Volume%and%Mass%to%Determine%Densit y%through%Dimensional%AnalysisCreate0your0Graph:Once3you3have3 your3x3 a nd3 y3values3 ta bula ted,3select3the3 numbers3in3the3 table3(the3 rang e 3C35:D 40)3by3left-clicking3and3dragging3t he3mouse.33Then,3click3the3Insert3tab3fr om3t he3top3of3the3Excel3window.33We3will3insert3a3graph3(calle d 3a3chartt3by3Excel) .33In3science,3we3almost3alwa ys3us3XY3scatter3plots3-3this3is3the3Chart3option3that3 looks3 like3se veral3unconnected3dots.3 3 Se lect3this3 icon3 to3crea te3your3graph.3 3(25points)Ple ase&recor d&your&measurem ents&in&this&table.&&You&will&n eed&t o&use&a&formula&in&t he&colum n&Li qu i d&Mass&to&subtract&the&mass&of&the&graduated&cylinder&from&subsequent&mass&measurements.Recor d3the3initial3mass 3and3the3mass 3aft er3each3addition3of3liquid3in3t his3column3(25points)Calcula te 3 the3 ma ss3 of3liquid3in3the3 g raduated3 cylinder3for3e a ch3 a ddition3 of3liquid.33Use3 a n3 a bsolute3ref e rence 3 (with3$)3to3write 3 a 3general3formula3that3can3be3typed3in3cell3D183,3then3copied3and3pasted3down3the3column3to3automatically3calculate3all3of3the3adjusted3masses.3(The3gradua ted3cylinde r3 ma ss3should3be3recorded3 in3 cell3B173 -3to3ma ke3 this3an3absolute3 re f erence,3it3 is3modif ie d3 to3$B$17)3(25points)Recor d3the3volumes3of3liquid3measur ed3with3the3graduated3cy linder 3fr om3t he3video.33Make3sure3t o3use3appropriate3sig3figs!3(25points)Select& the&corre ct&cells&from&th e&table&ab ove&to&p repa re &your&x&and &y&value s&for&your&&grap h.&&Remember,&th e&independent&variable&(what&we&control)&is&x&and&the&dependent&variable&(what&we&measure&after&each&change)&is&y.Note:3Excel3likes3to3have3x- values 3on3the3left3and3y-values3on3the3right.33From3t he3videos,3it's3easier3(in3my 3opinion)3t o3measure3mass3f irst,3so3it's3 writte n3on3the 3 le f t3in3the 3table 3above. 33This3is3our3de pende nt3variable,3however,3 so3it3 should3be 3our3y-value3(and3on3the3right3to3make3Excel3happy).33Use3the3table3below 3to3rearrange3the3data3into3t he3for mat3Excel3r equires3to3produce3a3graph.3(25points)Measuring%Length%(width%and%height)%to%find%V olumeIndicate3the3units3for3each3measurement.33Note3that313liter3is3equal3to313dm³3and313mL3is3equal3to313cm³.3(25points)Use 3the3Rule r3tool3with3the3videos3from3Pivot3Inte ra ctives3to3make3 measurem ents3of3 substa nces31-3.33The3first3column3should3 be 3the3distance3mesaur ed3left- to-right3w hen3the3v ideos3star t,3the3second3column3should3be3the3distance3measured3left-to-r ight3after3the3blocks3ar e3turned3(at3the3end3of3the3v ideo).33Height,3the3third3column,3should3be3measured3top-to-bottom3on3the3v ideo.3(35points)Calcula te 3 the3 volume 3 f or3e a ch3 recta ng ular3solid3 from3 the3 33 individual3me a surements.3 3 Use3Exce l3to3 do3the3ma th3 -3type3 a n3 =3sig n3 to3 te ll3Excel3you3want3to3add3a3formula,3then3click3on3the3 cell3that3has3the3value3for3length.33Excel3 uses3*3to3indicate3multiplication3and3/3to3indicate3division3(see3Ca n vas3guide3to3Excel3for3description).33If3you3type3*3after3you3click3on3the3first3cell,3you3can3click3to3select3the3number3to3be 3multiplie d. 33By3adding 3the 3math3 f unctions3 (+, -,*,/)3and3 using 3the 3mouse3to3select3cells3containing 3your3measurements,3you3can3quickly3do3your3calculations3from3lab3by3making3Excel3do3the3work3for3you.3(25points)Only%on%Pivot%Interactives%-%Nothing%to%Do%in%ExcelCreate0your0Graph:Once3you3have3 your3x3 a nd3 y3values3 ta bula ted,3select3the3 numbers3in3the3 table3(the3 rang e 3C35:D 40)3by3left-clicking3and3dragging3t he3mouse.33Then,3click3the3Insert3tab3fr om3t he3top3of3the3Excel3window.33We3will3insert3a3graph3(calle d 3a3chartt3by3Excel) .33In3science,3we3almost3alwa ys3us3XY3scatter3plots3-3this3is3the3Chart3option3that3 looks3 like3se veral3unconnected3dots.3 3 Se lect3this3 icon3 to3crea te3your3graph.3 3(25points)Place0your0Graph0in0the0outlined0region0below.Formatting0your0Chart0(30points):You r& graph & should& h ave&labeled&x&and & y&axes,& as&well&as&a& main&ti tle&at&the&top.&&It&is&commo n&prac tice&to&label&graphs &in&the&format&"y&vs.&x"&where&y&is&the&dependent&variable&of&the&experiment&an d&x & is&the& ind ep en dent&variab le&of&th e&experiment.& & The&general&name& (like&mass&or&volume) & is&typic ally&us ed&for&both&the&chart&titl e&and&axis&titl


View Full Document
Download Intro To Measurements
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Intro To Measurements and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Intro To Measurements 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?