Spreadsheet: 06c19ebd-1b71-419c-8649-b44cbe20906d
Sheet: Sheet1

ID | Area | Requirement | Delivery | Priority | Severity | Cat code | Category | Anticipated Sprint | Unnamed: 9 | Effort Estimate - Requirements | Effort Estimate - DB | Effort Estimate - UI | Effort Estimate - API | Effort Estimate - Test | Effort - Total | Elapsed time Estimates | Issues/Dependancies | Assigned sprint | Total Points | Completed | Burn Down Calculation | REL | Notes
48 | Adminsitration | Extension of Adminstration functionallity to support any new requirements delivered in phase II  & proposed for III - maintenance of dept information, association of depts with themes, delegation of group maintenance. | To be delivered with NEWLOOK user interface | 1 | 2 | 3 | Enhancement Request | 20 | 2011-09-21 00:00:00 |  |  | 100 |  | 50 | 150 | 14 | Deployment to LIVE dependent on delivery of replacement servers infrastucture by ISD
16a | Application Architecture | Import of Awards into Activities Table |  | 1 | 1 | 3 | Enhancement Request | 20 | 2011-09-21 00:00:00 | 10 | 20 |  |  | 10 | 40 | 1 |  |  |  |  |  |  | Completed
16 | Funding | Discrimination between project and award |  | 1 | 2 | 2 | Project Deliverable | 20 | 2011-09-21 00:00:00 | 50 | 40 | 75 |  | 50 | 215 | 14 |  |  | 215 |  | 215 |  | Completed
9 | Interface & Usability Enhancements | Activities/Projects – need a rubric to more clearly explain what is meant by a research activity |  | 4 | 3 | 2 | Project Deliverable | 20 | 2011-09-21 00:00:00 |  |  | 1 |  | 1 | 2 | 1 | Addressed by communications and integration of projects as  particular type of activity |  | 2 |  | 2
8 | External Interfaces | Research group pages should be able to provide a display of selected publications associated with each research group |  | 2 | 2 | 2 | Project Deliverable | 21 | 2011-10-05 00:00:00 | 20 | 20 |  | 80 |  | 120 | 14 |  |  | 120 |  | 120
755 | Application Architecture | Inconsistent application of permissions to edit IRIS profiles* | Phase III | 3 | 2 | 1 | Defect | 21 | 2011-10-05 00:00:00 |  | 15 | 15 |  |  | 30 | 3 |  |  | 30 |  | 30
34 | External Interfaces | IRIS Data available for PAR* |  | Declined | 2 | 2 | Project Deliverable
26 | External Interfaces | Export of limited sub-set of Researchers personal profile plus selected publications for consumption by external webistes  - (Core Profile & Selected Publications) | Phase III | 2 | 2 | 2 | Project Deliverable | 22 | 2011-10-19 00:00:00 | 50 | 100 |  | 40 | 25 | 215 | 14 |  |  | 215 |  | 215
1642 | REF - Publications | Ability to select REF output candidate by flagging with a checkbox which publications are to be categorised as REF submission | Now implemented in RPS | 2 | 3 | 2 | Project Deliverable |  |  |  |  |  |  |  |  |  | REF output slection will be supported by RPS |  | 0 |  | 0 |  | Completed
25 | External Interfaces | Export of Research Group data to include basic summary and membership information & selected publications  - (Core Profile & Selected Publications) |  | 3 | 2 | 2 | Project Deliverable | 23 | 2011-11-02 00:00:00 |  |  |  | 40 | 25 | 65 | 5 |  |  | 65 |  | 65
33 | External Interfaces | IRIS Data available for Senior Promotions application* |  | Declined | 2 | 2 | Project Deliverable |  |  |  |  |  |  |  |  |  | To be implemented by process change to Senior Promiotion to reference the IRIS data, there will be no requirement to integrate the systems technically
32 | External Interfaces | Export of Profile Data as Word format |  | 2 | 2 | 2 | Project Deliverable | 24 | 2011-11-16 00:00:00 |  |  | 100 |  | 50 | 150 | 14 | Protype completed - technology dependancy on php extensions  enabled on live servers |  | 150 |  | 150
30 | Application Architecture | Development of Reports Interface | To be Implemented in MSSQL Server 2008 R2 - Reporting Services | 2 | 2 | 2 | Project Deliverable | 24 | 2011-11-16 00:00:00 | 200 | 100 | 200 |  | 100 | 600 | 28 | Dependant on delivery of LIVE reporting server infrastucture by ISD |  | 600 |  | 600
1653 | Interface & Usability Enhancements | Editor plug-in does not provide a consistent or acceptable editing experience |  | 2 | 2 | 1 | Defect | 25 | 2011-11-30 00:00:00 |  | 15 | 50 |  | 50 | 115 | 7 |  |  | 115 |  | 115 |  | Completed
42 | Interface & Usability Enhancements | Inclusion of links to authored Moodle courses |  | Declined | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | Not considered significant, any hyperlink to a Moodle course can be added to the Teaching Summary
1693 | Interface & Usability Enhancements | Multiple minor display corrections |  | 4 | 3 | 1 | Defect | 25 | 2011-11-30 00:00:00 |  | 5 | 25 |  | 5 | 35 | 1 |  |  | 35 |  | 35 |  | Completed
50 | Application Architecture | Search of  Award  Detail |  | 3 | 3 | 3 | Enhancement Request | 27 | 2012-01-11 00:00:00 | 20 |  | 50 |  |  | 70 | 1 |  |  |  |  |  |  | Completed
1648 | Interface & Usability Enhancements | Edit of External Researchers and edit of external organizations need to be moved. | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 27 | 2012-01-11 00:00:00 |  | 25 | 50 |  | 25 | 100 | 4 |  |  | 100 |  | 100
17 | Application Architecture | Profiles for Post Graduate Research Students - see item 17 |  | Declined | 3 | 2 | Project Deliverable |  |  |  |  |  |  |  |  |  | Dependant on implementation of Portico opt in for public display of data |  | 0 |  | 0
36 | Interface & Usability Enhancements | Re-skin of IRIS application to align with UCL look and feel and be consistent as possible with the Institutional template* | To be delivered with NEWLOOK user interface | 1 | 2 | 3 | Enhancement Request | 28 | 2012-01-25 00:00:00 | 300 |  | 250 |  |  | 550 | 42
 | Application Architecture | Review and Replacement of redundant ' [NAME]' templates |  | Declined | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | No longer relavent as new UI design will be implemented in JAVA
