Computer Replacement Suggestions

  • Updated

Purpose:
This process outlines how to use the monthly Workday attractive asset report to create a list of devices that should be considered for replacement.  ITS suggest that you replace any items that were acquired 5 or more years ago.

Steps:

  1. Log into Workday and go to your Notifications
  2. Locate the notification called "Document Available" that alerts you that "FGCU Assets Issues to Property Manager <date>.xlsx" report is now available.  (You will receive a new monthly report on the 1st day of every month - Figure 1)
  3. Download the report from Workday to your computer
  4. Find and open the file in Excel, which will typically be found in your "Downloads" folder
  5. Highlight and delete the first 5 rows to allow for easier sorting of the data later(Figure 2)
    1.  Clicking on the #1 next to the start of the rows and dragging your mouse down to the #5. 
    2. Then right click and pick delete
  6. Highlight the remaining columns and rows (Select all button, or ctrl+a on your keyboard - Figure 3)
  7. Sort the data by the "Date Acquired" column ("i")
    1. On the "Home" tab, under editing, click "Sort & Filter", then pick "Custom Sort" (Figure 4)
    2. Under "Sort by" select "Date Acquired" and make sure "Oldest to Newest" is selected (Figure 5)
    3. Click OK
  8. Your inventory will now be sorted oldest to newest, and you can use this data to determine which devices you should consider replacing

What to replace?

  • ITS suggest you replace any computer 5 years or older, as they are likely out of warranty and at greater risk of malfunction
  • Please note that these recommendations do not include iPads or Android devices.  These are up to each department to decide when to replace

Notes

  • ITS will eventually stop supporting computers due to the age of the hardware and incompatibility with updates released by the software vendors
  • If you have questions about a specific device on your list, please contact the University Help Desk and we will be happy to assist you
  • For an up to date list of computer recommendations, please visit: https://www.fgcu.edu/its/staff/computerconfigurations

Figures:

mceclip0.png

Figure 1 - Workday Property Report Notification

 

mceclip1.png

Figure 2 - Delete first 5 rows

 

mceclip3.png

Figure 3 - Select the remaining data

 

mceclip4.png

Figure 4 - Custom Sort

 

mceclip5.png

Figure 5 - Sort settings