Individual Assessment
This is the Individual Assessment Version. This version will create a form that will allow you to choose a student from a drop down list then make an assessment for that student based on your assessment headings. Using this template, you will create a form with multiple assessment criteria and have those assessments summarized in the Google Sheet. You will decide on the areas/criteria you are going to assess and this template will summarize that assessment data for each assessment heading you choose.
The default scale for assessment is 5,4,3,2,1,0,no mark. 5 corresponds to a 4+ (90%-100%) and 4 is for a mid-to low level 4 (80%-90%). Then 3,2,1 correspond to those particular levels.
Click--> Copy Individual Assessment Sheet to create your sheet this is to be used to assess multiple assignments and collect multiple points of data for the same headings.
I've added a "single use" template, if you are going to use this as an assignment rubric for a single assignment the
single use template may work better as it provides more level input (4+,4,4-....etc) as opposed to just different inputs.
CLICK --> COPY SINGLE USE TEMPLATE
Then follow instructions below:
The copied Spreadsheet will open up, the first thing you need to do is RENAME it and MOVE TO FOLDER using the File menu at top ORGANIZE. **Tip create a new folder when you select move to folder for each course**
Next add your class list to combined name (first name last name) and student number to the “classlist” tab. You can get this list using a simple “user defined” export from Markbook or SIS then copy and paste into the appropriate columns. Make sure you paste combined name and student numbers into their corresponding columns. Then column C will combine those.
NEXT GO TO STUDENT RESULTS TAB: You will then want to decide on the “Headings” you are going to assess. There are 6 “Headings” by default if you wish to add more, you will need to make the appropriate adjustments to the “Student Results” sheet (ie. The purple section needs to be expanded. Just Drag the formulas across to fill right)
If you want these assessment headings to combine into larger categories (application etc), create cell references to those headings in the top yellow section.
NEXT GO TO SETUP TAB: Press CREATE FORM wait till finished → then CLICK ACTIVATE. Your form is created.
ONLY USE THESE BUTTONS FOR INITIAL SETUP: if you wish to add to your form manually do it from here on out.
Find your form by using the top menu “FORM” → “edit form”. RENAME and MOVE to same FOLDER as sheet Take a look at the Form and make any custom adjustments you wish (page breaks etc)
Once you have your form complete, either email yourself the link to the form or create a shortened url using “bit.ly”, “tinyurl.com” or some other custom link shortener so you can easily access the form and create a bookmark/add to homepage on your phone/tablet.
Start assessing your students and watch the data stream in. On the Students Results tab select a student from the drop down box in cell A1 (note that this sheet is best used on a desktop/laptop, as the mobile version is limited in viewing) to see results summary.
If you would like to have individual tabs for each student INSTEAD of using the drop down menu in the “student results” tab. GO TO “createTabs” and click on the “create tabs” pic. The advantage to using these tabs is you can manually adjust the levels for each student (note changes on this tab are NOT reflected on the ‘students results’ tab).
If you find a formula is not calculating you may need to simply click on the cell then press “Enter”, this tends to “wake up” formulas. As this sheet is still new if you find something is not quite working the way it should please send me an email (dawiwchar@gmail.com) explaining what you found.
The Following will Explain the process of sharing live assessment data with your students
UPDATE: as of Dec. 20 the sharing of tabs has been scripted into the template spreadsheets. After creating a tab for each student using the “createTabs” tab use the “shareTabs” tab to share the tabs. Ensure that email addresses are entered/correct then click the shareTabs button. Then click on each link to “ALLOW ACCESS” for the formula in cell A2 of the new sheets. The spreadsheets will show up in your students “shared with me” folder in their drive.