Merry Christmas and a Happy New Year

Dear Students,

Your fantastic and great ICT teacher desires you a Merry Christmas and a  Happy New Year.

May the Magi bring you health and the wants to study hard to become wise people so that you can improve the World.

See you next year!

6th practice. AUDACITY: Tell me your story

Hi dear students,

In this practice we are going to use the free software Audacity to edit audio files. You will find the program on your desktop.

First, I recommend you to visualize the videos included below so that you can start using this program.

For more information you can also consult the tutorials you will find in the next links.

Audacity Basics

Audacity Tutorial

So your work will consist on recording a traditional tale and then adding it music and sound effects. Its length has to be of at least 5 minutes and it has to include ten sound effects. So,please, surprise me!!!

Here you have some websites where you can find free sound effects.

Recursos TIC Educación

Creative Sound

Fxmania (in French)

You can use the Sound Recorder provided with Windows to record your voice telling the tale, but I think it's better for you to use the recorder included with Audacity to record your voice while telling the tale. You will also need a microphone, so ask me when needed.

When you finish your practice, be so kind to upload your file in Google Drive and share it with me. During the class you will also have to show me your Audacity project from time to time so that I can assess your work.

As always, if you have any problem editing your soundtrack, please ask me.


Important advertisement:

I am negotiating with the Entrepreneurship teacher, so that her students sell a CD of our best tales. A percentage of their income will be for us if they finally agree my proposal.

So, please, be careful about the pronunciation and try to do your best not only for the mark but also for the economic benefit you can obtain.

5th practice. Excel: Sort&Filter, Find&Replace, mail merge.

Dear students,

I am glad to inform you that we are going to start our next practice.

So, please, be so kind to open the internet explorer and search in Google “Colegios públicos Excel”. Download the first file with an xls extension you find.

Next, open the file and save it with the name “TIC1/2a/b/c/…”.

After that, fulfill the following tasks:

1) Sort the data by these three criteria.

POST CODE	Smallest to largest
ACRONYM	A-Z
DENOMINATION	A-Z

 
2) Find “LA GOMERA” and replace with “LA GOMERA” shadowed in green color.

 
3) Create a dynamic table as shown in the image below.

4) Finally make a merge mail by using Word and Excel programs. I have included you a link to a Youtube video where you can learn easily how to do it.

 
To summarize, you have to follow the steps listed below:


a) Open the Word program and go to “Mailings”.

b) Click over “Start a merge mail”

c) Select a recipient and after that “Use an existing list” (use the Directorio sheet of your Excel document).

d) While writing your mail, when you need to insert a field, you have to click over “Insert merge fields”.

e) Once you have finish “Preview results”.

f) Finally click in “Finish and merge” and print the document using PDF Creator. 
 

In the next image you can see the text you have to write and the fields needed to complete your work satisfactorily.

When you have finished the practice, please, upload in Google Drive your pdf and xls files and share them with me.

So good luck and take it easy!!!

4 th practice: Excel Functions I

Digital company wants to make a statistic study of its sales force in Spain. The company has the information contained in the following table:

They also have a commissions table used to calculate commissions and bonus. The bands are the following ones:

 
So you will have to complete the tasks listed below:

1) Insert a title in red and Arial 12 letters. The title has to be the name of the company.

2) Improve the spreadsheet:

-  The letters of the column’s titles should be 12 green Comic sans.

-  Apply borders to the cells or even colors.

-  Apply currency format with two decimals to the sales column.

3) Calculate the commissions the sellers are going to obtain considering the bands established by the company.

4) Calculate the bonus the sellers are going to receive taking into account the bands of the table.

5) Obtain the total net sales of the company.

6) Calculate the salary of each employee.

The commissions and the bonus of each employee are difficult to calculate. So I recommend you to watch the video included for a clue and, if after all you don’t find the solution, ask me. I will be glad to help you. You will also need to use the tutorials included in the last practice.

clue commissions and bonus 

So cheer up and don’t faint!