Methodical development "creation and use of interactive tests". We organize training in the blog

The popularity of all kinds tests and surveys is now very large. They find their main application, of course, in education: conducting exams and tests, passing all kinds of tests and the learning process itself in the form of quizzes or situational tasks. But their application is not limited to this. Polls public opinion, marketing research and just entertaining puzzles at your leisure - all this can be organized using a similar software.

On the Internet, you can find many site-constructors for creating tests. Some of them allow embed tests on pages of another site using a special code, some generate a unique URL for each test, which can be added as a link. But the main thing is that they all have a wide selection of various types of questions and tasks, save the results and provide detailed statistics on the results, and some even automatically issue certificates of successful completion to users (of course, virtual ones).

So that you do not waste time searching, we have collected in this review the top ten, in our opinion, systems of the class in question. Each of them has its own zest, among them there are paid and free solutions, so you are sure to choose the most suitable option for yourself.

Revision Quiz Maker

Quizinator

All The Tests

Testmoz

play buzz

Class Marker

The free plan allows up to 100 tests per month. For more, you will have to purchase a regular subscription with a monthly payment or a service package for occasional use.

Flexi Quiz

• GoConqr

  multifunctional knowledge testing and verification system focused on various disciplines, including geography, algebra and physics.

  Apart from classical tests allows you to create flashcards, educational slideshows and mind maps for more effective training for an exam or test.

  

If you want to organize training on your blog, you can use the Dabbleboard service. I found ideas and instructions for this organization of work at this address Application of the Dabbleboard service on the subject teacher's blog. I think that you will find there a lot of interesting and useful things for yourself. To do this, install the service on your blog. See Mastering the Dabbleboar for information on how to do this. The advantage of Dabbleboard is that it has a Freehand tool that allows you to draw (which is convenient for entering formulas, examples, schemes, reaction equations, etc.) . Also, this service has the ability to use some algebraic operators.

1. Create a Dabbleboard document (with multiple pages) in which each student uses a different page to complete an assignment.

2. If you need to work individually, then for each student create a document and put the appropriate links on your blog under the names of the students for whom they are intended. You can write the task by hand on an ordinary sheet, then scan it and put it on the Dabbleboard worksheet as a picture, or write the task in MS Word and also add it to the worksheet. In order for the students to have joint access to the document with you and be able to to edit it, solving a problem or answering your question, you need to type your student's email address in the invite others line on the right side of the board (in the chat). On his email you will receive a message about the task and a link to the Dabbleboard map you created.

Copy the address bar of the Dabbleboard page created for the student.

Next, in your blog, click on the button " Design"and on the opened page" Page elements" on the right side of the blog layout click " Add Gadget". Among the list of opened gadgets, select the gadget " Link List" and paste the copied address into the field " Add a link". In the "Contents" field, enter the student's last name. And click " Save".

This gadget allows you to do it differently. For example, create a shared link to work with several students, name the link whatever you want, for example, "Online learning" or "For 10 b", and place several links at once to the created Dabbleboard pages.

Wish you success!
You can also use blogging to organize training.interactive tests. To work with them you need a computer and a browser. And nothing more. Naturally, you need yourself interactive th test.

How are interactive tests created? in certain programs.

The most famous of them are here:
AdTester Knowing MyTest Hot Potatoes

