{"id":19026,"date":"2024-09-16T08:54:42","date_gmt":"2024-09-16T06:54:42","guid":{"rendered":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/?p=19026"},"modified":"2024-09-16T09:03:19","modified_gmt":"2024-09-16T07:03:19","slug":"curs-de-gestio-de-dades","status":"publish","type":"post","link":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/xerrades\/portada\/curs-de-gestio-de-dades\/","title":{"rendered":"CURS DE GESTI\u00d3 DE DADES"},"content":{"rendered":"
Des del CRP del Maresme ofereixen un curs telem\u00e0tic per tal que tots els professionals que hagin de gestionar dades a partir del RALC, GTAF, Esfer@… aprenguin a fer servir el full de c\u00e0lcul i, per tant, facilitar-nos la feina en aquesta tasca.<\/div>\n
<\/div>\n
Han dissenyant el curs\u00a0 partint de les peticions\u00a0 des dels Serveis Educatius, per\u00f2, tamb\u00e9 pensant amb les necessitats dels centres. \u00c9s un curs llarg i amb moltes sessions sincr\u00f2niques.<\/div>\n
<\/div>\n
Totes aquelles persones que estigueu interessades, no deixeu d’apuntar-vos al curs a trav\u00e9s d’aquest\u00a0ENLLA\u00c7\u00a0<\/a>(fins al 22 de setembre).<\/div>\n
<\/div>\n
<\/div>\n
\n\n\n\n
M\u00e9s informaci\u00f3<\/span><\/b><\/td>\n[\u00a0Detall d’activitat<\/a>\u00a0]\u00a0<\/span><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
<\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
A091011A09\u00a0\u00a0<\/span><\/b><\/td>\nEines de gesti\u00f3 de dades amb full de c\u00e0lcul (Excel i Google Sheets)<\/span><\/td>\n<\/tr>\n
2024-2025\u00a0\u00a0<\/span><\/b><\/td>\nCurs. Prim\u00e0ria-Secund\u00e0ria<\/span><\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n<\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n14\/10\/2024 – 26\/5\/2025 (30 hores)\u00a0de\u00a017:00h a 18:30h<\/span><\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\nCRP del Maresme I<\/span><\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\nc\/ Onofre Arnau, 32, 2n.\u00a0(Matar\u00f3)\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n<\/td>\n<\/tr>\n
Format\u00a0\u00a0<\/span><\/b><\/td>\nEn l\u00ednia<\/span><\/td>\n<\/tr>\n
Sincronicitat \u00a0\u00a0<\/span><\/b><\/td>\nS\u00edncron<\/span><\/td>\n<\/tr>\n
Organitzaci\u00f3\u00a0\u00a0<\/span><\/b><\/td>\nServei Educatiu Matar\u00f3<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Inscripci\u00f3\u00a0\u00a0<\/span><\/b><\/td>\n06\/09\/2024 – 22\/09\/2024<\/span><\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n<\/td>\n<\/tr>\n
Descripci\u00f3 i \u00a0 Metodologia:\u00a0\u00a0<\/span><\/b><\/td>\nA trav\u00e9s d’aquest curs es posaran a l’abast eines eficaces (Excel\/Google Sheets) per processar dades estructurades en forma tabular.
\n<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Objectius\u00a0\u00a0<\/span><\/b><\/td>\nCDD<\/span><\/p>\n

– Explorar les funcionalitats d’Excel i Google Sheets per optimitzar el seu \u00fas.
\n– Processar dades estructurades de forma tabular com s\u00f3n: les exportacions de les diferents aplicacions que es fan servir als centres educatius, els fulls de c\u00e0lcul amb les respostes de formularis de Google, els llistats procedents de diverses fonts que s\u2019han d\u2019unificar en una base de dades centralitzada, arxius creats individualment pels docents, etc.
\n– Con\u00e8ixer les difer\u00e8ncies i semblances entre Excel i Google Sheets per valorar l’\u00fas d’una eina o l’altra en funci\u00f3 del context.<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n
Continguts\u00a0\u00a0<\/span><\/b><\/td>\n– Funcions
\n– Taules \/ Rangs tabulars
\n– Filtres
\n– Validaci\u00f3 de dades
\n– Format condicional
\n– Creaci\u00f3 d’un full amb dades procedents d\u2019altres fulls (o llibres)
\n– Protecci\u00f3 de dades<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Formador\/a\u00a0\u00a0<\/span><\/b><\/td>\nJuan Conejo Ariza<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Avaluaci\u00f3\u00a0\u00a0<\/span><\/b><\/td>\n– Satisfacci\u00f3 de les persones en relaci\u00f3 amb el disseny i el desenvolupament de l\u2019activitat formativa i percepci\u00f3 de transferibilitat.
\n– Aprofitament en termes d\u2019aprenentatge dels continguts de la formaci\u00f3 orientats a una futura implementaci\u00f3 a la pr\u00e0ctica docent.
\n– En aquelles activitats que ho contemplin, transfer\u00e8ncia immediata a la pr\u00e0ctica docent d\u2019aspectes relacionats amb els continguts de l\u2019activitat formativa.
\n<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Requisits de\u00a0 certificaci\u00f3\u00a0\u00a0<\/span><\/b><\/td>\n– Activitats presencials i semipresencials: Assist\u00e8ncia a un m\u00ednim del 80% de les hores s\u00edncrones
\n– Valoraci\u00f3 positiva de totes les tasques planificades en relaci\u00f3 amb l\u2019aprofitament.
\n<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
Persones\u00a0 destinat\u00e0ries\u00a0\u00a0<\/span><\/b><\/td>\nIntegrants dels equips directius, docents responsables de les coordinacions, coordinadors digitals, docents administradors de l\u2019aula virtual, docents que recullin les seves qualificacions en full de c\u00e0lcul, etc.
\n<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
E-mail\u00a0\u00a0<\/span><\/b><\/td>\ncrp-mataro@xtec.cat<\/a><\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
\u00a0\u00a0<\/span><\/b><\/td>\n<\/td>\n<\/tr>\n
Calendari\u00a0\u00a0<\/span><\/b><\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u00a0Sessi\u00f3 1\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a014\/10\/2024\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 2\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a028\/10\/2024\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 3\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a011\/11\/2024\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 4\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a025\/11\/2024\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 5\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a013\/01\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 6\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a027\/01\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 7\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a010\/02\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 8\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a024\/02\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 9\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a010\/03\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 10\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a024\/03\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 11\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a007\/04\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 12\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a028\/04\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 13\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a012\/05\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n
\u00a0Sessi\u00f3 14\u00a0<\/span><\/td>\n\u00a0dilluns\u00a0<\/span><\/td>\n\u00a026\/05\/2025\u00a0<\/span><\/td>\n\u00a01700\u00a0<\/span><\/td>\n\u00a01830\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Des del CRP del Maresme ofereixen un curs telem\u00e0tic per tal que tots els professionals que hagin de gestionar dades a partir del RALC, GTAF, Esfer@… aprenguin a fer servir el full de c\u00e0lcul i, per tant, facilitar-nos la feina en aquesta tasca. Han dissenyant el curs\u00a0 partint de les peticions\u00a0 des dels Serveis Educatius, […]<\/p>\n","protected":false},"author":7,"featured_media":19027,"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,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","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":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","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":""}},"footnotes":""},"categories":[376,29],"tags":[],"class_list":["post-19026","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formacio","category-portada"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/posts\/19026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/comments?post=19026"}],"version-history":[{"count":2,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/posts\/19026\/revisions"}],"predecessor-version":[{"id":19029,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/posts\/19026\/revisions\/19029"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/media\/19027"}],"wp:attachment":[{"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/media?parent=19026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/categories?post=19026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/serveiseducatius.xtec.cat\/baixpenedes\/wp-json\/wp\/v2\/tags?post=19026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}