Excel Female and Male Ratio Chart

Learned how to create a female and male ratio chart and amazed on the effect. 

1.  Create a table with the data for 2 variables - Male and Female

2.  Highlight the table and insert a chart -clustered column

3. Remove the Title, Legend and Y axis

4. Click on the chart area to bring up the chart elements (+ sign at top right)

5. Uncheck the box with gridlines

6. Click on the blue bars and click on the chart elements.

7. Check the box on data labels.

8.Click on Insert icons

9. Search for "Person"

10. Select Male and Female Icons followed by insert.

11.  Select the male icon and  graphic format then select Graphic fill and blue color.

12. Select the female icon and  graphic format then select Graphic fill and orange color.

13. Select both icons - press control button and  click on both icons.

14. Press Control + C and then Control + V to copy and paste the male and female icons.

15. Click on the copied Male icon and select Black for the outline and No fill under graphic format.

16. Click on the copied Female icon and select Black for the outline and No fill under graphic format.

17. Select Male (filled) and press Control +C

18. Click on the Male Blue bar twice (to ensure that only the Male Blue Bar is selected)

19. Press Control +V

20. Select Male (No fill) and press Control +C

21. Click on Male Orange Bar twice (to ensure that only the Male Orange Bar is selected)

22. Press Control +V

Repeat Steps 17 to 22 for Female

23. Click on the Male bar (filled) and right -click format data series.

24. Select fill Picture or texture and stack and scale with

25. Click on the Female bar (filled) and right-click format data series.

24. Select fill Picture or texture and stack and scale with

25. Click on any of the bar (once)

26. Right click format data series and select series overlap =100%, gap width =0% - both the data for male will be stacked as well as the female. 

You can tidy up the graph by shifting the data labels above the icons as well to remove the data label lines. The amount of fill will change when you change the values in the table. 

uploaded to Google drive  but you will need excel for it to work. 

https://docs.google.com/spreadsheets/d/1PD0gjokbfuHcMGOysndp4Ay1RMmZXaJe/edit?usp=drive_link&ouid=118231387967860983986&rtpof=true&sd=true

Capy: Choice eliminator Google Form

 Capy: Choice eliminator add on to Google Form

This is a Google Form add on so after you have created the google form with the questions containing options, you can add this to your form and set the limit to the form.

In Google Form, create a blank form. 
https://docs.google.com/forms/

Choose Multiple choice and add in the question and options.

Click on the 3 dots setting and select get add-ons. 

Search for CAPY and click on install.

After you have installed the CAPY add-on, click on the add-on icon and select CAPY from your Google form. 

Click on start in the pop-up menu

A pop-up menu will appear for you to change the number limit value for each option:

For example I have set a value of 3 to workshop A, 2 for workshop B and 1 for workshop C.

When the one vacancy for workshop C is taken, only the other two workshops are visible.

AI Smart Goal Generator

A good AI activity to embark on at the start of the year. This interactive SMART Goal Generator space equips educators and students with a structured approach to setting specific, measurable, achievable, relevant, and time-bound goals. By asking for pertinent details, the AI provides guidance in formulating a comprehensive goal and action plan, complete with a progress tracker.  

 The teacher's dashboard. You can see the progress of each student. 

The student's dashboard - you can see that he/she can interact with the AI which will give prompts to guide the students to set SMART goals.

https://app.schoolai.com/spaces/clzhn1mof0d0nty4kz4vhqh6y

Padlet sandbox

Padlet Sandbox is similar to Jamboard, a digital whiteboard, which offers great opportunities for collaborative learning. You can also use the templates to create games such as the jeopardy game or create your own adventure game. It is easy to use and would appeal to educators who are already familiar with the use of Padlets. The ability to create cards for different groups and hyperlink to the different cards can help to create fun and engaging activities.  

https://padlet.com/site/sandbox

Watch the video below - you can also use it to create your own adventure story by hyperlinking the cards. You can even turn it into a game!

Try the template for jeopardy game - https://padlet.com/samplemisha/padlet-jeopardy-fofcldk855n4ob6c
You can also create an interactive story map https://padlet.com/samplemisha/wildlife-wonders-cfuhqm2kmu3u7y8z

I used the padlet sandbox tool in a CCE lesson on Religions. Each group was given a religion to work with. The group drew the paper containing the assigned religion from a bag and the groups have to read more the religion from a pdf file. The groups then wrote/drew features/clues on the religion on each assigned card on the sandbox. Every member of the group can add on to the card assigned. Feedback from students - its more fun and that it is less laggy than former Jamboard.  

