{"id":531,"date":"2026-06-02T15:39:06","date_gmt":"2026-06-02T13:39:06","guid":{"rendered":"https:\/\/sno.lycee-guynemer.com\/portfolio-lamarque\/?p=531"},"modified":"2026-06-07T22:25:26","modified_gmt":"2026-06-07T20:25:26","slug":"tableur-excel","status":"publish","type":"post","link":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/2026\/06\/02\/tableur-excel\/","title":{"rendered":"Tableur EXCEL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Durant ma formation en CS SNO, je devais utilis\u00e9 un jeu de donn\u00e9es t\u00e9l\u00e9charg\u00e9 sur le portail Open Data du d\u00e9partement des Pyr\u00e9n\u00e9es-Atlantiques (data.le64.fr).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"953\" src=\"https:\/\/sno.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-1024x953.png\" alt=\"\" class=\"wp-image-536\" style=\"aspect-ratio:1.0747520046796168;width:124px;height:auto\" srcset=\"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-1024x953.png 1024w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-300x279.png 300w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-768x715.png 768w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-1536x1429.png 1536w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-6-2048x1906.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background\" style=\"background-color:#60dade;color:#60dade\" \/>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>J&rsquo;ai t\u00e9l\u00e9charg\u00e9 le fichier de donn\u00e9es depuis le site data.le64.fr.<\/li>\n\n\n\n<li>J&rsquo;ai enregistr\u00e9 le fichier au format Excel sous le nom demand\u00e9.<\/li>\n\n\n\n<li>J&rsquo;ai appliqu\u00e9 une mise en forme au tableau afin d&rsquo;am\u00e9liorer sa lisibilit\u00e9 (en-t\u00eates, organisation des colonnes, style de tableau).<\/li>\n\n\n\n<li>J&rsquo;ai cr\u00e9\u00e9 de nouveaux onglets contenant des analyses graphiques issues des donn\u00e9es.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#b4b4b4;color:#b4b4b4\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">Analyse des graphiques<\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-medium-font-size\">Graphique 1 : R\u00e9partition des \u00e9tablissements publics et priv\u00e9s<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Le premier graphique pr\u00e9sente le nombre d&rsquo;\u00e9tablissements selon leur secteur.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00c9tablissements publics : 585<\/li>\n\n\n\n<li>\u00c9tablissements priv\u00e9s : 205<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized has-custom-border\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0\"><img decoding=\"async\" width=\"782\" height=\"432\" src=\"https:\/\/sno.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-3.png\" alt=\"\" class=\"has-border-color wp-image-532\" style=\"border-color:#60dade;border-width:2px;border-top-left-radius:10px;border-top-right-radius:10px;border-bottom-left-radius:10px;border-bottom-right-radius:10px;aspect-ratio:1.810254936573751;width:510px;height:auto\" srcset=\"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-3.png 782w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-3-300x166.png 300w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-3-768x424.png 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ce graphique montre que la majorit\u00e9 des \u00e9tablissements du d\u00e9partement appartiennent au secteur public.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#b4b4b4;color:#b4b4b4\" \/>\n\n\n\n<h3 class=\"wp-block-heading has-medium-font-size\">Graphique 2 : R\u00e9partition des \u00e9tablissements par type<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Le second graphique pr\u00e9sente la r\u00e9partition des \u00e9tablissements selon leur cat\u00e9gorie (\u00e9coles, coll\u00e8ges, lyc\u00e9es, etc.).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border\"><img decoding=\"async\" width=\"849\" height=\"452\" src=\"https:\/\/sno.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-4.png\" alt=\"\" class=\"has-border-color wp-image-533\" style=\"border-color:#60dade;border-width:3px;border-top-left-radius:10px;border-top-right-radius:10px;border-bottom-left-radius:10px;border-bottom-right-radius:10px\" srcset=\"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-4.png 849w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-4-300x160.png 300w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-4-768x409.png 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background\" style=\"background-color:#60dade;color:#60dade\" \/>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"40\" src=\"https:\/\/sno.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-5.png\" alt=\"\" class=\"wp-image-534\" style=\"width:504px;height:auto\" srcset=\"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-5.png 480w, https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-content\/uploads\/sites\/22\/2026\/06\/image-5-300x25.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background\" style=\"background-color:#60dade;color:#60dade\" \/>\n\n\n\n<p class=\"wp-block-paragraph\">Cette repr\u00e9sentation permet d&rsquo;observer quelles cat\u00e9gories d&rsquo;\u00e9tablissements sont les plus nombreuses dans le d\u00e9partement et de comparer leur importance respective.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#b4b4b4;color:#b4b4b4\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ce travail m&rsquo;a permis de d\u00e9couvrir l&rsquo;utilisation de donn\u00e9es ouvertes, de les exploiter dans un tableur Excel et de r\u00e9aliser des graphiques pour faciliter leur analyse. Les r\u00e9sultats offrent une meilleure visualisation de la r\u00e9partition des diff\u00e9rents types d&rsquo;\u00e9tablissements scolaires.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Durant ma formation en CS SNO, je devais utilis\u00e9 un jeu de donn\u00e9es t\u00e9l\u00e9charg\u00e9 sur le portail Open Data du d\u00e9partement des Pyr\u00e9n\u00e9es-Atlantiques (data.le64.fr). Introduction Analyse des graphiques Graphique 1 : R\u00e9partition des \u00e9tablissements publics et priv\u00e9s Le premier graphique pr\u00e9sente le nombre d&rsquo;\u00e9tablissements selon leur secteur. Ce graphique montre que la majorit\u00e9 des \u00e9tablissements [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-531","post","type-post","status-publish","format-standard","hentry","category-activites"],"blocksy_meta":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/posts\/531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/comments?post=531"}],"version-history":[{"count":2,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":537,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/posts\/531\/revisions\/537"}],"wp:attachment":[{"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/media?parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/categories?post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cyber.lycee-guynemer.com\/portfolio-lamarque\/wp-json\/wp\/v2\/tags?post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}