Share This

OIT Completed Projects 2016 - 2017

Office of Information Technology
0

OIT Completed Projects 2016 - 2017

2016-2017

Completed Projects

1. LANDesk Implementation

OIT designed and implemented the infrastructure for LANDesk Endpoint management. This solution allows the OIT to scan for vulnerabilities on over 8,000 machines within the college network.  In addition, it creates the capabilities to streamline and enhance software management throughout the college, including configuring, installing, updating, and uninstalling a wide range of software packages while maintaining updates and patches for the Windows, Mac, and Linux operating systems.  

2. NAC Smart Classrooms Upgrade

Throughout the spring 2017 semester, 86 of the NAC Smart Classrooms had a major upgrade. New fiber cables were installed, as well as data cables and a new IDF was built.  We added 14 newer switches, which substantially increased the network bandwidth from 100 MB to 1000 MB. Now, both faculty and students are experiencing a better and faster network connection.  76 access points (APs) were also deployed (10 were upgraded vs 66 were new installation). The APs upgrade has dramatically increased the bandwidth and coverage across NAC smart classrooms.

In addition, Wireless Presentation have been deployed into 83 smart classrooms, including STC-1 located inside the Technology Center in NAC 1/301. This new technology allows faculty to wirelessly connect to the AV system, play video content or display his/her presentation material from a laptop, iPad, smartphone, or tablet in real time.  It also allows up to four devices be displayed on the main screen at a time. 

3. Network storage upgrade

The final phase of the main campus Compellent Storage Centers was completed. The network storages were upgraded with the latest generation of the expansion enclosures, SC200/SC220, which delivers optimized efficiency, energy-efficient, and secure data protecting against downtime and disaster.  These storage systems host over 200 critical virtual servers.   This upgrade alleviated inadequate system resources, allowing OIT to provide additional services as needed to the user community and accommodate the storage needed to migrate legacy systems to a consolidated environment.   

4. Wi-Fi Enhancement and Upgrade

In collaboration with other schools/divisions, OIT continues enhancing and upgrading the wireless capabilities both in lecture halls, classrooms, office spaces, student laboratories, and libraries.  105 APs were installed this year, an 18% increase compared to fiscal year 2016.  We will continue adding to our Wi-Fi deployment each year. The list below represents the total number of Access Points (APs) installed:

·         Grove School of Engineering Lobby (4)

·         Grove school of Engineering, Room 161 (4)

·         Cohen Library (1)

·         Compton & Goethals Hall – CG, room 245 (1)

·         Center for Worker Education - CWE (16)

·         Center for Excellence in Teaching and Learning - CETL (3)

·         NAC Smart Classrooms (76)

5. New Student Seminar (NSS) Laptop Loaner Program

The OIT replicated the new Laptop Loaner Program for CCNY NSS classes, funded by the President’s Office.  This new loaner program offers 38 Dell Latitude laptops equipped with the latest technology.  Each NSS Instructor was able to borrow the computer for a full semester.  All laptops are loaded with MS Office, Wi-Fi, Adobe Acrobat, as well as other CCNY-approved software such as Adobe Cloud, etc.

6. Faculty Laptop Loaner Program Expansion

32 new (2-in-1 Dell 7250) Tablets were added to the existing faculty laptop loan program.  A total of 67 mobile devices (a 48% increase) is now available for faculty to use in smart classrooms.  These tablets are equipped with the latest technology, MS Office, VIA Connect Pro, and other CCNY-approved software such as Adobe Cloud. 

In addition, a new application called Ink2Go has been loaded onto each of the existing laptops and the new tablets.   Ink2Go allows users to annotate on top of any content they are displaying – even running video – and save it for subsequent display. You can also bring up a whiteboard display to write on your laptop/tablet with your finger or a stylus. You can then save your annotations as image files or even record the entire session as a video for subsequent sharing.

7. SharePoint Site for Middle States Accreditation Process

A new site in SharePoint was created to allow staff members to collaborate with each other in the Middle States Accreditation process. This site allowed the hosting of documents which could be checked-in/out, do annotations, version control, and checked documents history.  Documents in this site are encrypted and secured

8. CUNYfirst Report Generator

A report generator was built to prepare ad hoc reports based on requests from users over the years.  This new application simplifies the collection of programs (jobs) utilizing a more user friendly interface.  Features include:

·         An authorized user can run a job at any time

·         Reports can be downloaded in EXCEL format

·         Reports take less time to run 

