[DG: Teaching & Learning] Question - Anyone Tracking Faculty Activity in Courses?

[Pat Miller]

Hi, David,
I just read Gregory's response and he seems to have a nice automated
reporting system!

We have been querying a table into which our Sakai hosting partner
(Longsight) feeds activity from all sites-- kind of a data mart which was
built using SQL scripts originally used to extract the data from Sakai into
files.  Now having this table makes it much easier to get the data we need
for reports.  We don't have any contractual requirements like you do, but
find it helpful to give info to our LMS faculty guidance council so they
are aware of who of their colleagues are most active in Sakai.  It helps
the LMS team to also see which tools are not being used so we can target
training opportunities.  We also use it to find faculty exemplars to
present at monthly faculty lunch'n' learns on how they use various Sakai or
3rd party tools.

We use Tableau to query this table to get both student activity and faculty
activity.   We can see activity on all Sakai tools and for all course
sites.  For LTI tools we can see the launch but, of course, since the
actual activity is held by the tool site, we can't see the detailed
activity.

We link the ID of the instructors with our Banner system to find out which
departments they are from but this currently is not an automated process.
So we take the Tableau data summaries and import into Oracle to then link
with Banner and come up with reports by College, department, etc.

I imagine the Sakai queries we are using are probably similar to the ones
Gregory is using.  It would be good to find out how they compare!

Any of you going to the Aperio Conference?  I am presenting about what we
do to get our reports.  But I was thinking of the session as a good chance
to share ideas.

Pat
University of Notre Dame



On Tue, Mar 31, 2015 at 3:50 PM, David Eveland <DEveland at johnsonu.edu>
wrote:

>  All,
>
>
>
> Sorry if this isn’t the right context for this.
>
>
>
> We’re presently looking to gather some data on the level and kind of
> involvement our faculty have in their online courses, and are familiar with
> the Statistics tool in Sakai to gather just this type of information.
>
>
>
> However, we’re also looking at being able to provide a more responsive
> engagement with faculty – if for example they’re not remaining engaged or
> active in their online courses (as our contract spells out).  One way to
> check for this is to use the Statistics tool in every course an instructor
> is teaching in in the current term, and then relay that information to that
> faculty member’s respective dean or school.
>
>
>
> Another way would be to have a service that simply looks into the current
> term’s courses for just this sort of data and notifies those deans
> accordingly if (say) the instructor hasn’t engaged with a particular course
> for more than 4 days.
>
>
>
> Any thoughts are helpful.
>
>  <http://www.johnsonu.edu/>*—*
> * Dave E. **| *Johnson University
> *865.251.2320 <865.251.2320>*
> *--- End of Message ---*
>
>
>
> _______________________________________________
> pedagogy mailing list
> pedagogy at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/pedagogy
>
> TO UNSUBSCRIBE: send email to pedagogy-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/pedagogy/attachments/20150331/ae337695/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 1857 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/pedagogy/attachments/20150331/ae337695/attachment.png