![]() Once you have set up your sheet, you can then go through your submissions selecting the responses for each question or feedback point that you wish to make. You can include a URL to screencasts that explain the answers or give more details to the response.Generate a list for each question or each feedback point that you want to make.Hold down the “alt” key to get the drop-down list to show, allowing you to use the cursor to select the response you want.Very handy for those 1 in 100 responses that don’t fit the rubric. If you copy data from a cell without validation and paste this to a cell with data validation, the validation is destroyed (or replaced). ![]() Data validation can be easily overridden.In effect, it generates a drop-down list of responses in a cell, from which you can select the one you want. Values can be hardcoded directly into the Settings tab or specified as a range on the worksheet (this works best as it’s more easily edited later). The one we are going to use is “ List”, where only values from a predefined list are allowed. When a data validation rule is created, there are eight options available to validate the data. (This link gives full details on how to use the validation tool) Using data validation to generate feedbackĭata validation is implemented via rules defined in Excel’s user interface on the Data tab of the ribbon. Later we will use a trick to extract the number from the start of the statement to generate a mark. Hence glucose can be “broken down” in glycolysis but not formed by gluconeogenesis. For example, the following statements can be added to a column in Excel:Ģ – Fantastic, FPBase represents a rate-limiting step in gluconeogenesis that is not involved in glycolysis.ġ – Nearly, FPBase is involved in gluconeogenesis and not glycolysis, but I also wanted you to note it was a rate-limiting set.Ġ – FPBase represents a rate-limiting step in gluconeogenesis that is not involved in glycolysis. Each cell in Excel can hold 32,767 characters so you have space to say what you want. These can be those statements that you always seem to write, common misconceptions or statements explaining why a question was answered correctly or not. You will need to download it from the Google Drive folder.įor each item of feedback, you can generate a list of comments in Excel using data validation. Here is the feedback generator file that is used in the walk-through. To build our feedback generator we are going to use Excel to define our responses.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |