quiz with google forms and google sheets
Budget: €250 – €750 EUR
Experienced Google Forms and Sheets Developer for Advanced Quizzes
We are seeking a highly skilled and experienced freelancer to develop advanced Google Forms quizzes tailored for educational purposes. The ideal candidate should have a strong background in implementing spaced repetition algorithms (similar to Anki, SuperMemo) and be proficient in Google Sheets to ensure seamless integration and data tracking.
Key Responsibilities:
1. Develop Google Forms quizzes incorporating spaced repetition algorithms to enhance the learning experience.
2. Implement a system to track users' performance and adapt the quizzes accordingly, providing fresh and relevant questions based on their progress, topic preferences, and skill level.
3. Create and manage a comprehensive Google Sheets database, including:
A) Questions Sheet: Categorize questions by topics and levels.
B) Users Sheet: Store user data and preferences for topic and level selection.
C) Specific User "Email" Sheet: Match and store response data from Google Forms, updating the questions as per the user’s performance.
For Example:
https://docs.google.com/spreadsheets/d/1cfjZfRm0r61jaVMEm4l9tbPdaViQCSUlcIdnqM3zeRM/edit?usp=sharing
Spaced repetition:
https://supermemo.guru/wiki/Leitner_system
User has to solve the question correctly 5 times. Each time wrong it goes back 1 step. The time of repetition depends on the correctly answered questions:
Box 1 (1st time): Within 24 hours (1 day)
Box 2 (2 times): After 48 hours (2 days)
Box 3 (3 times): After 96 hours (4 days)
Box 4 (4 times): After 192 hours (8 days)
Box 5 (5 times): After 384 hours (16 days)
Steps Involved:
1. Importing Quiz Questions:
1A) Select multiple-choice questions from the "Questions" sheet based on user selections (topic, level, answered status) from the "Users" sheet.
1B) Import corresponding answers from the Google Sheet to match with the Google Form.
2. Exporting Responses to Google Sheet:
2A) Match responses with the specific user's email sheet.
2B) Update the specific user "email" sheet based on their responses.
3. Generating New Question Sets:
Adapt and generate a new set of questions based on user settings, including topics, repetition patterns, and skill level, to ensure continuous learning and engagement.
Requirements:
- Proven experience in creating advanced Google Forms quizzes and integrating with Google Sheets.
- Strong understanding of spaced repetition algorithms and their application in educational quizzes.
- Proficiency in Google Sheets, including data manipulation, formulae, and scripting.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills and the ability to work independently.
To apply, please submit your portfolio showcasing previous work related to Google Forms quizzes and Google Sheets integration, along with a brief description of how you would approach this project. Include any relevant experience with spaced repetition algorithms or educational tools.
We are looking to move quickly on this project, so prompt responses are appreciated. Thank you for considering our post, and we look forward to working with an outstanding freelancer to bring this project to fruition.
We are seeking a highly skilled and experienced freelancer to develop advanced Google Forms quizzes tailored for educational purposes. The ideal candidate should have a strong background in implementing spaced repetition algorithms (similar to Anki, SuperMemo) and be proficient in Google Sheets to ensure seamless integration and data tracking.
Key Responsibilities:
1. Develop Google Forms quizzes incorporating spaced repetition algorithms to enhance the learning experience.
2. Implement a system to track users' performance and adapt the quizzes accordingly, providing fresh and relevant questions based on their progress, topic preferences, and skill level.
3. Create and manage a comprehensive Google Sheets database, including:
A) Questions Sheet: Categorize questions by topics and levels.
B) Users Sheet: Store user data and preferences for topic and level selection.
C) Specific User "Email" Sheet: Match and store response data from Google Forms, updating the questions as per the user’s performance.
For Example:
https://docs.google.com/spreadsheets/d/1cfjZfRm0r61jaVMEm4l9tbPdaViQCSUlcIdnqM3zeRM/edit?usp=sharing
Spaced repetition:
https://supermemo.guru/wiki/Leitner_system
User has to solve the question correctly 5 times. Each time wrong it goes back 1 step. The time of repetition depends on the correctly answered questions:
Box 1 (1st time): Within 24 hours (1 day)
Box 2 (2 times): After 48 hours (2 days)
Box 3 (3 times): After 96 hours (4 days)
Box 4 (4 times): After 192 hours (8 days)
Box 5 (5 times): After 384 hours (16 days)
Steps Involved:
1. Importing Quiz Questions:
1A) Select multiple-choice questions from the "Questions" sheet based on user selections (topic, level, answered status) from the "Users" sheet.
1B) Import corresponding answers from the Google Sheet to match with the Google Form.
2. Exporting Responses to Google Sheet:
2A) Match responses with the specific user's email sheet.
2B) Update the specific user "email" sheet based on their responses.
3. Generating New Question Sets:
Adapt and generate a new set of questions based on user settings, including topics, repetition patterns, and skill level, to ensure continuous learning and engagement.
Requirements:
- Proven experience in creating advanced Google Forms quizzes and integrating with Google Sheets.
- Strong understanding of spaced repetition algorithms and their application in educational quizzes.
- Proficiency in Google Sheets, including data manipulation, formulae, and scripting.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills and the ability to work independently.
To apply, please submit your portfolio showcasing previous work related to Google Forms quizzes and Google Sheets integration, along with a brief description of how you would approach this project. Include any relevant experience with spaced repetition algorithms or educational tools.
We are looking to move quickly on this project, so prompt responses are appreciated. Thank you for considering our post, and we look forward to working with an outstanding freelancer to bring this project to fruition.