EVOLVING EDUCATORS

​​evolve as an Educator Blog

Picture
Check out our January 2023
Professional Development Offerings

​
  • Digital Secretary Institute - Cohort II
  • Digital Paraprofessional Institute
  • Aspiring Administrators Workshop

  • Home
  • About
    • Google Training >
      • Google Training for School Secretaries
      • Google Training for Schools >
        • Level I Virtual Training
        • Level 2 Virtual Training
        • Level 1 & 2 Exam Preparation
    • Books
    • Blog
  • Digital Secretary Institute
    • Digital Secretary Institute (Cohort 1) >
      • Gmail and Calendar
      • Docs and Drive
      • Sheets
    • Digital Secretary Institute (Cohort 2)
  • Digital Paraprofessional Institute
  • #Satchat
  • Contact

1/8/2023

2 Ways That Students Can Use Google Sheets

0 Comments

Read Now
 
Picture
Google Sheets has many features that provide students with an opportunity to show what they know about the topic at hand. The first feature is the ability to create a graph that highlights important information in a visually appealing way. Have students follow the steps below to create their very own graph in Google Sheets. 
    
    Step 1: Log into your school Google account. 
    Step 2: Open a new tab in your Chrome browser. 
    Step 3: Click on the waffle on the upper right hand side of the screen. 
    Step 4: Locate and click on the green Google Sheets icon. 
    Step 5: Provide data points to students from the topic currently being covered in class. 
    Step 6: Input data onto the Google Sheet using the columns and rows.
    Step 7: Highlight the data that needs to be included on the chart.  
    Step 8: Click on the Insert tab at the top of the screen and click on Chart. 
    Step 9: Edit the chart that appears in the spreadsheet to meet assignment requirements. 
    Step 10: Submit assignment on Google Classroom or click the Share button. 

The second feature on Google Sheets that students can use to show what they know about the topic at hand is the Template Gallery. One template in particular, Assignment Tracker, can provide students with a way to display the assignments they have completed in class. This organizational method helps the student actually see what they have accomplished and learned throughout the marking period. Have students follow these steps to create their own Assignment Tracker in Google Sheets. 

    Step 1: Log into your school Google account. 
    Step 2: Open a new tab in your Chrome Browser. 
    Step 3: Click on the waffle on the upper right hand side of the screen. 
    Step 4: Locate and click on the Google Drive icon. 
    Step 5: Click on the New button on the upper left hand side of the screen.
    Step 6: Hover over the Google Sheets icon and click on From a Template. 
    Step 7: Select the Assignment Tracker template and name the file. 
    Step 8. Edit the Assignment Tracker document to fit requirements of class. 
    Step 9: Share the document with your teacher and parents throughout the marking period. 
    Step 10: Submit the document via Google classroom at the end of the marking period. 

​Google Sheets provides students with a plethora of options to show what they know about the topic at hand. Additionally, Google Sheets can help support students stay organized and focused on learning goals. No matter the subject area, Google Sheets can be consistently used in order to make the classroom environment efficient and effective. 

Share

0 Comments

12/23/2022

Day 12 of the 12 Days of EdTech Tips - Gmail Confidential Mode

0 Comments

Read Now
 
TODAY IS THE LAST DAY OF THE 12 DAYS OF EDTECH TIPS FOR THE HOLIDAYS
Happy Holidays from the Evolving Educators Team!

Day 12 of 12 Days of
#EdTech Tips for the Holidays
Today: Gmail Confidential Mode

Share

0 Comments

12/22/2022

Day 11 of the 12 Days of EdTech Tips - Google Sheets Conditional Formatting

0 Comments

Read Now
 
Day 11 of 12 Days of #EdTech Tips for the Holidays
Today: Google Sheets Conditional Formatting

Share

0 Comments

12/21/2022

Day 10 of the 12 Days of EdTech Tips - Google Forms Response Settings

0 Comments

Read Now
 
Day 10 of the 12 Days of #EdTech Tips for the Holidays
Today: Google Forms Response Settings

Share

0 Comments

12/20/2022

Day 9 of the 12 Days of EdTech Tips - Google Docs Automatic Substitutions

0 Comments

Read Now
 
