Collecting Digital Assignments From Students in Office 365 Education Schools

Updated on February 4, 2015
Jonathan Wylie profile image

Jonathan is a certified teacher who has taught in the UK and in the US. He now works as a Digital Learning Consultant.

When you go digital, it's time to retire your red pen for good!
When you go digital, it's time to retire your red pen for good! | Source

The Paperless Microsoft Classroom

If you are a teacher who uses Office 365 Education at school, you will probably have spent some time thinking about the best way to receive digital assignments from students. Paperless classrooms are all the rage, but are they practical? Technology is supposed to make our lives easier, not harder, so there must be a good way to do this, right? There are, in fact, a number of ways that this can be done, but the solution you choose should be the one that works best for you. What follows are some of the workflows, ideas and processes that a teacher could use to collect, grade and organize student assignments in schools that use Office 365 Education.

1. Let's Take a Look at Outlook

If you live your life in Outlook, (as many educators do), you may want to have students email their assignments to you. This is a flexible way to receive assignments because almost any kind of digital file can be added to an email, whether it was created with Office products or not. Students could include hyperlinks to online assignments, add PDFs, image files, videos, and more.

So far so good, except for the fact that you will quickly find your inbox has a lot more email than it used to. Don't worry.There is a solution for that. You can create rules in Outlook to deal with your newly increased mail load and have Outlook sort it nicely in a folder so you can access it when you are ready to grade the assignments you have received. Instructions on how to do that are below:

  1. Begin by choosing a key phrase for students to add to the subject line of their email before they send it. For instance, Math 1st Hour.
  2. Next, open Outlook, and on the Home tab, click Rules > Create Rule…
  3. Check the box that says Subject Contains, and enter your key phrase, e.g. Math 1st Hour.
  4. Now check the box that says Move the item to folder.
  5. Click Select Folder and then New… to create a class folder for your assignments. Name the folder and click OK to continue.
  6. Double check that you have checked the boxes for Subject Contains and Move the item to folder, then click OK to create your rule.
  7. Send yourself a test message with the correct key phrase in the subject line to test your rule. It should bypass your inbox, so look for it in the class folder you just created.

Creating rules in Outlook 2013 is quick and easy to accomplish
Creating rules in Outlook 2013 is quick and easy to accomplish | Source

If your test email was successful, you can now talk to your students about the key phrase that they will need to include in the subject of their email when they submit their assignments. If you have multiple classes, you can have multiple rules and multiple class folders for student submissions. This method of collection may be prone to student submission errors early on, but once they remember the required format, it can be a very efficient way of collecting and organizing assignments.

How to Create a Rule for Student Assignments in Outlook 2013

2. Creating an Assignment Submission Form with Excel Surveys

Want to try something different? If you use an Excel survey, you can quickly set up an online assignment submission form that will let students add the link to their Word, Excel, PowerPoint, OneNote or other digital assignment. If you have never created an Excel Survey before, relax. You can learn how to create an Excel Survey in no time at all by reading this article, or by watching the video below.

The survey does not need to be long. Typical questions include: first name, last name, email address, and a box to add a URL link to an assignment. You should make all of these entries required questions. However, you may also want to include a paragraph box for comments that the student could include as part of their submission. This would not be a required question, but might be useful in certain scenarios, or for when the teacher needs more information about a given assignment.

When the survey is finished, you can post a link to it on your classroom website, on a learning management system like Edmodo, Moodle or Canvas, or make a memorable version of the link as a shortened or link. You could even make a QR code for it and add it to classroom communications or display it inside your room.

Screenshot of the editing mode in Excel Surveys
Screenshot of the editing mode in Excel Surveys | Source

Reviewing and Organizing Assignments in Excel & OneDrive

When students submit their assignments, the data will appear in the spreadsheet you created when you made the Excel Survey. The only question that remains is whether you want to reuse one survey for the duration of your class, or create a new survey for each assignment. There are pros and cons for both methods, so it just depends on what works best for you as a teacher.

