Technical Infrastructure Operational Practices

2. Technical Infrastructure Operational Practices Table of Contents of Spreadsheet Examples: Item: TabOfSheet: 1 2 3 4 5 6 7 8 9 Short version Intro 20TopUniversitiesIT ICT_Development_xls CriteriaCrosswalk.xls .ppt Google AppendixA(1) .xls Google AppendixB(1) .ppt MSN AppendixA(2) .xls MSN.com AppendixB(2) Sample VBA (Visual BASIC for Application) Code: Sub ProcessComplexity() ' ProcessComplexity Macro ' Macro recorded 6/14/2001 by Sara Johnson ' With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=$R$4:$R$7" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "Error Process Complexity" .InputMessage = "" .ErrorMessage = "You must enter a value between 1-3!" .ShowInput = True .ShowError = True End With Selection.Locked = False Selection.FormulaHidden = False End Sub Sub ProtectBox() ' ' ProtectBox Macro ' Macro recorded 6/14/2001 by Sara Johnson ' ' With Selection .Locked = True .LockedText = True End With With Selection .Placement = xlFreeFloating .PrintObject = True End With End Sub al Infrastructure Operational Practices Topic: eadsheet Examples: Company rating POSITION DESCRIPTION PROFILE FOR INFORMATION TECHNOLOGY POSITIONS (DA-313) Top 20 National Research Universities, IT Initiatives, by ranking How ICTs can help achieve the Millennium Development Goals Extent to which high-level design or operational concepts are defined. ... Google Search: .xls Technical Infrastructure and Operational Practices Google Search: .ppt Technical Infrastructure and Operational Practices MSN.COM Search: .ppt Technical Infrastructure and Operational Practices MSN.COM Search: .XLS Technical Infrastructure and Operational Practices al BASIC for Application) Code: 14/2001 by Sara Johnson ValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ mula1:="=$R$4:$R$7" rror Process Complexity" = "You must enter a value between 1-3!" aHidden = False 14/2001 by Sara Johnson lFreeFloating Company rating Company name: Date: Rate the following statements on a scale of 0 - 5. Rating The reputation of our company is very good Reputation We have a detailed, written business plan Our business plan is extensively used as a management tool We have a high priority to export our services Everyone in our company knows our priority to export our services We help each other within our company (also between departments) We believe in professionalism and commitment (0: business plan does not exist) (0: business plan does not exist) The top management has a high level of technology understanding The top management has a strong background in technology The top management has a strong background in business administration The top management is fully aware of IT industry trends The management adapts new leadership methods Management The management is willing to change We have a professional management team The management is highly motivated The management provides leadership The management is focused Our management has an open style The management is ready and committed to export IT services/products to the EU The management actively helps to solve problems The management promotes and facilitates self-development The management delegates operational issues Page 4 Company rating Company name: Date: Rate the following statements on a scale of 0 - 5. Rating We have a strong local client base We have a strong regional client base We make our technology/marketing/product related decisions based on foreign market needs We have a strong client base in Europe We have a strong client base in the US We focus on project based software development We focus on software product development We know the EU market very well We have an export marketing plan Markets and clients We have export marketing budget available We have a professional marketing team We have a well defined and clearly communicated selling proposition We have capacity to carry out projects for foreign clients We have professional printed marketing material We have a professionally designed web site The overall quality of our web site is very good We use our web site as a marketing tool Our web strategy is well defined and clearly communicated We offer very flexible contracting options We are prepared to take and share risks We always look for long term partnerships Our clients are highly satisfied with our services We have a strong reference list We know that we are very price competitive We regularly obtain and disseminate information on the latest outsourcing trends We deliver always on time and within budget Our company has a strong technical staff Our staff is highly motivated Most of our people are certified (Microsoft, Cisco, Linux, etc) Our company offers an extensive employment benefit package Our staff participates in training regularly Our staff selection process is formal and well documented Staff We evaluate our staff regularly Our staff evaluation process is formal and well documented We maintain a less than 10% annual staff turnover All of our people speak, write and understand English Our salary level is above average Page 5 Company rating Staff Company name: Date: Rate the following statements on a scale of 0 - 5. Rating We offer different bonuses to our staff We offer share options to our staff The work conditions in our office are very good Page 6 Company rating Company name: Date: Rate the following statements on a scale of 0 - 5. Rating We have an up to date internal IT infrastructure Everyone in our company has unlimited internet access Everyone in our company has e-mail Our technology portfolio is very strong Technology , processes We evaluate technology trends regularly We have several R&D programs running in our company We add new technologies to our technology portfolio regularly We have a fully defined and documented software engineering process We have a fully defined and documented project management process We have a fully defined and documented QA process We handle requirements changes very flexibly We master requirement engineering practices We plan all of our projects in great details We have a web based project monitoring system We have a formal quality certification (CMM, ISO, etc) We constantly improve quality assurance and key processes Our on-site security is up-to-date Our IT infrastructure security is up-to-date Adjusted score Reputation Management Markets and clients Staff Technology & processes Overall score Consultant's rating Final score Unadjusted score Reputation Management Markets and clients Staff Technology & processes Total unadjusted score 5 (0: if no, 5: if yes) (0: if no, 5: if yes) -0.1 -0.1 -0.1 -0.1 0.2 0.0 0.0 =IF((D104+$E$109)>5, 5, D104+$E$109) =IF((D105+$E$109)>5, 5, D105+$E$109) =SUM(D8:D14)/COUNTA(reputation) 5 5 0.0 =SUM(D8:D14)/COUNTA(reputation) 0.0 0.0 0.0 0.3 0.1 -0.083333333 Page 7 Reputation 5.0 4.0 3.0 2.0 Technology & processes 1.0 -0.1 Management 0.2 0.0 -0.1 -1.0 -0.1 -0.1 Staff Markets and clients DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES POSITION DESCRIPTION PROFILE FOR INFORMATION TECHNOLOGY POSITIONS (DA-313) INTRODUCTION What Is Form DA-313? The Position Description Profile for Information Technology Positions (DA-313, rev. 6-01) replaces the Position Description form (DA-281-2, rev. 1-86) for classified civil service positions in Kansas state government designated as being in the Information Technology (IT) occupational field. It describes the job responsibilities, knowledge requirements, and skill requirements of incumbents in these positions. DA-313 may also be used for unclassified IT positions, if desired. IT and HR specialists throughout Kansas state government experienced difficulty using form DA-281-2 for classifying IT positions. With the DA-281-2's free-form text descriptions of IT positions, the levels of detail and clarity varied widely among state organizations. This hindered precision and consistency in assigning position classes. IT employees and supervisors struggled to adequately and completely describe their positions within the Position Description (PD) form, and non-technical classifiers struggled to understand the technical language employed in those descriptions. In an attempt to make the classification process less time consuming for those who prepare and review PDs, and to remove the perceived subjectivity in the classification process, the state Division of Personnel Services (DPS) released a Position Description Profile form in August, 2000. While a step in the right direction, this form had enough shortcomings that DPS convened a workgroup of IT and Human Resources (HR) personnel to develop a replacement. With a revised or replacement IT PD Profile, DPS aimed to: o o o Enhance functionality of the form - make it useful for many purposes in managing positions and personnel; Make it easier to use - reduce the confusion, multiple interpretations and effort associated with the earlier forms; make the technical content easier to understand; Improve consistency of position descriptions and classifications - ensure positions of equivalent responsibilities and performing comparable jobs receive equal treatment across different state organizations. Why Have Form DA-313? How Was Form DA-313 Developed? From December 2000 through June 2001, a 22-member workgroup met weekly to devise, test and implement the IT PD Profile. The group consisted of 11 HR specialists and 11 IT specialists, from DPS, the state Division of Information Systems and Communications (DISC), the University of Kansas, Kansas State University, the Highway Patrol, the Board of Regents, and the state Departments of Aging, Administration, Commerce and Housing, Revenue, Social and Rehabilitation Services, and Transportation. This wide variety of participants represented IT positions which were deep (highly focused and skilled in a particular technical specialty), broad (having general responsibilities across many technical specialties), or somewhere in between. The workgroup recognized the importance of validating their assumptions in the real world. After the first draft of the form was completed, it was submitted to an Alpha Test group of over 160 IT personnel in the represented organizations. The data on the Alpha Test forms was combined with data compiled by the workgroup from existing class specifications to create first-round template profiles for each of the major IT classifications in the state. After instructions and reference material were developed, the draft DA-313 was again distributed to a subset of the Alpha Test group, to obtain their recommendations on material needed in training classes to be conducted during the summer of 2001. (continued on next page) DA-313 - Part 1 Rev. 2/2005 Page 9 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES The workgroup recognized that ease of use, clarity, precision and objectivity could best be promoted How Is by having components of the IT PD Profile in a checklist format - a prescribed, commonly-defined list Form of characteristics - in contrast to the vagaries of free-form text. The group had to make a fundamental DA-313 Structured? decision about how to structure such a checklist. Rather than develop a unique set of descriptors for IT jobs, the group chose to base much of the IT PD Profile on two standards emerging elsewhere in Kansas state government: o o The Kansas Statewide Technical Architecture (KSTA), for a description of the technologies and products used and supported within Kansas state government; and Control Objectives for Information Technology (COBIT), an international industry and government standard for auditing IT operations, which includes a comprehensive description of 34 generic IT Processes, categorized into four IT Domains. The Concept section of this document further describes how these standards relate to each other, and how they are applied within the IT PD Profile. The new DA-313 also contains several areas of "traditional" information carried over from the original DA-281-2 (organizational context, supervisory relationships, minimum knowledge and skill requirements, etc.). This breadth of data in one form makes it highly versatile for many aspects of managing IT positions and personnel within Kansas state government. How Do You Define "Success" In This Effort? DA-313 satisfies the following Success Factors for this effort: o o Collaboratively designed document - both HR and IT communities strove to accommodate each others' business requirements as well as their own. Meets the needs of a variety of users - the form is valuable for planning, recruiting, supervision, and evaluation as well as for classification. Easy to complete and review - while an initial learning curve can be expected due to the different concept and layout, maintaining and using these position descriptions, once defined, should be much easier than with earlier forms. Positions defined objectively - those who prepare and use the DA-313 all work from a common set of instructions and definitions; the data from the form supports quantitative analysis within a database. Integrity of the classification system is maintained - HR and IT specialists determine the best fit of each Profile when matched against standard templates for IT classes and levels; classification decisions are consistent across all state organizations. Dynamic document - with its electronic format, the DA-313 can be readily adapted to add or remove technologies and duties in consonance with the regular changes in the world of Information Technology, as reflected in revisions to the KSTA and COBIT documents. Viable management tool - the detail in the standard checklists, coupled with the ability to add or remove technologies and duties as needed by the organization and essentially customize the Profile for each IT position in the state, make this a comprehensive and flexible tool for managing both positions and people. o o o o o DA-313 - Part 1 Rev. 2/2005 Page 10 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES ELECTRONIC FILE CONTENTS WORKSHEET TAB SECTION TITLE PAGE * CONTENTS Part 1 IT PD Profile - Part 1 N/A Form DA-313 Part 1, General Position and Organization Information Form DA-313 Part 2, Essential Technology Items Form DA-313 Part 3, IT Domains, Processes and Tasks Date and signature blocks for the employee, the employee's supervisor, the organization's Personnel official, and the agency head, appointing authority or designee Why form DA-313 exists Contents of each section (worksheet tab) of the DA-313 package Part 2 Part 3 IT PD Profile - Part 2 IT PD Profile - Part 3 Affirmation N/A N/A N/A Intro Introduction Electronic File Contents 1 3 KSTA Overview: KSTA Technology Taxonomy Overview: COBIT Domain and Process Definitions 5 Summary of the technology taxonomy (divisions or groupings) in the Kansas Statewide Technical Architecture (KSTA) Summary of the IT Domains and Processes defined in Control Objectives for Information Technology (COBIT), as they apply to the Position Description Profile for IT Positions How DA-313 is organized, and how the three Parts are used General instructions for completing all three parts of DA-313, either on paper or electronically Detailed instructions for completing Part 1 of form DA-313 COBIT 7 Design Basics Form Design Form Basics 13 15 Part 1 Instr. IT PD Profile Detailed Instructions - Part 1 IT PD Profile Detailed Instructions - Part 2 Technology Complexity Code Definitions Proficiency Level Code Definitions 21 Part 2 Instr. 27 Detailed instructions for completing Part 2 of form DA-313 29 Definitions of the Technology Complexity Codes used in Part 2 of form DA-313 Definitions of the Proficiency Level Codes used in Part 2 of form DA-313 (continued on next page) 29 DA-313 - Part 1 Rev. 2/2005 Page 11 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES WORKSHEET TAB SECTION TITLE PAGE * CONTENTS Part 3 Instr. IT PD Profile Detailed Instructions - Part 3 Questions to Consider When Identifying "Essential" Tasks (Duties or Functions) Responsibility Level Code Definitions IT Process Complexity Code Definitions 31 35 Detailed instructions for completing Part 3 of form DA-313 In identifying tasks performed by the incumbent in an IT position, you must indicate whether or not each task is considered "essential" for the position. The questions help managers and supervisors make that determination. Definitions of the Responsibility Level Codes used in Part 3 of form DA-313 Definitions of the IT Process Complexity Codes used in Part 3 of form DA-313 Column widths and other formatting information to print, as intended, each of the three parts of form DA-313 36 37 Printing Printing Instructions 39 Quick Instr. Quick Instructions 45 One-page summary of instructions for three Parts of DA-313 * Page Number will vary, depending on which sections (worksheet tabs) the user selects to print. The page numbers shown in this table are effective when all sections (tabs) from "Intro" to "Quick Instr.", inclusive, are printed together. Page numbers are not shown for the blank form Parts of DA-313, since the page count will vary from one PD Profile to the next, depending on which rows are added to or excluded from the final version. DA-313 - Part 1 Rev. 2/2005 Page 12 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES OVERVIEW: KANSAS STATEWIDE TECHNICAL ARCHITECTURE (KSTA) TECHNOLOGY TAXONOMY KSTA specifies 18 general categories of technology (Architectures), for which it identifies standards, documents principles and best practices, and describes products used within Kansas state government. Each of these Architectures has its own KSTA chapter. The chapters are grouped within six sections. Since the KSTA chapters dealing with individual Architectures start their numbering with Chapter 4 rather than Chapter 1, this Position Description Profile (DA-313) uses a different identification scheme, as shown below. The full KSTA document can be found online at http://da.state.ks.us/itec/ITECKSTAMain.htm. KSTA CHAP DA-313 ID A KSTA CHAPTER / DA-313, PART 2 SECTION NETWORK CONTENTS 4 A-1 Physical Network The wiring, leased circuits, connecting and routing devices, and other components of voice and data telecommunications The protocols, software and disciplines needed to manage the physical network and telecommunications services Data connection and communication services based on the standard set of "Internet" protocols 5 A-2 Network Management 6 A-3 Internet / Intranet B PLATFORMS 7 B-1 Platforms Computer hardware, system software, and peripheral devices used to accomplish state business Data storage devices and networks which are used by computing platforms 8 B-2 Storage C SYSTEM MANAGEMENT 9 C-1 Asset Management The software and practices needed to plan and track hardware and software assets The software and practices needed to monitor and manage information system operations The software and practices needed to detect and respond to problems with information systems The software and practices needed to manage version changes in the system's hardware and software components Facility preparation, contingency planning and disaster recovery measures to restore IT services after a loss (continued on next page) 10 C-2 Console Event Management 11 C-3 Help Desk and Problem Management Change and Configuration Management Business Continuity 12 C-4 13 C-5 DA-313 - Part 1 Rev. 2/2005 Page 13 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES KSTA CHAP DA-313 ID D KSTA CHAPTER / DA-313, PART 2 SECTION APPLICATIONS CONTENTS 14 D-1 Application Development and Management Application Structure The software tools, processes and products associated with acquiring or developing application software Design patterns for application software, and methods for describing the patterns Common design standards and run-time services used by application software Common application services available to end users 15 D-2 16 D-3 Application Infrastructure Services Workgroup Services INFORMATION 17 D-4 E 18 E-1 Data Management The software and practices needed to ensure the availability and integrity of stored data How data resources are applied to meet sometimes contrary requirements for security, privacy and freedom of information How data resources are applied to meet requirements for government record retention, archiving and disposal 19 E-2 Information Management 20 E-3 Records Management and Preservation SECURITY F 21 F-1 Security The hardware, software and practices needed to ensure only authorized personnel have access to state information systems, and that systems are protected from malicious attack DA-313 - Part 1 Rev. 2/2005 Page 14 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES OVERVIEW: CONTROL OBJECTIVES FOR INFORMATION TECHNOLOGY (COBIT) DOMAIN AND PROCESS DEFINITIONS The State of Kansas has adopted COBIT standards as the framework for defining and evaluating Information Technology (IT) processes and job tasks. A complete understanding of what is contained within COBIT can be derived from documentation prepared by the Information Systems Audit and Control Association, or from formal training which ISACA conducts. This is a summary of the IT Domains and Processes defined in COBIT, as they apply to the Position Description Profile for Information Technology Positions. Italicized text is taken verbatim from COBIT documentation. COBIT documents are available online at either http://www.isaca.org/cobit.htm or http://www.itgovernance.org/resources.htm. IT DOMAIN: PLANNING & ORGANIZATION (PO) This domain addresses strategy and tactics and concerns itself with the identification of the way IT can best contribute to the achievement of the business objectives. There is a focus on planning, communicating, and managing the strategic vision from different organizational perspectives and to having a proper organization as well as technological infrastructure in place. PO1 Define a Strategic IT Plan Business goal: strike an optimum balance of information and technology opportunities and IT business requirements as well as ensuring the Strategic IT Plan's further accomplishment. A Strategic IT Plan is the long-range (3 to 5 year) map of where an organization intends to go with its IT services and infrastructure. IT resources should be implemented to support the business needs of the organization, and the business operations of the organization need to take advantage of the capabilities which IT resources can provide. IT resource development within the organization needs to comply with IT directions established for Kansas state government; and the state needs to consider the needs of each organization when establishing these enterprise-level directions. The Strategic IT Plan is the basis for short-term plans for system development and implementation. Tasks under this IT Process support the areas of coordination and plan preparation. PO2 Define the Information Architecture Business goal: optimize the organization of information systems. The key corporate asset which IT resources manage is the organization's business data. The Information Architecture establishes how the business data is defined; how it is structured (e.g., database tables and columns); how it is made accessible to application software; and the level of protection required for each data element. This IT Process covers definition of data requirements, data modeling, and data administration. Determine Technological Direction Business goal: take advantage of available and emerging technology to drive and enable business strategy. There are many technology-based solutions which could fit the organization's strategic direction (from PO1) and Information Architecture (from PO2). Under PO3, these alternatives are explored for the best fit with the organization's current technology, intended direction, and business needs. The selected technology directions are documented in infrastructure plans and in standards for the organization. Choices must be made within the context of statewide standards; and the establishment of statewide standards needs to consider technology needs of constituent organizations. Tasks under this IT Process support research, analysis, planning and coordination. Define the IT Organization and Relationships Business goal: deliver the right IT services. In this process, the organization describes its requirements for adequate staff to manage the infrastructure defined in PO3. Organization, roles and responsibilities for IT positions are detailed, as are expected external relationships. PO3 PO4 DA-313 - Part 1 Rev. 2/2005 Page 15 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES PO5 Manage the IT Investment Business goal: ensure funding and control disbursement of financial resources. An organization's financial investment in IT can be substantial. Tasks under this IT Process deal with managing that investment. System costs (for both development and operation) should be justified in terms of business benefit, whether quantitative or qualitative. Planned expenditures must be budgeted and funded through applicable sources. Actual costs incurred and actual benefits realized should be compared to determine if systems are meeting financial objectives, and if the organization's investment decision process is working as intended. There is a close relationship between the COBIT IT Processes PO5, DS1 and DS6. Communicate Management Aims and Directions Business goal: ensure user awareness and understanding of [management] aims. The user community and IT staff need clear, unambiguous, comprehensive, readily-available and relevant direction in how the organization's information systems are to be operated and managed. Tasks under this IT Process produce the necessary policies and procedures. Manage Human Resources Business goal: maximize personnel contributions to the IT processes. Tasks under this IT Process provide the individuals needed to meet staffing requirements identified under PO4. Standard HR functions are covered, such as recruiting and hiring, training, and assignment and evaluation of work. These tasks also recognize the special attention that should be paid to areas of IT staff retention and professional growth, factors which can position state organizations as competitive employers in a high-demand labor market for skilled IT personnel. Ensure Compliance with External Requirements Business goal: meet legal, regulatory and contractual obligations. Tasks under this IT Process require that all external mandates for the organization's information systems be identified, and that compliance with these mandates be formally validated. Assess Risks Business goal: support management decisions in achieving IT objectives and responding to threats by reducing complexity, increasing objectivity and identifying important decision factors. Every IT implementation faces risks of interrupted service. Common areas of risk include technical (e.g., hardware failure or software obsolescence), security (e.g., unauthorized system intrusion), environmental (e.g., fires or natural disasters), and financial (e.g., costs greatly exceeding budget). Tasks under this IT Process support identification of significant risks to the organization's IT infrastructure, determining the organization's vulnerability to these risks, and planning of activities to reduce the potential impact of these risks. There is a close relationship among the COBIT IT Processes PO9, DS4, DS5 and DS12. PO6 PO7 PO8 PO9 PO10 Manage Projects Business goal: set priorities and deliver [project results] on time and within budget. Major changes or additions to an organization's IT infrastructure are frequently managed as named projects, with their own objectives, schedule, staff, and budget. Tasks under this IT Process support the necessary oversight, planning, resourcing, coordination, management and execution of IT projects. PO11 Manage Quality Business goal: meet the IT customer requirements. Quality Assurance (QA) activities are intended to promote delivery of IT services to users at the intended levels of functionality, performance, reliability and integrity. Tasks under this IT Process support identification of the QA measures to be applied to an organization's IT services; conduct of regular QA measurements and operational adjustments; and periodic, formal reviews of QA activities to validate their continued effectiveness. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4. DA-313 - Part 1 Rev. 2/2005 Page 16 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES IT DOMAIN: ACQUISITION & IMPLEMENTATION (AI) This domain addresses the need to identify, develop, acquire, implement and integrate IT solutions into the organization’s business processes. It covers changes in and maintenance of existing systems in order to make sure that the life cycle of these systems is continued for these systems. AI1 Identify Automated Solutions Business goal: ensure the best approach to satisfy the user requirements. The Strategic IT Plan and its derivative tactical plans (PO1), the Information Architecture (PO2), and the technological direction selected for the organization (PO3) serve as the context within which requirements analysis is performed. Tasks under IT Process AI1 support this detailed identification of business requirements; analysis of alternative solutions to find the best fit to the requirements and the organization's ability to execute; and formulation of an acquisition strategy to implement the selected solution. Note: in COBIT, "acquisition" refers to whatever steps are taken to introduce new IT capabilities in an organization, which can mean "development" as well as "purchase." AI2 Acquire and Maintain Application Software Business goal: provide automated functions which effectively support the business process. "Application software" consists of the executable code, data stores, and procedures needed to perform business functions for the organization. Tasks under this IT Process cover the stages of implementing application software: application requirements determination, application design, acquisition of software (through either purchase, gift or development), testing, documentation, and maintenance-related changes. Acquire and Maintain Technology Infrastructure Business goal: provide the appropriate platforms for supporting business applications. Tasks under this IT Process cover the stages of implementing and supporting components of an IT system other than application software [see AI2]: system requirements determination, system design, acquisition (through either purchase, gift or development) and configuration of system components, testing, documentation, trouble diagnosis and repair, and maintenance-related system changes. Develop and Maintain Procedures Business goal: ensure the proper use of the applications and technological solutions put in place. Tasks under this IT Process produce and maintain documentation (including training material) needed by system users and system support staff. There is a relationship among COBIT IT Processes AI4, AI5 and DS7. Install and Accredit Systems Business goal: verify and confirm that the solution is fit for the intended purpose. Moving newly-acquired IT capabilities into production use should be a formal process, making certain that system capabilities successfully meet user needs, and that the system is approved by the organization's executive leadership. Tasks under this IT Process cover implementation planning, acceptance testing, site preparation, formal acceptance, system installation, migration activities, and initial training. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4; and a relationship among AI4, AI5 and DS7. AI3 AI4 AI5 AI6 Manage Changes Business goal: minimize the likelihood of disruption, unauthorized alterations and errors. In complex systems, any change can have unintended consequences. To minimize the risk of unpleasant surprises, and to help the IT organization prioritize its workload, there needs to be a formal process to request, review and approve changes to the current system. Tasks under this IT Process cover that sequence of events, and ensure that only the correct versions of system components and documentation are in production use. There is a close relationship between the COBIT IT Processes AI6 and DS9. DA-313 - Part 1 Rev. 2/2005 Page 17 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES IT DOMAIN: DELIVERY & SUPPORT (DS) This domain is concerned with the actual delivery of required services, which range from traditional operations over security and continuity aspects to training. In order to deliver services, the necessary support processes must be set up. This domain includes the actual processing of data by application systems, often classified under application controls. DS1 Define and Manage Service Levels Business goal: establish a common understanding of the level of service required. Performance expectations for information systems need to be clearly articulated and agreed to by both customers and suppliers of the services. Tasks under this IT Process cover documentation of desired service levels, negotiation of formal service level agreements, and activities to monitor how well the desired service levels are being achieved. There are close relationships among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4; among DS1, DS2, DS3, DS4 and DS13; and among PO5, DS1 and DS6. Manage Third-Party Services Business goal: ensure that roles and responsibilities of third parties are clearly defined, adhered to and continue to satisfy the requirements. IT services may need to be received from an external contractor, due to a short-term surge in requirements for skilled IT labor, a need for particular areas of expertise not found within the organization, or relative financial benefits from outsourcing. Tasks under this IT Process cover contract development, negotiation, and enforcement. There is a close relationship among COBIT IT Processes DS1, DS2, DS3, DS4 and DS13. Manage Performance and Capacity Business goal: ensure that the adequate capacity is available and that best and optimal use is made of it to meet required performance needs. Tasks under this IT Process help ensure that the organization's information systems are adequately sized to handle the level of activity which occurs. There is a close relationship among COBIT IT Processes DS1, DS2, DS3, DS4 and DS13. Ensure Continuous Service Business goal: make sure IT services are available as required and ensure a minimum business impact in the event of a major disruption. The organization should know in advance, and have tested, what steps it will take to restore IT services in case of major disruption (e.g., natural disaster or fire). Interim measures for business continuity may include manual procedures and non-electronic information resources (e.g., off-site copies of essential hard-copy files). Tasks under this IT Process cover planning, coordination and activities necessary for business continuity and system recovery. There is a close relationship among COBIT IT Processes DS1, DS2, DS3, DS4 and DS13. There is also a close relationship among PO9, DS4, DS5 and DS12. Ensure Systems Security Business goal: safeguard information against unauthorized use, disclosure or modification, damage or loss. It is critical that organizations protect their IT assets from damage due to malicious attack or user mistakes. Tasks under this IT Process support the planning, coordination, use of electronic tools, and procedures for user registration needed to obtain the intended level of system protection. There is a close relationship among the COBIT IT Processes PO9, DS4, DS5 and DS12. There is also a close relationship between DS5 and DS11. Identify and Allocate Costs Business goal: ensure a correct awareness of the costs attributable to IT services. Tasks under this IT Process cover financial accounting for IT system components and operations, and billing for chargeback to user organizations. There is a close relationship among the COBIT IT Processes PO5, DS1 and DS6. DS2 DS3 DS4 DS5 DS6 DA-313 - Part 1 Rev. 2/2005 Page 18 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES DS7 Educate and Train Users Business goal: ensure that users are making effective use of technology and are aware of the risks and responsibilities involved. Tasks under this IT Process cover identification of training needs, planning for training, developing training material, providing training facilities and resources, and delivering training. There are relationships between COBIT IT Processes DS7 and DS8, and among AI4, AI5 and DS7. Assist and Advise Customers Business goal: ensure that any problem experienced by a user is appropriately resolved. Tasks under this IT Process constitute the core functions of an organization's Help Desk: serving as the first point of contact for trouble reports or operational questions, assisting users resolve their own difficulties, directing technicians to respond when problems are beyond the user's ability to resolve, and compiling data on trends in system problems and incidents. There is also a consulting function here, in which IT staff assist users and managers meet their business objectives with available IT resources. There is a close relationship among COBIT IT Processes DS8, DS9 and DS10, and a relationship between DS7 and DS8. Manage the Configuration Business goal: account for all IT components, prevent unauthorized alteration, verify physical existence and provide a basis for sound change management. Tasks under this IT Process cover the activities needed to manage and troubleshoot components of the organization's IT infrastructure: documenting and maintaining an inventory of system components and how they interconnect; reviewing proposals for changes in system configuration; maintaining a software library; and tracking physical property. There is a close relationship between the COBIT IT Processes AI6 and DS9, and among DS8, DS9 and DS10. DS8 DS9 DS10 Manage Problems and Incidents Business goal: ensure that problems and incidents are resolved, and the causes investigated to prevent recurrence. Tasks under this IT Process result in formal steps for correcting and tracking system problems, documenting problem resolution, and identifying changes needed in the system configuration. There is a close relationship among COBIT IT Processes DS8, DS9 and DS10. DS11 Manage Data Business goal: ensure that data remains complete, accurate and valid during its input, update and storage. Tasks under this IT Process cover design, implementation, operation, and security of databases which fulfill the objectives of the Information Architecture (PO2) and meet the needs of various applications (AI2). Tasks also deal with data entry, validation, retention, archiving, backup, recovery, and disposal. There is a relationship between the COBIT IT Processes DS5 and DS11. DS12 Manage Facilities Business goal: provide a suitable physical surrounding which protects the IT equipment and people against manmade and natural hazards. The organization is responsible for providing (directly or through contract) the necessary physical security and appropriate environment (space, electrical power, air conditioning, fire protection, etc.) for its IT resources. Tasks under this IT Process cover the planning, delivery and monitoring of facility services. There is a close relationship among the COBIT IT Processes PO9, DS4, DS5 and DS12. DS13 Manage Operations Business goal: ensure that important IT support functions are performed regularly and in an orderly fashion. Tasks under this IT Process are traditionally associated with mainframe computer operations, but can be extended to any situation in which IT staff perform routine "shift" duties to monitor and control IT resources. Tasks cover documentation of standard and emergency procedures, control of machine operations, documentation of system events and errors, and procedures to be observed during shift changes. There is a close relationship among COBIT IT Processes DS1, DS2, DS3, DS4 and DS13. DA-313 - Part 1 Rev. 2/2005 Page 19 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES IT DOMAIN: MONITORING (M) All IT processes need to be regularly assessed for their quality and compliance with control requirements. This domain addresses management’s oversight of the organization’s control process and independent assurance provided by internal and external audit or obtained from alternative sources. M1 Monitor the Processes Business goal: ensure the achievement of the performance objectives set for the IT processes. Tasks under this IT Process determine whether IT Processes in the Planning and Organization, Acquisition and Implementation, and Delivery and Support Domains actually achieve their intended results. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4. Assess Internal Control Adequacy Business goal: ensure the achievement of the internal control objectives set for the IT processes. This IT Process determines the effectiveness of internal controls implemented in the organization's information systems. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4. M2 M3 Obtain Independent Assurance Business goal: increase confidence and trust among the organizations, customers and third-party providers. Under this IT Process, an objective third party determines whether the organization has, indeed, met various objectives for IT management. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4. Provide for Independent Audit Business goal: increase confidence levels and benefit from best practice advice. Under this IT Process, an objective third party reviews the financial and risk profiles of the organization's IT operation. There is a close relationship among the COBIT IT Processes PO11, AI5, DS1, M1, M2, M3 and M4. M4 DA-313 - Part 1 Rev. 2/2005 Page 20 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES POSITION DESCRIPTION PROFILE FOR INFORMATION TECHNOLOGY POSITIONS (DA-313) FORM DESIGN General The Position Description Profile for Information Technology Positions (DA-313, rev. 6-01) replaces the Position Description form (DA-281-2, rev. 1-86) for classified positions designated as being in the Information Technology field. The form may be either completed on paper, completed electronically (in a Microsoft Excel workbook) and printed for signatures on paper, or completed electronically and then digitally signed with a state-approved technique. DA-313 is in three parts: General Position and Organization Information. Similar to the DA-281-2 Position Description form, Part 1 provides organizational context, background and general description, supervisory relationships, minimum requirements on entry, and agency preferences for education, experience and certification licenses for the position. Essential Technology Items. A description of proficiency in essential information technology items (categories and, optionally, specific products) required of the position when the incumbent is functioning at a full performance level. IT categories are grouped according to sections in the Kansas Statewide Technical Architecture (KSTA) document. IT Domains, Processes and Tasks. A description of duties for the position, in the form of a checklist of standard process and task definitions for IT work. The structure of IT Domains and IT Processes comes directly from the Control Objectives for Information Technology (COBIT) standard. The IT Tasks are specific to work performed in Kansas state government. IT Task statements in Part 3, which describe a position's duties, are deliberately broad and generic. A Task such as AI6-02, "Assess impacts on the existing system of proposed changes; estimate level of effort required to implement" could apply to any of the IT focus areas (networks, server platforms, user platforms and information). The reason for having broad Task statements is that the IT Processes and Tasks will be relatively stable over time. Technologies may change, but the management and support activities which apply to the technologies will be consistent. Since IT position classification relies heavily on Part 3, such consistency is a stabilizing factor for organizations as they manage their positions, and for IT employees as they manage their careers. However, it is important to identify which technologies will be within a particular position's scope of work, and what level of proficiency is expected when the incumbent functions at the full performance level. Part 2 provides this information. Part 2 also informs position classifiers how complex the essential technologies are within the position's scope, and how broadly they apply within the organization; these are factors considered in determining the appropriate level of a position within a classification series. Generally, Part 2 will be more customized for each position, and will change more frequently over time, than will Part 3. In summary, Part 3 should be relatively stable; it defines the position's work from an IT management perspective. Part 2 can be relatively dynamic; it defines the technologies on which the Part 3 Tasks are performed. More detailed direction for an incumbent's job tasks, particularly if the tasks are timelimited, should be addressed in Priority Outcomes rather than the Position Description Profile. Priority Outcomes can also be used to identify which portions of a particular IT Task statement may not apply to an individual position (e.g., "AI2-06: Design unit and integration tests, but not required to perform or document same.") (continued on next page) DA-313 - Part 1 Rev. 2/2005 Part 1 Part 2 Part 3 How Part 2 and Part 3 Relate to Each Other, and to Priority Outcomes Page 21 of 51 "% Time" Differences DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Part 3 is intended to document the complete set of a position's duties, so the sum of time allocations for all IT Processes performed (including "Other Duty" tasks) must equal 100%. An individual IT Task marked in Part 3 may or may not involve technologies described in Part 2. Also, an individual IT Task in Part 3 may require simultaneous application of skills from several technologies identified in Part 2. Therefore, there is no requirement for a one-to-one match between a "% Time" allocation in Part 3 and any "% Time" allocation in Part 2. In another major difference, the sum of all "% Time" entries in Part 2 may greatly exceed 100%. See instructions for each Part for more details. Complexity Code Differences The extent of training and experience required in a position depends in large part on the complexity of the work. DA-313 uses two measures of complexity: a. In Part 2, the complexity of the technologies used or supported by the position - their number of component parts, number of features, frequency of change, etc. - is described with the Technology Complexity code. b. In Part 3, the complexity of the work processes which use the technologies in Part 2 - the number of steps required to complete a process, the number of decisions required, how well the process is documented, etc. - is described with the IT Process Complexity code. The scales (code numbers) of these two complexity codes are similar, but they measure different aspects of a particular position's work. For more explanation, see definitions of each code in respective Detailed Instructions for Parts 2 and 3. Why Are There So Many Pages? The world of work for Information Technology positions in Kansas state government is complex, varied, and continuously changing. DA-313 was designed to accurately and completely define the work performed within each IT position, without ambiguity, and consistently across all Kansas state organizations. Its design as an expandable checklist of technologies and duties is intended to simplify the job of describing an IT position, and to promote clarity and consistency in IT Position Descriptions. Because a wide variety of IT positions must be described, there are many technologies and many duties (IT Processes and IT Tasks) which need to be available for selection from the state-standard checklists in Parts 2 and 3. That translates to an impressive number of printed pages. However, with the availability of an electronic format for DA-313, the checklists for any particular position can be modified so they show only the technologies and duties which apply to that position - the rows that don't apply can simply be removed from view (hidden). Hiding non-applicable rows reduces clutter and the number of pages in printed copies. Adding rows to include technologies and tasks which do not appear in the standard list ensures that all characteristics of an IT position can be documented. This essentially allows each position to be described with its own, customized DA-313, but in a way which lets the DA-313 form be easily used for classification and other aspects of position and personnel management. Note: for purposes of signature approval of a particular DA-313, only the form pages of Parts 1, 2 and 3 need to be printed . Printed copies of the instruction and reference sheets provided in the electronic file should NOT be submitted as part of the DA-313 package. If state-approved digital signatures are used for an all-electronic submission, then NO pages need to be printed. DA-313 - Part 1 Rev. 2/2005 Page 22 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES POSITION DESCRIPTION PROFILE FOR INFORMATION TECHNOLOGY POSITIONS (DA-313) FORM BASICS Which Blocks to Fill In For instructions specific to each of the Parts of DA-313, see separate worksheet tabs within this workbook file, or the paper Reference Guide which contains the same information. These Detailed Instructions will identify which blocks must be filled in, and which may be left blank. There should NOT be any information recorded in shaded blocks (shaded worksheet cells). COMPLETION ON PAPER Submit All Pages If your organization does not have Microsoft Excel 97 (or subsequent versions of Excel) available to complete the DA-313 electronically, you will need to provide all needed information on pre-printed paper forms. To ensure that no pages of the package are mistakenly lost, submit ALL pre-printed pages together, even if some are not marked as pertinent to the particular IT position. In situations where there is insufficient space on the pre-printed form, you may attach additional sheets of paper. On additional sheets, clearly identify the information which is being extended (e.g., "Part 1, Section 9, continued"). Only black or blue ink will be accepted for pre-printed forms completed by hand. Pencil and other colors of ink do not reproduce well in photocopies. Pencil cannot be considered official, since it is easily changed after approval signatures have been affixed. Additional Sheets Ink Color COMPLETION WITHIN ELECTRONIC FILE Worksheet Tabs The Excel workbook file is divided into 13 worksheets, labeled by tab extensions at the bottom of the spreadsheet area. Contents of each worksheet are summarized in the DA-313 "Introduction." To activate a particular worksheet, position the mouse pointer over the tab and click the left mouse button. Use the directional arrows to the left of the worksheet tabs to see tabs which may be concealed on either side. Each worksheet can be printed separately, or several can be printed at once with a consistent page numbering sequence. See "How to Print Worksheets" below, and the "Printing Instructions" worksheet for more information. Saving the Modified File Change the name of the file in which you save information about a particular position - DO NOT JUST CLICK THE SAVE BUTTON after opening and modifying a template (empty) file or an earlier version of an individual's DA-313. Assigning a unique name to each file greatly assists the HR staffs within the organization and the Division of Personnel Services, as well as each IT employee and their supervisor, with keeping Position Description Profile files correctly identified. To save the file to a different file name, select the drop-down menu item FILE --> SAVE AS… The "Save As" pop-up window will appear on the screen. Use the drop-down arrow in the "Save in:" window to select the folder in which you want the new file to be saved. In the "File name:" block, type in the new file name [see next paragraphs for suggestions on how to name files]. The file extension ".xls" will be automatically added to the name, so you don't have to type it. (continued on next page) DA-313 - Part 1 Rev. 2/2005 Page 23 of 51 Saving the Modified File, continued DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES The new file name should convey enough information that it can be readily identified from within a list of similar file names. In the format used by the Division of Personnel Services, certain key pieces of information are included in the file name: the form identifier; the organization which prepared the form; the identity of the position being profiled; and the date of this version of the position's Profile (since a particular position may have different Profile contents over time). For the agency ID, DPS uses the three-digit agency number (which can be found in the Kansas Communications Services Directory), abbreviated below as "aaa". For the position ID, DPS uses the eight characters from the official position code; this is abbreviated below as "pppppppp". For the date, DPS uses the numeric format YYMMDD (NOT MMDDYY, since it is more useful to sort files first by their year, then by their month and day, rather than sorting them by month, then day, then year). File name components are separated with hyphens. A complete file name will thus have the format "DA313-aaa-ppppppppYYMMDD.xls". Example: DA313-149-K0123456-010629.xls. Each state organization may use its own file naming standard for locally-held copies of DA-313 files the standard described above is NOT mandatory. However, DPS will rename submitted files as necessary to conform to the above standard. If you use an alternative file name structure, then transmittal documents or e-mail messages should contain the form number, agency number, position number and Profile date for each DA-313 file sent to DPS. When DPS sends a completed DA-313 file to a requesting agency, the name of the file will be in "DPS" format. The Excel workbook version of form DA-313 is distributed with each of the Part 1, 2 and 3 worksheets Protected Worksheets "protected." Protection does two things: it speeds data entry, since you can use the Tab key to jump directly between relevant worksheet cells; and it prevents accidental alteration of worksheet layout or formulas. Since there is no password assigned to protected worksheets, you are free to disable protection as needed (see next paragraph). Disabling Worksheet Protection You may find it necessary to adjust how a DA-313 form appears, especially for printing. The row height might need to be increased so all the text you entered appears in the block. Column widths may need to be changed to correct flaws in printing. Or you may want to manually add, hide or reveal rows. You must disable worksheet protection to take any of these actions. To disable worksheet protection: 1. Select the drop-down menu item TOOLS --> PROTECTION --> UNPROTECT SHEET... CAUTION: When protection is disabled, it is possible to alter any characteristic of the electronic form DA-313. To avoid loss of previous work or the possibility of an altered form not being accepted by DPS, please limit changes to those discussed in the "Form Basics" section. If you want to see how formulas in the worksheet operate, dissect macros, etc., please do so with a copy of the file which is not intended for submission. Enabling Worksheet Protection After you have made desired changes in a DA-313 worksheet, you should re-enable protection to prevent unintended alteration by subsequent users of the form. To enable worksheet protection: 1. Select the drop-down menu item TOOLS --> PROTECTION --> PROTECT SHEET... 2. A pop-up box will be displayed. Three checkboxes under "Protect worksheet for" will be checked (Contents, Objects and Scenarios), and the "Password (optional)" entry will be blank. Left-click the OK button without changing any of these settings. Please do NOT establish a password on worksheet protection! DA-313 - Part 1 Rev. 2/2005 Page 24 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Worksheet Macros Worksheet macros are pre-recorded scripts of keystrokes to perform certain functions within an Excel workbook. For example, one macro for the DA-313 hides all the unused rows in Part 2, condensing the form from many pages to just the ones needed for a particular position. This macro saves a lot of time you might otherwise spend doing the same thing manually. (See "How to Hide Rows" below for more information about this particular operation.) You can activate macros within the DA-313 by left-clicking on the appropriate square button, located at the top (header section) of each of the Part 1, 2 and 3 forms. These buttons do not appear in printed copies of the forms. See separate "Detailed Instructions" for each form and other sections in "Form Basics" for additional information on what the buttons do. When you first open the DA-313 Excel workbook file, a pop-up screen will inform you that the workbook contains macros, and give you a choice of disabling macros, enabling macros, or not opening the file. If you want the macro buttons to work, left-click the "Enable macros" button. If you click the "Disable macros" button, the DA-313 will open and be completely available; however, the macro buttons within the DA-313 will not work. In Excel, use either the printer icon on the menu bar, or select FILE --> PRINT from the drop-down How to menus. Check the Print Preview image before sending output to the printer - there may be Print Worksheets unexpected effects with particular printer drivers (the software which is unique to each type of printer). If adjustments to the file are necessary to correctly print DA-313 forms on your system, see sections below on adjusting column and row widths, and the "Printing Instructions" worksheet for formatting values. How to Adjust Page Breaks As a result of entering text in Part 1, or adding or hiding rows in Parts 2 and 3, or using a printer with different driver software from that used in designing these forms, the pagination breaks in the Print Preview image may appear awkward. These can be manually set to force a page break where it makes sense to do so (e.g., at the beginning of a related block of rows). To add a forced page break: 1. Left-click the mouse cursor (highlight a cell) in column A of the row BELOW where you want to add a page break. 2. Select the drop-down menu item INSERT --> PAGE BREAK. A "hard" page break will be added. To remove a forced page break: 1. Left-click the mouse cursor (highlight the cell) in column A of the row BELOW the break. 2. Select the drop-down menu item INSERT --> REMOVE PAGE BREAK. Forced page breaks can be added or removed without disabling worksheet protection. Video Display vs. Printed Output There are minor differences in character sizing and spacing between the video display image and printer output. With the DA-313, this characteristic occasionally reveals itself when there are skipped lines on the printed page, which do not appear in the on-screen image. These minor differences can be overlooked - do not devote time in attempting to achieve a perfect match between the screen image and what comes out of the printer. DA-313 - Part 1 Rev. 2/2005 Page 25 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES How to Adjust Column Widths To adjust column widths: 1. If the worksheet is protected, follow the steps in "Disabling Worksheet Protection" above. 2. Find the column indicators (gray blocks with letters) along the top of the worksheet area. Find the location or letter of the column to be resized. 3. Move the pointer to the RIGHT edge of the block for the column to be resized. The symbol for resizing columns will appear (a vertical bar bisected by a horizontal, double-headed arrow). 4. Press and hold the left mouse button. A pop-up box with the current column width will appear. 5. While holding down the left mouse button, move the mouse right or left as needed to adjust the column width to the desired size - the value in the pop-up box will change as the mouse moves. If the precise value desired does not appear, use the value that is closest. 6. Release the left mouse button. 7. If the worksheet was originally protected, follow the steps in "Enabling Worksheet Protection" above. The intended column widths for all DA-313 worksheets can be found in the "Printing Instructions" worksheet (or corresponding section in the paper Reference Guide). How to Adjust Row Heights To adjust row heights: 1. If the worksheet is protected, follow the steps in "Disabling Worksheet Protection" above. 2. Find the row indicators (gray blocks with numbers) along the left side of the worksheet area. Find the location or number of the row to be resized. 3. Move the pointer to the BOTTOM edge of the block for the row to be resized. The symbol for resizing rows will appear (a horizontal bar bisected by a vertical, double-headed arrow). 4. Press and hold the left mouse button. A pop-up box with the current row height will appear. 5. While holding down the left mouse button, move the mouse up or down as needed to adjust the row height to the desired size - the value in the pop-up box will change as the mouse moves. If the precise value desired does not appear, use the value that is closest. 6. Release the left mouse button. 7. If the worksheet was originally protected, follow the steps in "Enabling Worksheet Protection" above. DA-313 - Part 1 Rev. 2/2005 Page 26 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES How to Add Rows Rows may be added manually to any electronic-format DA-313. The Part 2 form also contains a macro button to add rows and copy necessary formats and formulas automatically. See the "Detailed Instructions" for each Part of the DA-313 for guidance on when and where to add rows. To automatically add rows in DA-313 Part 2: 1. Left-click the mouse cursor anywhere in the row where you want to insert a new row. This row and all rows below it in the worksheet will be automatically moved down. 2. Left-click the mouse cursor on the "Insert Row" button in the form header. The "Part 2 Insert Row" macro will handle disabling and re-enabling worksheet protection. To manually add rows to any Part of the DA-313: 1. If the worksheet is protected, follow the steps in "Disabling Worksheet Protection" above. 2. Left-click the mouse cursor anywhere in the row where you want to insert a new row. This row and all rows below it in the worksheet will be automatically moved down. 3. Select the drop-down menu item INSERT --> ROWS. A new row will be added. The new row will have all columns displayed. DA-313 worksheets use Merged Cells in many areas, so this may not be the layout that you need. Follow these steps to get the correct layout, and to copy any formulas which may exist in hidden columns: 4. Find a row which has the desired appearance. Place the pointer over that row's ID number (left side of the worksheet), and click the left mouse button to select the entire row. 5. Select the drop-down menu item EDIT --> COPY (or left-click the Copy icon); the boundary around the row will change to indicate the row has been selected for copying. 6. Left-click the mouse cursor (highlight the cell) in column A of the new row. Select the dropdown menu item EDIT --> PASTE (or click the Paste icon), and the source row will be copied into the new location. 7. With the new row still highlighted from the Paste operation, press the DELETE key to erase the text contents copied from the source row. The correct row format will be retained, and you can enter the desired text in the appropriate cells. 8. If the worksheet was originally protected, follow the steps in "Enabling Worksheet Protection" above. DA-313 - Part 1 Rev. 2/2005 Page 27 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES How to Hide and Reveal Rows Hiding a row keeps it within the worksheet, but prevents it from being seen on either the video display or in printed output. Hidden rows may be "unhidden" later, if they are needed. See "Detailed Instructions" for individual Parts of the DA-313 - some rows should NOT be hidden. If any of the cells within a hidden row are used within spreadsheet calculations, their contents WILL continue to be referenced - if this is not desired, delete contents of such cells before hiding the row. Follow the instructions below for hiding rows in any of the three Parts of the DA-313. For convenience, this operation has been pre-set in macros for Parts 2 and 3. The macros handle disabling and re-enabling worksheet protection. To automatically hide rows in DA-313 Parts 2 and 3: 1. Left-click the mouse cursor on the "Remove Blank Lines" button in the form header. To manually hide rows in any Part of the DA-313: 1. If the worksheet is protected, follow the steps in "Disabling Worksheet Protection" above. 2. Find the row (or block of rows) which need to be hidden. 3. Left-click the row number on the left side of the screen. If other, adjacent rows are also to be hidden, keep pressing the left mouse button and drag the pointer over the desired range of row numbers. This action will select the row (or block of rows). 4. Position the mouse pointer anywhere over the highlighted row number(s) or row area. Click the RIGHT mouse button. A pop-up menu will appear. 5. Select "Hide" on the pop-up menu. The selected row(s) will disappear. You can see from the gap in row numbers on the left that the row(s) is/are still there, just concealed from view. 6. If the worksheet was originally protected, follow the steps in "Enabling Worksheet Protection" above. To automatically reveal hidden rows in DA-313 Parts 2 and 3: 1. Left-click the mouse cursor on the "Show All Lines" button in the form header. To manually reveal hidden rows in any Part of the DA-313: 1. If the worksheet is protected, follow the steps in "Disabling Worksheet Protection" above. 2. Use the mouse pointer to select the rows just above and below the hidden one(s). With the right-click pop-up menu, select "Unhide". Any hidden rows between the two selected rows will re-appear on video display and in printed output. 3. If the worksheet was originally protected, follow the steps in "Enabling Worksheet Protection" above. \ DA-313 - Part 1 Rev. 2/2005 Page 28 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES POSITION DESCRIPTION PROFILE FOR INFORMATION TECHNOLOGY POSITIONS (DA-313) PRINTING INSTRUCTIONS Possible Printing Problems Certain formatting characteristics of the Excel workbook version of form DA-313, particularly column widths within the worksheets, may not transfer accurately to copies of the file. In addition, the print images of the worksheets within the file may vary for different users due to differences in the printer driver software used on their respective systems. Examine the "Print Preview" image of the output before printing each worksheet within the Excel file. If the print image does not appear as expected (e.g., the far right column shows in a separate page; page numbers are missing), then consult the print format parameters below and adjust the worksheet as needed before printing. See the "Form Basics" worksheet for procedures to adjust worksheet columns and rows. Hint: If the print image carries onto extra pages due to width, before adjusting column widths or side margins, try reducing the print scaling to 97% or 98%. If the entire contents of this version of the DA-313 electronic workbook were printed, there would be at least 70 pages of output, depending on the printer used. Print only what is needed. Instructions and reference material can be examined on video display. Parts 1, 2 and 3 should be shortened in length by adjusting row heights and hiding rows before printing for signature. When worksheets are printed individually, the page numbering at the bottom will reflect the total number of pages within that worksheet alone. However, it is possible to print more than one worksheet at a time, and have the page numbering run consecutively across the entire group of worksheets. For example, here is how to print DA-313 Parts 1, 2 and 3 with consecutive page numbering: 1. Left-click on the "Part 1" worksheet tab to activate the Part 1 form. 2. While holding down the CTRL key, left-click on the "Part 2" and "Part 3" worksheet tabs. They will become active (the tab color will change to white), but the Part 1 form will remain displayed. 3. Left-click on the Print Preview icon, or select the drop-down menu item FILE --> PRINT PREVIEW. Observe that the page count in the page number section shows the total of all three forms. Advance through the Print Preview image to confirm the correct page numbering across the three Parts. If desired, send the job to the printer. Note: The macro button "Print Entire Profile" which appears at the top of the Part 1 form screen provides a handy shortcut. The macro hides unused rows in Parts 2 and 3, selects the three Parts of form DA-313 for consecutive print, and puts you into Print Preview to check the print image before printing. To de-activate a worksheet when more than one is activate, hold down the CTRL key and left-click on the worksheet tab once again. This will remove the white coloration of the tab and de-activate the sheet. How to Check for Problems Print Only What Is Needed Consecutive Page Numbers Across Worksheets DA-313 - Part 1 Rev. 2/2005 Page 29 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Part 1, General Position and Organization Information VIDEO DISPLAY VALUES Display zoom Column widths, A through Z 100% 3.00 PRINT PARAMETERS (MENU SELECTION: FILE --> PRINT SETUP) "Page" tab Orientation Portrait Scaling 100% normal size Paper size Letter Print quality 600 dpi First page number Auto "Margins" tab Top 1.0 Header 0.5 Left 0.5 Right 0.5 Bottom 1.0 Footer 0.5 Center on page Horizontally [only] "Header/Footer" tab Custom header: Left: [none] Center: [none] Right: Font Arial, Bold, 10 Text DA-313 (Revised 6-01) State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Custom footer: Left: Font Times New Roman, Regular, 9 Text DA-313 - Part 1 Rev. 06/29/2001 Center [none] Right: Font Times New Roman, Regular, 12 Text Page &[Page] of &[Pages] "Sheet" tab Print area A1:AB106 [this does not show in Print Preview] Print titles: Rows to repeat at top [none] Columns to repeat at left [none] Print [none] DA-313 - Part 1 Rev. 2/2005 Page 30 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Part 2, Information Technology Items VIDEO DISPLAY VALUES Display zoom Column widths: A B C D E F G H I J K L With cursor in cell A9, select menu item: 100% 7.14 3.29 4.43 26.43 8.29 9.86 8.57 8.71 0.50 6.57 5.43 5.86 WINDOW --> FREEZE PANES PRINT PARAMETERS (MENU SELECTION: FILE --> PRINT SETUP) "Page" tab Orientation Portrait Scaling 100% normal size Paper size Letter Print quality 600 dpi First page number Auto "Margins" tab Top 0.5 Header 0.25 Left 0.25 Right 0.25 Bottom 0.75 Footer 0.25 Center on page Horizontally [only] "Header/Footer" tab Custom header [none] Custom footer: Left: Font Arial, Regular, 8 Text DA-313 - Part 2 Rev. 06/29/2001 Center [none] Right: Font Arial, Regular, 10 Text Page &[Page] of &[Pages] "Sheet" tab Print area A1:L462 [Lnnn will vary as rows are added or deleted] Print titles: Rows to repeat at top $1:$8 Columns to repeat at left [none] Print [none] Page order Down, then over DA-313 - Part 1 Rev. 2/2005 Page 31 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Part 3, IT Domains, Processes and Tasks VIDEO DISPLAY VALUES Display zoom Column widths: A B C D E F G H I With cursor in cell A11, select menu item: 100% 7.00 29.00 17.00 17.00 5.00 5.00 5.00 5.00 7.00 WINDOW --> FREEZE PANES PRINT PARAMETERS (MENU SELECTION: FILE --> PRINT SETUP) "Page" tab Orientation Portrait Scaling 100% normal size Paper size Letter Print quality 600 dpi First page number Auto "Margins" tab Top 0.5 Header 0.25 Left 0.25 Right 0.25 Bottom 0.75 Footer 0.25 Center on page Horizontally [only] "Header/Footer" tab Custom header [none] Custom footer: Left: Font Arial, Regular, 8 Text DA-313 - Part 3 Rev. 06/29/2001 Center [none] Right: Font Arial, Regular, 10 PAGE TOTAL % TIME WORKED (only for preparation on printed form): __________ Text Page &[Page] of &[Pages] "Sheet" tab Print area A11:I227 [Innn will vary if rows are added] Print titles: Rows to repeat at top $1:$10 Columns to repeat at left [none] Print [none] Page order Down, then over DA-313 - Part 1 Rev. 2/2005 Page 32 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES Introduction, Form Design, Form Basics, all Detailed and Quick Instruction worksheets VIDEO DISPLAY VALUES Display zoom Column widths: A B C D E 100% 4.86 5.43 4.00 23.00 53.00 (On Intro, this will be the sum of D and E widths) (On Intro, this will be column F) PRINT PARAMETERS (MENU SELECTION: FILE --> PRINT SETUP) "Page" tab Orientation Portrait Scaling 100% normal size Paper size Letter Print quality 600 dpi First page number Auto "Margins" tab Top 0.75 Header 0.25 Left 0.5 Right 0.5 Bottom 0.75 Footer 0.25 Center on page Horizontally [only] "Header/Footer" tab Custom header [none] Custom footer: Left: Font Arial, Regular, 8 Text DA-313 - xxxxxxx [varies with worksheet tab] Rev. 06/29/2001 Center [none] Right: Font Arial, Regular, 10 Text Page &[Page] of &[Pages] "Sheet" tab Print area [not specified - prints entire worksheet] Print titles: Rows to repeat at top [none] Columns to repeat at left [none] Print [none] DA-313 - Part 1 Rev. 2/2005 Page 33 of 51 DA-313 State of Kansas, Department of Administration DIVISION OF PERSONNEL SERVICES KSTA and COBIT Reference, and Printing Instructions worksheets VIDEO DISPLAY VALUES Display zoom Column widths: A B C D E 100% 5.00 6.00 28.00 21.57 30.00 PRINT PARAMETERS (MENU SELECTION: FILE --> PRINT SETUP) "Page" tab Orientation Portrait Scaling 100% normal size Paper size Letter Print quality 600 dpi First page number Auto "Margins" tab Top 0.75 Header 0.25 Left 0.5 Right 0.5 Bottom 0.75 Footer 0.25 Center on page Horizontally [only] "Header/Footer" tab Custom header [none] Custom footer: Left: Font Arial, Regular, 8 Text DA-313 - xxxxxxx [varies with worksheet tab] Rev. 06/29/2001 Center [none] Right: Font Arial, Regular, 10 Text Page &[Page] of &[Pages] "Sheet" tab Print area [not specified - prints entire worksheet] Print titles: Rows to repeat at top [none] Columns to repeat at left [none] Print [none] DA-313 - Part 1 Rev. 2/2005 Page 34 of 51 15 Shared Document 13 5%ExtraCredit August 2002 Top 20 National Research Universities, IT Initiatives, by ranking Name Princeton University US News ranking CIO 1 Betty Leydon Vice President for Information Technology and CIO (609) 258-5601 betty@princeton.edu IT initiatives Late in 2001, Princeton pulled out of the Online Learning Alliance saying that it preferred to pursue other outlets for online education. Over 3,000 Princeton courses have Websites in Blackboard. The Educational Technology Center (ETC) creates courseware Harvard University 2 Dan Moriarty Assistant Provost, CIO (617) 495 9092 dan_moriarty@harvard.edu Philip E. Long Director, Information Technology Services (203) 432-3262 philip.long@yale.edu Dan Meiron Associate Provost, Information Technology (626) 395-4563 dim@its.caltech.edu James D. Bruce Vice President for Information Systems (617) 253-3103 jdb@mit.edu The Provost's Funds for Innovation in Instructional Technology and Distance Learning were established in April 2000 to promote innovative uses of technology in teaching and learning. Proposals for grants are accepted from individual faculty members, IT su Yale University’s Center for Media Initiatives, established in 2000, is a focal point for learning and teaching using leading-edge media and technology and for sharing those innovations with constituents outside Yale. The CMI Production Advisory Board sel The Technology Learning Center provides computer courses and instructional programs, specializing in commercial business desktop applications. Among options for learners are computer-based training modules available through a grant from Learning Tree. The The Open Courseware Initiative (OCW) is a process to make MIT course materials available free online. During the spring of 2002, MIT has built twenty pilot Websites for internal testing. This initiative is envisioned to publish eventually all of the unive Yale University 2 California Institute of Technology 4 Massachusetts Institute of Technology 5 Stanford University 5 Jan Thomson Director of Technology and Academic Services (650) 723-2566 thomson@stanford.edu The Academic Technology Specialists program places staff in departments to support faculty in their use of information technology in teaching and learning. Half the cost of placing each of these specialists is borne by the department and half by the Provo Name University of Pennsylvania US News ranking CIO 5 James J. O'Donnell Vice Provost for Information Systems and Computing (215) 898-1787 jod@jsc.upenn.edu 8 Tracy Futhey Vice President for Information Technology and CIO (919) 684-5300 tracy.futhey@duke.edu James G. Neal Vice President for Information Systems and University Librarian (212) 854-2247 jneal@columbia.edu Lawrence M. Levine Director of Computing (603) 646-2643 larry.levine@dartmouth.edu Gregory A. Jackson Vice President and CIO (773) 702-2828 gjackson@uchicago.edu Mort Rahimi Vice President and CIO (847) 491-7311 m-rahimi@northwestern.edu Charles J. Henry Vice President and CIO (713) 348-4022 chhenry@rice.edu IT initiatives Technology in Education, associated with the Office of the President of the University of Pennsylvania, was founded in the fall of 1999 to address the problem of the digital divide. Its initiatives include: direct teacher training, classroom support, tech Duke University The Center for Instructional Technology offers a CD entitled "Enhancing Teaching with Technology: Blackboard@Duke," containing video profiles of Duke faculty. The profiles focus on topics such as encouraging collaboration, writing, creating student teams, Columbia University 9 The Columbia Center for New Media Teaching and Learning enhances teaching and learning through the use of new media. They partner with faculty, providing support for construction of course Web sites and the development of more advanced projects. Initiati Dartmouth College 9 The Dartmouth Library's nascent Digital Publishing Program (DPP), which recently produced the first issue of Linguistic Discovery, could lead the way in producing noncommercial, "born-digital" scholarly publications. A primary goal of the DPP will be to p The University of Chicago's Provost's Program for Academic Technology Innovation (ATI) encourages faculty to explore new uses of information technology in research and instruction. Over $1.3 million has been awarded for projects ranging from online instru The International Center for Advanced Internet Research (ICAIR) has among its projects several of direct interest for teaching and learning: advanced internet digital video, digital media grid, global Internet digital video network, and collaborative envi In 1995, Rice University established the Center for Technology in Teaching and Learning (CTTL) to address the ways in which information technology can expand and enrich education. Its mission is to envision the "system after next" and engage faculty, stud University of Chicago 9 Northwestern University 12 Rice University 12 Name Cornell University US News ranking CIO 14 Polley Ann McClure Vice President for Information Technologies (607) 255-7445 polley.mcclure@cornell.edu 14 Shirley K. Baker Vice Chancellor, IT/Dean, University Libraries (314) 935-5400 baker@wustl.edu Ellen J. Waite-Franzen Vice President, Information Technology (401) 863-1000 ellen_waite-franzen@brown.edu IT initiatives Cornell’s fledging Student Technology Assistant Program helps faculty use instructional technologies in their courses. They work in faculty offices or at new multimedia centers donated to each college by Apple. Begun in January 2002, this program is inte Washington University in Saint Louis ITeach, a service begun in December 2001 and co-sponsored by University Libraries, the Teaching Center and the Teaching Lab in Arts & Sciences, focuses on helping University faculty members integrate technology into teaching. In addition to general sessio Brown University 16 The Brown University Scholarly Technology Group (STG) supports the development and use of advanced information technology in academic research, teaching, and scholarly communication. STG pursues this mission by exploring new technologies and practices, de The Digital Knowledge Center of the Milton S. Eisenhower Library opened in January 1997. While most of its projects focus on digital library development, DKC staff members also help with patron and library staff needs and operating issues at the library. In keeping with the charge to encourage an open relationship between teachers and the instructional technology resources available to them, Emory University offers resource centers, instructional technology support, and desktop and hardware support throug The Museum Informatics Project (MIP), an academic department within Information Systems and Technology, is a collaborative effort at the University of California, Berkeley, to coordinate the application of information technology in museums and other organ Johns Hopkins 16 Stephanie Reel Chief Information Officer (410) 516-6700 sreel@jhmi.edu Donald E. Harris Vice Provost and CIO (404) 727-7879 dharris@emory.edu Emory University 18 University of Notre Dame University of California-Berkeley 19 20 Jack McCredie CIO and Associate Vice Chancellor, Information Systems and Technology (510) 642-4096 mccredie@uclink.berkeley.edu 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 How ICTs can help achieve the Millennium Development Goals A B The following goals and targets were adopted in the Millennium Declaration at the General Assembly of the UN Goal 8 includes a target to make available Goals Goal 1: * Eradicate extreme poverty and hunger Role of ICT * Increase access to market information and lower transaction costs for poor farmers and traders; * Increase efficiency, competitiveness and developing country firms; * Enhance ability of developing countries to participate in global economy and to exploit comparative advantage in factor costs (particularly skilled labour). Goals 2 and 3: * Achieve universal primary education * Increase supply of trained teachers through ICT-enhanced * Promote gender equality and empower women distance training of teachers and networks that link teachers and to their colleagues; * Improve the efficiency and effectiveness of education ministries and related bodies through strategic application of technologies and ICT-enabled skill development; *Broaden availability of quality educational materials/resources through ICTs; * Deliver educational and literacy programmes specifically targeted to poor girls & women using appropriate technologies; * Influence public opinion on gender equality through information/ communication programmes using a range of ICTs. Goals 4, 5, 6: * Reduce child mortality * Enhance delivery of basic and in-service training for health * Improve maternal health workers; * Combat HIV/AIDS, malaria and other diseases * Increase monitoring and information-sharing on disease and famine; * Increase access of rural care-givers to specialist support and remote diagnosis; * Increase access to reproductive health information, including information on AIDS prevention, through locally-appropriate content in local languages. Goal 7: * Ensure environmental sustainability *Remote sensing technologies and communications networks permit more effective monitoring, resource management, mitigation of environmental risks; * Increase access to/awareness of sustainable development strategies, in areas such as agriculture, sanitation and water management, mining, etc.; 50 * Greater transparency and monitoring of environmental abuses/ 51 enforcement of environmental regulations; 52 * Facilitate knowledge exchange and networking among policy 53 makers, practitioners and advocacy groups. 54 55 56 Goal 8: 57 * Develop a global partnership for development 58 * Address the special needs of the least * Enable LDCs, landlocked countries and small islands to link up 59 developed countries (LDCs) with the global market to accelerate their progression and full 60 * Address the special needs of landlocked integration into the world economy. 61 countries and small island developing 62 states 63 64 * In co-operation with developing countries,* Distance working facilitated by ICT opens up opportunities 65 develop and implement strategies for to create service-sector jobs in developing countries in such 66 decent and productive work for youth industries as call centres, data entry and processing, and 67 software development; 68 * Telecentres do not only provide access to telecommunications, 69 they also create direct employment for men and women; 70 * Improve youth learning skills, employability to meet the 71 challenges of the knowledge-based global economy of the 72 21st century. 73 74 * In co-operation with pharmaceutical companies, * Provide online drugs databases. 75 provide access to affordable, essential drugs 76 in developing countries 77 78 * In co-operation with the private sector, * Combine low and high technology to achieve relative ubiquity of 79 make available the benefits of new technologies to effective and affordable information and communicatio access 80 especially information and communications technology tools; 81 * Promote digital literacy through e-learning; 82 * Develop a critical mass of knowledge workers with the technica 83 capabilities to provide and maintain ICT infrastructure. 84 85 86 Source : adapted from United Kingdom ment Goals C he General Assembly of the UN in September 2000. Best Practices rmation and lower transaction ountries to participate in mparative advantage in factor hers through ICT-enhanced and networks that link teachers ctiveness of education ministries egic application of technologies ucational materials/resources programmes specifically sing appropriate technologies; der equality through information/ ng a range of ICTs. n-service training for health ation-sharing on disease and ivers to specialist support and e health information, including through locally-appropriate nd communications networks resource management, of sustainable development culture, sanitation and water toring of environmental abuses/ and networking among policy ries and small islands to link up ate their progression and full ICT opens up opportunities eveloping countries in such ntry and processing, and access to telecommunications, ent for men and women; employability to meet the ed global economy of the gy to achieve relative ubiquity of e information and communication wledge workers with the technical ain ICT infrastructure. criteriacrosswalk.xls Extent to which high-level design or operational concepts are defined. ... IDS (As-Is) WDB of existing and sanctioned infrastructure components, services, and technology New Criteria Description Low (1) PERFORMANCE System’s capability for supporting associated Strategic goals and objectives as defined in DOI Strategic Plan. criteriacrosswalk.xls P1 Migration Legacy RIPS WBIS FORVIS RMiS RAS Medium (3) High (5) Target Migration RIS Migration Legacy P1 Business processes supported by the system. Extent of system support of DOI and Bureau strategies, goals, and objectives. Business processes automated are not defined. P2 No linkages between system functionality and DOI & Bureau strategies and goals. Extent of stakeholders feedback for performance measurement and system refinement. P2 BUSINESS P3 Customers? What customers? Who cares? Customers and users are never consulted as to their satisfaction with the system. No performance measurement. Business processes automated and stakeholders supported are clearly defined and documented. There is a direct link between the Some linkages between system functionality provided by the system functionality and DOI & Bureau and DOI & Bureau strategies and strategies and goals. goals. System managers have a vague idea Customer groups and individuals of who their customers might be (or are clearly identified; their needs are used to be); guess about their needs documented; data collection and and interests. Customers and users management systems are linked to are occasionally consulted as to their those needs. Customers and users satisfaction with the system. Minimal are regularly consulted as to their performance measures and system satisfaction with the system; ref performance is mea Business processes automated are partial documented. Some overlap between system functionality and COTS, GOTS products, and other Bureau systems TAA Lack of functional overlap with other systems. B1 P4 Degree to which system training and support opportunities have been addressed. P5 System incorporates reengineered/streamlined business processes (workflow) in an automated fashion that supporting DOI Strategic goals and objectives Significant overlap between system functionality and available COTS, GOTS products, and other Bureau systems. No training, support, or documentation available; users have to study the code to figure out what the system does. The functionality provided by the system does not significantly overlap with other Bureau systems Training and information provided to employees and the public ensure No comprehensive training materials data and information in Agency available, but experienced users and information systems are utilized to some documentation exist to help a their full potential. User groups determined user navigate the system. defined. B2 DATA Existence and documentation of data standards and protocols. D1 D1 Relative maturity and accessibility of system's data storage and access methods. D2 D2 Data standards are not defined, or are in a constant state of flux. No documentation exists outside of personal files and notes of the system developers to implement QA/QC systems. Data stored and maintained in proprietary databases and/or unique formats, which preclude access or use by customers. Standardized data collection protocols and data standards are fully documented and easily accessible and utilized in all data collection procedures at suitable scales. QA/QC systems are fully operational. Information systems and data Information systems and data structures provide employees and structures allow data entry and exit, the public ready access to current but it is cumbersome for users to gain economic, social, and ecological access and to extract information in data and information using current a usable format. technology. Data standards are defined, but redundancies exist within a given scale. Informal and ad hoc QA/QC systems. Some documentation exists, but it is not complete nor easily accessible. Some overlap with other systems in terms of data subject areas accessed. Few system data elements maintained are redundant with respect to other Bureau systems. Minimal overlap with other systems in terms of data subject areas accessed. system data elements maintained are unique with respect to other Bureau systems. D3 APPLICATIONS D3 Significant overlap with other systems in terms of data subject areas accessed. Relative data entity access or modification overlap with other systems. Many system data elements maintained are redundant with respect to other Bureau systems. A1 A1 Degree of architectural compliance with The system is not in alignment with the the conceptual Target Application conceptual TAA. No plans have been Architecture. established to bring the system into closer alignment with the TAA. Extent to which system design requirements are defined and documented. System availability, bandwidth, performance, and functional requirements are undefined and documented. System requirements not aligned with business processes. System interfaces, APIs, and dependencies are not defined. Not aligned with TAA. No high-level design diagram or description. No operational concept documentation. A2 A2 Extent to which systems interfaces are defined and documented. Extent to which high-level design or operational concepts are defined. The system and its development plan are partially aligned with the Bureau's TAA. Plans have been established to bring the system back into alignment. System availability bandwidth, performance, and functional requirements are partially defined and documented. System requirements partially aligned with business processes. System interfaces, APIs, and dependencies are partially defined. Some documentation exists, but it is not complete nor easily accessible. The system and its development plan are aligned with the Bureau's Target system Architecture. System availability, bandwidth, performance, and functional requirements have been fully defined and documented and aligned with business processes. System interfaces, APIs, and dependencies are fully defined. High-level design and operational concept exists and is fully documented and accessible. A3 A3 A4 TECHNOLOGY A4 T1 T3 T1 T2 SECURITY T2 System uses components that have are in direct opposition to the TRM. The system essentially creates its own Extent of maximum use of shared, infrastructure of independently procured existing infrastructure components and and managed components, services and services. technology Extent to which the system complies with current security requirements and extent of progress through the C&A process Extent of compliance with Technology Reference Model standards, protocols and best practices. Extent of compliance with Technology Reference Model technology architecture components. System standards and protocols are in not aligned with those detailed in the TRM System partially embraces TRM standards and best practices. System uses some recommended TRM components. The system makes some use of existing and sanctioned infrastructure components, services, and technology System embraces standards, protocols, and best practices are outlined in the TRM. System uses recommended TRM components. The system makes maximum use of existing and sanctioned infrastructure components, services, and technology. S1 C&A has been identified as required, but action has not been taken C&A Phase 2 has been completed, but issues have been found gating or delaying C&A progress Currently Certified and Accreditted through C&A Phase 5. .xls Technical Infrastructure and Operational Practices, copy and paste the results into Appendix B(1): Google Search: .xls Technical Infrastructure and Operational Practices http://www.google.com/search?hl=en&lr=&q=.XLS+Technical+Infrastructure+and+Operational+Practices+&btnG=Search rational Practices. (0.18 seconds) Web [XLS] Sheet1 File Format: Microsoft Excel 97 - View as HTML Technical collaboration and infrastructure support. 23. 24. = Completed by EHT ... Standard operating procedures for best practice ... www.who.int/entity/eht/frameworks/ ESC_Basic_Operational_Framework.xls - Similar pages [XLS] TIM_Assessment File Format: Microsoft Excel 2000 - View as HTML Have formal inter-agency agreements on operational and administrative procedures ... Have a developed technical infrastructure for surveillance and rapid ... ops.fhwa.dot.gov/incidentmgmt/docs/timtmplt04.xls - Similar pages [XLS] Sheet1 File Format: Microsoft Excel 2000 - View as HTML WHO DEPARTMENT OF ESSENTIAL HEALTH TECHNOLOGIES. BASIC OPERATIONAL FRAMEWORK ... Technical cooperation and infrastructure support ... www.who.int/entity/eht/frameworks/ DIL_Basic_Operational_Framework.xls - Similar pages [XLS] success page 1 File Format: Microsoft Excel 97 - View as HTML T-Technical Assist. E-Training/Education. 31. 32. Practice Area: ... Management Systems - Operational Planning. Information Technology - Data Management ... www.htr.org/DownloadFiles/ success%20story%20Triplett%20Machine%20Plant.xls - Similar pages [XLS] Sheet1 File Format: Microsoft Excel 2000 - View as HTML Extent to which high-level design or operational concepts are defined. ... of existing and sanctioned infrastructure components, services, and technology ... www.doi.gov/ocio/architecture/ documents/criteriacrosswalk.xls - Similar pages [XLS] Top 20 Universities File Format: Microsoft Excel 2000 - View as HTML By fiscal year 2004, the operating budget of the Libraries will increase by 33.8 ... STG pursues this mission by exploring new technologies and practices, ... oit.nd.edu/projects/documents/edutech_top20_xls.xls - Similar pages Appendix B Ends here onal+Practices+&btnG=Search AL FRAMEWORK ... for .PPT Technical Infrastructure and Operational Practices . (0.62 seconds) Web Appendix A Starts here Appendix A(1): .ppt Technical Infrastructure and Operational Practices, copy and paste the results into (Google Search: .ppt Technical Infrastructure and Operational Practices) http://www.google.com/search?hl=en&q=.PPT+Technical+Infrastructure+and+Operational+Practices+&btnG=Google+Search [PPT] HIPAA Phase II Assessment Privacy Final Deliverable - DRAFT File Format: Microsoft Powerpoint 97 - View as HTML Technical Infrastructure and Operational Practices. Information Security and Protection:. Policies. Access Control. Network and Telecomm. Encryption ... www.ehcca.com/presentations/HIPAAWest2/goldschmidt.ppt - Similar pages [PPT] SCA-IT Convergence File Format: Microsoft Powerpoint 97 - View as HTML Infrastructure security operations and management. Telecommunications - voice and data technical support ... Operating practices. Reporting policies ... www.its.ocio.usda.gov/doc/ SCA-ITConSlideShowRev(8)09-17-20031.ppt - Similar pages [PPT] Deploying & Supporting Windows Server 2003 File Format: Microsoft Powerpoint 97 - View as HTML Information Technology Infrastructure Library (ITIL). Microsoft business partners. ... Best Practices Any major operating system upgrade ... download.microsoft.com/download/c/d/f/ cdf2cc1b-8530-4afc-b580-40dcea43f785/WindowsServer2003TWPPpt.ppt - Similar p [PPT] Introduction File Format: Microsoft Powerpoint 97 - View as HTML Technical Infrastructure And Operational Practices. Protection of Information Assets. Disaster Recovery And Business Continuity ... csrc.nist.gov/organizations/fissea/ presentations/2001/CISA-Overview-austin.ppt - Similar pages [PPT] Extending the Reach File Format: Microsoft Powerpoint 97 - View as HTML Trust management: federation and member operation practices and control and privacy ... Challenges (cont):. Technical:. Consistent middleware infrastructure ... www.greatplains.net/conference/soldi-presentation.ppt - Similar pages Appendix A Ends here ... STG pursues this mission by exploring new technologies and practices, ... oit.nd.edu/projects/documents/edutech_top20_xls.xls - Similar pages Appendix B Ends here +Practices+&btnG=Google+Search sServer2003TWPPpt.ppt - Similar pages Web Results Appendix A(2): http://search.msn.com/results.aspx?q=.ppt+Technical+Infrastructure+Operational+Practices&srch_type=0&first=1&FORM=PER Page 1 of 12,447 results containing .ppt Technical Infrastructure Operational Practices (0.30 seconds) Results Results http://www.nawmeetings.org/LC/ceo/05pres/WolfOrg.ppt www.nawmeetings.org/LC/ceo/05pres/WolfOrg.ppt http://www.digitalgovernment.org/library/library/dgo2000/dir/PPT/sfv.ppt www.digitalgovernment.org/library/library/dgo2000/dir/PPT/sfv.ppt Page 5 of 12,447 results containing .ppt Technical Infrastructure Operational Practices (0.18 seconds) http://www.gartner.com/5_about/news/bcpbestpractices.ppt www.gartner.com/5_about/news/bcpbestpractices.ppt Page 3 of 12,447 results containing .ppt Technical Infrastructure Operational Practices (0.25 seconds) (with SafeSearch: Mode ... Current Technical Platform – SAP ECC 5.0 Netweaver (2004 ... Operational innovation” - creating, depl Results www.nawmeetings.org/LC/technet/mat/Tim.ppt Cached page http://www.sse-cmm.org/docs/SecEng01.ppt www.sse-cmm.org/docs/SecEng01.ppt http://www.satyam.com/events/documents/analyst7.ppt www.satyam.com/events/documents/analyst7.ppt Cached page http://edeworkshop.walcoff.com/secure/Architecture.ppt Didn't get the results you expected? Help us improve. ... underlying infrastructure components that support the applications ... of changes to production Technic Why does Search look like this? You are seeing this message because our stylesheet is not compatible with your browser. .ppt Technical Infrastructure Ope Search es&srch_type=0&first=1&FORM=PERE s (0.30 seconds) 25 seconds) (with SafeSearch: Moderate) ional innovation” - creating, deploying and performing ... ERP Minefield: Technology Infrastructure a Migration Path Thank Y s (0.18 seconds) f changes to production Technical controls must tightly ... approaches and best practices are evolving – stay tuned ... ucture a Migration Path Thank You ... e evolving – stay tuned ... Web Results Appendix B(2): http://search.msn.com/results.aspx?q=.XLS+Technical+Infrastructure+Operational+Practices&FORM=QBRE .XLS Technical Infrastructure Operational Practi Search Were you looking for .xls technical infrastructure operational www.practices.i12.com Page 1 of 6,476 results containing .XLS Technical Infrastructure Operational Practices (0.64 seconds) BPs by Column ... Operational VoIP Server Hardening VoIP Server Product ... Create Trusted PKI Infrastructure When Using Generally Available ... of technical www.nric.org/fg/charter_vi/fg1/RECOM_FG1B_Preventative_BPs_FINAL_03-06-2003_v.2_1.xls Short version www.euroitx.com/download.php?file=vendor_eval.xls .ppt Technical Infrastructure ... management delegates operational issues 31 32 Markets and ... company has a strong technical staff 60 Our staff is ... an up to date internal IT · Search Print version ... use financial planning practices? Y/N 40 What is the level of ... management involved in operational management? 57 How much ... How s o Sheet1 www.euroitx.com/download/ito_rating_user.xls ... principles, concepts, operational and functional, issues ... HR staff through the technical planning and change management ... to counter traditi www.napawash.org/pc_human_resources/HRITExcel.xls Sheet1 www.wseas.com/2003.xls ... technical drawing treatment for video presentation E ... information technology infrastructure development Seppo Sirkemaa ... Global optimizat · Sheet1 o www.wseas.com/2002.xls ... Jorge Ferreiro Diego Andina 443-157 This paper focuses on the network infrastructure security measures currently proposed and at a certa GSEC www.giac.org/gold/GIAC_Wishlists.xls ... Cisco Security Agent infrastructure using VMS GSEC 7 Case study on ... relationship about technical security measures and business ... Exam Sheet1 www.sname.org/FinalSection.xls ... Developing a Ship Design Infrastructure for the Future Navy 5 ... cost estimation, operational requirements, risk assessment P.P ... Canadian T Were you looking for .xls technical infrastructure operational www.practices.i12.com Search