Beverage Density Lab - explantion of its elements.

Post by: Kevin G
Wednesday, September 11, 2013

On Labs
- NEAT (for effective communication)
- CAN typed, written, or a combination.
- Post lab questions should be both concise and thorough.
  (1-2 thorough sentences is sufficient, but can be longer if it
   is necessary to fully answer question)
- Avoid long, rambling, repetitive answers
- For conclusion and post-lab questions, say 'Data shows...' or 'It appears that...'





Specifics of Beverage Density Lab

***N.B.    DO NOT DO POST LAB QUESTION #5***


 Regarding post lab Question #3

Apple Juice	Berry Juice	Cranberry Juice	Gatorade
28g sugar	28g sugar	32g sugar	21g sugar
240 mL drink	240 mL drink	240 mL drink	355 mL drink

 
% Sugar concentration  =  g sugar    X    100
                                           g drink     

Use dimensional analysis:

e.g.  49 g sugar        X      1 mL drink       =    .13g sugar   X  100  =  13% sugar
      355 mL drink              1.043g drink            1 g drink          

The 'mL drink' cancels out, leaving 'g sugar' on top, and 'g drink' on bottom
(which is the sugar  concentration)


Include in lab write up:

Title         -e.g. Beverage density lab

Purpose   -(can be word for word from lab directions)

Data        -Table format for hard data
                -Section to show calculation (i.e. for density of each solution)
                                                              (Label what calculation is finding)
 
Post-lab question   - #1-4 for Beverage Density Lab. Remain as concise as
                                 possible while still giving a complete answer.
                                (1-2 sentences or more if it is necessary to question)
                              - Reference the data, DO NOT re-write the data
                              - BUT if question directly asks for calculation,
                                the calculations may be done in the question

Conclusion      - Consists of three paragraphs focusing on the claim, evidence, and reasoning.

                                               Claim - answer the question of the lab (Purpose)
                                                          - For beverage density lab that means
                                    'What percent of sugar is in the two chosen beverages?'

                                           Evidence - Cite data and calculations you did to
                                                             decide on your claim.

                                         Reasoning - Validity of report
                                                           - What error happened,
                                                           - Why/how did the error happen
                                                           - How the errors effect the calculations
                                                              and validity of report



Graphing using Google Drive(Post lab Question #1)
1) Go to your Google 'Drive'
2) Click on 'Create' then click on 'spreadsheet'
3) Go down to spreadsheet and type something like this:
KEEP solution concentration on right (will be x axis) and density on left (y axis)
     
 N.B. Do not include the unit, as shown in 2nd, 3rd, 4th, 5th, and 6th rows

solution concentration %	calculated density g/mL
0	.123
5	.234
10	.456
15	.567
20	1.234

4) Highlight the 12 boxes (all the boxes you typed) and, while highlighted, click on 'insert' tab
       a) scroll down to 'chart'
       b)in the 'chart editor' move to 'chart' tab
       c) choose 'scatter chart'   
       d) of the two charts, choose the first scatter chart with small bubbles
       e) click the blue 'insert' at bottom of the box and the chart will appear


Chart Modification
The chart can be modified several ways. General way is

1) click on downward arrow in top right corner of the chart
2) go to 'advanced edit' to change content and look of the chart

or specifically...

Modifying the number on axis
Click on the numbers on the axis and you can change the minimum and maximum, to make the numbers more compact so it is easier to see where your data is on the graph. (e.g. min/max of 0 to 100000 would be hard to see where your data lies, but min/max of .93 to 1.15 will make it a lot easier to see where your numbers lie)


Modifying the axis names
1) right click on the whole image
2) scroll down to axis
3) click on 'horizontal axis title' or  left vertical axis title' to change the names of the x and y axis respectively

Moving Graph to MICROSOFT WORD DOCUMENT
There may be other ways, but what I did was
1)  hit 'print screen'
2) paste in word doc
3) 'crop' to size
(The resolution is very clear)

now, how its moved to the google drive doc, I haven't the faintest idea



and the next scribe is....
drumroll please.....
Kevin Mihelic