Replacement Plan in Smartsheet

Our leadership is looking at better documentation around Replacement Planning and while we have a lot of the data in existing Smartsheets, I need to work with others to better communicate that data.

Ultimately, we want to share who’s working on what project and who others can go to for “leadership” and “project” backups in the event that the principle is unavailable. In this time of COVID-19, we have determined that it may be necessary to document up to three backup tiers for each project.

Initially, the difference between a “leadership” and “project” backup needed to be defined. Someone identified to provide leadership backup would be expected to know how to get answers related to a specific project but they themselves may be unable to complete the work or task. The person identified as a project backup would be able to accomplish the work that would yield answers to those questions.

The next big hurdle was to determine how to combine information from at least three different Smartsheets and using the Dashboard feature, we will be able to combine that information. We’re starting off with one sheet as the master that will establish the basic style (column names and widths) for the data. A second sheet was edited by changing some of the existing column names and adding new ones. A third sheet is going to prove more difficult. We need to preserve the original column names and will not be able to add more columns to that existing sheet as we had done in the second sheet.

I have decided to create a secondary sheet that pulls in that information using index and match functions and then other formulae to remap that data into columns that we are using in the other two sheets.

Fire drill fiasco?

We just had to evac IST and objectively speaking, there are a number of issues I think we need to address (not necessarily in any order).

  1. We have to update the safety monitors for each section of the building. A lot of us just went through office moves and our responsibilities may have changed since then.
  2. We have to update everyone about meeting points, shelter spots, and how to manage students.
  3. We need to figure out a plan for the bridge. When is the bridge closed? How do we close off traffic? What about the street traffic? I know we cannot do anything legally about the street traffic, but that is a serious vulnerability as well.
  4. We need 2-way comms between safety monitors. Instant communication among the entire group and independent of cellphone towers.
  5. We may need to consider emergency lighting in the building. I just took a look around and I didn’t see a thing.
  6. We may need to be clear about egress routes and temporary signage for elevators.
  7. We need to make sure all faculty and staff know about evacuating the building when the alarm goes off.
  8. We need a way to inform people about when it is OK and not OK to enter the building.
  9. As the SAC represents different areas, the safety monitors should be responsible for informing their respective areas of any changes or reminders of what to do in threat situations. Our goal should be to develop an aware and able individual, not allow a sheep-mentality that looks to authority for well being.
  10. What happens after 5 PM? Who’s around to assist the students then? Perhaps we should assess and determine the preparedness of the students as a whole.
  11. What about coordinating with EECS on the other side of the building?

I should mention that I am one of the safety monitors, or at least I was before my office move, so much of this is my responsibility. Ultimately, we have a whole program in Security and Risk Analysis here at the College. It would be a shame to have something happen and not be as prepared as we could have been.

I don’t want to sound entirely negative. Lisa Ammerman and Peggy Stanton have done a great job organizing the safety monitors on our side of the building and we’ll continue to look to them for future leadership.

OIDI Staff Meeting

SRA 111 SU12 David Saab – coordinated fixes to lab documents with John F and David S, final checks for course launch going on nowGoogle Docs Automatic Backup (more info) – pending IST Helpdesk software install, currently being manually backed…

  • SRA 111 SU12 David Saab – coordinated fixes to lab documents with John F and David S, final checks for course launch going on now
  • Google Docs Automatic Backup (more info) – pending IST Helpdesk software install, currently being manually backed up at: filesdepartmentsoidigoogledocsarchive
  • I’ve added a new Google Doc in “Team Projects” folder: “Smartbuilder Branching Project” (see last meeting “active shooter game”) – potential basis for a new project using Smartbuilder to see how this tool works.
  • 3PlayMedia Estimates (see “3PlayMedia Assessment” GDoc) for courses – update > in progress > tallying media (will need assistance from students to expedite, Footnote ticket has been submitted), when is this due?
  • Packet-Switching simulation update – awaiting meeting with Ed about outcomes and assessments for the simulation; testing Storify (tool for aggregating and archiving tweets), Twitterfall (tool for visualization and aggreggation of tweets) to track hashtags–critical for feedback on progress and reflection

Weekly Activity Report (WAR) 9

This is the last foreseeable WAR that I’ll be posting on my ePortfolio. This document was something that was requested by a former director. At this point-in-time, I plan on using my Google Site and this ePortfolio to keep…

This is the last foreseeable WAR that I’ll be posting on my ePortfolio. This document was something that was requested by a former director. At this point-in-time, I plan on using my Google Site and this ePortfolio to keep track of projects and reflect on my work.

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

Weekly Activity Report (WAR) 8

Kent Matsueda’s 8th WAR Report for 1/16-1/18 1Accomplishments 2IST 515 2Ongoing Projects 2Ravi’s courses 2SRA 111 4vLabs availability for WC students 4Immediate Decisions / Issues 4Bug List 4Scheduling Events with non-IST individuals [WAR 7] 4WARs vs. Google Sites vs. ePorfolio…

Kent Matsueda’s 8th WAR Report for 1/16-1/18    1
Accomplishments    2
IST 515    2
Ongoing Projects    2
Ravi’s courses    2
SRA 111    4
vLabs availability for WC students    4
Immediate Decisions / Issues    4
Bug List    4
Scheduling Events with non-IST individuals [WAR 7]    4
WARs vs. Google Sites vs. ePorfolio (Blog) [WAR7]    5
ScreenFlow Alternative: A better FMV Screencasting option needed [WAR5 and WAR7]    5
Posting Documents Online [WAR4 and WAR 7]    5
Audio-loop back recording [WAR4, WAR5, WAR 7]    6
VNC access to my Mac at home [WAR 7]    6
Back Burner    7
Days off / Conferences    7
Notes to “self”    7
Identify sources of best practices related to research on optimal video content length    7
Literature    7

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file

