Create SharePoint List from Excel Spreadsheet

The advantages of using a SharePoint list instead of just uploading an Excel file to SharePoint is that multiple people can edit the file simultaneously, you avoid version sprawl by only having one centrally located version of the list and you can always download the list as a file if needed.

Here are the steps.

  • Make sure your Excel file is saved in the newest format, it needs to have a .XLSX extension. If it does not, simply save it in this newer format. The old format is .XLS.
  • Browse to your SharePoint site using Internet Explorer. This task requires IE as it is the only browser that works with ActiveX controls.
  • Follow these steps here using Internet Explorer:

https://support.office.com/en-us/article/Create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

Office 365 SLA (Service Level Agreement)

Many of us expect email to be delivered instantly. Although it is usually very fast, there are many factors that affect the delivery time and most of us have unreasonable expectations based on the service that we use. This article will hopefully explain some of the things that can affect the delivery of email and spell out the level of service guaranteed by Microsoft.

In summary.

  • The service design goal of Exchange Online is the delivery of email in less than one minute, but this is an average over a month and not for any one email message.
  • Broken is considered an average delay of greater than 10 minutes over a month, again this is an average and does not apply to any individual email message.
  • Any one message is considered delayed after three hours at which point the sender should get an information email.
  • Any one message that is not delivered in three days is failed and the sender will get a NDR (Non-Delivery Report).

There are also other factors that affect the delivery of email.

  • Exchange on-premise adds additional delay for Exchange Online users, this is usually under one minute (20-30 seconds seems normal) but can be up to five minutes. Currently, because of a requirement of a small number of users, all Exchange Online email is routed through an on-premise Exchange server. If there is a delay, this is usually where it occurs rather than with any Microsoft infrastructure.
  • That said, routing email through an on-premise Exchange server has mitigated numerous other risks with corresponding cost reductions that would have been incurred by addressing them. It also lets the UW comply with ISO 27001, ISO 27018, Safe Harbor, SSAE16 SOC1 Type II, SOC2 Type II and FISMA. Very few cloud-only (or even any) email providers can claim this.

BitLocker

The iSchool has BitLocker configured on all Faculty, Staff, and PhD student Windows computers.  BitLocker is a Microsoft disk encryption technology.  Once BitLocker is turned on, your UW NetID credentials will continue to allow you to sign into the computer; you should see no noticeable change in behavior.

If you are ever prompted for a BitLocker Recovery Key, please contact the iSchool IT Help Desk.

More about BitLocker can be found at the websites below.

https://docs.microsoft.com/en-us/windows/device-security/bitlocker/bitlocker-overview

https://en.wikipedia.org/wiki/BitLocker

 

 

FileVault

The iSchool has FileVault configured on all Faculty, Staff, and PhD student Mac computers.  FileVault is an Apple full-disk encryption technology.  Once FileVault is turned on, after a computer is restarted or shutdown, only FileVault-unlock-enabled users or a user with the FileVault Recovery Key can access the drive.  Once FileVault is turned on, your UW NetID credentials will continue to allow you to sign into the computer; you should see no noticeable change in behavior.

If you are prompted for a FileVault Recovery Key, please contact the iSchool IT Help Desk.

More about FileVault can be found at the websites below.

https://support.apple.com/en-us/HT204837

https://en.wikipedia.org/wiki/FileVault

Powerpoint

The Online Learning Team maintains a guide about Powerpoint, which is available on Canvas via the iSchool Online Learning Support site. You can access the guide here.

The guide specifically addresses ways instructors can use Powerpoint for their lectures, and provides a tutorial on how to embed audio in Powerpoint slides.

If you have any questions, you may reach out to the Online Learning Team by emailing olt@uw.edu.

 

Display People images on the iSchool SharePoint Intranet

Sometimes when you browse to one of the “People” links on the iSchool SharePoint Intranet all the image links are broken like this.

people

The reason for this is our Intranet and your Office 365 Profile (where your picture and bio live) are on different servers and you need to authenticate to both.

The easiest way to do this is to right click any of the broken images and select Open image in new tab. Once you see the picture (or the generic buddy icon in the case of a person who has not uploaded a picture to their Office 365 Profile) you can refresh the SharePoint page and you will see all the pictures.

Husky OnNet VPN Service

The Husky OnNet VPN application is installed on all iSchool issued computers. Search your computer for the application named “BIG-IP Edge Client.” For more detailed instructions, refer to “Run” sections on this page:

https://itconnect.uw.edu/connect/uw-networks/about-husky-onnet/use-husky-onnet/

Read on for more information about the Husky OnNet VPN.

