Excel – Unhide All Rows or Columns

How can you unhide all hidden rows or columns quickly? The secret is the triangle button at the top right corner of the worksheet.

Select All Triangle

ITS Knowledgebase instructions to unhide rows or columns.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page Tagged with: , ,

Add More Than One File Attachment to an Outlook Message – PC

Drag and Drop or Use the Paperclip

If you want to add several attachments to a message in one fell swoop, there’s two ways to do so. You decide which way is easier. Text directions and video instructions are on the ITS Knowledgebase. Just click either link below.

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page Tagged with: ,

Canvas – March 2015 Updates

The transition to Canvas is well underway!  All of the summer 2015 and fall 2015 semester courses are now in the Canvas learning management system.  If you want to check out what the course template looks like, you can login at http://etown.instructure.com.  ITS is currently archiving all Bb courses from the last two years so that we have the content to import into Canvas.  We are also working on importing the most recent version of a course into the Fall 2015 courses in Canvas.  This will take some time, and we know that everyone will be ready to work on the next semester’s courses at different times.  If you are ready to archive specific Bb content and then import it into a Canvas course and we haven’t gotten to your courses yet, just fill out this quick form and we can help you.

Training workshops continue each week.  Please check out the schedule of workshops and register for those that fit your schedule.  If you prefer to learn on your own time, we also have a self-paced Canvas Basics training and a self-paced Canvas Advanced course that you can self-enroll in and work through.

Canvas also has extensive and very helpful guides available here.

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Canvas, Home Page, Training

Canvas Updates – February 2015

The transition to Canvas is progressing.  At this time, we have all of the May term courses that have elected to use Canvas and all of the summer term courses added to Canvas.  Weekly trainings continue to prepare faculty for creating and converting their courses to Canvas.  See the current training schedule here: http://www.etown.edu/offices/its/Current_Class_Schedule.aspx

In addition to live training, there is now an online, self-paced training that closely parallels the face-to-face version of Canvas Basics.  If you want to enroll in that course, use your usual E-Town username and password here: https://etown.instructure.com/enroll/K48EPB

Fall 2015 courses will be added to Canvas right around Spring Break, so that faculty have plenty of time to attend training and prepare their courses.

All courses offered in the past two years are being archived from Blackboard and can be imported into Canvas.  However, you may prefer to just design from scratch and maximize the cleaner design features of Canvas.  If you are unsure if a fresh design from scratch or a Bb import is the best way to go for your course content, please contact Linda Macaulay for assistance.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Canvas, Home Page, Training

Fall Faculty Technology Institute

Over the last few summers, ITS and the Dean’s Office has sponsored a Faculty Technology Institute. This Spring, we will have Wednesday @ 11 presentations about the 2014 faculty projects. Each presentation will be held in Hoover 114. Save the following dates:

 

David Kenley, Maire Johnson, and Oya Ozkanca – April 22, 11-12:00

The panelists will talk about the use of technology in teaching their respective courses, and the impact the Summer Faculty Technology Institute had in their own teaching.

How to Avoid “Death by PowerPoint”

David Kenley will discuss how he incorporated other modes of presentation into his course so that students used more than just PowerPoint.

Creative Student Presentations

Maire Johnson will discuss one of the assignments students have often disliked–but then later admitted they found helpful–is the presentation of their rough research paper drafts to their colleagues to receive feedback and suggestions. Frequently, however, they deliver these presentations by reading their pages, with or without Powerpoint slides in the background. In an attempt to alleviate this repetition of style and to spur student creativity, I took part in the summer technology institute in order to challenge my students to come up with new ways of delivering their presentations; my presentation offers glimpses of the fun and exciting results.

The Use of Technology in Effective Teaching

Dr. Oya Dursun-Ozkanca discusses how the Faculty Technology Institute helped her in learning innovative and fun ways of integrating technology into her courses.

 

Sara Atwood – April 29, 11-12:00

Using Course Management Software for Prescriptive Advising

In a credit-heavy major, I have moved the prescriptive elements of advising into an electronic format. Using Blackboard, I created an Advising course with assignments, feedback, and due dates so that I can meet my advising objectives more efficiently. The goals is for this system to put more responsibility on the student to update their check sheets and think about some big-picture questions before their meeting, and to transition the advising meeting towards more developmental conversations rather than check sheet verification.

 

Kristen Waughen – May 6, 11-12:00

The Creation of High Quality Videos for a Flipped Model of Teaching

