![DoIT Training at Stony Brook University](/img/default-banner.jpg)
- Видео 493
- Просмотров 2 516 267
DoIT Training at Stony Brook University
США
Добавлен 25 июл 2012
Welcome to Stony Brook University's DoIT Training videos. Find helpful videos for learning and using software and hardware at Stony Brook University. Browse our videos and playlists.
Working with Excel Files in Google Workspace via Gmail and Drive
Google Sheets is a powerful spreadsheet tool, but sometimes you or your collaborators want to work with Excel. There are actual several ways to use Excel with Google.
Slides: docs.google.com/presentation/d/1jL53-yq6WKhHJK5Y2q_WmOxiKv91huZaB_mf0J6aStY/edit?usp=sharing
0:00 Intro
0:22 Save Excel Gmail attachments to Google Drive
1:23 Open Excel files in Google Sheets
2:25 Email an Excel version of your file from Google Sheets
4:11 Open Google-Drive stored Excel files in Excel
5:53 Clean up unneeded Excel files
Tip: If you don’t see Microsoft Excel.app as an option under Open with, install Google Drive for desktop (support.google.com/drive/answer/7329379) and Application Launcher extension (chrome....
Slides: docs.google.com/presentation/d/1jL53-yq6WKhHJK5Y2q_WmOxiKv91huZaB_mf0J6aStY/edit?usp=sharing
0:00 Intro
0:22 Save Excel Gmail attachments to Google Drive
1:23 Open Excel files in Google Sheets
2:25 Email an Excel version of your file from Google Sheets
4:11 Open Google-Drive stored Excel files in Excel
5:53 Clean up unneeded Excel files
Tip: If you don’t see Microsoft Excel.app as an option under Open with, install Google Drive for desktop (support.google.com/drive/answer/7329379) and Application Launcher extension (chrome....
Просмотров: 1
Видео
Brightspace: Automatic Zero for Missing Submissions Option (New Feature!)
Просмотров 7214 дней назад
Use the new Automatic Zero for Missing Submissions Option to automatically give a zero to assessments without submissions at the due date. See to enable this feature and what it looks like for learners and instructors when there is an automatic zero. #brightspace #brightspacegrading #D2L #LMSgradebook
Brightspace Gradebook 1: Setting up Your Brightspace Gradebook with the Setup Wizard Tool
Просмотров 21714 дней назад
Learn how to set up your Gradebook in Brightspace and how the new Automatic Zero option (community.d2l.com/brightspace/kb/articles/26156-about-automatic-zero-grading-for-missing-submissions) works. 0:00 Intro 0:16 Navigate to your course 0:25 Navigate to Grades Setup Wizard 1:13 Choose grading system 2:11 Choose which final grade to release 3:01 Grade Calculations 3:49 NEW Automatic Zero 4:18 D...
How to Update Brightspace Notification Settings
Просмотров 8014 дней назад
How to Update Brightspace Notification Settings
Protecting Sheets and Ranges in Google Sheets
Просмотров 38Месяц назад
Protecting Sheets and Ranges in Google Sheets
New! Google Sheets Tables: Organize, Group, Filter, and Share Data EASILY
Просмотров 2062 месяца назад
Google Sheets now has Tables! -Organize your data -Easily create (and share!) grouped and filtered views -Repeat -Celebrate 🎉 #googlesheets #spreadsheet #googlenewupdate #tables
Google Sheets: Tables to Organize Data (New Feature!)
Просмотров 1182 месяца назад
Google Sheets now has Tables, which help organize and beautify your data. Copy Demo sheet to follow along: docs.google.com/spreadsheets/d/1Sn1RhVnbs_fijR3XvAvt7aOuyt9C7asVh4fKnsfvcds 0:00 Intro 0:11 Create table from existing data 0:22 Create table from scratch with a template 0:52 Set column type 1:29 Use dropdowns 2:47 Customize table 3:41 Group by views 5:18 Filter views 6:20 Tables and form...
Google Sheets: Email Merge To Send Custom Attachments With a formula
Просмотров 1062 месяца назад
Use vlookup to send quasi-custom attachments using mail merge. If there's a column value you can use to find the right attachment from a list, this formula will help making mail merge emails even more customized and helpful. More on vlookup: docs.google.com/presentation/d/1eEvRc7j9nZY_pG4xAPAfyrqPeWDXxJyH34-dYFy5ZM8 More on email merge: docs.google.com/presentation/d/1S8TWRNIa_VrLIz5UJb-HOVp4VA...
Google Sheets: Pivot Tables to Summarize Data in a few clicks in Google Sheets
Просмотров 2202 месяца назад
Have a spreadsheet you need to summarize data for? Learn to use Google Sheets Pivot Tables to quickly summarize data to see total numbers by department, project status, or any repeated value in your data. Demo sheet (make a copy to follow along): docs.google.com/spreadsheets/d/1wTDINTKRNZCXL_t_LOYfZzhG4mgzcnzZjnSY4giRdgc 0:00 Intro 0:17 Sort sheet (to count number of each word) 0:53 Create Pivo...
Using AI to Improve Emails that Require Action
Просмотров 573 месяца назад
Watch as I use AI to rewrite an email inviting people to register for technology workshops. 0:00 Intro 0:23 Email with 70% better performance! 1:16 Get general tips for better emails from AI 2:20 Identify the goal of the email 3:27 Use AI to improve parts of your email
Using Grade Schemes in Brightspace
Просмотров 2224 месяца назад
00:00 What are Schemes? 00:34 Creating a Scheme 05:31 Apply a Scheme to Individual Grade Items 06:25 Apply a Scheme to an Entire Gradebook 07:06 Copying Schemes to Other Courses
Brightspace Common Gradebook Issues #5 How Can I Reorder My Gradebook
Просмотров 1015 месяцев назад
Brightspace Common Gradebook Issues #5 How Can I Reorder My Gradebook
Brightspace Common Gradebook Issues #4 What Are These Icons in My Gradebook
Просмотров 885 месяцев назад
00:00 Intro 00:20 Eyeball with Slash Icon in Manage Grades 00:59 Clock Icon 01:57 Star Icon 02:43 Exclamation Point Icon 03:30 Question Mark Icon in Manage Grades 04:06 Roundabout Icon 05:06 File in a Bin, Speech Bubbles, and Question Mark in Square Icons 05:50 Open Eyeball or Eyeball with a Slash Icon in Enter Grades Releasing Final Grades Article: it.stonybrook.edu/help/kb/releasing-final-gra...
Brightspace Common Gradebook Issues #3 Why Are My Students Not Seeing Their Grades
Просмотров 965 месяцев назад
00:00 Intro 00:14 Preview Grades as a Student 00:48 Are Your Grade Items Linked? 03:39 Are Your Grade Items Hidden? 05:21 Have You Checked Your Quiz Settings? 06:36 Have You Checked Your Final Grades Settings? Releasing Final Grades and Changing Final Grade Settings: it.stonybrook.edu/help/kb/releasing-final-grades-in-brightspace
Brightspace Common Gradebook Issues #2 Deleting Grade Items That Won't Go Away
Просмотров 745 месяцев назад
Brightspace Common Gradebook Issues #2 Deleting Grade Items That Won't Go Away
Brightspace Common Gradebook Issues #1 Grade Weight Error Messages
Просмотров 1095 месяцев назад
Brightspace Common Gradebook Issues #1 Grade Weight Error Messages
Google Sheets: Data Extractions- Pull Date Last Modified, Who Last Modified and More Into Sheets
Просмотров 2816 месяцев назад
Google Sheets: Data Extractions- Pull Date Last Modified, Who Last Modified and More Into Sheets
Broadcast Messages to Zoom Breakout Rooms
Просмотров 1006 месяцев назад
Broadcast Messages to Zoom Breakout Rooms
Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data
Просмотров 1776 месяцев назад
Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data
Grading Exams/Quizzes in Brightspace
Просмотров 2656 месяцев назад
Grading Exams/Quizzes in Brightspace
Quiz Settings & Enabling Respondus in Brightspace
Просмотров 1626 месяцев назад
Quiz Settings & Enabling Respondus in Brightspace
Google Sheets Query: GROUP BY to Organize Results by a Column
Просмотров 1,7 тыс.6 месяцев назад
Google Sheets Query: GROUP BY to Organize Results by a Column
Google Sheets: Removing Empty Rows from =Query() Results
Просмотров 9776 месяцев назад
Google Sheets: Removing Empty Rows from =Query() Results
Mini Byte: Microsoft Co-Pilot AI Enterprise
Просмотров 376 месяцев назад
Mini Byte: Microsoft Co-Pilot AI Enterprise
Im trying to use OnBase to scan some files but every time I click on Acquire, it wants to use my laptops camera for some reason. Any suggestions?
🍒🌻This version of the cheat is already old, the new version of the cheat with anti-ban is already on my channel🎤👾
🌟🎉This version of the cheat is already old, the new version of the cheat with anti-ban is already on my channel🔥💥
I am learning Brightspace. This was helpful.
Thank you!!!
Hi! Thank you for the useful idea, just a question can we do as button like add file, will instead of add file i will use download button? is it possible not a link.
thanks so much! trying to find a solution for that
Why don't I see 'move to' ?
This was super helpful thanks! I'm using it to create a free database for my landscaping business employees, to help them better remember addresses
nice
Thank you ❤
Thank you. You solved my problem with a 6 1/2 year old video. :)
Great video. What if my survey has been active and I want it to load all and future responses into a google sheet?
you can't bring previous responses through this tool. You can, however, export that data and manually paste it into the sheet your new responses come into: www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/export-data-overview/
Are there any options for sharing zoom polls between instructors? ie, if user A creates Poll A, is there a way for user A to the send the Poll A questions to User B for them to use in their own zoom meetings?
I have the same question. I create polls and quizzes and want the other instructors to use them w/o recreation.
Unfortunately no, at this time polls and quizzes are tied to one account and cannot be transferred or shared with another user.
why my gmail 3 dot..dont have foward as attachment?
Thanks for the info. OK I think I understand now (time will tell)!
thank you
This is an amazing video - it will be so much easier writing my dissertation now that I understand how to do this
Is there a way to add a link into the description? I added the link on the spreadsheet but it didn't import over.
If you use html markup on the link in the description field, it will import as a link. instead of google.com use <a href="google.com">Learn more here</a> where the link in " " after href is the link and the words between > and </a> is the text you want hyperlinked
Thanks so much!
What if I have the address listed in another column, is there a way to pull that over into the smart chip automatically?
So far as I know, there's currently no way to do that
I would love to go to next question instead
This is the default - no need to use this feature if you want users to go to the next question
Is it possible to only choose specific columns and rows. . Eg: in the above video i need values of A12,13 and B12, 13 into a separate table
check out the query formula ruclips.net/p/PL6Xrs39_KA2bpNJGr8TFCAZkwCJnmtsuF, perhaps used in conjunction with importrange
@@DoITTrainingSBU thankq so much...
Thanks a bunch for this! so useful
This was awesome. Easy to follow instructions for anyone to follow. Thank you..!!
Informative video works for me 🔥🔥
I wanted to gray out cells of a column regarding of the contents of another column and this helped me to do that Thanks for the Tutorial
I saw this link recently, but I was pulling my hair out to find it again. Thanks!
Very good. I have been working on a form since January to get exactly what I wanted from it. Everything was pointing to using all these different apps that our district does not have access to. This video just solved my problem. Thank you!
Is it possible to create a list with labels? I would like a list that has label for example: Type A : 1, Type B : 2, Type C : 3 So the list will look like above, but once selected, only the value will be displayed because I need those value to make further calculations. Is it possible?
thx!
Great!
Really helpful, thank you!
I can't find timeline tabe on google sheet . could you pls guide me?
Your Google Account likely doesn't have this feature - it's currently only in some Workspace Accounts: support.google.com/docs/answer/12935277?hl=en#zippy=%2Cthese-workspace-editions-can-use-timeline-view
I LOVE this! Thank you! In my case, I assign my team or the client to a task in a list of task...I have several tabs representing different types of activities...how do i use this to put the selected client tasks from the different tabs in one "Assigned to Client" list for the client to reference and complete? And same for tasks across all tabs "Assigned to Team?" PLEASE PLEASE PLEASE HELP!
I find it easier to have one master sheet and separate out from there (rather than having disparate sheets and trying to bring them together). Get your data in one sheet and then use filter views ruclips.net/video/15sjPLLsP4g/видео.html to create separate Editable views of the data, one view for each Client. This is the only way to make separate editable views :)
Hi thank you so much for your video, it's really helpful. One question: Can we the Timeline combine the information of 2 tabs or more? thanks
not as is, but if you bring the data together on one sheet, you can create the timeline from that composite
Thank you it's helpful in 2024😮😮😮😮
How can I organize my tasks so that all "in progress" tasks are at the top, then all "not started" tasks are after that, etc. Is there a value to enter somewhere or is there a way to make a custom filter / sort?
You'd have to sort the sheet/range and it'd be alphabetical. Here's a video on sorting/filtering: ruclips.net/video/idUNKGoiaBc/видео.html (to force the order you want, you could add a number to the status terms that force that order, e.g., 1 In progress, 2 Not started, etc.
Quick and to the point, very helpful. Thank you!
thanks, really helpful
Time to solution: 15 seconds. Thank you!
This video is dope. This is the dopest video I have seen since watching other dope videos.
I am looking to learn how to work my Bright Space
The most underrated query tutorial on RUclips. I am already using it at my workplace. Thank you.
How do you get rid of assignments that linger in the gradebook?
You should have had to start with this: "Availability Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade customers Not available to Nonprofits, and legacy G Suite Basic and Business customers Not available to users with personal Google Accounts " Source: workspaceupdates.googleblog.com/2022/11/timeline-view-google-sheets.html
Love the Simple Explanation
Hi there, may i know how to add a periodical event? Says an event happens once every Tuesday. How to add in?
You can't add recurring events this way; add the event's first instance and then Google Calendar set its recurrence.
What type of account should I have?
Hey guys I'm trying to find time insights but It's not showing up where you guys are showing it here. Is there a way to set this up?