Please login with your NEOnet account.
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).
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).
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).
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).
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.
2. Click Extensions
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.4. Click Start
5. You have the option to edit the pre-made template, but for now click New Template
6. In the first box, type Hogwarts Letter
7. Now we can customize the Email’s subject line. Click into the Email Subject box
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 keyboard9. In the highlighted box, type the following: {{Student First Name}}
10. Now we can type the body of the email. Type the following: Dear {{Parent First Name}} {{Parent Last Name}},
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.12. The body editor allows for some formatting options.
Click the font dropdown to select a different font.13. Click Arial Black
14. Click Italics
15. Click Save and close
16. This area gives you a preview of how your mail merge will be sent.
You will notice two issues.17. This tag did not merge
18. Nor did this tag. Both have typos that prevented merging.
19. Click Edit Template
20. This tag is incorrect because it has an apostrophe, whereas the column heading does not
21. This tag is incorrect because it only has one curly bracket at the beginning.
22. The changes have been made.
Click Save and close23. Click the arrow to view the next merge row’s preview
24. You will notice the preview changed.
Click the arrow again25. Click the arrow again
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.27. Click More options
28. You can designate who will be carbon copied or blind carbon copied.
Click the dropdown under CC29. This spreadsheet has alternate email address in Column H.
Click H30. The Sender Name box will allow you to add a custom name to the “From” field.
31. The Reply To box will allow you to add a custom reply address to the “From” field.
32. Recipients will see this in their From line.
33. Click Send
34. That’s it. You’re done.
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
2. Click Protect sheets and ranges
3. Click Add a sheet or range
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.
5. Click the symbol for selecting a data range
6. Using your mouse, highlight all of the letter grades. Begin clicking on Cell B2, then drag to Cell E9
6b. Drop
7. Now that the range is highlighted, click Ok
8. Click Set permissions
9. This window allows you to select who is able to edit the protected sheet or range.
10. Click the dropdown menu
11. Click Custom
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.
13. Let’s set this range to only be editable by you. First, click the dropdown menu
14. Click Only you
15. Click Done
16. Let’s see what it looks like if someone tries to edit a protected sheet or range.
17. Try to change Andrew Anderson’s Q1 Grade to B+
18. If the cell is within a protected sheet or range, this message will appear. Click OK
19. Any collaborators can view the list of protected sheets and ranges. Click Data
20. Click Protect sheets and ranges
21. All protected sheets and ranges will be found here.
22. That’s it! You’re done!
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.
2. A Google Sheet with an Average column is required.
3. In the first cell under Average, type the following: =average(
4. With your mouse, click and drag from Cell B2 to Cell B9.
4b. Drop
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.6. Double-Click on the small blue square to fill the formula to the bottom of the column.
7. Now the series is filled!
8. The next step is to crate the chart. Click Insert
9. Click Chart
10. That is how you can create the chart!
11. You can use the chart editor to change colors, line thickness, and other settings.
12. You also have the option to share the chart with others. Click the 3 dots in the upper right of the chart
13. The Publish Chart option will allow you to share the chart with others via a link or embed it on a webpage.
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.
15. That’s it! You’re done!
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
2. With your mouse, click and drag in cell B1, then drop it on cell B8
2b. Drop
3. Click Data
4. Click Data validation
5. Click the dropdown list next to Criteria
6. Click List of items
7. In the adjacent box, type the following: Present, Absent, Tardy, then hit enter.
Please note: In reality, you can enter anything you want8. Click Save
9. Click the first dropdown box next to Andrew Anderson
10. Click Present
11. Click the dropdown box next to Betty Brown
12. Click Absent
13. That’s how you can make dropdown boxes in Google Sheets!
You can use them to take attendance, grade, prepare lessons, and more!21 STEPS
1. The first step is to open Google Calendar
2. Click the 3 Dots next to the name of the calendar you want to share.
3. Click Settings and sharing
4. Click Access permissions for events
5. There are several different sharing options available to you. The first will make your calendar publicly available to anyone.
6. Click the checkbox next to Make available to public
7. This notification will appear. Click OK
8. At any point, you can stop making your calendar public. Click the checkbox next to Make available to public again.
9. Another sharing option is to allow anyone in your organization to view your calendar. Click the checkbox next to Make available for NEOnet
10. Click Get shareable link
11. You can use this link to share your calendar. Click Copy link
12. You also have the option to share your calendar with specific people. Click Add people
13. After adding a person’s email address, click the Permissions dropdown menu
14. Please note, options may be limited by your Google Administrator.
Select See all event details15. Click Send. This will send your recipients an email notification about your calendar.
16. If you want to view other people’s calendars, you will need to subscribe to their calendar.
17. Click Add calendar
18. Click Subscribe to calendar
19. Enter the email address of the person whose calendar you wish to have access to.
20. Click Request access. This will send them an email notification.
21. That’s it. You’re done.
https://www.iorad.com/player/1897900/Google-Calendar—How-to-Share-Calendars?iframeHash=trysteps-1
48 STEPS
1. We can move single files into folders to begin organizing.
Right Click over the highlighted document2. Click Move to
3. Click New Folder icon
4. In the box, type Other
5. Click Check Mark
6. Click Move here
7. With your mouse, click and drag between the two indicated points.
This will highlight all of the files in-between.7b. Drop
8. With your mouse, click and drag from any of the highlighted files up to the Other folder
8b. Drop
9. Click Name to change how the page is sorted
10. Click Last modified
11. Click highlighted icon.
12. This changes it to a list view.
Click Last modified13. Click Last modified
14. Holding the Shift Key after single-clicking on a file then clicking another file will highlight everything in-between.
15. Right Click on any of the highlighted files
16. With your mouse, hover over Add to workspace
17. Click Create new workspace
18. Type Example Workspace
19. Click Create
20. Workspaces are found in the Priority section.
Click Priority21. Click Example Workspace
22. Click Add files
23. Click The Gnat & the Bull
24. Click Insert
25. Click Done
26. Click My Drive
27. Right Click on Other Folder
28. Click Add to Starred
29. Click Starred
30. You can add as many files and folders to your Starred menu as you want!
31. Right Click on Other Folder
32. With your mouse, hover Change color
33. Click orange color
34. Click the “i” information icon
35. Click Details
36. You can quickly view information about a file or folder.
37. Click Activity
38. This page quickly shows who made changes, and what changes they made.
39. Click close
40. Click Shared with me
41. With your mouse, click and drag between the two highlighted points.
41b. Drop
42. Right Click over either of the highlighted files
43. Click Add shortcut to Drive
44. Click My Drive
45. Click Other
46. Click Add shortcut
47. When adding shortcuts to Drive, those files will appear in both the original and destination folders.
48. That’s it. You’re done!
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.
2. Click Get link
3. Now we need to change the link to be accessible to anyone.
Click Restricted4. Click Anyone with the link
5. Click Copy link
6. Click Done
7. Paste the link with Ctrl + v
8. In the URL, find the word “edit” and replace it with “copy“
9. The link can now be copied and shared with others.
10. This is what people will see when they click on your link.
Click Make a Copy11. This copy is owned by the one who made the copy, not you. Any changes they make will not affect the original.
12. That’s it. You’re done!
https://www.iorad.com/player/1907349/How-to-Force-Make-a-Copy?iframeHash=trysteps-1
18 STEPS
1. The first step is to open your Google Classroom and click Classwork
2. Now click Create
3. Now click Assignment
4. Click in the Title box
5. Type Example Quiz in the Title box, then hit enter
6. Click the Google Drive attachment icon
7. From here, we will attach the Google Form Quiz we created – select the one titled Example Quiz
8. Click Insert
9. Click the button to turn on Grade Importing
10. Click Assign to make the quiz available for students to take
11. When students are all finished taking the quiz, come back to Google Classroom and click Grades
12. Click Example Quiz to view more details
13. All of the students have turned in the quiz, but we do not see their grades yet.
Click Import grades14. Click Import
15. Click the checkbox next to “Turned In” to return the grades to students
16. Click Return
17. Click Return
18. That is how you can import grades from a Google Form Quiz to Google Classroom!
16 STEPS
1. This tutorial will show you how to create a collaborative email template in Google Docs!
2. The first step is to open a Google Doc
3. Type @email
4. Click Email draft
5. This template will allow you and anyone who has edit access to this Doc to enter information that will appear in the email
6. Next to the “To” section, type principal@school.org
7. Collaborators can add as much information as they like.
8. Click the Gmail Icon
9. A new window will open with the draft email
10. Click More options
11. With your mouse, hover Templates
12. With your mouse, hover Save draft as template
13. Click Save as new template
14. Type new template in the box
15. Click Save
16. That’s it. You’re done.
https://www.iorad.com/player/1939465/Google-Docs-Email-Templates?iframeHash=trysteps-1
© 2021 NEOnet All Rights Reserved