{"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":"<p><strong>LliureX\u00a0<\/strong>incorpora per defecte com a editor de text<strong>\u00a0Libre Office Writer<\/strong>, que igual que altres processadors de text, ens dona l\u2019opci\u00f3 de \u201c<em>Combinar Correspond\u00e8ncia\u201d\u00a0<\/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\u00a0<strong>Libre Office Calc<\/strong>\u00a0amb Writer per a realitzar informes individualitzats.<\/p>\n<p>Vegem com seria el proc\u00e9s. Comencem creant un document gen\u00e8ric on\u00a0<strong>deixarem espai per a inserir els camps del full de c\u00e0lcul<\/strong>, posant el nom que tindr\u00e0 aqueix camp:<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><figure id=\"attachment_mmd_4330\" class=\"wp-block-image \"><img decoding=\"async\" width=\"911\" height=\"509\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_120622.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>\n<p>Creem el full de c\u00e0lcul amb\u00a0<strong>Calc<\/strong>\u00a0que ens servir\u00e0 com a font de dades:<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><figure id=\"attachment_mmd_4331\" class=\"wp-block-image \"><img decoding=\"async\" width=\"842\" height=\"294\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121029.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>\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\u00a0<strong>Base de dades<\/strong>. Haurem de buscar el nostre document a Afig\u00a0<strong>Fitxer\u00a0de Base de dades<\/strong>\u00a0i el vinculem. En aquest cas estem usant un fitxer\u00a0<em>.ods<\/em>\u00a0de Calc, per\u00f2 podr\u00edem usar un\u00a0<em>CSV<\/em>\u00a0o una base de dades de Base :<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><figure id=\"attachment_mmd_4332\" class=\"wp-block-image \"><img decoding=\"async\" width=\"602\" height=\"686\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_121237.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>\n<p>Despr\u00e9s, caldr\u00e0\u00a0<strong>anar canviant<\/strong>\u00a0<strong>\u00a0els 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\u00a0<strong>a Insereix-&gt;Camps-&gt;Uns altres<\/strong>\u00a0i haurem de seleccionar el camp amb el qual volem substituir aqueixa paraula, i finalment cal pr\u00e9mer\u00a0<strong>Insereix<\/strong>\u00a0(per exemple, canviem la paraula\u00a0<strong>Nom<\/strong>\u00a0en el text pel camp\u00a0<strong>Nom<\/strong>\u00a0de la base de dades)<\/p>\n<p>El resultat final ser\u00e0 una cosa aix\u00ed:<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><figure id=\"attachment_mmd_4333\" class=\"wp-block-image \"><img decoding=\"async\" width=\"739\" height=\"416\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122249.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>\n<p>Ara ja nom\u00e9s ens queda imprimir. Atenci\u00f3,<strong>\u00a0no 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\u00a0 Fitxer.<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><figure id=\"attachment_mmd_4334\" class=\"wp-block-image \"><img decoding=\"async\" width=\"1024\" height=\"562\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122526-1024x562.png\" class=\"attachment-1024x562 size-1024x562\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>\n<p>El resultat final \u00e9s un full de qualificacions per alumne. Si triem l\u2019opci\u00f3 d<strong>\u2018Eixida-&gt;Fitxer<\/strong>\u00a0podem exportar a un document de text que podem editar abans d\u2019imprimir.<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><figure id=\"attachment_mmd_4335\" class=\"wp-block-image \"><img decoding=\"async\" width=\"593\" height=\"519\" src=\"https:\/\/edutictac.es\/blog\/sasogu\/wp-content\/uploads\/sites\/3\/2021\/11\/Screenshot_20200309_122840.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" \/><\/figure><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>LliureX\u00a0incorpora per defecte com a editor de text\u00a0Libre Office Writer, que igual que altres processadors de text, ens dona l\u2019opci\u00f3 de \u201cCombinar Correspond\u00e8ncia\u201d\u00a0, 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>","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}]}}