Design a guide on the Use of Advanced Microsoft Excel tools in Data entry
Design a comprehensive guide on using Advanced Microsoft Excel tools for data entry tasks.
Overview
Design a comprehensive guide on using Advanced Microsoft Excel tools for data entry tasks.
You have:
- Masters Degree in Statistics, Biostatistics, or a related discipline such as MPH.
- Previous experience in preparing lecture materials or working in educational settings.
- Familiarity with international academic standards and practices.
- Desired: PhD in Statistics or Biostatistics.
- Proficiency in Microsoft Word and PowerPoint.
- Ability to integrate multimedia (e.g., images, tables, YouTube links) into educational documents and slides.
- Strong written and verbal communication skills to prepare professional-grade materials.
- Capacity to meet deadlines while delivering high-quality work.
- Ability to prioritize tasks and manage the creation of multiple materials simultaneously.
Contract
This is a UNV contract. More about UNV contracts.
Africa Youth for Peace and Development (AYPAD) has long been committed to empowering African youth and professionals through capacity building, education, and sustainable development initiatives.
The Trainer International Project is part of a larger effort to address global knowledge gaps by equipping professionals with advanced research tools and fostering a culture of innovation.
Volunteer contributions play a pivotal role in this initiative. Trainers, coordinators, and support staff collaborate to design, deliver, and evaluate courses, ensuring they meet international standards while addressing local needs. The project also emphasizes digital learning and artificial intelligence integration, aligning with contemporary educational trends and creating a robust platform for knowledge sharing and collaboration. Through the Trainer International Project, AYPAD demonstrates its commitment to sustainable development, empowering individuals, and advancing equitable global progress.
As part of the Africa Youth for Peace and Development (AYPAD) initiatives, Trainer International Project furthers the organization’s goals of promoting youth empowerment, advancing knowledge-sharing, and fostering sustainable development. It empowers participants with critical research skills, enabling them to address societal challenges, innovate solutions, and actively contribute to the betterment of their communities. By focusing on practical, interdisciplinary education, the project also enhances collaboration and strengthens networks within and beyond Africa, promoting a culture of excellence and leadership.
The Trainer International Project contributes directly to SDG 4: Quality Education and SDG 17: Partnerships for the Goals. By offering specialized skills in research methods, biostatistics, and data analysis, the project fosters lifelong learning opportunities, enhances the global research landscape, and builds capacity among researchers and professionals. Its inclusive approach ensures equitable access to education, particularly targeting underrepresented groups, including women, youth, and professionals in low-resource settings.
The Trainer International Project advances AYPAD's mission by prioritizing youth capacity building through hands-on training. Young researchers are equipped with critical skills to excel in academic and professional fields, empowering them to contribute effectively to societal development. By targeting diverse participants, the project promotes inclusive development, ensuring that marginalized groups have access to high-quality training and resources. This inclusive approach strengthens the role of underrepresented voices in addressing global challenges.
Additionally, the project plays a pivotal role in strengthening global networks. By fostering international partnerships, it expands AYPAD’s influence in global development efforts and creates opportunities for collaborative innovation. Furthermore, the initiative emphasizes advancing knowledge dissemination by providing platforms to publish research outputs. This ensures that the knowledge generated is accessible and impactful, contributing to a global culture of evidence-based decision-making and innovation.
We are seeking 1 online volunteer to Design a guide on the Use of Advanced Microsoft Excel tools in Data entry.
As a volunteer, you will structure the material into three Parts. Part (A): Canvas Notes Word Document Part (B): Lecture Slides PowerPoint Part (C): Marking Guide Word Document
Part (A): Canvas Notes Word Document: Structure a Word document which will be submitted to Canvas. The Word document must have the following 1. Lecture Notes (Text, Images, Tables & Illustrative Videos -Paste a YouTube Link) 2. One Open Ended Discussion Question. 3. One Take-home Question for Assignment. 4. 25 Multiple-choice questions.
Part (B): Lecture Slides PowerPoint: You will Structure your Teaching slides to have the following 1. Summarize the Lecture Notes (Text, Images, Tables & Illustrative Videos -Paste a YouTube Link) 20 slides 2. One Open Ended Discussion Question. 3. One blank slide (5 minutes break). 4. Reference Materials(References and their links)
Part (C): Marking Guide Word Document: You will Structure your Marking Guide to have the following 1. 25 Multiple-choice questions as presented in the Canvas Notes Document. 2. Highlight The Most correct Answer(s)
Prior to the assignment, the Online Volunteer will receive an orientation session, during which they will receive guidance on the task and provided the documentation, information and references required to complete it.
Academic Writing and Content Development Ability to write clear, concise, and engaging lecture notes. Proficiency in structuring academic documents, including incorporating text, images, tables, and illustrative YouTube links. Experience creating educational materials tailored to diverse learning styles.
Instructional Design Familiarity with designing lecture slides that summarize key points and incorporate multimedia elements. Expertise in structuring teaching slides for optimal learner engagement and clarity. Understanding of effective teaching strategies, including the use of breaks and discussion prompts.
Assessment Design and Marking Guide Development Proficiency in crafting open-ended discussion questions and multiple-choice questions (MCQs). Skills in creating accurate marking guides with clear explanations of the most correct answers. Ability to align assessments with lecture content and learning objectives.
Technical Skills Proficiency in Microsoft Word and PowerPoint. Ability to integrate multimedia (e.g., images, tables, YouTube links) into educational documents and slides. Familiarity with Canvas or other Learning Management Systems (LMS) is an added advantage.
Subject Matter Expertise In-depth knowledge or familiarity with the module's subject area to ensure accurate and relevant content. Ability to research and reference credible academic materials appropriately.
Communication and Collaboration Strong written and verbal communication skills to prepare professional-grade materials. Ability to align with Trainer International Project standards and objectives.
Time Management Capacity to meet deadlines while delivering high-quality work. Ability to prioritize tasks and manage the creation of multiple materials simultaneously.
Preferred Qualifications Masters Degree in Statistics or Biostatistics field or related discipline such as MPH. Previous experience in preparing lecture materials or working in educational settings. Familiarity with international academic standards and practices. Desired: PhD in Statistics or Biostatistics.
Potential interview questions
| Can you describe a time when you successfully designed educational materials? | This question assesses your experience and ability to create engaging learning resources. | Provide a specific example, focusing on your creative approach and effectiveness. |
| How do you ensure the materials you design meet diverse learning styles? | The interviewer wants to know your strategies for inclusivity in educational design. | Pro members can see the explanation. |
| What methods do you use to manage your time effectively on projects with tight deadlines? | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you give an example of integrating multimedia into your teaching materials? | Pro members can see the explanation. | Pro members can see the explanation. |
| How do you align assessments with learning objectives when creating educational content? | Pro members can see the explanation. | Pro members can see the explanation. |