background preloader

Utbildning - IT - Programmet för volyminköp

Utbildning - IT - Programmet för volyminköp

Google Sheets: Fill Down One of the coolest things about spreadsheets is the ability for it to recognize patterns and apply it over a large range. If you write a formula in a spreadsheet and then copy the formula to other cells, the spreadsheet recognizes the pattern and automatically adjusts the formula. “Fill down” refers to copying the pattern in the spreadsheet down a particular range in a column. After highlighting the pattern look for the square in the bottom right-hand corner of the highlighted range. This works with other patterns too. Another pattern you might want to use is skipping rows. Having a list of numbers quickly is very handy. To continue my calendar I will want to skip a row. Notice in the screenshot below that in cell B6 I had typed the formula =B4+7. Finish the calendar by highlighting the range of cells with the pattern. This also works with dates. Let’s pretend you have a spreadsheet with 500 rows. Copyright secured by Digiprove © 2015

Flippat föräldramöte Use Google Docs in a Hangout You’re probably aware of Google Hangouts, and how useful they are for video chat and conferencing. Did you know that you can also include your Google Drive documents as part of your hangout video, and edit them right there in the hangout? There are a few ways to open a hangout; here I’ll do so from Gmail: Click image to enlarge The first time, you may be asked for authorisation to use the camera and microphone. Then you’ll see a screen something like this (but I can’t guarantee that yours will display such a handsome guy): The icons down the left are applications you can use from within the hangout. The webcam display is now down below, and you can recover it when you want to by clicking on it: From here you can add Drive documents to the hangout. If you’re chatting to someone who has edit priveleges for the document you’re viewing, you can both work on the content in real time, right there in the hangout.

Nybörjarguide ~ Kilskrift Din nybörjarguide till att flippa klassrummet Vad bra! Du har börjat intressera dig för att flippa klassrummet. Men vad är det egentligen? Jag intervjuades av Ålands Radio när jag var där och föreläste. Dessutom har jag med i radioprogrammet Skolministeriet när det handlade om det flippade klassrummet. Här kommer Aaron Sams och Jonathan Bergmanns föreläsning från BETT 2013. Här är ett blogg inlägg som heter The Flipped Classroom Guide for Teachers.Flippat London - del 2 Sen föreslår jag att du gå vidare med att titta igenom en del länkar: Den första är Salman Khans föreläsning på TED från 2011. Så nu har du ett begrepp om vad Flippa klassrummet innebär. Men om du nu står på steget"Hur gör jag det?". Blogga Det finns flera blogghotell, men jag rekommenderar att du använder Blogger, Wordpress eller Moobis. Roliga besöksräknare har du här och i form av en jordglob här. TextReadSpeaker - Gör så att dina blogläsare kan få texten uppläst.Blogbooker - gör din blogg till en bok. Om upphovsrätt.

rosterSync - Admin Edition - New Visions CloudLab The manual enrollment of students in Google Classroom can be an adoption barrier, which rosterSync alleviates.Frequent roster-changes occur particularly in higher needs schools, which means that an easy roster sync process is critical to boosting technology adoption. Best if adopted and set up PRIOR to the start of the school year or semester. This avoids a scenario where teachers have already set up Google Classroom on their own, and then receive a bunch of redundant courses from rosterSync.Teachers can "Accept" or "Decline" course invitations from Classroom courses created with rosterSync, and students do not see the courses until they are "Accepted" by the teacher.It's probably wise to message to teachers that they are at liberty to make adjustments to their own rosters once they are provisioned, and to train them to do so, so they feel empowered to avoid IT bottlenecks and fix SIS errors on their own!

Super Teacher Tools Use Chromebooks for student assessments - Chrome for Work and Education Help Chromebooks are a secure platform for administering student assessments, and when setup properly, these devices meet K-12 education testing standards. With Chromebooks, you can disable students’ access to browse the web during an exam in addition to disabling external storage, screenshots, and the ability to print. Both PARCC (see TestNav) and the Smarter Balanced Assessment consortia have verified that Chromebooks meet hardware and operating system requirements for online student assessments. Setup Assessments can be delivered on Chromebooks in any of these three ways: Scenario 1: The exam is delivered on Chromebooks set up as a "Single App Kiosk". Pre-requirements: Get Chrome management for each Chrome device. With each method, the administrator can configure the device for secure student testing. Scenario 1: School sets up Chromebook to run as a Single App Kiosk running the exam app Sign in to the Admin console. Auto-Launch Setting for a Kiosk App Steps for the provider: Resources

Popplet Educational Technology and Mobile Learning: A Comprehensive Collection of Some of The Best Google Drive Add-ons for Teachers and Educators January 4, 2015 Google Drive has proved to be an indispensable tool in teachers digital toolkit. It provides everything teachers need to write up a document, create a quick presentation or spreadsheet and design beautiful visuals and drawings, creative possibilities in Google Drive are endless. Additionally, Drive works across different devices and platforms so you can easily continue working on your documents anywhere you go and without even the need for Internet connection. In 2015 Google Drive has known a lot of improvements with the addition of a number of key features. We have covered all of these features in Drive for Teachers section here in EdTech and mLearning. We have also reviewed a wide variety of educational add-ons and tools for teachers to use on Google Drive to enhance its overall productivity and extend its learning potential.

