Google App Script – Independent Discovery

I always want to improve my coding skill and I have had many Independent Discovery about coding. For this Independent Discovery, I’m coding Google Apps. I can add my code to any Google Apps such as Spreadsheet, Docs, Form, etc. So, why Google Apps? Most of Liger students and staffs use Google like Google Drive, Spreadsheets, Docs. I was sure that they had a bad day interact with them. I was thinking if I could write a feature that solves some problems they have, it would be better. I have interviewed a facilitator and a catering manager about their problems with Google Spreadsheet or Google Docs.

Caroline, a facilitator had a problem with copying a Master Docs and Sharing and I fixed that with some lines of code.

Matt, Catering manager had a really big problem with Ordering Form Spreadsheets. Liger just has an ordering form system for each apartment to order items to cook. There are eight apartments and every apartment has a Spreadsheet to order the items. In some case, the items weren’t on the list so Matt has to go to every spreadsheet of all apartments and add a new item. Another case is the item price is not constant, some months might the price is increase and Matt has to change the price to every spreadsheet. Yes, each apartment spreadsheet has 12 sheets. 8 * 12 = 96 sheets. It means if he wants to add a new item or change price, he must add or change to 96 sheets.

THAT’S A LOT!

I wrote the feature for him and it much faster than copy and paste. Video below is the features demonstration on ordering form:

Startup Weekend

Woh, it was tired join a 54 hours event, Friday noon till Sunday night. 12 of Liger students joined this event at Phnom Penh and we have worked really hard. Startup Weekend is a global event where we can pitch an idea, form the team and start the business, it happens every weekend around the world. I didn’t pitch an idea but I decided to join with one pitcher and have a team of six members. The problem that we see is that students don’t have a goal, it has a goal but don’t know where to start. Our solution is to create a website where students can do a personal test (if they don’t know they have an academic or don’t have a goal) and students can find opportunities by their academic. My role of the team is a developer, but I also share many ideas because I am a high school student so I know how the students feel.

We spent two days on the brainstorming solution and how to make money from the solution. 80 percents of the time we felt very stressed, our mentor asked many difficult questions. The questions help our team a lot. I worked really hard on the website for the whole Sunday.
Check our company website. http://www.academicgoal.co/

Finally, we pitched to judges and we won the top three team. The judges said we won because the problems that we come up is a serious problem in Cambodia and we came up with a good solution.

Uri Levine, co-founder of Waze said, fall in love with the problem, not the solution.

I learned so much about business from this event even if we very tired.

 

Drone Lesson

Liger bought two DJI drones, one is for the training and another is for the filming that has a camera attached. Drone were introduce when a filming team from United State that came to take a film about Liger. The drone really inspire me as well as everyone at Liger. Everybody want one. Eventually, a team of three students start an Exploration about drone and ask Liger to buy one. They involved in Drone for weeks and become an expert pilot. The pilots filmed about our school, NGOs like CamKids and our trip in Koh Seh Island and they become a filming company.

Liger also want other Liger student to become pilots. So, Liger bought a new drone without Camera in a cheap price because it is better to accidentally crush the trees instead of the crushing the trees with the Camera drone while we do the training.

We have an After School Extension that host by Liger expert pilot and get help by Jan. I was lucky to sign up for ASE first and it is a best chance to fly a drone.

Flying drone is not easy, it is harder than what people think. We have to be patient, go slow and importantly to know its direction. Otherwise, the drone could crash with something. My friend crashed the drone once because he doesn’t know its direction of the drone. The first time I learn how to fly, I almost crash the drone.

This video is when I fly the drone on the second time, where I have more control with the drone.

Marine Life Radio Broadcasting

In our Khmer class this year was interesting. Our Khmer teacher was a radio speaker that have many experience about it and he wanted Liger students to write and record a script. The theme of the broadcast is about Marine Life in Cambodia. We partner with a NGO call FFI to give information about marine life. The broadcast could be a story telling, conservation and more. We divided into group of three students and our group chose Dugong as our animal that we want to talk in the broadcasting. Our broadcast is like a story telling and conservation, where we act the Dugongs in the story.

Below is our broadcasting:

Lego Master After School Extension

I love Lego and I volunteered to host an After School Extension (ASE) called Lego Master for Junior Students. Six of Junior students join my ASE. I was really surprised that they like Lego and having fun. It remind me of when I was young playing Lego.

Pictures from Lego Master ASE that I host with Rithy and Lux.

