Thursday 28 December 2017

TUTORIAL 2 : RPH TEMPLATE WITH DROP DOWN LIST


Assalamualaikum! Hello people! Today, I'm going to share something new for me related to how to make a drop down list in Excel. Scroll til the end of the post to download the template if you are too lazy to read it k. ^^


Tadaaa! As you can see, I've just finished editing a RPH template with drop down list items since I am that lazy to type and wasting more time on that. So, let me give you some tutorial on how to make one!

WHAT DO YOU NEED :
  • Microsoft Excel (any version)
  • DSKP (of any subjects that you teach)
  • Patience (yessss)

HOW TO DO IT?

1. Launch the Microsoft Excel.

2. Click for Sheet 2 and rename it. (I renamed it as Monday).

3. Create a template of your RPH on Sheet 2. I just copied 2017's template and upgraded it in this kind of form. Simple black and white to save my ink for printing. 




4. Back to Sheet 1 (I renamed it as Drop Down List Menu). In this sheet, fill in the information that you will use for the drop down list items. Make sure you type it in LIST FORM. Just like this :




5. After that, select the rows and right click. Click "Define Name". Something like this (below) will popped up. Just rename the "MONDAY" on the popped up window to something related. So that later, you will use this "NAME" as the reference cells to make drop down list.


6. Then, click Sheet 2 (or whatever that you have renamed it). Click on the box that you want to apply the drop down list menu. Click Data, then click Data Validation. A popped up window will appear. Click List, then at the Source, type "=name". name here is the name that you used in Step 5. (Its a must to put the = sign)

  
7. To check whether it works, you can find it out immediately. It will turn out with a symbol at the end of the row for drop down list items. Like this :


So, that's it! A pretty simple one that I got from YouTube. You can check the tutorial that I have referred HERE. For any inquiries, do email me at hidayu1409@gmail.com.


P/s : No worries, if you are too lazy to make one, just download the template by clicking the icon below. Edit and make it yours! :)


RPH TEMPLATE FOR ENGLISH LANGUAGE YEAR 2 (2018)

Sunday 26 November 2017

Reading 9 : Months of the Year (Song) - Year 1

Hello there!


After the final exam, I realised that I faced a major problem in dealing with my pupils' weaknesses regarding spelling of the months of the year in English. I tried drilling, memorising and spelling test, none of it works well especially for the weaker pupils. So, I decided to come up with a song, which eventually matched with their styles of learning.

This lesson was conducted at the end of the year after the exam since we got plenty of time to waste. Hahaha. First, I distributed the lyrics and we read it together to ensure they got correct pronunciation. This drilling sessions went on and on for two days, without music, just plain reading on the first day, and slowly introduced them with the melody on the second day. So, on the third day, I brought my guitar and we started sing to the song with the melodies learnt.

I started sing with them line by line and repeat with verse by verse. After they managed to do it well, I continued with singing the entire song. The lyric is provided down here. 


Now, let's take a look at the video below :






P/s : You can check out for more post-exam activities in our school's HIP Page. Thanks for reading! :)


Friday 17 November 2017

LA 20 : Mini Story Book

Hello there! So, to deal with post exam activities, I have prepared few activities that test their imagination and knowledge and this is one of them. Exposing them to few content from the Year 4 text book just to fill the remaining days before the holidays. We made a simple magic book, which is as follow (check the tutorial on how to make this book HERE) :




I only asked them to bring scissors and colour pencils, while I provided them with a white A4 paper each. Then, I taught them on how to make the mini book step by step. Seems like they had fun while doing this activity! I explained the content of each paragraph so that they can imagining on how to illustrate their mini story books. The text is taken from Year 4 textbook :



For your information, I did not prepare any sample in this activity as I just don't have the time to do something handwritten and decorative at the moment. Thank God they loved to do it on their own. These are their reactions while doing this activity. Some of them did pretty well and of course, they got variety of imaginations which can be seen in their drawings. :)







Overall, all of them did very well and illustrated it in a great way. Well, I got these two which I believed the best ones among all. Surprisingly, these two are boys' works. Congrats guys!




 P/s : As a post exam activity, this is one of the best for the pupils to reduce their boredom at school. Anyway, thanks for reading!

Monday 13 November 2017

Education.com : Write a Silly Dinosaur Poem (Grammar)


