Category Archives: Workshops

Excel Learning Series – Spring 2016

Are you looking to improve your Excel skills? Does the phrase Microsoft Excel make you nervous? Fear not friends, META LAB and the DLC are collaborating once again to provide a series of Excel workshops to support the MIIS community. The sessions will take place in CF442, Pac Lab from 11-12. All you need to bring is yourself! Your facilitator will be META Lab GA and Data Analysis Teaching Assistant: Mentru Nagbe. When used properly, Microsoft Excel can be an extremely powerful tool to display, organize, and analyze large data sets. The series will contain hidden tips and tricks in addition to exercises that will make you an Excel champion in no time.

Schedule

  • Session 1: February 19, 11-12
  • Session 2: February 26, 11-12
  • Session 3: March 11, 11-12
  • Session 4: March 18, 11-12
  • Session 5: April 1, 11-12 

Sign Up

excel-signup-buttonTo get access to the learning series materials and receive information on future sessions, click the sign up button!

Curriculum

Session 5

  • Linking functions, equations, and graphs
  • Creating custom budgets from scratch
  • Series review

Session 4

  • More pivot tables
  • Working in multiple workbooks
  • Linking workbooks and formulas
  • Uploading untidy data
  • In-depth V-lookup
  • Financial functions

Session 3

  • How to create a charts (All Types)
  • Other chart types, mixed income as line, expenses and
  • savings as stacked column
  • Altering parts of a chart
  • SPARKLINES
  • Freeze panes
  • Splits
  • Outlining
  • Some more useful functions
  • Pivot Table (time permitting)

Session 2

  • Formatting Cells
  • Tabs (part 2)
  • Row Height and Columns Width
  • Alignments
  • Text Wrap
  • Borders
  • Numerical Formatting
    • Dates
    • Time
  • Format
  • Conditional Formatting
  • Tables
  • Hidden Function
  • Print Preview tab
  • Previewing Page Breaks
  • Page Set up and printing screen

Session 1

  • Cursor
  • Cells
  • Formula bar
  • Tabs
  • Worksheets
  • Templates
  • Fonts
  • Copy and paste
  • Wrap text
  • Minitoolbar
  • Quick Access Tool Bar-
  • Status Bar
  • Entering data
    • Autofill
    • Undo/redo
    • Comments
    • Save
  • Formulas
    • Writing formulas
    • Copying formulas
    • $$$$$$

Resources

Lynda LogoLynda.com is an incredible online resource offering guided video tutorials and step by step instructions for all sorts of digital tools. As a member of the Middlebury community you have premium access. Here’s how it works:

  • Visit go.miis.edu/lynda
  • Input your MIIS login credentials
  • Search “Excel Essential Learning”

Domain of One’s Own Open House

With a domain of your own, you can explore the creation and development of your digital identity in whatever way you choose. This year we are exploring how this environment can be used to share, collaborate on, and discuss our academic and professional work across Middlebury and beyond!

We are excited to let you know that Middlebury’s version of “Domain of One’s Own”—called “MiddCreate”—has been launched, and we are holding an open house so you can learn more!

At the open house you will learn more about the possibilities of having your own domain, see examples of how people have already been using MiddCreate, as well as look at samples from other schools’ Domain of One’s Own projects.

The Open House will be held in the Digital Learning Commons at MIIS, on Tuesday, February 9, from 2:00-3:00 PST​, while Amy Collier, the Associate Provost for Digital Learning, is visiting Monterey. Additionally, Adam Croom, the Director of Digital Learning at the University of Oklahoma, will be with us virtually to share some stories of how OU is successfully using Domain of One’s Own.

Email Evelyn Helminen (ehelminen@miis.edu) or Amy Collier (acollier@middlebury.edu) for more information.

Domain of One’s Own is an initiative of the Associate Provost for Digital Learning, in collaboration with the DLC.

WordPress Workshop J-term 2016

