{"id":8056,"date":"2023-01-25T19:16:53","date_gmt":"2023-01-25T17:16:53","guid":{"rendered":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=8056"},"modified":"2023-09-07T14:37:27","modified_gmt":"2023-09-07T12:37:27","slug":"l2-informatique-traitement-de-donnees","status":"publish","type":"page","link":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=8056","title":{"rendered":"L2 Informatique &#8211; Traitement de donn\u00e9es"},"content":{"rendered":"<p><script type=\"text\/javascript\" src=\".\/wp-content\/js\/decodemel.inc.js\"><\/script><br \/>\n<a href=\"https:\/\/icom.univ-lyon2.fr\/\"><img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2018\/09\/logoICOM64.png\" alt=\"Logo ICOM Lyon 2\" title=\"Site ICOM Lyon 2\" height=\"54\" \/><\/a><\/p>\n<p>Ann&eacute;e 2022-2023<\/p>\n<h3>Pr&eacute;requis<\/h3>\n<p>TIC de L1 et L2<\/p>\n<h3>Objectif des TD<\/h3>\n<p>Ma\u00eetriser les fonctions avanc\u00e9es d&rsquo;un tableur et sa programmation pour l&rsquo;analyse de donn\u00e9es et la simulation.<\/p>\n<h3>Th\u00e8mes des TD<\/h3>\n<ol>\n<li>Mise en forme, fonctions, liens, tri, filtres automatiques<\/li>\n<li>Filtres avanc\u00e9s, fonctions de base de donn\u00e9es<\/li>\n<li>Tableaux crois\u00e9s et graphiques dynamiques, fonctions de comptage conditionnel, fonctions logiques<\/li>\n<li><span class=\"important\">Contr\u00f4le n\u00b0 1<\/span> et suite du TD (fonctions logiques, mise en forme conditionnelle)<\/li>\n<li>Outils de simulation<\/li>\n<li>Fonctions de recherche, macros et programmation VBA<\/li>\n<li><span class=\"important\">Contr\u00f4le n\u00b0 2<\/span><\/li>\n<\/ol>\n<h3 id=\"planning\">Organisation p&eacute;dagogique \/ Planning<\/h3>\n<ul>\n<li><strong>Cours (3 s\u00e9ances &#8211; 6h) :<\/strong> <script type=\"text\/javascript\" src=\".\/wp-content\/js\/mail-nh.inc.js\"><\/script><\/li>\n<li><strong>TD001 (7 s\u00e9ances &#8211; 14h) :<\/strong> mardis du 31\/01 au 21\/03 (8h-10h), salle D411 (<a href=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=90\">J\u00e9r\u00f4me Darmont<\/a>)<\/li>\n<\/ul>\n<h3>Modalit&eacute;s d&rsquo;&eacute;valuation<\/h3>\n<p>Contr\u00f4le continu<\/p>\n<ul>\n<li>Rendus de TD \u00e0 chaque s\u00e9ance<\/li>\n<li>Contr\u00f4les aux s\u00e9ances de TD n\u00b0 4 et 7<\/li>\n<\/ul>\n<h3>Mat&eacute;riel en ligne<\/h3>\n<ul>\n<li>Moodle CM (<script type=\"text\/javascript\" src=\".\/wp-content\/js\/mail-nh.inc.js\"><\/script>)<\/li>\n<li>Moodle TD001  (<a href=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=90\">J\u00e9r\u00f4me Darmont<\/a>)<\/li>\n<\/ul>\n<h3>Bibliographie<\/h3>\n<p><a href=\"https:\/\/catalogue.univ-lyon2.fr\/cgi-bin\/koha\/opac-search.pl?q=excel\">Ouvrages disponibles \u00e0 la BU<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ann&eacute;e 2022-2023 Pr&eacute;requis TIC de L1 et L2 Objectif des TD Ma\u00eetriser les fonctions avanc\u00e9es d&rsquo;un tableur et sa programmation pour l&rsquo;analyse de donn\u00e9es et la simulation. Th\u00e8mes des TD Mise en forme, fonctions, liens, tri, filtres automatiques Filtres avanc\u00e9s, fonctions de base de donn\u00e9es Tableaux crois\u00e9s et graphiques dynamiques, fonctions de comptage conditionnel, fonctions\u2026 <span class=\"read-more\"><a href=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=8056\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":300,"menu_order":2030,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-8056","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/8056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8056"}],"version-history":[{"count":18,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/8056\/revisions"}],"predecessor-version":[{"id":8350,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/8056\/revisions\/8350"}],"up":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/300"}],"wp:attachment":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}