There are currently 72 users from different departments using this application. There are now more than 84 jobs available in this application, a 52% increase since it was launched on October 1, 2016.  Below find sample reports which an authorized user can run:  

  • The Dean’s List
  • All students in a term
  • All registered students counted by major
  • Reading/Writing/Math score for registered students
  • Students with INC/FIN grade and instructor's email
  • Students with W* Grades
  • SEEK students with active SEEK stdgrp but is not regd.
  • Student Graduation Summary Report
  • All courses taken by science student
  • All sections offered by semester
  • Compare course enrollment limits and counts
  • Registration trends by major
  • Extract student contact info from a user's emplid
  • First-time registration trend
  • Emplid list to create FQWS student group

9. Non-Public University Information Survey

This site allows users to submit a form detailing their use of non-public data and which technology they use. CUNY policy mandated that the use of non-public data must be collected via a security attestation form.  The site features a password protected administrative interface which allows the security office team to review, edit, sort and download submitted applications as a .csv or .pdf file.

10. Password Reset Version 2

The old Password Reset application was upgraded to its newest version 2 to address compatibility issues with Google’s reCaptcha.  Users were also complaining that the old version was not very user friendly.  This new version includes the following features:

  • enhanced user interface for mobile devices
  • an activity log which shows prior activity for troubleshooting purposes
  • a new security method is used – the "honeypot" method, which is triggered only if the script detects a value in a hidden field which is not shown to the user. If a value is detected, ONLY then is the captcha triggered
  • color coded two boxes for each group to make it easier to select which option the user needs
  • more user friendly wording
  • changed captcha from Google's reCaptcha to a simpler solution called visualcaptcha.  This tool is hosted locally and asks the user to select one of five icons only one time, or to answer an audio question.

11. CUNY Medical School Password Reset Application

A password reset application was built for the CUNY Medical School based on the existing many CCNY password reset applications.  It can also be used as a lookup tool to find a forgotten emplId and/or email address.  A new feature of this application is that it allows a user to unlock their account if it gets locked.

12. Internship Database Application

This internship database system allows advisors to keep track of which internships students have participated in. Some of the useful features of this application include the ability to:

  • search for student or employer information from a centralized database
  • add a new student or internship to the database
  • export search results into a .csv file
  • the system is password protected
  • administrator privileges include the ability to:

 i.      add, update or delete program administrators (access to the application)

 ii.      add, update or delete different programs or offices

iii.      add, update or delete the list of Degree displayed on the form

iv.      Add, update or delete the list of Career Cluster displayed on the form

v.      Add, update or delete the year displayed on the form.

13.  Leave Request Form

A web based application was built to digitize the Leave Request paper form previously used by the Office of Information Technology (OIT).  The application is being piloted within the OIT Department.  Once the pilot program period ends, we will deploy it across campus.  This application uses the ProcessMaker platform to handle the workflow behind the form. It has an administrative interface where the department’s liaison can change supervisors/approvers on the back-end. 

14.  Hobson Retain implementation

All the data files required to feed the Hobson Retain System have been centralized into one system.  MS SQL jobs were created to generate the files and upload them to the Hobson server on a schedule.

15.  Credit card online payment application

OIT developed a credit card online payment application which functions as a general purpose credit card payment system, which the business office can offer to other CCNY departments to take payments for donations, parking, conferences and sponsorships. The application can also generate weekly reports on payments.  The credit card online payment application was used this past year (FY 2017) to collect payment from both attendees and sponsors for the following conferences listed below:

  • II-IV Compounds and Related Materials Conference in Puerto Rico, NOAA CREST
  • CWE Transatlantic Conference, CWE
  • 91st ACS Colloid & Surface Science Symposium- GSOE/Chemical Engineering Department
  • NOAA Satellite Conference 2017 – GSOE.

16.  New laptops for newly-created online clinical intake form

Three clinical support areas – AccessAbility, Counseling and Health – now have a unified online demographic and clinical form to ensure accurate and secure data on a wide range of issues affecting students, from chronic medical and disability issues to alcohol and drug use, mental health, homelessness and more. It also provides the ability to track student outcomes based on their GPA. The collected data, along with a prevention assessment model will support a holistic and comprehensive approach to providing student support, which will potentially improve retention rates.

17.  Wellness and Accessibility Titanium and File Share Migration

The Wellness and Accessibility Center utilized a locally maintained file share hosted on a server with obsolete hardware and software which could be accessed by both Windows and Macintosh users at both locations. Due to functionality, performance, sensitive student’s records, and security concerns, these files were migrated to a more secure and reliable file share cluster that has regular back up and security updates. 

