The Black Box Theatre is open for business! Reserve this space for your classes through your Outlook calendar, just like any other meeting space on campus. Katrina walks you through it in the video below.
It’s easy to add a simple countdown timer to your PowerPoints:
This tip works when you’re using the Powerpoint Mac app, but not in the Online version through the web browser.
Microsoft’s Translator app has the potential to transform how we do parent-teacher communication at this school. It has interpretation features that translate spoken or typed text in real time! While it won’t replace a real-life interpreter, it’s handy in situations like SLCs when there isn’t one on hand. Better parent-teacher communication means more parent buy-in and involvement, resulting in better student achievement.
Watch how it works below.
Sending emails home about Incompletes or Not Yets doesn’t have to be a chore. Learn how you can mostly automate the process in less than ten minutes by watching the guide above (NCPA login required due to presence of student information).
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 people at the same time. Note that the other users ALSO need to be on the latest version if they are also using the Mac apps.
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, SUM
- LEFT, RIGHT, MID – take X characters from the left, middle, or right of a cell
- SUMIF, AVERAGEIF
- SUMIFS, AVERAGEIFS
- UPPER, LOWER – convert a cell to upper or lower case
We also learned about these Excel features:
- Inserting columns and rows
- Filtering and sorting (under the Data tab) to make large spreadsheets easier to read
- Splitting into columns by delimiter use Text to Columns, also under the data tab
- Freeze panes to make a row and/or column always show, even when you scroll right or downHide columns/sheets
- Filling by dragging the square in the bottom-left of a cell
- Dollar sign use in formulas to use an absolute reference to a cell
- When you begin typing a formula, Excel will show a pop-up explaining the syntax you need to follow
Finally, we used VLOOKUP to automatically retrieve information about students based on a key value, such as their student ID number.
Contact Matt directly to get the practice workbook.
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 rid of those “locked for editing” errors that happen when multiple users use the regular desktop apps.
Get instructions on signing up direct from Microsoft’s support site: https://products.office.com/en/office-insider?tab=Mac#Tabs_section
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 collaborated with Matt K to create a 15-minute lesson on syncing with OneDrive, using the Outlook app on phones, and accessing the school calendar at community.ncpachina.org.
As of November 29, OneDrive use has climbed steadily due to most students using the OneDrive sync client to store and back up files from their Macbooks to OneDrive:
% of students not actively using OneDrive (have <6 files)
|Grade||Oct 24||Nov 29|
We hope this is making it easier for students to collaborate and work productively in your classes. Thanks again to the courses and teachers in the Chinese and English departments who contributed their instructional time to make it happen!