Group items tagged

joevans · My Wikis · My Mail · My Account · Help · Sign Out · wikispaces *This page can only be edited by organizers of this wiki.homeProtected * pagesubmenu o print o what links here? o rename o delete o redirect o unlock o view source * discussion * history * notify me Protected Welcome to our resource wiki for: Personal Learning Networks: The Power of the Human Network Judith Epcke (@jepcke) and Scott Meech (@smeech) Locations of visitors to this page Bold Italic Underline Color and Style Ordered List Unordered List Horizontal Rule Insert Link Remove Link Insert Images and Files Embed Widget Insert Table Insert Special Character Insert Code Cancel none Optional: a note about this edit for the page history log Optional: tags for this page, separated by commas Cancel Note that the content you create on http://creatingapln.wikispaces.com is licensed under the Creative Commons Attribution Share-Alike 3.0 License. Please only submit content that you write yourself or that is in the public domain. Learn more about our open content policy. Insert a File Double click an image or file to insert it into the page. Show: please wait... Page: Jump: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Double clicking a file: inserts the file links to the file Upload New File notUploading Insert External Image by URL Enter an external image address, click "Load", then double click the image to insert it into the page. * Wikispaces Wikispaces * Video Video * Audio Audio * Calendar Calendar * Spreadsheet Spreadsheet * Document Document * Polls Polls * RSS Feed RSS Feed * Chat and IM Chat and IM * Slideshow Slideshow * Map Map * Bookmark Bookmark * Other HTML Other HTML Choose the category of application you would like to embed from the list on the left. Choose the kind of content you would like

"Around this time last year I shared a neat Google Spreadsheets script called Flippity. Flippity was originally designed to help you create flashcards through Google Spreadsheets. This morning Steve Fortna informed me that you can now use Flippity to create Jeopardy-style gameboards through Google Spreadsheets. In the video embedded I demonstrate how to use Flippity to create a Jeopardy-style gameboard."

"Spreadsheets can be intimidating to a lot of teachers and students. I have to admit that at one time working with spreadsheets was a daunting task for me too. Fortunately, Google Sheets has made it much easier for the average computer user to work with spreadsheets. Once you get the hang of working with Google Sheets there are a lot of great ways to use spreadsheets as a teacher or as a student. Here's a run-down of some of my favorite things to do with Google Sheets in the classroom."

"Flippity is a very good tool that you can use on Google  Spreadsheets to create flashcards and quizzes. The flashcards you create can be either printed or shared online through a generated link. The process to create a flashcard using Google Spreadsheet is pretty easy. Here is how to do it:"

"Google forms are fabulous for gathering information, but sometimes, the data in the spreadsheet can be difficult to view. In this post, I'll share a simple-to-implement formula that will make it much easier to deal with (and even print) form-fed data!"

If you're setting up a worksheet only for yourself, you can simply leave an empty cell for this purpose. To check it, just type in an x or any other character. Then use a formula with the =isblank() function to make the contents of that cell affect the rest of the spreadsheet. But you might want something more mouse-friendly--especially if you're designing a spreadsheet for other people. I've tested the technique below on Excel 2007, 2010, and 2013. I'm not sure about earlier versions. You can insert checkboxes on Excel's Developer tab. Unfortunately, that tab is hidden by default. To make it visible in Excel 2010 or 2013, click the File tab and select Options. ClickCustomize Ribbon. You'll see two lists. Make sure that the one on the right is titled Main Tabs. Check Developer.

"Fact, I have anxiety about math facts. I have a degree in math. I graduated college with honors. I got the highest score at my university on the Putnam exam, which is supposedly a big deal to get a non-zero score. I taught high school math for 14 years. I am the Queen of Spreadsheets. I code for fun and share my coding projects. I repeated the 4th grade due to math facts. After 2 years of 4th grade, I never passed the timed math tests. If you ask me to do basic arithmetic in my head, even 7×8, I freeze. My heart races. I try to dodge the question. I'm perfectly capable. I'm more inclined to use strategies when doing math problems than memorization. When I'm alone and tallying student scores on a paper, I do great. If I need to design a spreadsheet and apply math, I excel at that. I am not alone. Reading Mathematical Mindsets by Jo Boaler, for the first time in my life I realize I am not dumb."

"Google Drive provides a streamlined, collaborative solution to writing papers, organizing presentations and putting together spreadsheets and reports. But besides the basic features, there are lots of little tricks and hacks you can use to make your Google Docs experience even more productive. Here are 100 great tips for using the documents, presentations and spreadsheets in Google Docs."

"As tablets move from novelty items to staples in the classroom, teachers are finding new ways to make them more than just another screen for students to look at. One way to make the devices more interactive and collaborative is to extend their reach by connecting them with external sensors or robots. According to Sam Patterson, a technology integration specialist at Gideon Hausner Jewish Day School, a K-8 school in Palo Alto, CA, "What we are seeing is technology becoming more and more transparent." Years ago, if you had a computer for every student in the class it would look like a computer lab. And then each student had a laptop, and it was a classroom full of screens, he noted. "Now students have the ability to connect to other things in the room, so that when we are collecting data we can do it directly and do observations," he said. "It is amazing that in a seventh-grade science class, you can import data and it is in a spreadsheet already. You can start to work with that data without having to teach the students how to build a spreadsheet.""

"After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can't ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2010"