Hey new IEMers, need to submit your eportfolio url? Bring your laptops and come to one of our WordPress workshops in the DLC! We’ll help you create your site, set up your menu, add content, and more! The three sessions will cover the same content – seating is first come first serve.

Topics

  • create your url + site title
  • set your theme
  • create pages
  • add text + media
  • customize your menu

Links

Google introduced a new logo September 1, 2015. The new, simplified, logo will appear on all Google platforms, including the mic which will help users identify and interact with Google whether talking, tapping or typing.

Make an Appointment

If none of these times work for you, you’re using a different platform, or you have follow up questions, you can always make an appointment with us through our website: https://sites.middlebury.edu/dlc/appointment-request/

Resources

Lynda.com is an incredible online resource offering guided video tutorials and step by step instructions for all sorts of digital tools. As a member of the Middlebury community you have premium access. Here’s how it works:Lynda Logo

  • Visit go.miis.edu/lynda
  • Input your MIIS login credentials
  • Search: WordPress Essential Training

Alternative Platforms

  • Wix
  • Weebly
  • Middcreate

 

Roundtable on Multidisciplinary Learning

Have you participated in the on-campus Hult Prize competition? Do you want to submit a proposal to the Davis Projects for Peace?  Are you looking for faculty guidance on an immersive learning experience or other independent project, such as capstone or a directed study?

The DLC is involved in a collaborative effort between faculty, staff, and students to explore how multidisciplinary learning can be promoted on campus through campus-wide challenges, competitions, and other activities that stretch beyond classroom walls.

Come share your experiences or learn from other students, and influence how MIIS prepares students to address the complex issues we encounter on and off campus.

Story+Maps Brown Bag Lunch Nov 10

What: Story+Maps Brown Bag Lunch
When: Tuesday, November 10 | 12:15pm-1:30pm
Where: DLC Design Sp@ce

Join Institute alumni Andy Stieglitz and Aaron Ebner, founders of the Andean Alliance for Sustainable Development (AASD) in Peru, for a brown bag lunch focusing on using new media approaches to communicating the reach of organizations. The informal event is a space to share ideas and examples of how different mapping tools can be partnered with stories to convey impact. AASD will share the ArcGIS Story Map of their work, the Center for Social Impact Learning (CSIL) will walk us through their Ambassador Corps map created with help from the META Lab, and Intercultural Digital Storytelling Project (IDSP) Senior Fellows along with other immersive learning teams working on J-term project plans will brainstorm how maps might be used to help visualize their work in the field. We hope you’ll join us!

This event is a collaboration between the DLC, CSIL, and the META lab!

MORE MAPPING GOODNESS: Friday November 13 | 12-1pm
Follow-up with the META Lab team to learn more about working with open source mapping tools on Friday, November 13 from 12-1pm in the Pac Lab. Workshop Details here.

Mac OS X Workshop II

Hey Mac owners! Thanks for making the first Max OS X Workshop a great success! We had a great turn out, but if you weren’t able to make the first session, fear not! We’ve already got another one scheduled to address some of the more popular (yet sometimes frustrating) features that Max OS X has to offer. Come discover how to maximize your productivity, and work smarter, not harder!

Topics to be covered include: Creating different iPhoto Libraries and Using time machine and iCloud to back up your files.

The workshop is optimized for any version of Mac OS X you have running (Snow Leopard, Yosemite, etc.) and you didn’t need to attend the first workshop to attend this one!

Here are the Deets

What: Mac OS X Workshop II
When: Wednesday, October 28th, 11:00am-noon
Where: in the DLC Design Space
Topics Covered: creating iPhoto libraries, using iCloud, and using Time Machine

Fall 2015 Excel Learning Series – Session 4

Are you looking to improve your Excel skills? Does the phrase Microsoft Excel make you nervous? Fear not friends, META LAB and the DLC are collaborating once again to provide a series of Excel workshops during the first half of the Fall 2015 term to support the MIIS community. The final session will take place on October 23rd, 12pm- 12:45pm in CF442, Pac Lab. All you need to bring is yourself! Your facilitator will be META Lab graduate assistant and Data Analysis Teaching Assistant: Mentru Nagbe.