If you choose to use just one survey, you will want to add a multiple choice question that lets students pick the assignment they are adding. That way you can sort by assignment name in Excel. Following this method will require you to update the assignment name question every time you create a new assignment for students to submit.

If you choose to use a new survey for every assignment, you will soon have a lot of additional files in your OneDrive. However, you can create an assignment folder for your class and add the surveys to this folder so that you can quickly access them when you need them.

Learn How to Create Your First Excel Survey!

Office 365 at Home for up to 5 PCs/Macs & 5 Mobile Devices!

3. The Amazing OneNote Class Notebook Creator

OneNote teachers have another interesting option - the OneNote Class Notebook Creator. If you have never used it before, this app has to be added by a 365 Administrator at your school, but once you have access to it, you can quickly take advantage of the OneNote Class Notebook Creator as an assignment workflow solution in your classroom.

The free OneNote Class Notebook Creator tool quickly automates several tasks at once by creating one class notebook that has three specific types of sub-notebooks.

  1. Content Library - A place for teachers to share view only material with students - handouts, study guides, content examples, etc.
  2. Collaboration Space - A place where students can work collaboratively.
  3. Student Notebooks - A private notebook for each student in your class that is shared between the teacher and the student. The teacher can see all the student notebooks, but the students can only see their own.


So, as well as accessing all class materials and collaborating with their peers, students can use their private notebooks to add the assignments they are given by their teacher. They never need to copy a link, fill in a form or even send an email. The teacher can see their notebook at all times, and knows exactly where to go when it is time to grade the assignment.

Of course, OneNote allows for a variety of different types of assignments. They could be in the form of text that students type on a OneNote page, it could be a link to a OneDrive file, a link to another other online project, or it could be a file attachment. It could even be an audio or video recording that the student creates using the multimedia recording features inside of OneNote 2013. As such, the OneNote Class Notebook Creator is an extremely flexible way to collect assignments.

Creating Your First OneNote Class Notebook

4. Teacher Dashboard for Microsoft Office 365

Another option for schools would be to invest in a third-party solution like Teacher Dashboard for Microsoft Office 365. This web-based tool allows teachers to monitor and manage student OneDrive files. Teacher Dashboard also lets you distribute, collect and grade assignments from students all from a simple to use interface. It also lets you create custom groups of students to help sort your students by grade, ability, or subject. Assignments can then be assigned to classes, groups, or individuals as you see fit. Teachers can see all the completed assignments in one place and track student activity too. Teacher Dashboard for Microsoft Office 365 is available in the Sharepoint store and is now free for up to 100 teachers! An overview of all that it has to offer can be seen in the video below.

The Paperless Transition: It's Easier Than You Might Think

Any of these workflow solutions can seem a little complex at first, but once you (and your students) get used to one, you will be surprised at just how intuitive they can be. They are a great time saver for students (and teachers), as well as being a great way to model how powerful technology can be when used to enhance efficiency and productivity. Which one is best? The one that saves you the most time, the one that you are most comfortable with, and the one that makes you life in a digital classroom easier.

Is there something to be said about a consistent assignment model across all classes in your school? Absolutely, so think about having that conversation with your school administrators. Using the same assignment collection model will be a lot easier for students if the process is the same in all their classes. It can also be good for teachers who can get peer support from those who are able to support them as they begin to go paperless. It can be a daunting process, but with tools like these the rewards are there for all to see.

© 2014 Jonathan Wylie


    0 of 8192 characters used
    Post Comment

    • Jonathan Wylie profile imageAUTHOR

      Jonathan Wylie 

      3 years ago from Iowa, USA

      Thanks, I appreciate the comment.

    • askformore lm profile image

      askformore lm 

      3 years ago

      Thank you for these very detailed tips. Very helpful!

      I am not a teacher, but I strongly believe that your hub can be useful for parents too.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)