mobrien

@Graham Quince I worked out how to get as close to this as possible! Using the ad-hoc date selector in Analytics, I've been able to get a list of students who logged in per day, then compare that to our SIMs student list. Works a treat.

Many thanks @Graham Quince. Unfortunately, this is not quite what I am after. I'm happy with combining all the data together, but where a user has logged in 10 times, I'd like to be able to see all those 10 logins listed line by line. And for all students...

@Graham Quince Sorry to add to this but... The Visitor Log widget would help me going forward, but I have also been asked to provide a report of student login patterns for groups and individual students e.g. Vulnerable students for the week passed. The Analytics app shows me total number of logins, but I need the raw data that the count is sourced from. Is this something that Frog can provide me with? Even if it was an Excel dump I can process it as needed. Any help gratefully received as ever!

@Graham Quince Hopped on our platform this morning to give this a whirl. I could see the widget already installed, checked and there were no updates. But when I add it to a site, even a brand new site, it adds a strange empty placeholder and then I am not able to save the site, or click any other buttons in fact. Refresh the page is the only available action. Any ideas?

@Graham Quince the idea of grouping staff into teams is good, but the HR manager would have to check around 20 teams' sites/forms (!!) for updates as the data viewer only appears to display data from a single form. The idea of having a dynamic keyword was so that the teacher would specify the staff code of their line manager. Using this keyword, filters could be applied to only display them to the relevant line manager - worth a thought, perhaps? I'd used your Governor Portal policies as the source for my thinking this morning. @adamw my other consideration for thought is that the first layer of approval would work great, but how does the HR manager get notified of the response updates? Would it be possible to add a two stage notification system...? Thank you to you both

@adamw and @Graham Quince thank you for this - it sounds like it is getting close to the solution we are looking for! Thanks for your tips - I'll take a look at them now, in particular the Wall idea. Intrigued to hear the afore mentioned 'other' development. Looking forward to the details as ever! Thanks for your help so far.

Dear Community, I have been granted a day today to develop a system for staff absence requests in School. I had originally planned on using SharePoint, but I was inspired by @Graham Quince at Frog18 yesterday and have started to look at using Frog instead. A combination of Forms, Data Viewer and the Keyword widget appear to be the key. I have, however, hit a couple of conundrums that I am struggling to resolve, and wonder if there might be any help from the community. Please treat me as a complete coding beginner with very little experience... Description: Teacher1 creates an 'Absence Request' site from a template Teacher1 enters details into the page describing the absence. e.g. dates, reasons etc. (I can build this all in HTML, but the forms widget will make a nicer job). They submit the data to be stored (and viewed later), AND click the 'Submit' keyword button LineManager1 sees the site in a keyword-filtered site list. LineManager1 reads the data Teacher1 entered, and approves/rejects with another keyword widget. Queries (3) Is there a way to create a button that will create a new site from a specific template? How do I store the data entered in the fields into he page of the site so that the owner AND line manager can read the data (not by using the Data Viewer format)? Is it possible to have a field (variable) with a button that sets a keyword equal to that field. I hope you can help. Thank you

@pconkie You are quite simply: a genius! Brilliant, works a treat. Thank you very much.

Hi @pconkie, Thank you for this! It has not quite worked, but nearly there. I've amended it for the two subjects in my own TT (science and physics) and double checked that this is the SIMs name. I also made the 'stringtocolour' changes to 'subjecttocolour', as suggested. I also took out all other subject references to make sure eliminate any other variables and gave it a go. However, the timetable is only returned in the default colour specification (black in this instance). Is there anything that I am missing?: var subjectToColour = function(subject) { var colour = ""; switch(subject.toLowerCase()) { case "science": colour = "#4daa50"; break; case "physics": colour = "#007681"; break; default: colour = "black"; } return colour; }; Thank you for your help with this.

@pconkie I've just been having a play with this code and have got it to work!! (after some serious trial and error...) Brilliant stuff, though! In section 5 you describe how you generated the subject colours, based upon their names as they arrive. I've managed to amend the colour schemes by adjusting the 'p * 8' multiplier here: var stringToColour = function(str) { var hash = 0; for (var i = 0; i < str.length; i++) { hash = str.charCodeAt(i) + ((hash << 5) - hash); } var colour = '#'; for (var p = 0; p < 3; p++) { var value = (hash >> (p * 8)) & 0xFF; colour += ('00' + value.toString(16)).substr(-2); } return colour; }; My question is, would it be possible to pre-select a colour per subject? For example, we have a colour coded building, and it would be nice to match the subjects with their location colour. I know in you post you mentioned that you tried to avoid this, though. Thanks, Michael.

Excellent, many thanks @Graham Quince, worked a treat!

Dear Community, On the Frog website designs showcase page, there is a link to Theale Green School. We have noticed that they have a calendar widget on their homepage without the skeuomorphic red rings at the top. Does anyone have some code to achieve this with the HTML widget? All I have managed to do so far is remove the header text. Thanks, Michael

Hi @Graham Quince, Thank you for the explanation - makes total sense. It's good to know that security is a non-negotiable. M.

@pconkie Many thanks for this, that's really clear now. Thank you for taking the time to explain it to me. So, I think I might have a finished product, as below. This will be used to display students' Rewards to tutors during tutor time. All in one place, with one set of data. @Chris.Smith and @pconkie, what you have built for me here is far more than I could have expected. Thank you. Once we have a live version with the Excel part to build the data, I'll post the results here. Thank you again, Michael

We have had FrogPlay for just over two years now. we haven't ever done a huge launch with students, just offered it to departments to embed in their departmental sites, and made links to it available on a student hub page. Science and Maths have really seen the most success and command most of the usage so far. See the screenshot below with our stats. This equates to 4200 quizzes this year, 54% completed by Y11 students. Our 'in school' figures are high because internal home work marking lessons are regularly followed by an opportunity to use FrogPlay to further embed their learning. In the next few weeks we are launching a Y10 dedicated site and FrogPlay competetion to encourage revision before end of year mock exams. For this coming year we are going to be running a section of our rewards system to further incentivise FrogPlay use, and ultimately, embed learning retention. i was at a curriculum leader meeting this Tuesday giving a breakdown of Frog's usage stats and individual student success stories. One particular reference I made was to the Technology courses, where they have only a very basic department site (currently...) but students have spent just under 5 hours on FrogPlay for DT alone ! It's great.