What Do I Need to Get an A?

A plus!


How many times has a student asked you:

What do I need to get on the final to get an A?

Because I am a nerd, I of course create a spreadsheet to see how low I can score on the final exam and still get an A in the course. Another student in my class liked it so I created a more formalized one as a generic template. Have your students create a copy of this spreadsheet template so they can answer that question for themselves.

A Spreadsheet Template

This does not solve the issue in the slightest, but here is a template to help students to calculate what they need to get on the final to earn the grade in the class they desire.  You will want to make a copy of this spreadsheet: http://goo.gl/Vtw5Vh.
Screen Shot 2014-04-17 at 9.54.44 AM


If you look at the bottom of the spreadsheet there are 3 tabs. The middle tab has the directions. The first tab is for calculating a what if grade based on total points. The third tab is for calculating a grade based on a weighted grading system.
Look at the tabs

Posted in Blog Entries, Spreadsheet | Tagged , | Leave a comment

5 Chrome Extensions for Teachers – Part 10

Part 10 of my series on Chrome Extensions for Teachers.
Find the other 9 parts here: Part 1 - Part 2 - Part 3 - Part 4 - Part 5 - Part 6 - Part 7 - Part 8 - Part 9


easybibI love using EasyBib to create APA and MLA citations. This Chrome extension makes it even easier to build my bibliography. Instead of having to copy and paste the URL and opening the EasyBib website I can simply click on the extension icon. The EasyBib form pops up and pre-fills in the information.

Click Here to download the EasyBib extension.

Scroll to Top Button

scroll up Save classroom time by getting back to the top of the website quickly. Once you scroll down far enough the icon shows up in the upper right hand corner of the page. Click on it to scroll back to the top. Unfortunately this does NOT work in Google spreadsheet or Google Docs.

Click Here to download the Scroll to Top Button extension.


Screen Shot 2014-04-15 at 9.37.54 PM Too Long Didn’t Read. This extension summarizes an article so you do not have to read it all first. If you are reading a blog make sure you click on the blog post title or it will summarize multiple articles at once. You can choose what level of summary you want. Save yourself time in your trek to find resources for students or looking at articles provided by your PLN.

Screen Shot 2014-04-15 at 9.43.16 PM

Click Here to download the TLDR extension.

Check All

Screen Shot 2014-04-15 at 9.53.34 PMBeing a high school teacher with around 150 students I find I have to check a lot of checkboxes. Click on this extension to check all of the checkboxes. Better yet, use the uncheck all boxes option so you do not accidentally agree to save your password or other defaults on a website.

Click Here to download the Check All extension.


citelighter First you will need to create an account at http://www.citelighter.com/

Toggle the Citelighter extension on by clicking on the blue highlighter icon. A toolbar will appear to allow you to capture information. Highlight the text you want to cite and click on capture. The text you selected will be copied into Citelighter. Any information such as article title, author, etc… that can be automatically picked up will be.
Citelighter Pop Up

Click Here to download Citelighter extension.

Posted in Chrome Apps, Google | Tagged , , | Leave a comment

Quick Web Navigation Tip: Space Bar and Shift Space Bar



When navigating a website it is quicker to hit the spacebar rather than scrolling down the page. This is also handy to keep your place. The spacebar sends you down a full screen length. This means everything on the screen is new information so long as you have not hit the bottom.

Shift Spacebar

The spacebar will leap you down the screen. Holding down the shift key as you strike the spacebar will move you back up the screen. Chances are you will accidentally hit the spacebar key while reading a website and lose your place. Shift spacebar will jump you back to where you were.

Posted in Keyboard Shortcuts | Tagged | Leave a comment

Google Hangout on Air: Watching YouTube Videos

Watch YouTube together

One of the advantages the Google Hangout (GHO) has over Skype is the ability to watch YouTube videos together at the same time. I especially like this feature for online learning. When students are asked to collaborate together Google Hangouts can be a way for small groups to get together in real time. If the instructor creates or provides YouTube videos for instruction or to lead the discussions the small groups can watch the videos together in real time and discuss them.

Add the YouTube App

As you hover over the Google Hangout window options show up on the left hand side. If you do not see the YouTube app as one of the options click on the dot dot dot (…) and choose to “Add apps.” Add Apps

Find the YouTube app tile and choose to “Add to video call.” add YouTube app

Go to YouTube App

