-
Recent Posts
- Embedding Google Documents in a Google Site
- Infographic Technique: Text that Pops
- How to Create a Pivot Table to Summarize Student Information
- Equation Editor in Google Presentation
- Detecting Plagarism
- Reflection on Social and Professional Networks
- Images Make Things Better
- Getting Started with Spreadsheets
- 5 things everyone should know about spreadsheets
- Using the New Google Forms – A workflow
- Sharing Google Forms
- Using Web 2.0 tools & infographics
- Opacity in Google Drawing
- Have Students Create Infographics Using Google Draw
- Have Students Contribute Data to Make a Cool Class Data Visualization
- Sharing a Google Drive Folder in 5 easy steps
- Creating Side by Side Tables in a Google Doc
- LEC – Instructional Methodologies
- Student Sign in Sheet with Mail Merge
- Creating Custom Headers in a Google Doc
- Adding your Twitter Feed to a Google Site
- Putting Graphics Near Text on a Google Doc
- Student Video Mash Up with YouTube
- Reading Logs – Sharing progress with students
- Format Painter
- Leading Edge Certification – Online and Blended Teacher
- Have students create their own blog badge
- Scheduling Parent Conferences
- Peer Evaluations with a QR Code
- Using Google Forms for Peer Evaluation
- Students Submitting YouTube Videos
- Creating a Quiz with a Google Form and use Flubaroo to Grade it.
- Rubric Scoring – a template
- Zoom in Google Chrome
- Grading with a Rubric
-
Recent Tweets
-
I just posted Embedding Google Documents in a Google Site, read it here: http://t.co/jWjc44NUcC 2 hours ago
-
RT @lightroomblog: Loving @snagit for screen capture. Means I can grab roughly and refine the crop later. Handy. 4 hours ago
-
RT @bbridges51: 46% of CA districts utilize #onlinelearning or #BlendedLearning 26% of the rest want to. CA eLearning Census Report http:/… 4 hours ago
-
#islope the old model is multiple choice. The new model is "which of these methods are correct" #CCSS 5 hours ago
-
Introducing @mathtchrlinda to twitter as a PLN. Anyone want to share some getting started with Google Docs tips? #GoogleCT #edtech 5 hours ago
-
Tags
animation apple Chrome code Collaboration command conference creative commons CUE docs document camera draw email forms formula formulas games gamification google gta gtawa highlight images IPad ipevo LEC mac math presentation projects QR share shift sites spacebar Spreadsheet spreadsheets table of contents teacher toc twitter unconference voice workaround youtubeCategories
- Activity
- Apple
- Blog Entries
- Chrome
- Chrome Apps
- Collaboration
- docs
- Draw
- forms
- Gamification
- GarageBand
- Illuminate Ed
- Inspire
- iPad
- iWork
- LEC
- MAC
- Open Source
- pedagogy
- Presentation
- Promethean
- Resources
- Sites
- Spreadsheet
- Student Projects
- Teaching with iPad
- Tricks
- Uncategorized
- voice
- Web 2.0
- YouTube
-
Alice's Projects
Blogroll
- 100 google tricks for teachers
- Alice Keeler’s Old Blog
- CUE FPU Innovative Educators Advanced Studies Certificate
- How College Prep is Killing High School
- How to steal like an Artist
- Importance of Free Response
- Jerry McGuire Moment
- Kleinspiration
- Minarets STUDENTS video channel
- Myth of Khan Academy
- Steve Hargadon
- Top 10 signs your teacher is a geek
- Well Duh: Alfie Kohn
Tag Archives: Spreadsheet
How to Create a Pivot Table to Summarize Student Information
Tweet Link to the presentation Pivot tables are an incredibly powerful tool for summarizing information. When looking at data oftentimes there are repeats in the information. Multiple times a students name is listed. Multiple times an assignment title is listed. … Continue reading
Student Sign in Sheet with Mail Merge
Tweet Barretr Air Mail Envelope clipart from Clker.com One thing I like to do to start class is to have students fill out a Google Form. I use this to take attendance, ask survey questions to see … Continue reading
Reading Logs – Sharing progress with students
Tweet Click Here for my Google Doc of the post
Scheduling Parent Conferences
Tweet By request, here is a work around for creating parent conference appointments. Request: Can you make a way to let parents schedule conferences and know which time slots are available but not make the name of the student or … Continue reading
Peer Evaluations with a QR Code
Tweet In my previous post I showed you how to create a custom peer evaluation form for each student in the class. This works when students are able to go to a shared spreadsheet and click on the URL for … Continue reading
Using Google Forms for Peer Evaluation
Tweet Photo Credit: quinn.anya via Compfight cc I like to have my students do peer evaluations on student presentations or student projects. An issue is having students type in the name of their classmate. Frequently they will misspell or otherwise … Continue reading
Rubric Scoring – a template
TweetMany of us use a rubric to assess student work and projects. I am into saving time so I like to use spreadsheets to calculate things for me quickly. When doing a rubric scale it is important to realize it … Continue reading
Grading with a Rubric
Tweet On occasion I have observed some rubrics being utilized to create numerical grades that do not correspond to the rubric scale. For example on a 3 point rubric scale 3 = excellent 2 = average 1 = poor A score of … Continue reading
Random Student Chooser
TweetHow do you call on students in class? I use a spreadsheet and the =rand() formula. Create spreadsheet with student names In the column next to their name write the formula =rand() Sort the sheet by the random number and … Continue reading