Coding Exploration – Making an economic game

Coding Exploration has 16 students that passed the brain test. Before the Exploration, we have an expertise by Skype with Michael, learned to use git commands. After git, we moved to Javascript, practiced and learned it in Codecademy. The goal of the Exploration is to make an economic game using Javascript. We have four teams are UI team designs user interface, data team gets data from data sheets and write it in Javascript and gives it to game engine team, game engine team writes code how the game works and tutorial team designs tutorial pages. All teams are collaborating with each other to make the amazing game.

2015/2016 Yearly Reflection

Cambodia has a lot of problems, at the same time we will also have a lot of solutions for it. As a citizen of Cambodia, I really wants to make Cambodia to a better place. Changing Cambodia isn’t a easy, but we could take a baby steps to make a big change and try our best. For this year, I done and doing with some projects or Exploration that might or will changing Cambodia. Other than projects, I educated my family to change their habit, I taught others what I know, I practice good habit and I discussed with others what we could change Cambodia.

Bus Application

Big problems right now is traffic jam and traffic accidents. To reduce traffic jam, the City Hall of Phnom Penh launched city buses for serving passenger in the city. It started on September 2014 and a lot of people love this service because it only charged 1500 Riel per way. It is free for students. Some people didn’t ride on the bus. They use their vehicles like motors or cars because they have get to places quickly. We saw one problem from bus passenger. The passengers don’t know where is the bus right now and when it gonna arrive the station. They need to wait for the bus at the station. If there is traffic jam they might need to wait for a long of time. Some buses are quicker and some are slower, it depends on the traffic. It’s boring and waste their time. If they know where is the bus, they will longer get bored, they could be ready, hurry or wait at their house. Here is the good news, this problem is solving, my coding team are making a bus application, so it can helps passengers to know where is the nearest bus. Our application feature is we can use with any phone by just use text message. Not everyone has smartphone or Internet. If the passenger doesn’t have internet or smartphone they could send a text message to our application and the application will reply back the best bus for them. Our application base on the community. The bus drivers need to update bus location and status. We will add more feature, like GPS for calculate distance and easiest for drivers, voice command, multiple languages for passengers, Voicecall for those don’t know how to read our right. The application will help a lot of people in Cambodia. It will save their time, save their money, save the gas, reduce exhausted gas produced by cars and motors, reduce traffic jam and reduce traffic accident. This application would change Cambodia in a big section. Our application doesn’t charge any money from passengers, they just pay their money for their text message. We hope when we launch this application, more people would come to ride on the city bus and reduce traffic jam reduce traffic accident altogether.

Map Guide

I have worked with ISPP students to make a mobile application for tourism that come to Cambodia. The app called Map Guide. Map Guide can help tourism to have a better communication with Tuk Tuk driver. The tourism can choose the location where they want to go and our app will pronounce the location name, street name and other information about it. To that end, tourism feels much happier and more tourism would come to Cambodia.

 

Khmer Typing

Khmer typing is one of my coding project that I am working with Prakhar. He is my mentor from India. Most of Cambodian student not very good at typing in Khmer on the computer, they are very good at typing English because it is easy to type. For my observation, Liger students also not that good at typing in Khmer they have to practice more but they don’t have a tool to help them. I want Cambodian students know how type Khmer faster, so I am making a typing application that teach how to type in Khmer. Prakhar looks at Google and found a program called Klavaro. It is an open source typing application that has plenty of languages but no Khmer. Prakhar asked the Klavaro developer for translation sheet so that I can translate. I spend a lot of time translate the application. I hope in the future, Cambodian students know how to type Khmer very well.

Scratch

Scratch is where I learned the first code at the first year of Liger school. I have a lot of experience with it. I made plenty of projects, some are game and others are animations. I inspired a lot of people to use Scratch, but they didn’t enjoy with it. I taught some Liger students that interesting to learn Scratch, but it didn’t worked very well. Furthermore, I taught Assistant of Secretary of MoEYS. It was very great opportunity to teach him. Scratch is very great tool for students that wanted to learn how to code that why the Secretary of State of MoEYS wanted one of the Liger students to teach his assistant and that was me. Then his assistant could teach the Secretary of State of MoEYS when ever he has free time. It was very headache for him when he started learn about Scratch. Later on, he was okay. I was enjoying teaching him. I was glad to see he enjoyed with Scratch.

