Online Training Best Practices - Revision history

DDlugiewicz56 at 23:34, 12 May 2020

2020-05-12T23:34:05Z

← Older revision		Revision as of 19:34, 12 May 2020
Line 13:		Line 13:
	Text Editor		Text Editor
	Ability capture a chat window on Google Meets, Zoom etc		Ability capture a chat window on Google Meets, Zoom etc
	# Create a copy of a spreadsheet that has the class information (CAPID/Name etc) It could be something like ~~this~~:<br>		# Create a copy of a spreadsheet that has the class information (CAPID/Name etc) It could be something like these columns:<br>
	Day1 Day 2 Other1 Other2 Other 3 Name Last Name CAPID Email		Day1 Day 2 Other1 Other2 Other 3 Name Last Name CAPID Email
	# Create ~~another sheet~~ and name it attendance		In each of these columns row 2, put this formula =IF(ISNA(VLOOKUP(I2,'Day1'!$A$1:$A$55,1,FALSE)), "No", "Yes") (I2 is the capid, 'Day1' is the first sheet, $A$1:$A$55 (assumes not more than 55 name)
			Copy to day2, other1, other 2 etc and the only change you need is to set it to I2 (if that's the CAPID) and the right sheet name)
			Copy all those columns down to the bottom
			Highlight the day1 to otherxx, and do a conditional formatting, if cell value="No" change it to red

			# Create other sheets and name it day1, day2, other1, other 2 (depends how many times you want to do attendance)
	# In chat, put a note similar to this -- Please put just your CAPID and nothing else in chat		# In chat, put a note similar to this -- Please put just your CAPID and nothing else in chat
	# Copy from the line you put to the end of the CAPIDS		# Copy from the line you put to the end of the CAPIDS
	# Paste into a text editor (not necessary but it helps)		# Paste into a text editor (not necessary but it helps)
	#		# Copy into column A of day1, day2 etc.
			# Sort
			# delete any lines that are not CAPID

DDlugiewicz56 at 23:20, 12 May 2020

2020-05-12T23:20:03Z

← Older revision		Revision as of 19:20, 12 May 2020
Line 10:		Line 10:
	===== Taking Attendance for a Class=====		===== Taking Attendance for a Class=====
	# Tools needed:<br>		# Tools needed:<br>
	* Excel or Google Sheets (or some other spreadsheet)		Excel or Google Sheets (or some other spreadsheet)
	* Text Editor		Text Editor
	* Ability capture a chat window on Google Meets, Zoom etc		Ability capture a chat window on Google Meets, Zoom etc
	# Create a copy of a spreadsheet that has the class information (CAPID/Name etc) It could be something like this:<br>		# Create a copy of a spreadsheet that has the class information (CAPID/Name etc) It could be something like this:<br>
	Day1 Day 2 Other1 Other2 Other 3 Name Last Name CAPID Email		Day1 Day 2 Other1 Other2 Other 3 Name Last Name CAPID Email
	# Create another sheet and name it attendance		# Create another sheet and name it attendance
	#		# In chat, put a note similar to this -- Please put just your CAPID and nothing else in chat
	# ~~Numbered list item~~		# Copy from the line you put to the end of the CAPIDS
			# Paste into a text editor (not necessary but it helps)
			#

DDlugiewicz56: /* Taking Attendance for a Class */

2020-05-12T22:45:30Z

Taking Attendance for a Class

← Older revision		Revision as of 18:45, 12 May 2020
Line 13:		Line 13:
	* Text Editor		* Text Editor
	* Ability capture a chat window on Google Meets, Zoom etc		* Ability capture a chat window on Google Meets, Zoom etc
	# ~~Numbered list item~~		# Create a copy of a spreadsheet that has the class information (CAPID/Name etc) It could be something like this:<br>
			Day1 Day 2 Other1 Other2 Other 3 Name Last Name CAPID Email
			# Create another sheet and name it attendance
			#
	# Numbered list item		# Numbered list item

DDlugiewicz56 at 22:39, 12 May 2020

2020-05-12T22:39:14Z

← Older revision		Revision as of 18:39, 12 May 2020
Line 8:		Line 8:
	=== Techniques ===		=== Techniques ===
	=== How to's ===		=== How to's ===
			===== Taking Attendance for a Class=====
			# Tools needed:<br>
			* Excel or Google Sheets (or some other spreadsheet)
			* Text Editor
			* Ability capture a chat window on Google Meets, Zoom etc
			# Numbered list item
			# Numbered list item

DDlugiewicz56: /* Software Options */

2020-05-12T18:56:39Z

Software Options

← Older revision		Revision as of 14:56, 12 May 2020
Line 1:		Line 1:
	== Online Training Best Practices ==		== Online Training Best Practices ==
	=== Software Options ===		=== Software Options ===
			This is very similar to the remote operations software
			==== Google Classroom ====
			==== Zoom ====
			==== Teams ====

	=== Techniques ===		=== Techniques ===
	=== How to's ===		=== How to's ===

DDlugiewicz56: Created page with "== Online Training Best Practices == === Software Options === === Techniques === === How to's ==="

2020-05-12T18:54:21Z

Created page with "== Online Training Best Practices == === Software Options === === Techniques === === How to's ==="

New page

== Online Training Best Practices ==
=== Software Options ===
=== Techniques ===
=== How to's ===