When used properly, Microsoft Excel can be an extremely powerful tool to display, organize, and analyze large data sets. The series will contain hidden tips and tricks in addition to exercises that will make you an Excel champion in no time.

Session 4 Topics

  • more pivot tables
  • grouping of tabs
  • linking worksheets through formulas
  • If()
  • Vlookup()
  • SumIF()
  • macros basic

excel-signup-buttonTo get access to the learning series materials and receive information on future sessions, click the sign up button!

Resources

Lynda LogoLynda.com is an incredible online resource offering guided video tutorials and step by step instructions for all sorts of digital tools. As a member of the Middlebury community you have premium access. Here’s how it works:

  • Visit go.miis.edu/lynda
  • Input your MIIS login credentials
  • Search “Excel Essential Learning”

DLC Hosts Camtasia Workshop

On October 15, 2015 the DLC hosted a workshop for MIIS students on using Camtasia software to create instructional videos and narrated presentations.  Many of the students in attendance were enrolled in the DPPG 8541 class, Leading Capacity Development.  Students learned how Camtasia could be used as a platform to create the final deliverable for the class; a professional video to be shared with International Development professionals in the field.

Screen Shot 2015-10-08 at 4.00.15 PM

The workshop covered topics such as:

  • Screen and audio capture
  • Transitions, text, & animations
  • Trimming footage & audio
  • Exporting to Youtube/Midd Media

Additional Resources

On-line Tutorials

Sharing your Video

Similar Tools

Mac:

    • Quicktime (free)
    • Keynote
    • Movenote
    • iMovie
    • iPad Apps
      • Doceri (free)
      • Explain Everything
      • Screen Chomp (free)

Max OS X Workshop

OS X El Capitan-970-80Hey Mac owners! Let me throw something out there and see if it sounds familiar: you own a beautiful Macbook Pro/Air and only use it to browse BuzzFeed and write the occasional grad school paper. If you sheepishly identified with that statement, don’t feel bad! I too was once guilty of under-utilizing my Mac. But then I discovered all the amazing tips and tricks built into this sleek machine, and it dramatically changed my grad-school experience!

Mac OS X is an extremely powerful operating system that can help you organize your life and set you up for success at grad school. Unfortunately, most people never take advantage of all it has to offer! If you’re a newbie to the Mac world, or even a veteran user looking for some additional help, join us at the Digital Learning Commons for a workshop on Max OS X. Come discover how to maximize your productivity and work smarter, not harder!

Some topics to be covered include: Track pad navigation, Using multiple desktops, Shortcut Keys, Creating different iPhoto Libraries, Working with split screens, Using time machine, using iCloud

Here are the Deets

What: Mac OS X workshop – learn how to maximize your productivity
When: Wednesday, October 21st, 11:00am-noon
Where: in the DLC Design Space
Topics Covered: Track pad navigation, Using multiple desktops, Shortcut Keys, Creating different iPhoto Libraries, Working with split screens, Using time machine, using iCloud

DLC Sponsored Workshop on Camtasia

Learn How to Create Instructional Videos Using Screen & Audio Capture

Screen Shot 2015-10-08 at 4.00.15 PM

Students, need to make an instructional video for class, or record a presentation or Skype call? Want to easily demo your work on your e-portfolio into narrated videos?

Professors, want to turn your lecture slides into narrated videos?  Want to create tutorial videos for your students?

Powerful, yet easy to use, Camtasia helps you easily record your onscreen activity and create professional videos or instructional presentations.

This DLC sponsored workshop will go over some best practices for creating video content for classes, and how to use Camtasia as a tool to do this.  Join us and learn how to create high-quality videos that you can use in your academic and professional lives.

 

Thursday, October 15th  1:00pm – 1:50pm @ MG100.