{"id":4329,"date":"2021-11-24T14:51:19","date_gmt":"2021-11-24T12:51:19","guid":{"rendered":"https:\/\/edutictac.es\/sasogu\/?p=4329"},"modified":"2021-11-24T14:51:19","modified_gmt":"2021-11-24T12:51:19","slug":"crea-informes-individualitzats-a-partir-duna-taula-amb-qualificacions","status":"publish","type":"post","link":"https:\/\/edutictac.es\/blog\/sasogu\/crea-informes-individualitzats-a-partir-duna-taula-amb-qualificacions\/","title":{"rendered":"Crea informes individualitzats a partir d\u2019una taula amb qualificacions"},"content":{"rendered":"\n<p><strong>LliureX&nbsp;<\/strong>incorpora per defecte com a editor de text<strong>&nbsp;Libre Office Writer<\/strong>, que igual que altres processadors de text, ens dona l\u2019opci\u00f3 de \u201c<em>Combinar Correspond\u00e8ncia\u201d&nbsp;<\/em>, aix\u00f2 vol dir redactar un model de document i emplenar part del text amb informaci\u00f3 extreta des d\u2019una altra font de dades. Tradicionalment el seu \u00fas ha sigut el de combinar correspond\u00e8ncia la qual cosa hui en dia ja no \u00e9s una opci\u00f3 molt popular. Per\u00f2 com a docents li podem traure molt de partit a aquesta funcionalitat, per exemple podem combinar un full amb les qualificacions dels nostres alumnes generat en&nbsp;<strong>Libre Office Calc<\/strong>&nbsp;amb Writer per a realitzar informes individualitzats.<\/p>\n\n\n\n<p>Vegem com seria el proc\u00e9s. Comencem creant un document gen\u00e8ric on&nbsp;<strong>deixarem espai per a inserir els camps del full de c\u00e0lcul<\/strong>, posant el nom que tindr\u00e0 aqueix camp:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"911\" height=\"509\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_120622.png\" alt=\"\" class=\"wp-image-4330\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_120622.png 911w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_120622-300x168.png 300w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_120622-768x429.png 768w\" sizes=\"auto, (max-width: 911px) 100vw, 911px\" \/><\/figure><\/div>\n\n\n\n<p>Creem el full de c\u00e0lcul amb&nbsp;<strong>Calc<\/strong>&nbsp;que ens servir\u00e0 com a font de dades:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"294\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121029.png\" alt=\"\" class=\"wp-image-4331\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121029.png 842w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121029-300x105.png 300w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121029-768x268.png 768w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/figure><\/div>\n\n\n\n<p>Ara haurem d\u2019anar a-&gt;Camps-&gt;Uns altres i en la finestra que se\u2019ns obri caldr\u00e0 anar a la pestanya&nbsp;<strong>Base de dades<\/strong>. Haurem de buscar el nostre document a Afig&nbsp;<strong>Fitxer&nbsp;de Base de dades<\/strong>&nbsp;i el vinculem. En aquest cas estem usant un fitxer&nbsp;<em>.ods<\/em>&nbsp;de Calc, per\u00f2 podr\u00edem usar un&nbsp;<em>CSV<\/em>&nbsp;o una base de dades de Base :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"686\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121237.png\" alt=\"\" class=\"wp-image-4332\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121237.png 602w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121237-263x300.png 263w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure><\/div>\n\n\n\n<p>Despr\u00e9s, caldr\u00e0&nbsp;<strong>anar canviant<\/strong>&nbsp;<strong>&nbsp;els espais, que hav\u00edem deixat abans, pels camps de la base de dades<\/strong>. El que cal fer \u00e9s seleccionar la paraula que deixem com a espai, cal tornar&nbsp;<strong>a Insereix-&gt;Camps-&gt;Uns altres<\/strong>&nbsp;i haurem de seleccionar el camp amb el qual volem substituir aqueixa paraula, i finalment cal pr\u00e9mer&nbsp;<strong>Insereix<\/strong>&nbsp;(per exemple, canviem la paraula&nbsp;<strong>Nom<\/strong>&nbsp;en el text pel camp&nbsp;<strong>Nom<\/strong>&nbsp;de la base de dades)<\/p>\n\n\n\n<p>El resultat final ser\u00e0 una cosa aix\u00ed:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"416\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122249.png\" alt=\"\" class=\"wp-image-4333\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122249.png 739w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122249-300x169.png 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/figure><\/div>\n\n\n\n<p>Ara ja nom\u00e9s ens queda imprimir. Atenci\u00f3,<strong>&nbsp;no trieu la funci\u00f3 d\u2019exportar a PDF<\/strong>, cal utilitzar l\u2019opci\u00f3 Imprimeix. All\u00ed hem de confirmar l\u2019origen de les dades i podrem triar entre Impressora o&nbsp; Fitxer.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"562\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526-1024x562.png\" alt=\"\" class=\"wp-image-4334\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526-1024x562.png 1024w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526-300x165.png 300w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526-768x422.png 768w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526.png 1065w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>El resultat final \u00e9s un full de qualificacions per alumne. Si triem l\u2019opci\u00f3 d<strong>\u2018Eixida-&gt;Fitxer<\/strong>&nbsp;podem exportar a un document de text que podem editar abans d\u2019imprimir.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"593\" height=\"519\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122840.png\" alt=\"\" class=\"wp-image-4335\" srcset=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122840.png 593w, https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122840-300x263.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>LliureX&nbsp;incorpora per defecte com a editor de text&nbsp;Libre Office Writer, que igual que altres processadors de text, ens dona l\u2019opci\u00f3 de \u201cCombinar Correspond\u00e8ncia\u201d&nbsp;, aix\u00f2 vol dir redactar un model de document i emplenar part del text amb informaci\u00f3 extreta des d\u2019una altra font de dades. Tradicionalment el seu \u00fas ha sigut el de combinar correspond\u00e8ncia &#8230; <a title=\"Crea informes individualitzats a partir d\u2019una taula amb qualificacions\" class=\"read-more\" href=\"https:\/\/edutictac.es\/blog\/sasogu\/crea-informes-individualitzats-a-partir-duna-taula-amb-qualificacions\/\" aria-label=\"M\u00e9s informaci\u00f3 sobre Crea informes individualitzats a partir d\u2019una taula amb qualificacions\">Llegiu m\u00e9s<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":""},"categories":[7],"tags":[37],"class_list":["post-4329","post","type-post","status-publish","format-standard","hentry","category-lliurex","tag-libreoffice"],"_links":{"self":[{"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/posts\/4329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/comments?post=4329"}],"version-history":[{"count":0,"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/posts\/4329\/revisions"}],"wp:attachment":[{"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/media?parent=4329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/categories?post=4329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/edutictac.es\/blog\/sasogu\/wp-json\/wp\/v2\/tags?post=4329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}