AT All programs are free. Some have paid add-ons.
Hot Potatoes (

Gazimagomedov Malik

this work will be very interesting to those who want to diversify the forms of the OPR in the lesson.

Download:

Preview:

Introduction.

Exist various ways involvement of students in the learning process. Interactive testing is one of them. Students like to test in dialogue mode with a computer and immediately get the result, rather than waiting for the teacher to check paper tests. This work allows teachers to create interactive tests that do not require special skills in working in MS Excel.
The paper discusses the non-standard use of spreadsheets and programs for creating computer testsfor knowledge control. Thanks to the ease of creating (recording) macros, you can give tests interactivity, even without knowing Visual Basic, the language in which they are written..

The work consists of three sections. In the first -basic information on MS Excel- only the most basic information on MS Excel is given, which you need to know when creating tests. The second shows the ability to create an interactive test using standard Excel functions and macros - a set of commands used to automatically perform some operations, which allows you to automate the transition to the next question of the test and return to the beginning of the test for further testing., and the third shows the research part in which this development was applied in the lesson of mathematics.

Purpose of the study: to consider methods in an interactive mode, to study the literature on this topic.

Research objectives:

• teach how to use the basic techniques of working in a spreadsheet environment;
• use logical functions when compiling various mathematical models;
• create simple macros like "Clear", "Result", "Exit", etc.
• Consider the effectiveness of using interactive tests, in contrast to traditional methods knowledge control.

Basic information about MS EXCEL.

An Excel document has the extension "*.xls" and is called a workbook. The workbook consists of sheets. Three are created by default. You can switch between sheets using the tabs (labels) at the bottom of the "Sheet 1" window, etc.

Each sheet is a table. The table consists of columns and rows. Columns in the sheet 256 (2 to the 8th degree),

and lines 65536 (2 to the 16th degree). I propose to calculate the number of cells by ourselves. Columns are denoted by Latin letters

alphabet (in normal mode) from "A" to "Z", then comes "AA-AZ", "BB-BZ", etc. to "IV" (256). Rows are denoted

regular Arabic numerals.

There is a cell at the intersection of a column and a row. Each cell has its own unique (within a given sheet)

an address that is made up of a column letter (in normal mode) and a row number (eg "A1").

Think of a sea battle, chess, or how you find your seat in a movie theater. Cell address (cell reference) is used

in calculations (and not only) in order to "get" the data from this cell and use it in the formula.

Only one of the sheet cells is currently active. A bold line is visible around the active cell.

black frame with a square in the lower right corner (autofill marker). Even if a range of cells is selected,

anyway one of the selected cells will have White color. This does not mean that it is not selected, it means that

that it is active in the selected range - it is into it that the text typed from the keyboard will be entered.

Macros Microsoft Excel are simple, highly adaptable yet powerful tools that allow the user to save time and be more productive.

Therefore, I want to offer one of the test options using macros.

Creating an interactive test in MS EXCEL

Let's create a test - test in mathematics, materials demo version KIM GIA 2013, the number of answers can be set arbitrarily for each question, but at least 4 is better, otherwise the probability of “passing” the test by at least 3 becomes almost 100%.

Open Excel and rename the sheets of the workbook:

Sheet 1 - "Start"

Sheet2 - "Test"

Sheet 3 - "Result"

On the "Start" sheet, select all the cells and set them some background color (CELL FORMAT - VIEW), or make a substrate for the sheet with a picture

Let's color the "Test" and "Result" sheets in the same way.

Let's draw a button on the "Start" sheet - START. More precisely, it will be on a button, but just a drawing made, for example, using autoshapes from the Drawing panel. (In the future, this picture will become an active button, but after we assign a macro to it.

Let's go to the "Test" sheet and create multiple choice questions there

Consider for one question (Question 1):

In cell C3, write the number of the question

In cell D3 we write the question itself

In cell E3, you must specify a list of answer options

To do this, we get up in E3 and go to the DATA - CHECK menu, where we select the LIST and in the SOURCE field we type in the answer options separated by a colon.

Click OK and the list of answers is ready - when you click on cell E3, a button will appear that opens the list of answers and allows you to select one of them:

IF (= cell value; “true”; “false”) - this means that if the correct answer is selected in cell E3, then in cell F4 we will display the word “true”, otherwise we will display “wrong”

Go to cell G3, where we write the formula: =IF(F3="true";1;0)

It is clear that in this cell there will be a value of 1 if the answer is correct and 0 if it is incorrect. (This will be needed on the next sheet to count the number of correct answers).

Similarly, we will create all 10 questions. Finally on this sheet we will draw 2 buttons: clear and result

Let's go to the "RESULT" sheet

Copy from the TEST sheet the columns with the question numbers and the questions themselves (I have them, respectively, in columns C and D.

Write the correct answers in column E. In column F, we will display the answers that are selected by the testee, therefore, for example, in cell F3 there will be a formula F3 = test! E3 (that is, the answers selected on the TEST sheet are displayed here - this is for comparison with the correct answer)

Fill in all other cells in the same way.

Let's draw two buttons: AGAIN (to repeat the test) and EXIT (to exit the test)

In column I, we will make two inscriptions to control the execution of the test: TOTAL and TRUE, TOTAL, ASSESSMENT.

Next, in column J, having messed up TOTAL, we write: 10 (this is the number of test questions), and opposite TRUE - the formula = SUM (test! G3: G11) - that is, units of correct answers from the TEST sheet will be summed up here, in cell K opposite TOTAL we write formula =(K11*100)/10, which will calculate the percentage of the quality of the work performed, and in cell L we will write a formula that will display the score =IF(K9=100;5;IF(K9>70;4;IF(K9>40 ;3;2))).

It remains to create macros and assign them to buttons.

Let's start with the START button on the START sheet.

When you click on this button, a sheet with test questions (TEST) should open, the contents of column E with the correct answers will be cleared and cell E3 will be highlighted so that the button for selecting the first answer is visible.

Go to the menu VIEW - MACRO - START RECORDING. Give the macro a name and OK.

And the macro recording began, i.e. everything we do now will be written in VBA code

After that, open the TEST sheet, select cells E3 - E21 there, press Delete to clear the contents and click on cell E3 to select it.

Macro recorded. Stop recording. Assign this macro to the START button. To do this, right-click on it and select ASSIGN MACRO: In the window that appears, select our macro and OK - the macro is assigned. The button (and this is already a button, not an autoshape) began to act. If the button does not work, then most likely the level

Excel's security stands high.

Then go to EXCEL Options - MACRO - SECURITY and

put low level security. Go to the TEST sheet and there you need to create 2 macros for the CLEAR and RESULT buttons. Create macro CLEAR. We start the macro recording, select the column with the selected answer options and press Delete. Stop recording the macro, then assign it to the clear button.

Go to the RESULT sheet, you must also create 2 macros to return to the beginning of the test (button AGAIN) and to exit the test (button EXIT)

For the AGAIN button in a macro, contains only the action of moving to the START sheet.

For the EXIT button, the macro should go to the START sheet and then make the application exit.

Let's record only the transition to the START sheet, then open the macro and manually add the Application.Quit code - shutdown. Assign this macro to the EXIT button

As a result, the next time the test is run, it will open from the START sheet, which is what we want, and the answer choices from the previous test run will be cleared, regardless of whether we answered YES or NO to the question about saving changes upon exit.

Let's remove the sheet tabs so that you can't immediately go and see the answers, remove the grid, column and row names, and scrollbars. We remove all this by going to the EXCEL OPTIONS- ADDITIONAL menu:

ALL. The test is ready. We start and try. (See disk)

Research part.

Interactive control methods in mathematics lessons.

To substantiate and confirm the theoretical provisions presented in this paper, an experimental study was organized, during which it was supposed to prove the effectiveness of the proposed testing using interactive methods control for grade 9 on the example of the experimental class.

The experiment was carried out on the basis of 9 "C" and 9 "B" classes of the MKOU "Kizlyar Gymnasium No. 1 named after M.V. Lomonosov", and consisted of the following stages: ascertaining, forming and control-diagnostic.

The purpose of the experiment is to optimize the control of schoolchildren's knowledge, to create prerequisites for the implementation creativity means of interactive methods.

Tasks:

1) analyze and assess the level cognitive activity students of the experimental and control groups according to certain criteria;

2) to form the ability to master MS EXCEL

