A couple of people have said, they are happy (ish) with the flipped classroom for excel skills, but what do you actually ask (within the quiz) and how long does the assessment take?
Given the task is a skills development session to ensure they can perform some introductory tasks in Excel. The quiz questions include;
Three objective questions – auto marked (based on the calculated descriptive statistics)
- Calculated Numeric Question: To two decimal places, what is the mean value for Experiment B?
- Calculated Numeric Question: To two decimal places, what is the standard deviation in Experiment C?
- Calculated Numeric Question: To two decimal places, what is the range in Experiment B?
Two subjective questions (based on plots)
- The standard deviation in Experiment C is greater than in Experiment B, what does this mean in plain English?
- What can you infer from the scatter about the relationship between the temperature and gas Z emissions?
Upload their spreadsheet
- Quick visual check
This works very well. To speed up the checking process for the file upload and the two subjective questions, I use a very simple rubric (marking criteria) within Blackboard. The student can access this rubric before they submit. The idea is not too make this complicated, the broad intended learning outcomes are; 1) ensure they can calculate descriptive statistics, create a bar chart, create a scatterplot with trend line and r2 coefficient 2) ensure they know where to find online help.
Therefore, the marking criteria (rubric) allows me to click the grade classification, and reflect they technical competencies. For instance, the rubric for he file upload is …
Part A: Scatterplot:
- 20 points – scatter plot is included, for two experiments on one plot, they have included the trend lines, the labels / titles are included
- 15 points (minimum pass for question) – scatter plot is included, for two experiments on one plot, but no trend line, however, labels and titles are included
- 0 points (need to attend workshop) – no plot, or wrong plot or not including two experiments, axis not labelled.
Part B Bar Chart:
- 20 points – bar chart is included, for all three experiments on one plot, they have included the labels / titles are included
- 15 points (minimum pass for question) -bar chart is included, but not all three data sets are included, however, labels and titles are included
- 0 points (need to attend workshop) – no bar chart, wrong plot or axis not labelled.
Using the Blackboard Rubric within the Quiz (test) this means the subjective questions can be marked quickly. I’d suggest, marking the assignment for one person (including all the feedback) takes about 1 minute.