Online Lab Submission
Submitting Lab Data
Student lab data (mass, volume, temperature, pressure, concentration, pH, time and absorbance readings) is entered according to YOUR preference as follows. . . .
- all lab data is entered at the top of the lab report and "redisplayed" throughout the lab report as needed so students do not have to scroll to the top of the webpage to see their data. This appoach is used when students enter their data during lab as it is collected . . . . the Instructor can quickly "see" the progress of the class by clicking the "lab data report" link.
- lab data is entered at various stages during lab submission, usually in the order it was collected in lab, but interspersed with calculations, essays, balanced equations, etc.
The image to the right shows "grouped" lab data entered at the top of the lab report.
Note the following . . . .
a. the lab guide (digital or pdf) is readily accessible to the student from the link at the top of the webpage.
b. incorrectly entered lab data is easily modified without requiring the attention (or time) of the Instructor / TA. Note that a link on the TA / Instructor side displays a list of the students that reset their lab data in case further investigation is needed.
c. navigational instructions help students on the first few labs.
d. the Submit Data button (right side panel) saves the lab data to the database.
e. lab data can be "checked" against expected ranges to prevent typos. For example, if the procedure calls for ~ 2 g NaOH the expected range could be set at 1 - 3 g . . . . if the actual mass is 1.987 g and the students accidently enters 19.87 g the expected range code will trigger a message in the Side Panel so the student can fix the issue without having to reset their lab data.
f. lab data can be "checked" against expected decimal places to help students remember to report trailing zeros. For example, if the procedure calls for ~ 2 g NaOH to be weighed on a mg balance, the expected number of decimal places could be set at 3 . . . . if the actual mass is 1.980 g and the students accidently enters 1.98 g the expected decimal place code will trigger a message in the Side Panel.
In both e and f, the message in the Side Panel tells the student to "double-check" the data in question, but they are instructed to report the data exactly as they recorded it during lab .
A data array (i.e. pooled class data) is entered in a text box similar to the data entry above. Once entered, the Chem21Labs program can calculate the MEAN, MIN, MAX, and STDEV of the array to grade the student's entered value.
For labs that use instruments (pH meter, UV-Vis spectrometer, Temperature probe, etc.) to collect a group of data points, students can copy / paste these x,y values into a rectangular text box where the Chem21Labs program parses and saves the values in the database. The image to the right shows the text box where a student entered pH data collected during the standardization of a NaOH solution.
In most labs, a graph of this data is displayed on the webpage as a pH curve, absorption spectrum or temperature curve. In the image shown below, the student's pH data (entered above) is displayed as an interactive graph on the webpage. Clicking the 1st or 2nd Derivative button at the top of the graph will re-plot the pH data. In addition, x,y coordinates appear in a tooltip when students mouse over the graph. Finally, students can draw lines on the graph to help them determine the pH at the equivalence point.