3) develop intellectual abilities, emotional-volitional and moral qualities personality;

Two classes were given a test task

9 "B" - testing in the traditional form.

9 "B" - using an interactive test.

The test results can be expressed in the following table:

Conclusion : the use of interactive tests can significantly reduce the time for testing processing.

CONCLUSION.

Interactive tests can be used at various stages of the lesson (introductory, current, final briefing), at various stages of control (input, current, milestone, final). They attract the attention of students with their variety, brightness, the ability to independently create a mini program for a computer that not only calculates the grade, but will also be used in the classroom, acquiring practical significance for students.

No special software is required to create tests. MS Office package (Excel in particular) is available on every personal computer. This explains the availability of the proposed information.

Creating interactive tests does not require special knowledge and skills. The ease of making tests makes it possible for both experienced and novice users to try their hand.
Creating tests using Microsoft Excel (option 1) (rc.novokuybishevsk.ru)
Creation of a test questionnaire with results processing using MS-Excel (sites.google.com)

Methodological material for a lesson in computer science

on the topic "Creating interactive tests using an electronic processorEXCEL. »

Annotation.

This work is a control and training manual on the topic " Practical use spreadsheet electronic editor EXCEL", namely the creation of interactive tests.

The work can be used in computer science lessons in grades 9-11 of a technical profile, as well as for beginner level users.

