Author: Amy Slay

Fall 2015 Excel Learning Series – Session 4

Amy Slay Events, MIIS Update, Workshops

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”

Fall 2015 Excel Learning Series – Session 3

Amy Slay Data Analysis, Events, Excel

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 third of four sessions will take place on October 9th at noon 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 3 Topics

  • Charts and Adjusting Worksheet View
  • How to create a charts (All Types)
  • Other chart types, mixed Use income as line, expenses and
  • Savings as stacked column
  • Altering parts of a chart
  • SPARKLINES
  • Freeze panes
  • Splits
  • Outlining

Sign Up

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”

Fall 2015 Excel Learning Series – Session 2

Amy Slay Data Analysis, Events, Excel, TW@M, Workshops

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 second of four sessions will take place on September 25th 11am – noon in MG100 (McGowan 100).  All you need to bring is yourself and your laptop! 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.

Sign Up

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

Session 2 Topics

  • Control 1 important and easy way to get to the format cell box
  • Formatting Cells
  • Tabs (part 2)
  • Row Height and Columns functions
  • 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

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”

IEM WordPress Workshop F15

Amy Slay Blogging, Events, Workshops

Sign-in hereHey 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

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: http://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

 

Fall 2015 Excel Learning Series

Amy Slay Data Analysis, Events, Excel, MIIS Update, TW@M, Workshops

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 first of four sessions will take place on September 11th at noon 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 1 Topics

– cursor
– cells
– formula bar
– tabs
– worksheets
– templates
– fonts
– copy and paste
– wrap text
– mini toolbar
– quick access tool bar
– status bar
– entering data
– autofill
– undo/redo
– comments
– save
– writing + copying formulas
– $$$$$$

Sign Up

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”

The DLC is hiring!

Amy Slay Uncategorized

The DLC is hiring!  We’re looking for a new graduate assistant for the 15/16 academic year.  The GA will work within the curricular technology zone of the DLC under the supervision of the Digital Learning Specialist. The GA will directly support the following digital learning projects and courses:

  • Community Interpreting as a Profession
  • Lesson Planning & Materials Development
  • T&I Early Diagnostic Test
  • IEM Practicum Symposium

Background/Preferred Skills

  • Interest in/experience with digital pedagogy and learning
  • Familiarity with Moodle LMS and Adobe Connect virtual meeting environment
  • Effective communication and writing skills

Responsibilities

  • As needed, provide exceptional customer service, taking scheduled and drop-in appointments with MIIS community clients
  • As available, participate in DLC graduate assistant team meetings
  • Assist the Digital Learning Specialist in the management and curation of online courses on an ongoing basis
  • Test the functionality of online courses before they go live
  • Monitor and manage technical support forums in supported online courses
  • Provide technical support to instructors (e.g. assist professors using Adobe Connect and/or similar tools for synchronous sessions)
  • Assist in the revision of Admission’s web-based Early Diagnostic Test in Moodle

Interested?  Have questions?  For more information, contact miisdlc@gmail.com

Intro to Narrated Screen Capture Workshop!

Amy Slay Camtasia, Digital Storytelling, MIIS Update, Spring 2014 Services, Workshops

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

Students, need to record a presentation or Skype call for class?  Want to easily demo your work on your e-portfolio?

Why? With Camtasia, you can easily record, narrate, and edit your onscreen activity to create professional-quality videos.  Come learn the basics of narrated screen capture as well as how to share your videos.

When? October 7th, 1-2 PM

Where? DLC D Space

How? The DLC has 6 computers with Camtasia software for you to use.  Computers will be given out on a first-come first-serve basis and may need to be shared within small groups.

Questions? Email us at dlc@miis.edu

Screening: Transforming the Academy in the Digital Era

Amy Slay Curricular Technology, Events, Storytelling

This year, the theme of Middlebury’s Clifford Symposium is “Transforming the Academy in the Digital Era”. We are living in an era featuring massive transformations in information and communication technology that alter generations of traditional practices in a wide range of fields, careers, and elements of everyday life. This symposium will focus on how such technological transformations, and their corresponding cultural, political, economic, and social shifts, are changing the world of higher education and scholarly research.

Join us in the DLC D Space for a live-stream screening of John Palfrey’s keynote speech!

You can also watch the below speakers live at the following times here:

    • Tara McPherson, September 19, 10:00 AM
    • Siva Vaidhyanathan, September 19, 1:30 PM