Pic. 1

Chat GPT makes a serious threat to teaching online, especially for online exams. However, using solutions presented on this site, one can seriously restrict students' access to such bots. There are two types of tests. The first ones are those which are distributed in Microsoft Notebook  through the Assignment program in Teams. The second ones are multi choice questions tests in Moodle. From the side of Microsoft 365 Education the main defense tool is based on screen recordings with a free software ShareX. Within 12 hours after the exam student submit the full screen recordings though the special Microsoft form. This form includes only one field to upload the file. It is not necessary to collect students' data since they are determined automatically. The size upload limit currently is restricted by 1 GB, which is enough to record 90 minutes with ShareX. In case the limit is exceeded by some reasons, one can use https://handbrake.fr/  to compress the recording up to 50%.

Pic. 3

Getting a List of students who didn't send the Recordings.

I open the corresponding Microsoft Form, see pic. 3.

Pic. 5

The Excel Table

I reorder the records through the right icon in the ID column and obtain the full list of recordings made during a particular test. The names of students who are in the list can now be selected and pasted as a column in another Excel file. The process of automatic selection of those who didn't send the screen recording is described on the page of this site.

Pic. 7

Examination Rules.

By pressing the button on pic. 7, students confirm that they agree with the examination rules stated above the button.

Pic. 9

ShareX recording

The picture above demonstrates a right recording. Notice that the Moodle test is shown in a separate window which is not in the full screen mode. The screen is recorded full and includes the task bar with time and mouse. The window of the Face ID is all the time on. 

To apply for the ChatGPT help, students cannot copy the statement of the problem since this is forbidden. Students may have only ONE session of the test, which implies that they can pass it only on one Notebook. Theoretically students may retype the questions on the second monitor and even use the second mouse on the second screen. However, in this case the typesetting will be captured by the microphone which must be turned on in ShareX before the recording is started. They do not need to type anything since they can make all necessary calculations on the sheet of a paper. Or they can use Math Solver openly under the ShareX recording.

Even Essays can be given without problems. Then students must type everything on the main screen of the test. No typing anywhere else is allowed.

I recommend to create a number of meetings in private channels of a Microsoft Teams team for recording students presence via mobile phones. In this case teachers will have a more detailed information on students behavior during the exam. It is good to show the table of every student via the camera of a mobile phone. The proctoring process in Microsoft 365 Education is described on the following page of my site.

Pic. 11

Welcome to Send Email from Power Apps

The details of the creation of the "Send Email" application can be found in the following video https://youtu.be/SimDjo3WJOQ  . I've added a few improvements. The yellow labels such as "To" activate the Reset("name of the field on the right") function in Power Apps. There are cases when you must send identical or slightly different emails. When I click any yellow label, the contents of the right box of the text input type disappears. I return back to the main screen by clicking onto the left arrow at the top left corner of the screen.

Pic. 13

Welcome to Power Automate

The structure of the flow is shown on pic. 13.

Pic. 15

Welcome to Power Automate

The "Parse JSON" block provides the access to the "link" field with the "HTTPS" link to the screen recording, see the last field on pic. 15.

Pic. 17

The application for Grades can be also shown on the SharePoint site as well as in a tab of the General channel in Teams, see pic. 17. In case screen recordings influence Grades (as it should now be since CahtGPT can solve problems for students) the Home screen for students' results can be placed in the SharePoint above the application for screen recordings for teacher's convenience, see pic. 18. Both screens have search fields but for grades it is not do important since all grades are odered alphabetically exactly as in the Assignments program in Microsoft Teams.

Pic. 19

The recording can be played back with the doubled speed. To activate this regime one can just click the vertical ellipsis at the bottom right conner of the screen, see pic. 19.

Pic. 21

Welcome to ChatGPT

The measures described on this page block access to ChatGPT during quizzes and other tests. On the Moodle level students have time restrictions on each question and copying in the test window is blocked. The second monitor cannot be used, and the student's face is recorded since it is shown in the Face ID part. Students must record the full screen of their PC including the tools bar with the time. This is duplicated in the Moodle window twice with the down clock timers for each question and the whole exam. Therefore, it is actually impossible to do any editing of the screen recordings. The application created for screen recordings allows teachers easily find required recordings and open them for investigation. I have already run over fifty tests and all results are distributed according to the normal law and follow the current successes of students exactly. Homeworks are useless because of ChatGPT. They also were never very useful since many students just copied them. ChatGPT and the system shown on this page open new possibilities. Since students record their sessions with ShareX, they have the text of problems they were given by an automate during tests. Therefore, they may try solving them step by step with ChatGPT. Although this bot is not reliable, still it may give students some ideas for possible solutions. I usually warn students that they must ask for step-by-step solutions to learn how to solve problems of different type. In the Final I add 50% of problems which were not distributed before. 