Introduction.

Microsoft Excel- program to work with spreadsheets created by a corporation Microsoft for Microsoft Windows, Windows NT and MacOS. It provides economic and statistical calculation capabilities, graphical tools and, with the exception of Excel 2008 under MacOS X, a macro programming language VBA(Visual Basic for Applications). Microsoft Excel is included Microsoft office and today Excel is one of the most popular applications in the world.

Also in Microsoft Excel, you can create interactive tests using standard functions or macros.

Creating interactive tests in MS Excel.

(instruction for exploring the possibilities and use of MS Excel to create interactive tests for high school students)

Development consists of three sections. The first one - basic information on MS Excel - provides only the most basic information on MS Excel that you need to know when creating tests, advanced users can skip this section. The second shows the ability to create an interactive test using standard Excel functions, and the third shows using macros, a set of commands used to automatically perform some operations, which allows you to automate the transition to the next question of the test and return to the beginning of the test.

Interactive tests can be used at various stages of the lesson (introductory, current, final briefing), at various stages of control (input, current, milestone, final). In my practice, students themselves create tests with pleasure. Fill them with their course projects. They attract the attention of students with their diversity, brightness, the ability to independently create a mini-program for a computer that not only calculates the grade, but will also be used in the classroom, acquiring practical significance for students.

No special software is required to create these tests. MS Office package (Excel in particular) is available on every personal computer. This explains the availability of the proposed information.

Creating interactive tests does not require special knowledge and skills. The ease of making tests makes it possible for both experienced and novice users to try their hand.

Basic information on MS Excel

To create a test, you need to know several features of the MS Excel program, which are referenced in this development.

The list of commands that control the work of Excel is located in the main menu (Fig. 1.1) Here you will find the command Insert, Data, Service.

The main menu items contain a drop-down list of commands, which can be opened by clicking the left mouse button on the menu item. This is how you find commands. Examination(menu item Data), Sheet(menu item Insert), Macro(menu item Service).

Each Excel cell has a unique address, consisting of a column name and a row (Fig. 1,2).

The columns of the Excel table are indicated by Latin letters (Fig. 1.3), rows by numbers (Fig. 1.4). Pay attention if you enter formulas from the keyboard.

Formulas are entered in the formula bar (Fig. 1.5), starting with the sign = (equality) .

To create a figure for the test, use the toolbar Drawing ( located at the bottom of the Excel window), or the menu item Insert-Drawing-AutoShapes

Create a test with

standard commands and functions of MS Excel

MS Excel contains a set of standard functions. Functions are predefined formulas that perform calculations on given values ​​in a specified order. The user only needs to specify the function name (for example, SUM, IF) and the function arguments - the addresses of those cells that are subject to processing (addition, verification).

Let's create a test consisting of 5 questions.

For this:

1. In cells B1, B3, B5, B7, B9 we type the text of the questions.

2. We type answers

* In column K we type answers to question No. 1 (cell B1)

* In column L we type the answers to question No. 2 (cell B3)

* In column M - to question No. 3 (cell B5)

* In column N - to question No. 4 (cell B7)

* In column O - to question No. 5 (cell B9)

Arranging cells with answers

# In cell B2 we enter data validation

# Set the cursor to cell B2

# Run the menu item Data-Verification

# On the Parameters tab (Fig. 1)

fill out data type List

and source data - specify a column with answer options

# on tab Message write a message to enter

« Choose an answer!

# Clicking OK

We carry out similar actions with cells B4, B6, B8, B10.

Validation Window

3. Indicate the correct answers

** In cell K5, enter the formula = IF (B2 = K1; 1; 0) - in this case, in cell K1 - the correct answer

** similarly fill in cells L5, M5, N5, O5.

4. In cell P5, enter the formula that calculates the total score = SUM (K5: O5)

5. In cell B11 we enter a formula that determines the assessment of the completed test

=IF(P5=5,5,IF(P5=4,4,IF(P5=3,3,2)))

