Create a Peer Review System for your Class or Course - 3 | Paula Guilfoyle | Skillshare

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Create a Peer Review System for your Class or Course - 3

teacher avatar Paula Guilfoyle, CPA, Online Educators, Lifelong Learner

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

5 Lessons (13m)
    • 1. Introduction

    • 2. Setting up the Rubric and email

    • 3. Formula for Response sheet

    • 4. Final add ons and apps

    • 5. Conclusion

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

A peer review system will allow student submit a project and have the project reviewed by other students.  This is fantastic for courses or classes that are project based and have a large number of students.

Over the course of 3 classes we will build a peer review system that will automatically email student project to review and automatically calculate a score and email the project submitter their results of the review.  Once set up the entire process is automatic.

All that is required is a Google account so if you have Gmail, or a Google+ account then you can do this at no cost!

In the first class you will learned how to set up a Google form to allow student submit a project for review. You then look at the formula required in the collection sheet that will allocate reviewers to projects.

In the class Create a Peer Review System for your Class or Course - 2 we looked at the Google apps required to auto email students the projects they must review and also setting up the second form for reviewers to submit their review

In this class, the final class Create a Peer Review System for your Class or Course - 3 you will learn how to set up the rubric, the formula required to grade the project after the review has been submitted and how to automatically email the learner their review

By the end of this class you will have a fully functional peer review system 

Meet Your Teacher

Teacher Profile Image

Paula Guilfoyle

CPA, Online Educators, Lifelong Learner


Paula is a qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Paula is also the owner and author at  The Excel Club is the only Excel blog in the world where you can earn while you learn.  To read more about our Excel Learn and Earn Activities take a read of this

<... See full profile

Class Ratings

Expectations Met?
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.