Weekly Activity Report (WAR) 7

Kent Matsueda’s 7th WAR Report for 1/5-1/11 1Accomplishments 2Undergrad Courses – RDC vs. VNC 2IST 515 2SRA Courses – Cyber Protect game 3Liberal Arts Scholarship and Technology Summit 3Going the Distance: Online Education in the United States, 2011 4Meeting with…

Kent Matsueda’s 7th WAR Report for 1/5-1/11    1
Accomplishments    2
Undergrad Courses – RDC vs. VNC    2
IST 515    2
SRA Courses – Cyber Protect game    3
Liberal Arts Scholarship and Technology Summit    3
Going the Distance: Online Education in the United States, 2011    4
Meeting with Dean Hall    4
Ongoing Projects    4
Ravi’s courses    4
SRA 111    4
Immediate Decisions / Issues    5
Back Burner    5
Days off / Conferences    5
NEW – Bug List    5
Posting Documents Online (WAR4)    5
ScreenFlow Alternative: A better FMV Screencasting option needed (WAR5)    5
Scheduling Events with non-IST individuals    6
WARs vs. Google Sites vs. ePorfolio (Blog)    6
VNC access to my Mac at home    7
Audio-loop back recording (WAR4 and WAR5)    7
Notes to “self”    7

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file

Weekly Activity Report (WAR) 6

Kent Matsueda’s 6th WAR Report for 1/3-1/4 1Accomplishments 2IST 515 2SRA 111 MS Project Timeline 3Ongoing Projects 3Ravi’s courses 3SRA 111 4Immediate Decisions / Issues 5Back Burner 5Days off / Conferences 5NEW – Notes to “self” 6Subversion 6Holiday Hours 6iOS…

Kent Matsueda’s 6th WAR Report for 1/3-1/4    1
Accomplishments    2
IST 515    2
SRA 111 MS Project Timeline    3
Ongoing Projects    3
Ravi’s courses    3
SRA 111    4
Immediate Decisions / Issues    5
Back Burner    5
Days off / Conferences    5
NEW – Notes to “self”    6
Subversion    6
Holiday Hours    6
iOS App Development    6

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file

Weekly Activity Report (WAR) 5

Kent Matsueda’s WAR Report for 12/5-12/19 1Accomplishments 2SRA 111 MS Project Timeline 2IST 402 PennTAP 2PennTAP Kick-off with Greg 2Capturing “loop-back” audio in Captivate 2Labsim Demo 22012 TLT 3NMC Learning Analytics Online Workshop 3Voice Recognition/Transcription 3Ongoing Projects 3Ravi’s courses 3IST…

Kent Matsueda’s WAR Report for 12/5-12/19    1
Accomplishments    2
SRA 111 MS Project Timeline    2
IST 402 PennTAP    2
PennTAP Kick-off with Greg    2
Capturing “loop-back” audio in Captivate    2
Labsim Demo    2
2012 TLT    3
NMC Learning Analytics Online Workshop    3
Voice Recognition/Transcription    3
Ongoing Projects    3
Ravi’s courses    3
IST 515    4
SRA 111    4
Immediate Decisions / Issues    5
Back Burner    5
Days off / Conferences    5

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file

Weekly Activity Report (WAR) 4

Kent Matsueda’s WAR Report for 12/8-12/14 1Accomplishments 2Publishing PDF’s to the Web 212/8/11 New Century Presentations 2Captivate Templates for IST 515 2Closed Captioning in YouTube 3SRA 111 MS Project Timeline 3Ongoing Projects 3Lynda.com 3Ravi’s courses 3IST 515 3SRA 111 5General…

Kent Matsueda’s WAR Report for 12/8-12/14    1
Accomplishments    2
Publishing PDF’s to the Web    2
12/8/11 New Century Presentations    2
Captivate Templates for IST 515    2
Closed Captioning in YouTube    3
SRA 111 MS Project Timeline    3
Ongoing Projects    3
Lynda.com    3
Ravi’s courses    3
IST 515    3
SRA 111    5
General Pipeline Discussion    5
Immediate Decisions / Issues    5
Capturing “loop-back” audio in Captivate    5
Back Burner    6
Games, Sims, and Virtual Worlds    6
Days off / Conferences    6

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file

Week 4 @ IST (WAR3)

Kent Matsueda’s WAR Report for 12/1-12/7 1Accomplishments 2MT4 Mobile Edits 2Voicethread Mobile App 212/2 LD Community Meeting: 21st Century ID 2Department Resources 2Ravi’s courses 3Flash training 3Ongoing Projects 4SRA 111 Kick-off 4General Pipeline Discussion 4Immediate Decisions / Issues 4Flash in…

Kent Matsueda’s WAR Report for 12/1-12/7    1
Accomplishments    2
MT4 Mobile Edits    2
Voicethread Mobile App    2
12/2 LD Community Meeting: 21st Century ID    2
Department Resources    2
Ravi’s courses    3
Flash training    3
Ongoing Projects    4
SRA 111 Kick-off    4
General Pipeline Discussion    4
Immediate Decisions / Issues    4
Flash in Drupal    4
Publishing PDF’s to the Web    4
Back Burner    5
Games, Sims, and Virtual Worlds    5
Days off / Conferences    5

It appears your Web browser is not configured to display PDF files. No worries, just click here to download the PDF file.

click here to download the PDF file