You can see the different types of inputs from the members of the group - some prefer to write, some to draw and some to type. You can see the students work on the cards simultaneously synchronized. 

Some prefer to write and draw. 

Some prefer to add images and type.

SLS new AI Authoring Copilot

 The new Authoring Copilot (ACP) is able to automatically:

a. Generate Section title, notes, description and tags from Module notes, description, and content map tags​.

b. Generate Activity title, notes and description from Section title, notes, description and content map tags and any uploaded knowledge base​.

c. Generate Components (Text/Media, MCQ, FRQ, Poll) from Activity title, notes, description and any uploaded knowledge base​.

d. Automatically create these Sections, Activities and Components in SLS after the teacher accepts the recommendations for further editing.

Lalal AI audio editor

Lalal.ai uses artificial intelligence to make your audio file or audio track from a video sound better. You can clean up audio, separate a speaker from background music, separate audio tracks, and more without sound engineering knowledge. 

https://www.lalal.ai/

https://constructingmodernknowledge.com/ai-whitepaper/

Descript Video Editor

Try this AI video editor with amazing features.

• It can automatically generate the transcript which you can edit.
• You can remove the fillers e.g. umm.. uh.. 
• You can jump cuts or shorten the parts which have long pause e.g. 3 seconds to 0.25 seconds.
• You can remove background and insert AI green screen.
• You can do voice cloning.

https://www.descript.com/?lmref=65pAYQ

https://constructingmodernknowledge.com/ai-whitepaper/

Limitations to free version restrict the transcript to 1hr per month and only 10 mins to the use of most features such as removal of background and voice cloning. The free version also has low export resolution of 720p and watermark.

Video explorer School AI

1. Sign in to school AI https://schoolai.com/

2. Select discover and select Video Explorer.

I have chosen a video on pro-poor tourism for the lesson.  

https://www.youtube.com/watch?v=p1bizZaKMac

Enter the YouTube video url.

You can also show the video to the class first and allow the students to explore the content of the video by asking questions or getting feedback from the AI. It is all personalised!

On the student's device.

The AI will provide questions to check on the student's understanding based on the video. 

The student's can also ask the AI questions and dive deeper into the issue.

On the teacher's device, you can view the engagement level as well a summary of what the student's are engaged in. You can click on the 3 dots to view the individual student's chat. On the right hand side AI will suggest on what the student have feedback and can be used to extend the learning.

There is also option to download the AI insights on the individual student's learning.

The AI is even sensitive to the student's emotional wellbeing.  Above showed that the AI picked up that the student is very tired.

For students who responded not on the topic, AI is very patient to ask other questions and continued to affirm the student's responses.

Brisk Teaching

 Utilizing AI, brisk teaching  chrome extension can create quizzes, lesson plan, depth of knowledge activities and many more in seconds. Content created integrates seamlessly with Google workspace. 

 Just install the Chrome extension here https://chromewebstore.google.com/detail/brisk-teaching/pcblbflgdkdfdjpjifeppkljdnaekohj

After you have installed Brisk teaching chrome extension, just select from the menu what you would like to create. For example DOK questions

Input the learning objectives of a lesson and questions with activities on different depths of knowledge are generated on a Google doc.  Questions associated with different depths of knowledge  were instantly generated. There were even suggestions of strategies to increase their depth of knowledge. 

You can also inspect how students are creating and revising assignments on Google Doc. 

You can see a demo here too https://www.briskteaching.com/inspect-writing-demo

Watch this video to see other uses of this awesome AI chrome extension.

Pulse Exit Pass

Have you ever wish you could provide personalised feedback to each student instantly? Now you can with an AI powered exit ticket. Invite students to show what they learned today and how they’re feeling about it. You can instruct the AI to review specific learning outcomes. Student sentiment and confidence will be displayed to you.

Utilising AI to review a exit pass for a lesson.  You will be prompted to create an account with School AI.

https://schoolai.com/

Limited to only 75 participants per day for the free version.

Select Discover from the menu and then select Pulse Exit ticket. 

Enter your lesson overview and the learning outcomes you want AI to review with the students. 

Click on launch pad and then get the students to scan the QR code or give them the link e.g. in Google classroom. 

You can get feedback from the AI on the students' engagement level.

When you click on the three dots of the respective student you can view the chat.