Please login with your NEOnet account.

Edit
Login Help?

Password Reset
If you are unable to login, and password reset did not help, please create a helpdesk ticket via email or phone (330.926.3900).

Login Help?

Password Reset
If you are unable to login, and password reset did not help, please create a helpdesk ticket via email or phone (330.926.3900).

Learn something new in 2 Minutes!

Google Sheets

34 STEPS

1. The first step is to open a Google Sheet that has data in it, including at least one column of recipients’ email addresses.

Step 1 image

2. Click Extensions

Step 2 image

3. With your mouse, hover over Mail Merge for Gmail.

Please Note – if you do not have this extension, you will need to install it.

Step 3 image

4. Click ‎‎‎Start

Step 4 image

5. You have the option to edit the pre-made template, but for now click New Template

Step 5 image

6. In the first box, type Hogwarts Letter

Step 6 image

7. Now we can customize the Email’s subject line. Click into the Email Subject box

Step 7 image

8. We will create our first “Merge Tag” here.

To create a “Merge Tag” you will use double curly brackets {{ and }} around the title of the column of the sheet you want to merge. Curly brackets are found in the upper right corner of your keyboard

Step 8 image

9. In the highlighted box, type the following: {{Student First Name}}

Step 9 image

10. Now we can type the body of the email. Type the following: Dear {{Parent First Name}} {{Parent Last Name}},

Step 10 image

11. You have the option to add as many Merge Tags as you’d like.

Just be sure to use double curly brackets surrounding the same words that appear in the heading columns of the sheet.

Step 11 image

12. The body editor allows for some formatting options.

Click the font dropdown to select a different font.

Step 12 image

13. Click Arial Black

Step 13 image

14. Click Italics

Step 14 image

15. Click Save and close

Step 15 image

16. This area gives you a preview of how your mail merge will be sent.

You will notice two issues.

Step 16 image

17. This tag did not merge

Step 17 image

18. Nor did this tag. Both have typos that prevented merging.

Step 18 image

19. Click Edit Template

Step 19 image

20. This tag is incorrect because it has an apostrophe, whereas the column heading does not

Step 20 image

21. This tag is incorrect because it only has one curly bracket at the beginning.

Step 21 image

22. The changes have been made.

Click Save and close

Step 22 image

23. Click the arrow to view the next merge row’s preview

Step 23 image

24. You will notice the preview changed.

Click the arrow again

Step 24 image

25. Click the arrow again

Step 25 image

26. The Recipient Column menu allows you to select who will receive each merged email.

In this example, Column G contains the parent email addresses.

Step 26 image

27. Click More options

Step 27 image

28. You can designate who will be carbon copied or blind carbon copied.

Click the dropdown under CC

Step 28 image

29. This spreadsheet has alternate email address in Column H.

Click H

Step 29 image

30. The Sender Name box will allow you to add a custom name to the “From” field.

Step 30 image

31. The Reply To box will allow you to add a custom reply address to the “From” field.

Step 31 image

32. Recipients will see this in their From line.

Step 32 image

33. Click Send

Step 33 image

34. That’s it. You’re done.

Step 34 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1907312/How-to-Mail-Merge-in-Google-Sheets?iframeHash=trysteps-1

22 STEPS

1. The first step is to click Data

Step 1 image

2. Click Protect sheets and ranges

Step 2 image

3. Click Add a sheet or range

Step 3 image

4. Note: you can protect an entire sheet (tab at the bottom), or a range within a sheet. For this tutorial, we will focus on protecting a range.

Step 4 image

5. Click the symbol for selecting a data range

Step 5 image

6. Using your mouse, highlight all of the letter grades. Begin clicking on Cell B2, then drag to Cell E9

Step 6 image

6b. Drop

Step 6b image

7. Now that the range is highlighted, click Ok

Step 7 image

8. Click Set permissions

Step 8 image

9. This window allows you to select who is able to edit the protected sheet or range.

Step 9 image

10. Click the dropdown menu

Step 10 image

11. Click Custom

Step 11 image

12. This section will allow you to add specific people as editors of the protected sheet or range. All others will be prevented from editing the protected sheet or range.

Step 12 image

13. Let’s set this range to only be editable by you. First, click the dropdown menu

Step 13 image

14. Click Only you

Step 14 image

15. Click Done

Step 15 image

16. Let’s see what it looks like if someone tries to edit a protected sheet or range.

Step 16 image

17. Try to change Andrew Anderson’s Q1 Grade to B+

Step 17 image

18. If the cell is within a protected sheet or range, this message will appear. Click OK

Step 18 image

19. Any collaborators can view the list of protected sheets and ranges. Click Data

Step 19 image

20. Click Protect sheets and ranges

Step 20 image

21. All protected sheets and ranges will be found here.

Step 21 image

22. That’s it! You’re done!

Step 22 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1892641/How-to-Protect-Sheets—Ranges?iframeHash=trysteps-1

15 STEPS

1. This is what the finished chart will look like.

Step 1 image