Hello there! Its another new post but this time, its a very special one. I've got an email from Education.com who would like to collaborate their content as a guest in my blog. So, its kind of surprising for me, but yes, I've accepted it. So, here we are! (I made slight changes on the activities to suit the students' need here.) You can refer the original post from them on the link provided below :



credit to Education.com

The photo displayed above showed on the outcomes of this activity which being given from Education.com. Since my students still have limited knowledge in terms of vocabulary, I will ask them to draw their version of dinosaur first using their own imagination. This is because we have limited access on the internet and also books as our resources.

WHAT YOU NEED :
  • A4 Paper
  • Pencil
  • Colored pencils
HOW TO DO IT :

1. Give A4 paper and fold it into two to make it in a size of A5. The teacher introduces the activity to make a poem book with a proper sample and explanation. 

2. Then, let the pupils decide which type of dinosaur that they want to be use as the main character. Let them use their imagination in drawing a dinosaur and give the dinosaur a name.

3. Encourage the pupils to decide on a humorous situation for her character. Personifying a dinosaur and having it involved in activities that people usually do can be quite funny. (example : big eyes, small mouth and so on).

4. The teacher showed a sample of her own silly dinosaur on the whiteboard.

5. Create a list of interesting words (adjectives) to use in the poem and ask the pupils to keep track of all the words written on the whiteboard.

6. Now, brainstorm with them and try to find a rhyming twin for several of the vocabulary words based on the sample given by the teacher.

7. Pupils can begin by creating two sentences that introduce the poem. The last word of the second sentence should rhyme with the last word of the first sentence.

8. Continue the rhyming pattern until they have created three pairs of rhyming sentences that describe their funny dinosaur situation.

9. Write the entire poem neatly on a given A4 paper.

10. The pupils can attach the drawing to the poem with a staple or cut out the drawing and glue it to the second page of the poem book. They can also draw the dinosaur on the given A4 paper.


P/s : This activity can be done as a fun activity towards the end of the year. Thanks a lot to Jessica from Education.com for sharing their ideas to be included in my blog. Thanks for reading! :)

Friday 20 October 2017

LA 19 : Surprising Magic Book

Year : 1 - 6
Lesson : Language Arts / Writing


Hello there!

So, this week, we've been through a three-day course related to the Curriculum Induction for the CEFR. One of the things that we have learnt that attracted me the most was a session of making the magic book. During the IPG life, we have attended a course which also taught us on how to make a magic book (which I was really excited that time), but this version of magic book is waaaayyy too awesome and pretty tricky!

You can check the link for the normal magic book that we always heard HERE

So, the pictures below are the samples of magic books that our group made during the course. Normally, this can be done for riddles or any quizzes with plenty of clues. The inside part is hidden and can be shown by opening the outside (clues part). See for more information at the end of this post. 

inside

 outside

 inside

outside

This is a pretty simple thing to make and quite surprising too!. Check out for further tutorial here, since I did not have any videos while making one during the course. 




P/s : Thanks for reading! :)

Friday 13 October 2017

LA 18 : 3D Foldable Crafts (Vehicles, Buildings, Animals, Toys)

Year : 1 - 6 (based on the suitability of the crafts)
Lesson : Language Arts

Hello there!

Well, today I would like to share a new craft that I bought at a DIY store. Sorry, but I can't remember the exact price of it. Just check it out at the store. It is a 16 scissors-less craft because it was supposed to be directly done from the given template. But, to provide each for the pupil, I have scanned it, edit it into black and white template so that they can colour it according to their preferences. So, here's what it looks like :




The original one is pretty thick and we just need directly take it out from the cut outs and assemble it. So, I have conducted this class with my Year 3 pupils as a freedom day of the week. My sample of the paper 3D foldable craft looked like this :


Double Decker Bus

As usual, I've prepared the edited (black and white) template for you to print it out and carry out in your lesson. Here's the link :

 3D Foldable Crafts (Vehicles, Building, Animals, Toys)

P/s : I used this as a reward for those who completed their works properly throughout the week. It works well! Thanks for reading! :)

Sunday 10 September 2017

Writing 12 : Words in A Word

Year : 3
Lesson : Language Games



Hello! I'm back with new activity to enhance my students' vocabulary and allowed their brains to think outside the boxes. So, since they have finished their syllabus, I decided to conduct interesting activity that will help them to enjoy learning English more.


Basically, 'Words in A Word' game is related to the ability of the students to create as many words a as possible during the given time. Initially, I conducted this activity individually the day before, and I could see that few of the students were struggling to come out with other related words. Thus, I decided to continue this game in pairs and groups of three the next day. As a result, they managed to come out with even better words! At the same time, they have learnt how to use the dictionary wisely. For those who did not have dictionaries, they can also use their textbooks to find the proper words related to the word given. 

For example, I gave the words 'BASKETBALL'. They have to create 3 letters words, 4 letters words, 5 letters word and 6 letters words as many as possible based on the word 'BASKETBALL'. To make it even competitive, I've prepared a reward for a student who came up with the most correct words, and they did very well. I did asked some of them about this game and they said they loved it since it challenged them to think more and more within the time limit.

This game showed that words have no limit. They are free to create new words but they need to ensure that the words created exist in the dictionaries. That's it!











P/s : In case you are wondering, I let my Year 3 students to write the days and dates by themselves everyday since we have learnt about it. So, they need to know how to write it properly. Thanks for reading! :)

Sunday 23 July 2017

LA 17 : Mobile Paper Butterflies

Subjek : Pendidikan Seni
Tahun : 3
Topik : Membuat Mobail Haiwan Bersayap

