This week we learned about seven ways technology helps you modify the format of your assessments to increase engagement and authenticity while keeping the focus on content and skills. The graphic above summarize the session, and the skeleton Powerpoint is here.
Office for Mac now lets you co-author in real time just like the online version! (Read more at Arstechnica.) To enable this functionality, update your Office apps by opening any of them, go to the Help menu, and choose Check for Updates. After updating, you will be able to open documents and change them with other […]
If you don’t have PDF editing software like Adobe Acrobat Pro, you can still easily create fillable forms using Microsoft Word. Avita recently used this feature to create internal forms for the counseling department. Follow these instructions from Microsoft to create your form or watch this video from a guy on YouTube.
At this week’s after school PD, we learned to use Excel to manipulate text and numbers with formulas and array formulas and look up information/fill in information automatically with VLOOKUP and LOOKUP. For manipulating text and numbers, use these formulas: CONCATENATE, CONCAT, “”&”” – combine two or more cells, strings, or numbers AVERAGE, MEDIAN, MODE, […]
The desktop Office apps are more powerful than their Online counterparts, but the current release doesn’t support the real-time co-authoring that helps us collaborate. Luckily, you can opt into the “Fast Insiders” version that enables this key feature. While it’s technically an unsupported release, feedback from users so far is that it’s stable and gets […]
At the end of October, we noticed that many students had very few files in their OneDrive. The percentage of students with fewer than six files in their OneDrive reached as high as 66% for some grade levels. Since OneDrive use is critical for students’ abilities to create and collaborate, the English and Chinese departments […]
If you’re using OneNote Class Notebooks, you’ll be pleased to learn that you can mass-generate private links for parents to see the notebooks of their children: This will let you and the students share evidence of their learning with parents without letting them change anything in the notebooks. You can use an e-mail merge to send out […]
A great feature of the OneDrive sync client is that it lets you sync your group files to your laptop. But you may not want to sync all the files in your groups or individual OneDrive, for example to save hard drive space. In these cases, you can choose the folders you want to sync: […]
Sway is an app in Office 365 that we haven’t covered here before, but it’s worth checking out. It goes beyond Powerpoint by letting you create online presentations/websites that look great on mobile phones and computers. This means that Sway goes great with QR codes. We tried this out at the recent Student Leadership Summit, where […]
Yes, the best way to create forms is to first go to your individual or group OneDrive and click the + New button, then choose Forms for Excel: This creates an Excel workbook in your OneDrive that you can use the share the results with collaborators. You’ll notice a new Forms button in the toolbar: […]