1. Introduction: welcome toothy third and final class. Create a peer review system for your class or course tree in this class, you're going to learn how to set up the rubric. The formula required to gray the project after the review has been submitted on how to automatically email the learners their reviews. This is the third class in the course the final class. In the first class, you learned how to set up the Google form to allow students submit a project for a review on how to set up the formula required in the collection sheet that will allocate reviewers to the projects. In the second class, we looked at the Google maps require toe all her email, the students the projects they must review on also setting up the second form for reviewers to submit the review. And this is now the final class, and we'll put it all together on at the end of this class. You'll have a completely automatic peer review system. If you missed Class Warner to do her back on, have a look at them classes 2. Setting up the Rubric and email: This is our former spun sheet for the actual peer review submission so pulled in all the fields from the former gives it first gives at a time stamp. Then the first thing we asked was for the project code that the reviewing and then we asked for the link on. Then we asked the question. So is there a clear brand and so forth on it pulled in the and two. So, as I said, I submitted some answers just to show you After this, I then have a number of formulas in this sheet, and then I have some Adam's running. But before I can go through the formulas, I need to show you how to set up some other stuff. So the first thing we're going to do is you need to add a new sheet. Anita, add your rubric in here. So you will remember from your text document they This is the scoring that we were going to give for the particular project with a total score available off 20 on. What we can do now is having this on another sheet from the form responses here. We can actually pull in the scores. Two over here. The coward corresponding scores over here, so you'll need to set up a new sheet. Unreal Nieto add in your rubric. We also need to pull in some email addresses from the other sheet that we had. So what we have is we have our we have our actual comments on then we haven't scored on. Then we need to the email address to send the results to, because the person that submits the form isn't the Paris um, that's going to get the email. The Paris in that owns the project is the person that's going to get the email. We have their email address in the other spreadsheet on. The only way we can identify these is by using the project cold. And that's why the project given the project a unique identifying code, is so important. No, to do this and to be able Teoh pulling the email address is What I've done is I've used the import range function, and if you look up here, it looks rather complicated, but it's not half as complicated as it looks. He started typing equals import range. You then need to put in the name off the she's on. Where do you get the name Off the sheet. Well, if I go back to that particular sheet on, if you look up here, you'll see this cold. Here is the name off the sheet. So you need to put that in there. Then you need to put in a comma in another set of inverted commas. You need to put in the sheet name on the range that you want to take. So we've put all that in on, will hit, enter, and it'll then ask you to connect to spreadsheets on Little pulling. The information on it will update when this is going to pull in all the way across to the course code. Now what I've done then is to use a V look up is I've actually pulled in the email by Equalling the email address was which is in row C and I'm equal that all the way down, you'll see that formulas filled in all the way down. So we've now actually pulled in the email addresses to this sheet. What we need to do now is in our form responses What? We're going to look at it in the next tutorial. is the formula to pull these in to pull in the scores from the rubric sheet and to pull in the email address from the email pull sheet into the form responses sheet, so we're gonna look at that in the next session. 3. Formula for Response sheet: Okay, Back in our form. Response to sheet on the first formula I'm going to show you is the local formula to pull it in the email addresses. So a local formula is going to look up something on return. A position relative to where you tell it. A Polian. So the firmly that we have is V lock up and we're gonna look Upsell before before is our cold. So we're gonna look up our cold. The next thing it's saying is, where are we going to look it up? And this is the table where we're going to look it up. So if we just jump in there, we will see email pull f row, F N g, which is thes two here. So it's gonna go to these tables. It's gonna go down here, June, it's gonna look up the cold, and then it's gonna go course on. It's gonna pull in the particular email address, which we've set up to pulling directly from over here. So let's have a look at this again. So it's going to look up the particular code and before, So it's gonna go over here, it's going to look up the cold that the individual submitted on the form it's they're going to go to the email. Paul. It's going to find who owns that cold on what? The related email address, and it's going to return the email address force. So that's the V lock up. And once we have that formula in, it's going to auto fill down. When we turn on our copy down, as we did in her previous spreadsheet, the next formula that I have in here I have the score available on. I've literally just made this score available equal to Selby seven on the Rue Bic, and if we go to a Rubik sheet, we will set. Sees out. B seven is the total score, which is 20 so that's literally pulled in. I have blocked in themselves since. Is using the dollar sign before the be on the seven, so thescore available is always going to be 20. You could have heard coated that end, but I put in a formula so the copy down will work. The total score is another formula on. Basically, it is just adding up all of the scores together to give the individual a total score and I've also calculated a percentage, which would be the total score on and the score available. The other formulas that we need then is to pull in the actual score allocated to what the review has been given. So we can see the question is here, Aunt, then the person's choice answer that they're giving is here. So we know from a rubric. Is there a clear brand? If it's excellent before, if it's very good to be tree, if it's OK, it be, too. And could do better. Could be one thing. So what we're gonna do is we're gonna use the index Onda match functions, and what the index and match function will do is it's gonna go on. It's gonna look for this question, so it's going to go over here. It's gonna come down here. It's gonna look for this question. It's then gonna look for the particular answer on. It's going to find the intersecting point between the question on the answer and return the intersecting point. So let's have a look at the formula. First of all, we have index on it, saying Where are we going to index? So I've pulled in the whole Rubik table. So that's from South. A won T E 60 can see here from South a one t e six. So that's the table where we're going to be looking stuff up. We then need to know what role we want to look up. So we want to match. The answer said this cell here. So what's being given onward? We want to look this up. We want to go to the rubric on. We want to go across the answers here, and it's going to return whichever particular answer. And then we want to do the same, then with the questions. So which question is up and it's going to go? Course it's gonna go into the Rubicon, and it's going to go down here to select the question on. Then we'll give the intersecting point. So once we have that formula in, don't forget to put in your dollar signs to look the formula in. So when you do your copy down that you're easily able to copy, the formula is down on the formulas. Don't get mixed up, so I'd have a close look at that formula. Study that former there for a few minutes So you understand that if you have any questions on a stick them in the discussion board, Andi, I'll try and get additional resource for you for index on much. 4. Final add ons and apps: the final thing with the with this particular sheet. Now with the peer review response sheet is the Adams on the order responding email. And we looked at this in the first sheet. So I'm gonna go through very, very quickly on the Adams. We need to have the copy. Damn future turned German. If we turn on the settings, it's gonna work through the spreadsheet. It's gonna look for the formulas. You need to turn it on. We want to copy the formulas in row two on. We want to be able to copy them down. And you can rediscover the formulas if you need to rediscover the formless. So we've closed this. We also need to turn on our form. You'll I already have to set up. So I'm going again. Go true very quickly. We will send on submission. We have one template, and we're gonna send it for all Rose. And what are we going to send them? Well, we pulled in the email address email to send results. We pull that in. That was formula driven. You should put in a reply to email address subject. Your project has been reviewed. Then we put in the body of our email so high you have received a review on your project. Please don't forget that this was for demonstration purpose only. I then pull in the score available on the total score on. Don't forget, these are all fields from your spreadsheet. I pull in the score. The score that they got for the 1st 1 on. Then is there a clear bond? And what? What? They said I pulled in everything about what they said on. Then Thank you for taking part. Bloody bloody block. So you can preview this and you'll see how. Then it will look when it sent on. Then you can send all. And once you have this set open once you have it sent its then Satya stand as soon as the form is actually submitted to you. So that's the a peer review system that I have made. When we're finished, we will be left with four files were going toe, have two forms and we're going to have to sheets. Andi, these you can then uses a template and you can copy them and share the mom on to use them for other peer reviews. I hope you enjoyed thes session on building a peer review. Thank you. Goodbye. 5. Conclusion: congratulations. You have now completed this course on how to create a peer review system for your class or course or project a pair of you system is fantastic. If you are teaching on your own platform and you've load the projects being submitted on, you want them to be reviewed, but you don't have time to review them yourself. I hope that you'll take the time to leave a review for this class and a review for the previous two classes on Also submit your project because projects and reviews are extremely important to instructors Lycos to help our classes Be found.