50 Education Technology Tools Every Teacher Should Know About Technology and education are pretty intertwined these days and nearly every teacher has a few favorite tech tools that make doing his or her job and connecting with students a little bit easier and more fun for all involved. Yet as with anything related to technology, new tools are hitting the market constantly and older ones rising to prominence, broadening their scope, or just adding new features that make them better matches for education, which can make it hard to keep up with the newest and most useful tools even for the most tech-savvy teachers. Here, we’ve compiled a list of some of the tech tools, including some that are becoming increasingly popular and widely used, that should be part of any teacher’s tech tool arsenal this year, whether for their own personal use or as educational aids in the classroom. Social Learning These tools use the power of social media to help students learn and teachers connect. Learning Lesson Planning and Tools Useful Tools
אנליסטים אנונימיים » SQXL – שימוש בקוד אס-קיו-אל כדי לחבר גיליונות אקסל הידעתם שאפשר להשתמש בקוד SQL כדי לחבר גיליונות אקסל, כאילו היו טבלאות DB לכל דבר? תשכחו מ-Vlookup, בואו ללמוד איך עובדים המקצוענים. אקסל הינו כלי חזק וגמיש, כולנו יודעים זאת היטב. עם זאת, לאקסל יש מספר בעיות מובנות והמרכזית שבהן הינה היכולת (או חוסר היכולת, בעצם) להתמודד עם כמויות גדולות של נתונים. כל אחד יכול לעשות vlookup כדי לחבר נתונים כשמדובר באלפי או אפילו עשרות אלפי שורות (במחשבים חזקים). אז מה הפתרון? SQL (קיצור של Structured Query Language) היא שפת מחשב לשליפה, מידול, ומניפולציה של נתונים בבסיסי נתונים רלציוניים. אז למה להשתמש בנוסחאות אקסל כבדות כשאפשר להריץ קוד SQL אשר יעיל ואפקטיבי בהרבה? העניין הוא ש-SQL עובד על נתונים אשר מסודרים במבנה של טבלאות מוגדרות במסגרת Database, כמו למשל Access או אחיו הגדול, ה-SQL Server ואחרים. אז במייקרוסופט החביאו – אבל אנחנו מצאנו בכל זאת, ועכשיו נשתף גם אתכם בדוגמא הבאה נדגים הקמה של שתי טבלאות נתונים עם שדה מקשר ביניהן (Foreign Key בשפה ה-SQLית), ובניית דוח אשר ירכז נתונים משתי הטבלאות, על בסיס שאילתת SQL מסוג Inner Join. 1. השם והמיקום חשוב.
Flipping Professional Development Last week I worked with almost 100 educators from my district in the area of flipping the classroom over a period of two days. These two sessions were lead by well-known "flipper", Brian Bennett, another colleague of mine, Brian Bobbitt, and myself. It was a fantastic two days and there was a lot of excitement. Being a part of these sessions allowed me to really think about the way we do professional development. The first day we started off talking about the philosophy and rationale of the flipped classroom. We had a day off between sessions and we communicated through email about what we wanted to do differently. One of my favorite conversations I had the second day was with a group of instructional coaches and administrators from my district and how they can flip professional development. I personally experienced traditional PD this past Friday in a session for a leadership cadre that I belong to in my district.
Booktrack Classroom - Teachers Booktrack Classroom dramatically improves student reading and writing abilities with a fun, easy to use technology that integrates with Common Core Standards. Booktrack Studied by Major Universities New York University and The University of Auckland have conducted studies on Booktrack which showed that Booktrack increases reading comprehension scores and student engagement. Read more. What is Booktrack? Booktrack is a new way for students to read stories and texts accompanied by a movie-style soundtrack. Using Booktrack Classroom Booktrack can be used in a variety of ways to engage with students. Booktrack Classroom achieves multiple learning objectives, while simultaneously promoting digital literacy and creative thinking among students. Lesson Plan Library We've assembled a variety of lesson plans catering for students at the elementary, middle and high school levels, covering a variety of subjects and learning outcomes.
The 50 Free Apps We're Most Thankful For 48 People To Follow On Twitter If You're Interested In Indiana Education Douglas E. Curran/AFP/Getty Images Tweet, tweet, tweet... Of course, I hope you’re following yours truly and my colleague for the latest news on Indiana education. But to round out your Twitter account, I thought I’d pull together a list of some of the Hoosiers who’ve been tweeting most actively about education issues. I pulled most of this list from my personal list of Twitter follows/followers, which makes me a bit nervous that I’ll exclude someone. Note I’ve excluded most institutional accounts and most public relations accounts from this list, with a few exceptions. UPDATE: You’ll find a total of 50 people in this post now, after two late additions — sorry Abdul and Sarah! Educators Policymakers Eduwonks & Advocates Journos, Bloggers & Media Types
Bounce – A fun and easy way to share ideas on a webpage 5 Excel Add Ins Every Data Scientist Should Install No matter what you do, you can’t avoid excel. So, may as well dive into it & tame the beast. Here are 5 excel Add Ins that every data scientist should install. Power Query: Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.With Power Query you can:Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).Discover relevant data from inside(*) and outside your organization using the search capabilities within Excel.Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.Share the queries that you created with others within your organization, so they can be easily found via Search. (*)
Excellent Videos OnThe Use of Augmented Reality Apps by Students Below are some good videos I got a few days ago on examples of how some augmented reality apps are being used with kids to help them improve their learning. If the concept of augmented reality if all new to you then here is a brief definition of it: Augmented Reality is exactly what the name implies: an augmented version of realty created by mixing technology with the known world. It might be a distorted, augmented, or less augmented version of the actual world but in its basic form, augmented reality is a simulation or rather a way of superimposing digital contents into the real context. You can learn more about the importance of augmented reality in education from " Teachers' Guide to Augmented Reality ". Now here are some video examples of augmented reality concept in action. 1- Augmented Reality to engage students in Mathematics 2- Teach coding using Augmented Reality 3- Augmented Reality in Education Topia and Aurasma 4- Is this the future of education ?
How to Block An Application from Accessing the Internet with Windows Firewall Most of the time we want our applications online and connected to both our local network and the greater Internet. There are instances, however, when we want to prevent an application from connecting to the Internet. Read on as we show you how to lock down an application via the Windows Firewall. Why Do I Want To Do This? Some of you might have been sold immediately by the headline, as blocking an application is exactly what you’ve been wanting to do. Although you generally want your applications to have free access to the network (after all what good is a web browser that can’t reach the web) there are a variety of situations in which you may wish to prevent an application from accessing the network. Some simple and commonplace examples are as follows. Regardless of why you want to drop the cone of network connectivity silence over a given application, a trip into the guts of the Windows Firewall is an easy way to do so. Creating a Windows Firewall Rule Testing the Rule
101 iPad Tips & Tricks Use these iPad tips and tricks to do more with your iPad Air, iPad mini and every other iPad running iOS 8. This list of over 100 iPad tips and tricks is broken down by tips to help you get started, use the keyboard better, surf the web on the iPad easier, sync your photos, data and calendars as well as get the most out of your iPad with entertainment apps and services. Whether you just bought an iPad, or you’ve had one for years, these useful iPad tips and tricks will show you new ways to do more with your iPad. If you want to get to know how to use the iPad like a pro with useful shortcuts that will have you typing faster, being more productive and enjoying your iPad more, this is what you need to know. Check out these 101 iPad tips that work on the iPad Air, iPad mini, iPad mini Retina, iPad 4, iPad 3 and iPad 2. All of these iPad tips and tricks work on all the iPad models Apple sells now, even going far back as the iPad 2. Advertisement iPad Setup Tips Show iPad Battery Percentage