1660 | Interface & Usability Enhancements | Check box in Profile to permit use of data in another application |  | 3 | 2 | 3 | Enhancement Request | 28 | 2012-01-25 00:00:00 | 10 | 10 | 20 |  |  | 40 | 4 |  |  | 40 |  | 40
3 | Interface & Usability Enhancements | Ability to restrict the display of publications to  ‘Selected publications’ by flagging with a checkbox which publications are to be globally visible | Now implemented in RPS | 2 | 2 | 2 | Project Deliverable | 29 | 2012-02-08 00:00:00 | 20 | 20 | 100 |  | 40 | 180 | 14 |  |  | 180 |  | 180 |  | Completed
51 | Interface & Usability Enhancements | Suport for Multiple bibliographic display formats | To be delivered with NEWLOOK user interface |  |  |  | Enhancement Request | 30 | 2012-02-22 00:00:00 | 25 |  | 75 |  | 100 | 200 | 14
46 | Application Architecture | Rationalisation of research service applications infrastructure - migration of webservices - php upgrade - reduction of redundant tables |  | 1 | 2 | 3 | Enhancement Request | 31 | 2012-03-07 00:00:00 | 40 | 80 |  |  | 50 | 170 | 7 | Deployment to LIVE dependent on delivery of replacement servers infrastucture by ISD
52 | Data Management Utilities | Multiple bibliographic export types | Now implemented in RPS | 1 | 2 | 3 | Enhancement Request | 31 | 2012-03-07 00:00:00 | 50 |  |  | 150 | 100 | 300 | 12
1694 | Data Management Utilities | Utility or script required to consolidate duplicate external organizations. |  | 2 | 3 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 | 20 | 20 |  |  | 25 | 65 | 7 |  |  | 65 |  | 65
1890 | Interface & Usability Enhancements | Add the name of the creator of activity - where activities are listed in admin |  | 2 | 2 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 |  | 20 | 20 |  | 20 | 60 | 1 |  |  | 60 |  | 60
29 | REF - Units of Assessment | User interface for association of individual with UoA | Now implemented in RPS | 1 | 2 | 2 | Project Deliverable |  |  |  |  |  |  |  |  |  | Functionality will implected |  | 0 |  | 0 |  | Completed
1645 | Interface & Usability Enhancements | Change of display by allowing user to control the sort order of funding | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 |  | 10 | 20 |  | 20 | 50 | 5 |  |  | 50 |  | 50
1644 | Interface & Usability Enhancements | Change of display by allowing user to control the sort order of Activities | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 |  |  | 20 |  | 20 | 40 | 5 |  |  | 40 |  | 40
1643 | Interface & Usability Enhancements | Control of display by changing sort order of publications | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 |  |  | 20 |  | 20 | 40 | 5 |  |  | 40 |  | 40
10 | Interface & Usability Enhancements | Activity requires a final tab – ‘Partners’ to capture external partners. Collaborators are individuals – Partners will be captured at the organization level e.g. Transport for London,  Nokia, Thales, UK Border Agency |  | 4 | 3 | 3 | Enhancement Request | 32 | 2012-03-21 00:00:00 | 10 | 10 | 5 |  | 10 | 35 | 1 |  | 12 | 35 |  | 35
47 | Interface & Usability Enhancements | User preference retention. |  | Declined | 2 | 3 | Enhancement Request |  |  | 40 | 40 | 50 |  | 50 | 180 | 14 | No longer relavent in new UI design
1679 | Application Architecture | Appointment History - does not use external organization |  | 3 | 3 | 3 | Enhancement Request | 33 | 2012-04-18 00:00:00 |  | 50 | 5 |  | 50 | 105 | 7 |  |  | 105 |  | 105
38 | External Interfaces | Interfaces to prospective collaboration service | Phase IV - consideration | 3 | 2 | 3 | Enhancement Request | 34 | 2012-05-02 00:00:00 | 100 |  |  |  |  | 100 | 14 | Sharepiont identified as development platform for Collaboration
55 | Interface & Usability Enhancements | Increase flexibility of display of search results - allow contol of display to sort by rank or date for publicitions (xml results) | To be delivered with NEWLOOK user interface | 1 | 2 | 1 | Defect | 35 | 2012-05-16 00:00:00 | 40 | 40 | 150 |  |  | 230 | 14 | Requires the interface to consume the results as raw xml data rather than relying on the funnelback configuration files
44 | External Interfaces | Interface with UCL Experts |  | 3 | 2 | 3 | Enhancement Request | 36 | 2012-05-30 00:00:00 |  |  |  | 150 |  | 150 | 14 | Available via web-services |  |  |  |  |  | Completed
39 | External Interfaces | Syndication services - Mendeley | Phase IV - consideration | 3 | 2 | 3 | Enhancement Request | 37 | 2012-06-13 00:00:00 | 40 |  |  | 80 |  | 120 | 14
1675 | Interface & Usability Enhancements | Image Display for Themes should support multiple cycling images | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 35 | 2012-05-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0 |  | 0
37 | Interface & Usability Enhancements | IRIS + (extension of system elements to cover all staff groups) |  | 2 | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | Required agreement of HR and Project Board - to extend scope generally - proposal declined. The techical changes have been completed and permit IRIS profiles to be enabled on an idividual basis |  |  |  |  |  | Completed
40 | External Interfaces | Integration with Collexis | Phase IV - consideration | 3 | 2 | 3 | Enhancement Request | 38 | 2012-06-27 00:00:00 | 100 |  |  | 180 |  | 280 | 28
31 | REF - Units of Assessment | Report - Publications by unit of assessment | Now implemented in RPS | 2 | 2 | 2 | Project Deliverable |  |  | 75 | 50 | 10 | 40 | 140 | 315 | 21 | Functionality to be provided by Reporting module and/or Symplectic Elements REF module |  | 315 |  | 315 |  | Completed
1646 | Interface & Usability Enhancements | Support of inline images in Research Activities | Phase IV - consideration | 3 | 3 | 3 | Enhancement Request | 39 | 2012-07-11 00:00:00 |  |  | 5 |  |  | 5 | 1 |  |  | 5 |  | 5
43 | Interface & Usability Enhancements | Tag cloud representation of keywords |  | Declined | 2 | 3 | Enhancement Request |  |  | 5 |  | 25 |  |  | 30 | 3 | No longer considered relevent within the application
1676 | Interface & Usability Enhancements | Support of Superscript and subscript to display Chemical Formula | To be delivered with NEWLOOK user interface | 3 | 3 | 3 | Enhancement Request | 39 | 2012-07-11 00:00:00 |  |  |  |  | 5 | 5 | 1 |  |  | 5 |  | 5
45 | Research Equipment | Capture of methodologies and access to equipment |  | Declined | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | This inititiative will be developed as a separate project
49 | Research Equipment | Search support for Research Equipment, Research Platforms |  | Declined | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | This inititiative will be developed as a separate project
41 | Application Architecture | Integration with Research Services Documentum records | Pilot - in progress | 3 | 2 | 3 | Enhancement Request | 40 | 2012-07-25 00:00:00 | 50 |  |  |  |  | 50 | 7
35 | Interface & Usability Enhancements | Provision of RSS feed of new/updated research activities | Phase IV - consideration | 4 | 2 | 3 | Enhancement Request | 40 | 2012-07-25 00:00:00 |  | 10 | 40 |  |  | 50 | 5
37 | Interface & Usability Enhancements | Development of Display of International Collaborators | To be Implemented in MSSQL Server 2008 R2 - Reporting Services | 1 | 2 | 3 | Enhancement Request | 39 | 2012-07-11 00:00:00 | 100 | 40 | 100 | 100 | 100 | 440 | 14 | Dependant on delivery of LIVE reporting server infrastucture by ISD
53 | Research Equipment | Internal Research Equipment Database |  | Declined | 2 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | This inititiative will be developed as a separate project
54 | Reporting Function | Build re-usable library of ad-hoc queries generated by users |  | 2 | 2 | 2 | Project Deliverable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
58 | External Interfaces | Creation of collaboration triplets for export in external visualization application |  | 3 | 3 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
56 | Application Architecture | Association of Publications with Award/Research Activity | Phase IV - consideration | 1 | 1 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | Dependent of extension of ESRC - services to all RCUK
57 | External Interfaces | Integtration with RCUK - ROS (Research Outcomes System) | Phase IV - consideration | 1 | 1 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | Dependent of  RCUK - roadmap for the HEI interfaces to ROS
59 | Interface & Usability Enhancements | Display icon to show whether an Academic is accepting students | Phase IV - consideration | 2 | 1 | 3 | Enhancement Request |  |  |  |  |  |  |  |  |  | Requirement Requested by Faculty of Engineering/Graduate Recruitment
60 | External Interfaces | Include Primary Department association in XML search results | Phase IV - consideration | 2 | 2 | 3 | Enhancement Request
Total |  |  |  |  |  |  |  |  |  | 390 | 335 | 211 | 420 | 256 | 1612 | 140 |  |  | 2587 |  | 2587
Total Available |  |  |  |  |  |  |  |  |  | 1320 | 1040 | 1320 | 1320 |  | 5000