Day 9 of the 12 Days of #EdTech Tips for the Holidays
Today: Google Docs Automatic Substitutions

Share

0 Comments

12/19/2022

Day 8 of the 12 Days of EdTech Tips - Google Docs Template

0 Comments

Read Now
 
Day 8 of the 12 Days of #EdTech Tips for the Holidays
Today: Google Docs Template

Share

0 Comments

12/18/2022

Day 7 of the 12 Days of EdTech Tips - Google Sheets Calendar Template

0 Comments

Read Now
 
Day 7 of the 12 Days of #EdTech Tips for the Holidays
Today: Google Sheets Calendar Template

Share

0 Comments

12/17/2022

Day 6 of the 12 Days of EdTech Tips - Gmail Choose Layout

0 Comments

Read Now
 
Day 6 of the 12 Days of #EdTech Tips for the Holidays
Today: Gmail Choose Layout

Check out the video for details. 

Share

0 Comments

12/16/2022

Day 5 of the 12 Days of EdTech Tips: Add Task to Google Calendar

0 Comments

Read Now
 
Day 5 of the 12 Days of #EdTech Tips for the Holidays
Today: Add Task to Google Calendar

Adding a task to Google Calendar is a simple process. First, open Google Calendar in your web browser. Then, click the "Create" button in the top left corner of the calendar. In the pop-up window, enter a title for your task, as well as any additional details or notes you want to include. You can then choose a date and time for the task, and specify whether you want it to be a one-time event or a recurring event. When you are finished, click the "Save" button to add the task to your calendar. Watch the video for more details. 

Feel free to leave a comment on this tip. 


Share

0 Comments

12/15/2022

Day 4 of the 12 Days of EdTech Tips - Google Calendar Out of Office

0 Comments

Read Now
 
Day 4 of the 12 Days of #EdTech Tips for the Holidays
Today: Google Calendar Out of Office
​
Google Calendar is a calendar application that is part of the Google suite of online productivity tools. One of its features is the ability to set an "out of office" status, which lets other people know that you are not available to attend meetings or respond to emails. When you set an out of office status, you can specify a time period during which you will be unavailable, as well as a message to be sent to anyone who tries to schedule a meeting with you during that time. This can be useful if you are going on vacation, working from home, or otherwise unable to respond to work-related communications.

Feel free to leave us a comment about this tip. 

Share

0 Comments

12/14/2022

Day 3 of the 12 Days of EdTech Tips - Change Drive Folder Color

0 Comments

Read Now
 
Day 3 of the 12 Days of #EdTech Tips for the Holidays
Today: Change Drive Folder Color


Share

0 Comments

12/13/2022

Day 2 of 12 Days of EdTech Tips - Reshape Images in Slides

0 Comments

Read Now
 
Day 2 of 12 Days of #EdTech Tips for the Holidays
Today's focus: Reshape Images in Google Slides. Please feel free to leave comment.


Share

0 Comments

12/12/2022

Day 1 of the 12 Days of EdTech Tips - Google Smart Chips

0 Comments

Read Now
 
Join us from Monday, December 12th through Friday, December 23rd for a Free Edtech Tip each day as we celebrate the holiday season with you. Today's focus: Google Smart Chips.

Share

0 Comments

11/27/2022

Leverage Google Earth to Learn About the World Cup Teams

0 Comments

Read Now
 
PicturePhoto courtesy of FIFA World Cup
The World Cup is a popular soccer tournament that includes teams from around the world. Google Earth is a platform that allows users to quickly locate and learn about a place with a few clicks of the mouse or taps of the screen. Students can learn about the countries participating in the World Cup by leveraging the power of Google Earth. Teachers can set up the learning experience by instructing students to first visit the World Cup website and generate a list of teams. Then, the students should be instructed to head over to Google Earth and set up a new project following the steps listed below. 