100+ Google Tricks for Teachers It's Google's world, we're just teaching in it. Now, we can use it a little more easily. With classes, homework, and projects–not to mention your social life–time is truly at a premium for all teachers, so why not take advantage of the wide world that Google has to offer? From super-effective search tricks to Google tools specifically for education to tricks and tips for using Gmail, Google Docs, and Google Calendar, these tricks will surely save you some precious time. Search Tricks These search tricks can save you time when researching online for your next project or just to find out what time it is across the world, so start using these right away. Convert units. Google Specifically for Education From Google Scholar that returns only results from scholarly literature to learning more about computer science, these Google items will help you at school. Google Scholar. Google Docs 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. Gmail 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. Google Calendar 44.

Google Drive Sharing Controls Just Got Even Better - The Gooru Click here to watch this video on YouTube Learn more about Google Drive ——> Get the Ultimate Guide to Google Drive Google kicked off this week with new features in Google Drive that greatly improve Sharing Controls for both the end user and the Admin. Over the next several days, these new features will be available in the Admin Console in a new section called the Access Checker. So what do these new Sharing control features mean? For the End User… With this new update, end users will receive the below alert when they attempt to add a new collaborator to a document through any of the channels mentioned above. New End User Alert Let’s say for instance you are making a comment on a Google Doc and loop in a new user to the document with the “+” sign. For the Admin… Access Checker is a new section in the Sharing settings of the Admin Console. Access Checker To begin using the Access Checker: Go to your Admin Console.Select Apps.Click Google Apps.Select Settings for Drive.Scroll to Sharing settings.

7 Fabulous iPad Apps to Create Short Animated Lessons for Your Flipped Classroom Today, however, I am sharing with you a set of some wonderful apps that you can use to create short video lessons and tutorials to share with your students. You can also use them to : Easily explain a range of topics from math to chemistry to music theory to basket weaving.Attach a personal message to any travel photos you want to shareDiagram offensive and defensive strategies for sportsGrade student work with commentary explaining the reasoning behind their performanceImplement a “flipped classroom” Showcase your tutorials online and share your knowledge with your students, friends, family, or the world! I have meticulously handpicked the apps mentioned below and only included what I personally see as the best available out there. 1- Educreations This is my favourite of them all. 2- ShowMe ShowMe is similar to Educreations in that it also allows you to turn your iPad into a recordable iPad. 3- DoodleCast Pro 4- Explain Everything 5- Board Cam Pro 7- Knowmia

En-till-en-miljö gör undervisningen mer formativ I antologin ”Den trådlösa pedagogiken: en-till-en i skolan på vetenskaplig grund” med Tomas Kroksmark som redaktör presenteras studier med inriktning mot att utforska olika aspekter på införandet av en-till-en i framförallt grundskolan men även gymnasiet. En-till-en beskrivs som en förändring som innebär att varje elev utrustas med en egen dator, surfplatta eller telefon. I kapitlet ”Undervisningen i en-till-en” av Moni Sohlberg och Tomas Kroksmark framkommer resultat som tyder på att en-till-en förändrat såväl lärarroll som klassrumssituation och därmed också bidragit till en förändring av bedömningspraxis. Som särskilt viktigt framställs att det skett en ”perspektivförändring från fokus på undervisning till fokus på elevens lärande” (Kroksmark & Sohlberg 2013 s. 150). Undervisningen mer framåtriktad Syftet med studien är att ge kunskap om hur datorn påverkar undervisningen och därmed elevernas kunskapsutveckling och lärande. Kunskapsutvecklingen synliggörs Förändrar synen på kunskap

Att arbeta med genrepedagogik och IKT i moderna språk Publicerad av Hanna Stehagen Vi undrar varför eleverna väljer bort eller hoppar av språkvalet i grundskolan. Det är för att de är svaga, säger vi. I min tyskgrupp i år 6 och 7 har jag arbetat enligt genrepedagogikens cirkelmodell och den systemiskt funktionella grammatiken samt använt mig av Photostory, då eleverna skulle skriva och sedan presentera sina alster. Jag använde mig i grunden av en traditionell uppgift, nämligen att eleverna skulle redogöra för vad de hade gjort på sportlovet. För att utveckla uppgiften och göra den intressant för eleverna fick de först samla en ordbank med aktiviteter, som eleverna hade gjort på sitt lov med hjälp av en tankekarta och sedan fick de arbeta med att översätta aktiviteterna till tyska. I fas tre och fyra fick de med hjälp av min mall, där jag hade skrivit om mitt lov, skriva egna storyboards till sin photostoryfilm. Så vad var då vinsterna med att arbeta med genrepedagogik och IKT i detta arbetsområde, förutom att samtliga elever nådde målen?