Open Office Database

We learned how to link tables and with the tables we linked we made queries, forms and reports. In this case the different tables that I've linked are called 'NameAddrPhone' and 'Marks' and I've took information from both tables and made a query, a form and a report.

NameAddrPhone

Marks

Query

Form

Report

Open Office Impress: Presentation

This time we were working with Open Office Impress (which is like power point) and we made a presentation about a subject we chose ourselves. I chose to make the presentation about tigers. Too bad my gif in the right lower corner of the presentation doesn't work.

Tiger

View more presentations from AnnikaHerrala.

GIMP: Making gifs

We also learned to make gifs. We had to create a 'logo' to ourselves which would be in GIF form. I made two gifs.

GIMP: Logo

We chose a logo and then we made it on GIMP. Here's the original logo:

And here's my version of it:

GIMP: Putting our face to a celebrity's body.

Here we had to choose a picture of us and with help of GIMP put it to a celebrity's body.

I chose Lindsay Lohan's body (from the movie 'Mean Girls').

GIMP: First exercise.

As our first GIMP exercise we had to take a picture of everyone in our class, and put everyone in only one picture.

Open Office CALC: Exercise.

In this exercise we had to work with numbers on Open Office CALC.

Open Office Writer: TV & Broadcasting

What is broadcasting?

Broadcasting is the distribution of audio and video. In, for example, radio and TV broadcasting means sending information to a large audience. The information, which can be everything from TV shows to music on the radio, is sent in radio waves, through a wire or by satellite. Television sets and modules are there for picking up the signals that's been sent through the air and they make the signals comprehensible for us.

Different types of electronical broadcasting

• The telephone broadcasting was the first type of electronical broadcasting. It was invented in 1881. The first telephone broadcasts were used to listen live opera and theatre performances over the telephone lines. The creator of this is Clément Ader.
• Radio broadcasting was first invented in 1906, but it became popular in 1920. Radio broadcasting distributes audio. The signals are sent from a transmitter through the air as radio waves to an radio antenna and from the antenna to a receiver, a radio. Guglielmo Marconi, an Italian inventor, was the one who invented wireless telegraphy (based on air signal) and in December 1901 he was the first one to send radio signals across the Atlantic Ocean.
• Television broadcasting, or telecast, is from 1925. The commercial television is from 1930 though.
• Cable radio (from 1928) and cable television (from 1932) are transmission mediums from programs that are produced at either radio or television stations.
• Direct-broadcast satellite (from around 1974) is a term used for satellite television broadcasts intended for home reception.
• Webcasting of video (from 1993) and audio (from 1994) offers a mix of traditional radio and television station broadcast programming with dedicated internet radio-webcast programming.

Television (TV)

Electromechanical television

The television was initially explored using electromechanical methods to scan, transmit and reproduce an image. Willoughby Smith discovered the photo conductivity of the element selenium in 1873, Paul Gottlieb Nipkow invented the scanning disc in 1884, and John Logie Baird demonstrated of televised moving images in 1926.

Baird was the first one to give a demonstration of a working television system to members of the Royal Institute and a newspaper reporter. This happened in 1926. Only two years later he sent a television signal all the way from London to New York.

Electronic television

The electronic television was demonstrated by Philo Tayler Fansworth in 1927 and the first regular TV transmissions were on 11^th of May in 1928, New York. The same year the first transatlantic transmission was sent with Baird's mechanical methods.
In 1936 one of the bigger transmissions was the Olympic Games in Berlin and after the World War II the TV increased a lot.

Color television

Baird demonstrated the first color transmission on July 3, 1928. Ten years later, on February 4, he made the world's first color broadcast. CBS, Columbia Broadcasting System, started making daily color field tests on June 1, 1941 but since these color systems didn't work with the existing black-and-white television sets and no color television sets were available the viewing of the field tests was restricted to RCA and CBS engineers and some invited press.
NTSC, National Television System Committee, worked in 1950 to 1953 with a color system that would be compatible with the black-and-white television sets. The first NTSC color broadcasts to air was a performance of the opera Carmen on October 31, 1953.

Open Office Writer: 1st exam

In this exam we got a plain text and a few pictures and icons taken from a wikipedia page and we had to make the text look like the wikipedia page where it was taken from.

This is the wikipedia page:

And this is my version of it:

Open Office Writer: Tutorial for a class timetable.

Class timetable

Tutorial for a class timetable 1

Step 1. 1

Opening a new text document. 1

Step 2. 1

Changing the page from Portrait to Landscape. 1

Step 3. 1

Making the table. 1

Step 4. 2

Making the basic layout. 2

Changing the size of the letters and making them bold. 2

Step 5. 2

Writing the lessons. 2

Step 6. 2

Saving the file. 2

Step 1.

Opening a new text document.

Click File > New > Text Document

Step 2.

Changing the page from Portrait to Landscape.

In the menu bar click on Format > Page.

Click on the Page section and go to Orientation. You see two choices: Portrait and Landscape. Uncheck Portrait by clicking on the little circle you see in front of Landscape.

Click OK.

Step 3.

Making the table.

Click Table > Insert > Table

A new window pops up. Change the number 2 in Columns to number 6 (that's going to be the time and the days for your timetable) by selecting the number and pressing 6 on your keyboard.

Do the same in Rows but instead of changing the number to 6, change it to 10.

Click OK.

Step 4.

Making the basic layout.

Now a timetable has appeared in your text document. In the first column (the one to the left) you will write the time for your lessons but leave the first row blank.

In the first row you will type the days from Monday to Friday.

Changing the size of the letters and making them bold.

Select everything from Monday to Friday by dragging the mouse from the beginning of Monday to the end of Friday and then click on B in the icon bar. The words become bold.

Also change the size of the letters to 14 by selecting Monday to Friday and clicking on Font Size in the icon bar and then clicking on 14. The letters become bigger.

Step 5.

Writing the lessons.

Beneath the section where you have typed Monday you will type your first lesson, which is English. Type English. Now type your second lesson on Monday and so on. Next to 10.45-11.05 type a B. On Tuesday in the same row type R. On Wednesday in the same row type E. On Tuesday type A and on Friday type K. Now you can see that you have BREAK from 10.45am to 11.05am.

Do the same after 12.55-13.10 and then continue typing your lessons on the timetable.

Step 6.

Saving the file.

Click File > Save As..

Type Class timetable in the section ”Save As”.

Click Save.

Open Office Writer: Templates.

Hey, so I'm going to post all my works from our TIC classes on this blog! :)