The flipped model involves a strategically choreographed lesson(s) that prepares students for the next class where the knowledge will be applied. The context of the session is to use the flipped model of teaching to provide foundational elements of lessons using short videos to provide a cognitive scaffold to build on during the actual face-to-face class. The lessons were created and recorded in Camtasia Studio. Students were able to view the videos as many times as they needed to work through the basic knowledge of the topic and practice the task with the information/data provided. The next face-to-face class incorporated application, analysis, and synthesis of the new knowledge learned. Come find out more about the goals and results of this project and any advantages and disadvantages, and acquire informative feedback.

 

As a College dedicated to implementing strategies to increase learning through use of instructional technology, it is imperative that faculty members have opportunities to become comfortable with new and emerging technologies and to envision new ways to use technology to enhance student learning. Therefore, the primary goal of the Fall Faculty Technology Institute is to provide training to faculty in the use of technology for classroom instruction – that is grounded in educational research and instructional design – with a special focus on active learning and technologies that promote success for all learners.

Faculty interested in participating in the 2015 Fall Technology Institute should email Linda Macaulay (macaulayl@etown.edu) and include tentative plans to implement active learning strategies and a specific technology in teaching or identifying a set of instructional challenges that may be addressed through the new classrooms. These ideas will help us plan professional development for the monthly sessions in the fall.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Teaching and Learning

Goodbye Blackboard

As of June 24, 2015, the college will no longer be using Blackboard as an LMS. Don’t worry! ITS will archiving all of your Blackboard courses and can help import them into Canvas. As Etown moves to Canvas, there are many things you can do to ease the transition and help prepare for the new LMS implementation.

Training

Training sessions on how to use Canvas are being offered right now and provide not only information but also insight as to how courses are designed. Visit here for a list of ITS’ upcoming sessions and look for the Canvas Training with Linda Macaulay, ITS Instructional Technologist.

Explore the Guides

Canvas offers many Quick Start guides for both Canvas in general and Canvas for instructors. Visiting the guides for Getting Started and more can be very helpful by itself or as supplementation for the training sessions provided by ITS. Click here to visit guides.instructure.com.

You do not need to have a Canvas account or log in to view the guides.

Talk to Fellow Instructors

Several instructors were able to utilize a pilot version of Canvas during the testing stages and are already familiar with the LMS. Speaking with fellow instructors on how they’ve used Canvas and any tips they may have can be very useful. Contact ITS for a list of pilot instructors if you’re not sure who has been piloting the program.

 

Have questions about Canvas?  Not sure how the implementation will work? Click here to see the full implementation plan and more on the ITS homepage.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Canvas, Home Page, Teaching and Learning, Training

New Tech We Love

Kahoot!

Student’s dozing off in class? Wake them up and get them focused with Kahoot! Utilizing a quick-and-easy online quiz builder while playing on your students’ competitive spirit, Kahoot! allows students to respond from their smartphones, tablets, and laptops to compete for who has the top score in real time. Based on a game-type simulation, this free website and app allows students to take control of their own learning and participate in class like never before.

To find out more, visit the Kahoot! website here: http://bit.ly/1ChzqT8

Office Mix

Tired of the same old PowerPoints for every course? Well now you can jazz up your presentations with Office Mix! Utilizing your current presentation and adding interactivity as well as voice overs, your PowerPoint can transform from “blah” to dazzling. With polls, quizzes, and surveys in real time as well as animations and more, your students will sit up and listen with Office Mix which you can download for free from Microsoft.

To learn more, visit the Office Mix website here: http://bit.ly/1AmOP81

Plickers

Sick of having to log in or wait several minutes for just a one question poll to load? Never again! Combining paper and technology, Plickers does the seemingly impossible task of gathering and grading answers in only a few seconds.  Employing a unique scanning method, you can use just your smart phone or tablet to collect answers from your students who hold up unique cards. Collect analytics on your students and track learning without log-ins, loading times, or computers all with only one smart device in the classroom! Plus it’s free.

To discover more, visit the Plickers website here: http://bit.ly/1DFypZp

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Teaching and Learning, Web Tips

Tag Along Programs

It is widely known that most things in life aren’t free, or if they are, they come at a price. However, many users seem to forget this when offered a free download online. Free downloads often have viruses and malware attached to them. These programs, called Tag Along Programs or “Crapware” cause many problems on personal computers and can stop one from working at all.

How Does It Work?