The test is ready!

PS : It remains to format in a style convenient for you.

Answer options (columns K, L , M , N , O ) it is better to hide (Format-Column-Hide), or choose a white font color.

Creating a test using macros

Macro - a set of commands used to automatically perform certain operations. In our case, the macro is used to automate the transition to the next test question and return to the beginning of the test for further testing.

Let's create a test consisting of 5 questions using macros. Security level should be low (Service-Macro-Security-Low)

For this:

1. Create 7 sheets using the menu item Insert-Sheet.

2. Fill in the sheets with inscriptions:

* On the first sheet there is one figure "Start the test";

* On the last one there are two figures “Your rating” and “Return to the beginning

On the rest - one " question content» and figures with options

answers (how many there will be - depends on you).

3. Now you need to create macros that make your test work.

3.1 Macro that runs the test

* Place the cursor on sheet 1 in cell A1

* Run command Service-Macro-Start Recording

* In the window, set the name of the macro test_start

We click on the figure "Start test", then on the label of the second sheet

We go to the menu

Choose Assign macro

In the window that opens, select test_start

Click OK

To check, you can, after placing the cursor in any cell (let's say A1), click on the figure. As a result, you will find yourself on the second sheet of the book.

3.2 Macro that works with the correct answer

Run the command Service-Macro-Start Recording

Name the macro in the window Sheet_2_correct

(Please note! Spaces are not allowed in the macro name)

Click OK (the window closes and the macro is being recorded)

Click on the figure correct answer", then on cell A1, write the number 1 into it, then on the label of the third sheet

We go to the menu Service-Macro-Stop Recording

Clicking on the shape with the right mouse button

Choose Assign macro

In the window that opens, select Sheet_2_correct

Click OK

3.3 Macro that works with the wrong answer

Place the cursor on sheet 2 in cell A1

Run the command Service-Macro-Start Recording

Name the macro in the window Sheet_2_wrong

(Please note! Spaces in the macro name

not allowed)

Click OK (the window closes and the macro is being recorded)

Click on the figure wrong answer”, then on the label of the third sheet

We go to the menu Service-Macro-Stop Recording

• Clicking on the shape with the wrong right mouse button response

  Choose Assign macro

  In the window that opens, select Sheet_2_wrong

  Click OK

We repeat the last 4 points with the rest of the figures with the wrong answer options

3.5 Macro working with return to the beginning of the test

Place the cursor on sheet 7 in cell A1

Run the command Service-Macro-Start Recording

Name the macro in the window return_to_beginning_of_test

(note! Spaces in the macro name

not allowed)

Click OK (the window closes and the macro is being recorded)

Click on the figure back to the beginning of the test?»,

• then on sheet 6 in cell A1, on the Del key,

  then on sheet 5 in cell A1, on the Del key,

  then on sheet 4 in cell A1, on the Del key,

  then on sheet 3 in cell A1, on the Del key,

  then on sheet 2 in cell A1, on the Del key,

  then on the label of the first sheet

We go to the menu Service-Macro-Stop Recording

Click on the figure back to the beginning of the test?» right

Mouse buttons

Choose Assign macro

In the window that opens, select return_to_beginning_of_test

Click OK

For this:

SUM(Sheet2!A1;Sheet3!A1;Sheet4!A1;Sheet5!A1;Sheet6!A1)

Column names are written in Latin letters!

Now in the cell located next to the “Your score” figure, insert the formula for calculating the score

IF(A1=5,5,IF(A1=4,4, IF(A1=3,3,2)))

3.7 For the convenience of control and the inability of students to change the test, use the command of the menu item Service-Parameters. On the tab View uncheck all the checkboxes on each sheet of the book individually.

The test is ready! It remains to format to your liking!

Algorithm for creating an interactive test.

What are the benefits of this program?

Firstly, it is always "at hand", as it is included in the package. office programs, both my personal PC at home and at school on any PC that is loaded with Windows. So no need to waste your time downloading additional programs to create tests, the time to remove such a program after working with the class. At the same time, no one violates copyrights, since school PCs, if they are loaded with Windows, are licensed for this.

Secondly, working in Excel is easy and simple, a test can be created in just a few minutes, for example, at a break.
Of course, any active PC user can find many arguments against. However, I repeat: in my opinion, Excel tests are simple both at the time of creation and at the time of use.

So, how do you create a quiz where each subsequent question appears after the correct answer to the previous one?
Such tests can be successfully used in developing the skills and abilities of students during the lesson - learning a new topic.
I will describe the algorithm for creating a test, in which each subsequent question appears only after the correct answer to the previous one:

EXCEL MICROSOFT OFFICE  ALL PROGRAMS 

1. Starting the program: START

2. Acquaintance with the main buttons of the program for creating tests (Fig. 1):

3
.Formation of the test - work in the cells (Fig. 2):

 Cell FormattingUse the right mouse button to format the cell (See Figure 3)

This is where your imagination runs wild! Vary as you like: play with color - filling the cells of questions and answers, play with borders! Don't forget about ready-made your test. For example, I color a table field that is not occupied by the test in White background. Then the grid of the Excel table does not distract students when working with the test.

4. In the first line of questions (cell B4) we enter the text of the first question.

5. In the second line (cell B5) we enter a formula with which question No. 2 will appear, provided that the student answers question No. 1 correctly.

6. Formula introduction:
a) press the fk icon
b) a pop-up window will appear (Figure 4)

