Can a B Com student learn SQL

sofatutor magazine Teacher

An app, a website or a game: Show your students how to not only use these things, but how to program them yourself.

What do you have to be able to do for that?

To do this, you have to master one of the common programming languages ​​such as C ++, Java or Python. In order to introduce pupils in a playful way, a little more creativity is often required, because not every person wants to learn programming voluntarily right away.

Why is learning to code important?

There are two aspects to consider, the educational policy and the personal aspect. In terms of educational policy, Germany has a lot of catching up to do when it comes to developing the media skills of schoolchildren. In March 2015, a joint application was submitted by the CDU / CSU and the SPD: “Promote media skills by strengthening digital education and overcome digital divisions”. As a result of a technical discussion, education experts determined that not only schoolchildren have to learn how to use PCs and the Internet safely, but also their teachers. The ICILS study also attested that German eighth graders only had mediocre computer and information-related skills in an international comparison. Many teachers also know why the students only shone in the midfield.

Free access for teachers

Of course, it is also about the personal development of the students: They should be given the opportunity to use digital educational materials and programs and to learn how to use them. In addition to fixed education plans in the federal states, this also requires the correct motivation of the learners.

How can you get children interested in programming?

We took advice from a teacher who, among other things, publishes digital teaching materials under a Creative Commons license. The German and religion teacher and media studies blogger Tobias Hübner knows his way around the world of digital education. He has been committed to the “digital literacy” of schoolchildren for years and has already received many awards for this, such as the Dieter Baacke Prize 2014. Hübner recommends, “I have had very good experiences with integrating programming into lessons in a playful way. That goes z. B. very good with the programming language 'Scratch'. In a teaching project on narration in various media, for example, pupils should convert the first page of their favorite book into a computer game. First they painted a picture and then they used Scratch to try to create simple animations. Some students were really enthusiastic about it and then continued programming at home and tried out the other functions of the programming language. If you can convey this 'aha experience', a lot has already been achieved. ”You can therefore also integrate the programming tools and programming beyond the computer science lessons into the everyday learning of the students and work across disciplines.

But isn't it enough if the students can use WhatsApp?

German teacher Tobias Hübner sees it differently. He says: “It depends on whether you want to raise children to be consumers or producers. To consume, knowledge of the operation is completely sufficient. However, if you want children to be able to design their media environment themselves, a little more effort is required. I think no student should graduate from high school without a basic understanding of how a computer and the internet work. Not everyone has to become a programmer, but everyone should know that there are programmers and many lines of code behind software. And that works best when you've written at least a small program yourself. There is good reason why we teach children not only to read, but also to write. "

Examples of programming tools in the classroom

We see it the same way, so we have put together a few free entry-level programs with which children can learn to program in a playful way.

  • Scratch: This application is probably the best known. Here you can program videos, games and pictures with standardized programming blocks. These are sorted according to the action pattern. The exercises are in German, but the example results and the community function only work in English.
  • Blockly Games: Blockly uses the same principle as Scratch or Turtle Art, except that learning success is achieved through different games: the learner has to move a figure along a Google Map or shoot an opposing figure in a pond.
  • Open Roberta Lab: With the beta version of the Fraunhofer Institute's Open Roberta Lab, EV3 robots can be programmed in the cloud. It supports the first programming steps up to the programming of intelligent robots with sensors and capabilities. The site is in German, programming is done in the Fraunhofer Institute NEPO's own programming language. As with Scratch, you work with a graphical programming environment and arrange the commands using drag and drop.
  • Greenfoot: Here you get to know the Java programming language in an object-oriented manner. Greenfoot creates customizable environments called micro-worlds. Gender, age or other factors can be individualized. In addition to the free software, the Java Development Kit must also be installed.
  • Alice: As with Greenfoot, Alice is based on an object-oriented programming language. You create computer animations from 3D models using drag and drop. With a little practice, these can be expanded into complex programs. Alice is not related to any particular development environment, so there is no need to familiarize yourself with any particular syntax.
  • is the third example in this line of visual programming. It is partially translated into German and has well-known, animated little helpers, such as the Angry Birds or the princesses from "Frozen".

other tools that kids can use to learn to code

