{"id":1949,"date":"2016-09-24T20:38:29","date_gmt":"2016-09-24T19:38:29","guid":{"rendered":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/?p=1949"},"modified":"2018-02-17T02:05:33","modified_gmt":"2018-02-17T01:05:33","slug":"difference-de-deux-des","status":"publish","type":"post","link":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/difference-de-deux-des\/","title":{"rendered":"Diff\u00e9rence de deux d\u00e9s"},"content":{"rendered":"<h2>Contenu :<\/h2>\n<p>On lance simultan\u00e9ment deux d\u00e9s et on s&#8217;int\u00e9resse \u00e0 la diff\u00e9rence des deux faces obtenues (le plus grand r\u00e9sultat moins le plus petit).<\/p>\n<h2>Pr\u00e9requis<\/h2>\n<ul>\n<li>\u00a0Utilisation basique d&#8217;un tableur (recopie de formules)<\/li>\n<li>\u00a0Notion de fr\u00e9quence .<\/li>\n<\/ul>\n<h2>Objectifs<\/h2>\n<ul>\n<li>\u00a0Introduire les outils du tableur permettant de r\u00e9aliser des simulations (fonctions ALEA.ENTRE.BORNES et NB.SI)<\/li>\n<li>\u00a0R\u00e9aliser une simulation \u00e0 l\u2019aide d\u2019un tableur pour explorer une situation de non-\u00e9quiprobabilit\u00e9.<\/li>\n<li>\u00a0D\u00e9terminer des probabilit\u00e9s \u00e0 l\u2019aide d\u2019un arbre ou d\u2019un tableau<\/li>\n<\/ul>\n<h2>D\u00e9roulement de la s\u00e9quence<\/h2>\n<p>TP en salle informatique avec \u00e9ventuellement d\u00e9monstration cherch\u00e9e \u00e0 la maison .<\/p>\n<h2>Fiche \u00e9l\u00e8ve<\/h2>\n<p>On lance simultan\u00e9ment deux d\u00e9s et on s&#8217;int\u00e9resse \u00e0 la diff\u00e9rence des deux faces obtenues (le plus grand r\u00e9sultat moins le plus petit).<\/p>\n<p>On va simuler cette exp\u00e9rience \u00e0 l&#8217;aide d&#8217;un tableur.<\/p>\n<p><strong>Pour 100 lancers<\/strong><\/p>\n<p>1)\u00a0\u00a0\u00a0\u00a0 Compl\u00e9ter la colonne A \u00e0 l&#8217;aide d&#8217;une formule et par recopie.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1950 aligncenter\" src=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-1.jpg\" alt=\"difference-de-deux-des-1\" width=\"176\" height=\"150\" \/><br \/>\n2)\u00a0\u00a0\u00a0\u00a0 On a rentr\u00e9 en cellule B2 la formule\u00a0: ALEA.ENTRE.BORNES(1;6)<br \/>\nTaper sur Ctrl + Maj + F9. Que remarquez-vous dans la cellule B2\u00a0?<br \/>\nQuel est le r\u00f4le de la fonction ALEA.ENTRE.BORNES(1;6)\u00a0?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1951 aligncenter\" src=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-2-300x83.jpg\" alt=\"difference-de-deux-des-2\" width=\"300\" height=\"83\" srcset=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-2-300x83.jpg 300w, https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-2.jpg 553w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>3)\u00a0Recopier la cellule B2 de B3 \u00e0 B101.<\/p>\n<p>4)\u00a0Compl\u00e9ter de mani\u00e8re similaire la colonne C.<\/p>\n<p>5)\u00a0 A l&#8217;aide des fonctions MIN et MAX du tableur, faire calculer dans la colonne D les diff\u00e9rences pour chaque lancer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1952 aligncenter\" src=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-3-300x115.jpg\" alt=\"difference-de-deux-des-3\" width=\"300\" height=\"115\" srcset=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-3-300x115.jpg 300w, https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-3.jpg 492w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>6) \u00a0\u00a0\u00a0\u00a0a\/ Entrer en colonne F les r\u00e9sultats possibles de la diff\u00e9rence<br \/>\nb\/ Compl\u00e9ter la colonne G \u00e0 l&#8217;aide de la fonction NB.SI\u00a0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1953 aligncenter\" src=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-4-300x48.jpg\" alt=\"difference-de-deux-des-4\" width=\"300\" height=\"48\" srcset=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-4-300x48.jpg 300w, https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/Diff\u00e9rence-de-deux-d\u00e9s-4.jpg 593w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>7) \u00a0Faire une nouvelle simulation de l&#8217;exp\u00e9rience en utilisant Ctrl + Maj + F9.<br \/>\nQuelle diff\u00e9rence appara\u00eet le plus souvent\u00a0?<\/p>\n<p>8)\u00a0Calculer en colonne H les fr\u00e9quences d&#8217;apparition de chacun des r\u00e9sultats.<\/p>\n<p><strong>Pour 1\u00a0000 lancers<\/strong><\/p>\n<p>Modifier la feuille de calcul de mani\u00e8re \u00e0 simuler 1\u00a0000 lancers, puis observer les r\u00e9sultats.<\/p>\n<p><strong>Justification<\/strong><\/p>\n<p>A l&#8217;aide d&#8217;un arbre de choix ou d&#8217;un tableau justifier les r\u00e9sultats observ\u00e9s.<\/p>\n<h2>Documents<\/h2>\n<ul>\n<li><a href=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/difference_des_eleve_v2.pdf\">Fiche \u00e9l\u00e8ve Diff\u00e9rence de deux d\u00e9s<\/a> (pdf)<\/li>\n<li><a href=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/difference_des_corrige.ods\">Diff\u00e9rence de deux d\u00e9s corrig\u00e9<\/a> (ods)<\/li>\n<li><a href=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-content\/uploads\/sites\/3\/2016\/09\/difference_des_corrige.xls\">Diff\u00e9rence de deux d\u00e9s corrig\u00e9<\/a> (xls)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contenu : On lance simultan\u00e9ment deux d\u00e9s et on s&#8217;int\u00e9resse \u00e0 la diff\u00e9rence des deux faces obtenues (le plus grand r\u00e9sultat moins le plus petit). Pr\u00e9requis \u00a0Utilisation basique d&#8217;un tableur (recopie de formules) \u00a0Notion de fr\u00e9quence . Objectifs \u00a0Introduire les outils du tableur permettant de r\u00e9aliser des simulations (fonctions ALEA.ENTRE.BORNES et NB.SI) \u00a0R\u00e9aliser une simulation &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/difference-de-deux-des\/\">Lire la suite<\/a><\/p>\n","protected":false},"author":351,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[23,22,14],"tags":[],"class_list":["post-1949","post","type-post","status-publish","format-standard","hentry","category-seconde","category-lycee","category-numerique","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/posts\/1949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/users\/351"}],"replies":[{"embeddable":true,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/comments?post=1949"}],"version-history":[{"count":3,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/posts\/1949\/revisions"}],"predecessor-version":[{"id":1959,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/posts\/1949\/revisions\/1959"}],"wp:attachment":[{"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/media?parent=1949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/categories?post=1949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ent2d.ac-bordeaux.fr\/disciplines\/mathematiques\/wp-json\/wp\/v2\/tags?post=1949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}