e) click OK

f
) a pop-up window will appear (Figure 5)

EXPRESSION LOG: enter G4=2, where G4 is the student's answer box, 2 is the number of the correct answer.
Value if true: enter the next question (i.e. right here enter the next question by opening it and closing "").
Value if false: enter "" (i.e. empty quotes).
Those. if the student chooses the answer “4”, then the next question will appear for him, and if he chooses other options, then there will be no further questions.
Similarly, fill in all the lines of questions (Figure 6).

figure 6

The test is ready!

How to handle a test or how to grade?
For the test, select 5 questions, the number of correct answers and will correspond to the assessment. You can set the number of questions in multiples of 5.

List of sources.

1.http://dl.dropbox.com/u/74798925/3820998_tn.jpg

2.http://dl.dropbox.com/u/74798925/cm-31.jpg

3.http://dl.dropbox.com/u/74798925/Excel.jpg

4.http://dl.dropbox.com/u/74798925/i%20(1).jpg

5.http://dl.dropbox.com/u/74798925/i%20(2).jpg

6.http://dl.dropbox.com/u/74798925/i%20(3).jpg

7.http://dl.dropbox.com/u/74798925/i.jpg

8.http://dl.dropbox.com/u/74798925/%D0%91%D0%B5%D0%B7%20%D0%B8%D0%BC%D0%B5%D0%BD%D0%B8 -1.jpg

9. Miklyaev A. "Desk book of the user", M., 1998.

div align="center">

So let's start step by step:

1 step:

As for the previous test, we will choose a subject, a topic, formulate questions and ask 4 possible answers (or more), of which we will choose one correct one.

For example, I will consider 3 questions:

1 question: What programs are Text editors:

• word pad
• Word
• photoshop
• excel

Question 2: Which mushrooms are edible?

• fly agaric
• White
• boletus
• Toadstool

Question 3: Which of these substances are metals?

• Carbon
• Aluminum
• Zinc
• Tin

2 step:

Now let's open MS PowerPoint and create 5 slides (1 title slide, 1 slide for each question and a final slide for the results), select the design of the slides, fonts. Let's take the first slide as an example.

a) On the slide we place

- inscription QUESTION 1
- an inscription with the text of the question

b) go to the menu VIEW - TOOLBARS - CONTROLS,

We take the “flag” (click on it) and place it on the slide (click on the slide) - a switch appears on the slide

- Right-click on the checkbox and select the PROPERTIES section

c) Create 3 more flags and perform the same actions with them

d) Let's create a button. To do this, take it from the same CONTROLS panel and place it on the slide

e) By right-clicking on the button, select PROPERTIES and also change the appearance and text on the button

3 step:

So, we have created one slide. In the same way, we create slides 2 and 3, inserting the appropriate questions and answers, switches and buttons into them.

4 step:

By analogy with the “one of ..” test, we will create the last slide on which all the results will be displayed

a) place on the slide 4 Label elements (inscription) from the panel

CONTROLS

b) Let's create 2 buttons:

- see result
- exit

5 step:

