or login with

@MrSchwen

  1. @mrschwen Course Management Data System tutorial
      Flip
    • The video runs fast so I'd recommend making use of the pause button to read notecards.
      Flip
    • Select a class, unit and multiple tests to compare by clicking in the yellow cells and choosing a test from the drop-down menu once student test data is present.
      Flip
    • In the grade book tab, setting the category to pretest does not contribute to their mastery score as soon as other test data becomes present.
      1. "Include" will use the score in the mastery score and a "Pretest" immediately following an include score will replace the score in the mastery calculation.
      Flip
    • Some online grade programs don't allow for teachers to paste in a column of scores from a spreadsheet. This script will automate the process and reduce the amount of time spent on putting scores into the school grade book system.
      1. You can get the program from my student's website at http://piguy.net/ He has versions for both PC and Mac here.
      Flip
    • Instant feedback on test questions can help direct future instruction or decide if test questions are misleading for students.
      Flip
    • As tests (Google Forms) are created, links are automatically sent to a unit document (editable) that you can share with students with included QR codes that can be pasted onto paper test copies.
      Flip
    • The setup process is automated. The menu changes based on what step you are completing.
      Flip
    • First you will name your course folder--all materials created will be organized within it from this point on.
      Flip
    • Next you will create a (new) class list. You will only do this step once. This will create a spreadsheet where you will enter student names (and update them with each new year).
      1. Most people new to the system will not need to connect an existing class list.
      Flip
    • Next you will create units that will contain assessments. You can have up to 6 assessments within a unit for comparing student scores.
      Flip
    • To add assessments to a unit, click on the "edit unit" link in the "Smart Setup" sheet of the course management spreadsheet.
      Flip
    • Click on the Unit menu that loads (you will need to authorize the script and then click it again).
      Flip
    • You have two options: 1. For schools that have Google accounts for students you can choose the G-Apps assessment to automatically collect user emails. 2. For schools without or not wanting to require students to login, choose the public account
      1. Using the public option #2 students will need to manually enter their email address to get their emailed results.
      Flip
    • Click the "Edit Test" link the the "setup" sheet on your unit spreadsheet. Next you will edit the test, set the answer key and activate instant email results.
      Flip
    • In the test spreadsheet: Click "form" menu, click "Edit Form"
      Flip
    • Edit the form to have your test question types--leave existing items in place. You can also update the instructions and title to be more specific for your students.
      1. For Google Apps (test option 1) template users make sure to click the second two checkboxes when viewing the edit form window.
      Flip
    • While still in the edit form window, after editing all your questions click on the live form link at the bottom. Submit the correct answers to be used as your answer key.
      Flip
    • Go back to the test spreadsheet, click on the assessment menu (may have to do twice to authorize the script again).
      Flip
    • Choose "set answer key" and then type in the row number that has your correct answers (usually will be a 4).
      Flip
    • Click the menu again and click on "Activate Email Results" so students will get an email with their score instantly after submitting their answers.
      Flip
    • All units, tests and class list will appear organized (by unit) in a Google folder in your account list.
      Flip
    • If you open the class list, here you can add students (and update as students come and go). Since much of this is formula based I would make these suggestions on the names you enter here.
      Flip
    • I recommend using only last names in your class list unless multiple students have the same last name. Use as little of the first name as possible to make it unique from other classmates e.g. for Patrick Anderson enter "Anderson" if no other Anderson
      1. Enter "Anderson, P" if no other andersons with a first name starting with a P. The space after the comma makes a difference too.
      Flip
    • *This will be the only file you will need to change each year once your quizzes are made.
      1. There seems to be an issue with Google recognizing text pasted in from a grade program export at times. If you are having this issue you could try doing a "paste values".
      Flip
    • This document acts as a table of contents. I share this one documents with students and they get to ALL course materials through it.
      Flip
    • The student work submission link can act as an inbox for students to submit links to work they have completed. All work submitted will show up in the "Inbox" sheet in the main course management spreadsheet.
      Flip
    • This is a great alternative for paying for similar services. As of now it is spreadsheet driven and more accessible to tech savvy teachers.
      1. More information can be found at my blog: mrschwen.blogspot.com
      Flip
    • The possibility of making it more web-based is not a far stretch but it goes beyond my expertise. I'm open to a partnership that would take it to that next step.
      Flip