{"id":808,"date":"2019-01-03T10:00:49","date_gmt":"2019-01-03T09:00:49","guid":{"rendered":"http:\/\/domagoj-sajter.from.hr\/?p=808"},"modified":"2019-03-07T18:17:21","modified_gmt":"2019-03-07T17:17:21","slug":"suvremen-nacin-pracenja-nazocnosti-studenata-na-nastavi","status":"publish","type":"post","link":"http:\/\/domagoj-sajter.from.hr\/?p=808","title":{"rendered":"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2."},"content":{"rendered":"<p><!--more--><\/p>\n<p><del><span style=\"text-decoration: underline\">Proces ima sljede\u0107e faze:<\/span><\/del><br \/>\n<del> <strong>1. kreiranje upitnika i priprema baze podataka<\/strong> (radi se samo prvi put),<\/del><br \/>\n<del> <strong>2. instalacija i priprema aplikacije na telefon<\/strong> (radi se samo prvi put),<\/del><br \/>\n<del> <strong>3. o\u010ditavanje kodova studenata<\/strong> (prije ili na kraju svakog predavanja),<\/del><br \/>\n<del> <strong>4. prebacivanje u\u010ditanih kodova na web<\/strong> (mogu\u0107e je odmah za vrijeme o\u010ditavanja koda, ili na kraju predavanja, \u0161to \u0107u opisati).<\/del><\/p>\n<p>&nbsp;<\/p>\n<h1><del>1. Kreiranje upitnika i priprema baze podataka<\/del><\/h1>\n<p><del>Prvo preuzmite listu studenata koji poha\u0111aju va\u0161 kolegij kojega \u017eelite pratiti. To mo\u017eete napraviti tako da iz ISVU &#8211; Nastavni\u010dkog portala preuzmete popis studenata u Excelu. Trebaju nam prezimena, imena i JMBAG brojevi.<\/del><\/p>\n<p><del>Otvorite Chrome browser (ako ga nemate instalirajte ga <a href=\"https:\/\/support.google.com\/chrome\/answer\/95346?hl=en\" target=\"_blank\">besplatno<\/a>, Google aplikacije bolje rade u njemu nego u Firefoxu ili drugdje), ulogirajte se u Google (ako imate Gmail onda ve\u0107 imate ra\u010dun, ako nemate napravite ga), i u Google Driveu napravite novi folder pod nazivom npr. <em>Evidencije_nazocnosti.<br \/>\n<\/em>U tom folderu napravite novi Form (obrazac upitnika) pod nazivom npr. <strong>Kolegij201X <\/strong>koji ima tri obvezna pitanja tipa &#8220;<em>short answer<\/em>&#8220;: Prezime, Ime, i JMBAG. Evo primjera:<\/del><br \/>\n<del> <a href=\"https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/viewform\" target=\"_blank\">https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/viewform<\/a><\/del><br \/>\n<del> U izborniku tog obrasca odaberite opciju &#8220;<strong><em>Get pre-filled link<\/em><\/strong>&#8220;; otvorit \u0107e vam se novi prozor s obrascem. Unijet \u0107emo jedno izmi\u0161ljeno ime za po\u010detak; unesite pod prezime Anti\u0107, pod ime Ante, a za JMBAG 123456789 i kliknite <strong><em>Submit<\/em><\/strong>.<\/del><br \/>\n<del> Kreirat \u0107e se link u kojemu je unaprijed ispunjen obrazac; onaj tko klikne na taj link otvorit \u0107e mu se obrazac s unaprijed popunjenim mjestima. Probajte:<\/del><br \/>\n<del> <a href=\"https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/viewform?entry.891649=Anti%C4%87&amp;entry.1292569967=Ante&amp;entry.778554417=123456789\" target=\"_blank\">https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/viewform?entry.891649=Anti%C4%87&amp;entry.1292569967=Ante&amp;entry.778554417=123456789<\/a><\/del><\/p>\n<p><del>No, za unos u bazu podataka jo\u0161 uvijek je potrebno kliknuti <em>Submit<\/em>. Idemo i taj dio ugraditi u link, tako da se onome tko klikne na link automatski &#8220;usisaju&#8221; podaci u bazu, a da se&nbsp; pritom ne mora ni\u0161ta dodatno \u010diniti.<\/del><\/p>\n<p><del>U linku s pred-upisanim podacima:<\/del><br \/>\n<del> &#8211; zamijenimo u sredini linka <em><strong>viewform?<\/strong><\/em> sa <em><strong>formResponse?ifq&amp;<\/strong><\/em><\/del><br \/>\n<del> &#8211; i dodajmo na kraj linka&nbsp;<em><strong>&amp;submit=Submit<\/strong><\/em>.<\/del><br \/>\n<del> Tako \u0107emo od ovoga linka<\/del><br \/>\n<del> <span style=\"color: #000080\">https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/<strong>viewform?<\/strong>entry.891649=Anti%C4%87&amp;entry.1292569967=Ante&amp;entry.778554417=123456789<\/span><\/del><br \/>\n<del> dobiti ovaj link:<\/del><br \/>\n<del> <span style=\"color: #ff0000\">https:\/\/docs.google.com\/forms\/d\/1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88\/<strong>formResponse?ifq&amp;<\/strong>entry.891649=Anti%C4%87&amp;entry.1292569967=Ante&amp;entry.778554417=123456789<strong>&amp;submit=Submit<\/strong><\/span><\/del><\/p>\n<p><del>&#8220;Crveni&#8221; link u sebi sadr\u017ei sve \u0161to je potrebno da se klikom na njega podaci automatski unesu u bazu podataka.<\/del><\/p>\n<p><del>Izdvojimo sada iz crvenoga linka stati\u010dne elemente, i za svakoga studenta napravimo individualni, personalizirani link. Klju\u010dni stati\u010dni elementi linka su:<\/del><br \/>\n<del> <strong>a) identifikacijska oznaka Forma<\/strong>, ovdje je to:<\/del><br \/>\n<del> <em>1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88<\/em><\/del><br \/>\n<del> <strong>b) identifikacijske oznake pitanja<\/strong>, i to:<\/del><br \/>\n<del> <span style=\"text-decoration: underline\">za prezime<\/span>: <em>entry.891649<\/em><\/del><br \/>\n<del> <span style=\"text-decoration: underline\">za ime<\/span>: <em>entry.1292569967<\/em><\/del><br \/>\n<del> <span style=\"text-decoration: underline\">za JMBAG<\/span>: <em>entry.778554417.<br \/>\n<\/em>Vi \u0107ete, naravno, imati svoje ID oznake, a ne gore navedene koje samo slu\u017ee kao primjer.<\/del><\/p>\n<p><del>Kreirajmo sada u Google Driveu u folderu <em>Evidencije_nazocnosti<\/em> novi Google Sheet pod imenom <strong>QR_generator<\/strong> u kojemu \u0107emo generirati QR kodove za svakoga studenta.<\/del><br \/>\n<del> Napravimo zaglavni redak u kojemu su naslovi stupaca:<\/del><br \/>\n<del> Redni broj, Prezime, Ime, JMBAG, FORM_ID, dugi link, skra\u0107eni link, QR kod.<\/del><br \/>\n<del> Primjer je ovdje:<\/del><br \/>\n<del> <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1JFhgxt9QM8ObE4zhhWUCg_GZScAjhrDZovuhFSCrwLU\/edit?usp=sharing\" target=\"_blank\">https:\/\/docs.google.com\/spreadsheets\/d\/1JFhgxt9QM8ObE4zhhWUCg_GZScAjhrDZovuhFSCrwLU\/edit?usp=sharing<\/a><\/del><br \/>\n<del> U stupce A\/B\/C\/D kopirajmo podatke o studentima iz ISVU-a (redni broj, prezime, ime, JMBAG).<\/del><br \/>\n<del> U E2 kopirajmo Form ID (ovdje je to <em>1RcDlQ3zEWscgBH0Ee694WtnGLXVtHlqH-wNN5BAtW88<\/em>).<\/del><br \/>\n<del> U F2 do H2 kopirajmo ID za svako pitanje (<em>entry.xxxxx&#8230;<\/em>).<\/del><br \/>\n<del> U I2 upi\u0161imo formulu:<\/del><br \/>\n<del> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<span class=\" default-formula-text-color\" dir=\"auto\">CONCATENATE<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" string \" dir=\"auto\">&#8220;https:\/\/docs.google.com\/forms\/d\/&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">E2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;\/formResponse?fq&amp;&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">F2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;=&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">B2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;&amp;&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">G2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;=&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">C2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;&amp;&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">H2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;=&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">D2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;&amp;submit=Submit&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/span><\/strong><\/del><\/p>\n<p><del>U stupce E do H za svakoga studenta kopiramo jedan te isti k\u00f4d. Automatsko popunjavanje mo\u017eete napraviti dvoklikom na donji desni kut \u0107elije.<\/del><br \/>\n<del> Obilje\u017eimo \u0107eliju <strong>I2<\/strong>, dvokliknemo na donji desni kut, i automatski popunimo retke do kraja tablice. Sada svaki student ima svoj link, koliko god da studenata imate.<\/del><\/p>\n<p><del>Svaki student ima svoj specifi\u010dan link, no kao \u0161to vidite taj link je poprili\u010dno duga\u010dak, pa kad se treba dekodirati treba ne\u0161to vi\u0161e vremena, a tako\u0111er i kada se izra\u0111uje link treba vi\u0161e prostora jer zauzima vi\u0161e mjesta (prostorno). Zato preporu\u010dujem skra\u0107ivanje linkova.<\/del><\/p>\n<p><del>Prvo u Formu <em>Kolegij201X<\/em> prestanite dopu\u0161tati unose u bazu. Pod <em>Responses<\/em> odaberite <em>Not accepting responses<\/em> (zato \u0161to svako skra\u0107enje linka testira link, tj. &#8220;klika&#8221; na njega, a \u010dim testira link to stvara unos u na\u0161u bazu podataka, a to zasad ne \u017eelimo).<\/del><br \/>\n<del> Iz QR_generatora kopirajte sve duge linkove iz stupca <strong>I<\/strong> i zalijepite ih na stranici<\/del><br \/>\n<del> <a href=\"http:\/\/urlshortener.kwebpia.net\/\" target=\"_blank\">http:\/\/urlshortener.kwebpia.net\/<\/a><\/del><br \/>\n<del> u prozor pod <em>Long URLs (input)<\/em>, skratite ih (<em>create short link<\/em>), i preuzimite ih skra\u0107ene (<em>short URLs<\/em>). Kopirajte skra\u0107ene linkove u stupac J.<\/del><\/p>\n<p><del>U stupcu K na\u010dinit \u0107emo QR kodove. U K1 upi\u0161ite formulu:<\/del><br \/>\n<del> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">image<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" string \" dir=\"auto\">&#8220;https:\/\/chart.googleapis.com\/chart?chs=150&#215;150&amp;cht=qr&amp;chl=&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span dir=\"auto\">J2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/del><br \/>\n<del> Dvoklikom na donji desni kut \u0107elije K1 popunite cijeli stupac K QR k\u00f4dovima. Pove\u0107ajte visinu svih stupaca tako da obilje\u017eite cijeli <em>sheet<\/em> klikom na podru\u010dje u gornjem lijevom kutu tablice (na kri\u017eanju oznaka redova i stupaca), i na razme\u0111i bilo koja dva retka povu\u010dete grani\u010dnik; video pomo\u0107: <a href=\"https:\/\/youtu.be\/bNGnKm93j6M?t=20s\" target=\"_blank\">https:\/\/youtu.be\/bNGnKm93j6M?t=20s<\/a>. Tako \u0107e se vizualno pove\u0107ati i QR kodovi.<\/del><br \/>\n<del> Dodajmo i imena studenata kraj kodova, u \u0107eliju L2 pi\u0161emo formulu:<\/del><br \/>\n<del> <strong><bdo dir=\"ltr\"><span class=\"formula-content\"><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span dir=\"auto\">B2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span class=\" string \" dir=\"auto\">&#8220;, &#8220;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span dir=\"auto\">C2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span class=\" string \" dir=\"auto\">&#8220;, &#8220;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span dir=\"auto\">D2<\/span><\/span><\/bdo><\/strong><\/del><br \/>\n<del> i dvoklikom povu\u010demo do kraja popisa.<\/del><br \/>\n<del> Ozna\u010dimo stupce K i L i odaberimo <em>File &gt; Print &gt; Print selection<\/em>. Na taj na\u010din isprintajte kodove, izre\u017eite i podijelite studentima. Evo primjera: <a href=\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/QR_generator-Sheet1.pdf\" rel=\"\">QR_generator &#8211; Sheet (PDF)<\/a><\/del><\/p>\n<p><del>Sad u formu <em>Kolegij201X<\/em> definirajmo tablicu u koju \u0107e se pohranjivati o\u010ditani podaci. U <em>Kolegij201X<\/em> u izborniku <em>Responses<\/em> odaberite destinaciju za pohranu podataka. Odaberimo novi <em>spreadsheet<\/em> <strong>Kolegij201X (Responses).<\/strong><\/del><br \/>\n<del> Otvorimo sad taj <em>spreadsheet<\/em> i u njemu dodajmo novi radni list pod nazivom <strong>Izvjestaj<\/strong> (<em>Insert<\/em> &gt; <em>new sheet<\/em>).<\/del><br \/>\n<del> U taj novi radni list kopirajmo prezimena, imena i JMBAG podatke iz <em>QR_generator<\/em> dokumenta, odnosno stupce A do D.<\/del><br \/>\n<del> Dodajmo u stupcu E broja\u010d nazo\u010dnosti, koji \u0107e pobrojati koliko je koji student puta bio prisutan na nastavi, odnosno koliko je puta njegov QR k\u00f4d bio o\u010ditan. U \u0107eliju E2 pi\u0161emo:<\/del><br \/>\n<del> <bdo dir=\"ltr\"><span class=\"formula-content\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">COUNTIF<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">&#8216;Form responses 1&#8217;!D:D<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">D2<\/span><\/strong><span class=\" default-formula-text-color\" dir=\"auto\"><strong>)<\/strong><br \/>\nDvoklikom na donji desni kut povu\u010demo navedenu formulu do kraja popisa. Tablica izgleda ovako (gledajte radni list <em>Izvjestaj<\/em>):<\/span><\/span><\/bdo><\/del><br \/>\n<del> <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/edit?usp=sharing\" target=\"_blank\">https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/edit?usp=sharing<\/a><\/del><\/p>\n<p><del>Dodatno, tu tablicu mo\u017eemo objaviti i studentima na webu. U izborniku <em>File<\/em> odaberemo <em>Publish to web<\/em>, odaberemo samo radni list Izvejstaj u kojemu je broja\u010d, i dobijemo link kojega mo\u017eemo dati studentima, odnosno objaviti na webu:<\/del><br \/>\n<del> <span style=\"color: #800080\"><a style=\"color: #800080\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/pubhtml?gid=1599268869&amp;single=true\" target=\"_blank\">https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/pubhtml?gid=1599268869&amp;single=true<\/a><\/span><\/del><\/p>\n<p><del>Uo\u010dite da svaki klik na skra\u0107eni link stvara novi individualni unos u bazu podataka. Sad \u0107emo link umjesto klikanjem otvarati o\u010ditanjem QR k\u00f4da.<\/del><\/p>\n<p><del>Jo\u0161 samo instalirajte <strong>Linkclump<\/strong> dodatak za Chrome, trebat \u0107e nam kasnije:<\/del><br \/>\n<del> <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/linkclump\/lfpjkncokllnfokkgpkobnkbkmelfefj\" target=\"_blank\">https:\/\/chrome.google.com\/webstore\/detail\/linkclump\/lfpjkncokllnfokkgpkobnkbkmelfefj<\/a><\/del><\/p>\n<p><del>Ovim je 90% posla zavr\u0161eno. \ud83d\ude42<\/del><\/p>\n<p>&nbsp;<\/p>\n<h1><del>2. Instalacija i priprema aplikacije na telefon<\/del><\/h1>\n<p><del>Preporu\u010dujem aplikaciju <strong>QR Droid Private<\/strong>:<\/del><br \/>\n<del> <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=la.droid.qr.priva\" target=\"_blank\">https:\/\/play.google.com\/store\/apps\/details?id=la.droid.qr.priva<\/a><\/del><br \/>\n<del> zbog toga \u0161to:<\/del><br \/>\n<del> &#8211; ima mogu\u0107nost uzastopnog skeniranja niza k\u00f4dova (batch scan),<\/del><br \/>\n<del> &#8211; sinkronizira o\u010ditanja s va\u0161im Google Drive ra\u010dunom,<\/del><br \/>\n<del> &#8211; mo\u017eete koristiti i prednju i stra\u017enju kameru (prednja je za samoo\u010ditanje studenta, a stra\u017enja ako \u017eelite sami obi\u0107i dvoranu i o\u010ditati k\u00f4dove studenta)<\/del><br \/>\n<del> &#8211; dva ili vi\u0161e puta u\u010ditan k\u00f4d samo jednom ostaje u memoriji.<\/del><\/p>\n<p><del>Instalirajte aplikaciju, u <em>Settings<\/em> odaberite sinkronizaciju s Google Drive ra\u010dunom, a u <em>Advanced Settings<\/em> stavite kva\u010dicu kod <em>Batch Scan<\/em>.<\/del><\/p>\n<p><del>Gotovo.<\/del><\/p>\n<p>&nbsp;<\/p>\n<h1><del>3. O\u010ditavanje kodova studenata<\/del><\/h1>\n<p><del>Za o\u010ditanje k\u00f4da mobitel ne mora biti spojen na internet.<\/del><br \/>\n<del> Na po\u010detku ili kraju predavanja, kako vas je volja, pokrenite QR Droid aplikaciju, o\u010ditajte QR k\u00f4d svakoga studenta.<\/del><br \/>\n<del> Alternativno, postavite mobitel kraj sebe, prebacite na prednju kameru, i pozovite studente da svatko sam o\u010dita svoj k\u00f4d dok vi pripremate po\u010detak predavanja, ili na izlasku iz dvorane.<\/del><br \/>\n<del> Tako\u0111er, student ne mora uvijek nositi svoj k\u00f4d na kartici na kojoj ste mu ga predali. To je ujedno odgovor na pitanje studenta &#8220;\u0161to ako izgubim k\u00f4d&#8221;. Neka ga fotografira i dr\u017ei fotku u mobitelu. A ako izgubi i mobitel onda mu ponovno isprintajte k\u00f4d. Student, dakle, mo\u017ee fotografirati svoj k\u00f4d svojim mobitelom, otvoriti fotku k\u00f4da i prilikom skeniranja staviti ekran svog mobitela na kojemu je fotka k\u00f4da.<\/del><br \/>\n<del> O\u010ditanje traje do najvi\u0161e tri sekunde, \u0161to je prihvatljivo vrijeme i za ve\u0107e grupe.<\/del><br \/>\n<del> Kad su k\u00f4dovi svih studenata o\u010ditani samo zatvorite aplikaciju.<\/del><\/p>\n<p>&nbsp;<\/p>\n<h1><del>4. Prebacivanje u\u010ditanih k\u00f4dova na web, u bazu<\/del><\/h1>\n<p><del>Na kraju predavanja prebacite u\u010ditane k\u00f4dove u Google Sheet.<\/del><\/p>\n<p><del>Kako ste vidjeli, k\u00f4d je link na specifi\u010dan unos u bazu podataka. O\u010ditanje k\u00f4da automatski stvara unos u bazu, i stvar je mogu\u0107e i tako poslo\u017eiti da unosi ulaze u bazu u realnom vremenu. Ja to nisam tako rije\u0161io, a evo i za\u0161to.<\/del><\/p>\n<p><del>Dakle, svako o\u010ditanje QR k\u00f4da je zapravo unos u bazu podataka, no ako ostavimo Form otvoren (<em>Accepting responses<\/em>) student mo\u017ee i sam o\u010ditati svoj k\u00f4d. Nitko mu ne brani da on i sam instalira neku aplikaciju za o\u010ditanje QR k\u00f4da (ima ih koliko ho\u0107ete), i ako se ovaj dio korektno ne napravi mogu se dogoditi manipulacije; npr. student mo\u017ee u vrijeme po\u010detka predavanja sam sebi o\u010ditati k\u00f4d od ku\u0107e i tako unijeti upis u bazu podataka, odnosno <em>fingirati<\/em> nazo\u010dnost na nastavi.<\/del><\/p>\n<p><del>Kad u\u0111ete &#8220;u \u0161tos&#8221; procedura prebacivanja zapisa sa mobitela na web gotova je za dvije minute, a sastoji se od sljede\u0107eg:<\/del><\/p>\n<p><del><strong>1.<\/strong> spojite svoj mobitel na web, otvorite QR Droid i u njemu <em>History<\/em>. Ondje su pohranjeni svi u\u010ditani k\u00f4dovi. Izvezite (<em>export<\/em>) povijest &#8211; ondje gdje je zaokru\u017eeno crveno polje na donjoj slici, tj. izvezite u\u010ditane k\u00f4dove u svoj Google Drive.<\/del><br \/>\n<del> Zapisi su u tzv. CSV obliku kojega Google Sheets (i Excel) lako \u010ditaju. Kod QR Droida odli\u010dna je stvar \u0161to ako neki k\u00f4d slu\u010dajno bude dvaput o\u010ditan, samo jednom ostaje u <em>History<\/em>, tako da ako student slu\u010dajno dvaput o\u010dita svoj k\u00f4d stvorit \u0107e se samo jedan unos u bazu podataka.<\/del><br \/>\n<del> Preporu\u010dujem da otvorite novi podfolder u folderu <em>Evidencije_nazocnosti<\/em> samo za primanje CSV zapisa sa QR Droida.<\/del><br \/>\n<del> <a href=\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png\" rel=\"attachment wp-att-825\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-825\" src=\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png\" alt=\"QR_Droid_Screenshot\" width=\"491\" height=\"821\" srcset=\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png 491w, http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38-179x300.png 179w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/a><strong>2.<\/strong> Otvorite Chrome browser i u njemu Google Drive. Desnim klikom na CSV dokument kojega ste prebacili s mobitela u meniju izaberite <em>Open with<\/em> &gt; <em>Google Sheets<\/em>. Otvorite, dakle taj Google Sheet i objavite ga; <em>File<\/em> &gt; <em>Publish to the web<\/em>.<\/del><br \/>\n<del> Google \u0107e vam stvoriti link; kopirajte ga.<\/del><\/p>\n<p><del><strong>3. <\/strong>Otvorite <em>form&nbsp;Kolegij201X<\/em> i dopustite unos podataka u bazu (<em>Accept responses<\/em>).<\/del><\/p>\n<p><del><strong>4.<\/strong> Link kojega ste malo\u010das kopirali zalijepite u Chrome i otvorite ga; to je popis linkova, tj. popis o\u010ditanih k\u00f4dova. Kada desnim klikom obuhvatite linkove dodatak <em>LinkClump<\/em> \u0107e ih otvoriti sve odjednom (video pomo\u0107: <a href=\"https:\/\/youtu.be\/JHsDPRpV5xw?t=50s\" target=\"_blank\">https:\/\/youtu.be\/JHsDPRpV5xw?t=50s<\/a>).<\/del><br \/>\n<del> Ako imate stotinu studenata otvorit \u0107e stotinu novih kartica, a ako va\u0161e ra\u010dunalo to ne mo\u017ee podnijeti razdvojite otvaranje linkova u vi\u0161e podgrupa.<\/del><\/p>\n<p><del><strong>5.<\/strong> Kada su se svi linkovi u\u010ditali u&nbsp;<em>formu Kolegij201X<\/em> zatvorite unos podataka u bazu (<em>Accept responses<\/em> &gt; off).<\/del><\/p>\n<p><del><strong>6.<\/strong> U mobitelu u aplikaciji QR droid obri\u0161ite povijest (History).<\/del><\/p>\n<p><del>7. Gotovo.<\/del><\/p>\n<p><del>Svi unosi se nalaze u sheetu <em>Kolegij201X (Responses)<\/em>, a ondje se ve\u0107 nalazi i radni list Izvjestaj kojega smo ve\u0107 napravili, a u kojemu je &#8211; izvje\u0161taj. \ud83d\ude42<\/del><br \/>\n<del> Studenti bazu vide na &#8220;ljubi\u010dastoj&#8221; adresi koju smo tako\u0111er ve\u0107 objavili:<\/del><br \/>\n<del> <span style=\"color: #800080\"><a style=\"color: #800080\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/pubhtml?gid=1599268869&amp;single=true\" target=\"_blank\">https:\/\/docs.google.com\/spreadsheets\/d\/1Jm9PQgNDyy8ZdaX9O-LWgbv10rU5BmvlfdmoBy9wwds\/pubhtml?gid=1599268869&amp;single=true<\/a><\/span><\/del><\/p>\n<p><del>I to je to!<\/del><\/p>\n<p><del>Mislim da su prednosti o\u010dite:<\/del><br \/>\n<del> 1. razvidnost (transparentnost) sustava,<\/del><br \/>\n<del> 2. online dostupnost baze podataka,<\/del><br \/>\n<del> 3. brzina,<\/del><br \/>\n<del> 4. mogu\u0107nost kreiranja izvje\u0161taja o nazo\u010dnosti po volji (kako tko \u017eeli),<\/del><br \/>\n<del> 5. cijena.<\/del><\/p>\n<p><del>Ako se odlu\u010dite koristiti ovaj sustav molim da mi se javite na mail <em>domagoj to\u010dka sajter et d\u017eimejl to\u010dka kom<\/em> da \u010dujem kako vam ide i imate li kakvih pote\u0161ko\u0107a.<\/del><br \/>\n<del> Sretno!<\/del><\/p>\n<p>4. 4. 2016.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center\"><span style=\"color: #ff0000\"><strong>***<\/strong><\/span><\/p>\n<p style=\"text-align: center\"><span style=\"color: #ff0000\"><strong>v.2. update, 3. 1. 2019.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"text-align: center\"><span style=\"color: #ff0000\"><strong>***<\/strong><\/span><\/p>\n<p style=\"text-align: center\">&nbsp;<\/p>\n<p>Sve ovo gore je ok, ali ima dosta koraka i ima nekog posla.<br \/>\nImam bolje i jednostavnije rje\u0161enje. Tako\u0111er se sastoji u tome da se o\u010ditava QR kod, ali se izbacuje nekoliko dosadnih me\u0111u-koraka.<\/p>\n<ol>\n<li>Pripremiti Excel s imenima studenata i JMBAG-ima.<\/li>\n<li>Uploadati ga na <a href=\"https:\/\/posguys.com\/BarcodeBulk\/Index\" target=\"_blank\">https:\/\/posguys.com\/BarcodeBulk\/Index<\/a>, i ondje izraditi kodove (QR kod \u0107e biti broj &#8211; JMBAG).<\/li>\n<li>Isprintati, izrezati, podijeliti kodove studentima.<\/li>\n<li>Instalirati QR droid applikaciju. U <em>Advanced Settings<\/em> stavite kva\u010dicu kod <em>Batch Scan<\/em>.<\/li>\n<li>Prije nastave pripremiti smartphone: to zna\u010di otvoriti QR droid i prebaciti ga na prednju kameru. Studenti sami o\u010ditavaju svoje kodove.<\/li>\n<li>Na kraju nastave eksportirati povijest kako je gore opisano. Spojite svoj mobitel na web, otvorite QR Droid i u njemu <em>History<\/em>. Ondje su pohranjeni svi u\u010ditani k\u00f4dovi. Izvezite (<em>export<\/em>) povijest &#8211; ondje gdje je zaokru\u017eeno crveno polje na donjoj slici, tj. izvezite u\u010ditane k\u00f4dove u Google Drive ili Onedrive ili gdjegod. Zapisi su u tzv. CSV obliku kojega Google Sheets (i Excel) lako \u010ditaju.<\/li>\n<li>U csv-u kojeg ste izvezli imate sve: svaki zapis ima svoj datum i vrijeme o\u010ditanja, i JMBAG. Njih obradite u Google Sheets (ili Excelu) i imate bazu podataka &#8211; dolazaka na nastavu. S power query u Excelu obradite sve u par koraka i gotovo.<\/li>\n<li>That&#8217;s all, folks!<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":171,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[1],"tags":[1292],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2. - Domagoj Sajter<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/domagoj-sajter.from.hr\/?p=808\" \/>\n<meta property=\"og:locale\" content=\"hr_HR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2. - Domagoj Sajter\" \/>\n<meta property=\"og:url\" content=\"http:\/\/domagoj-sajter.from.hr\/?p=808\" \/>\n<meta property=\"og:site_name\" content=\"Domagoj Sajter\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/financije.1\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-03T09:00:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-07T17:17:21+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Napisao\/la\" \/>\n\t<meta name=\"twitter:data1\" content=\"Domagoj Sajter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Procijenjeno vrijeme \u010ditanja\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/domagoj-sajter.from.hr\/#website\",\"url\":\"https:\/\/domagoj-sajter.from.hr\/\",\"name\":\"Domagoj Sajter\",\"description\":\"osobne stranice\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/domagoj-sajter.from.hr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"hr\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/domagoj-sajter.from.hr\/?p=808#primaryimage\",\"inLanguage\":\"hr\",\"url\":\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png\",\"contentUrl\":\"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/domagoj-sajter.from.hr\/?p=808#webpage\",\"url\":\"http:\/\/domagoj-sajter.from.hr\/?p=808\",\"name\":\"Suvremen na\\u010din pra\\u0107enja nazo\\u010dnosti studenata na nastavi v.2. - Domagoj Sajter\",\"isPartOf\":{\"@id\":\"https:\/\/domagoj-sajter.from.hr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/domagoj-sajter.from.hr\/?p=808#primaryimage\"},\"datePublished\":\"2019-01-03T09:00:49+00:00\",\"dateModified\":\"2019-03-07T17:17:21+00:00\",\"author\":{\"@id\":\"https:\/\/domagoj-sajter.from.hr\/#\/schema\/person\/d4fdfbe69949cfe84f1166af6396b800\"},\"breadcrumb\":{\"@id\":\"http:\/\/domagoj-sajter.from.hr\/?p=808#breadcrumb\"},\"inLanguage\":\"hr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/domagoj-sajter.from.hr\/?p=808\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/domagoj-sajter.from.hr\/?p=808#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/domagoj-sajter.from.hr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Suvremen na\\u010din pra\\u0107enja nazo\\u010dnosti studenata na nastavi v.2.\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/domagoj-sajter.from.hr\/#\/schema\/person\/d4fdfbe69949cfe84f1166af6396b800\",\"name\":\"Domagoj Sajter\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/domagoj-sajter.from.hr\/#personlogo\",\"inLanguage\":\"hr\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/d77b3a3c73438d362255d004235ba492?s=96&d=monsterid&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/d77b3a3c73438d362255d004235ba492?s=96&d=monsterid&r=g\",\"caption\":\"Domagoj Sajter\"},\"sameAs\":[\"http:\/\/domagoj-sajter.from.hr\"],\"url\":\"http:\/\/domagoj-sajter.from.hr\/?author=171\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2. - Domagoj Sajter","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":"http:\/\/domagoj-sajter.from.hr\/?p=808","og_locale":"hr_HR","og_type":"article","og_title":"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2. - Domagoj Sajter","og_url":"http:\/\/domagoj-sajter.from.hr\/?p=808","og_site_name":"Domagoj Sajter","article_publisher":"https:\/\/www.facebook.com\/financije.1","article_published_time":"2019-01-03T09:00:49+00:00","article_modified_time":"2019-03-07T17:17:21+00:00","og_image":[{"url":"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png"}],"twitter_card":"summary","twitter_misc":{"Napisao\/la":"Domagoj Sajter","Procijenjeno vrijeme \u010ditanja":"12 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/domagoj-sajter.from.hr\/#website","url":"https:\/\/domagoj-sajter.from.hr\/","name":"Domagoj Sajter","description":"osobne stranice","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/domagoj-sajter.from.hr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"hr"},{"@type":"ImageObject","@id":"http:\/\/domagoj-sajter.from.hr\/?p=808#primaryimage","inLanguage":"hr","url":"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png","contentUrl":"http:\/\/domagoj-sajter.from.hr\/files\/2017\/01\/Screenshot_2016-03-31-12-53-38.png"},{"@type":"WebPage","@id":"http:\/\/domagoj-sajter.from.hr\/?p=808#webpage","url":"http:\/\/domagoj-sajter.from.hr\/?p=808","name":"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2. - Domagoj Sajter","isPartOf":{"@id":"https:\/\/domagoj-sajter.from.hr\/#website"},"primaryImageOfPage":{"@id":"http:\/\/domagoj-sajter.from.hr\/?p=808#primaryimage"},"datePublished":"2019-01-03T09:00:49+00:00","dateModified":"2019-03-07T17:17:21+00:00","author":{"@id":"https:\/\/domagoj-sajter.from.hr\/#\/schema\/person\/d4fdfbe69949cfe84f1166af6396b800"},"breadcrumb":{"@id":"http:\/\/domagoj-sajter.from.hr\/?p=808#breadcrumb"},"inLanguage":"hr","potentialAction":[{"@type":"ReadAction","target":["http:\/\/domagoj-sajter.from.hr\/?p=808"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/domagoj-sajter.from.hr\/?p=808#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/domagoj-sajter.from.hr\/"},{"@type":"ListItem","position":2,"name":"Suvremen na\u010din pra\u0107enja nazo\u010dnosti studenata na nastavi v.2."}]},{"@type":"Person","@id":"https:\/\/domagoj-sajter.from.hr\/#\/schema\/person\/d4fdfbe69949cfe84f1166af6396b800","name":"Domagoj Sajter","image":{"@type":"ImageObject","@id":"https:\/\/domagoj-sajter.from.hr\/#personlogo","inLanguage":"hr","url":"http:\/\/1.gravatar.com\/avatar\/d77b3a3c73438d362255d004235ba492?s=96&d=monsterid&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/d77b3a3c73438d362255d004235ba492?s=96&d=monsterid&r=g","caption":"Domagoj Sajter"},"sameAs":["http:\/\/domagoj-sajter.from.hr"],"url":"http:\/\/domagoj-sajter.from.hr\/?author=171"}]}},"_links":{"self":[{"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/posts\/808"}],"collection":[{"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/users\/171"}],"replies":[{"embeddable":true,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=808"}],"version-history":[{"count":37,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/posts\/808\/revisions"}],"predecessor-version":[{"id":1080,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=\/wp\/v2\/posts\/808\/revisions\/1080"}],"wp:attachment":[{"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=808"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/domagoj-sajter.from.hr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}