Beverage Density Lab: Sugar Content Analysis
E-10 Name: Beverage Density Lab
Data Table:
|Known |Mass |
|Samples |(data) |
|Heading (Title, name, date) | |
|All 4 prelab questions answered correctly in full sentences restating ? | |
|Purposes | |
|Procedure (clear, but not word-for-word) | |
|Data & Calculations (30 total) |--------------------- |
|All data & calculations have units labeled, are complete & logical | |
|All data & calculations are reported with correct significant figures | |
|Graph & Analysis (25 total) |--------------------- |
|Axes and units are labeled | |
|Title box is present (y vs x) | |
|Scales are logical, graph is FULL page size | |
|Data points are correctly plotted, with error circles. | |
|Intersections of known % sugars & each beverage are circled & labeled. | |
|#3 is answered on worksheet. | |
|#4 is answered on data table AND completed on worksheet. | |
|Questions (10 total) |--------------------- |
|All answers are correct. | |
|All parts of each question are answered. | |
|Conclusion (20 total) |---------------------- |
|The conclusion | |
|is in complete sentences. | |
|avoids personal pronouns (I, you, we, me, etc.) | |
|Addresses ALL of the purposes | |
|Tell me what the correct formula for DENSITY is. | |
|Explain how you constructed a calibration curve (refer to graph). What data went into it? Include RESULTS to support| |
|statements. | |
|Explain HOW you used the calibration curve to determine the % sugar in the 5 beverages. Include results to support | |
|statements. | |
|Tell me two things that would have been experimental errors and how they each would have affected results. (2 SOURCES| |
|OF ERROR) | |
|Mind Prober (10 total) | |
|BOTH are answered thoughtfully on the worksheet. | |
Total Points earned above: _________ / 100
Standard penalties
Lab not in ink (& no red pen) - 10 _____
Lab not on graph paper - 10 _____
(except for typed/printed portions)
Lab LATE (due end of class Mon 10/3 -20 per day _____
Messy/ disorganized up to -10pts _____
No prelab stamp - 5 _____
How to make a graph using Excel
1. Open Excel.
2. Click on “Excel workbook” icon.
3. In cell “A1” type “mass percent”.
4. Starting in cell “A2” and moving downward, enter in the data for the independent variable (0, 5, 10, 15, & 20%).
5. In cell “B1” type “density”.
6. Starting in cell “B2” and moving downward, enter in the data for the dependent variable (density for the 5 sugar solutions in this lab).
7. Click and drag to highlight all data.
8. Next, click on the Chart Wizard Icon.
9. When step 1 “Chart Type” box appears, choose “XY Scatter” graph. Hit “enter”.
10. The graph should appear as step 2. Hit “enter” again.
11. When step 3 “Chart Options” appears, type in your name as the title, then hit “tab” key and type in the name of the independent variable (% sugar), then hit the “tab” key again and type the name of the dependent variable (density – g/mL).
12. Click on the “finish” icon.
At this point the graph should appear on the same “page” as your data.
13. Click on the word “Chart” at the top of the screen and highlight “add trendline”.
14. Choose “linear” when the menu box appears.
15. Click on the “options” tab. Click on the boxes for “display equation on chart” and “display R-squared value on chart”. Hit the “enter” key.
At this point the graph should re-appear on the same “page” as your data.
16. After your teacher checks your graph, then you can “print” a copy. Then continue on #2 of the analysis for the lab.
-----------------------
OVERALL GRADE:
__________ /100
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- starbucks beverage recipe cards
- starbucks handcrafted espresso beverage list
- starbucks handcrafted beverage list
- healthy beverage recipe
- starbucks beverage manual
- sugar density lab
- density of sugar water
- sugar density chart
- agricultural density vs physiological density of nigeria
- skull analysis lab report
- is sugar cane sugar healthy
- qualitative analysis lab report