February 2020 – Kent Matsueda

Troubles with O365 Permissions and OneNote

Jon was having issues with not being able to edit pages in our team’s OneNote notebook. He reminded me that we dealt with something similar when he first started working here and that I was able to fix that issue pretty quickly, but something must have changed since then because those pages are a subset of the larger notebook that we’re now having issues with.

We believe we have a working solution: SharePoint > Site Contents > Site Assets > Options > Share > Who would you like this link to work for? Specific People > Apply > [add email address] > Send.

This appeared to work for his laptop and iPad when accessing OneNote using the web interface, not the native apps. Hopefully this is the solution we’re looking for. We’ll know in our upcoming Weekly Office Meeting.

I tried a slightly different approach that worked temporarily, but didn’t lead to a permanent fix: SharePoint > Site Contents > Site Assets > Options > Manage access > adjust permissions to “Can edit.”

Video Copyright and Licensing for Instructional Designers Training

I attended an online training, “Copyright for Instructional Designers” (scroll down the page) provided by Ana Enriquez on the very complex topic of copyright when it comes to video content, but not limited to just video.

My main take-aways:

Contact Ana (aee32@psu.edu) or Brandy Karl (bak25@psu.edu) with questions
Do your due diligence to follow the laws while working on a project for PSU, there may be some protections under PSU Policy IP05 but don’t count on it because there is some specific language about “system users”
There are three sections of Copyright law that we use
- Fair Use (107)
- Classroom use (110-1)
- TEACH Act (110-2)
We only need to qualify for one of these sections, not all three
The laws may not and do not make common sense, but that’s not important, what is important is to try and understand how they work – and this is why I am not a lawyer

Truncating text in Smartsheet

I’m trying to figure out how to truncate characters from a cell but am having troubles.

For most of the data, it’s easy.

ex. “13: FA16” with the function

=RIGHT([Launch Semester]@row, 4)

yields “FA16” which is exactly what we’re looking for.

However, some of the cells have additional data like “00: Unknown” and returning the last 4 characters, “nown” isn’t useful.

So, I’ve tried this formula

=RIGHT([Launch Semester]@row, LEN([Launch Semester]@row – 4))

based on this article and I’m getting an error, “INVALID OPERATION.” The problem is, I don’t know if I’m getting this error because I’m using tutorial information for Excel or if it’s because I’ve messed something up.

I believe it is the LEN formula because when I use the formula below, I still get the error

=LEN([Launch Semester]89 – 4)

But when I change it to this, I do get the right number!

=(LEN([Launch Semester]@row)) – 4

And there we go… here’s the working formula:

=RIGHT([Launch Semester]@row, (LEN([Launch Semester]@row)) – 4)

Now, “00: Unknown” returns “Unknown” which is exactly what we’re looking for.

Digital Pedagogy Video Guide Presentation

April Millet and I have been asked to present at the Feb 12 Faculty Development series being hosted by the Schreyer Institute for Teaching Excellence. Chris Gamrat has been working with others to plan these faculty development sessions at various locations around University Park. I the sessions are also being shared and recorded via Zoom.

April and I will be discussing the pedagogical applications of video. We worked together to build an online resource for the University.

INSTRUCTIONAL VIDEO GUIDE: Best practices for creating pedagogically appropriate video – https://instructionalvideoguide.psu.edu/