{"id":33196,"date":"2024-07-15T12:05:48","date_gmt":"2024-07-15T10:05:48","guid":{"rendered":"https:\/\/projectes.xtec.cat\/pensament-computacional\/?post_type=nodes_recursos&#038;p=33196"},"modified":"2024-09-18T13:05:12","modified_gmt":"2024-09-18T11:05:12","slug":"registrem-dades-en-fulls-de-calcul-a-internet","status":"publish","type":"nodes_recursos","link":"https:\/\/projectes.xtec.cat\/pensament-computacional\/recursos\/registrem-dades-en-fulls-de-calcul-a-internet\/","title":{"rendered":"Registrem dades en fulls de c\u00e0lcul a Internet"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-6 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-align-center has-small-font-size\"><a href=\"https:\/\/drive.google.com\/thumbnail?id=1BduMefZu8pBjFpCP9tJLqHNCgKBnZOI3\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/drive.google.com\/thumbnail?id=1BduMefZu8pBjFpCP9tJLqHNCgKBnZOI3\" alt=\"ESP32 STEAMakers\"><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-align-center has-small-font-size\"><a href=\"https:\/\/drive.google.com\/thumbnail?id=1_M2IhLU_4TVmIf86la5o75HNVZIzbEBd\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/drive.google.com\/thumbnail?id=1_M2IhLU_4TVmIf86la5o75HNVZIzbEBd\" alt=\"Shield Imagina Arduino\"><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-align-center has-small-font-size\"><a href=\"https:\/\/drive.google.com\/thumbnail?id=1PsES5AWeso1LNLGcF4MhMTRTmPZ8i-wP\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/drive.google.com\/thumbnail?id=1PsES5AWeso1LNLGcF4MhMTRTmPZ8i-wP\" alt=\"Shield Imagina TdR Steam\"><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-4 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-align-center has-small-font-size\"><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-align-center has-small-font-size\"><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-5 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column caixa2 is-layout-flow wp-block-column-is-layout-flow\">\n<h4 class=\"wp-block-heading has-text-align-center has-ast-global-color-5-color has-ast-global-color-0-background-color has-text-color has-background\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--30);padding-right:0;padding-bottom:var(--wp--preset--spacing--30);padding-left:0\"><strong>ESO<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading has-text-align-center has-ast-global-color-1-color has-pale-cyan-blue-background-color has-text-color has-background has-small-font-size\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:0;padding-bottom:var(--wp--preset--spacing--20);padding-left:0\"><strong>3r, 4t<\/strong><\/h6>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-getwid-tabs active-tab2 tablinks-active2\" data-active-tab=\"0\"><ul class=\"wp-block-getwid-tabs__nav-links\"><\/ul>\n<div class=\"wp-block-getwid-tabs__nav-link\"><span class=\"wp-block-getwid-tabs__title-wrapper\"><a href=\"#\"><span class=\"wp-block-getwid-tabs__title\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-1-color\"><strong>General<\/strong><\/mark><\/span><\/a><\/span><\/div><div class=\"wp-block-getwid-tabs__tab-content-wrapper\"><div class=\"wp-block-getwid-tabs__tab-content\">\n<div class=\"wp-block-getwid-section caixa2 getwid-margin-top-none\"><div class=\"wp-block-getwid-section__wrapper getwid-padding-top-none getwid-padding-left-none getwid-padding-right-none getwid-margin-left-none getwid-margin-right-none\"><div class=\"wp-block-getwid-section__inner-wrapper\"><div class=\"wp-block-getwid-section__background-holder\"><div class=\"wp-block-getwid-section__background\"><\/div><div class=\"wp-block-getwid-section__foreground\"><\/div><\/div><div class=\"wp-block-getwid-section__content\"><div class=\"wp-block-getwid-section__inner-content\">\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--30);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--30);padding-left:var(--wp--preset--spacing--30)\"><strong>Descripci\u00f3 de l&#8217;activitat<\/strong><\/h5>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--20);margin-right:0;margin-bottom:var(--wp--preset--spacing--20);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\">En l&#8217;activitat s\u2019utilitza una placa ESP32 STEAMakers amb una placa d&#8217;extensi\u00f3 Imagina 3dBot o TdR STEAM equipada amb sensors externs. Els valors mesurats s\u2019envien per Internet a un script lligat a un document de Google Sheets i es registren en un full de c\u00e0lcul del document. L\u2019enviament dels valors mesurats es pot iniciar o aturar manualment amb un bot\u00f3 de la placa d\u2019extensi\u00f3 o b\u00e9 per infraroigs, amb un comandament a dist\u00e0ncia.<\/p>\n<\/div><\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-getwid-section getwid-margin-top-none\"><div class=\"wp-block-getwid-section__wrapper getwid-padding-left-none getwid-padding-right-none getwid-margin-left-none getwid-margin-right-none\"><div class=\"wp-block-getwid-section__inner-wrapper\"><div class=\"wp-block-getwid-section__background-holder\"><div class=\"wp-block-getwid-section__background\"><\/div><div class=\"wp-block-getwid-section__foreground\"><\/div><\/div><div class=\"wp-block-getwid-section__content\"><div class=\"wp-block-getwid-section__inner-content\">\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Material necessari<\/strong><\/h5>\n\n\n\n<div style=\"margin-top:0;margin-bottom:0;height:7px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-getwid-section getwid-margin-top-none getwid-margin-bottom-none\"><div class=\"wp-block-getwid-section__wrapper getwid-padding-top-none getwid-padding-bottom-none getwid-padding-left-none getwid-padding-right-none getwid-margin-left-none getwid-margin-right-none\"><div class=\"wp-block-getwid-section__inner-wrapper\"><div class=\"wp-block-getwid-section__background-holder\"><div class=\"wp-block-getwid-section__background has-background has-ast-global-color-5-background-color\"><\/div><div class=\"wp-block-getwid-section__foreground\"><\/div><\/div><div class=\"wp-block-getwid-section__content\"><div class=\"wp-block-getwid-section__inner-content\">\n<ul class=\"wp-block-list\">\n<li style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">Placa ESP32 STEAMakers<\/li>\n\n\n\n<li style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">Extensi\u00f3 Imagina TdR STEAM<\/li>\n\n\n\n<li style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">Extensi\u00f3 Imagina 3DBot<\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div>\n\n\n\n<div style=\"height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Orientacions pedag\u00f2giques<\/strong><\/h5>\n\n\n\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:var(--wp--preset--spacing--20);padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\">Es formen grups d\u2019alumnes en funci\u00f3 del nombre de plaques i sensors disponibles. Es pot utilitzar qualsevol sensor extern, no \u00e9s necessari fer servir els de l\u2019exemple.<br><br>Cada alumne configura un full de c\u00e0lcul i fa el programa amb ArduinoBlocks segons les instruccions de l\u2019apartat \u201cPas a pas\u201d.<br><br>Si el docent prefereix compartir amb els alumnes el seu script en comptes que cada alumne hagi de crear-ne un de propi, es pot seguir <a href=\"https:\/\/ateneu.xtec.cat\/wikiform\/wikiexport\/cmd\/tac\/computacional\/b12_ai_google_sheets\/06_compartir\">aquest procediment<\/a>.<br><br>Quan un alumne acaba el programa, comprova que funciona correctament amb el material del seu grup.<br><br>Si s\u2019ha de deixar l\u2019equipament en funcionament de forma continuada, \u00e9s convenient augmentar l\u2019interval d\u2019enviament de valors de 10.000 a 43.200.000 (mitja hora).<\/p>\n\n\n\n<div style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30);height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30);height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Elements de programaci\u00f3<\/strong><\/h5>\n\n\n\n<div class=\"wp-block-columns has-ast-global-color-5-background-color has-background is-layout-flex wp-container-core-columns-is-layout-7 wp-block-columns-is-layout-flex\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-left:var(--wp--preset--spacing--30)\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--20)\"><li>Seq\u00fc\u00e8ncies b\u00e0siques<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><li>Bucles<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><li>Condicionals<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><li>Operadors<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><li>Variables<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><\/p>\n\n\n\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p style=\"margin-top:var(--wp--preset--spacing--20);margin-right:0;margin-bottom:var(--wp--preset--spacing--20);margin-left:0\"><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0\"><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0\"><li>Programaci\u00f3 per blocs textuals (verticals)<\/li><\/p>\n\n\n\n<p style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0\"><\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30);height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Eix | \u00c0rea | Mat\u00e8ria<\/strong><\/h5>\n\n\n\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:var(--wp--preset--spacing--20);padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\">SEC &#8211; Tecnologia<\/p>\n\n\n\n<div style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30);height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Compet\u00e8ncies espec\u00edfiques<\/strong><\/h5>\n\n\n\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"margin-top:var(--wp--preset--spacing--20);margin-right:0;margin-bottom:var(--wp--preset--spacing--20);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\">CE04 &#8211; Desenvolupar solucions sostenibles a problemes plantejats que incorporin l\u2019automatitzaci\u00f3 i les tecnologies emergents, per dissenyar i construir sistemes de control programables i rob\u00f2tics<\/p>\n\n\n\n<div style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30);height:2px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading has-pale-cyan-blue-background-color has-background has-medium-font-size\" style=\"margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\"><strong>Sabers<\/strong><\/h5>\n\n\n\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"margin-top:var(--wp--preset--spacing--20);margin-right:0;margin-bottom:var(--wp--preset--spacing--20);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--30)\">Utilitzaci\u00f3 de diferents components de sistemes de control programat: controladors, sensors i actuadors, que permetin l\u2019optimitzaci\u00f3 dels recursos i apliquin l\u2019automatitzaci\u00f3 i la robotitzaci\u00f3.<\/p>\n\n\n\n<p style=\"text-align: right;\">\n    <img decoding=\"async\" style=\"height:22px!important;margin-left:3px;vertical-align:text-bottom;\" src=\"https:\/\/mirrors.creativecommons.org\/presskit\/icons\/cc.svg?ref=chooser-v1\" alt=\"\">\n    <img decoding=\"async\" style=\"height:22px!important;margin-left:3px;vertical-align:text-bottom;\" src=\"https:\/\/mirrors.creativecommons.org\/presskit\/icons\/by.svg?ref=chooser-v1\" alt=\"\">\n    <img decoding=\"async\" style=\"height:22px!important;margin-left:3px;vertical-align:text-bottom;\" src=\"https:\/\/mirrors.creativecommons.org\/presskit\/icons\/nc.svg?ref=chooser-v1\" alt=\"\">\n    <img decoding=\"async\" style=\"height:22px!important;margin-left:3px;vertical-align:text-bottom;\" src=\"https:\/\/mirrors.creativecommons.org\/presskit\/icons\/sa.svg?ref=chooser-v1\" alt=\"\">\n<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-getwid-tabs__nav-link\"><span class=\"wp-block-getwid-tabs__title-wrapper\"><a href=\"#\"><span class=\"wp-block-getwid-tabs__title\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-1-color\"><strong>Pas a pas<\/strong><\/mark><\/span><\/a><\/span><\/div><div class=\"wp-block-getwid-tabs__tab-content-wrapper\"><div class=\"wp-block-getwid-tabs__tab-content\">\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"padding-right:var(--wp--preset--spacing--30);padding-left:var(--wp--preset--spacing--30)\"><b>1. <\/b>Creeu un document nou de Google Sheets:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1-cmxloFc2bk0CBrYCZlSk0AUjs2UJOTe\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1-cmxloFc2bk0CBrYCZlSk0AUjs2UJOTe\" alt=\"Crear un document a google Sheets\"><\/a><br><b>2. <\/b>Escriviu en les cel\u00b7les de la primera fila \u201cData\u201d, \u201cHora\u201d i el nom dels valors que es vulguin registrar:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1_p9kUX8JyTgcjIcNobD_55VqgsixcQGd\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1_p9kUX8JyTgcjIcNobD_55VqgsixcQGd\" alt=\"Cap\u00e7alera del full de c\u00e0lcul amb les dades que es volen recollir\"><\/a><br><b><br>3. <\/b>Creeu un script lligat al document. Seguiu les <a href=\"https:\/\/ateneu.xtec.cat\/wikiform\/wikiexport\/cmd\/tac\/computacional\/b12_ai_google_sheets\/02_configurar\">indicacions<\/a> per obtenir l\u2019URL (\u201cscriptURL\u201d).<br><b><br>4. <\/b>En l\u2019entorn ArduinoBlocks, creeu un nou projecte de tipus ESP32 STEAMakers + Imagina 3dBot o ESP32 STEAMakers + Imagina TdR STEAM, en funci\u00f3 de la placa d&#8217;extensi\u00f3 que s\u2019utilitzi (les captures de pantalla d\u2019aquest \u201cpas a pas\u201d s\u2019han fet per a la placa Imagina 3dBot).<br><b><br>5. <\/b>En el bloc d\u2019Inicialitzaci\u00f3 s\u2019ha d\u2019establir la connexi\u00f3 a Internet i al servidor de temps NTP. Tamb\u00e9 es defineix la variable booleana \u201cenviant\u201d que determina si s\u2019han d\u2019enviar valors o no i la variable \u201ccomanda\u201d que cont\u00e9 el codi IR que emet el comandament a dist\u00e0ncia:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=14X7vaXUuPJkGJaDbSY4UkwpBVWOnXR1l\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=14X7vaXUuPJkGJaDbSY4UkwpBVWOnXR1l\" alt=\"Blocs per programar la connexi\u00f3 a internet i al servidor de temps NTP]<br><b><br>6. <\/b>Obtenir el codi IR que emet el comandament a dist\u00e0ncia transferint un petit programa a la placa i visualitzant la sortida en la consola d\u2019ArduinoBlocks. Com a comandament IR es pot utilitzar el de dotaci\u00f3 (cal una pila bot\u00f3 CR2025) o el de qualsevol TV:<br>[Imatge 4 (Blocs per obtenir el codi IR&#8221;><\/a><br><b>6. <\/b>Obtenir el codi IR que emet el comandament a dist\u00e0ncia transferint un petit programa a la placa i visualitzant la sortida en la consola d\u2019ArduinoBlocks. Com a comandament IR es pot utilitzar el de dotaci\u00f3 (cal una pila bot\u00f3 CR2025) o el de qualsevol TV:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1hxCyYfcwSP5f8BiYUYdF8UwW6jEomOAG\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1hxCyYfcwSP5f8BiYUYdF8UwW6jEomOAG\" alt=\"programa per comprovar si s'ha premut el bot\u00f3\"><\/a><br><b>7. <\/b>En el bucle principal, es comprova cada 200 ms si l\u2019usuari ha premut el bot\u00f3 de la placa o del comandament a dist\u00e0ncia. L\u2019esdeveniment commuta el valor de la variable \u201cenviant\u201d i enc\u00e9n o apaga un led que mostra a l\u2019usuari l\u2019estat d\u2019enviament:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=14PKm43sLRrPqPg63J50v0YljAMWE8vQb\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=14PKm43sLRrPqPg63J50v0YljAMWE8vQb\" alt=\"Bucle per enviar els valors mesurats a l'script\"><\/a><br><b>8. <\/b>A continuaci\u00f3, tamb\u00e9 en el bucle principal, s\u2019envia a intervals la data, l\u2019hora i els valors mesurats pels sensors externs a l\u2019script. L\u2019URL per afegir una fila al full de c\u00e0lcul t\u00e9 el format (consulteu <a href=\"https:\/\/ateneu.xtec.cat\/wikiform\/wikiexport\/cmd\/tac\/computacional\/b12_ai_google_sheets\/04_consultes#insert\" target=\"_blank\" rel=\"noopener\">aqu\u00ed<\/a>): scriptURL?query=insert&amp;values=hora$$dia$$valor1$$valor2$$valor3\u2026<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1wr9i8Lbxzm5LAZFhd9SneJMwPo1fIVPg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1wr9i8Lbxzm5LAZFhd9SneJMwPo1fIVPg\" alt=\"Imatge del resultat\"><\/a><br><b>9. <\/b>Transferir el programa a la placa ESP32 STEAMakers, pr\u00e9mer el bot\u00f3 de la placa d\u2019extensi\u00f3 i comprovar que la informaci\u00f3 s\u2019envia i es registra correctament en el full de c\u00e0lcul:<a href=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1A77fCbR0wfLMrqspHY4weyoEATmiFUiW\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" style=\"display:block;margin:0 auto;margin-top:20px;max-width:500px;max-height:500px\" src=\"https:\/\/edumet.cat\/areatac\/robotica\/get.php?id=1A77fCbR0wfLMrqspHY4weyoEATmiFUiW\" alt=\"undefined\"><\/a><\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-getwid-tabs__nav-link\"><span class=\"wp-block-getwid-tabs__title-wrapper\"><a href=\"#\"><span class=\"wp-block-getwid-tabs__title\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-1-color\"><strong>Desc\u00e0rregues i fitxa t\u00e8cnica<\/strong><\/mark><\/span><\/a><\/span><\/div><div class=\"wp-block-getwid-tabs__tab-content-wrapper\"><div class=\"wp-block-getwid-tabs__tab-content\">\n<p class=\"has-ast-global-color-5-background-color has-background\" style=\"padding-right:var(--wp--preset--spacing--30);padding-left:var(--wp--preset--spacing--30)\">&#8211; <a href=\"https:\/\/drive.google.com\/file\/d\/1U-XKIPBWlgQGqB1m--1DiAcGlvXvHz82\/view?usp=drive_link\" target=\"_blank\" rel=\"noreferrer noopener\">Programa sencer<\/a><br>&#8211; <a href=\"https:\/\/projectes.xtec.cat\/digital\/equipaments-i-infraestructures\/robotica\/formacio-tecnica-robotica\/plaques-microcontroladores\/esp32-steamakers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fitxa t\u00e8cnica de la placa ESP32 STEAMakers<\/a><br>&#8211; <a href=\"https:\/\/projectes.xtec.cat\/digital\/equipaments-i-infraestructures\/robotica\/formacio-tecnica-robotica\/components-i-accessoris\/imagina-tdr-steam\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fitxa t\u00e8cnica de la placa d&#8217;extensi\u00f3 Imagina TdR STEAM<\/a><br>&#8211; <a href=\"https:\/\/projectes.xtec.cat\/digital\/equipaments-i-infraestructures\/robotica\/formacio-tecnica-robotica\/components-i-accessoris\/imagina-3dbot\/\" data-type=\"link\" data-id=\"https:\/\/projectes.xtec.cat\/digital\/equipaments-i-infraestructures\/robotica\/formacio-tecnica-robotica\/components-i-accessoris\/imagina-3dbot\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fitxa t\u00e8cnica de la placa d&#8217;extensi\u00f3 Imagina 3DBo<\/a>t<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>En aquesta activitat utilitzarem una placa ESP32 STEAMakers equipada amb sensors externs per enviar a trav\u00e9s d&#8217;Internet un script lligat a un document de Google Sheets.<\/p>\n","protected":false},"featured_media":34268,"template":"","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,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"nodes_tipus_recursos":[],"nodes_robots_recursos":[567,568,569,559],"nodes_materies_recursos":[573,602],"nodes_ambits_recursos":[],"nodes_complexitat_recursos":[610],"nodes_idiomes_recursos":[],"nodes_PRI_CAT":[],"nodes_PRI_CAS":[],"nodes_PRI_LEST":[],"nodes_PRI_MAT":[],"nodes_PRI_MED":[],"nodes_PRI_EDF":[],"nodes_SEC_FIQ":[],"nodes_PRI_ART":[],"nodes_PRI_ETI":[],"nodes_SEC_CAT":[],"nodes_SEC_FOL":[],"nodes_SEC_LAT":[],"nodes_SEC_ARES":[],"nodes_SEC_BIOGEO":[],"nodes_SEC_GEO":[],"nodes_SEC_CUCI":[],"nodes_SEC_DIG":[],"nodes_SEC_ECO":[],"nodes_SEC_VAL":[],"nodes_SEC_EDFIS":[],"nodes_SEC_EVIP":[],"nodes_SEC_EXART":[],"nodes_SEC_EMP":[],"nodes_SEC_FIL":[],"nodes_SEC_CCLA":[],"nodes_SEC_LEST":[],"nodes_SEC_CAS":[],"nodes_SEC_MAT":[],"nodes_SEC_MUS":[],"nodes_SEC_ROB":[],"nodes_SEC_TEC":[454],"nodes_SEC_TID":[],"nodes_INF_EIX1":[],"nodes_INF_EIX2":[],"nodes_INF_EIX3":[],"nodes_INF_EIX4":[],"nodes_etiqueta_recursos":[],"class_list":["post-33196","nodes_recursos","type-nodes_recursos","status-publish","has-post-thumbnail","hentry","nodes_robots_recursos-esp32","nodes_robots_recursos-3dbot","nodes_robots_recursos-tdr","nodes_robots_recursos-plaques","nodes_materies_recursos-sec","nodes_materies_recursos-tecno_sec","nodes_complexitat_recursos-avancat","nodes_SEC_TEC-sectece04"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_recursos\/33196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_recursos"}],"about":[{"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/types\/nodes_recursos"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/media\/34268"}],"wp:attachment":[{"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/media?parent=33196"}],"wp:term":[{"taxonomy":"nodes_tipus_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_tipus_recursos?post=33196"},{"taxonomy":"nodes_robots_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_robots_recursos?post=33196"},{"taxonomy":"nodes_materies_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_materies_recursos?post=33196"},{"taxonomy":"nodes_ambits_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_ambits_recursos?post=33196"},{"taxonomy":"nodes_complexitat_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_complexitat_recursos?post=33196"},{"taxonomy":"nodes_idiomes_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_idiomes_recursos?post=33196"},{"taxonomy":"nodes_PRI_CAT","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_CAT?post=33196"},{"taxonomy":"nodes_PRI_CAS","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_CAS?post=33196"},{"taxonomy":"nodes_PRI_LEST","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_LEST?post=33196"},{"taxonomy":"nodes_PRI_MAT","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_MAT?post=33196"},{"taxonomy":"nodes_PRI_MED","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_MED?post=33196"},{"taxonomy":"nodes_PRI_EDF","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_EDF?post=33196"},{"taxonomy":"nodes_SEC_FIQ","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_FIQ?post=33196"},{"taxonomy":"nodes_PRI_ART","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_ART?post=33196"},{"taxonomy":"nodes_PRI_ETI","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_PRI_ETI?post=33196"},{"taxonomy":"nodes_SEC_CAT","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_CAT?post=33196"},{"taxonomy":"nodes_SEC_FOL","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_FOL?post=33196"},{"taxonomy":"nodes_SEC_LAT","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_LAT?post=33196"},{"taxonomy":"nodes_SEC_ARES","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_ARES?post=33196"},{"taxonomy":"nodes_SEC_BIOGEO","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_BIOGEO?post=33196"},{"taxonomy":"nodes_SEC_GEO","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_GEO?post=33196"},{"taxonomy":"nodes_SEC_CUCI","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_CUCI?post=33196"},{"taxonomy":"nodes_SEC_DIG","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_DIG?post=33196"},{"taxonomy":"nodes_SEC_ECO","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_ECO?post=33196"},{"taxonomy":"nodes_SEC_VAL","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_VAL?post=33196"},{"taxonomy":"nodes_SEC_EDFIS","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_EDFIS?post=33196"},{"taxonomy":"nodes_SEC_EVIP","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_EVIP?post=33196"},{"taxonomy":"nodes_SEC_EXART","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_EXART?post=33196"},{"taxonomy":"nodes_SEC_EMP","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_EMP?post=33196"},{"taxonomy":"nodes_SEC_FIL","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_FIL?post=33196"},{"taxonomy":"nodes_SEC_CCLA","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_CCLA?post=33196"},{"taxonomy":"nodes_SEC_LEST","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_LEST?post=33196"},{"taxonomy":"nodes_SEC_CAS","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_CAS?post=33196"},{"taxonomy":"nodes_SEC_MAT","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_MAT?post=33196"},{"taxonomy":"nodes_SEC_MUS","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_MUS?post=33196"},{"taxonomy":"nodes_SEC_ROB","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_ROB?post=33196"},{"taxonomy":"nodes_SEC_TEC","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_TEC?post=33196"},{"taxonomy":"nodes_SEC_TID","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_SEC_TID?post=33196"},{"taxonomy":"nodes_INF_EIX1","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_INF_EIX1?post=33196"},{"taxonomy":"nodes_INF_EIX2","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_INF_EIX2?post=33196"},{"taxonomy":"nodes_INF_EIX3","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_INF_EIX3?post=33196"},{"taxonomy":"nodes_INF_EIX4","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_INF_EIX4?post=33196"},{"taxonomy":"nodes_etiqueta_recursos","embeddable":true,"href":"https:\/\/projectes.xtec.cat\/pensament-computacional\/wp-json\/wp\/v2\/nodes_etiqueta_recursos?post=33196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}