Aug 15, 2017

Google Calendar: Import Events with CSV file

Google Calendar is instrumental in keeping me, and those who work with me, on track. To prepare for the new year I enter weekly lab, library, and coaching events. I also enter my club schedule (several 3-5 week sessions and 1 year long).  For the weekly events I add the first and repeat the event until the last week of school -- easy-peasy. But club schedules are more varied, and often interrupted by early dismissal or no school days. That leaves too much room for error, especially for those of us who are number challenged.

The simplest and quickest solution I have found involves a spreadsheet (doesn't it always?).
  1. Open your preferred spreadsheet software.
  2. Enter your preferred headers. Only Subject and Start Date are required.
    • Subject (event name)
    • Start Date (format: 12/01/2017)
    • Start Time (format: 9:30 AM)
    • End Date (format: 9:30 AM)
    • End Time (format: 9:30 AM)
    • All Day Event (enter True or False)
    • Description
    • Location
    • Private (enter True or False)
  3. Add your event data. (For my clubs, I copy paste the dates from the my planning spreadsheet.) Keep in mind that how content formatting is very important -- when in doubt, set the cell formatting as "text" to ensure the software does not automatically reformat dates or times.
  4. Save the completed file as CSV (comma delimited).
  5. Go to Google Calendar.
  6. Click the down arrow next to Other calendars. Select Import calendar.
  7. Locate and choose the recently created CSV file.
  8. Select the calendar where events will be added. (Tip: to test, create a temporary calendar and import events to ensure correct formatting.)
  9. Click Import. If successful, your events should not appear in Calendar. If you see an error message, visit this Calendar Help page for troubleshooting support.

Looking for more? This Google Calendar help page has step by step instructions on how to create and import a csv file.

Nov 16, 2016

Prodigy: Fantasy Math Game

Prodigy is a freemium interactive math tool that integrates game-based learning and teacher friendly management and reporting tools. Teacher and classroom accounts are completely free; parents have the option to upgrade to access non-essential/non academic game content.

Teachers may create student accounts, or students can create their own and join the class with a teacher provided code. Usernames and passwords are automatically generated -- a negative for districts that use standard logins. Students can access the games either through the website or the Chrome app.

Games allow students in grades 1-8 to play games and practice Common Core aligned content. The game interface reminds me of Nintendo DS games -- there is a dialog box at the bottom of each screen where Noot (a fairy like creature) guides the new Wizard (student) through the game. Limited reading is required, although the game is intuitive and easy to follow. Students can play through all skills at their own pace, or teachers may create assignments based on single or multiple skills. On screen tools such as pencils, counters, fractions, base blocks, and coins help students work through their response. Incorrect response result in hints that explain how to find the correct answer.

Students can interact with other players, although this is limited. Game names are completely different than real life names; no personal information is shared or shareable. Teachers can monitor progress and usage through several reports: weekly activity, standard coverage, topic coverage, student usage, and student progress.

Support is easily accessible and plentiful:
  • Zendesk powered Support links to common topics, an active community forum, and a support ticket for unique issues.
  • Resources page links to videos, upcoming webinars, presentations, and additional resources.
  • The Prodigy blog has great resources for implementing Prodigy and game-based learning in the classroom.
  • Browse play throughs at ProdigyGame YouTube channel.

Nov 14, 2016

On the School Sites: Picture Book Month

This week our School Sites are celebrating Picture Book Month! Students will be asked to vote for their favorite picture book.
Middle school students will write-in their favorite titles and/or authors. Elementary students will have a ballot comprised of the top 10 favorites (based on circulation records for the past 4 years, excluding multiples in series or authors):
  • Don't let the Pigeon Drive the Bus! by Mo Willems
  • Chippy Chipmunk by Kathy Miller
  • Fancy Nancy by Jane O'Connor
  • Green Eggs and Ham by Dr. Seuss
  • Hooray for Fly Guy by Tedd Arnold
  • Houdini by Kathleen Krull
  • If You Give a Mouse a Cookie by Laura Numeroff
  • Martin's Big Words by Doreen Rappaport.
  • Mermaid Queen by Shana Corey
  • Scaredy Squirrel by Melanie Watt


Nov 9, 2016

Digital Citizenship: Email Security

G Suite accounts provide access to more than just email -- your login gives access to files stored in Drive, private Sites, and saved passwords in Chrome. It is not just your data that could be compromised, it is also student, colleague, and district information. Don't be the weak link in your school's security chain: protect your password, read popup and other messages, think critically about what email messages and links are asking you to do. Anyone can be fooled, even the most "tech savvy" professionals: This is the email that hacked Hillary Clinton’s campaign chief.
  • If you have any doubts about a message, forward it to your district technology team.
  • Carefully read all messages. Rarely does a reputable company send a message with spelling errors or odd logos.
  • Hover over links to see if they are legitimate. Put your cursor over a link; look at the address that appears in the lower left corner. A common trick is the include a legitimate looking address in the url. 
  • Avoid shortened URLs from unexpected sources. Google (and other sites) will not use URL shorteners, especially regarding security. If an email asks you to check your settings, manually type the true address (not the tinyurl or bitly) in the address bar.

Nov 7, 2016

On the School Sites: Election Day

Like many schools across the United States, our students have been exploring the presidential election process in their classrooms. Teachers have carefully navigated the news reports in order to keep the focus on media and political literacy. It was interesting to hear the older students discuss the challenge in differentiating news from gossip, and how all of that impacts their view on the candidates (and the election process).

Since the election takes place early in the week, our front page media is lighter on election, heavier on fun.

The elementary school site presents a retelling of a silly election story: Doreen Cronin's Duck for President (as retold by Miss Yumi).

Middle school students can bop along with Flocabulary's Presidential Election Process.

On Tuesday the middle school will have a mock election where the will cast a vote for President. Based on "population," each homeroom has been designated 1 or 2 electoral votes. Will the homeroom teachers follow the will of the students? Or will they vote for their preferred candidate?

Oct 23, 2016

On the School Sites: Apples and Cavities

In celebration of apple picking season, the elementary students have Ten Apples Up On Top sung in the style of Jason Mraz.

In anticipation of the candy-filled holiday Halloween, our middle school students can learn something about tooth care from the TedEd video "What Causes Cavities?"