Job Description

POSITION: Copy Writer

JOB RESPONSIBILITIES:

- Analyze a sample of all current standards (Word PowerPoint Excel) to identify all required styles elements formulas and advanced features.

Template Analysis Report (documenting required styles formulas and elements for all 3 file types).
- Develop master Google Docs Google Slides and Google Sheets templates that incorporate all necessary formatting and structural elements.

Final Master Templates (Google Docs Slides and Sheets).
- Test the master templates for reversible transfer (Google Word/PPT/Excel) to ensure formatting and functionality remain intact.

Template Transfer Test Report (documenting successful two-way transfer for all 3 file types).

Document Conversion
- Convert all active documents (Word PowerPoint Excel) to the respective Google Workspace format (Docs Slides Sheets) using the developed templates.
- All approximately 150 documents converted to Google Workspace formats.

Quality Assurance (QA):

- Review each converted document against its original source file to confirm:
- Comprehensive QA Checklist/Report for all converted documents (confirming 95% fidelity).
- Correct preservation of all text tables and images.
- Correct application of new styles/themes.
- Functional integrity of spreadsheets (all formulas charts and pivot tables function correctly and produce identical results).

Final Handoff & Training
- Organize and place all final Google Workspace standards in the designated shared Google Drive folder structure.

Organized Google Drive Folder with all final documents.
- Provide a brief overview/training on the developed templates and best practices for future standards creation and transfer across all three formats.
Brief Training Session (up to 1 hour virtual) and a Template User Guide (brief written instructions).

Standards & Requirements
The Contractor must adhere to the following standards and requirements throughout the project:
Fidelity Requirement: All converted documents must meet the following criteria against the original source document:
Content Fidelity: 100% preservation of all text data tables charts and images. No content data point or written word may be lost or altered unless approved by the Client.
Format & Functional Fidelity: Maintain at least 95% fidelity to the original documents appearance (layout styles fonts) and functional results (for spreadsheets all formulas must produce identical final results).
Note: Due to platform differences (especially between Excel and Sheets/PowerPoint and Slides) minor aesthetic differences may be tolerated only if pre-approved by the Client.
Reversible Transfer Requirement: The developed templates must allow for the converted Google files to be downloaded as their Microsoft Office counterparts (Word PPT Excel) and reopened/re-edited and vice versa without significant errors (e.g. lost data broken formulas text overlap).
Formulas & Features: The contractor must identify any Microsoft-specific formulas or features (e.g. complex VBA macros certain Excel functions) that are incompatible with Google Sheets/Slides and document solutions or workarounds.
Tools: The Contractor will utilize Google Workspace (Docs Sheets Slides) and Microsoft Office (Word PowerPoint Excel) for all conversion and testing activities.
Responsible for providing a Timeline with milestones and target completion dates of deliverables

#PSSLL

Job Tags

Similar Jobs