{"id":477,"date":"2011-04-19T18:14:35","date_gmt":"2011-04-19T22:14:35","guid":{"rendered":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/?p=477"},"modified":"2016-06-23T11:18:54","modified_gmt":"2016-06-23T15:18:54","slug":"18-avril-2011-utilisation-pedagogique-du-tableur","status":"publish","type":"post","link":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/18-avril-2011-utilisation-pedagogique-du-tableur\/","title":{"rendered":"18 avril 2011 &#8211; Utilisation p\u00e9dagogique du tableur"},"content":{"rendered":"<p><a href=\"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/15-decembre-2009-apres-cours-fga-en-mathematiques-utiliser-excel-en-classe\/logo_microsoft_excel_2013\/\" rel=\"attachment wp-att-2857\"><img decoding=\"async\" class=\"alignleft size-thumbnail wp-image-2857\" src=\"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-content\/uploads\/sites\/2\/2009\/12\/Logo_Microsoft_Excel_2013-150x150.png\" alt=\"Logo_Microsoft_Excel_2013\" width=\"150\" height=\"150\" srcset=\"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-content\/uploads\/sites\/2\/2009\/12\/Logo_Microsoft_Excel_2013-150x150.png 150w, https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-content\/uploads\/sites\/2\/2009\/12\/Logo_Microsoft_Excel_2013-144x144.png 144w, https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-content\/uploads\/sites\/2\/2009\/12\/Logo_Microsoft_Excel_2013.png 256w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Animateur : St\u00e9phane Lavoie (RECIT FGA Mont\u00e9r\u00e9gie)<\/p>\n<p>Participants :<\/p>\n<ul>\n<li>Robert Gour (Bas-Saint-Laurent)<\/li>\n<li>Marc-Andr\u00e9 Blais (Mont\u00e9r\u00e9gie)<\/li>\n<\/ul>\n<hr \/>\n<p>Une rencontre de discussion sur l\u2019utilisation p\u00e9dagogique du tableur.<\/p>\n<p>En appui visuel \u00e0 la rencontre, j\u2019ai utilis\u00e9 cette petite pr\u00e9sentation.<\/p>\n<p><iframe src=\"https:\/\/docs.google.com\/presentation\/d\/1cF-PKa_QYV4Y1J_w6_fis24UQHOzeJ7LZcRZDlu8LOc\/embed?start=true&amp;loop=true&amp;delayms=3000\" width=\"533\" height=\"429\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Nous avons entre autres pass\u00e9 en revue quelques fonctions int\u00e9ressantes de Excel pour acc\u00e9l\u00e9rer le traitement de donn\u00e9es (notamment en MAT5102).<\/p>\n<p><!--more--><\/p>\n<p>L\u2019utilisation des fonctions suivantes a \u00e9t\u00e9 expliqu\u00e9e :<\/p>\n<ul>\n<ul>\n<li>moyenne<\/li>\n<li>\u00e9cart-type<\/li>\n<li>coefficient.correlation<\/li>\n<li>droitereg<\/li>\n<\/ul>\n<\/ul>\n<p>Nous avons par la suite pris quelques minutes pour voir rapidement les fonctions de Google Documents &#8211; Feuille de Calcul.<\/p>\n<p>Robert a constat\u00e9 que l\u2019appel des fonctions dans Google Document est en anglais, ce qui est moins int\u00e9ressant. Par contre, les possibilit\u00e9s de partage et de cor\u00e9daction lui conf\u00e8rent un avantage dans certaines situations.<\/p>\n<p>Je remercie aussi Pierre Couillard (du <a href=\"http:\/\/recitmst.qc.ca\/\">RECIT MST<\/a>)qui a r\u00e9pondu \u00e0 mon gazouillis avec deux ressources int\u00e9ressantes \u00e0 explorer pour une utilisation p\u00e9dagogique du tableur :<\/p>\n<ul>\n<ul>\n<ul>\n<li><a href=\"http:\/\/recitmst.qc.ca\/Calc-Le-chiffrier-electronique-d\">http:\/\/recitmst.qc.ca\/Calc-Le-chiff&#8230;<\/a><\/li>\n<li><a href=\"http:\/\/recitmst.qc.ca\/maths\/Simulation-d-un-lancement-d-un-de\">http:\/\/recitmst.qc.ca\/maths\/Simulat&#8230;<\/a><\/li>\n<\/ul>\n<\/ul>\n<\/ul>\n<p>Merci aux participants !<\/p>\n<hr \/>\n<h3>Et puis apr\u00e8s ?<\/h3>\n<p>Vous d\u00e9sirez poursuivre la discussion ? Vous avez de nouvelles ressources ?<\/p>\n<p>Je vous invite au forum des math\u00e9matiques du Salon national des enseignants (accessible \u00e0 <a href=\"http:\/\/moodle.fgamonteregie.qc.ca\/mod\/forum\/view.php?id=235\">http:\/\/moodle.fgamonteregie.qc.ca\/mod\/forum\/view.php ?id=235<\/a>).<\/p>\n<p>Si vous n\u2019y avez pas de compte, suivez la proc\u00e9dure \u00e0 <a href=\"http:\/\/spip.fgamonteregie.qc.ca\/spip.php?article1178\">http:\/\/spip.fgamonteregie.qc.ca\/spip.php ?article1178<\/a>.<\/p>\n<div style=\"text-align: -webkit-auto;\"><span style=\"font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: x-small;\"><span class=\"Apple-style-span\" style=\"line-height: 19px; white-space: normal;\"><br \/>\n<\/span><\/span><\/div>\n<pre style=\"text-align: left !important; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f3f3f7; overflow-x: auto; overflow-y: auto; word-wrap: break-word; padding: 11px; margin: 0px 0px 22px 0px; border: 1px solid #dedee3;\"><span style=\"font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: x-small;\"><span class=\"Apple-style-span\" style=\"line-height: 19px; white-space: normal;\">&lt;!--more--&gt;<\/span><\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Animateur : St\u00e9phane Lavoie (RECIT FGA Mont\u00e9r\u00e9gie) Participants : Robert Gour (Bas-Saint-Laurent) Marc-Andr\u00e9 Blais (Mont\u00e9r\u00e9gie) Une rencontre de discussion sur l\u2019utilisation p\u00e9dagogique du tableur. En appui visuel \u00e0 la rencontre, j\u2019ai utilis\u00e9 cette petite pr\u00e9sentation. Nous avons entre autres pass\u00e9 en revue quelques fonctions int\u00e9ressantes de Excel pour acc\u00e9l\u00e9rer le traitement de donn\u00e9es (notamment en MAT5102).<\/p>\n","protected":false},"author":2,"featured_media":2938,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182],"tags":[142,141,61,143],"class_list":["post-477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-index","tag-pedagogie","tag-tableur","tag-technologie","tag-utilisation"],"_links":{"self":[{"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/posts\/477"}],"collection":[{"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/comments?post=477"}],"version-history":[{"count":0,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/posts\/477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/media\/2938"}],"wp:attachment":[{"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/media?parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/categories?post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.carrefourfga.ca\/ticfga\/aprescours\/wp-json\/wp\/v2\/tags?post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}