Statement of Work for CVN79 Microsoft Suite Training.docx

Statement of Work for CVN79 Microsoft Suite Training

1. INTRODUCTION

1.1 The USS John F Kennedy (CVN79) Training Department has a requirement for Officers, First Class Petty Officers, and Chiefs to be trained on the Microsoft applications, Word 2016, Excel 2016, PowerPoint 2016, and Access 2016.

2. BACKGROUND

2.1 The USS John F Kennedy (CVN79) Training Department is requiring Officers, First Class Petty Officers, and Chiefs to complete both Basic and Advance training in the use of Microsoft applications, Word 2016, Excel 2016, PowerPoint 2016, and Access 2016 to improve performance in completing Evaluations, Awards, and other professional Navy-Writing requirements.

3. DESCRIPTION

3.1 The Contractor shall provide the following:

· Contractor shall furnish a meeting room within a 10 mile radius of 4101 Washington Ave, Bldg 2, Newport News, VA 23607, to conduct the training to accommodate 20 participants.

· Contractor shall furnish current, working equipment with supporting cables, power cords, and appropriate software loaded and set-up prior to class to accommodate 20 participants.

· Contractor shall provide all Course-Materials and Certificate of Completion.

· Contractor shall provide in-person instructor-led training. No virtual instructors. Each instructor shall be certified for the class he or she is teaching and holds extensive experience in the field.

4. Training Course Requirements

4.1. Microsoft Word 2016 Basic and Advanced Training

4.1.1. All training courses should assume students know how to use a computer and are familiar with Microsoft Windows and does not assume students have used a different version of Word or another word processing program.

4.1.2. Microsoft Word 2016 basic training shall provide the basic concepts and skills to include:

· Fundamentals - Creating a document.

· Formatting - Formatting characters and paragraphs, Quick Styles, Making lists.

· Document Set-up-Page lay-out, printing headers and footers, templates.

· Graphics-inserting, formatting pictures and picture layout.

· Tables-Creating and formatting tables

· Shapes, WordArt, and SmartArt

· Managing Documents-Custom Themes, building blocks, section breaks, and page backgrounds.

· Styles - Character and paragraph styles.

· References and Hyperlinks-Reference notes, table of contents, and hyperlinks.

· Navigation and Organization - Navigating and Master documents.

· Saving and Sharing Documents - Saving and Sending, Comments, and Protecting documents.

4.1.3. Microsoft Word 2016 Advance training shall provide the advanced concepts and skills to include:

· Advanced Formatting - Tables and Charts, creating building blocks, and linking text.

· Advanced Document Managing - Configuring Word options, working with templates, and tracking and reviewing changes.

· Using References - Internal references, indexing, and citing external sources.

· Creating Mailings - Recipient Lists, performing mail merges, and envelopes and tables.

· Macros and Forms

4.2. Microsoft Excel 2016 Basic and Advanced Training

4.2.1. All training courses should assume students know how to use a computer and are familiar with Microsoft Windows and does not assume students have used a different version of Excel or another spread-sheet type program.

4.2.2. Microsoft Excel 2016 basic training shall provide the basic concepts and skills to include:

· Fundamentals - Getting around and workbook basics.

· Creating Worksheets - Entering data, formulas, functions, moving/copying data, and reference type.

· Formatting - Text and number formatting, alignment, borders and highlighting, styles and themes.

· Manipulating Data - Data entry shortcuts, paste options, inserting, deleting, and hiding data.

· Charts - Creating charts and chart types and elements.

· Output - Managing worksheet windows, printing and sharing worksheets.

· Settings and Templates - Workbook options, properties, and templates.

· Managing Workbooks - customize Excel

· Named Ranges - Using names in formulas.

· Tables-Sorting, filtering tables, structured references, validation, and transposing data.

· Summarizing Data - Consolidation and subtotals.

· Pivot Tables - Creating, formatting, and manipulating Pivot Tables and Pivot Charts.

· Presentation Features - Conditional and custom formats and Graphics.

· Advanced Charts - Special Chart types, sparklines, and quick analysis.

· Collaboration - Permissions and shared workbooks.

4.2.3 Microsoft Excel 2016 Advanced training shall the advanced concepts and skills to include:

· Logical and Lookup Functions - Decision making functions, Lookup and reference functions.

· Advanced Formulas - Auditing and error-trapping, formula options, and arrays.

· Special Functions - Date/Time, text, and other functions

· Importing and Exporting - The Power Pivot Data Model and exporting data.

· Analysis - The Analysis Toolpak

· Macros and Forms

4.3. Microsoft PowerPoint 2016 Basic and Advanced Training

4.3.1. All training courses should assume students know how to use a computer and are familiar with Microsoft Windows and does not assume students have used a different version of PowerPoint or another slide show program.

4.3.2. Microsoft PowerPoint 2016 basic training shall provide the basic concepts and skills to include:

· Fundamentals - Exploring PowerPoint environment.

· Creating Presentations - Create presentations and creating and modifying slide content

· Formatting - Working with slide masters and layouts, and formatting slides and text.

· Working with Shapes and Images - Creating and formatting shapes and working with images.

· Working with Charts and Tables

· Customization - Slide transitions, additional text options, and printing.

4.3.3. Microsoft PowerPoint 2016 advanced training shall provide the advanced concepts and skills to include:

· Advanced Formatting - Inserting/Formatting SmartArt and additional formatting options.

· Animation, Time Effects, and Media-Animating slide content and inserting and formatting media.

· Reviewing Content, Tracking changes, and Saving in other Formats

· Custom Slide Shows - Working with notes pages, configuring, rehearsing, and presenting slide shows.

· Sharing, collaborating, and Security-Protecting and sharing presentations.

4.4. Microsoft Access 2016 Basic and Advanced Training

4.4.1. All training courses should assume students know how to use a computer and are familiar with Microsoft Windows and does not assume students have used a different version of Access or another data management program.

4.4.2. Microsoft Access 2016 basic training shall provide the basic concepts and skills to include:

· Navigate within Microsoft Access 2016 application, create a simple database, and customize Access configuration options.

· Organize and manage data stored with Access tables.

· Use queries to join, sort, and filter data from different tables.

· Use forms to view, access and input data.

· Create and format custom reports.

· Design a relational database.

· John tables to retrieve data from unrelated tables.

· Validate data entered into a database.

· Use advanced queries to manipulate your data.

· Customize reports to organize displayed information and specific print layouts.

4.4.3. Microsoft Access 2016 advanced training shall include the advanced concepts and skills to include:

· Implementing Advanced Design Form Design - Add controls to forms, enhance navigation of forms, and apply conditional formatting.

· Sharing Data across Applications - Import and export data into Access, link tables, and create mail merge.

· Using VBA

· Using Advanced Database Management

· Distributing and Securing a Database.

· Managing Switchboards - Create and modify a database switchboard, and set startup options.

5. Period of Performance

5.1. The period of performance will be August 1, 2024 through September 30, 2024.

6. Place of Performance

6.1. The place of performance is in and around Newport News, VA 23607.