I taught Scratch to people face to face. I also wanted to created a course in Youtube so it easy for students to learn at their own time. It very honor for me to created this course. Nobody had asked me to do that. I just want to inspired Cambodian students about programming. That’s all.

Scratch has plenty of languages translated including Khmer, but the translation isn’t very professional and doesn’t understandable. That is one of my task to translate it. It could help students. English is also good when we started write real code like Python but English is not easy for the Khmer beginner.

Google Science Fair

Google Science Fair was a great opportunity, so I joined it with a friend. We had one idea then another one then another one at last we found our best one. Our first idea was to create a soapy water filter. People can use it to filter the soapy water to clean the water that they can use it again, but according to the researcher from Singapore. They said we need high technologies and special equipments to filter the water. It’s too expensive for Cambodia people to buy. So we have another idea is to create a bin that attached with a material detector sensor to know what type of trash? Is it metal? Plastic? Organic? And if it’s a right trash type to the bin, it will open the lip for us to throw trash. Well, this idea was good but we needed a expensive sensor and it still not very accurate. Cintri (collecting trash in Cambodia) wouldn’t buy our bins of it expensive. We stopped research about this idea and go for another idea. Another is to sorting trash by using the robot. It possible but we don’t have enough time to research and design it. Another idea is the final idea that my team have. We want to make a machine to fill plastic bag into water bottle. The product made by the machine are use as building materials. We can build houses, road, beach, etc. If we fill it hard enough, the bottle should be stronger than a brick 20 times. We got this idea from a workshop but they did it with hands and stick. Imagine how hard and how long it would be fill a plastic into a bottle. Why don’t we build a machine that work faster, easier and cheap. People can buy this machine and produce the water bottle brick at their home. We wanted to open a market for this product. So people will not want to throw plastic bags or water bottle anymore, they will keep it to make the bottle brick. We use it as building material, so it replace with brick, so no brick, no making bricks, no burning woods, no deforestation, no plastic in water system, no plastic bag anywhere no plastic bag in the landfill but there is plastic in the wall of the buildings.

Project based learning Exploration

Our school does Project based learning but government schools do not. The students learn by listen to the teachers and write in the books. The students never do a project or do a presentation before. This is one of the big problem for education in Cambodia. Dr. Hang Chuon Naron, Ministry of Education Youth and Sport school to see our presentation and wanted to do the same thing in Government school. So, he asked our school to make small projects that government students could do. My group’s job was to make a presentation about how to do a presentation and do a project that our teacher assigned to model for government teachers. I tried my best do the presentation to teachers

Trash Problems

­Liger done a lot of Explorations and projects about plastic. Trash is one of big issue in Cambodia. My Google Science Fair is also about recycle trash. Other than projects, I tried use less plastic bags. I practice at the school when we go to buy snacks. We use clothes bag instead of plastic bags. I also practice this at outside of school. Sometime, I didn’t bring cloth bag then I asked the seller to give only one plastic bag instead of two. I told my mom to reduce plastic bags. When I am home at my hometown, I separate trash into two bins. One is organic bin and another plastic bin. I told my brother when go to school he doesn’t need to pack breakfast, he could eat at home or eat at the restaurant. My mom usually burns plastic or throw into the river. I told her not to but she asked me so what should she do. I told her to keep in one place. She also burns the organic waste because it take space on the farm.

Khmer Role Model

We had a lot of opportunities and one of them is Hun Sen Khmer Role Model competition. The challenge required us to submit a project like a video, picture, music or document. I submit a video about electricity safety. I made this video using Scratch. To win this competition we have to have the most ten vote of all competitor. At that time, I didn’t have Facebook account, so I didn’t promote much to my family and my friends. I didn’t win the competition but I felt proud of myself to join this challenge. I tried my best to promote my project by email to Liger students, asked my house mom to post it in her Facebook. I asked my brother in-law post in his page. We got 1000 likes in Facebook but it was my mistake that I should told my brother to make a post and tell other people how to vote me. They confused to like in Facebook instead of like in Hunsen website where my project is. I felt so bad at that time. That was okay, I at least I got some experience.

In 2013-2014 I was in Leadership Exploration. In this exploration we think about problems in Cambodia and how change it. Our teachers decided to chose one problem is electricity safety and as the students we need make a video, posters, flyer to teach kids about how avoid of electrical shock. I and my another friend Theara made an animation in Scratch that take about three things:

“When there are storm you should turn of electrical things like TV”

“Avoid of electrical things from the water”

“When have electricity problem should call an expert, don’t fix it by youself”

