Это видео недоступно.
Сожалеем об этом.
Simple Data Analysis for Teachers Using Excel
- Добавить в
- Мой плейлист
- Посмотреть позже
- Поделиться
Поделиться
HTML-код
Размер видео:
- Опубликовано: 17 ноя 2011
- Exploring some basic data analysis in excel
Комментарии • 20
Следующие
Автовоспроизведение
Data Analysis for Teachers Using Excel (Part 2)Jon Jasinski
Просмотров 22 тыс.
Module 1: Data Analysis in ExcelDAT206x
Просмотров 555 тыс.
Excel Tips for Teachers Episode 1: Creating a Simple SpreadsheetTeachprof Tunmore
Просмотров 21 тыс.
Roman Reigns - I Am Greatness (Entrance Theme)WWEMusic
Просмотров 742 тыс.
EST Gee - NEVER NEED (Feat. Selfpaid Savage) [Official Video]ESTGeeVEVO
Просмотров 1,1 млн
HIGHLIGHTS | NEW ZEALAND v ARGENTINA | The Rugby Championship 2024TRC & SUPER RUGBY PACIFIC
Просмотров 728 тыс.
Disguised Truck Stealth CampingSteve Wallis
Просмотров 685 тыс.
Descriptive Statistics using "Data Analysis" tool in Excelozanteaching
Просмотров 398 тыс.
TEDxCincy - Jeff Edmondson - The Key to Educational Improvement: Data and How We Use ItTEDx Talks
Просмотров 60 тыс.
Track Student Progress with Google SheetsShawn Beard
Просмотров 121 тыс.
For teachers: How to use Excel to analyse a test given to students.Matthew O'Brien
Просмотров 48 тыс.
Test AnalysisGlen Tox
Просмотров 56 тыс.
Excel Tips for Teachers Episode 3: Ranking results in ExcelTeachprof Tunmore
Просмотров 271 тыс.
Excel for Teachers: Student Progress Tracker Part 1 of 3 - Convert Grades to Numbers Using VLOOKUPTiger Spreadsheet Solutions
Просмотров 32 тыс.
ВСУ в Судже, Нойз оправдывается, Долина и мошенники, конец Олимпиады. Мобилизация? Разбор новостейОсторожно: Собчак
Просмотров 825 тыс.
@RoomFactoryy КОРОЧЕ ГОВОРЯ, СЪЕЛИ 100.000 КАЛОРИЙ / КТО ДОЛЬШЕ ПОТОЛСТЕЕТ ЧЕЛЛЕНДЖКОРОЧЕ ГОВОРЯ.
Просмотров 180 тыс.
Harley Quinn's revenge plan!!!#Harley Quinn #jokerHarley Quinn with the Joker
Просмотров 8 млн
Батя учит французский #батя #орешекВиталий Оpехов
Просмотров 109 тыс.
СОБАЧЬЯ ПОДСТАВА ► SCHOOLBOY RUNAWAY #4Kuplinov ► Play
Просмотров 1 млн
Classic Italian Pasta Dogalbert_cancook
Просмотров 5 млн
одеваюсь с парнем в одном магазине 💃🏻🕺 #mariaomgMaria OMG
Просмотров 356 тыс.
OMG! THANK YOU! You rock. I'm a little slow when it comes to excel and I've tried for YEARS to figure out how to incorporate it into my curriculum. You've made this so easy that I can actually use it in my classroom!
Hi. Thanks, this is way easier than the 4 hour crash course I got 20 years ago.
A very simple but very effective analysis ...for simple data analysis
OMG the good old excel interface. Love it.
how to download template sir
Thanks! I would like to know how will you plot the scores in excel if the test questionnaire is the Likert type where it is distributed as follows: for questions with positive answers-strongly agree (4), agree (3), neutral (0), disagree (2), strongly disagree (1). For questions with negative answers-strongly agree (1), agree (2), neutral (0), disagree (3), strongly disagree (4). The neutral was credited as "0" to eliminate guessing. Thanks again!
One way you could handle a Likert scale is to find and replace (ctrl f) each term with a number. You can replace all, then work with the numbers.
Is there a way that this data can be switched into a visual aid like a graph or pie chart?
If you go to quick analysis (right click) then you can
Thank you for your kind response!
Awesome, i have A question suppose that you have a questionarre it has for examples 50 question, and you are giving the respondant to choose between totally agree, agree, neutral, disagree, totally disagree, you will give the first one number 5, second 4.and so on how you will get the mean and standrad devitation in excel, it will become Very kind if you can provide with a tutorial in you tube, because I searched and i could not find, may because I am a begginer
Short answer, You could use find and replace to change each "strongly agree" into a "5" and the rest. Then use =AVERAGE() and =STDEV()
Can this be a program system? Frequency of Error System?
Free apps that scan and grade scantrons will do error analysis for you now.
If I received #### as average, what do I do?
Expand the cell
THANK YOU!
Thanks!!!
I'm using Google Forms to give the quiz.
One question is
"4. Someone who does a work-study training, in English we call that person an ________________. "
I'm parsing (case insensitive) for the word "intern", but I'll also accept "trainee".
After the students complete, I export the answers into an excel spreadsheet. Then I parse cells with answers.
Cell O2 function which analyses cell N2:
--------------------------------------------------------------------------------------------------------------
=if(
OR(
ISNUMBER(SEARCH("intern",N2)),ISNUMBER(SEARCH("trainee",N2))
)
, "1", "0")
1 = Correct; 0 = Wrong
I am interested in using this video in a professional development curriculum we are writing at Deeper Dive Learning. I would appreciate if you could let me know of a current email where I could send you more information about this, as we hope you will be interested in furthering the professional development of many passionate educators.
With sincerest thanks,
Pamela Bruening, Ed. D.
Founder and CEO Deeper Dive Learning