There are other tools below that make programming entertaining and instructive:

  • Tynker: Tynker is course based. Children can learn to program in a playful way at different levels of difficulty. They can build computers and learn to draw or create games and videos themselves. Tynker also works on tablets, but is currently only available in English.
  • Code Monkey: The online game CodeMonkey teaches programming in a playful way, as children try to collect as many bananas as possible with a monkey. The game is in English. There is a free demo version.
  • CoderDojo: A CoderDojo is a free programming club for children and teenagers from 5 to 17 years of age. The meetings of specialists and children and young people interested in programming take place all over the world. We have already organized a CoderDojo. If a child enjoys programming, they can also register with Jugend hackt and take part in hackathons.
  • MIT AppInventor: MIT has set out to develop a tool for programming apps. The cloud-based web program App Inventor works without any further installation. Children can then test their own app on their own mobile phone. However, the App Inventor only works in English.
  • Light Bot 2.0(by Armor Games): The little Light Bot is a robot that can light up blue tiles. That is the aim of this game. The instructions are in English, but a lot of the work is done with simple symbols so that children without knowledge of English can find their way around quickly.
  • Code Combat: In the online game Code Combat, children move the hero using codes and can solve exciting tasks in the process. The game has a comic design and is in German.

Further information on programming tools is also available on the Informatik-Tools website. One site where you can learn Java, SQL or Pascal without installing any additional software is the Programming Wiki.

Have you already used programming tools in class to familiarize your students with programming? What are your experiences?

Cover picture: Pressmaster / shutterstock

More related articles

sofatutor for the whole school: this is how it works with financing

Equal opportunities for everyone: if the entire school learns with sofatutor, it has many advantages. But how can licenses for all students be financed? Here four schools report on their solutions. School licenses from sofatutor ideally give all students in a school access to the more than 10,000 learning videos, the more than 44,000 [...]

Free Workshop: Strengthening Teachers' Health

Teachers in Germany have been working in a state of emergency for more than a year. Homeschooling, changing classes, wearing a mask and keeping your distance - all of this is very stressful. The Federal Association for Digital Education is therefore offering a webinar on the subject of resilience. Resilience can be learned Corona has turned the school system on its head and shaken it up vigorously. That applies [...]

Simon Hermsdorf: "This is the next level"

As a technology teacher at the Fintauschule secondary school, Simon Hermsdorf is enthusiastic about applications that enable his students to experience theoretical concepts. After the first test runs, he was enthusiastic about LEGO® Education SPIKE Prime. Mr. Hermsdorf, three of your students recently unboxed a LEGO® Education SPIKE ™ Prime set in a professional unboxing video. How many sets are there [...]

"The teacher ends the video chat - no one else!"

We will soon be living for a year with the changes that the corona pandemic brought with it. Woman with class reports (again) from the home office and also takes on the supposed experts who always know everything better. Regular operation as if nothing happened What happened in the schools after the first lockdown in March 2020? It [...]

33 teachers give tips for hybrid teaching

Digital media gained a huge boost in importance during the early phase of the corona pandemic. But how can teachers and students now deal productively and sustainably with the knowledge gained? Teacher Tim Kantereit collected ideas and suggestions. The problem: School is changing too slowly Many institutions - schools, teachers, the [...]

Bradley Davies: “My favorite class? - Every hour in which I am allowed to do something new! "

As a primary school teacher at the bilingual Kämmer International School, Bradley Davies uses LEGO® Education to make his pupils' eyes shine. You learn programming early on and can use it realistically with WeDo2.0. Note: The interview was conducted in English and then translated into German. Mr. Davies, can you [...]

8 indoor games for breaks - with exercise, fun and distance

Rain, frost and social distancing due to Corona can mean that students have to spend their break in the classroom. So that the children don't just sit bored in the corner, we have put together entertaining games for you - for every grade level. Why playing together is so important in times of Corona Break games and [...]

Protection against corona? - Nope, but here is a ventilation concept!

The warm summer days are over and, as expected, autumn brings unsightly twists and turns. The number of new infections is increasing, many people are going back to the home office, but regular operations continue at school. A woman with class finds some honest words for this situation. Back to school fun with a mask Yesterday the autumn holidays ended and for [...]

STEM funding: "Using the practical to teach the theory"

Tanja Zellner loves trying things out and discovering. She works in the MINT promotion in Lower Bavaria and uses LEGO® Education to bring children closer to their fascination and to strengthen their interest in technical careers. Tanja Zellner is part of the “MINT Funding” team at TH Deggendorf. There she offers workshops for teachers and extracurricular programs that help children and young people [...]