Topicm12b2faf14160063a_1528449000663_0Topic

Revision on the spreadscheet

Levelm12b2faf14160063a_1528449084556_0Level

Second

Core curriculumm12b2faf14160063a_1528449076687_0Core curriculum

Grade VII - VIII

II. Programming and solving problems by using the computer and other digital devices. Using computer applications the student:

3) creates documents and presentations, including those in a cloud in order to solve problems and create papers from various fields (subjects), adjusts the format and the appearance of the research papers to their content/purpose and demonstrates the following skills:

c) performing calculations specified in the curriculum of various subjects within the scope of primary school and useful in everyday life and implementing selected algorithms in a spreadsheet: entering data in a worksheet table, using basic functions, using relative, absolute and mixed references, presenting data in the form of various charts, ordering and filtering data.

Timingm12b2faf14160063a_1528449068082_0Timing

45 minutes

General objectivem12b2faf14160063a_1528449523725_0General objective

Test on the spreadscheet.

Specific objectivesm12b2faf14160063a_1528449552113_0Specific objectives

1. Feedback on students’ progress.
2. Managing the time during the test.
3. Communicating in English; developing basic scientific, technical and digital competences; developing learning skills.

Learning outcomesm12b2faf14160063a_1528450430307_0Learning outcomes

The student:
Feedback on his/her skills.

Methodsm12b2faf14160063a_1528449534267_0Methods

1. Flipped classroom.
2. Test.

Forms of workm12b2faf14160063a_1528449514617_0Forms of work

Individual work.

Lesson stages

Introductionm12b2faf14160063a_1528450127855_0Introduction

Before the test the students get acquainted with time management during the test.m12b2faf14160063a_1527752263647_0Before the test the students get acquainted with time management during the test.

The teacher presents exercises grading schema.
Discussion on test evaluation.
The minimum passing grade - 40% of correctly solved tasks.
Failing grade below 40% of correctly solved tasks.m12b2faf14160063a_1527752256679_0The teacher presents exercises grading schema.
Discussion on test evaluation.
The minimum passing grade - 40% of correctly solved tasks.
Failing grade below 40% of correctly solved tasks.

Procedurem12b2faf14160063a_1528446435040_0Procedure

PROGRESS TEST

Rh8vyqiyZOfu6

Plik do pobrania z pytaniami testowymi w języku angielskim.

Plik do pobrania z pytaniami testowymi w języku angielskim.

Zasób interaktywny dostępny pod adresem https://zpe.gov.pl/a/D3IXFhu0o

Lesson summarym12b2faf14160063a_1528450119332_0Lesson summary

Discussion on each exercise: correct answer, incorrect answer.
Students get 1 point for each correct task.m12b2faf14160063a_1527712094602_0Discussion on each exercise: correct answer, incorrect answer.
Students get 1 point for each correct task.

Selected words and expressions used in the lesson plan

cellcellcell, columncolumncolumn, data typesdata typesdata types, formulaformulaformula, spreadsheetspreadsheetspreadsheet

correct answercorrect answercorrect answer, gradegradegrade, incorrect answerincorrect answerincorrect answer, knowledgeknowledgeknowledge, negative evaluationnegative evaluationnegative evaluation, positive evaluationpositive evaluationpositive evaluation, skillsskillsskills, solutionsolutionsolution, tasktasktask, testtesttest