How To Join Multiple Cells In A Spreadsheet.

In my last post, I showed you how to take information from one cell and split it into two different cells. In this post, I'm going to show you how to take multiple cells and combine their data into one cell.

There are a couple of ways to merge the cells, but they are both based on the concatenate feature. When you concatenating things, you are linking, or joining them together. In the example that we'll be looking at today, we're going to be taking lists of student first and last names that we have in different cells and putting them together in a different cell.

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.

Saving A Google Doc In Another Format

If you're like me, you probably think that Google Docs are the greatest things since sliced bread. That is, unless you need to use the document in a way that doesn't involve the web, say like if you want to upload the document into another program that isn't setup to accept Google based files.

If you need to convert your Google document into another format, the process is simple. With your document open, click on File, and then on Download as, which is about two-thirds of the way down the page. This will open up a list of seven different formats you can choose from, such as .docx, .pdf, .epub.

When you click on your option of file type, it will save it in your downloads folder. From there, you can upload it to that pesky program that hasn't quite gotten the hang of playing nice with Google.

Syncing Your Schoology Gradebook To Your Skyward Gradebook

In this post, I'll be explaining how to sync your Schoology and Skyward gradebooks at the beginning of a new course:

1. Choose the grading categories that you plan on using from Skyward.
2. Next, log into Schoology and navigate to your Schoology course.
3. Click on the Skyward app on the lower left side of your course and click Configuration.
4. If you don’t already see a dropdown box under the Schoology Course Categories header, press + Include Category for the categories you want to map from Skyward to Schoology.
1. Select (Create New Schoology Category) if your Skyward categories do not yet exist in Schoology.
2. Choose the corresponding category from the dropdown if it already exists.
3. If you have chosen to weight your categories in Skyward, you will be able  to view and set the weights of each category. (Note, this must be ok’d by building principals before weighting grading categories.)

We've gone Enterprise! Schoology enterprise that is.

https://c1.staticflickr.com/1/90/231478071_24bf502c2e.jpg

Great news everyone, we've decided to purchase the Schoology enterprise version this year for the secondary buildings. This is going to change the way those of you who used the free version in the past have done things, and I feel that it might interest many of you who haven't tried it in the past.

1. You no longer have to build your courses from scratch, We've linked Skyward and Schoology which means that all of the courses and sections that are built into Skyward are automatically pulled into Schoology.
2. Along those lines, you no longer have to have students join your classes by giving them the code. Because of the Skyward link, all teachers and students are already rostered to the class.
3. You only have to enter grades one time. Schoology will now become your "go to" gradebook. Any assignments that you build in Schoology will automatically be created in your Skyward gradebook, no more grading in Schoology and then turning around and entering them in Skyward.
4. You, and students, have the ability to record audio right in the assignment, discussion, or quiz/tests.

There are too many more things to list in one blog post, so I'll be sharing other tips and tricks as time goes on. If you're concerned that you don't know how this Schoology thing works, don't worry, we'll be having training sessions once school gets underway.

I'm looking forward to "...boldly going where no one has gone before" with all of you this year!