Advanced Google Drive Tools for ABA (2.0 CEUs)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level.

Who this course is for:

  • BCBAs and BCaBAs seeking CEUs

Course content

3 sections • 16 lectures • 1h 56m total length
  • Functions
    11:47
  • Calculating Session Duration
    07:45
  • Section 1 Quiz
    1 question

Instructor

Analyzing data to help make better decisions
  • 4.7 Instructor Rating
  • 123 Reviews
  • 484 Students
  • 6 Courses

My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results.

Expected Outcomes

  1. How to share documents on Google Drive Understanding functions in Google Sheets How to use the FILTER function How to use the SORT function How to use conditional formatting How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  2. Understanding functions in Google Sheets How to use the FILTER function How to use the SORT function How to use conditional formatting How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  3. How to use the FILTER function How to use the SORT function How to use conditional formatting How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  4. How to use the SORT function How to use conditional formatting How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  5. How to use conditional formatting How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  6. How to use the QUERY function How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  7. How to use the COUNTIF function How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();
  8. How to use the SUMIF & SUMIFS functions Requirements Must have a Google account set up In order to receive CEUs, must be an active Board Certified Behavior Analyst (BCBA) or Board Certified Assistant Behavior Analyst (BCaBA) Description This course goes beyond the first class 'Google Drive Tools for Applied Behavior Analysis' to explore more advanced features in Google Sheets. There are many functions that can be utilized by behavior analysts to make their data collection more efficient and streamlined. However, it can sometimes be difficult to figure out where to start when you don't even know what you don't know. This course will introduce and provide examples for a variety of useful functions such as 'filter', 'sort', 'query', 'count', and many more. This will provide you with the tools to take your data analysis to the next level. Who this course is for: BCBAs and BCaBAs seeking CEUs Show more Show less Course content 3 sections • 16 lectures • 1h 56m total length Expand all sections Introduction 4 lectures • 33min Introduction Preview 07:40 Adding Example Data to Google Drive Preview 06:17 Functions 11:47 Calculating Session Duration 07:45 Section 1 Quiz 1 question Function Examples Set 1 4 lectures • 33min Filter Function 09:18 Sort Function 09:08 Conditional Formatting 06:09 Query Function 08:20 Section 2 Quiz 1 question Function Examples Set 2 8 lectures • 51min Import Range Function 05:39 Automated graphing part 1 - average 13:17 Automated graphing part 2 - standard deviation 08:23 Count If Function 09:11 Sum If Function 09:28 Section 3 Quiz 1 question Conclusion 02:37 Additional CEU Courses 00:57 How to Get CEU Credit 01:00 Instructor Blake Crosby Analyzing data to help make better decisions 4.7 Instructor Rating 123 Reviews 484 Students 6 Courses My mission is to use science and technology to make new discoveries to inform decisions that improve the overall well being of my clients. As a behavior analyst, I have been the lead consultant for dozens of children with autism spectrum disorder (ASD). In this capacity, I am responsible for assessing their strengths and weaknesses, constructing treatment plans to target socially significant changes, and using rigorous data analysis to make adjustments based on the results. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a2fafd71dc33',m:'b3412450dfc32da5564635de92a23cebde8c2fe4-1627847859-1800-AVan4rxnMd2mVZELCQovddlVnUU1ZyVxJ0e8QUYZn9dgFR3+fDFVO+ArqT0mPpudO0tGPS5iAXs9H1DB/QNPMlTAbVSTCKraflqm/kT/CEyR+rk/iR4+jLJ8gPL3nFZs6eAfLplfCB9Ww69tZR6rIsqjJuyoEYv8hAQvLHThnJYP',s:[0x2e2e969dab,0xfa806fab1e],}})();