<?xml version="1.0" encoding="UTF-8"?><lom:lom xmlns:lom="http://ltsc.ieee.org/xsd/LOM" xmlns:lomfr="http://www.lom-fr.fr/xsd/LOMFR" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://ltsc.ieee.org/xsd/LOM http://lom-fr.fr/xsd/lomfrv1.0/std/lomfr.xsd">
<lom:general>
<lom:identifier>
<lom:catalog>IEL</lom:catalog>
<lom:entry>oai:iutengligne.net:1158</lom:entry>
</lom:identifier>
<lom:title>
<lom:string language="fre"><![CDATA[Automatisation des tableaux de bord avec Excel]]>
</lom:string>
</lom:title>
<lom:language>fre</lom:language>
<lom:description>
<lom:string language="fre"><![CDATA[Ce cours décortique l’automatisation sous Excel de deux exemples de tableaux de bord. Il montre comment combiner une approche tableur (formules avancées, plages nommées…) et une approche algorithmique (programmation Visual Basic) pour y parvenir.
]]></lom:string>
</lom:description>
<lom:keyword>
<lom:string language="fre">excel</lom:string>
</lom:keyword>
<lom:keyword>
<lom:string language="fre">tableau de bord</lom:string>
</lom:keyword>
<lom:keyword>
<lom:string language="fre">visual basic</lom:string>
</lom:keyword>
<lom:keyword>
<lom:string language="fre">tableur</lom:string>
</lom:keyword>
<lomfr:documentType>
<lomfr:source>LOMFRv1.0</lomfr:source>
<lomfr:value>ressource interactive</lomfr:value>
</lomfr:documentType>
<lom:structure>
<lom:source>LOMv1.0</lom:source>
<lom:value>atomic</lom:value>
</lom:structure>
</lom:general>
<lom:lifeCycle>
<lom:contribute>
<lom:role>
<lom:source>LOMv1.0</lom:source>
<lom:value>author</lom:value>
</lom:role>
<lom:entity><![CDATA[BEGIN:VCARD
VERSION:3.0 
N:Raffinat;Patrick;;;
FN:Patrick Raffinat 
EMAIL;TYPE=INTERNET: 
ORG:IUTenligne;;
END:VCARD]]></lom:entity>
<lom:date>
<lom:dateTime>2013-04-10</lom:dateTime>
</lom:date>
</lom:contribute>
<lom:contribute>
<lom:role>
<lom:source>LOMv1.0</lom:source>
<lom:value>publisher</lom:value>
</lom:role>
<lom:entity><![CDATA[BEGIN:VCARD 
VERSION:3.0 
N: ;;;; 
FN: IUTenligne
ORG: IUTenligne;;
END:VCARD]]></lom:entity>
<lom:date>
<lom:dateTime>2013-04-10</lom:dateTime>
</lom:date>
</lom:contribute>
</lom:lifeCycle>
<lom:metaMetadata>
<lom:identifier>
<lom:catalog>IEL</lom:catalog>
<lom:entry>meta-22081</lom:entry>
</lom:identifier>
<lom:metadataSchema>LOMv1.0</lom:metadataSchema>
<lom:metadataSchema>LOMFRv1.0</lom:metadataSchema>
<lom:metadataSchema>SupLOMFRv1.0</lom:metadataSchema>
<lom:language>fre</lom:language>
</lom:metaMetadata>
<lom:technical>
<lom:format>text/html</lom:format>
<lom:format>application/vnd.ms-excel</lom:format>
<lom:size/>
<lom:location>http://public.iutenligne.net/informatique/bureautique/raffinat/TableauBordExcel/</lom:location>
</lom:technical>
<lom:educational>
<lom:learningResourceType>
<lom:source>LOMv1.0</lom:source>
<lom:value>lecture</lom:value>
</lom:learningResourceType>
<lom:learningResourceType>
<lom:source>LOMv1.0</lom:source>
<lom:value>exercise</lom:value>
</lom:learningResourceType>
<lom:learningResourceType>
<lom:source>LOMv1.0</lom:source>
<lom:value>experiment</lom:value>
</lom:learningResourceType>
<lom:intendedEndUserRole>
<lom:source>LOMv1.0</lom:source>
<lom:value>learner</lom:value>
</lom:intendedEndUserRole>
<lom:context>
<lom:source>SupLOMFRv1.0</lom:source>
<lom:value>Bac+2</lom:value>
</lom:context>
<lom:context>
<lom:source>SupLOMFRv1.0</lom:source>
<lom:value>Bac+3</lom:value>
</lom:context>
<lom:context>
<lom:source>LOMv1.0</lom:source>
<lom:value>higher education</lom:value>
</lom:context>
<lom:language>fre</lom:language>
</lom:educational>
<lom:rights>
<lom:cost>
<lom:source>LOMv1.0</lom:source>
<lom:value>no</lom:value>
</lom:cost>
<lom:copyrightAndOtherRestrictions>
<lom:source>LOMv1.0</lom:source>
<lom:value>yes</lom:value>
</lom:copyrightAndOtherRestrictions>
<lom:description>
<lom:string language="fre">Propriété IUTenligne. Utilisation libre dans le cadre de l'enseignement en formation initiale par les enseignants des IUT.
L'auteur accepte l'utilisation en formation continue : oui. Contacter le webmaster pour connaître la procédure.
</lom:string>
</lom:description>
</lom:rights>
<lom:classification>
<lom:purpose>
<lom:source>LOMv1.0</lom:source>
<lom:value>discipline</lom:value>
</lom:purpose>
<lom:taxonPath>
<lom:source>
<lom:string language="eng">DDC 22nd ed</lom:string> 
<lom:string language="fre">CDD 22e éd.</lom:string>
</lom:source>
<lom:taxon>
<lom:id>005.3</lom:id>
<lom:entry>
<lom:string language="fre"><![CDATA[Logiciels]]></lom:string>
<lom:string language="eng"><![CDATA[Programs]]></lom:string>
</lom:entry>
</lom:taxon>
</lom:taxonPath>
</lom:classification>
<lom:classification>
<lom:purpose> 
<lom:source>LOMv1.0</lom:source> 
<lom:value>security level</lom:value>
</lom:purpose> 
<lom:taxonPath>
<lom:source>
<lom:string language="fre">Projet OCW France</lom:string>
</lom:source> 
<lom:taxon>
<lom:id/> 
<lom:entry>
<lom:string language="fre">Catalogue OCWC</lom:string> 
</lom:entry>
</lom:taxon> 
</lom:taxonPath>
</lom:classification>
</lom:lom>