Husky OnNet, offered by UW-IT, is a client-based, SSL (Secure Sockets Layer) VPN (Virtual Private Network) service. Husky OnNet provides individuals using Mac OS and Windows devices with a secure, temporary connection to the UW network from off-campus locations. Users connecting their device to an off-campus network (e.g., from home, a conference, a café, at the airport, etc.) can use Husky OnNet to connect to the UW network to access resources as if they were physically on campus.

If you are off campus:

you need to be connected to Husky OnNet to:
– access the N drive via File Explorer or Finder
– use the Avaya telephone software
– connect to certain class and research related servers
access library databases and journals

you do not need to be connected to Husky OnNet to:
– connect to your iSchool Windows computer using the iSchool Remote Desktop Gateway
– access your UW email
– access the iSchool SharePoint Intranet
– access the Internet

To use Husky OnNet, you need to have the application installed on your computer. There is an application for both Mac OS and Windows.

If you have an iSchool issued computer, you already have the Husky OnNet application installed.

If you do not have the application installed, click the link below to download the application installer:

Download the Husky OnNet application

UW-IT maintains a web page with information about installing and running the Husky OnNet VPN application:

https://itconnect.uw.edu/connect/uw-networks/about-husky-onnet/

More Husky OnNet resources from UW-IT:

Husky OnNet frequently asked questions

Recover a deleted Contact in Outlook

Sometimes we delete things accidentally and sometimes we even empty the Deleted Items folder before we figure out what we did. Fortunately, if you realize what you have done within a few days, there is a recourse.

Follow these instructions:

https://support.office.com/en-us/article/Recover-a-deleted-contact-in-Outlook-51c83288-6888-4dcd-8c99-4932daabf643?ui=en-US&rs=en-US&ad=US

Locked printing with Ricoh printers

Locked printing with Ricoh printers

Instructions below are for using a security function on Ricoh printers allowing users to “lock” or hold their print until they are physically in front of the printer to “release” the actual printed piece of paper.

The instructions below are applicable to the following printers:

Ricoh in Bloedel Hall 095 (BLD-095-RicohMPC4504)
Ricoh in Gerberding Hall B054L (GRB-B054L-RicohIMC3500)
Ricoh in Mary Gates Hall 015 (MGH-015-RicohMPC4504)
Ricoh in Mary Gates Hall 095 (MGH-095-RicohMPC307)
Ricoh in Mary Gates Hall 330 (MGH-330-RicohMPC4504)
Ricoh in Mary Gates Hall 370A (MGH-370A-RicohMPC4504)
Ricoh in Mary Gates Hall 420 (MGH-420-RicohIMC4500)
Ricoh in Tower (TWR-RicohMPC4504)

Windows
Mac

locked printing in Windows

(Word is used in the example below. However, this option works with Excel and other programs.)

01) click File

 

02) click Print

 

03) select one of the printers listed above, click Printer Properties

 

04) from the “Job Type:” drop-down, select Locked Print, click Details…

 

05) in the Job Type Details window, use the following settings:

User ID: use Create Own ID
Enter User ID: use your UW NetID
Password: use any number with 4 to 8 digits, it must be memorable to you, you will need to type in this number while physically at the printer

click OK

 

06) click OK

 

07) click Print

 

At this point, the rest of the steps need to be done while at the printer.

08) (on the Ricoh printer interface) press Printer

ricoh_printer_button

 

09) press Print Jobs

ricoh_print_jobs

 

10) select the User ID you created in step 05

ricoh_user_id

 

11) select the correct print job, press Print

ricoh_user_id_print_job

 

12) enter the password you created in step 05, press OK

ricoh_print_job_password

 

13) change the quantity of print copies desired if necessary (1 copy is default), press Print

ricoh_print_button

 

locked printing in Mac OS

(Word is used in the example below. However, this option works with Excel and other programs.)

01) click File, click Print…

mac_word_file_print

 

02) select any printer listed above from the “Printer:” drop-down, select Job Log from the third drop-down

 

03) for “Job Type:” select Locked Print, use the following settings:

User ID: use your UW NetID
Password: use any number with 4 to 8 digits, it must be memorable to you, you will need to type in this number while physically at the printer

click Print

 

At this point, the rest of the steps need to be done while at the printer.

04) (on the Ricoh printer interface) press Printer

ricoh_printer_button

 

05) press Print Jobs

ricoh_print_jobs

 

06) select the User ID you created in step 03

ricoh_user_id

 

07) select the correct print job, press Print

ricoh_user_id_print_job

 

08) enter the password you created in step 03, press OK

ricoh_print_job_password

 

09) change the quantity of print copies desired if necessary (1 copy is default), press Print

ricoh_print_button