Digital Media Commons (DMC) Workshop

Advanced Excel

This short workshop will cover techniques for using Excel productively. It will introduce you to functionality such as Advanced Formulas, Data Tables & Conditional Formatting, Charting, Pivot tables and Macros and VBA programming.  Use of these excel features will help you to analyze, visualize and gain insights from your data.

Introduction to Audacity

This hands-on workshop will cover the basics of using Audacity to record and edit audio. The workshop will cover the following topics:

  • Setting up a project and getting familiar with the interface
  • Importing audio files
  • Recording audio files
  • Using the editing tools
  • Using basic effects and corrections
  • Exporting a final audio file

Video Editing with Adobe Premiere Pro (Adobe Creative Cloud)

This hands-on workshop will cover the basics of using Adobe Premiere Pro CC to edit video. The workshop will cover the following topics:

  • Setting up a project and getting familiar with the interface
  • Importing and organizing media
  • Using the timeline editing tools
  • Adding transitions, graphics, text, and generated media
  • Using basic effects and color correction
  • Normalizing audio
  • Exporting a final product

Blender 3D basic animation and rendering

This short course covers basic animation in rendering in Blender. At the end of the course, participants should be able to do very basic keyframe animation and render out a scene. This course is intended to help students create graphics or video for their presentations. Topic covered in this short course are:

  • mixing and applying materials (shaders)
  • Setting the correct texture coordinates
  • very basic UV unwrapping 
  • setting keyframes
  • ​output the final video

Excel 101

 Introduction to using spreadsheets for beginners or a refresher for the sometime user. Covers basic features and options of Microsoft Excel, including how to organize and navigate tabular data, creating and using simple formulas, formatting worksheets and other helpful tips.

Introduction to Tableau 

Tableau is a fast rising and award-winning visualization software tool in Business Intelligence (BI) and Analytics Platforms.  It helps people see and understand data. In this short course, we will cover the following topics:

• What is Tableau?

• What can Tableau do?

• Why is Tableau so successful in BI in recent years?

The hands-on part will cover how to use Tableau Public, the free version of the software. Specifically, we will use a small set of DMC equipment circulation data as an example. We will cover: