Loading...
2. 03/23/2016 Agreementl AMY REAVILIN, CPA CLERK Of CIRCUIT COURT & COMPiROLIER MONROE COUNTY, FLORIDA DATE: April 9, 2016 TO: Teresa Aguiar, Employee Services FROM. • Cheryl Robertson Executive Aide to the Clerk of Court & Comptroller At the March 23, 2016 Board of County Commissioner's meeting the Board granted approval and execution of Item C4 Approval of Memorandum of Agreement with the Florida Keys Community College (FKCC) for instruction of Microsoft Office Suite software applications for Monroe County employees. Attached is a duplicate original of the above -mentioned for your handling. Should you have any questions please do not hesitate to contact this office. cc: County Attorney Finance File V 500 Whitehead Street Suite 101, PO Box 1980, Key West FL 33040 Phone: 305-295-3130 Fax: 305-295-3663 3117 Overseas Highway, Marathon, FL 33050 Phone: 305-289-6027 Fax: 305-289-6025 88820 Overseas Highway, Plantation Key, FL 33070 Phone: 852-7145 Fax: 305-852-7146 Florida KeQS communnu conoe MEMORANDUM OF AGREEMENT THIS AGREEMENT, made this date between the, FLORIDA KEYS COMMUNITY COLLEGE, hereinafter referred to as "FKCC" and MONROE COUNTY BOARD OF COUNTY COMMISSIONERS, hereinafter referred to as the "Monroe County." It is agreed that FKCC will conduct off -site training of Microsoft Office Suite applications to Monroe County employees. All training sessions will be from 3:00 p.m. — 6:00 p.m. Classes will run with a minimum of five (5) and a maximum of 10 students per class. Each course will consist of six (6) hours of instruction. Marathon Off -Site Location — Wednesdays Excel Fundamentals Word Fundamentals PowerPoint Fundamentals Access Fundamentals Outlook Fundamentals Excel Intermediate Word Intermediate PowerPoint Advanced Access Intermediate Outlook Intermediate Excel Advanced Word Advanced Access Advanced April 6-13, 2016 April 20-27, 2016 May 4-11, 2016 May 18-25, 2016 June 1-8, 2016 June 15-22, 2016 June 29-July 6, 2016 July 13-20, 2016 July 27-August 3, 2016 August 10-17, 2016 August 24-31, 2016 September 7-14, 2016 September 21-28, 2016 Key Largo Off -Site Location — Thursdays Excel Fundamentals Word Fundamentals PowerPoint Fundamentals Access Fundamentals Outlook Fundamentals Excel Intermediate Word Intermediate PowerPoint Advanced Access Intermediate Outlook Intermediate Excel Advanced Word Advanced Access Advanced April 7-14, 2016 April 21-28, 2016 May 5-12, 2016 May 19-26, 2016 June 2-9, 2016 June 16-23, 2016 June 30-July 7, 2016 July 14-21, 2016 July 28-August 4, 2016 August 11-18, 2016 August 25-September 1, 2016 September 8-15, 2016 September 22-29, 2016 Key West Campus Middle Keys Center Upper Keys Center 5901 College Rd., Key West 900 Sombrero Rd., Marathon 89901 US Highway 1, Tavernier (305) 296-9081 (305) 809-3219 (305) 809-3154 K Key West Off -Site at County Specified Location — Mondays Excel Fundamentals Word Fundamentals PowerPoint Fundamentals Access Fundamentals Outlook Fundamentals Excel Intermediate Word Intermediate PowerPoint Advanced Access Intermediate Outlook Intermediate Excel Advanced Word Advanced Access Advanced April 4-11, 2016 April 18-25, 2016 May 2-9, 2016 o May 16-23, 2016 C71 r=- rn June 6-13, 2016 �r CD June 20-27, 2016 CD JuneJune 29-July 6, 2016 `7) n 'a July 11-18, 2016 4 Fq July 25-August 1, 2016 =` IV ,. August 8-15, 2016 tv August 22-29, 2016 September 12-19, 2016 September 26-October 3, 2016 The responsibilities of Monroe County are as follows: 1. Monroe County agrees to pay FKCC $100 per student per each six (6) hour course taught. The responsibilities of FKCC are as follows: FKCC will provide training on laptops to Monroe County employees for Microsoft Office 2010 Suite software. The student will receive a manual for each software training course of instruction they attend. In witness whereof the Parties hereto have executive this Agreement: MONROE COUNTY BOARD OF COUNTY COMIyIISSIONERS Heather'Carruthers FLORIDA KEYS COMMUNITY COLLEGE MO E COUNTY ATTORNEY A =ROVS T M: YNTHIA L. HALL ASSISTANT COUNTY ATTORNEY Date 3-�- �016 Excel 2010 Fundamentals Course Objectives: Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will: • Get started with Microsoft Office Excel 2010. • Perform calculations. • Modify a worksheet. • Format a worksheet. • Print workbooks. • Manage workbooks. ,Excel 2010 Intermediate Course Objectives: Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: • Customize the Excel environment. • Create advanced formulas. • Analyze data by using functions and conditional formatting. • Organize and analyze datasets and tables. • Visualize data by using basic charts. • Analyze data by using PivotTables, slicers, and PivotCharts. Excel 2010 Advanced Course Objectives: Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will: • Work with multiple worksheets and workbooks simultaneously. • Share and protect workbooks. • Automate workbook functionality. • Apply conditional logic. • Audit worksheets. • Use automated analysis tools. • Present your data visually. Word 2010 Fundamentals Course Objectives: In this course, you will learn fundamental Word 2010 skills. You will start by getting acquainted with the Word user interface, creating a new document, and finding help. You will find, select, and modify text. You'll format text as well as paragraphs, and add tables to documents. You'll manage more complicated lists, and insert graphic objects. You'll apply design and layout options to pages. You'll check your documents for spelling, grammar, and other errors, and use other proofing tools to look up information. Finally, you'll customize the Word environment to better suit your individual work habits, and learn additional methods of saving documents. You will: • Identify the various components of the Word interface, create a new Word document, enter text into a document, save a document, preview and print a document, and search Help. • Navigate through a document to find and select text, modify selected text, and find and replace text. • Apply character formatting to text, align paragraphs using tab stops, display text as list items, control paragraph layout, apply borders and shading to paragraphs, apply text styles, and manage formatting in documents. • Insert a table into a document, modify the structure of a table, format a table, and convert text to a table. • Sort a list, renumber a list, and customize a list. • Insert symbols and special characters, and add images to a document. • Apply page borders and colors, apply a watermark, add a header and footer to a document, and control page layout. • Check spelling and grammar and use other proofing tools. • Customize the Word interface and use additional options for saving. Word 2010 Intermediate Course Objectives: In this course, you will expand your knowledge of Microsoft Word. You will work with tables and charts to organize and summarize data. You will use styles and themes to customize the look of your documents. You will add images and custom graphic elements to your documents to graphically show information. You will add building blocks of information and updatable fields to the document to improve efficiency. You will control how text flows around graphics, between paragraphs, and between pages; and use section, page, and column breaks in your documents. You will use templates to maintain consistency between documents. You will use the mail merge feature to customize and personalize content. Finally, you will create and use macros to automate tasks. You will: • Work with tables and charts. • Customize formats using styles and themes. • Use images in a document. • Create custom graphic elements. • Insert content using Quick Parts. • Control text flow. • Use templates. • Use mail merge. • Use macros. Word 2010 Advanced Course Objectives: In this course, you will manage, revise, and distribute documents. You will: • Collaborate on documents. • Add reference marks and notes. • Simplify and manage long documents. • Secure a document. • Create forms. PowerPoint 2010 Fundamentals Course Objectives: Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations. You will: • Identify the basic features and functions of PowerPoint 2010. • Develop a PowerPoint presentation. • Perform advanced text editing. • Add graphical elements to a presentation. • Modify objects in a presentation. • Add tables to a presentation. • Add charts to a presentation. • Prepare to deliver a presentation. PowerPoint 2010 Advanced Course Objectives: Upon completing this course, you will be able to customize the PowerPoint 2010 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations. You will: • Modify the PowerPoint environment. • Customize design templates. • Add SmartArt to a presentation. • Work with media and animations. • Collaborate on a presentation. • Customize a slide show. • Secure and distribute a presentation. Access 2010 Fundamentals Course Objectives: In this course, you will learn to create and manage a fundamental Access 2010 database. You will: • Navigate within the Microsoft Access application environment and create a simple database. • Organize and manage data stored within Access tables. • Use queries to join, sort, and filter data from different tables. • Create advanced queries, including action queries, parameter queries, PivotTables, and PivotCharts. • Create and format custom reports. • Customize Access configuration options. Access 2010 Intermediate Course Objectives: In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. You will: • Design a relational database. • Join tables to retrieve data from unrelated tables. • Organize a database for efficiency, performance, and to maintain data integrity. • Share data between Access and other applications. • Customize reports to organize the displayed information and produce specific print layouts. Access 2010 Advanced Course Objectives: Upon successful completion of this course, students will be able to: • Customize a form layout to improve usability and efficiency of data entry. • Add user interface features to validate data entry. • Use macros to improve user interface design. • Organize data into appropriate tables to ensure data dependency and minimize redundancy. • Lock down and prepare a database for distribution to multiple users. • Create and modify a database switchboard and set the startup options. Outlook 2010 Fundamentals Course Objectives: In this course, you will become familiar with the Outlook 2010 interface, and then use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; and customize the Outlook environment to suit your personal preferences. You will: • Perform basic functions in the Outlook 2010 interface. • Compose email messages. • Read and respond to email messages. • Manage email messages. • Manage your calendar. • Manage your contacts. • Work with tasks and notes. • Customize the Outlook environment. Outlook 2010 Intermediate Course Objectives: Upon successful completion of this course, you will be able to use the advanced features in Outlook to manage the advanced options for message, contacts, and calendar management and perform more advanced tasks such as task assignment, journaling, sharing workspaces, and backing up to data files. You will: • Configure advanced message options. • Perform advanced message management tasks. • Perform advanced calendar management tasks. • Perform advanced contact management tasks. • Manage activities by using tasks and Journal entries. • Share Outlook workspaces with other users. • Manage Outlook data files. ACORDF CERTIFICATE OF LIABILITY INSURANCE �i DATE(MMIDD/YYYY) 2/25/2016 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder In lieu of such endorsements . PRODUCER Arthur J. Gallagher Risk Management Services, Inc. 200 S. Orange Ave Suite 1350 CONTAC NAME: PNONE 352-955-2190 FAx E-MAIL INSURERS) AFFORDING COVERAGE NAIC # Orlando FL 32801 INSURER A: Qualified Self Insurer INSURED INSURER B : INSURERC: Florida Keys Community College 5901 College Road Key West, FL 33040-4397 INSURER D INSURER E : INSURER F : COVERAGES CERTIFICATE NUMBER- 1791743871 REVISION NUMBER - THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. 1�TR TYPE OF INSURANCE INSD WVD POLICY NUMBER MMIDDY� MM/DDY� LIMITS A X COMMERCIAL GENERAL LIABILITY CLAIMS-MADE OCCUR RMC20160301 3/1/2016 3/l/2017 EACH OCCURRENCE $200,000 DAMAGE TO RENTEff- PREMISES Ea occurrence $ MED EXP (Any one person) $ PERSONAL & ADV INJURY $ GEN'L AGGREGATE LIMIT APPLIES PER: ]POLICY ❑ PROJECT ❑ LOC OTHER: GENERAL AGGREGATE $ PRODUCTS - COMP/OP AGG $ Ea Occurrence Agg $300,000 A AUTOMOBILE LIABILITY ANY AUTO X ALL OWNED SCHEDULED NON -OWNED X HIRED AUTOS Ix AUTOS RMC20160301 3/l/2016 3/1/2017 Ea accident)$ BODILY INJURY (Per person) $200,000 BODILY INJURY (Per accident) $300,000 PROPERTY DAMAE Per accident $Included UMBRELLA LIAB EXCESS LIAB CLAIMS -MADE Ini AF$ EACH OCCURRENCE $ HOCCUR AGGREGATE $ DED RETENTION $ WORKERS COMPENSATION AND EMPLOYERS' LIABILITY Y / N ANY PROPRIETOR/PARTNER/EXECUTIVE ❑ ER/MEMBER EXCLUDED, (Mandatory In NH) If yes, describe under DESCRIPTION OF OPERATIONS below N / A BY DATE — - PER OTH- STATUTE ER E.L. EACH ACCIDENT $ E.L. DISEASE - EA EMPLOYE $ E.L. DISEASE - POLICY LIMIT $ DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached If more space Is required) Self Insured per Florida Statute 768.28 - $200,000 per Person / $300,000 per Occurrence Aggregate. With respect to the Florida Keys Community College classes and sports events held in Monroe County. Monroe County 1100 Simonton Street Key West FL 33040 USA CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. y REPRESENTATIVE ©1988-2014 ACORD CORPORATION. All rights reserved. ACORD 25 (2014101) The ACORD name and logo are registered marks of ACORD