Microsoft Office 365/ Microsoft Team (DOD version), Azure, Power BI, & Power Apps Training

Statement of Work Microsoft Office 365 / Microsoft Teams (DoD version), Azure, Power BI, & Power Apps Training GENERAL REQUIREMENTS: Contractor to provide training and is able to support one of the following methods: In-person training at the U.S. Coast Guard Finance Center, 1430 Kristina Way, Chesapeake, VA 23326. Off-Site within 20-mile radius of U.S. Coast Guard Finance Center. 2. INSTRUCTOR REQUIREMENTS: Contractor to provide resumes (not to exceed 2 pages) for a pool of 4-5 potential instructors, one of which will be presenting the course. Instructors must have a minimum of 3 years of Governmental practical experience in the application of subject material (not including academic or instructional experience). 3. SCOPE OF WORK: This training should provide participants with a general understanding of the functionality and operation of Microsoft office 365 as currently used on the DoD / USCG computer network, highlighting the Teams and Sharepoint components. This course should address the objectives below. Learning Objectives: Enhance understanding of the functions, use and operation of Microsoft Teams 365 Develop knowledge and abilities related to Power Business Intelligence (BI) Understand the abilities and functionality of multiple Power apps, building the skill necessary to utilize these to accomplish work tasks Understand the abilities and functionality of the database application Azure in order to create a detailed database of over 400 positions, vacancies, grades, titles, etc. Understand the abilities and functionality of whatever method is used to create detailed organizational charts from the database created in previous step, and be able to break down the organization chart by Division, Branch, Section, Unit and Team, pulling into the organization chart different categories needed depending on audience, i.e. some may have name, grade, series, position codes, vacancy status, hiring status and some may be simpler and just have name, grade, etc. Develop the ability to build a workflow for practical use in human resource management Create & generate reports based on data contained in workflow Learn how to create workflows that can collect information from employee users and managed by administrative staff Training must include practical hands-on exercises. Duration: 5 business days (8:00am- 4:00pm) including 1 hour for lunch each day. Requested training date: Training must begin before September 30, 2022 or vendor enrollment deadline for training September 30, 2022 Number of attendees: 12 students Target audience: CG FINCEN administrative and human resource personnel. Detailed syllabus to accompany bid. Firm fixed pricing under GSA Contract Pricing should be all inclusive to include travel, per-diem (if any), and any other cost associated with this training. If slides/projection are required, vendor to provide computer/laptop with HDMI output to connect with FINCEN projection equipment. If internet connectivity is required for the instructor's computer, vendor shall provide their own (i.e. AirCard, HotSpot, etc.). No such capability (neither wired nor wireless) will be provided for non-USCG computing devices. Upon scheduling, vendor to provide a list of all training aids that CG FINCEN should provide including computer needs. After scheduling, and no later than two weeks prior to the course, provide to CG FINCEN Logistical Point of Contact any data files that need to be disseminated to students prior to the course. 4. IMPORTANT NOTES: Course content must contain case studies, practical exercises, or scenario based training to provide students an interactive learning experience that enhances skills. Instructor(s) must arrive at training site 1 hour prior to scheduled start time on the first day of class and 30 min prior on remaining days. Vendor to provide information regarding student testing requirements (if applicable). Bid to Indicate the amount of CPU/CEU/PDU's to be awarded for attendance. Provide certificates of completion with the associated CPU/CEU/PDU's within 10 days of course completion. 5. DESIGNATED CONTRACTING OFFICER'S QA EVALUATOR (QAE) REPRESENTATIVE: The designated contracting officer's QAE and logistical representative is Jeff Wright 757-366-6550. Jeff.L.Wright@uscg.mil 6. TRAINING SITE: The US Coast Guard Finance Center (FINCEN) has parking at no cost. Instructors may arrange for a site visit by contacting Jeff Wright. Instructors must provide State or Federal approved identification to enter the premises. 7. CONDITIONS AFFECTING THE WORK: The Offeror should visit the site and take such other steps as may be reasonably necessary to ascertain the nature and location of the work, the general and local conditions which can affect the cost of the work thereof. Failure to do so will not relieve bidders from responsibility for estimating properly the difficulty or cost of successfully performing the work. The government will assume no responsibility for any understanding or misrepresentations concerning conditions made by any of its officers or agents prior to the execution of the contract, unless included in the request for quotes, the specification or related documents. 8. ORAL MODIFICATION: No oral statement of any person other than the contracting officer shall in any manner or degree, modify or otherwise affect the terms of this contract. 9. WORKMANSHIP: All work shall be accomplished with the best standard practices, and by workmen thoroughly experienced in the required trades. The work shall be supervised by experienced personnel and shall be satisfactory to the Contracting Officer. 10. PERMITS: The contractor shall without additional expense to the government, obtain all appointments, licenses, and permits required for the prosecution of the work. The contractor shall comply with all applicable federal, state and local laws. 11. WORK OUTSIDE REGULAR HOURS: If the contractor desires to carry on work on Saturday, Sunday, holidays or outside the unit's regular hours, must submit their request in writing to the Contracting Officer's QAE Representative for approval consideration. The contractor shall allow ample time to enable satisfactory arrangements to be made by the government for inspecting the work in progress. 12. UPON COMPLETION OF WORK: Contact the Contracting Officer's QAE Representative to arrange for inspection/acceptance of work. 13. IDENTIFICATION OF CONTRACTOR PERSONNEL: The contractor shall provide a detailed list of all employees to the QAE Representative five (5) days prior to commencing work. The employee list shall contain the employee's full name. The onsite Security Officer will be given a copy of the employee list and a pass will be issued for entry.