Sociogram Add-on for Google Forms Development

**Project Title:** Development of a Google Forms Add-On for Sociogram Questions and Automatic Report Generation **Project Description:** We are looking for a professional or company to develop an add-on that expands the functionalities of Google Forms. This add-on will enable the creation of sociogram questions, process responses, and generate detailed reports with visual analysis. The goal is to facilitate the collection and analysis of data on social relationships in educational or organizational settings. **Functional Requirements:** 1. **Creation of Sociogram Questions:** - Respondents should be able to select other respondents from a list automatically generated from the entered participants. - Questions should include options for positive and negative selection (e.g., "Who would you prefer to work with?" and "Who would you prefer not to work with?"). 2. **Response Processing:** - Automatically collect and analyze responses. - Identify positive, negative, and mutual connections among respondents. - Detect complex relationships, such as unreciprocated positive selections. 3. **Automatic Report Generation:** - Create downloadable reports with: - Detailed listings of connections by type (positive, negative, mutual, etc.). - Data summaries per participant (number of positive, negative, and mutual selections). - Relationship diagrams (visual connection graphs). - Export results to PDF and Google Sheets formats. 4. **Integration with Google Workspace:** - The add-on must integrate directly into Google Forms and Google Sheets. - Include a user-friendly interface for configuration and result visualization. **Technical Requirements:** - Use of Google Forms and Google Sheets APIs. - Compatibility with Google Workspace tools. - Development using Apps Script or another technology compatible with Google. **Expected Deliverables:** 1. Functional add-on installed in Google Forms. 2. Source code of the add-on. 3. Technical documentation for usage and maintenance. 4. Example report generated with sample data. **Required Skills:** - Experience in developing add-ons for Google Workspace. - Knowledge of Apps Script and Google APIs. - Experience in data visualization and analysis (desirable). **Budget and Timeline:** - Please provide the estimated cost and time required to complete the project. - Proposals with previous examples of similar work will be highly valued. **Additional Information:** We have attached a PDF file with an example report generated by a similar add-on previously used. This will serve as a reference for the expected report design. We look forward to your proposal! If you have any questions or need further details, please feel free to ask. We require the following types of visualizations: Node and Relationship Diagrams: Representing participants as nodes and their relationships as edges. Positive connections should use solid lines (e.g., green), negative connections dashed or dotted lines (e.g., red), and mutual connections should be emphasized with thicker or differently styled lines. Conflict and Affinity Matrix: A grid or table format showing conflicts and affinities between participants. Positive and negative relationships should be visually distinguishable with colors or symbols. Bar Charts: Displaying the number of positive mentions and negative mentions for each respondent. Clear differentiation between positive and negative values, with labeled axes for easy interpretation. Interactive versions of these visualizations are preferred, but static diagrams will also be acceptable if they are clear and detailed. Let me know if further clarification is needed. The visualizations should be node and relationship diagrams. The expected level of interactivity for the visualizations is as follows: moderate. The visualizations should offer moderate interactivity, such as zooming and filtering options. Additionally, visualizations should be exportable in PNG format. The user configuration interface should follow a simple and minimalistic design. The project should include other support services: in addition to some support. The data summaries should include the number of positive, negative, and mutual selections, as well as additional metrics such as centrality or influence scores. Skills Required: Google Apps Script Development Data Visualization Google Workspace API Integration Graphical Reporting Tools JavaScript Programming