Analytics and reporting

Hi,

This is a small project I started recently, which, from a report, extracts users who started and finished a quiz attempt from the same IP.

I'm sharing the Google Sheets link so everyone can access it and make contributions for improvements and new ideas.

Google Sheets: https://docs.google.com/spreadsheets/d/1il7CD40xiykMBpUAHMLTLh0EciNSIdcgmRol5W4attw/edit?usp=sharing

To edit the worksheet, you should make a copy and edit it.

Moodle
(1) Access the quiz
(2) Under "Actions menu", click on "Logs" link
(3) Select a specific date
(4) Download as "CSV" file

Google Sheet
(1) Select worksheet "Dados"
(2) Under "File", click on "Import"
(3) Upload the downloaded CSV file
(4) "Import File" dialog box: select "Sustitute actual page" and untick "Convert..."
(5) Click "import data" button
(6) Access "Indício de Fraude" worksheet
(7) Under "Suspicious IP" select IP
(8) "Full Name" will show all users. if any, accessing the same IP selected before

All the best,

Ricardo