Step 1 - Make sure your students are signed into a district issued Google account. 
Step 2 - Visit ​https://earth.google.com/web/​.
Step 3 - Click on Projects located on the left hand side of screen. 
Step 4 - Click on the Create button and then the Create in Google Drive option. 
Step 5 - Name your project. 
Step 6 - Click on the New Feature button and then Search to Add Place. 
Step 7 - Type in the name of a participating country, for example Costa Rica. 
Step 8 - Click on the Add to Project located on the right hand side of page under country information. 
Step 9 - Repeat Step 8 until all participating countries have been added. Students can share the project by clicking on the share button to grab the link. 
Step 10 - Make sure to click on the More Information link located under the country preview. 
Step 11 - Once all of the countries have been added to the Google Earth project, post an assignment for students in Google Classroom that will task them with filling out a table on Google Docs showing information about the country. 
Step 12 - Once the table is filled out, randomly assign students a country to present about using one Google Slide. Once the Google Slide is completed, students can make a one minute presentation to their classmates. 
Step 13 - The slide, along with the table and Google Earth project should all be submitted on Google Classroom for a grade. 

Timeline:
Day 1 - Overview of instructions and begin to add countries to the Google Earth Project. 
Day 2 - Finish adding countries to the Google Earth Project. Then, begin to work on Google Doc table. 
Day 3 - Finish Google Doc table and begin working on Google Slide presentation. 
Day 4 - Finish Google Presentation and then begin presenting to class. 
Day 5 - Finish class presentations. 


Register Today!
The first is Cohort 1 of the Digital Paraprofessional Institute. This institute is designed to provide paraprofessionals with the knowledge and usability of the Google Suite of Apps to improve their skills and to enhance their ability to assist the students they work with each day. The Institute is separated into four (4) modules that allow paraprofessionals to go at their own pace. Within each module are videos designed to enhance their knowledge and skills, a newsletter, and. opportunities for individualized assistance. The DPI starts on January 2, 2023.

The second is Cohort 2 of the Digital Secretary Institute. Due to popular demand we have opened a second cohort after more than 60 secretaries and administrative assistants from around the US joined our first cohort. The DSI is a ten (10) month program focused on the Google Suite of Apps. Participants set personal goals and each month there are videos and a newsletter to support their learning. DSI also includes opportunities for individualized assistance and two live events for cohort participants. The DSI - Cohort 2 starts on January 16, 2023.

The third event is our Aspiring Administrator Workshop. This 90 minute workshop is designed to prepare participants for their first or next interview for an administrative position in education. Areas covered in this workshop include, resume development, cover letter writing, digital portfolio content creation, live interview preparation, and virtual interview preparation. This live virtual event is on January 23, 2023. 

Share

0 Comments

11/19/2022

5 Ways to Tell Your Classroom Story

0 Comments

Read Now
 
Picture
1. Share your lesson or unit plans with colleagues on a consistent basis. 
2. Conduct informal conversations about what is happening in your classroom. 
3. Leverage social media to post pictures and information about learning experiences taking place in your classroom. 
4. Present about a best practice or tech tool at an upcoming faculty meeting or staff inservice day. 
​5. Curate a blog or newsletter to keep parents and guardians in the loop about classroom happenings. 

Register Today! 
Digital Paraprofessional Institute 

​A ​4 module professional development experience designed for school paraprofessionals providing them the ability to learn at their own pace. Training will center on key apps in the Google Suite that provide paraprofessionals with the knowledge to use the apps and the skills to help the students they assist.
Click here to learn more. 

Share

0 Comments
<<Previous
Details

    Author

    The Evolving Educators Team

    Archives

    January 2023
    December 2022
    November 2022
    October 2022
    August 2022

    Categories

    All
    Facebook
    Google
    Google Classroom
    Google Earth
    Instagram
    Learning
    Social Media
    Social Studies
    Teaching
    Technology
    Twitter
    World Cup

    RSS Feed

Picture
8 Drew Court  |   North Caldwell, NJ 07006
​Call Us: 888-304-9211 or 973-200-8323
© 2021 Evolving Educators, LLC. All Rights Reserved.
  • Home
  • About
    • Google Training >
      • Google Training for School Secretaries
      • Google Training for Schools >
        • Level I Virtual Training
        • Level 2 Virtual Training
        • Level 1 & 2 Exam Preparation
    • Books
    • Blog
  • Digital Secretary Institute
    • Digital Secretary Institute (Cohort 1) >
      • Gmail and Calendar
      • Docs and Drive
      • Sheets
    • Digital Secretary Institute (Cohort 2)
  • Digital Paraprofessional Institute
  • #Satchat
  • Contact