Each person in the hangout must manually choose to go to the YouTube app. You will want to instruct everyone in the hangout to choose this option.

Add Videos to Playlist

Someone in the group needs a video to share with the group. If the teacher has specific videos for the group to watch the video links will need to be provided and one student in the group will need to add these videos to the GHO playlist. Click on the blue “Add videos to playlist” button. Add videos to playlist

One person in the group pastes the YouTube URL into the search and presses the search icon. Microphones of everyone in the hangout are automatically muted. Anyone in the hangout can add videos to the playlist this way. Click the blue “Back” button to see the videos.
search the video and mic is muted

Watch Together

This is intended to be a collaborative experience. If one person in the hangout pauses the video it is paused for everyone. Pressing the next or previous icon next to the pause button advances everyone to the next YouTube video in the collective playlist.

Recording Paused

Due to copyright issues with videos if the hangout is a Google Hangout on Air the broadcast will be paused during the shared video watching time. If the intent is to record commentary about a video while watching it, a Google Hangout on Air is not the way to accomplish this.

Posted in Google, Hangout, YouTube | Tagged , , , | Leave a comment

We Have to Do Things Differently

Sir Ken Robinson


I was presenting at the Pearson CITE conference in Fort Worth Texas last week. The opening keynote speaker was the very funny Sir Ken Robinson. One of the things he said was:

“We have to do things differently, We have to move on from some of the practices we have come very comfortable with.”

It is when we are uncomfortable that we are learning. The other keynote speaker Ian Jukes had us clasp our hands together to see if our right or left thumb was on top. Then he said to do it again but with the other thumb on top. He pointed out that it feels uncomfortable and we have this urge to switch it back. Doing things differently is uncomfortable.

The world is changing and it is uncomfortable for a lot of people. We can not put the technology toothpaste back in the tube. The innovations that have been coming out fast and furious are changing what is possible. This is causing another shift in the types of jobs people are going to be having in the future. It use to be that the majority of Americans were employed in agriculture (70% in 1870). It is now less than 2% of the population that is working in agriculture. This changed the culture dramatically. We are now in shifting away from these jobs to more creative jobs.

Technology gives me instant access to information. Looking at my tablet there is a specialized calculator for just about any math function out there. Not only will it calculate the values for me in a fraction of a second but in some cases it will also show all of the steps. I could tell students to put away their devices and put my head in the sand and pretend this technology does not exist. However, the reality is that this not going away. Very soon everyone will have some sort of mobile device and the technology we currently have is only going to get better.

So now that almost anything you teach is on YouTube, that Siri or Google Now can give you all the information you need to know at the point you are wondering, what are you going to do differently?

Posted in Blog Entries | Leave a comment

iMovie: Show Advanced Tools



As a teacher I like to add a little commentary to some of the video clips I am sharing with students. iMovie allows me to drag pictures into the timeline. I can then use my webcam to tape myself talking about the pictures or video clips I imported into iMovie. The picture in picture option allows me to have my video small on top of the the picture or video clip.

Advanced Options

iMovie allows you to do a green screen effect, picture in picture, side by side and other advanced features.
picture in picture


In the iMovie menu choose “Preferences…” and check the checkbox for “Show Advanced Tools.” This is a one time menu setting.
iMovie Preferences

show advanced tools

Drag and Drop

Once advanced tools have been enabled you can select video clips and drag them onto the timeline. For green screen, picture in picture, or other advanced features you want to drag the clip on top of another video clip. A green plus sign will signal to you that you are adding this video clip onto the current clip. Releasing the mouse will trigger the advanced options menu.

Posted in Apple, iMovie | Tagged , , | Leave a comment

Google: Sign Out Remotely




It is important to make sure that you sign out of any websites you are visiting when you are using a public computer. If you forget to sign out of your Google account you are able to sign out remotely.

Details Link

details In the bottom right hand corner of your Gmail is a link that says “Details.” This link allows you to see where your account is logged in.

Sign Out

After clicking “Details” a pop up window gives you the option to “Sign out of all other sessions.” This will log you out of the library computer you forgot to sign out of even though you are now back at home.
sign out

Show Students

When students are at school it is likely they will sign into their accounts on non personal devices. Showing this trick to students will help them keep their accounts safe. This is also an opportunity to talk about digital citizenship and online safety.

Posted in Google | Tagged | Leave a comment

Random Student Chooser Template

Screen Shot 2014-03-29 at 9.48.16 AM