I have been to Green Umbrella school and two school in Kep to teach them about electricity safety and it was really hard to teach kids about it because they did not know much about electricity. That is the reason I make the animation because kids like cartoons lots.

Robotics Exploration

Also in the year I was in Robotics Exploration. The purpose of the Exploration is to complete a lego robotics competition. In the competition was about solving the robot challenge and the Project. The Project was about Natural Disaster my team chose flooding as the our argument because in our country flooding happen annually and impact a lot of things. We chose one big problem is people in Cambodia drowned because of flooding. We found the solution that the government school should have a swimming pool but to make a traditional swimming pool is cost a lot of money. We was research about swimming pool and we found out that there are natural swimming pool that cost less money, don’t need to clean use the aquatic plants to filter the water and we won for 2nd place of Innovative solution. We didn’t make any change for Cambodia but we have the solution to change Cambodia.

Tech Support:

In this Exploration I have been to Singapore to learned about hardware in the computers and learned how to fixed them when they have troubles. When I returned to back to Cambodia we conducted with two NGOs are Tiny Toones and Green Umbrella and they have some issues about technological things, especially computers. So as the team we brought their broken computers to our school and fixed them for free and provided better Ubuntu Operating System (OS) to them because it is free and have a lot of education apps.

Community English:

Community English is an extension in 2014-2015. This extension is to teach the community kids to learn English and I was join in this extension and taught English to the kids. I was put a lot of effort to make them interesting, fun and they understand what it means.  

 

Teaching Scratch to Assistant of Secretary of State

It is a great opportunity to teach Scratch to the Assistant of the Secretary of State of Cambodia. I was shocked when I heard about that, but I didn’t feel nervous at all. I went to the Ministry of Education, Youth and Sport every Wednesday morning with a Liger teacher and taught Pollin (Assistant of the Secretary of State) about two and a half hours. The first day, I taught how to install Scratch Offline 2 and Adobe Air. It was a challenge to explain Scratch, how to use it and what is included in the program. I gave him homework every week to do a small project. After the first week, he understood faster. I tried to make a simple project that is fun, using the blocks that he had learned.

The purpose of this training is because Scratch is great for students to use and learn in Government Schools. The Secretary of State wants to learn Scratch too, but he’s too busy with work so he asked his Assistant to learn from me and his assistant can then teach him.

If Government Schools have Scratch lessons for students to learn, they can make educated animations, games, art. Kids love to play games and I think it is so fun to play their own game. Also, if you know how to use scratch well, it is easy to learn coding.

Scratch is a great tool, it has a lot of languages including Khmer, but the Khmer translation isn’t perfect. I wanted to translate it, but I didn’t have time.

The Secretary of State wants me to make an educated animation about traffic problems in Cambodia. He said, if I made it, he will include it on his TV campaign commercial.

Project-based learning Exploration

Our school does Project based learning and Liger students love it. Dr Hang Chounaron Ministry of Education, Youth and Sport came to our school and he’s very interesting what we are doing in Liger. He wants to try to do PBL at government schools. So, he asked Liger to help to make sample projects, to teach teachers how to do projects and to evaluate.

We have three Explorations that worked together for the mission are PBL, STEM and Evaluate. I was in PBL doing about Moral & Civic Education. Our role is to make a presentation how to do a presentation and do a project about the Moral & Civic Education. So when we go to Kratie school we presented to the teachers at public school how to do a presentation and the product we had done one the topic.

For our project, we have to interview six women and pick one of them to present. After we interviewed them we wanted to make a role play. It’s not easy to act out an angry man yelling at the girl like that, but I did my best to do that.

Here is the video of the role play:

This is presentation skill video:

Cookbook Exploration

Exploration Name: Liger Senior Book
Number of student: 9
Description:
The purpose of this Exploration is to make a recipe book or cook book for Liger students because next term (August 2016), the first generation students will move to new campus and we will cook breakfast and dinner by our self. To do that we divided into three teams, recipe crew, photographers and book designers. I was in the recipe crew. For my job, I research the recipe depend on the the our categories. Then I order the ingredient that I need to cook for next day. We have chief facilitator to help us cook and check our recipe while we cook. After we cook a food, we decorate and photograph it very well. Next we send the recipe and pictures to book designers.

We use Bookwrite to draft the recipe because this software we cannot print it at Cambodia and the PDF files quality is bad. So we decided to use Adobe Indesign.

Book cover: