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

Playback Speed

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

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

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

4 Lessons (11m)
    • 1. Introduction

    • 2. Setting up the Apps

    • 3. Setting up the form to collect reviews

    • 4. Whats Next

  • --
  • 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 learned how to set up a Google form to allow student submit a project for review.  We then looked at the formula required in the collection sheet that will allocate reviewers to projects.

In this class Create a Peer Review System for your Class or Course - 2 we will look 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 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 the series of classes 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 to create a peer review system for your class or courses or projects to. This is the second class in the course. In the first class, we set up the Google form to collect the project. Submissions on We set up the Google sheaf a swell on the collections. So in this class we're going to look at the Google Apps that I require toe auto email, the students the projects that they most review on. We'll also set up the second form for the reviewers toe actually submit their review. 2. Setting up the Apps: we're gonna look now at the add ons that make this sheet actually work. So the first Adam that we use is the copy down Adam. Now, why would we need a copy down at on when somebody submits a form, what you want to happen is you want all of the's codes Are all of the's formulas here that you have entered into this sheet to copy down before any mount is actually sent. Otherwise, thes particular cells will be blank on. They won't pull in the information that we need for the email. So the copy down is an Adam on. Did you? Congrats it from Get Adams on. You can do a search for copy down on Once it's arm, all you need to do is go into your copy down on little Come on, A little chip searched through your sheet for your particular formulas on its found my formulas, you turn it on to arm its found my formulas in row two. You can then check the formulas. If you updated, you compress rediscover formulas and then you save settings. So basically what happens is as soon as the form is submitted, these formulas automatically copy down before it moves on to step off sending the email. The second thing that you need to do in terms of Adams is turn on your auto responding email. You need this to be a czar. Automatic is possible because if you have a lot of students in your course and you're using a peer review system, you don't want to. The reason we were using the peer review system, Mr Cale, from other students in grating people's working in reviewing people's work. If you have to do all this manually, sure, you might as well be grading them yourself. So we want to send an also replying email. When somebody sends us their project, we want to send them details off the project that they have to review on. We need to remember that you can't give certain information. I like you can to give the other projects email address or their user names, so you have to keep certain things confidential. So let's set up Adam, so we're going to use for mule on. If you haven't got form, you'll you need to get form you'll so we will open our form you'll on. We want to send it on submission on them. We will select our template. And then here we consider criteria. And we've looked at four mule in some of our other tutorials in this course. So I'm not going to go true it in great detail. But we have only one template, so there's only one particular email on. We're going to send it for all rows. So we're going to save, and then we're going to add at the particular template. So I already have this pre populated. So I'll go true which you what you need to do. So the two is. Please enter your email address. So we got this. These are all our tugs. These are all the headers off our spreadsheet. So we want to get the email address imparted in here. So whichever one of these is the email address, you need to put in a reply to sample peer review submission. Please review these projects. Hi. And then I have please enter your name to pull in the person's name. Thank you for taking part in our sample Peer review. Your project has been submitted for review. You have to projects now to review. Please use the rubric on the website so you would have the room bicker. You'd have whatever details you need to put in. And you can put in whatever you want in the body. I have also then put in. Please note the project code that you are reviewing, as you will need this when you are completing the review form and I then pull in the cells from over here. So please review the following and I pull in the cold. I pull in the name of the project. I'm a link. The project. I don't pull in personal information for who's made it the project on I do for the 2nd 1 and these are all down here. I then have a link to my review form which you will be able to get at the later stage. Actually that at a later stage to enter it in here on then I can preview and I can send all the emails and what'll happen is it will go down True all of the submissions and see what emails haven't been sent undergoing. Send the particular emails pulling in the correct references when the email is sent. It will then put some details in here to say that the email is sent that this is also responding. So once you've done this once and Sabbath up from then on, when somebody submits a project, it's going toe automatically. Send the email to the in the next tutorial. We're going to look at the second form, and this is the form where somebody needs to review the actual project that's been submitted. 3. Setting up the form to collect reviews: So we create a new form from our Google drive the same way that we created the previous form. We go to Google forms and set up in your form and I already have a form set up and I'll talk you through it. So the first thing that you do is you give the former title. So we're calling this peer review review submission form. I think given the form of description, please use this form to submit your evaluation off the projects you are reviewing. Please submit a separate form for each project. We then need to collect some information on the first information that I'm going to ask them for is the code for the project that they're reviewing Now, If you remember on our first split, she the forms are completed. They submitted their project and then we use the role function to pull in a project number on. Then we allocated the project number in the email for the projects to be reviewed. So what you do now is you're actually collecting that project number in this question. Here on, we have it as a a text type. Andi. I also have some advanced settings here, So I have some data validation on I have number is greater than two because I started on with row two. Now you could start with growth housing so you would have equals row number on whatever would make up to start were with thousands. And you can put in some custom error text if you want to. After that, I've then also asked them to submit a link to the project. Ferial reviewing If for some reason the person that receives the review isn't happy with the review, they might want you to re review it. And you just need to be able to check back that the person is reviewing the correct projects. So you need to make sure if there's any sort of problem that these two time in, we will then ask your questions. So from you will remember from the text that you read early around in a previous lecture, we had the Rubik set up on one of her questions is, is there a clear brand on what we don't this term was? We use the question type Jews from a list on they can choose. Excellent. Very good. Okay, Could do better and we've made these all required questions as well. So other images used in the posts either links to useful content overall presentation overall quality on they all are choose from a list on this ties back. As I said to the rubric that you have seen early around, I have Then update of the confirmation page, your responses being recorded to thank you for completing the peer review you will receive on email when your project has bean rebate Butte on. I'm gonna keep the shoaling to another response in there because they have to projects to review, and they might want to review them straight away. Now, the next thing you need to do when you have this former actually settle piz, you need to get out a link to this form. So to get the link, if we go to send form and we can get a short two hour or and we can copy this, you are out and we can copy this on. We then need to go back to our first spur cheek into the email into the form you'll on the email set up and copy that in so that they have and I mentioned early round. You'd see this in the later stage. So this is where you get that link from to go back and put in. So we'll quickly have a look at the live form. And again, I have changed the formatting to be the same as the previous one. So they're going to enter the project. They're going to enter earthy, linked to the project. Is there a clear, bland and all the questions on Do you have any further comments? And then they can submit the project begin. This form is just collecting information on the magic again is gonna happen from the actual spreadsheet. So in the next section, we're going to look at the spreadsheet that we use for this Pierre of use of mission form. 4. Whats Next: congratulations on completing the second class in creating a peer review system. We looked at the Google maps required to auto email students the projects they must review , and we also looked at setting up the second form for viewers to submit the review. Look for my third class now and the final class, which is to create a peer review system for your class or course of project Tree, where you learn how to set up the Rubik. The formula required to grade the project after the review has been submitted on how toe automatically email the learners their review and after that class you will have a completely automatic peer review system.