CLICK HERE (http://goo.gl/fvztE3) for a template to randomly call on students.

This template is created in Google Sheets. If you are logged into your Google account you can use the File menu to make a copy.

Notice at the bottom there is a tab labeled “Roster.” Click on this tab to enter the list of names of your students. You can use this for each period you teach or for different groups you might have. Delete the default student names and enter in the names of your students.

Back on the first tab (Chooser) select the period you are randomly drawing from and a random name from the list will appear.

The spreadsheet uses a random number formula. The formula must be refreshed in order to generate a new name. You can refresh the page or type something into the spreadsheet.  A box is provided to allow you to type a word. Type a new word in the box to generate a new random name. Suggestion to type a vocabulary word or something meaningful if you are projecting the random student chooser.


Instead of entering in student names into the roster page you could instead list discussion prompts or vocabulary words.

Posted in Google, Spreadsheet | Tagged , , , | Leave a comment

Shared Spreadsheet Tip


I like sharing my spreadsheets as “anyone can edit” or allow specific people to edit the spreadsheet. The problem with sharing a spreadsheet is the potential for your cells to accidentally be deleted. Currently the new Google Spreadsheets do not allow you to protect cells. That feature is coming, but in the meantime…

Careful Placement

I try to write a lot of my formulas far on the fringes of the spreadsheet. Assume the average user will initially see the first maybe 15 columns and 50 rows. If you have cells that you want to put default information or formulas into, try using cells outside of that range. If users have to scroll in order to accidentally delete or change your information they are less likely to.

Hide Rows and Columns

If you right click on a row or column indicator there is the option to hide the row or column. hide row

Duplicate and Hide the Tab

After writing directions and formulas, click on the tab and choose to duplicate the tab. Click on the copied tab to choose to hide the sheet. If a user accidentally messes up your formulas you can find the hidden sheet and copy and paste the formula back without too much fuss. duplicate and hide sheet

Posted in Google, Spreadsheet | Tagged , , | Leave a comment

Screen Sharing in a Google Hangout on Air Video Conference

Tweet   Screen sharing is one reason I really like Google Hangouts on Air. A Google Hangout (GHO) is a video conferencing tool with some neat ways to integrate Google products and other add on’s. A Google Hangout on Air kicks the GHO up a notch and broadcasts it live through YouTube. At the end of the video conference the recording is available on the creators YouTube channel.

Google Hangout on Air

One way to create a Google Hangout on Air is to first go to http://youtube.com. After signing in, choose “Upload” at the top of the screen. Choose the 3rd option on the right:  ”Google+ Hangouts on Air.”

Once the Hangout launches, there are a lot of fun goodies you can do in a hangout. Notice at the bottom right hand corner is the option for “Links.” Use the YouTube page link to share the video broadcast live. This same link also links to the archive which is located in your YouTube account. links

Jump In Link

The jump in link is different than the broadcast link. The jump in link allows others to join the Google Hangout, not just watch it. Jump In Link


When you hover over the Google Hangout options appear. On the left hand side notice the green icon of a computer monitor with a white swoopy arrow. This will toggle screen sharing.

Controlling the Camera

The person who started the Google Hangout controls the camera. Assuming this person is you, then what you see in the main area of the GHO is what is recorded to the YouTube video. By default the person visible in the main area of the GHO is the person talking. You can stop this by clicking on the  video tiles in the bottom right hand corner.
Screen Shot 2014-03-26 at 6.02.28 PM Screen Shot 2014-03-26 at 6.02.34 PM Screen Shot 2014-03-26 at 6.02.39 PM

Notice in the first image there is NO blue box around either video tile. This indicates that the screen will switch to who ever is talking. If I click on my own video tile then the GHO will record what is on my video even if the other person is talking. If I click on the other person a blue box will appear around their video tile indicating that their video feed is what is being recorded to the YouTube video broadcast.

If you are screen sharing, then your screen will be recorded to the YouTube broadcast.

Make Sure You Click on Yourself

The tricky thing to get into the habit of is to click on your own video tile if you are sharing your screen.

You can click back on the video tile with the blue box around it to turn OFF having the video focus on your video feed.

Sample Screenshare

Thank you to Dave Mulder for being willing to help me demo screen sharing. You can see Dave’s blog at: http://iteach-and-ilearn.blogspot.com/  and find him on twitter @d_mulder

Posted in Google, Hangout | Tagged , , , | Leave a comment