Hacks
Spreadsheet Commands
Average -Returns the numerical average value in a dataset, ignoring text.
Arrayformula - copies cells from one sheet to another sheet or region
Concatanate - ties together strings
Count - Returns a count of the number of numeric values in a dataset.
Countif - count based upon a given parameter
Importrange - note, the URL of the second spreadsheet must be in quotes; the range must be in quotes
Max - Returns the maximum value in a numeric dataset.
Median - Returns the median value in a numeric dataset.
Min - Returns the minimum value in a numeric dataset.
Query - =query('1'!A:K,"select C,D,B,E,F,G,H,I,J,K where I='criteria'",1)
Subtotal - Use with filters to get subtotals and summaries of subsets;
1 is AVERAGE
2 is COUNT
3 is COUNTA
4 is MAX
5 is MIN
6 is PRODUCT
7 is STDEV
8 is STDEVP
9 is SUM
10 is VAR
11 is VARP
Hidden values can be skipped for any of these codes by prepending 10 (to the single-digit codes) or 1 (to the 2-digit codes)
Sumif - conditional sum
Subscripts and Superscripts - copy unicode
Transpose - exchanges rows and columns
Duplicates: =COUNTIF (D:D, D1)>1.
Airserver
Streaming content to your instructor computer
Note: To use AirServer or similar software, the mobile device and the computer must be on the same newtwork. At CSUN, this network is eduroam. You must sign in with your email as your login. Ernie Perez (ernie.perez@csun.edu) must be notified to call Jeff Fisher to make each room open to specific users. See also teaching untethered.
Keyboard shortcuts
Youtube
Downloading Youtube videos - To download YouTube Video: Go to Youtube video. Click on URL. Delete all characters prior to the "Y" in Youtube. Type ss before the "Y" and hit enter
View in HD - to get full size, add this to the end of the link: &hd1
Prevent suggested videos:
this is the URL they give you. http://www.youtube.com/watch?v=P5rlrh6RY6c
Do the following: remove watch?v=. Replace with v/
Example: http://www.youtube.com/v/P5rlrh6RY6c
Add &rel=0 to block related videos
Therefore, the final URL would be: http://www.youtube.com/v/P5rlrh6RY6c&hd1&rel=0
Playing a portion of a video
to your video link add &t=xmys where x=time in minutes and y=time in seconds
or it looks like you can also do &start=(time in seconds)&end=(time in seconds)
Special Characters
Opening Google Docs
Share a clutter-free view of your document
→ Replace /edit with /preview
Force others to make a copy before viewing your document
→ Replace /edit with /copy
Force others to make a copy that includes comments from the original before viewing your document
→ Replace /edit with /copy?copyComments=true
Share an easy-to-copy preview of your document
→ Replace /edit with /template/preview
Share a direct download of a PDF version of your document
→ Google Docs & Sheets: Replace /edit with /export?format=pdf
→ Google Slides & Drawings: Replace /edit with /export/pdf
Start a presentation
→ Replace /edit with /present
Inserting Images from Google Drive
Make sure that all photos are in folders in Google Drive
Set the permissions of each the main photo folder(s) to public
Title each photo with a descriptive title
On a webpage in Google Sites, select Insert/Drive/Images
Search of the photo by the name you have given it
Insert photo. If it shows up on your screen, AND if the photo folder permissions are set to public, others will be able to view it.
Use only the Insert / Google Drive / Image function or copying the URL of the actual photo from Google+ images. DO NOT use the URLs provided in Google Drive as they are transient and won't work lat
Microsoft 365 Server Limits - CSUN email
Max: 500 emails in a single message
10,000 per day
Zoom
Feedback - Feedback happens when you use the iPad with the computer on Zoom.
The problem is that Zoom now automatically connects you to audio. Click on the More menu, scroll ALL THE WAY DOWN - to Disconnect from Audio!!
Your profile photo will not show up on other people's zoom if you are a "guest". Do not login from the weblink. Open the Zoom App, and then paste the link in and use the pass code. Then your profile photo will show.
Command(⌘)+Control+M: Mute audio for everyone except the host (only available to the host)
Command(⌘)+Control+U: Unmute audio for everyone except host (only available to the host)
Command(⌘)+U: Show/hide participants panel
Command(⌘)+Shift+H: Show/hide in-meeting chat panel
Control+Option+Command+H: Show/hide floating meeting controls