Entri ini ditulis dalam Bahasa Melayu sebab ini untuk subjek Pendidikan Seni. Walaupun boleh digunakan untuk subjek Bahasa Inggeris. Ini adalah pertama kali aku kena ajar subjek Pendidikan Seni. Bila rujuk RPT dari internet, minggu lepas kena buat Mobail Haiwan Bersayap. Mula - mula tak tau la apa tu mobail, Ingatkan benda berkaitan dengan kereta. Hahaha!

Ok. Mobail tu benda yang bergantung, apa - apa bahan seni yang bergantung (betulkan jika salah, sebab aku main google je benda ni). Jadi, untuk melaksanakan 1 jam pelajaran ini, aku buat keputusan untuk membuat Rama - rama kertas yang boleh digunapakai untuk hias pentas sekolah kalau ada majlis - majlis.

Berikut adalah gambar - gambar sepanjang aktiviti :


ni yang murid - murid buat dan dermakan untuk hiasan pentas














Bahan - bahan yang diperlukan :

  • Kertas warna A4 / kertas origami / kad manila (*saiz kertas menentukan saiz rama - rama ye. Kertas biasanya ditaja oleh guru Seni kalau murid - murid tak bawak bahan)
  • Gunting (kalau takde, guna pembaris pun boleh)
  • Gam (optional)
  • Tali / Benang (sebab mobail kan, mesti ada tali atau benang la, pun ditaja oleh guru Seni sendiri)

Cara - cara nak buat :

*ketahuilah bahawa aku cuma menonton video dari YouTube ini dan membuat dua sampel rama - rama untuk murid - murid. So, sila klik video di bawah ye. Sesi ni dimulakan dengan mengajar murid - murid cara - cara melipat kertas ini dengan betul. Kesabaran amat diperlukan bagi membenarkan murid - murid berjaya membuat satu rama - rama dengan tepat. Selepas itu, aku cuma perlu membantu mengikat rama - rama yang mereka buat.




Sekian perkongsian. Terima kasih kerana membaca!

Wednesday 19 July 2017

L & S 14 : Pretend Play at the Airport

Skill : Listening and Speaking
Topic : I See Numbers
Year : 3

This lesson is the continuation of learning numbers from twenty-one to thirty. Since I have teach them about the numbers, doing a pretend play related to it makes them remember better. Besides pretend play at the bus stand (where they are more familiar to it), I decided to change it to an airport situation. Yes, they asked a lot while they are 'on the plane'.

I started by distributed blank template of boarding pass which is as below :


This template is taken from HERE because I was too lazy and tired to design one. For a complete set of airline pretend play, you can refer these websites :



Then, instead of providing them with complete and printed version of boarding passes, I provided them with my own samples of two boarding passes from Air Asia and Malaysia Airlines for them to copy and draw it themselves.


These boarding passes have been ripped off by the 'person-in-charge'



How do I chose the pupils and specific characters?

Simple. Those who lost their own boarding passes (I gave them to complete these templates a day before) are chosen to be the person-in-charge of the check-in counter, become the departure gates, the person-in-charge to check and ripped off the boarding passes. Meanwhile, those who have their boarding passes definitely become the passengers of the flight.

So, I demonstrated each role and provided them with scripts especially those at the check-in counter. Surprisingly, they did very well which I was quite amazed with their hidden talents in playing the roles. I can also see that some of the pupils deserved to be in such kind of works when they grew up later on. At first, they were confused since there were so many departure gate labels that I have prepared (21 until 30). I told them, at KLIA2, we have about 22 gates since in Tawau we're only have 4 gates. I explained and told them about how big the KLIA and KLIA2 is as compared to the Tawau Airport.

So, after the entered the gate, they entered the plane. I became the captain of the flight, making usual flight announcement. So, in the flight, the pupils asked so many things that they were curious of. For example :

Pupil A : "Teacher, ada tandas ka di kapal terbang?"
Teacher : "Yes, of course. But, small one only. Like the size of that cupboard."

Suddenly, pupil asked permission to go to the toilet. So, I let them. But, they purposely went to 'that plane's toilet' at the cupboard. Hahaha. Then, I told them, "you don't have to ask permission to go to the toilet when you are on a plane!" Simply go when the seat belt sign is turned off. 

They asked about tv, food, drinks, price tickets, how to call the stewardess when you need something. So, to me, this activity brings a lot of new experiences and exposure towards the airport situations. I can see that these kids have the flare and ambitions to do well in their life and they need to realise that education is the main key.

To end this post, I let you see some photos of the activity conducted.


 *Check-in counter. The pupils carried their own bags for checked in. 












There were cases were the passengers (pupils) forgot their gates. I said, simply asked the counter because they will tell you the gates for departure. It was a really fun activity to end our day yesterday. Thanks for reading! :)

Popular Posts

Copyright © DIY Teaching Aids | Powered by Blogger
Design by Viva Themes | Blogger Theme by NewBloggerThemes.com