Loading...
R-01-07-26-14A1 - 7/26/2001 RESOLUTION NO. R-01-07-26-14A1 WHEREAS, the Telecommunications Infrastructure Fund Board has grant funds available to cities for various projects, and WHEREAS, the City Council wishes to make application for the available grant funds for improvements to the library internet system, Now Therefore BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK, TEXAS, That the Mayor is hereby authorized and directed to make the necessary application for the above-described grant . The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended, and the Act . RESOLVED this 26th day of July, 2001 . 4RO. . STLUKA, JK. , Mayor City of Round Rock, Texas ATTEST: City Secretary 0,N1215riN61n qRt/nJ6Z,; R,157,- 0:\WPDOCS\RESOLUTI\R10726A1.WPD/sc FORM 1 : LIBRARY COVER PAGE NAME OF LIBRARY: Round Rock Public Library System FSCS Number TX0259 Regional Library System: CTLS Name of Contact Person: Dale L. Ricklefs Title of Contact Person: Library Director Mailing Address: 216 E. Main Street Round Rock, TX 78664 Telephone Number: 512-218-7010 Fax Number: 512-218-7061 E-Mail Address: dale(cDround-rock.tx.us Federal Tax ID #: 74-6017485 Name of County: Williamson State Senator: Steve Ogden State Rep.: Mike Krusee ANNUAL CIRCULATION (check one): ❑ Less than 100,000 ® Greater than 100,000 TOTAL TIF FUNDS REQUESTED $55,950 TOTAL LOCAL FUNDS FOR PROJECT $ 6,217 If applicable, NAME OF COLLABORATIVE IN WHICH YOUR INSTITUTION IS PARTI ATING: NA Has t s p c)tion been reviewed by your Regional Library System (yes or no): No Sign t re of thorized Official Date: July 26, 2001 Robe tt, Jr., City Manager TIF Form/Narrative Abstract (October 2000 rev.) FORM 2: DESIGNATION OF GRANT OFFICIALS PROJECT DIRECTOR Name: Dale L. Ricklefs Title: Library Director Organization Name: City of Round Rock, Round Rock Public Library System Mailing Address: 216 E. Main, Round Rock, TX 78664 Telephone: 512-218-7010 Fax#: 512-218-7061 E-mail Address: dale(cDround-rock.tx.us Signature: /Q ��cDate: 7/11/01 FINANCIAL OFFICER Name: David Kautz Title: Finance Director Organization Name: City of Round Rock, Finance Department Mailing Address: 221 E. Main, Round Rock, TX 78664 Telephone: 512-218-5430 Fax #: 512-218-5442 E-mail Address: dkautz(a-)round-rock.tx.us Signature: r ( Date: 7/11/01 a2 AUTHORIZED OFFICIAL Name: Robert L. Bennett, Jr. Title: City Manager Organization Name: City of Round Rock, Administration Mailing Address: 221 E. Main, Round Rock, TX 78664 Telephone: 51 - 18- 2 Fax #: 218-7097 E-mail Address: au in20 und-rock.tx.us Signature: -f' Date: 7/11/01 TIF Form/Narrative Abstract (October 2000 rev.) i - i L FORM 3: CERTIFIED ASSURANCES The applicant hereby assures and certifies to the grant that: 1. It possesses legal authority to apply for the grant; that a resolution, motion or similar action has been duly adopted or passed as an official act of the applicant's governing body, authorizing the filing of the application including all understandings and assurances contained therein, and directing and authorizing the person identified as the official representative of the applicant to act in connection with the application and to provide such additional information as may be required. 2. It is applying for funds to purchase equipment or services that are not already in the possession of the applicant. 3. The programs contained in its application meet all requirements, that all the information is correct, that there has been appropriate coordination with affected agencies, and that the applicant will comply with all provisions of the grant and all other applicable federal and state laws, regulation, and guidelines. 4. Fund accounting, auditing, monitoring, and such evaluation procedures as may be necessary to keep such record, as TIF shall prescribe, shall be provided to assure fiscal control, proper management, and efficient disbursement of funds received under the grant. 5. It shall maintain such data and information and submit such reports, in such form, at such times, and containing such information as TIF may require. 6. It will comply with Texas Government Code, Chapter 573, Vernon's 1994, by ensuring that no officer, employee, or member of the applicant's governing body or of the applicant's contractor shall vote or confirm the employment of any person related within the second degree by affinity or the third degree by consanguinity to any member of the governing body or to any other officer or employee authorized to employ or supervise such person unless otherwise expressly provided by law. 7. Will insure that all information collected, assembled, or maintained by the applicant relative to the project and all equipment purchased with grant funds will be available to TIF staff or its agents for copying or inspection during normal business hours. 8. It will comply with the State of Texas Uniform Grant Management Standards (UGMS) as amended January 1998, developed under the directive of the Uniform Grant and Contract Management Act, Texas Government Code, Chapter 183. (Applies to Public Libraries only.) 9. It will comply with all federal statutes relating to nondiscrimination which include, but are not limited to, Title VI of the Civil Rights Act of 1964 (42 U.S.C. 2000d et seq.), which prohibits discrimination on the basis of race, color or national origin; Title IX of the Education Amendments of 1972, as amended (20 U.S.C. 1681et seq.), which prohibits discrimination on the basis of sex; Section 504 of the Rehabilitation Act of 1973, as amended (29 U.S.C. 794), Subtitle A, Title II of the Americans With Disabilities Act (42 U.S.C. 12131-12134) and the Department of Justice implementing regulation, 28 CFR Part 35, which prohibit state and local governments from refusing to allow a person with a qualified disability from participating in a service, program, or activity simply because the person has a qualified disability; the Age Discrimination Act of 1974, as amended (42 U.S.C. 6101 et seq.), which TIF Form/Narrative Abstract (October 2000 rev.) prohibits discrimination on the basis of age; and the Department of Justice Nondiscrimination Regulations, 28 CFR, Part 42, Subparts C, D, and G. 10. It will in the event a federal or state court or federal or state administrative agency makes a finding of discrimination after a due process hearing, on the ground of race, color, religion, national origin, sex, age, or disability against the project, forward a .copy of the finding to Telecommunications Infrastructure Fund Board. 11. It will comply with the Drug-Free Workplace Act of 1988 (41 U.S.C. 701 et seq.) by certifying that it will not engage in the unlawful manufacture, distribution, dispensing, possession, or use of a controlled substance in conducting any activity with the grant; it will publish a statement notifying employees that these activities are prohibited in the applicant organization's workplace and specifying the actions that will be taken against employees for violation of such prohibition; and by maintaining on file the place(s) that work is performed in connection with the grant listing street address, city, county, state and zip code. 12. It will provide an Equal Opportunity Program if required to maintain one, where the application is for $500 or more. By execution of this form the applicant certifies that it agrees to abide by the above- referenced assurances. The assurance with regard to the above laws and regulations shall obligate the applicant organization for the period during which State financial assistance is extended. Organization Name: City of Round Ro and Rock Public Library System By: ignature — Head of Governing Body Robert Stluka 4ureo or 2001 By: Siorized Official Bennett City Manager July 26, 2001 TIF Form/Narrative Abstract (October 2000 rev.) ........_. ... FORM 4: NARRATIVE ABSTRACT The abstract is a summary of the project and should mention the problem or need being addressed,the proposed activities,and the intended outcomes. The abstract must contain: a statement of goals,purpose and objectives;and a brief description of expected results. Applicant Name: City of Round Rock, Round Rock Public Library System Amount Requested: $55,950 Total Project Cost: $62,167 The Round Rock Public Library System is located in Round Rock (Williamson County), one of the fastest growing cities in the state. The current population estimate is 71,000, with a 10% growth rate per year during the past four years. While we have received two previous grants from the TIFB, this grant application is two-pronged. Part of the grant offers new capabilities, such as Remote Patron Authentication and access to a station for someone who has impairments beyond wheel chair needs (Projects 1 and 4). The other part of the grant includes enhancements to the basic internet services project funded by TIFB three years ago (Projects 2 and 3). This grant will address four project goals. The primary goal is to provide remote patron authentication (RPA) to the library and state library's database. Both software and hardware is required to manage this function effectively. Once the RPA software and server is installed, registered library users will be able to access the library and state library databases from their homes, something they are currently unable to do. Project cost: $11,500 The second goal is to secure the various servers purchased by TIF and the library during the past two grants by a) contracting with a consulting firm to test the servers for security leaks and take the steps necessary to secure the servers from intrusion both within and outside of the LAN, and b) upgrade access control and time out software with Cybrarian, replacing our PAM software. We are no longer able to update the PAM software as the vendor has gone out of business. PAM does not work properly with NT or Windows 2000. These two projects will help the library prevent ping and other attacks that the city has recently experienced, of which we are also vulnerable, as well as improve the service and reduce the frustration both the staff and the public are experiencing when using the PAM interface. Project cost: $9,000 TIF Form/Narrative Abstract (October 2000 rev.) The third goal is to enhance what we are currently doing. Being in a high tech community, we had assumed that the 15 adult internet stations previously funded by the TIF and the six PCs we acquired from the Dell Employee's Foundation for the children's area would be sufficient to meet the demand. During peak times, we have found that this is not the case. In order to address the phenomenal demand, we will be requesting 5 adult (one of them being a wireless station), 6 child, and 2 staff PCs. The staff PCs will be used at the reference and information desks to enhance the net-based assistance we provide the customers at this point. With only two computers but four staff members behind the desks, our service is limited. A color laser printer will be added to the library's existing selection of printer options so there are more printing options for the public. This project will also place Office XP licenses on all TIF, City, and Dell funded public access computers (38 in all). Finally, the project will also provide a hardware solution to internet filtering on the children's computers. Project cost: $28,295 hardware related, $6,622.00 software and network licenses, $2000 tables and chairs. The final goal is to make available a computer fully equipped for the visually and hearing impaired. While we have handicapped access to computing areas, the PCs continue to be standard machines with MS accessibility options selected. However, touch screens, speakers, and other tools will greatly improve internet access to this population. Project cost: $4,750.00 TIF Form/Narrative Abstract (October 2000 rev.) FORM 6: NEEDS ASSESSMENT Explain the needs and/or problems that the proposed project will address. Focus on conditions in the lives of constituents that need to be changed;specify services that are unavailable without deploying advanced technology;identify disparity in access and financial need. Project 1, Remote Patron Accessability: This project will be useful for students (public and home-schooled), recently unemployed tech workers, and the general population in getting into city- and state-funded databases from their homes. Only registered library users will have access to the databases, meeting the licensing requirements of most of the database owners. These databases are not accessible to the at- home or remote user otherwise. Project 2, Security: While there is a firewall protecting the primary database servers and other types of servers in the library, servers outside of the firewall are not protected as thoroughly. Recent attacks on the City Hall servers, and recent unexplained behavior of the library's replicated server outside of the firewall, creates a need to identify security holes in the system and to address them accordingly. The RPA server will also be outside the firewall, so we should secure it appropriately prior to installation. Project 3, Enhancement of existing services: While we do not survey our customers to find out if they have a computer at home or their income, we have visually observed a great diversity of users by age, race, and culture on our computers—a diversity greater than those who use the library for other activities. This includes adults and children, male and female. Adult stations are used continuously by adults in the morning and after school by the teen and college populations, and children's stations are used primarily after school and during the summer, providing an activity for the children living near the library after school, and during the daytime by the home schooled population. We have people waiting for machines during all peak times, though we have a one-hour time limit on most of the machines. Additionally, we need an additional printer so that the existing printer has fewer print jobs waiting to be printed, and two more staff use computers so more staff members have access to computers to help the public from the service desks. We will also be adding a hardware solution (Bess by N2H2) for filtering the children's computers, We filter the children's area, allowing all children access to the internet. In the adult TIF Form/Needs Assessment (October 2000 rev.) area there is no filtering, and children under the age of 16 need parental consent to use those particular adult workstations. Finally, we are adding a laptop wireless solution for parents allowing them to search the web in the children's area, keeping the children entertained at the children's computers or with the books or other age appropriate equipment and toys in the library, creating more of a family learning center. Project 4, Special needs accessibility: We have customers who are hearing, visually, and physically challenged. By developing a system that meets the more unusual physical needs beyond those that are wheel chair bound, we will be able to better serve the needs of the population that may have poor motor control, poor vision, or need hearing enhancement devices to understand auditory information from the internet/office product software. TIF Form/Needs Assessment (October 2000 rev.) FORM 7: PROJECT OBJECTIVES & METHODS Identify project objectives and the methods or activities that will occur to meet the stated objectives. Objectives should be specific, identify what needs to be done,and be directly related to solving the needs defined in Form 6. Clearly describe project activities, state reasons for selection of activities,describe sequence of activities,describe staffing selections. Project 1, Remote Patron Accessibility (RPA): The library will contract with Epixtech, its library database provider, to supply the RPA software which is fully functioning and used in other libraries throughout the country. The library will request competitive quotes for the RPA server. As the library has already talked to the Epixtech Corporation on pricing and requirements, it is ready to purchase this software immediately, and will be able to receive competitive quotes for hardware within a two week timeframe. The library has sufficient port access on its existing hubs for the new server. After the software and server are fully operational, the library will actively promote remote access to its registered population. The staff involved in this activity include Tricia Brauer (MLS, Library Software Administrator) for software application installation and working with Epixtech; David Wongwai (Library System Administrator) who will identify the appropriate server supplier using the city's existing procurement procedures; and Ping Liu (MLS, Reference Librarian) for publicizing the improved access to the public. Project 2, Consulting on library security and Cybrarian acquisition: Library computer tech staff will identify, through the competitive price quote process, an appropriate consultant to test the system. Based on the consultant's advise, appropriate software or hardware modifications will be made. Any excess costs for this project for the implementation of the improvements will be requested from the City of Round Rock during midyear and/or next year budget request cycles. At this time we do not know the types of improvements that will be required. Staff has been working the past three months to identify the most current and effective library workstation security software. While no vendor seems to meet all library needs at this point, Cybrarian seems to come the closest to the library's security and access needs. David Wongwai, Library System Administrator, will oversee this project which at this point includes the purchase and installation of Cybrarian on all library public access computers. Project 3, Enhancement of existing services: When the library was designed, additional work surfaces for the adult areas, chairs, and in many cases, LAN outlets, were put in place to meet the needs of the growing population of internet, library catalog, and word processing users. It was expected that stations would be added as we grew. After two years in the new facilities, we are ready for the next stage in the library's expansion of computer access. All purchases will be TIF Form/Objectives&Methods (October 2000 rev.) made using the city's purchasing procedures. The city will request bids for four adult workstations, six children workstations, two public service staff workstations, and one laptop computer for parental web searching inhouse. Furniture and seating will need to be purchased for the children's workstation, which will be part of the city's match. Additional Cat 5 cabling will be needed for the children's workstations, following TIFB guidelines for installation and certification. For ease of administration, Office XP will be placed on all computers (existing and new) as will NT 4.0. We have several versions of Office throughout the library, causing different approaches to managing each one. We have already identified the options in the filtering field, and staff feels that for ease of administration and flexibility, N2H2's Bess proxy server is the best option. David Wongwai, Library System Administrator, will manage the technical aspects and purchase the MS software. Janette Johnston, Children's Librarian II, will identify the most appropriate seating and work surface for the children's area. Project 4, Special needs workstation: Staff has already identified the type workstation that will be developed. David Wongwai, Library System Administrator, will oversee the acquisition and installation of the workstation. Ping Liu, Reference Librarian, will publicize the availability through traditional media, as well as identify the hearing, blind, and physically challenged community through their media resources. The library already has a workstation suitable for this equipment. TIF Form/Objectives&Methods (October 2000 rev.) FORM 9: PROJECT TIMELINE Include a detailed timeline for installation of equipment,training,and project activities. Document when outlined objectives are expected to be met as well as major milestones projected over the life of the project. Refer to the RFP for anticipated starting and ending dates for the grant project. All obligations of funds for activities and services conducted shall occur within those dates. September 2001: Server identified through purchase process Cybrarian purchased Consultant identified and contracted to test existing security measures used on protecting the library's database servers and create guidelines for additional servers, including RPA Furniture for children's work stations identified October 2001: Late October: Receive Consultant report. This part of project 2 completed. RPA server purchased RPA software purchased from Epixtech Cybrarian installed. Project 2 completed. Furniture for children's work stations purchased (usually a four month turnaround time) November 2001: RPA server configured based on consultant's recommendations RPA software installed and tested December 2001: Publicity on RPA availability initiated. Project 1 completed.January 2002: Identify computer vendors via procurement process, including the special needs computer Identify final location of computers where LAN connections do not exist. Begin LAN connection installation. Includes wireless stations. February-March 2002: Complete LAN connection installation, including wireless stations Receive children's workstations Receive all computers Install XP software (if not installed with the computers), NT OS on previously purchased LAN comptuers Advertise to agencies representing those with special needs the availability of the special needs workstation, as well as existing workstations for the wheelchair bound. All remaining projects (3 and 4) completed. April 2002: Submit to City request for budget adjustments for furnishings for children's workstations as well as security measures based on consultant report. These items will, however, be tentatively covered in other areas of the library's budget. TIF Form/Project Timeline (October 2000 rev.) FORM 10: EVALUATION PLAN Applicants must include the following information in their evaluation plan: *Who is responsible for conducting the evaluation plan; *Defined evaluation criteria that relates to stated objectives; *How evaluation data will be collected throughout the life of the project; *How evaluation data will be analyzed; *How evaluation data will be reported and used to improve project. Dale Ricklefs, Project Director, will work with the staff in monitoring progress, accessing the success of the programs in terms of timely installation, publicity, and actual use where appropriate. Basic Texas State Library and Archives Commission measurements. While it is difficult to gain accurate counts of this information with the technology and software as it currently exists, sampling methods are available to give us the best estimate to asnwer the questions. 1. How many patrons used electronic resources of the library during a typical week? The library's software system PAM collects the number of individuals who log on to the internet stations, the word processing stations, and the database stations. Cybrarian, the recommended software replacement, will likewise give us realistic measurements of people who use these particular types of resources. 2. How many persons were trained in the use of electronic resources in formal settings? The library offers internet and "card catalog" training four times a month. We have accurate counts of these particular"student" counts. 3. How many persons were trained in the use of electronic resources in informal settings? The library has not formally collected this information in the past. However, we will do this as a sampling method during a one week period in October using traditional paper tally sheets, and calculate that number across the number of days we are open. 4. How many materials are provided through electronic resources? We will be able to count three resources. We will be able to obtain view counts from vendors participating in the TexShare program, and we do have a counter on the library's website to measure the number of visits to those resources. We are also able to get more specific counts TIF Form/Project Evaluation (October 2000 rev.) from computers that are designated as database-only access computers within the library through the PAM, and if funded, Cybrarian, software. Other measurements based on projects proposed: Project 1, Remote Patron Authentication (RPA): RPA will allow us to receive information from the State Library as to the number of people using the state library from home. Statistics from the State Library will help us measure effectiveness of the service and our publicity/training attempts. We will also receive statistical information from the Epixtech software as well. Epixtech information will be available immediately. Project 2, Security: The success of securing the servers will be based on the solutions recommended by the consultant that the staff and the city choose to implement, and the measurement of system failure or ease of analysis of failure that follows after the solutions are implemented. In terms of Cybrarian, the measure of success is observed reduction of frustration by the staff in managing the workstation security software, as well as the ease of use of the workstations by the general public by reducing the frequency of automatic shutdowns and "blue screens". Project 3, Enhanced access: The measurement of success is the reduction in the number of people waiting for a work station, an increase in the number of people having access to the systems, particularly in the children's area, and the ability of more staff members being able to assist the public through effectively doubling the number of workstations staff have access to when helping the public. This use of computing equipment by the public is captured in the PAM or Cybrarian software. The number of instances that staff has assisted the public using the new computer systems will be measured at the beginning of the grant period (without the new computers) and the end of the grant period (with computers) for a one week period to see if there is an increase in the number of contacts staff has had with the public. This will be measured through traditional tally sheets. The amount of time people have to wait for a printout will also be reduced. Color lasers are effective, though quite slow in providing copies. As before, we will be able to measure the number of copies printed over a one week period before the funding starts and then perform the same measurement with the two machines one year later over the same week. The printers have counting devices on them. TIF Form/Project Evaluation (October 2000 rev.) Project 4, Speciel needs accessible workstation: The measurement of success will be the number of people using the special needs workstation as well as this population's comments on ease of use. The initial input will be the publicity generated by staff targeting the special needs population. TIF Form/Project Evaluation (October 2000 rev.) FORM 11: OVERALL GRANT BUDGET SUMMARY APPLICANT NAME: City of Round Rock Public Library System BUDGET SCHEDULE TIF Funds Local Funds Total A. Personnel $0.00 $0.00 $0.00 B. Contractual Services $5,000.00 $0.00 $5,000.00 C. Travel $0.00 $0.00 $0.00 D. Supplies and Materials $15,622.00 2000.00 17,622.00 E. Equipment $35,328.00 4217.00 39,545.00 TOTAL DIRECT EXPENSES $55,950.00 $6217.00 $62,167.00 1 approve the budget for this project and agree to abid by all ina cial guidelines. Signature of Financial ffice Signat of Aut rized Official David Kautz, Finance Director Robert L. Benn t, Jr., City Manager July 11, 2001 July 11, 2001 TIF Form/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY SCHEDULE A - ELIGIBLE PERSONNEL COSTS APPLICANT NAME: City of Round Rock Public Library There are no expenses in this category TIF Form/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY SCHEDULE B — CONTRACTUAL SERVICES APPLICANT NAME: Type of Expense Quantity TIF Funds Local Funds Total Duration Section 1: Telecommunications rb . Monthl ISP Fees. Monthly Line Charges Total Section 1 Section 2: Project Management a. Pro'ectDesi n/Mana ement b. Security audit 1 1 month 5000 5000 Total Section 2 $5,000 $5,000 Section 3: Training a. TIFTech Training Total Section 3 TOTAL DIRECT EXPENSES SECTION 1 + 2 + 3 = $5,000 $5,000 TIF Form/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY BUDGET SCHEDULE B - CONTRACTUAL SERVICES JUSTIFICATION ATTACHMENT Part of Program 2, Consulting for Security, $5,000: The external web server which currently provides access to the public to the library's database has minimal security on it. We do not have the resources internally, either in the library or in the city's IT department, to identify the best type of security for our particular application. Additionally, with the proposed addition of the RPA software and server which will also sit outside of the firewall, the appropriate means needs to be taken to secure this new piece of equipment. To date we have had no verifiable attacks on the server. However, the city has received ping attacks on three of its servers that sit outside of its firewall, so we feel we should take appropriate hardware or software steps to secure the servers that sit outside our firewalls. These servers sit outside of the firewall, replicating data from the server inside the wall, allowing customer transactions which would not be possible behind the firewall. The cost estimate is based on the city's previous consulting experience with Southwestern Bell, our internet service provider. "Fixes" will most likely be specific OS patches, sw codes, and operating procedures with little cost that will be absorbed by the library. Any other longer term hardware or software fixes will be assumed by either the library or part of an overall city software solution for its various departments in FY 2002-2003. TIF Form/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY SCHEDULE C — TRAVEL APPLICANT NAME: City of Round Rock Public Library System There are no expenses in this category TIF Fom-/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY SCHEDULE D - SUPPLIES & MATERIALS APPLICANT NAME: Type of Expense Quantity TIF Funds Local Funds—T Total Section 1: Software a. Web Authoring b. Operating System 200 200 c. Web Server d. E-mail e. Anti-Virus f. Application Software- 6,422 6,422 MS licenses for Office XP g. RPA SW 5,000 5,000 h. C brarian 4,000 1 4,000 Total Section 1 $15,622 1 $15,622 Section 2: Other Materials a. Equipment Rack b. Children's workstation, 6 2,000 2,000 chairs Total Section 2 $2,000 $2,000 TOTAL DIRECT EXPENSES SECTION 1 + 2 = 1 $15,622.00 $2,000.00 $17,622 Note: Using the Justification Attachment form,justify and briefly describe the basis for arriving at the cost of each line item. See Section 4, Page 3 of the Application Guide for additional information. TIF Form/Sched B Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY BUDGET SCHEDULE D - SUPPLIES & MATERIALS JUSTIFICATION ATTACHMENT Program 1, Remote Patron Authentication Software, $5,000 This Epixtech software, compatible with our Epixtech library system, costs this standard amount. There is no competitive product. Program 2, Cybrarian, $4,000 After reviewing several library kiosk-type/ management software, this product provides most of the features we are looking for. With the closing of the business that created PAM, we are no longer able to upgrade the PAM management software to run with NT 4.0 or Win 2000. Cybrarian will give us that capability. This is a site license and will run on all TIF and library funded systems, both current and existing. Program 3, Expanded internet access, $8,622 The Office XP licenses will run on all TIF grant funded computers, past and present ($6,422). The operating system licenses, NT 4.0, are for the new computers ($200). The workstations and chairs for for the children's area and will constitute part of our match ($2,000). TIF Form/Sched D Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY SCHEDULE E — EQUIPMENT / FIXED ASSETS APPLICANT NAME: Type of Expense Quantit TIF Funds Local Funds Total Section 1: Network Hardware a. CSU/DSU b. Hub c. Router d. Ethernet Switch 2 600 600 e. UPS f. Wireless network cards 2 400 400 g. Access pts for wireless 3 900 900 Total Section 1 $1,900 $1,900 Section 2: Distance Learning Hardware Total Section 2 Section 3: Computer Hardware a. Server 1 6,500 6,500 b. Workstations 1) Desktop 12 14,400 14,400. 2) Laptop 1 2,000 2,000 c. Special needs 1 4,750 4,750- d. Color laser printer 1 3,500 3,500 e. Proxy server for filtering--T 278 4,217 4,495 Total Section 3 $31,428 $4,217 $35,645 Section 4: Cabling and Supplies a. Wiring & Associated 1 2,000 2,000 Total Section 4 $2,000 $2,000 Section 5: Other Equipment a. Digital Camera i. Total Section 5 TOTAL DIRECT EXPENSES SECTION 1 + 2 + 3 + 4 +5= $35,328 $4,217 39,545 Note: Using the Justification Attachment form, justify and briefly describe the basis for arriving at the cost of each line item. See Section 4, Page 3 of the Application Guide for additional information. TIF Form/Sched Q Attach (October 2000 rev.) OVERALL GRANT BUDGET SUMMARY BUDGET SCHEDULE E - EQUIPMENT / FIXED ASSETS JUSTIFICATION ATTACHMENT Program 1, Remote Patron Authentication Server: $6,500 This server will sit outside of the firewall and house the authentication software. No additional cabling in necessary. This cost is based on current quotations. Program 3, Expanded internet access: $28,295 12 desktop computers at $1200 each will be purchased. Six will be in the children's section, four in the adult area, and two at staff stations where direct service is provided to the public. These prices are based on current quotations. ($14,400). Related costs include $2000 for the wiring and associated costs, which will be done with Cat 5 cabling. The children's section will need 1-2 network drops for the six child internet workstations and the wireless parent workstation. The children's section and the west wall of the second floor of the library will have raceways, gang boxes, and patch cables installed. Existing staff will install the raceways, gang boxes and patch cables. All cabling will be certified by the contractor as required by TIFB. ($2,000) Two additional 10/100 switches will be purchased at $600.00. Final, a LAN based color laser is being added to meet the need of the expanded access, at a cost of $3,500. This cost is based on our recent purchase of a new color laser printer. ($3,500) One laptop with wireless access will be used by parents in the children's area ($2,000). We find that parents want the unfiltered access in the upstairs area or are prohibited from using the children's computers in order to provide access to the children. It is better to have parents working downstairs in the children's area so their children have something to do, rather than disturb others in the quiet area of the second floor. This machine will allow us to limit use to the parent by not making it readily available to the children as a desktop model, as well as provide a non-filtered machine. The parent can also go to other areas downstairs, near the child, and not necessarily near the bank of children's TIF Form/Budget summary (October 2000 rev.) e , computers. The related costs include the wireless network cards at $400, three access points for wireless at $900. ($3,300 total package) As part of this project, N2H2, a hardware based solution to filtering of the children's workstations will be administered. The staff prefers the flexibility of this system in that it: provides central administration, as a proxy server it will block an entire page, not just words and images on a page, within 24 hours the company will block or unblock a site, an entire site is not blocked just the offending pages. We are using Net Nanny (self-funded) which is ineffectual and time consuming to administer and update. New children's stations proposed in this grant application and existing stations that were donated by Dell will be blocked by this software. ($4,495) Project 4: Special needs station, $4,750 This workstation includes, with current costs follows. This is being presented as a "turnkey" system. However, the software (Jaws 3.7, Zoomtext, IBM Home page reader) would otherwise go under software and the braille keyboard overlay go in Schedule D as a supply item. The Computer and trackball would stay in E if these items are broken out. Dell Optiplex GX100 with 21 inch monitor 2,600.00 Jaws 3.7 for WIN NT/2000 (a voice reader) 1,311.00 Zoomtext level 1, Version 6 360.00 Large-print w/ Braille keyboard overlay 45.00 Oversized trackball 30.00 IBM Home page reader 129.00 TIF Form/Budget Summary (October 2000 rev.) Appendix D TIF APPLICATION CHECKLIST— 1-137 Public Libraries FORM 1: Library Cover Page FORM 2: Designation of Grant Officials FORM 3: Certified Assurances FORM 4: Narrative Abstract FORM 6: Needs Assessment FORM 7: Project Objectives & Methods FORM 9: Project Timeline FORM 10: Evaluation Plan FORM 11: Overall Budget Summary SCHEDULE A: Personnel — Costs Related to Training (w/Justification Attachment) N A SCHEDULE B: Contractual Services (w/justification Attachment) SCHEDULE C: Travel (w/justification Attachment) NA SCHEDULE D: Supplies & Materials (w/justification Attachment) SCHEDULE E: Equipment/Fixed Assets (w/justification Attachment) FORM 12: Individual Site Budget Summary SCHEDULE A: Personnel — Costs Related to Training (w/Justification Attachment) SCHEDULE B: Contractual Services (w/justification Attachment) SCHEDULE C: Travel (w/justification Attachment) SCHEDULE D: Supplies & Materials (w/justification Attachment) SCHEDULE E: Equipment/Fixed Assets (w/justification Attachment) APPLICATION CHECKLIST— signed below Applicant Organization: City of Round Rock Public Library System Dale L. Ricklefs, Library Director July 11, 2001 a DATE: July 20, 2001, 2001 SUBJECT: City Council Meeting—July 26, 2001 ITEM: 14.A.1. Consider a resolution authorizing the Mayor to make the necessary grant application to the Telecommunications Infrastructure Fund Board for improvements to the Library Internet system. This is a third grant request to TIFB. This grant will provide software allowing library card holders to gain access to library and state owned databases, update the security on the in-house computers,provide a consultant to study existing security levels on the servers outside of the firewall, all 10 internet stations for the public, and add a station for the physically handicapped. This grant requires a 10%match. The amount requested from TIFB is $55,950,with a match of$6,217 from the City, for a total project cost of$62,167.00. Resource: Dale Ricklefs, Library Director History: This is a third grant request. We've just completed the last grant, which outfitted the computer learning center. The first grant provided the basic adult Internet stations we currently offer. Funding: Cost: match of$6,217.00 Source of funds: Operating budget FY 2002 Outside Resources: TIFB will fund 90% of this project Impact: Existing staff will manage the project. A contractor will be hired to gauge the security of the library's external servers. Benefit: Over 28,000 customers will have access from other locations to the library's various databases, as well as certain databases from the State Library that are not currently accessible. 10 new Internet stations, six for children and 4 for adults, will be added, as will a station for the physically handicapped beyond wheelchair accessibility. Public Comment: None required Sponsor: N/A