How To Split Cells In A Spreadsheet

Have you ever had a spreadsheet where you'd really like to split a cell that contains multiple data points (last name, first name) into individual cells with only one data point each? I know that I used to use this a lot for taking my class roster and separating the last and first names. Today I'm going to show you how to use the Text to Columns feature, in both Google Sheets, and Microsoft Excel to do just that.

Google Sheets:

As you might expect, with Google Sheets generally being a simplified version of Excel, the process of splitting text to columns is fairly simple.

1. Right click on the column to the right of the column that contains the text you'd like to split.
2. Choose the option Insert 1 left; you're going to need to do this for each additional word. Since I will end up with two separate words in this example, I only need to do this step once as I only need one extra cell.
3. Highlight the cells that you want to split.
4. Click the Data heading from the toolbar.
5. Click Split text to columns. This will take the first name and place it into the second column that you just added.

You Asked For It, We Answered!

Since we started using Illuminate and Schoology as a district, teachers have been lamenting the fact that students are able to open other windows or tabs in their browser while taking online tests. While there are programs that can lock down the browsers, those have a cost associated with them.

I'm happy to announce that I've developed kiosk logins that can be used with the Chromebooks that are similar to what we used with the M-Step assessment last year. Now, you can have students log into one of two kiosks before they log into the Chromebook and they will be taken either to either the Illuminate student portal, or to Schoology.

Before students login to their Chromebooks, they should click on Apps which can be found in the lower left hand corner, right next to where they click to shut the Chromebook down. Once they click there, a window will pop up with the different Kiosks that we have loaded into the machines. Have students choose the app associated with the program in which they are testing.

If they're using the Illuminate Kiosk, they will go to the Student Portal and will be asked to input their username and password as usual. If they are logging into Schoology, they will be asked to enter their email and password.

When logged into any of these kiosks, students are unable to leave the window that they're logged into, making it impossible to tab over to different websites to look up answers. When students are done with the assessment, they will need to power down the device in order to freely move around the web.

REMC Classroom Maker Project (#cmakers)

I just wanted to share some exciting information with you that I just heard about through the CISD.

The REMC Classroom Makers (#cmakers) project is a multi-year effort to provide local REMCs with maker training, curriculum and materials to be used with their districts to support and expand curricula and learning.  Makering is the convergence of hands-on DIY and technology.  It involves problem solving through failure, creativity, exploration and often collaboration. 

I went to one of the training sessions with Melinda Waffle last week and got some hands-on training with the different kits that she is putting together, all available for you to check out!

Some of the kits available for you include:

• Circuitry Kit - create circuits that turn on lights, make noises, spin motors, etc.
• Coding Kit - create code that makes robots move and interact with their surroundings
• Construction Kit - allow your students to be creative with hands-on manipulatives
• Gaming kit - create games that can be played on tablets
• Robotics Kit - program robots to perform different actions

Individual Items

• 3D Printer with laptop Bloxel set
• Breakout EDU Box Dash (robot)
• Google Cardboard (up to 5) Green Screen
• Keva Planks Little Bits kit
• Makey-makey kits (up to 5) Osmo (Numbers, Letters & Tangram)
• Ozobot set Snap Circuits (up to 2 kits)
• Sphero Strawbee connectors

If you're interested in learning more about these exciting items, check out the CISD website.