Malware and viruses are often bundled with other programs that are offered as free downloads. When you install a program, they will pop up as additional install steps or “free” offers within the installation. Often the Tag Along Programs are fake PC “Health” scanners, apps which redirect your browser to a new homepage, and those which create extra ads/pop ups.

“Safe” Downloads

Even though nearly all of the free downloads available online are infected, many people still believe that some sites are safe. A lot of free download sites offer “guarantees” that their software is malware and virus free, citing Terms of Agreement on the website which do not allow malicious content. However, it is almost never true.

What Can You Do?

It is nearly impossible for antiviruses to catch every piece of crapware which is trying to install on your computer by bundling with other software. It is even harder for a regular end user to discriminate between the Tag Along programs and the actual software they are trying to install. In order to prevent your computer from becoming clogged with malicious software, avoid any free download regardless of a site’s claim to be malware free. If you need to download a program, say for a course, make sure to scan the files with a strong antivirus program, like Symantec.

Final Tip

Actually read the Terms and Conditions before installing anything on your computer. Although it is nearly second nature to just click ‘Accept’ on an install, don’t do it. You may be agreeing to allow monitoring of your actions on your computer and, even worse, allowing control of your computer and files to be taken out of your hands.

 

For more information on tag along programs, check out this other blog post here: groups.etown.edu/its/2013/11/12/tag-along-programs/  or read an exposé on the Top 10 Downloads from download.com.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page, Web Tips

Nicarry Active Learning Classrooms

Pilot Classroom

pilot classroomThe planning for the active learning classrooms on the first floor of Nicarry is moving forward with due diligence. We have partnered with Steelcase to install a pilot classroom during Spring Break. The classroom is designed with mobile furniture to allow it to be easily reconfigured during class to support lecture, group work and class discussions. Technology will include two interactive whiteboards and an interactive projector. There will also be multiple sizes of portable writing surfaces.

The faculty in the Education Department will be piloting the furniture and the different technologies during the second half of the spring semester. This will allow us to be better informed as we make our final purchasing decisions for the classrooms that will be renovated this summer.

Summer Renovations

summer renovationsDuring the summer all classrooms on the first floor of Nicarry will undergo substantial renovations. The ITS Help Desk and office areas will also be renovated. There will be minor updates to all offices to include lights, paint, carpet, and ceiling tiles as needed.

There will be eight teaching/learning spaces on the first floor after the summer renovations. Four of these will be classrooms used by the Education Department. This includes two general education classrooms, a Science, Technology, Engineering and Math (STEM) classroom, and a classroom that will feature the pilot furniture from Steelcase. All of the rooms will be designed with mobile furniture, multiple screens, electronic whiteboards, whiteboards on most walls, and wireless technology to allow the instructor and students to project from their laptops and tablets.

Collaboration Classroom and More

classroomThe most “high tech” classroom will be the room we call the collaboration classroom. This room will have six huddle spaces allowing groups of students to work on projects sharing a wall-mounted TV monitor which displays the output from their laptops or tablets. The room was designed to hold 35 students to accommodate core classes that may wish to utilize the space. The instructor can display material on the large screen as well as any or all of the TVs at the huddle spaces. There are Business, English, Education, Music, and Engineering classes scheduled in this collaboration classroom during the fall semester. There are still open time slots after 2:00 p.m. if others would be interested in scheduling a course in this room.

Other rooms included in the renovated space will include a videoconferencing room and a seminar room. Biology students enrolled in a joint program with Drexel will utilize the videoconferencing room. Others may use the room for interviews, meetings, or small classes. This room will feature two 70” displays, microphones, and speakers to allow for an optimum videoconferencing experience. The videoconferencing room will accommodate 6 people for videoconferencing and 12 people for meetings.

Other Tech

Some of the other technologies to be purchased to support the instruction in these active learning classrooms include a cart of iPads, a cart of Windows laptops or tablets, a few small robots, a small 3D printer, video cameras, and microphones.

Funding

With the gift in kind from Steelcase, a large donation from the Alden Trust, and another substantial gift from an alumnus, about one third of this renovation project is being covered by private gifts. The remainder of the project is funded from the Plant Reserve Fund. The Plant Reserve Fund is money set aside each year to cover major infrastructure upgrades. It is not part of the annual operating budget and must be used for maintenance and renovation of the facilities.

 

As we embark on this renovation, we are positioning E-Town to be on the cutting edge of classroom design and teaching innovation. This is an exciting time for instructors and students alike!

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Teaching and Learning

Making Yosemite Work on the College Network

