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