1
00:00:00,500 --> 00:00:08,939
Okay, so I'm going to explain in this video how to use LibreOffice Calc to make a graph

2
00:00:08,939 --> 00:00:15,880
using this data that I have found or I have recorded doing this experiment on the refraction

3
00:00:15,880 --> 00:00:16,879
of light.

4
00:00:16,879 --> 00:00:20,699
So firstly, I need to select all of the data.

5
00:00:20,699 --> 00:00:27,920
Then I'm going to click on this icon, these little bars over here, and then I will choose

6
00:00:27,920 --> 00:00:29,500
the type of graph that I want.

7
00:00:29,500 --> 00:00:36,399
it will be XY dispersion where I'm going to select touch and lines. I could end

8
00:00:36,399 --> 00:00:42,000
here to finish here but I'm going to make it a little nicer so I don't need

9
00:00:42,000 --> 00:00:52,250
to touch this or this either so I'm going to add a title to my graph

10
00:00:52,250 --> 00:01:10,099
a fraction of light and I can also add light bulbs to the axis. There is a mistake here.

11
00:01:10,099 --> 00:01:25,469
I end here and here I have my graph, the experimental data and the lines, the line

12
00:01:25,469 --> 00:01:34,590
that represents the function that connects them. I hope this helps understanding what

13
00:01:34,590 --> 00:01:44,349
what you need to do to do the activity about making a graph using a spreadsheet.