Mac’s newest OSX, Yosemite, is now compatible with the self-registration process on the campus network. If you choose to install Yosemite on your computer, you need to install a newer version of Symantec Antivirus and reinstall the Bradford agent. 

Steps

  1. You must be connected to the college network.
  2. Install the new Symantec Endpoint Protection version 12.
    Symantec Endpoint Protection installer on-line
    Do this BEFORE you install Bradford Agent.
  3. Upgrade Bradford Agent from the Registration webpage

os_x_yosemite_roundup
Pic: http://cdn.macrumors.com/article-new/2014/05/os_x_yosemite_roundup.jpg

 

Mac OSX (Operating Systems) from newest to oldest and dates they were announced.

Note: Only 10.8, 10.9, and 10.10 can access the college network.

OSX Name Version # Release Date
Yosemite 10.10 10/16/2014
Mavericks 10.9 10/22/2013
Mountain Lion 10.8 7/25/2012
Lion 10.7 7/20/2011
Snow Leopard 10.6 8/28/2009
Tiger 10.4 10/26/2007
Panther 10.3 10/24/2003
Jaguar 10.2 8/24/2002
Puma 10.1 9/25/2001

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Split the Message Window in Outlook or Other Microsoft Program Windows

Add the Split Command to Outlook’s Quick Access Toolbar

Split1

Directions from Experts Exchange.

If your message, document or spreadsheet is long, readers may have to scroll up and down a lot. But if you split the window in two, each pane can be scrolled independently of the other. So you can see the beginning and end of the message, document or spreadsheet at the same time.

Office 2013 did away with the split bar that appeared at the top of the vertical scroll-bar, but the feature is not gone. Instead add the Split feature to Outlook’s Quick Access toolbar.

Split the Window in Excel and Word with the View Ribbon

Split2

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page Tagged with: , , , ,

Flash Fill – Excel

FlashFillExcel

If you have a column containing first names AND last names, it is hard to sort or otherwise just work with the last name. Excel 2013 provides a neat feature called Flash Fill to copy out just the last name. You don’t have to be an Excel expert to use it. Just type!

Knowledgebase Article

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips

Add a Program to the Windows 7 Taskbar

ProgOnTskBr

This article explains how to add a program to the task bar and then easily start it by clicking its icon on the taskbar. Though the example uses Microsoft Office Outlook, this applies to any program, not just Microsoft’s.

Steps to Add a Program to the Taskbar

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips

Teaching and Grading Timesaver: Using Turnitin Quickmarks with Hyperlinks

If you have used Turnitin for assignments to check for plagiarism, you already know it is a powerful tool.  But did you also know that you can grade assignments within Turnitin and use Quickmarks that you can customize to give detailed feedback with a simple click and drag?  At first, you might just use these Quickmarks for text comments.  However, they can be even more powerful teaching tools and provide detailed feedback to students if you include a hyperlink in the Quickmark to a tutorial video, assignment guidelines, or sample papers.  Want to learn how to add hyperlinks to your Quickmarks?  Check out this blog post from Turnitin and then contact Linda Macaulay if you would like support implementing this time-saving strategy in your courses.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Teaching and Learning Tagged with:

Prepare for Winter Break Before You Leave Campus

clip_image001

 

 

 

Set Out of Office notices and make sure VPN works. Change your password if necessary. Then enjoy winter break with no computer worries!

Email Out of Office Notices

Notify Senders You’re Away from the Office

Phone Out of Office Notices

Set an Alternate Greeting on Your Office Phone

VPN

If you are doing any college work from home over winter break, before you leave make sure VPN is working and that you can connect to your network drives on your college-owned computer. On a personal computer check that you can connect using a remote desktop connection to ecfsHome-ts.

Network Password

Change Your Network/Email Password

If you haven’t changed your password since the beginning of the fall term, change it now to stay connected to email, JayWeb and Blackboard. You won’t have to do it again until April. Just make sure to remember the new password.  After you change your password, change it on all your devices. Use your new password before you leave campus.
Step by Step Directions & Video
Log on to OWA to test your new password.

WiFi – Update Your Password

After you change your email password, if you connect to EC_JAYNET_LOGIN on campus you will need to change the wireless password for that connection. This is not necessary if you connect to EC_OPEN_WIFI.

Email on Wireless Devices – Update Your Password

If you receive college email on any of your devices, such as an iPhone, update your mail settings to use the new password. Step by step instructions:  iPhone

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page, Phone Tips, Web Tips