Archive

Posts Tagged ‘excel-web-app’

Protected: Timesheets Pivot Table

2012/03/13 Enter your password to view comments.

This content is password protected. To view it please enter your password below:

How to make a tally on student staff performance

  1. We have a “Do’s and Don’ts” checklist for student workersas a Word web app
    1. easy to view/print for student staff,
    2. easy to update/print (and stash the work places with) for permanent staff – where each item has their point value.
  2. We have a tally of points earned (sorry, permanent staff only)  by temp staff member with date+time and explanation in Excel Web app which can be easily updated with observations by permanent staff when walking the LRC floor

Collaborative timeline activity for face-to-face classes on history

  1. An easily produced and repeated classroom activity, originally developed for listening comprehension and speaking practice in  language classes, based on filling out collaboratively a timeline spreadsheet in the digital audio lab:
    1. Listen and process/write:
      1. Advanced German class listens to segments of an authentic German cultural history documentary from the authentic German TV series “100 deutsche Jahre” (which follows a single topic throughout 20th century German history).
      2. And each student enters notable summaries of events with their time of occurrence into a spreadsheet
      3. that the teacher
      4. has at beginning of activity distributed to each individual student using the digital audio labs file management features
      5. and after listening collects from students, merges, either with student author data or an anonymous student identifier (for corrections), into an excel timeline spreadsheet
      6. and visualizes the collaborative outcome as an easily collated timeline on the projector to the entire class.
    2. Speaking: Discuss!
      1. Identify what are the gravity points for the comprehension of the video by the class: Why are these events deemed important?
      2. What are the outliers? Criticism? Justification?
      3. Also correct language errors in the  student output.
    3. nexus_timeline_excel_100_deutsche_jahre
      1. In early 2006, there was no Excel web app – collaboration likely has become simpler now
        1. launch link to publically editable spreadsheet to class
        2. visualize using excel web app charts