2. A Google Sheet with an Average column is required.

Step 2 image

3. In the first cell under Average, type the following: =average(

Step 3 image

4. With your mouse, click and drag from Cell B2 to Cell B9.

Step 4 image

4b. Drop

Step 4b image

5. Note: If you press the F4 key on your keyboard, it will mark the formulas as an absolute reference. This means the formula will not be adjusted when it auto-fills.

You can see the formula has added dollar signs ($) in between the cell coordinates.

Step 5 image

6. Double-Click on the small blue square to fill the formula to the bottom of the column.

Step 6 image

7. Now the series is filled!

Step 7 image

8. The next step is to crate the chart. Click Insert

Step 8 image

9. Click Chart

Step 9 image

10. That is how you can create the chart!

Step 10 image

11. You can use the chart editor to change colors, line thickness, and other settings.

Step 11 image

12. You also have the option to share the chart with others. Click the 3 dots in the upper right of the chart

Step 12 image

13. The Publish Chart option will allow you to share the chart with others via a link or embed it on a webpage.

Step 13 image

14. You also have the option to move the chart to its own sheet. This will create a new tab at the bottom just for the chart.

Step 14 image

15. That’s it! You’re done!

Step 15 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1892675/Creating-a-Chart-with-an-Average-Line?iframeHash=trysteps-1

13 STEPS

1. The first step is to open Google Sheets

Step 1 image

2. With your mouse, click and drag in cell B1, then drop it on cell B8

Step 2 image

2b. Drop

Step 2b image

3. Click Data

Step 3 image

4. Click Data validation

Step 4 image

5. Click the dropdown list next to Criteria

Step 5 image

6. Click List of items

Step 6 image

7. In the adjacent box, type the following: Present, Absent, Tardy, then hit enter.

Please note: In reality, you can enter anything you want

Step 7 image

8. Click Save

Step 8 image

9. Click the first dropdown box next to Andrew Anderson

Step 9 image

10. Click Present

Step 10 image

11. Click the dropdown box next to Betty Brown

Step 11 image

12. Click Absent

Step 12 image

13. That’s how you can make dropdown boxes in Google Sheets!

You can use them to take attendance, grade, prepare lessons, and more!

Step 13 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1881454/How-to-make-dropdown-boxes-in-Google-Sheets?iframeHash=trysteps-1

Google Calendar

21 STEPS

1. The first step is to open Google Calendar

Step 1 image

2. Click the 3 Dots next to the name of the calendar you want to share.

Step 2 image

3. Click Settings and sharing

Step 3 image

4. Click Access permissions for events

Step 4 image

5. There are several different sharing options available to you. The first will make your calendar publicly available to anyone.

Step 5 image

6. Click the checkbox next to Make available to public

Step 6 image

7. This notification will appear. Click OK

Step 7 image

8. At any point, you can stop making your calendar public. Click the checkbox next to Make available to public again.

Step 8 image

9. Another sharing option is to allow anyone in your organization to view your calendar. Click the checkbox next to Make available for NEOnet

Step 9 image

10. Click Get shareable link

Step 10 image

11. You can use this link to share your calendar. Click Copy link

Step 11 image

12. You also have the option to share your calendar with specific people. Click Add people

Step 12 image

13. After adding a person’s email address, click the Permissions dropdown menu

Step 13 image

14. Please note, options may be limited by your Google Administrator.

Select See all event details

Step 14 image

15. Click Send. This will send your recipients an email notification about your calendar.

Step 15 image

16. If you want to view other people’s calendars, you will need to subscribe to their calendar.

Step 16 image

17. Click Add calendar

Step 17 image

18. Click Subscribe to calendar

Step 18 image

19. Enter the email address of the person whose calendar you wish to have access to.

Step 19 image

20. Click Request access. This will send them an email notification.

Step 20 image

21. That’s it. You’re done.

Step 21 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1897900/Google-Calendar—How-to-Share-Calendars?iframeHash=trysteps-1

Google Drive

48 STEPS

1. We can move single files into folders to begin organizing.

Right Click over the highlighted document

Step 1 image

2. Click Move to

Step 2 image

3. Click New Folder icon

Step 3 image

4. In the box, type Other

Step 4 image

5. Click Check Mark

Step 5 image

6. Click Move here

Step 6 image

7. With your mouse, click and drag between the two indicated points.

This will highlight all of the files in-between.

Step 7 image

7b. Drop

Step 7b image

8. With your mouse, click and drag from any of the highlighted files up to the Other folder

Step 8 image

8b. Drop

Step 8b image

9. Click Name to change how the page is sorted

Step 9 image

10. Click Last modified

Step 10 image

11. Click highlighted icon.

Step 11 image

12. This changes it to a list view.

Click Last modified

Step 12 image

13. Click Last modified

Step 13 image

14. Holding the Shift Key after single-clicking on a file then clicking another file will highlight everything in-between.

Step 14 image

15. Right Click on any of the highlighted files

Step 15 image

16. With your mouse, hover over Add to workspace

Step 16 image

17. Click Create new workspace

Step 17 image

18. Type Example Workspace

Step 18 image

19. Click Create

Step 19 image

20. Workspaces are found in the Priority section.

Click Priority

Step 20 image

21. Click Example Workspace

Step 21 image

22. Click Add files

Step 22 image

23. Click The Gnat & the Bull

Step 23 image

24. Click Insert

Step 24 image

25. Click Done

Step 25 image

26. Click My Drive

Step 26 image

27. Right Click on Other Folder

Step 27 image

28. Click Add to Starred

Step 28 image

29. Click Starred

Step 29 image

30. You can add as many files and folders to your Starred menu as you want!

Step 30 image

31. Right Click on Other Folder

Step 31 image

32. With your mouse, hover Change color

Step 32 image

33. Click orange color

Step 33 image

34. Click the “i” information icon

Step 34 image

35. Click Details

Step 35 image

36. You can quickly view information about a file or folder.

Step 36 image

37. Click Activity

Step 37 image

38. This page quickly shows who made changes, and what changes they made.

Step 38 image

39. Click close

Step 39 image

40. Click Shared with me

Step 40 image

41. With your mouse, click and drag between the two highlighted points.

Step 41 image

41b. Drop

Step 41b image

42. Right Click over either of the highlighted files

Step 42 image

43. Click Add shortcut to Drive

Step 43 image

44. Click My Drive

Step 44 image

45. Click Other

Step 45 image

46. Click Add shortcut

Step 46 image

47. When adding shortcuts to Drive, those files will appear in both the original and destination folders.

Step 47 image

48. That’s it. You’re done!

Step 48 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1907551/How-to-Organize-Google-Drive?iframeHash=trysteps-1

12 STEPS

1. The first step is to open the Share Menu for any Google Doc, Slide, Sheet, or Form.

Step 1 image

2. Click Get link

Step 2 image

3. Now we need to change the link to be accessible to anyone.

Click Restricted

Step 3 image

4. Click Anyone with the link

Step 4 image

5. Click Copy link

Step 5 image

6. Click Done

Step 6 image

7. Paste the link with Ctrl + v

Step 7 image

8. In the URL, find the word “edit” and replace it with “copy

Step 8 image

9. The link can now be copied and shared with others.

Step 9 image

10. This is what people will see when they click on your link.

Click Make a Copy

Step 10 image

11. This copy is owned by the one who made the copy, not you. Any changes they make will not affect the original.

Step 11 image

12. That’s it. You’re done!

Step 12 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1907349/How-to-Force-Make-a-Copy?iframeHash=trysteps-1

Google Forms

This tutorial will explain how to import grades from a Google Form Quiz to your Google Classroom Gradebook

18 STEPS

1. The first step is to open your Google Classroom and click Classwork

Step 1 image

2. Now click Create

Step 2 image

3. Now click Assignment

Step 3 image

4. Click in the Title box

Step 4 image

5. Type Example Quiz in the Title box, then hit enter

Step 5 image

6. Click the Google Drive attachment icon

Step 6 image

7. From here, we will attach the Google Form Quiz we created – select the one titled Example Quiz

Step 7 image

8. Click Insert

Step 8 image

9. Click the button to turn on Grade Importing

Step 9 image

10. Click Assign to make the quiz available for students to take

Step 10 image

11. When students are all finished taking the quiz, come back to Google Classroom and click Grades

Step 11 image

12. Click Example Quiz to view more details

Step 12 image

13. All of the students have turned in the quiz, but we do not see their grades yet.

Click Import grades

Step 13 image

14. Click Import

Step 14 image

15. Click the checkbox next to “Turned In” to return the grades to students

Step 15 image

16. Click Return

Step 16 image

17. Click Return

Step 17 image

18. That is how you can import grades from a Google Form Quiz to Google Classroom!

Step 18 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1881931/How-to-Import-Grades-from-Forms-to-Classroom?iframeHash=trysteps-1

Gmail

16 STEPS

1. This tutorial will show you how to create a collaborative email template in Google Docs!

Step 1 image

2. The first step is to open a Google Doc

Step 2 image

3. Type @email

Step 3 image

4. Click Email draft

Step 4 image

5. This template will allow you and anyone who has edit access to this Doc to enter information that will appear in the email

Step 5 image

6. Next to the “To” section, type principal@school.org

Step 6 image

7. Collaborators can add as much information as they like.

Step 7 image

8. Click the Gmail Icon

Step 8 image

9. A new window will open with the draft email

Step 9 image

10. Click More options

Step 10 image

11. With your mouse, hover Templates

Step 11 image

12. With your mouse, hover Save draft as template

Step 12 image

13. Click Save as new template

Step 13 image

14. Type new template in the box

Step 14 image

15. Click Save

Step 15 image

16. That’s it. You’re done.

Step 16 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1939465/Google-Docs-Email-Templates?iframeHash=trysteps-1

Click to access the login or register cheese