SPREADSHEET SOFTWARE

Important words:  data, formula, function, graph.

FIRST SESSION :  Open Excel and draw your name in the cells. When you finish, send the file to your POU 's computer subject. 

SECOND SESSION : Make an excel file where it is calculated the average mark of four people and five subjects. Use formulas and the "mitjana" function. 

After this, create a graph with the average of the four students. 

Notice that if you change a mark, everything will get recalculated!!

Upload the file to the platform.

THIRD SESSION :  Make a shopping invoice with excel or calc. For example, you can do a greengrocers' invoice. The total amount depends on the number of kg and the taxes (IVA - VAT).

FOURTH SESSION: Make an excel file which calculates the area of the following objects: square, rectangle, circle. Use the "pi" function.

                 

FIFTH SESSION: Make an excel file which calculates your average mark of five computer exercises. Use a function (promedio, mitjana,... depending on the program you use) in order to calculate it. After this, create a bar and a circle graph with this information.

Remember to improve the file appearance to get a better mark.

SIXTH SESSION: Make an excel file with a graph like the following one.

                       

SEVENTH SESSION: Find out which Spanish soccer team is the 5th best and the number of points. With this information, make an excel graph. Include a title and the two axis titles as well. After this, copy this graph to a word file. Send to the platform ("POU") only the word file.

                                                   

EIGHTH SESSION:  Has E3 a good formula to copy to the other cells?

Improve the formula. Calculate the leftover cells. Improve the appearance.

NINTH SESSION: Make an excel file where it's calculated the average of four subjects. If the mark is less than 5 it must be in red colour (conditional format). By the mark, it must be seen if the subject is approved or failed ( SI function).

                   =SI(E8>4,99;"approved";"failed")

TENTH SESSION: Write five students and their math mark. By the mark, calculate with the SI function its qualification (exc, not, be, sf, in). After this, create a full bar graph with the data.

=SI(J18<5;"IN";SI(J18<6;"SF";SI(J18<7;"BÉ";SI(J18<9;"NT";"EX"))))

ELEVENTH SESSION: Create a sheet that controls all the delays and absences of five pupils during a two weeks period. Use the "compta.si" funcion. After this, create a bar graph with the data (two series).

                     =COMPTA.SI(D8:N8;"a")

TWELFTH SESSION: Write 30 random numbers from 1 to 9. Calculate their absolute frequencies. After this, calculate with functions other statistical measures. To finish, create a bar graph to represent numbers (1-9) and their frequencies.

                     =COMPTA.SI($D$5:$H$10;"1")