{"id":6371,"date":"2022-11-15T12:33:12","date_gmt":"2022-11-15T11:33:12","guid":{"rendered":"https:\/\/matematikmedit.dk\/?page_id=6371"},"modified":"2023-03-13T10:38:38","modified_gmt":"2023-03-13T09:38:38","slug":"regneark-2","status":"publish","type":"page","link":"https:\/\/matematikmedit.dk\/?page_id=6371","title":{"rendered":"Regneark"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#3e4f82&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_menu menu_id=&#8221;75&#8243; dropdown_menu_bg_color=&#8221;#3883c1&#8243; logo=&#8221;https:\/\/matematikmedit.dk\/wp-content\/uploads\/2021\/03\/Logo-dmlf-h65.png&#8221; logo_max_width=&#8221;75%&#8221; logo_max_width_tablet=&#8221;65%&#8221; logo_max_width_phone=&#8221;&#8221; logo_max_width_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; menu_font=&#8221;||||||||&#8221; menu_text_color=&#8221;#FFFFFF&#8221; background_color=&#8221;#3e4f82&#8243; text_orientation=&#8221;right&#8221; max_width=&#8221;100%&#8221; module_alignment=&#8221;right&#8221; min_height=&#8221;69px&#8221; custom_margin=&#8221;0px||-18px||false|false&#8221; custom_padding=&#8221;0px||0px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_menu][et_pb_fullwidth_header title=&#8221;Matematik med it&#8221; text_orientation=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; title_font=&#8221;|300|||||||&#8221; title_text_color=&#8221;#FFFFFF&#8221; title_font_size=&#8221;60px&#8221; title_letter_spacing=&#8221;1px&#8221; content_font_size=&#8221;20px&#8221; content_letter_spacing=&#8221;1px&#8221; subhead_font=&#8221;|300|||||||&#8221; subhead_text_color=&#8221;#FFFFFF&#8221; subhead_font_size=&#8221;20px&#8221; subhead_letter_spacing=&#8221;1px&#8221; subhead_line_height=&#8221;1.8em&#8221; background_enable_color=&#8221;off&#8221; width=&#8221;100%&#8221; min_height=&#8221;137px&#8221; min_height_tablet=&#8221;&#8221; min_height_phone=&#8221;&#8221; min_height_last_edited=&#8221;on|phone&#8221; height=&#8221;150px&#8221; height_tablet=&#8221;&#8221; height_phone=&#8221;&#8221; height_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;0px||0px||true|false&#8221; custom_padding_tablet=&#8221;0px||0px||false|false&#8221; custom_padding_phone=&#8221;&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; title_font_tablet=&#8221;&#8221; title_font_phone=&#8221;&#8221; title_font_last_edited=&#8221;on|phone&#8221; title_font_size_tablet=&#8221;40px&#8221; title_font_size_phone=&#8221;25px&#8221; title_font_size_last_edited=&#8221;on|tablet&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span style=\"font-family: 'Playfair Display';\">Regneark<\/span><\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;2_5,3_5&#8243; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;https:\/\/matematikmedit.dk\/wp-content\/uploads\/2022\/11\/Regneark.jpg&#8221; title_text=&#8221;Regneark&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>Brugen af regneark har v\u00e6ret en fast del af undervisningen, da der er en s\u00e6rlig syntaks, som eleverne skal have en vis grad af kendskab til for at programmet kan udf\u00f8re beregninger. Det er ogs\u00e5 en udfordring, at formler er skjult i regnearket.<\/p>\n<p>Brugen af regneark \u00e5ber for i hvertfald f\u00f8lgende omr\u00e5der:<\/p>\n<ul>\n<li>Behandling af store datas\u00e6t<\/li>\n<li>Trinvis fremskrivninger i forbindelse med modelleringen af fx afbetalingshandel, befolkningsudvikling, epidemier.<\/li>\n<li>En st\u00f8rre forst\u00e5else af variabelbegrebet.<\/li>\n<li>Simulering af simple stokastiske eksperimenter.<\/li>\n<li>Regression &#8211; skal bruges med forsigtighed.<\/li>\n<\/ul>\n<p><em>(Fra l\u00e6rervejledningen til &#8221; Matematik med it&#8221; bog 2 og 3)<\/em><\/p>\n<p>Jesper Quist har udarbejdet et powerpoint, der viser de mange muligheder, der ligger i anvendelse af regneark i matematikundervisningen. Der er b\u00e5de tekniske fif og didaktiske muligheder i pr\u00e6sentationen, som du <a href=\"https:\/\/matematikmedit.dk\/wp-content\/uploads\/2022\/11\/Excel-Odense.pdf\" target=\"_blank\" rel=\"noopener\">finder her<\/a> <a href=\"https:\/\/bit.ly\/diasexcelodense\"><\/a>\u200b<\/p>\n<p>Jesper har ogs\u00e5 udarbejdet et google-site, der hedder \u2019Unders\u00f8gende arbejde i Excel\u2019, hvor mange faciliteter i programmet er anvendt i en virkelighedsn\u00e6r kontekst. Der ligger gode anvisninger til, hvordan programmet kan underst\u00f8tte forskellige matematiske unders\u00f8gelser.<br \/>Du finder sitet her: <a href=\"https:\/\/sites.google.com\/view\/undersgendearbejdeiexcel\/startside\">https:\/\/sites.google.com\/view\/undersgendearbejdeiexcel\/startside<\/a><\/p>\n<p>Se h\u00e6ftet med <a href=\"https:\/\/matematikmedit.dk\/wp-content\/uploads\/2022\/11\/Mit-foerste-moede-med-Excel.pdf\" target=\"_blank\" rel=\"noopener\">Mit f\u00f8rste m\u00f8de med Excel<\/a><\/p>\n<p><a href=\"https:\/\/matematikmedit.dk\/wp-content\/uploads\/2022\/11\/Diplom-Excel-2.docx\" target=\"_blank\" rel=\"noopener\">Diplom<\/a><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#636363&#8243; custom_margin=&#8221;||-55px|||&#8221; custom_padding=&#8221;0px|||||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;2_3,1_3&#8243; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; max_width_tablet=&#8221;&#8221; max_width_phone=&#8221;&#8221; max_width_last_edited=&#8221;on|phone&#8221; min_height=&#8221;185.4px&#8221; custom_margin=&#8221;|auto|-47px|auto||&#8221; custom_padding=&#8221;50px||50px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.18.1&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;12px&#8221; text_letter_spacing=&#8221;1px&#8221; text_line_height=&#8221;1.1em&#8221; header_text_color=&#8221;#FFFFFF&#8221; header_3_text_color=&#8221;#FFFFFF&#8221; header_4_text_color=&#8221;#FFFFFF&#8221; header_5_text_color=&#8221;#FFFFFF&#8221; custom_margin=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Danmarks Matematikl\u00e6rerforening<\/p>\n<p>Forlaget Matematik ApS<\/p>\n<p>Naverland 2, 2600 Glostrup<\/p>\n<p><span>Email: mat.forlag@dkmat.dk<\/span><br \/><span>Tlf. 86 59 60 22<\/span><br \/><span>CVR.nr. 30 58 83 12<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;12px&#8221; text_line_height=&#8221;1.5em&#8221; header_2_text_color=&#8221;#FFFFFF&#8221; header_3_text_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;|||0px||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Kontakt<\/h3>\n<p>Har du sp\u00f8rgsm\u00e5l i forbindelse med projektet, kan du sende en mail til:\u00a0 <span style=\"color: #2ea3f2;\"><a style=\"color: #2ea3f2;\" href=\"mailto:mat.forlag@dkmat.dk\">Forlaget MATEMATIK<\/a><\/span><\/p>\n<p>Eller du kan kontakte\u00a0<a href=\"mailto:ksp@dkmat.dk\">S\u00f8s Spahn<\/a><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>RegnearkBrugen af regneark har v\u00e6ret en fast del af undervisningen, da der er en s\u00e6rlig syntaks, som eleverne skal have en vis grad af kendskab til for at programmet kan udf\u00f8re beregninger. Det er ogs\u00e5 en udfordring, at formler er skjult i regnearket. Brugen af regneark \u00e5ber for i hvertfald f\u00f8lgende omr\u00e5der: Behandling af store [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-template-blank.php","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-6371","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Regneark - MATEMATIK MED IT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/matematikmedit.dk\/?page_id=6371\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Regneark - MATEMATIK MED IT\" \/>\n<meta property=\"og:description\" content=\"RegnearkBrugen af regneark har v\u00e6ret en fast del af undervisningen, da der er en s\u00e6rlig syntaks, som eleverne skal have en vis grad af kendskab til for at programmet kan udf\u00f8re beregninger. Det er ogs\u00e5 en udfordring, at formler er skjult i regnearket. Brugen af regneark \u00e5ber for i hvertfald f\u00f8lgende omr\u00e5der: Behandling af store [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/matematikmedit.dk\/?page_id=6371\" \/>\n<meta property=\"og:site_name\" content=\"MATEMATIK MED IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/forlagetmatematik\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-13T09:38:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/matematikmedit.dk\/wp-content\/uploads\/2021\/03\/LOGO-D-M-L-221x65-1.jpg?fit=221%2C65&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"221\" \/>\n\t<meta property=\"og:image:height\" content=\"65\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/?page_id=6371\",\"url\":\"https:\\\/\\\/matematikmedit.dk\\\/?page_id=6371\",\"name\":\"Regneark - MATEMATIK MED IT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#website\"},\"datePublished\":\"2022-11-15T11:33:12+00:00\",\"dateModified\":\"2023-03-13T09:38:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/?page_id=6371#breadcrumb\"},\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/matematikmedit.dk\\\/?page_id=6371\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/?page_id=6371#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/matematikmedit.dk\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Regneark\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#website\",\"url\":\"https:\\\/\\\/matematikmedit.dk\\\/\",\"name\":\"MATEMATIK MED IT\",\"description\":\"Hvilke potentialer er der, n\u00e5r vi bruger digitale v\u00e6rkt\u00f8jer i matematikundervisningen?\",\"publisher\":{\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/matematikmedit.dk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"da-DK\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#organization\",\"name\":\"Forlaget Matematik\",\"url\":\"https:\\\/\\\/matematikmedit.dk\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/matematikmedit.dk\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/LOGO-ForlagetMatematik.png?fit=97%2C54&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/matematikmedit.dk\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/LOGO-ForlagetMatematik.png?fit=97%2C54&ssl=1\",\"width\":97,\"height\":54,\"caption\":\"Forlaget Matematik\"},\"image\":{\"@id\":\"https:\\\/\\\/matematikmedit.dk\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/forlagetmatematik\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Regneark - MATEMATIK MED IT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/matematikmedit.dk\/?page_id=6371","og_locale":"da_DK","og_type":"article","og_title":"Regneark - MATEMATIK MED IT","og_description":"RegnearkBrugen af regneark har v\u00e6ret en fast del af undervisningen, da der er en s\u00e6rlig syntaks, som eleverne skal have en vis grad af kendskab til for at programmet kan udf\u00f8re beregninger. Det er ogs\u00e5 en udfordring, at formler er skjult i regnearket. Brugen af regneark \u00e5ber for i hvertfald f\u00f8lgende omr\u00e5der: Behandling af store [&hellip;]","og_url":"https:\/\/matematikmedit.dk\/?page_id=6371","og_site_name":"MATEMATIK MED IT","article_publisher":"https:\/\/www.facebook.com\/forlagetmatematik","article_modified_time":"2023-03-13T09:38:38+00:00","og_image":[{"width":221,"height":65,"url":"https:\/\/i0.wp.com\/matematikmedit.dk\/wp-content\/uploads\/2021\/03\/LOGO-D-M-L-221x65-1.jpg?fit=221%2C65&ssl=1","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimeret l\u00e6setid":"4 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/matematikmedit.dk\/?page_id=6371","url":"https:\/\/matematikmedit.dk\/?page_id=6371","name":"Regneark - MATEMATIK MED IT","isPartOf":{"@id":"https:\/\/matematikmedit.dk\/#website"},"datePublished":"2022-11-15T11:33:12+00:00","dateModified":"2023-03-13T09:38:38+00:00","breadcrumb":{"@id":"https:\/\/matematikmedit.dk\/?page_id=6371#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/matematikmedit.dk\/?page_id=6371"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/matematikmedit.dk\/?page_id=6371#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/matematikmedit.dk\/"},{"@type":"ListItem","position":2,"name":"Regneark"}]},{"@type":"WebSite","@id":"https:\/\/matematikmedit.dk\/#website","url":"https:\/\/matematikmedit.dk\/","name":"MATEMATIK MED IT","description":"Hvilke potentialer er der, n\u00e5r vi bruger digitale v\u00e6rkt\u00f8jer i matematikundervisningen?","publisher":{"@id":"https:\/\/matematikmedit.dk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/matematikmedit.dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Organization","@id":"https:\/\/matematikmedit.dk\/#organization","name":"Forlaget Matematik","url":"https:\/\/matematikmedit.dk\/","logo":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/matematikmedit.dk\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/matematikmedit.dk\/wp-content\/uploads\/2016\/11\/LOGO-ForlagetMatematik.png?fit=97%2C54&ssl=1","contentUrl":"https:\/\/i0.wp.com\/matematikmedit.dk\/wp-content\/uploads\/2016\/11\/LOGO-ForlagetMatematik.png?fit=97%2C54&ssl=1","width":97,"height":54,"caption":"Forlaget Matematik"},"image":{"@id":"https:\/\/matematikmedit.dk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/forlagetmatematik"]}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8jkG5-1EL","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/pages\/6371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6371"}],"version-history":[{"count":5,"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/pages\/6371\/revisions"}],"predecessor-version":[{"id":6547,"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=\/wp\/v2\/pages\/6371\/revisions\/6547"}],"wp:attachment":[{"href":"https:\/\/matematikmedit.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}