One of the newer features within Moodle is the availability of completion status. As an instructor, you can turn this on (as long as it has been enabled at the server level) and then use it to help students "track" which items they have completed within your course. Advantages of this feature: There are several advantages:
If you do not use the gradebook, it gives an alternative way for students to track their progress
It is flexible by activity so you can set completion "standards" such as a grade or action, or even set it so students can mark it themselves
It can be used in conjunction with contingencies, so activities can be dependent on each other (students have to complete one activity to see or do another)
Disadvantages of the feature: There are a couple drawbacks to using this feature as well:
While a default can be set within your course, if you set parameters for completion it has to be set on each activity
It has to be enabled at the server level
To see if you have completion status available as a choice within your courses, go to your Administration block and under Course Administration select Edit Settings. You will have an area for Completion Tracking if it is turned on at the server level. If you have the choice, setting it to No will hide this option for each activity. Setting it to Yes will display an additional area of information for each activity:
Here are the choices you can set for the activity:
Here are the standards you can set it to - be warned! The more you check, the more you can slow down your course. It is best to only pick one...two at the most!
Again, note that these change depending on the activity. So in a forum you will have a choice about posting responses to the forum. And with an assignment you will have a choice about when the assignment is graded and another about when the assignment is submitted.
A very cool feature, just use it with caution as you are starting out as you may inadvertently get some unexpected results!
(Updated on 3/21/2017 - triggers have been moved!)
I guess it was only a matter of time before I ended up dabbling with Google Scripts. Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data. Not finding an add-on for this (why recreate the wheel? :-) I explored creating a script. And...discovered that this task is not too hard!
To do this yourself -
1. Create your form.
Really important step. Make sure to create your drop-down item and give it a title, but you do not need to add any options to it (because later you will populate it from the spreadsheet).
2. Create the spreadsheet where your list will reside.
You have two options for this.
A: You can create the spreadsheet for your form responses and add a second sheet to it. That is what I did here - adding a sheet called Student Names:
B: You can create a new spreadsheet to use. If you do this you will need to add the sp…
Let's say you have put together a sheet with information you THINK is how you want it. And after using it for awhile, you realize you REALLY want the columns and rows switched. Can you easily remedy this without re-entering all the data? The answer is yes!
Before walking through how to easily do this, let me introduce you to a Google Sheets formula you may not know - it's called TRANSPOSE and it's purpose is to transpose the rows and columns in an array or range. So, here is some data I have in cells A1-E2:
If I want to flip the columns and rows, I add the formula:
in the cell I want to start the transposed information into. And...viola! My data is flipped:
It needs to be noted that you CANNOT change data in the transposed cells. As soon as you try to change the data in the transposed area you will get a REF! error because you have data in a cell it need to do the transposing. The data is dynamic - if you change your original data set it will c…
If you are looking at the summary view of the results for some Form data you have collected, you can copy a chart or diagram that you want to use elsewhere very easily and quickly.
Simply hover over the chart or diagram, and a copy icon will appear in the upper right corner of it. Click on that -
You will get a message that it has been copied to to the clipboard in the lower left corner -
You can then paste it into the location you want to use it. Here's an example in a G Doc -
I also pasted it into: Slides, an email, a Sites webpage, in my Blogger. A nice feature addition that saves time from taking screenshots!
2. Login with the account you used previously to register for the conference. You must use the same account!
3. Note a new window at the top will tell you that you are already registered for the conference, but you may add workshops (pre-conference sessions) by going through the process again. (You would use these same steps to make any modifications to your registration.)
4. Click Next on the first screen with your contact information
5. Click Next on the next screen about Membership
6. On the next screen, pre-conference workshops are now an option
7. When you click on the blue bar, it will display the pre-conference sessions. Each one has the following: Registration box for that workshopName of the workshop sessionSponsoring SIGCost (1/2 day sessions are $70, full day sessions a…
Another foray into creating a script to help make a process more efficient.
We had a program that spent a LOT of time with the invoicing process. They were hoping that they could use a Google form to gather information for invoices, then use the Add-on Autocrat to create the invoice which could then be shared with appropriate parties.
The problem was that each invoice needed to be assigned a unique number. Enter a script to add to the spreadsheet. After creating it, I realized that this simple script could be used in a variety of ways so thought I'd share (I've already used it for two other applications!).
1. Create your form to collect the data (not covering this here - I am assuming you know how to create a Google Form)
2. In the result page, select to create spreadsheet so you can view the data in a spreadsheet
3. Go to the Tools Menu and open the Script editor
4. Delete out the default text
Replace with this script (all in highlighted gray including the final curly bra…