18.  Improved computer service for ChE department students – Citrix server upgrade

The Citrix virtual server assigned to the Chemical Engineering (ChE) students has been upgraded with additional hard drives and extra memory to minimize downtime and provide adequate resources during peak demand. The Citrix server purchased in 2010 had been constantly shutting down, affecting in excess of 50 ChE undergraduate, doctoral and MS students, who need 24/7 availability to use specialized software. These additional resources also provide a fail-over backup server to minimize downtime.

19.  Symplicity Career Services Management System

OIT renewed the Symplicity contract from the Tech Fee budget. The Career Services Management System is the primary web-based operating system for the Career and Professional Development Institute, which enables CCNY students to access job and internship opportunities online. In order for CCNY to stay in compliance with a federal gainful employment mandate and state experiential learning law, this essential system is needed to administer and track these opportunities. Users are now able to view and apply for employment and internship opportunities, regularly communicate with over 5,000 potential employers, host and deliver the senior graduation and six-month post-graduation surveys, track student internship experiences, notify students, faculty and administration of any new opportunities, and receive career coaching.

20.  Art ad MCA departments student web-checkout equipment

The Art and Media and Communication Arts departments (MCA) received 30 iPads with accessories, two pocket projectors, and one 360-degree camera as part of an equipment checkout system for all Art and MCA majors and minors (affecting a total of 1,175 students). This new equipment loan program operates on a first-come, first-served basis. This project, administered in two locations (Compton-Goethals and Shepard Hall) services both departments offering equipment that would otherwise not be available to students who use this equipment for assignments and presentations both in and out of class (e.g., for future employment). The Tech Fee also funded the acquisition of BookingPoint software, which allows the program administrator to easily manage the equipment being loaned.  MCA also installed a FileMaker-based web checkout system to be shared and jointly administered by Art and MCA.

21.  School of Education smartboard upgrade

In collaboration with OIT, six of the current 11 smart classrooms were upgraded with the newest smartboards technology, faster desktop computers and the latest software version of Notebook to use with these smartboards.  

22.  Finance Server Upgrade

Thanks to the VP & CFO of Finance and Administration, OIT was able to upgrade and migrate its legacy finance application from an old physical server to a new high-availability virtual environment.

23.  Student Computer Lab Upgrades

OIT continues to work closely with the President’s and Facilities offices in conjunction with the relevant schools and divisions in implementing upgrades throughout the campus. Several student computer labs have been upgraded during the last several months, some of them funded by the CCNY Students Technology Fee and others by the President’s Office. These include:

a. The GSOE virtualization computer lab 

In collaboration with the GSOE, OIT implemented a new state-of-the-art virtualization computer lab that hosts 45 thin clients (a stateless, fan-less desktop terminal that has no hard drive).  This lab is shared between the Mechanical and Civil Engineering departments.

b. Mechanical Engineering computer labs upgrade (ST 226 & ST B39). 

10 obsolete computers were replaced (five in each computer lab) with new computers as well as the instructor laptop for each lab.  OIT also replaced the obsolete 10-year-old network switch and the network cabling was upgraded with Cat 6 in Lab ST 226.  The School of Engineering only had 50 licenses of SolidWorks, which have been upgraded to the newest version. An additional 150 licenses more have been added to allow students from different majors in engineering to complete their assignments and projects on time.

c. NAC 6/325 Social Science AV enhancement

With the support of the Office of Facilities and OIT, NAC 6/325 was reconfigured to install a new projection system. Two new projectors and screens were installed along the longer wall of the room so that presentations are readily visible from all parts of the room. The projectors in these rooms are equipped with the latest technology lamps, providing sharper images with more energy efficiency. In addition, video and recording equipment was also installed to enable remote learning and conferencing. This new reconfiguration increased the class size capacity from 60 to 80 students per class.

d. Writing Center collaborative learning Initiative upgrade

Four 65-inch digital displays have been installed in the Writing Center to allow students to share their laptop screens with other students.  In addition, OIT deployed four VIA Connect Pros allowing students collaborate with each other via Wi-Fi and to present from their devices to the displays.

e. Computing and printing infrastructure upgrade for students in the Division of Science

A new HP plotter T790 was purchased to replace the 15-year-old printer in the EAS department, as well as the desktop. The old plotter was faulty, outdated and unable to handle large files and software packages, which are necessary for the creation of large format posters for national and international colloquia and meetings. We installed 20 licenses of ENVI/IDL in the teaching lab in MR-044. These are for use by students performing assignments in several EAS courses involving the mapping and analysis of geospatial datasets. 

