diff options
Diffstat (limited to '')
-rw-r--r-- | 2023/info/table-after.md | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/2023/info/table-after.md b/2023/info/table-after.md index ec3e87dd..3224d011 100644 --- a/2023/info/table-after.md +++ b/2023/info/table-after.md @@ -4,6 +4,9 @@ <a name="table-mainVideo-transcript"></a> # Transcript + +Introduction + [[!template text="""Welcome everybody. My name is Daniel Molina""" start="00:00:01.360" video="mainVideo-table" id="subtitle"]] [[!template text="""and I'm going to give this talk""" start="00:00:03.080" video="mainVideo-table" id="subtitle"]] [[!template text=""""Who needs Excel? Managing your students' qualifications""" start="00:00:05.061" video="mainVideo-table" id="subtitle"]] @@ -40,6 +43,9 @@ [[!template text="""and to help other teachers.""" start="00:01:35.000" video="mainVideo-table" id="subtitle"]] [[!template text="""Anyway, it could be used not only for teaching""" start="00:01:36.640" video="mainVideo-table" id="subtitle"]] [[!template text="""but for more contexts.""" start="00:01:39.960" video="mainVideo-table" id="subtitle"]] + +Demonstration + [[!template text="""Well, let's start.""" start="00:01:41.960" video="mainVideo-table" id="subtitle"]] [[!template text="""First, I have two sections,""" start="00:01:44.800" video="mainVideo-table" id="subtitle"]] [[!template text="""the comments and the section of the table, or results.""" start="00:01:46.460" video="mainVideo-table" id="subtitle"]] @@ -60,6 +66,9 @@ [[!template text="""Okay, that's one point, this a three,""" start="00:02:50.720" video="mainVideo-table" id="subtitle"]] [[!template text="""and use a column total with something like that.""" start="00:02:55.680" video="mainVideo-table" id="subtitle"]] [[!template text="""Okay, that's nice.""" start="00:03:06.680" video="mainVideo-table" id="subtitle"]] + +Range + [[!template text="""But then, when I started getting more and more parts,""" start="00:03:08.320" video="mainVideo-table" id="subtitle"]] [[!template text="""I considered it more useful to use,""" start="00:03:11.640" video="mainVideo-table" id="subtitle"]] [[!template text="""to put for each part,""" start="00:03:17.082" video="mainVideo-table" id="subtitle"]] @@ -76,6 +85,9 @@ [[!template text="""I only have to put,""" start="00:03:54.440" video="mainVideo-table" id="subtitle"]] [[!template text="""multiply the values of the second line with that.""" start="00:03:56.480" video="mainVideo-table" id="subtitle"]] [[!template text="""So, it's very useful for doing that.""" start="00:04:08.300" video="mainVideo-table" id="subtitle"]] + +More qualifications + [[!template text="""Okay, that's the first part, so I can put the comment,""" start="00:04:11.900" video="mainVideo-table" id="subtitle"]] [[!template text="""I can go to the section, I can create...""" start="00:04:16.640" video="mainVideo-table" id="subtitle"]] [[!template text="""I'm going to put more qualifications.""" start="00:04:19.960" video="mainVideo-table" id="subtitle"]] @@ -96,6 +108,9 @@ [[!template text="""but in the lesson table using that format.""" start="00:05:21.801" video="mainVideo-table" id="subtitle"]] [[!template text="""Okay?""" start="00:05:29.560" video="mainVideo-table" id="subtitle"]] [[!template text="""That is a good option.""" start="00:05:32.100" video="mainVideo-table" id="subtitle"]] + +Subsets + [[!template text="""Now we are going to see how can we use that""" start="00:05:34.240" video="mainVideo-table" id="subtitle"]] [[!template text="""to make a subset of the students.""" start="00:05:38.500" video="mainVideo-table" id="subtitle"]] [[!template text="""For instance, imagine, this is me,""" start="00:05:44.360" video="mainVideo-table" id="subtitle"]] @@ -111,6 +126,9 @@ [[!template text="""that has failed the exam,""" start="00:06:47.260" video="mainVideo-table" id="subtitle"]] [[!template text="""I could use that to make another table,""" start="00:06:48.840" video="mainVideo-table" id="subtitle"]] [[!template text="""this is the people that passed the exam.""" start="00:06:54.080" video="mainVideo-table" id="subtitle"]] + +Sorting + [[!template text="""Another interesting feature is that""" start="00:07:08.300" video="mainVideo-table" id="subtitle"]] [[!template text="""I can... the lesson table can be sorted automatically.""" start="00:07:10.981" video="mainVideo-table" id="subtitle"]] [[!template text="""It's simple. You only have to put this symbol (`^`),""" start="00:07:15.621" video="mainVideo-table" id="subtitle"]] @@ -124,6 +142,9 @@ [[!template text="""or here from the best score to the lesser score.""" start="00:07:43.960" video="mainVideo-table" id="subtitle"]] [[!template text="""And this sort is completely independent""" start="00:07:46.640" video="mainVideo-table" id="subtitle"]] [[!template text="""to the sort of the original table.""" start="00:07:48.961" video="mainVideo-table" id="subtitle"]] + +New table + [[!template text="""Now I'm going to do another different thing,""" start="00:07:51.641" video="mainVideo-table" id="subtitle"]] [[!template text="""we are going to put a new table,""" start="00:07:54.521" video="mainVideo-table" id="subtitle"]] [[!template text="""I'm going to put a new table""" start="00:08:02.800" video="mainVideo-table" id="subtitle"]] @@ -153,6 +174,9 @@ [[!template text="""with the students that passed,""" start="00:09:55.740" video="mainVideo-table" id="subtitle"]] [[!template text="""the students that failed""" start="00:09:57.520" video="mainVideo-table" id="subtitle"]] [[!template text="""and the ratio of people that passed.""" start="00:09:58.560" video="mainVideo-table" id="subtitle"]] + +Statistics + [[!template text="""Sometimes this type of qualification will be useful for me,""" start="00:10:01.280" video="mainVideo-table" id="subtitle"]] [[!template text="""to see how much has been the sound,""" start="00:10:04.820" video="mainVideo-table" id="subtitle"]] [[!template text="""how much good has been the exercise.""" start="00:10:08.080" video="mainVideo-table" id="subtitle"]] @@ -173,6 +197,9 @@ [[!template text="""sorry, there was an error about that,""" start="00:12:05.920" video="mainVideo-table" id="subtitle"]] [[!template text="""and two decimal,""" start="00:12:08.960" video="mainVideo-table" id="subtitle"]] [[!template text="""and that is another interesting score.""" start="00:12:12.640" video="mainVideo-table" id="subtitle"]] + +Combining + [[!template text="""Now, I'm going to finish showing how we can use.""" start="00:12:17.800" video="mainVideo-table" id="subtitle"]] [[!template text="""To finish it, we are going to see""" start="00:12:23.240" video="mainVideo-table" id="subtitle"]] [[!template text="""how we can combine several tables""" start="00:12:25.840" video="mainVideo-table" id="subtitle"]] |