So, the slides are created, the objects are placed on them. Let's proceed to the description of events. For this, the Visual Basic for Application (VBA) language built into Microsoft office programs is used.

Let's start with the first question. We need that when choosing answer options and clicking on the "NEXT" button automatically:

- the number of completed tasks was counted
- the answer was checked, and if it was correct, then one was added to the counter of correct tasks
- the transition to the next slide was carried out (question)

Let's open the first slide. Let's double-click on the "NEXT" button, this will open the Visual Basic editor, in which we will describe the procedures for clicking the button
Below we see the Visual Basic editor window

Let's write the following code:

Z=
L = 0
N=0
If (CheckBox1.Value = True) And (CheckBox2.Value = True) And (CheckBox3.Value = False) And (CheckBox4.Value = False) Then
L=L+1
End if
Z=Z+1
CheckBox1.Value = False
CheckBox2.Value = False
CheckBox3.Value = False
CheckBox4.Value = False
SlideShowWindows(1).View.Next

Code explanation:

Z = 0 - Z- this, as in the previous test, is the counter of completed tasks, i.e. how many tasks are in the test, at the beginning of the test we reset it
L = 0- L - counter of correctly completed tasks, we also assign zero to it
N=0– N is the percentage completion of test items

If (CheckBox1.Value = True) And (CheckBox2.Value = True) And (CheckBox3.Value = False) And (CheckBox4.Value = False) Then
L=L+1
End if– ‘Here it is checked if the correct answers the first and second are selected and the third and fourth are not selected, then the counter of correctly completed tasks is added to one, and if an incorrect answer is selected, then it is not added. If you do not add answers to the code that should not be selected, the test will not work correctly
Z = Z + 1 ‘the number of tasks completed is counted’

CheckBox1.Value = False
CheckBox2.Value = False
CheckBox3.Value = False
CheckBox4.Value = False - This unchecks all checkboxes so that the next time you run the test, there will be no default selected answers.

SlideShowWindows(1).View.Next is the command to go to the next slide

6 step:

Similarly, open slides 2 and 3 and paste the same code for the NEXT buttons (you can just copy the code from the first slide), but remove the lines in the code of these buttons
Z = 0
L = 0
N=0– because the test is already running and there is no need to reset the readings

7 step:

In order for the buttons to work, you need to add a module with a description of variables to the project

For this:

Public L, Z, N As Integer

- close the presentation and save the changes

8 step:

It remains to write the code for the buttons "VIEW RESULT" and "EXIT"

a) First, let's describe the "VIEW RESULT" button:

For this

- go to the last slide
- double-click on the button "VIEW THE RESULT" go to Visual Basic
- write the code:

Label1.Caption = Z
Label2.Caption = L
N = (L / Z) * ​​100
Label3.Caption = N" here
If N >= 95 Then
Label4.Caption = "Excellent"
End if

If N< 95 And N >= 70 Then
Label4.Caption = "Good
End if

If N< 70 And N >= 50 Then
Label4.Caption = "Satisfactory"
End if

If N< 50 Then
Label4.Caption = "Bad"
End if

Code explanation:

Label1.Caption = Z- the number of completed tasks will be displayed here
Label2.Caption = L- the number of correctly completed tasks will be displayed here
N = (L / Z) * ​​100- the percentage of tasks completed is calculated
Label3.Caption = N- "here the percentage of tasks completed is displayed

If N >= 95 Then
Label4.Caption = "Excellent"– If the percentage of completion >= 95 – “Excellent” is displayed
End if

If N< 95 And N >= 70 Then
Label4.Caption = "Good"- If the percentage of completion is from 70 to 95 - "Good" is displayed
End if

If N< 70 And N >= 50 Then
Label4.Caption = "Satisfactory"- If the percentage of completion is from 70 to 50 - "Satisfied" is displayed"
End if

If N< 50 Then
Label4.Caption = "Bad"- If the percentage of completion is below 50 - "Bad" is displayed
End if

b) Now we will describe the EXIT button

Private Sub CommandButton1_Click()
Slide5.Application.Quit
end sub

Exit and save all changes

9 step:

This completes the creation of the test. We launch it (open the presentation) and check
If something does not work, then look and change the security settings in the SERVICE - MACRO - SECURITY menu (maybe macros are automatically disabled, and our test is based on macros)