To view a list of Google Groups, and the members of those groups, visit: https://groups-directory.appspot.com/ You can also enter an email address in the directory to get a listing of the groups to which that user is a member.

Adding one of the below calendars to your calendar: Click the +Google Calendar button to add the calendar to your Google Calendar. All school calendar: Duties calendar: 6th Grade Test Calendar: 7th Grade Test Calendar: 8th Grade Test Calendar: Rental Calendar - Blacked Out - School Events Rental Calendar - Vinik Gym Rental Soccer Fields LC204 LC-214 (Think Room LC-225 (Community Kitchen) LC-223 (EurekaLab) MS208 MS206 https://calendar.google.com/calendar/embed?src=c_188cloku464amgq9n2pl36npfpc56%40resource.calendar.google.com&ctz=America%2FNew_York

In this tutorial, we will be heavily customizing the People Directory template in Awesome Table, and will dive in to the following techiques: Populating the template spreadsheet Customizing the HTML Template Hosting and Adding Photos from Google Drive Further Customizing the Awesome Table If you would like to follow along using the same sample data to populate the template, make a copy of this sheet. Create a copy Template Go to Awesome-table.com and Click the people directory. Follow the prompts to make your own copy. You will now have a copy of the Awesome Table view, and the spreadsheet powering the table. Take a moment to interact with both the table and the spreadsheet to see how they are structured and interact. Populate the Template with your data We'll need to delete the sample data. Be sure to not edit the first two rows of the sheet. Enter in your data. Here, we populate the Columns A, F and G. Note that in columns F and G, we are storing different data than the template. While column F had Country Data, we are now storing the Voiced By data, and in G rather than Department, we are storing Quote. You will need to be very careful when editing the first two rows, including column labels, as these drive the template and the Awesome Table view. Continuing following the instructions to edit the template to account for these changes. Edit the HTML Template We now need to edit the template. Switch to the Template sheet. Any time you see text surrounded by double curly brackets, {{like this}}, that data is being merged into the card view in the Awesome Table from the sheet. The {{double curly bracket tags}} refer to column titles in row 1. Let's update Country to now be Voiced By, and Department now to be Quote. If you know some basic HTML, you can further edit the template. Be careful, as your HTML needs to be formatted correctly (always close your tags with the corresponding closing </> tag. For basic information on HTML, refer to the W3Schools HTML Reference Site. Adding the Photos Now we will tackle a trickier issue. We want to provide photos to display in the Awesome Table. These photos need to be hosted in Google Drive and linked to in the sheet in a particular way. First, start with a folder of images where each image has the same file name as one of the columns in your sheet. In this case, each photo uses the same exact First Name as in the Sheet (it must be exact to the character - watch extra spaces, punctuation, etc). If you are following along, make a copy of this folder to have the sample directory photos. We now need a way to easily create working links to these photos. The links are not typical Google Drive sharing links, but direct links to the photos themselves. We will use another Awesome Table tool, the Photo Gallery, as a "hack" to easily create these links. Go to the template list at awesome table and select Photo Gallery Install the add-on Grant the necessary permissions. In the new blank spreadsheet, click use the existing album as we have a folder of photos to use. Grant the necessary permissions. Close the tab. Click use existing album again. Select the folder that contains your photos. In this case we are using the Lego Movie Directory Photos folder Awesome table creates a photo gallery. We won't be using this, and can close the tab. However, Awesome Table creates a helpful spreadsheet which contains the Photo Title, ID and URL. Copy this Data... Navigate to your directory sheet and create a new sheet Paste the data into the sheet. Insert a new column to the right of the photo file name, and use the following formula to only have the name, not the file name. This formula drops the last 4 characters from the text string in the cell. =Left(A1,LEN(A1)-4) The left formula will display the characters in a string starting from the left. So Left(A1,3) will show the first 3 letters of a string. We want to drop the last 4 characters off of the string. To do this, we will find the length of the string using LEN(), and subtract 4, and use that in our left formula. Fill this formula down the column you created. Here we see an example of the column with the title minus the file extension. Now for the trickiest and funest part! In the main sheet, in the Picture column, we will be creating a formula that will look up (match) the name to the ID, and then create the URL will need to display the photo. First, let's look at the URL that we need to create. Here's an example: http://drive.google.com/uc?export=view&id=1KXQC_M9Xx2_3axp8rwdte77dCSy-0Jkv This URL is a special one, in that it links directly to the photo as a file and can be referenced using the HTML . Note that while the URL is long, it follows a pattern. http://drive.google.com/uc?export=view&id= comes first, followed by the ID, in this case 1KXQC_M9Xx2_3axp8rwdte77dCSy-0Jkv. So we can create these URLs combining the ID with the first, consistent part of the URL (http://drive.google.com/uc?export=view&id=). To do this, let's start by matching, or looking up, the ID for a Name To do so, we will use the Lookup Function. This function takes a cell, looks at a range, finds that match and then displays the content of cells in another column. Here we want to find the name and then result in the ID. =vlookup(A3,Sheet1!$B$1:$D$9,3,False) is the formula we will use. Let's break that down. A3 has the name we want to find in our ID table (the one we made with the Photo Album feature and pasted in) Sheet1!$B$1:$D$9 is the range where the table is. We've added the $ in the cell references as we don't want the reference to change when we fill down - the range stays the same no matter what. 2 refers to the column in the range that we want to return. we want to return the ID, which is found in the second column over in the range. False is a keyword that looks for an exact match. We want the ID that exactly matches the name. You should see this results in the Matching ID for the photo. Now, let's take that ID and combine it with the URL pattern to make the URL we need. Remember, our URLs should look like: http://drive.google.com/uc?export=view&id=1KXQC_M9Xx2_3axp8rwdte77dCSy-0Jkv We will use the concatenate to combine two strings - "http://drive.google.com/uc?export=view&id=" and the ID (which is the vlookup formula we made). We then wrap this in a IFERROR function, which will hide errors if any occur. This will make the Awesome Table View stay "pretty" even if data we give it is in error - it won't display anything rather than an error message. Here's the final formula we created: =IFERROR(concatenate("http://drive.google.com/uc?export=view&id=",vlookup(A3,Sheet1!$B$1:$D$9,2,false),"")) Fill this down the column. Check the Awesome Table view - you should now see the photos displaying! Further Customizing the Data and Template Let's further customize the template. We won't be using Weight or Birth Date, so let's remove those columns. Now our data only spans from A to K, so we can edit the Data Source to A1:K in Awesome Table. Error! When we do this, an error occurs. We need to adjust the Query settings as well. Under Advanced Parameters, Remove the column letters from the Query. In this case we need to delete K and L wherever they occur. Now the Awesome Table should display again. Continue using these techniques! You can continue using these techniques to further customize your Awesome Table, by adjusting the HTML templates, columns and column types and adjusting the query. Take your time, move slow and be ready to back track if anything goes wrong!

After you've entered your username and password, you'll need to click or tap "Try another way to sign in". Select "Get a text message with a verification code at (...) ...-.xx" If you don't have another method to get into your account, email the help desk at help@meadowbrook-ma.org Wait for the text message to show up. If you are trying to authenticate on the same device that you're signing in with,  make sure don't get out of the authentication screen or switch apps. The Google login screen may disappear and start you over. Enter the code and tap "Done"

Occasionally, you might accidentally allow notifications from a distracting site. Follow these steps to control what notifications you receive. The problem - unwanted notifications Above is an example of of an unwanted notification. Click Settings to change your notification settings Now, click the 3 dots to the right of a site, and remove the unwanted notification. If you don't see the Settings button in your notification, follow these steps. Go to chrome settings by clicking the 3 dots in the far right of chrome Click Advanced. Click Content settings Click Notifications Now, click the 3 dots to the right of a site, and remove the unwanted notification.

Certain websites might ask you to allow mic and camera access in Google Chrome. This can be done through your Chrome settings Start by ensuring sites can request access to the mic and camera Type "chrome://settings" into your URL bar in Chrome to get to your Chrome settings In the search bar at the top, type "site settings" and click on this menu option when it appears under privacy and security Ensure Camera and Microphone are set to "Ask before accessing." If they are, you may skip the next step If they are set to "Blocked" click on either one and click on the switch to change it to "Ask before accessing." Repeat this step for the other (so both camera and microphone are set the same). Once this is enabled, websites will be able to request access with a pop-up message that asks you to "Allow" access for their site If this does not work, please reference this article to allow mic and camera access on your mac

What are some of the benefits of having multiple accounts signed into Chrome at the same time you may ask? Let's say you have your personal Gmail Account. But you also have your Meadowbrook GmailAccount and Google Apps for that account. Then there's your Google Accounts for any clubs/organizations you may run or be a part of. Having all of these accounts can be difficult to manage, luckily with Chrome you can have all of your workspaces separated from one another! Here's how : Add a Person or Profile 1. On your computer, open Chrome. 2. At the top right, click the button with your name or People 3. Click Manage people. 4. Click Add person. 5. Choose a name and a photo. 6. Click Add. A new window will open and ask you to sign in. 7. (Optional) Sign in to Chrome with a Google Account for the new profile. Their bookmarks, history, passwords, and other settings will automatically sync. Switch to another person or profile 1. On your computer, open Chrome. 2. At the top right, click the button with your name. 3. Choose the person or profile you want to switch to. (Below "Other People" should be a list of all accounts you are signed into). Change a Name or Photo 1. On your computer, open Chrome. 2. Switch to the profile you want to edit: At the top right, click the button with your name. Choose the person or profile you want to switch to. 3. At the top right, click the button next to your name with the 3 dots. 4. Click Settings. 5. Click Chrome Name and Picture 6. Choose new Chrome Name and Picture and hit the back button. Chrome should automatically save these changes. Remove a Person or Profile After you remove someone from Chrome, their bookmarks, history, passwords, and other settings are erased from the computer. 1. On your computer, open Chrome. 2. At the top right, click the button with your name or People. 3. Click the Settings gear next to Other People. 4. Point to the person you want to remove. 5. At the top right of the person, click More (3 dots). 6. Confirm by clicking Remove this person.

When using a shared resource like the Eureka Lab, you can see when it is available and reserve it using Google Calendar Viewing the Resource Calendar In Google Calendar, the left navigation bar has options to show and hide many calendars. Click on the plus symbol next to "Other calendars" Next, select Browse resources from the dropdown list that appears. The available rooms and resources are grouped by location within Meadowbrook. Expand the group to see individual calendars for resources within that location. Select the calendar you wish to view from the list in that location. The calendar will now appear in your view and can be turned on and off by clicking on the box next to it in the Other calendars section of the left navigation pane in your Google Calendar. Reserving a room or resource on Google Calendar Rooms and resources are not directly reserved on their Google Calendars. Instead, they are added in the same area where people are invited to calendar events. Check the resource calendar to make sure there is no conflict and then you can reserve the room or resource. To do this, create or edit an existing event on your Google Calendar. You can double click an existing event or double click in an open space to get the the full event editor window. After you add title, date, and time information, select the Rooms tab Navigate to the room/resource you wish to reserve from the dropdown list. You can search the room/resource name in the search bar in the window. You can navigate the location sections expanding the one you want using the arrow next to it. The room/resource you want may show up in the suggested section at the top of the list. Once you have selected your room/resource, your reservation should show up as an event in your calendar and then a few moments later show up in the room/resource's calendar as well. If you move your event or cancel it, these changes will be reflected in the other calendar, as well.

Adding your schedule to Google Calendar allows others to easily schedule meetings and see conflicts between multiple calendars. It also reduces the number of emails about scheduling allowing your email inbox to be less cluttered. First, open Google Calendar and navigate to the first day of a course/activity. Double click on that day, anywhere, to bring up the detailed event window. Give your recurring event a name. Set the time for your event. You can add location information, video conferencing, etc. Don't change the calendar from your default calendar. If there is an agenda or any other materials pertinent for this event, you can add them here. This is the important piece. Click on the Does Not Repeat button. Select Custom... from the drop down list. In this box, select the days of the week for this course/event  Then select the Ends On button and select a calendar date for the event to terminate.   Click all the Done and Save options until your are back to your calendar. You now have a recurring event that runs as long as you set it to run. You can delete individual events in a recurring event without deleting all of the events.    Navigate to the individual instance of the event you wish to delete. Click once on it to bring up the information window. Click on the trash can icon Select This event.

First open or create the Drive folder in which your photos will be deposited. Have this folder open in a Chrome tab. In this example, there is an empty folder titled "Photos from Photobooth tutorial. Next, open Photobooth. You may want to use an external camera, like a webcam, to avoid holding your laptop at weird angles to capture an image. If so, select the camera menu and select the camera you wish to use. In this example the webcam has been enabled instead of the built in FaceTime camera. Snap a picture in Photobooth. You will see it show up in the file tray under the active photo window. In this example, the photo of red wires was taken and can be saved, deleted, or edited. Drag your photo into the Google Drive folder open behind the Photobooth app. In this example, the red wires photo is dragged from photobooth into the Google Drive folder.