f. Grove School of Engineering computer labs upgrades

With financial support from the President’s Office, the following engineering and music library student computer labs were upgraded with state-of-the-art “high end” workstation computers with large monitors which allow students to perform processor-intensive calculations and designs.  In addition to the computer upgrades, we also increased the SolidWorks license from 45 to 200 licenses.  The list below represents the list of computer labs what were upgraded.

·         Civil Engineering Labs

o   CM1 Lab (24 desktops)

o   CM-4 Lab (16 desktops)

·         Biomedical Engineering Labs

o   General Student Lab – Room B-2 (30 desktops)

o   Purification and Teaching Dry Lab Room B-6A (six desktops)

o   Room B-41 (6 desktops)

·         Mechanical Engineering Labs

o   Manufacturing Lab, Room B-39 (five desktops)

o   Computer Aided Design Lab, Room ST-213 (five desktops)

g. Music Library student computer lab upgrade

In collaboration with the President’s Office, OIT replaced the four, seven-year-old computers and added an additional eight new iMacs, totaling 12 computers – a 67% increase in computer availability. We also added an additional eight new license seats for the music writing software Finale and Sibelius to the existing one to accommodate the new computers in the library.

 

24.  College-wide classroom and space renovation

a.      Tech Center – STC 1

OIT and the Office of Facilities worked to complete the redesign of STC-1 located inside the Tech Center, NAC 1/301.  The new design is ADA compliant and accommodates two students on wheelchairs.  All seats are now facing the instructor, allowing the students to have a better communication with the instructor. All the network data cables, Wi-Fi, and AV systems were reconfigured to accommodate the new furniture in the room. 

b.   Office/conference space and classroom networking upgrade

Several classrooms have been renovated in the past several months with the latest data and voice cabling, networking capacity, and Wi-Fi access points, as well as furniture, to provide better services to our faculty, staff, administrators, and students.  Listed below are some of the rooms that have been completed. NAC 1/301 STC-1, NAC 4/220, MR 15, MR 407S, MR 409S, MR 409N, SH-105, CG-245.

        c. NAC Library, 2-201F

OIT has replaced the existing furniture in room 2-201 F inside the NAC Cohen Library and rewired it with new data and electrical wiring.  Fiber uplink was furnished to increase the network bandwidth in the library.  In addition, a new access point and 50 computers were added to increase the computer capacity in the library.  The new design is ADA compliant and accommodates students on wheelchairs.

25.  Departmental and office relocation

Throughout the year, OIT worked with the Office of Facilities and end users to facilitate several departmental and office moves.  Tasks included re-cabling existing suites; adding and reconfiguring data and voice connections; coordinating computing equipment; and phone disconnections and reconnections.  Listed below are some of the offices that have been completed.

  • The iMedia Reservation Desk and office operation moved to NAC 1/204 and 1/205 respectively
  • New York City Alliance Department moved from Marshak 14 to Marshak 529

26.  Office and department AV upgrades

The Office of Information Technology continues to upgrade AV systems in smart classrooms, schools/divisions, and departmental office/conference rooms. In the past few months several offices and conference rooms have been upgraded with newer AV technology and display systems, including LCD flat TVs, smart boards, projectors, lecterns, and electronic screens, to provide better AV services to our faculty, staff, administrators, and students.  Listed below are some of the rooms that were completed.

  • Provost conference room – Dual display AV systems with wireless presentation VIA Connect Pro
  • Accessibility Office, NAC 1/218 – Wall mounted existing AV components in the main office and lounge area
  • Baskerville 106 – Replaced existing projection screen
  • NAC 4/225 E- AVP & CIO of IT Conference room – installed new AV System with wireless presentation VIA Connect Pro.

27.  Digital signage expansion

OIT continues expanding the digital signage project which was initiated back in fall 2015 with funding by the CCNY Student Technology Fee.  During February and March, a total of three new displays were installed in the following locations:

·         Two displays –  Grove School of Engineering, 2nd and 2-M Floors

·         One display – Marshak building, 1st floor (near Elevators)

28.    2017 Commencement Ceremony

In collaboration with the Public Safety Office, and Facilities Office, OIT facilitated the webcast and simulcast services during the 2017 Commencement Celebration. Several displays were deployed across campus to view the ceremony broadcast.