Spring 2012 Instructional Technology Workshops for Faculty

Location for all workshops: Room 111 ALF (the lab off 107 ALF)

Coordinator: Sheila Booth
sbooth@qcc.mass.edu   508 854-7456

 Workshop

 Topics

Date

 Time

• Setting up columns
• The SUM and AVERAGE formulas
• Changing grade values (percentages)
• Grading discussions
• Column for converting final average to a letter grade

• The Portal interface:
  Tabs, Sidebar, Quick Links  
• Adding handouts and bookmarks or web links
• Adding course information

Excel for Grading

• Sample gradebook
• Sample gradebook 2
  (drops lowest quiz)

• Simplest formulas for averaging and customizing course grades
• accessing class lists from The Q or QCCNet

Web Authoring with Expression Web

• Guide to Expression Web
• Simple Template
• Template with Image

• Site purpose and audience
• Software interface
• Entering text
• Creating links
• Using tables for layout
• Uploading files

Assessment in Blackboard/Vista

To participate you must be teaching a course with Blackboard or have completed QCC's Sandbox training.

• Types of assessments
• question bank
• scoring
• displaying in grade book

• Best Practices: Creating a Clean Interface
• FAQ for online discussion (PDF)
• FAQ for class email--with email forwarding (PDF)
• Tracking Reports and What They Record