Edstar Analytics is creating videos of mathematics and language arts instruction that we use in our lessons. Our math and language arts teachers have created lesson handouts that students can use without much adult supervision. The lessons include self-directed learning for students, with links to appropriate Khan Academy, Flipgrid, or other free class accounts. These accounts, if set up appropriately, will provide data for monitoring student work and their progress. These can be set up by homeschoolers, other online schools, and connected to a teacher.
Our lessons include scaffolding, for students who need extra help, and a deep-dive enrichment for those who need more challenge. We continue to create more lessons.
These videos are available free. Email jackie.alvarez@edstaranalytics.com if you would like to subscribe to our lesson handouts. We will send you a sample. We also offer an online system to creating lessons.
This was really super quick and easy! Impressive. I need to thik of something along the lines of retired teachers, for you to ask & chart for me. By the way, did you ask for NC data only, or US, or world? I missed that part. Is there a Chat-GPT that is free to the general public?
I have a $20 a month subscription but there is a free version. I was using the free version and way happy with it, then someone talked me into getting the subscription. I was happy with the free and am thrilled with the subscription. I did not ask it for NC data. Note that the MTSS and Ac. Gifted don't have set criteria. The IEP and 504 are federal so they are the same everywhere.
It depends. We were setting up a template to analyze the data for several schools, many different times. We wanted to set this up so that we can dump the data in each time and get nice graphs to put into reports for the schools. I actually made this video for my interns to show so they could go back and watch it if need be while they made some of these templates for various surveys that we give repeatedly. If you are analyzing one time only, a pivot table would probably be easier.
Actually, you probably could use pivot tables. Sometimes we do that and generate the charts off of them. I don't like the pivot charts. I thought this would be simpler for some interns I had and I wanted them to learn more about Excel. I just made it public for the heck of it. I didn't expect anyone else to watch it. Since this, we have run into Jamovi and learned to use Power Querry in Excel. There are probably many better ways to do this.
@@edstaranalyticsinc.52 Thank you so much, I am currently working as a data analyst and I am trying to incorporate other methods besides throwing my data in pivot tables :) your information was very helpful, I hope to see more of your videos :)
@@elijahd.spragueph.d8905 I enjoy making these. We recently discovered Jamovi, which is open-source. I love it. The tool doesn't get in the way of thinking about what you are doing. I've been too busy to make many videos for it, but if I get caught up, I'll make more. Here is one: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JkU9SPVQbPc.html. We still use Excel daily. We make things pretty in Excel. I think we used Pivot tables but did more with them in this one: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-srm5lvhhGHo.html I am busy right now tutoring 3rd grade math for Americorps via Zoom. If you need any "how to tutor 3rd graders, I am making those right now: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PH1p9LoBrRs.html
This is just for a check to make sure your formulas are correct. I don't know why Excel wouldn't show you the count of the filter, but you can check some other way. For example, find an empty cell and write a formula of =countif(A3:A200,"Strongly Agree") if the data is in A3:A200. That will count them so you can check. It is just a lot easier if Excel will just tell you. I've had that happen. Close and reopen, and see if Excel starts behaving.
Since students often want "memory tricks", I have started using "Please Excuse MaDame AlliSon" to replace the old memory device. (I tell them Aunt Sally [or Sarah] will steer you wrong!) Since M and D are both in the same word, it means you can work the at the same time. I do like the idea of telling them to get rid of Division and Subtraction, but this Madame Allison would still help out.
The McNichols were Dessie and Clyde's friends who lived in Florida. Landons stayed with them when they traveled to Florida (wintertime). I'll check with Mom to be sure and edit later.
It took me a while to realize what that paper I (the fairy god mother) was holding up when I waved my wand and switched dresses. It is a ticket to the ball.
OMG! I laughed so hard! Your narration is perfect, Janet, and the whole play excellent! I love so many of the details and ad libs. Delightful and precious!! Thank you for sharing. Rating: 5 STARS
lol I love your personality, I think you're funny and your proficiency in excel is excellent, your videos have been very helpful thanks so much. am humbled.
Funny? I wasn't trying to be funny. I have another series where I actually am trying to be funny. I have taught College Algebra to countless very smart people who somehow got through 12th grade without understanding some very basic math concepts. Having taught so many of these classes, I picked up on the critical concepts that these folks are generally missing. I made a series for very smart people who need to pass a high stakes math test but they don't know much math. These folks generally hate math. So, I put math jokes in them to lighten things up. I figure anyone watching these Excel videos doesn't need me to tell jokes to keep them from crying. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Vzgc8a4DLvw.html
@@edstaranalyticsinc.52 i love it when lessons are less serious,it becomes easy to fathom concepts keep it up with the good job. If u happen to know any excel course I can take to sharpen my skills feel free to share.👍
Don't put a $ in. Just type = then go to the tab that has the items and click on the first question. That should bring the question into this new tab. Then either copy/paste that or pull it across.
You may or may not have noticed that I misspelled "strongly disagree," which is why all of those were zero. After I noticed it, I didn't want to stop and go back. Later, I fixed it and those numbers updated. This is why you have to check everything or cut/paste from the previous page--and don't write while talking.