Select Page

Create Filters in Excel

 

This latest quick tip is another Excel one. If your data has headers, you can quickly turn those headers into filters. Even if your data does not have headers, you can quickly add them. Here’s how:

  1. Select the entire row with your headers (typically the first row)
  2. Select the Data Tab
  3. In the Ribbon, click on Filter
  4. Excel will automatically create filters, using unique data in each column as options
  5. Click on the triangle icon to the right of the header you want to filter
  6. Click on the checkbox to the left of Select All to deselect all of the options
  7. Then, go down the list and select the options you want to filter by
  8. Click on OK
  9. Excel will automatically filter the data based on your criteria. If needed, multiple filters can be used at once
  10. To reset the filter, click on the symbol to the right of the header with the filter
  11. In the menu that appears, click on Clear Filter from “Header Name”

Click on the image below (or here) to view the tutorial video:

Click on the above image (or here) to view Applying Filters video.

For more tutorials on Excel and other Microsoft Office products, visit the Microsoft Office Support Wiki Page.

Submitted by: Tyler Kron-Piatek, Instructional Designer, COLI

Midterms in D2L

 

With midterms coming up, it may be useful to review these features of D2L Quizzes and Dropboxes.

D2L Quizzes provides a robust tool to grade quizzes easier and quicker. Some features can help prevent cheating to a degree, like basic question randomization and advanced question randomization. If you want to use questions from a previous exam or quiz, the Question Library lets you copy questions to the mid-term. Additionally, for faster grading, you can connect the Quiz to the gradebook. You can also have your students sign an Academic Integrity Pledge before continuing to the Midterm. Customize the Quiz Result display to show students what questions they got and see where they need to brush up on their studying.

Please note that if you allow automatic grading of your exam, D2L will not automatically grade written responses. Those need to be graded manually. Inform your students that the grade they have immediately after completing the exam is not reflective of their overall grade. If you want to see all of the tutorials on the D2L Quiz tool that COLI has compiled, check the Online Quizzes and Exams in the Quizzes Tool Section.

D2L Dropboxes are a great way to receive student work in various formats but more notably PDFs, Microsoft Office files, JPGs or PNGs. You can also restrict the types of files the dropbox will accept. Attach the dropbox to the grade book or use a D2L Rubric and attach it to the dropbox for faster grading.

For more information on D2L Dropboxes, check out the Collecting Assignments in Dropboxes Section. For tutorials on D2L Rubrics, check out the Using Rubrics Section. If you would prefer, you can also sign up for COLI workshops or sign up for a Consultation with one of COLI’s staff members.

COLI has compiled other resources on the various tool sets in D2L. Check the D2L Self-paced Training for Faculty and Staff Wiki page.

Submitted by: Tyler Kron-Piatek, Instructional Designer, COLI

Campus Candids

Students gave their professional wardrobes some love when the Griff Center for Student Success opened its pop-up shop on Valentine’s Day.

The pop-up shop runs through the end of February in Horan O’Donnell 014.  Career Development is still accepting donations of clean, gently used professional clothing.  All sizes needed!

Submitted by: Eileen Abbatoy, Executive Director, Career Development, Griff Center for Student Success

 

Canisius in the News

The Women’s Business Center (WBC) at Canisius was in the spotlight last week when WKBW-TV Channel 7 featured a story on the center’s women empowerment movement. The WBC hosted several organizations on campus to find ways to bridge the gap in women-owned businesses. Click here to watch the story.

Submitted by: University Communications

Canisius Names New Director of Public Safety

Clayton Staton has been named director of public safety at Canisius.  Staton is responsible for providing a safe and secure environment for all Canisius students, faculty, staff and visitors to the campus.  He will enforce federal, state and local laws, as well as Canisius’ rules and regulations, and will work to ensure that the Public Safety Department plays a critical role in the university’s emergency preparedness and response, including organizing safety training for the campus.

“Clayton joins Canisius with 33 years of law enforcement experience; he will undoubtedly be an asset to our campus community,” said Harold O. Fields, EdD, vice president for student affairs and dean of students. “His diverse background includes a commitment to service, extensive law enforcement experience, expertise in crisis preparedness, as well as campus safety and security.  These experiences make him an ideal candidate for the position.”

Staton is a State of New Jersey certified Security Officer Registration Act (SORA) instructor and private security consultant. In the position, Staton is responsible for instructing security officer candidate courses including national incident management system (NIMS), incident command system (ICS), the role of the security officer, use of force, ethics, active shooter, bomb threat management, suspicious activity reporting and homeland security.

Click here to read more.

Submitted by: University Communications

Canisius Welcomes Andrea Alvarez, PhD

The Borders and Migration Initiative along with ArtsCanisius invites the campus community to join them at 1:00 PM on Wednesday, March 6, 2024 in the Library Learning Center for an art history lecture featuring the current Narsiso Martinez: From These Hands (De Estas  Manos) exhibit at the Buffalo AKG Art Museum.

Andrea Alvarez, PhD, associate curator at the Buffalo AKG, will discuss this solo exhibition that features a selection of works that exemplify the artist’s unique practice of combining drawing and painting on reclaimed produce boxes. The exhibition will run through April 8, 2024.

The lecture is free and open to the public and light refreshments will be provided by the Andrew L. Bouwhuis Library.

This event is co-sponsored by ArtsCanisius and the Borders and Migrations Initiative.

For more information about the exhibit, click here. 

Submitted by: Yvonne K. Widenor, Assistant Professor, Art History, MLLC Department, Director and Studio Art Galleries Director, ArtsCanisius