Waffle Bytes

As more educators begin to use Google Classroom, it seems as if Google keeps updating it and adding features. Here are some updated posts with the newest Classroom look. Your teacher may give you a class code to join a Google Classroom.  To join using the code, when logged in to your Google Account at classroom.google.com click on the plus sign in the upper right corner - Choose Join class in the window that pops up - 1 - Type in the Class Code provided to you then 2 - click on JOIN This will enroll you into the course and open the course up for you -

(Part of my administrative assistant series on Google Sheets.) The other task that can be labor intensive without a formula is joining fragments together into a single cell.  I can actually remember spending a whole DAY once creating student accounts that followed a certain pattern so I could upload them for auto-account creation in an online system.  This was for a single grade...and certainly not so "auto" especially considering I could have saved my day as there is an EASY way to do this :-) Similar to SPLIT, the formula needs to be applied to each item you want to split - however, using the fill capability can make that quick work.   CONCATENATE Joins data together in one cell; it can use cell references and/or fixed data.  If it is only 2 pieces of data, it can be shortened to CONCAT Example: =CONCAT(C2, "19") This will join the value of 19 to the value that is in C2. Here is an example of it -  Example:  =CONCATEN...