Pic. 23

Welcome to Search Boxes

Pic. 25

A Sorting and Filtering Formula

I select “Items” in the left field and type

SortByColumns(Filter('Screen Recordings Calculus 2',StartsWith(Name,txtName.Text)),"Title",SortOrder.Descending)

in the right part of the command line. Here “SortByColumns()” is a sorting command, 'Screen Recordings Calculus 2’ is the name of the SharePoint list used for data connection.

StartsWith(Name,txtName.Text) is another filter command. Here the “Name” is the name of the column in the SharePoint list where students Display Names are collected. The parameter “txtName.Text” makes a reference to the search field (I renamed it on pic. 24). The “Title” parameter indicates that sorting will be made through the “Title” column of the SharePoint list, whereas “SortOrder.Descending” says that sorting goes from larger to smaller ID numbers which are collected in the “Title” column of the SharePoint list.

Pic. 27

Screen Recording App in SharePoint

For the sake of convenience, I insert this application after the application for Grade Books, see pic. 27. The result of a concrete search is shown on pic. 28. Then I click on the Gallery field which includes the required record and open it from the Detailed form see pic. 29.

Pic. 29

Pic. 30

Format Multi-text Columns

I start by adding two extra multi-line text columns to the list shown on pic. 12. I format these two columns following the recommendations of Manuel T. Gomes which can be found here. 

The column “Urllink” is the seventh column in the list. To open it for formatting after its creation as a multiple-line column, I expand the right checkmark and click “Column settings” followed by the click onto “Format this column” line. The default JSON code shown on the right of pic. 30 must be expended. I put the comma after the double quote symbol (to start a new JSON object) and typeset from the new line the code shown on pic. 30. Namely, I type
,
“elmType”: “a”,
“txtContent”: “Link”,
“attributes”: {
“target”: “_blank”,
“href”: “=@currentField”
}

I repeat the same with the second new multi-line column “URLDescription.” The code is shown on pic.31 

Pic. 32

A Modification of the first Flow

After that I create the second list at the same location using this one as a pattern. Each list will be filled with its own flow. The first flow shown on pic. 13 has small modifications at the last step shown on pic. 32. This time, I leave blank field 1 and instead insert the dynamical icon “link” in both fields 2 and 3. These actions on the one hand prevent the first flow from failure if the real length of the link exceeds 255 characters, and on the other hand sends the link to new fields of the first SharePoint list.

Pic. 34

The Second Flow

One may include the action “Apply to each” but it will be included automatically with the correct icon “value” as soon as one starts filling the fields of the “Create item” action with dynamical icons. One can fill the “Records” field with the dynamical icon “Link to item,” which is an URL reference to the created row in the first SharePoint list, but it is better to use an f_x function here. Although the link to item action creates a shorter URL link, the “concat” function creates much shorter one.

The code in window 2 of pic. 34 looks as follows: concat('https://satbayevuniversity.sharepoint.com/sites/Algebra1/Lists/Algebra1Rec/DispForm.aspx?ID=',items('Apply_to_each')['Id'])

The part between the first quote mark and the question mark can be easily found from the first SharePoint list. If it is empty then just create one item manually, save it and find its link as it is shown on pic. 35. Select the item. Then click onto “Copy link,” put the mouse cursor in window 2 and with the right button copy the link. You will get something like this:

https://satbayevuniversity.sharepoint.com/sites/Algebra1/Lists/Algebra1Rec/DispForm.aspx?ID=1&e=yPshtN

The part between the quote marks must be filled with the code starting with “https” and ending with “ID=”. The code ‘Apply_to_each’ corresponds to the name of the action “Apply to each.” If by some reasons it is “Apply to each 2”, then the code will be ‘Apply_to_each_2’. 

Pic. 36

Welcome to the Application

To see how this system works in practice, . I submit a new recording through the Microsoft Form. In a few seconds a new record appears in the left Gallery of the application shown on pic. 36. Its number is 18 in the details view on the right. I can open links in either “URLlink” or “URLDescriprion” only by a copy/paste action. However, field “Records” is colored in blue indicating that it is a URL link. If I click on it with the mouse, then the system opens the window shown on pic. 37.

Pic. 38

Welcome to the Application

Add a description here.