{"id":392,"date":"2016-09-05T17:51:39","date_gmt":"2016-09-05T15:51:39","guid":{"rendered":"http:\/\/www.cours-info.ch\/wordpress\/?p=392"},"modified":"2016-09-05T17:51:39","modified_gmt":"2016-09-05T15:51:39","slug":"ex-x-tri-01-6-semaines-de-vacances-par-annee","status":"publish","type":"post","link":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2016\/09\/05\/ex-x-tri-01-6-semaines-de-vacances-par-annee\/","title":{"rendered":"Ex. X.TRI.01 \u2013 6 semaines de vacances par ann\u00e9e"},"content":{"rendered":"<div class=\"panel wiki\"><b>Objectif(s)<\/b><\/div>\n<div class=\"panel wiki\">Utiliser les filtres et le tri pour extraire des donn\u00e9es pr\u00e9cises<br \/>\n<b>Tutos\u00a0utiles<br \/>\n<\/b>Trier<br \/>\nFiltrer<\/p>\n<p><b>Consignes<\/b><br \/>\n1. <a href=\"http:\/\/www.cours-info.ch\/wordpress\/wp-content\/uploads\/2016\/09\/x.tri_.01.xlsx\">Cliquez ici pour ouvrir le document contenant les donn\u00e9es<\/a><br \/>\n2. Cr\u00e9ez un filtre dans le tableau<br \/>\n3. R\u00e9pondez aux questions suivantes dans un document texte (Textedit) :<\/p>\n<pre>a) Combien d'\u00e9lecteurs sont inscrits dans la plus petite commune vaudoise ?\r\n \r\nb) En moyenne, quel \u00e9tait le score (Oui en %) des 6 plus grandes (en nombre d'\u00e9lecteurs inscrits) villes de Suisse ?\r\n \r\nc) Quelle commune vaudoise a obtenu le plus fort taux de \"oui\" ?\r\n \r\nd) Et le plus faible ?<\/pre>\n<p>4. Quand vous avez fini, enregistrez-le classeur sous <strong>Ex. X.TRI.01.xlsx<\/strong>, le document texte sous <b>R\u00e9ponses Ex. X.TRI.01<\/b>\u00a0et d\u00e9posez-les dans votre r\u00e9pertoire personnel dans le dossier \u00ab\u00a0Tableur\u00a0\u00bb<b><\/b><br \/>\n5.\u00a0Passez \u00e0 l&rsquo;exercice suivant<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Objectif(s) <a href=\"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2016\/09\/05\/ex-x-tri-01-6-semaines-de-vacances-par-annee\/\" class=\"read-more\">Cliquez pour voir la suite<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-392","post","type-post","status-publish","format-standard","hentry","category-filtrer-et-trier-des-donnees"],"_links":{"self":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":2,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":1435,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/392\/revisions\/1435"}],"wp:attachment":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}