 Felly, y fideo yw'r ysgolwyd yw'r ysgolwyd yn ymgyrchol. Felly, ydych chi'n gwybod ychydig o'r ysgolwyd? Felly, rwy'n credu y gallwn y ffordd yw'r ysgolwyd. Felly, y gallwn ymgyrchol yn y lab yn ymgyrchol, ac mae'n cyd-3, mae'r ffordd yw'r ffordd. A'r ffordd yw'r ffordd yw'r 24. Felly, y ffordd yw'r ffordd yw'r 24 yn ymgyrchol, yna? Felly, ychydig yw'r ffordd. A oddych chi'n gweld y ffordd ywodol yn ymgyrchol? Felly, ychydig yw'r 2, 3, 5 o some gwybod yw'r ysgolwyd yw dwy. Felly, ychydig yw ymgyrchol wedi chi? Yna, rydych chi'n siarad am y fforddd. Felly, rwy'n gyffredinol balog ac maGGg y galw ymgyrchol yn ymgyrchol. Ychydig yw i'r ffordd eich ysgolwyd yn ymgyrchol. Mae'r unedaint yn ymgyrchol, Llywodraeth, C7, 21, divide that by 1,000, return that correct answer. So this is really no different to tapping it into a calculator except that maybe if you, actually let's do 24 minus 3 as well, except you want to come back and change that, it'll all recalculated for you. So this is kind of a halfway point between kind of setting up a spreadsheet to do the data analysis for you and kind of assessing it at the same time so it's going to be checking the calculations. And the main reason to use something like this is because when you say ask an online quiz to do it, usually students can't upload their own data and check it. Most of the kind of the online quiz formats on virtual learning environments like Canvas don't support that. You'd have to go for a third party tool anyway and that might involve some kind of complex web hosting or programming and that's a bit of a pain so you know this is a nice visual way with a good interface that lets you just do it kind of natively on a computer. So that's why you'd want to use it and this is how it works and you know it's all right. You need to be a little bit careful about what order you present things in and what feedback you give and browning errors but we'll discuss that a little bit as I go through how to build one. So I'm not going to build a complicated one in this tutorial. This is just going to lay out how I would start one and then a couple of hours later you just throw features at it through each other and you play around with it and you get something more complicated out. So let's just do the titration one. So let's just say we're going to label a couple of rows. We want starting point or an ending point and then the titra calculation so three things and I'm going to right align those and then I want the numbers to appear here and then I'm going to put the units in so centimeters cubed, centimeters cubed, choose millilitres, go back and format that subscript as you like but I'm not going to do that here and in the middle I want to indicate that someone should fill this bit in so I'm going to highlight the three cells, go to conditional formatting the cell style section and just select input now it jumps out at you and if you go to view and remove things like the grid lines and the headings now it starts looking a bit more like a worksheet that you fill in and if you highlight these and right click you can go to format the cells and there's this thing here that says protection normally it'll jump up to number but I was playing with this earlier and you just tick locked or untick it at least. Now normal cells are going to be locked these input ones aren't so if you go to the review tab and click protect sheet, unselect the select lock cells let them select the unlocked cells okay that suddenly no one can play around with any other coding that you're going to do they're not going to break anything they can only manipulate the input cells so let's unprotect that and put the rest of the stuff back on right so now it looks like a spreadsheet again okay so the thing about this is that you need to be able to understand how someone's going to manipulate the data and what they need to do and you kind of calculate it behind the scenes you hide it away and then you compare it and then pick it tick so what I'm going to do is I'm just going to put off in this cell some off to the side the actual calculation we're going to do I'll put some sample data there just to make sure it looks right so it's going to be the end point minus the starting point that gets us our title it should be 22 so we want to compare this number to that one and I'm going to stick 22 there and what's the well the easiest way to compare two numbers is simply equals and the two cells next to each other so is c4 equal to f4 a statement like that will simply return true or false if I miscalculated that and well it would come out as false if I keep doing that and so on so that's fine that works pretty nicely but I want to do something a little bit more fancy with this so I'm going to type in if and if if c4 equals f4 if that is true I want it to return one and if not zero now that seems a little bit redundant if you know a bit of excel because true and false often evaluate as one and zero if you're using maths on it but for conditional formatting it kind of doesn't that so we're going to make sure that it says one or zero you could if you're getting more complicated use one zero and two for like maybe a correct or nearly correct answer we're just keeping it simple for now I'm going to come to conditional formatting and create a new rule just on that cell and we're going to format the cells based on its value I'm not going to do a covers color scale I'm going to do the icon sets so an icon set just flag up an icon depending on the number you do need to change a couple of the defaults on this so I'm going to go by the exclamation marks and the tick marks here make sure to change the type to straight number not a percent by default this icon set is like the top third of your data will be green then the middle third will be yellow the bottom third will be red you don't want that you want it to evaluate the number so when it is greater or equal to one I want it to be green when it is greater or equal to zero I'm going to set that as red you could make this more complicated if you want the three but we're just going to stick it as two for now I'm going to okay that and what you can see is when it is the right answer there's that green tick if I put the wrong answer it's uh nx it's the wrong answer value it's a zero now I'm going to go back into the conditional formatting again and edit that rule and I'm going to click show icon only in the middle okay that reply it and what you can see is it just gets rid of the number it just replaces the data with just the conditional format icon which is really useful because that now becomes formatable partially formatable and we can centre it so that is the wrong answer that is the correct answer number 22 yeah that's going to take it if I put 23 it's wrong now here's the question if I leave that blank that's correct I haven't put in a correct answer so it should be x but what if I just presented this blank let's get rid of the data here suddenly it's marking it is correct but you know that's that's technically true this is what we told the computer to evaluate this is blank that's zero blank equals zero in computer terms so we need to um kind of evaluate this a little bit more precisely we don't want any of the hints or evaluation to trigger until there is an answer to actually evaluate so I'm going to edit this formula a little bit push it over here and just worked here now so the first thing I want to do is if is blank so is blank hit the tablet or to complete it and I want to see if that value c4 there is blank if that is blank what's my true value well it's not going to be one or zero because I don't want a thing to appear there at all I mean I could stick zero in if I wanted to um I'm going to have just two quote mocks uh and that will fill it with nothing now if false if it isn't blank it's worth keeping that always uh in your head properly if it's not blank it's got an answer and I wanted to evaluate an answer so I'm going to go if if that c4 is equal to f4 then one zero and then close that and what we can see is it's now blank it is not going to stick a number on unless we've calculated an actual answer there we go so that's basically all that really needs to happen after that is you to hide this and the easiest way to hide your answer is to simply put uh it is white text there you go you can get rid of it that way uh sometimes i'll either miss the light ish where's it gone lightish gray and then hide it with uh a graph or something so something might be hidden behind a little graph um and that just means if I'm troubleshooting it I just need to move it out of the way another option is if you highlight your column control shift and to the right you can hide the whole thing away now you do that again and you do this it's always um always awkward to do that on hide it again so that's it um that's how you would start an interactive web sheet um oh an interactive worksheet sorry um maybe it could be done better on the web but this doesn't require the hosting I suppose and you can build on it from there so instead of this I'm going to write a calculate title there for instance and then if it's blank it gives me an instruction and usually I will do uh maybe sell style so that looks like that um now once we get rid of the grid lines on the headings now it looks like kind of a worksheet especially if I then go off to review and protect the sheet I can't change anything all I can do is manipulate my answer and see can I calculate it correctly