Go-To Tools for Presentations: When to Blog and When To PowerPoint

The goal of a presentation is to effectively convey information that allows the audience to remember what has been said. That being said, there are several options as to how to give a presentation, specifically for a final project. For students, presentations can be given as individuals or groups, or for educators in seminars. The best tool for the job depends on whether the presentation will be visual or verbal. 

When to Blog 

Blogs are definitely the ideal verbal tool for presentations. They are becoming increasingly popular for e-portfolios, offering students the opportunity to review, communicate, assess, archive and display their work - including blogging for projects and presentations. Google has a great Keyword Planner tool that allows the writer to enter seed keywords and receive a list of suggested search terms. Microsoft’s Windows Open Live Writer is another solid option.

There are several pros to using blogs in presentations:

• Blog writing is informal, unlike academic writing. This style takes the pressure off students and also allows them to speak their audiences’ language. Blog, or web log, style is typically relaxed, which makes it comfortable and easy for students.

• Blogs allow for comments. Students can get feedback from peers, educators and even parents about their blog.

• Blogs are published. The students’ work is online and can help educate others about their opinion.

• Blogs can easily be linked to social media. Blogs are almost made for social media. A student’s project can easily be shared or linked to the school’s social media account.

There are also some cons:

• A blog doesn’t allow the student to practice his or her speaking skills. In today’s world - where it is a struggle to compete with online and handheld distractions for students’ attention - there aren’t as many real-world opportunities for students to practice their speaking skills.

• Blogs aren’t conducive to group projects. It can be hard to track who-did-what if only one blog is uploaded. Presentations give an entire group the opportunity to participate, even those that aren’t the strongest writers.

When to PowerPoint

When the presentation goal is to be visual, the presentation needs to be done in PowerPoint. Microsoft’s presentation software allows users to create fluid, cinematic motion in one click. Slides can be duplicated, morphed together, moved, etc. 

There are definite pros to PowerPoint: 

• PowerPoint is the standard when it comes to professional settings. It’s been offered in Microsoft Office versions for more than a decade. It’s highly-recognizable.

• PowerPoint can improve presentations. The software’s ability to use animations and images is a definite plus. Even basic shapes can enhance data and help get the point across.

• PowerPoint slides can be easily distributed. The slides can be printed or emailed. They can be uploaded to the cloud or saved on a flash drive.

Yet, there are also some cons to PowerPoint:

• PowerPoint requires some time to learn. There are a lot of options, which can seem overwhelming to users. Also, novices could put too much information on slides, ruining the entire purpose of using PowerPoint – which should be to enhance a presentation. No one wants to sit and read slide-after-slide. 

• PowerPoint could be riddled with technical difficulties. The computer could stop working, power might be lost to the outlet or the overhead display doesn’t work right. These might seem like conditions that can be avoided, but you never know what can happen in a space that is unfamiliar.

Follow us @AreyJones for more great tech tips.

Seek Mentors Out On Twitter

Twitter is more than tidbits of daily news and tweets about trending television. It is a great source to find like-minded people in your field and even a mentor.

Twitter influencers, experts, thought leaders and kindred spirits can help improve your teaching by supplying information and ideas that you can put into practical applications. Once you find someone to follow, you can build on that virtual relationship and use them as a mentor, either virtually or face-to-face.

Figure out who you’d like to follow.

The first step is to actually figure out who’d you like to follow. Sounds easy. But, the Internet is a BIG place and Twitter is no exception.

Use Twitter’s search to seek out influencers and people you want to follow. Type your keywords in the top search. You can also use Twitter’s filters and Advanced Search to search locally, which gives you a better opportunity for an in-person meeting.

You can try these five hashtags to get you started.

1. #GoogleET, #GoogleCE, #GoogleEI

2. #MIEExpert

3. #SkypeMT or #MinecraftMentor

4. #GoogleTeacherTribe

5. #STEAM

A search for these hashtags brings up the top results, but also people tied to them. This is a really easy way to start following an influencer and possible mentor. 

If you’re still having an issue finding who to follow, search through your other social media platforms. How many people do you know that use just ONE form of social media? You can increase your chances of connecting with a mentor if you can overlap social networks. 

Prepare to take the next step.

Once you find someone to follow that is mentor-material, do some research and learn as much as you can about them. Start a virtual conversation or check out any podcasts or blogs they have to find common areas of interest. Do they seem comfortable sharing their knowledge? If so, continue on.

The approach.

Build a rapport with your potential mentor. Promote their tweets, ask for their advice, comment on their blogs and so on. Treat the virtual world as you would the real one and get to know them slowly. The key is to build a dialog and show you have something of value to contribute. 

When you’re ready, email the influencer and simply ask if they would be willing to act as a mentor to you. Email works great because it is - literally - the electronic equivalent of a letter. It is more formal than a DM but not so formal as a mailed piece of paper.

Once you create and facilitate that online relationship, you can decide both decide if, when and how you want to meet in person. Even if you never get to that stage, there’s so much powerful information out there that just following posted advice provides a great opportunity for personal and professional growth. Reach out to Arey Jones for more advice on your professional development.

Top Chrome Extensions For The Google Classroom

Google Classroom has been instrumental in changing the way education looks today. It streamlines assignments, boosts collaboration and fosters seamless communication to help make teaching more productive. There’s also the advantage of being able to integrate hundreds of Chromebook apps and extensions that save teachers and students time and make it seamless to share information. Extensions enhance the browsing experience by tailoring Chrome’s functionality towards individual needs and preferences. 

Here are some of our favorites.

Grammarly

Grammarly is an online editor that gives all of your text the once-over before you send it to colleagues, parents or students. It’s a free extension that revises the text you type in Chrome, Facebook, Gmail, Twitter, Linkedin and anywhere else on the web. It suggests corrections based on both spelling and grammar, and it explains alternative options because we call all still learn.

Screencastify

Screencastify is a great tool to use when you need to create a quick demonstration or instructional video. It is a screen recorder that allows you to capture, edit and share videos in seconds. It can tell a story in just a couple of clicks.

CheckMark by EdTechTeam

This extension is designed to give teachers the ability to provide students with feedback quickly and easily. When a teacher highlights text in Google Docs, an overlay pops up with quick shortcuts to frequently-added comments such as “Spelling” or “Check Punctuation,” or “Evidence needed.” CheckMark has both comments related to grammar as well as concepts, citations and more.

Shareaholic

Shareaholic gives you the ability to share and bookmark great content, without stopping what you’re doing on Chrome. It works with Facebook, Twitter, Pinterest and more than 200 other services. It makes all your shared links searchable in one place and won’t slow down your Google Chrome.

Alice Keeler – Teacher Tech

This extension gives you quick access to Alice Keeler’s Teacher Tech blog – which covers all things classroom and Google Classroom. A quick click on the extension pulls up a list of her most recent posts. Topics include: 50 Things You Can Do With Google Classroom, A Tour Of Google Classroom and Google Slides, Create a Drop Shadow on Text.

LastPass: Free Password Manager

This handy extension saves all your usernames and passwords in one spot. It gives you secure access and will autologin to your websites and sync passwords. Plus, anything you save on one device is instantly available on all your other devices. Slick.

We'd love to know your favorites on Chromebooks, too.

30 Educational Technology Tips in 30 Days

We all want to be more productive, rested, calm, collected, alert, and generally amazing. Here are 30 tech tips that can help you leave the month better than you found it.

1. Learn how to make SMART goals.

2. Drink your coffee from a spillproof mug. Trust us.

3. Work in 90-minute intervals.

4. Show your Chromebook (or laptop) some love.

5. Schedule breaks into your schedule to do something fun on purpose.

6. Add a calming picture to your desktop screen.

7. Then hang a pretty picture in your office, about 20 feet away. Looking up at every 20 minutes for twenty seconds can prevent eye fatigue.

8. Color-code your Google Calendar.

9. Silence notifications to minimize distractions.

10. Use Microsoft Word’s Gridline tool to keep your document in line.

11. Dedicate a set time each day to read and respond to emails, and stick to it.

12. Drive the above message home by adding a statement to your email signature like, “I check emails every morning and will respond by 10am.”

13. Follow these hashtags on social media.

14. Set an out-of-office message for after-hour emails that reminds senders you don’t take work home with you. Remember. Those who need to contact you for true emergencies will likely have your cell phone.

15. Create embedded links in a Google Doc by clicking CTRL+K and searching for the content within the pop-up menu. No more extra tabs!

16. Use Microsoft OneNote in your next meeting for amazing notetaking.

17. Organize your desktop files into folders.

18. Empty your trash.

19. Commit these quick keys to memory.

20. Schedule coffee with a friend via a calendar appointment, so you both remember.

21. Treat yourself to a new laptop or phone case. It will feel like a brand new machine at a fraction of the cost.

22. Organize your GDrive or Cloud files.

23. Follow Arey Jones on Facebook.

24. Add these tips to your OneNote vocabulary.

25. Put a seven-minute workout app on your phone and challenge yourself to do at least one circuit daily (here’s one to try)

26. Listen to an audiobook on your commute.

27. Sort and empty your Download folder.

28. Catch up on what’s new in Microsoft EDU.

29. Watch a TED talk.

30. Go absolutely tech-free for at least 30 minutes a day (when you are awake).

These are just a few ways to boost your productivity and get more out of life in general with (and without) technology. How many did you do? We'd love to know.

Tech Cleaning Tips From Your Grandmother

My grandmother fit every grandmother mold possible. Impeccable hair. Crisp aprons. Mouthwatering homemade bread on the counter. She ran a tight ship with even tighter hair. For Grandma, spring cleaning was as much a celebration as it was a chore (but then she always smiled most when she was working).

I have more than a little of her blood coursing though my veins, and now that the weather is shaking off winter’s chill, I have the urge to clean as she used to do. And I can apply her methods to my phones, laptop, and tablet just effectively as I do everything else in my home.

Get sorted. While my grandmother had an eye and a hand for organization, my grandfather had a different method. Every weekend, she would group the mail, his receipts, and his tools and put everything back where they should have gone in the first place. Take the time to organize your documents and files in a system that makes the most sense to you, and delete files that are no longer relevant. For every minute spent here, you’ll save twice. 

Put the right things into the right storage. It’s okay to hold onto things (I myself am pretty sentimental). The trick is figuring out where to put them so that they can be reached where you need them and out of the way when you don’t. Consider organizing your files in bulk by year, and clearly label each file and folder with its exact contents. This saves you stress and energy, whether you are looking for Aunt Lucy’s china or last year’s lesson on volcanoes. And no, “Science stuff” doesn’t count.

Clear your desktop. If Grandma could see my laptop screen, she would sigh, “Clutter, clutter, clutter, dear. How can you see what you mean?” It was an odd expression, but I understood it. If you save everything to the desktop, you’ll never find what you really need. This works just as well for your desk as well as your desktop. Save it only for items you need to find quickly or things you use every single day. Rely on your filing system for the others. Delete the rest.

Clean your Windows. Grandma loved a clean window (even if the birds didn’t). If you are running the digital version on your laptop, Windows 10 has a handy Disk Cleanup tool to clean up temporary and unnecessary system files that could be obstructing your computer performance. Use this handy guide for additional information.

Empty the trash. Now that you’ve gotten everything where you want it, it’s time to remove what you don’t need once and for all. My grandma always emptied the trash as the last part of her cleaning routine, grabbing a bag and hitting every bathroom and bin on her way out the door.

Grandma made the most of everything (I can still taste her creative leftovers), and I hope these above tips help you make the most of your time and managing your technology this spring. If you found any of these valuable, we’d love your feedback--follow us on Facebook for more!

7 Microsoft PowerPoint Tricks For Every Day This Week

As a staple of the Microsoft Office suite, PowerPoint often gets a bad rap, mostly because it’s associated with speeches, presentations, and seminars--and they aren’t always the most exciting events (to put it mildly). Since it’s estimated that PowerPoint is a key software on over one billion computers worldwide, it’s safe to say slide-based presentations aren’t going anywhere.

The question, however, isn’t where PowerPoint can go; it’s what PowerPoint can do to make those presentations even better.

Here are our favorite Microsoft PowerPoint tips to make sure your presentation goes smoothly.

1. Launch your PowerPoint presentation with one click. To start your presentation off quickly and cleanly, all you need to do is save the file with a .PPS or .PPSX file extension and save it to your desktop. Instead of nervously launching from editing mode or from your email (for all the world to see), all you’ll do is double-click and get on with the show. (Keep your desktop free of embarrassing distractions for full professional effect).

2. State your case in black and white. PowerPoint presentations are meant to be an aid to your presentation--not necessarily be a word-for-word account of it. To keep them from being a distraction, press “B” or “W” on your keyboard to make the screen black or white. This will help your audience focus on you and what you are saying.

3. Doing a demo? Get a screenshot. If you need to replicate the feel of your computer screen while giving a presentation, use the PowerPoint Screenshot tool on the Insert tab. It will give you a thumbnail of each window you currently have open. Simply select, resize, and click--and it will automatically be inserted on your current slide.

4. Animate charts. Turn charts and graphs from boring to mindblowing with animation. Once you’ve set up the chart or graph as you need to, head to the Animations tab to turn on the Animations Pane. Pick an animated effect, add sound, adjust timing and, most importantly, change the “Group Chart” options from “As One Object” to “By Category.”

5. Employ Kiosk mode. For presentations that don’t require an active speaker, you can set the presentation to play in Kiosk mode, which will play it on a loop, no human required. You can also output the entire slide deck to a video format.

6. Duplicate without the CTRL C + V. Instead of quick keys to copy and paste reused elements, go one step lazier--hold the CTRL key while you click and drag on the element you want to multiply. Great for elements as well as entire slides.

7. Be zen with Venn. Venn diagrams are a useful visual aid, but they can be a pain to make--unless you know how to Merge Shapes. Simply layer your pre-created shapes as you want, head to the Drawing Tools, and select “Merge Shapes” from the menu. This feature also makes light work of inserting pictures and text into shapes and vice versa. 

There are so many ways to do more in Microsoft PowerPoint in less time. We can help you figure them out.

Google Gold: 7 Nuggets You Didn’t Know Existed in the Google Suite

G Suite--what most of us first knew as Google Apps for Work--is one of the most powerful cloud-based collaborative and productive tools on the market. It’s no secret why it has become the fastest go-to for schools, business, and personal use. The trick is how to make the most of it.

Here we’ve broken down our favorite hidden gem for each product in GSuite (so far). We’re finding more ways to use these tools all the time, so check back often for more tips!

Gmail Tip: Get the Group Together

Use Contact Groups to get your team, your classroom, and your students’ parents all on the same page. By creating separate groups for each, you can email the group without fear of forgetting anyone important, and you can easily manage additions and edits. To avoid the awkward accidental Reply-All moments, put your own address in the “To:” field and use “BCC:” for your group.

Google Forms Tip: Form an Opinion (Poll)

This underutilized app can help you take a quick poll, give a test, get to know your students, and reach out to parents right where it’s easy for them--online. The Google Form generator is easy to use and intuitive, you can choose from text answers to multiple choice, check boxes, lists, sales and schedule options.

Google Scholar: Use Your Resources

Google Scholar performs your query against an index of scholarly publications. It works the same as a Google Search, only it filters everything out but academic papers across an array of disciplines and formats.

Google Drawings: Chart Your Heart Out

Whether you use it as a literal drawing board for collaboration or as a place to create customized charts and graphs, Google Drawings can bring your documents, presentations, and imaginations to light. As part of the Google Docs package, it’s easy to use, integrate, and share.

Google Docs: Improve Your Image.

Within Google Docs or Google Slides, you can insert a variety of royalty-free images to give your paper or presentation the wow-factor you want.

Google Drive: Slash Your Search Time

If searching for your files is taking longer than just creating the doc itself, keep reading. You can perform a filtered search in Google Drive by simply clicking that tiny black triangle to the right of the field. You can filter your search by date, words, and how it was shared.

Google Everything: Find Your Shortkeys

Use the Ctrl+/ combo to quickly find available keyboard shortcuts--and then commit them to memory, so you save even more time.

What “Google Gold” tip has saved you more than once so far? We're always looking to add more to our resources here at Arey Jones.

Greener Pastures: The Dawn of the Paperless Classroom

I picked up my son’s backpack the other day, and the weight of it astounded me.

It was so...light. Empty even.

I remembered my school days. I didn’t just wear a backpack; I lugged it. I measured my progress in school by the physical weight of my assignments. I remembered how frustrated my mother would get when I home--yet again--with a broken arm strap or a ripped seam because I had demanded too much of it. After all, aren’t backpacks crammed with notebooks, worksheets, books, and scratch paper a normal part of education?

Not if technology has anything to do with it.

According to the World Wide Fund for Nature, technology--when appropriately used--can reduce paper usage by up to 30%. Take Bank of America for example (they did). When the largest bank in the country turned to online reports, forms, email, double-sided copying, and lighter-weight papers, it reduced is paper consumption by over one billion sheets of paper. That’s a 32% reduction--on internal operations alone. 

And if Bank of America can do it, so can your school district.

There are several ways to save paper and money through the use of technology. 

• Use emailed school and class newsletters instead of sending home printed ones.

• Direct parents toward a consistent website or web page for frequently asked questions, the latest news, or the most recent homework assignments.

• Store documents in electronic archives for instant retrieval (rather than relying on file cabinets).

• Encourage the use of on-screen editing features, instead of printing and editing by hand.

• Share events on a shared calendar with reminders.

• Use Google Forms instead of worksheets, quizzes, and paper tests.

• Use Google Drawings for scratch paper.

• Use OneNote for notetaking.

• Embrace the cloud system for swift data recovery and increased collaboration and distribution of resources.

But it’s more than just paper schools are saving. Printing supplies--everything from copier purchases to toner to maintenance contracts--are expensive line items. With reduced paper comes reduced printing costs, and printing supplies--everything from copier purchases to toner to maintenance contracts--are expensive line items. Moving to educational technology also saves more precious resources: family time, patience, creativity, sanity, and wear and tear on a backpack you can keep for years.

How does your school save natural resources while unleashing productivity, innovation, and collaboration? We can always help you find more ways.

6 Tools in Google Docs To Help Write (and Grade) Term Papers

We’re in the throws of March Madness, and productivity across American businesses--and classrooms--is taking a nosedive. (Research shows that employers lose an estimated $4 billion in revenue due to the paid time lost in managing brackets, discussing team matchups, and watching games.)

And your students aren’t immune.

While college basketball teams are gearing up for the culmination of the season, high-school students across the country are prepping for midterms, term papers, and research projects. To stay ahead of the game, they have to stay on the ball--and Google Docs is a fan favorite.

1. Choose your Add-ons wisely.
   There are several Google Doc add-ons that can help you write--and grade--an effective paper. Word clouds, editing tools, a worthy thesaurus--all of these can improve your language and flow while demonstrating your knowledge of the material. Before you start adding a bunch, however, start with Extensity, an add-on that makes sure extensions and additional add-ons play well with each other.
   
   Try: Pro Writing Aid, Kaizena, and Easy Bib

2. Get a second opinion.
   Having another set of eyes on your paper is always a good thing. An unbiased proofreader will catch unclear phrasing, grammar, and flow problems, and they may be able to offer insight on specific context you could be missing. Use the Chats and Comments functions within Google Docs to make sure you and your friendly editor are both on the same page.

3. Find supporting research.
   Just like you can use the CTRL + K function to create link text, you can also use it to find likely resources--and sources— for your material. Simply type out the topics you are researching, highlight, and hit the shortkeys, and Google will give you some suggestions. Make sure to cite!

4. Use your Tools to Explore
   Another excellent resource in the Google Doc toolbox is the Explore function. Hidden in the Tools menu, Explore opens a side tab in your doc and gives you additional ideas and sources that support your paper based on the phrases, topics, and ideas you are talking about. It pulls from other Google services, like Google Scholar, Google Images, Google Quotes, and Google Dictionary.

5. Harness collaboration.
   With Google Docs, you can pass around thoughts, edits, suggestions, and formatting questions with relative ease. You can also sneak back into past revisions if a tossed idea ends up being relevant again. These commenting tools are also crucial for teachers who want to encourage deeper research or call out worthy sentences.
   
   Tip: Make sure you understand the difference between the Editing and Suggesting modes in active collaborating. Determine who has the final say before ideas start to swarm.

6. Minimize distractions.
   While not a specific function of Google Docs, it’s all-in-house ability to focus a student’s efforts can help funnel creativity in a purposeful, productive way. There’s no need to have multiple tabs open (including ones with live updates of the games); there’s just you and the page, and all the time and tools in the world to fill it.

What add-ons are you using in your Drive? We would love to know.

How To Put Play Tech to Work

As an educational technology company, we love to talk about how technology helps kids learn more efficiently, engage in heightened collaboration, and access real-time data and resources that would otherwise be unavailable in traditional classrooms. Technology can and often does make us better at almost everything.

And it can make us really good at being distracted. 

One could argue that the minds of students have always been easily lured away from classroom activity. The only difference now is that instead of staring out of windows, they are staring into Microsoft’s equivalent; instead of daydreaming, they are building virtual realities in Minecraft.

As adults can attest, switching from “play mode” to “work mode” isn’t easy, especially when using the same device for both. Children have a particularly hard time making this transition; not only are they more easily influenced by technology, but they also don’t get as many chances to learn and practice their focusing skills--and the distractions are only a click away.

And I don’t think we’re alone when we say us adults could use a refresher course, too. Here are a few tips to help you and the students in your life focus on what’s important and still make time for play, be it in their Minecraft world or on social media.

Give yourself a clear lead.
You may never be able to remove every distraction from your classroom, office, or home, but you can learn to clear and calm your mind. If it helps (and it likely will), remove visible and audible distractions from your desktop, log out of your email and social media, silence notifications, and put your phone in a drawer. If all else fails, fight tech with tech. These distraction-diverter apps can help.

Classroom focus: Guide the kids through a quick mindfulness exercise that includes some deep belly breathing before starting a new task.

Intentionally place your focus on the task at hand.

It’s been proven that multitasking physically shrinks your brain, so stop doing it. Work on your task or watch television or text your best friend, don’t try to do all at the same time. Your attention will suffer on all, and you’ll only accomplish a fraction of what you want and need to get done.

Classroom focus: Clearly state the one task you want your students to accomplish and what you expect to be completed at the end of the alloted time. Have them write it down or repeat it (out loud or to themselves) to make sure it sticks.

Take short breaks.

“Downtime is to the brain what sleep is to the body,” said Dr. Rich of Harvard Medical School in a New York Times article. “But kids are in a constant mode of stimulation.” 

There’s a reason why productivity systems like Pomodoro are popular--because they work in realistic ways. The Pomodoro Technique, which is a time management method that interlaces timed bursts of productivity with short breaks, helps keep people focused because it keeps work and play in perspective, all while allowing access to both. Make sure some tasks or breaks are of the unplugged variety to give the brain time to process and adapt to something new.

Classroom focus: Incorporate tech-free breaks throughout your day and encourage students to take breaks from a task on a regular basis to do something physical or an activity that allows their brain to rest.

What else are you doing in your classrooms to maximize their focus and learning potential? If you ever need ideas, we've got a few.

6 Markers of Memorable Mentors

We’ve all had at least one teacher or adult make a notable impression upon our lives. They singled us out, pushed us out of our comfort zone, guided us in our chosen craft, or put us on the road to our destined career--or all of the above.

Being someone’s mentor isn’t easy, however. It takes time, dedication, patience, self-control, and generosity--all the qualities that make a great educator (and a pretty decent human being). Here are ways to develop those traits and use them to benefit your mentee.

Make sure you’re ready.

Being a mentor is an important job--and it’s one you must do on top of the other important jobs that fill your life. Make sure you have the time, emotional intelligence, mental bandwidth, and organization skills to properly nurture a mentee, and you must be willing to work with students and young professionals who may have different backgrounds, education, opinions, and strengths. Remember, this is mentoring, not cloning. There’s a good chance you’ll both come away learning something valuable.

Light the fire with a good match.

One of the reasons your mentee approached you (or the other way around) is likely because you both share an enthusiasm for your job or your field of study. Embrace this and use it to shine a light on your mentee’s potential strengths, opportunities, and challenges. While this enthusiasm will fuel your initial arrangement, pay close attention to how well the two of your work together. Chances are the arrangement will either add to your own fires, or it will sap your energy and burn you both out. Be aware of this chemistry early so you can either mix it up or dissolve it before any damage is done.

Remember where you started.

It can be easy for those of us established in our respective fields to forget what it was like at the beginning of our studies and careers. Your mentee may enter into the relationship with idealism and unrealistic expectations; your job is to harness that passion and direct it toward what’s possible. Help them focus their efforts, find the tools, and develop the necessary skills. Meet them where they are, so they can determine for themselves the best way to go.

Be generous with your knowledge.

Great mentors are teachers, and great teachers are always learning. Take the time to clearly share what you know about your field, the industry, or the task at hand, and don’t let your mentee be the only one asking the questions. Make sure you both stay in tune with the process by asking how they are doing, what they are getting from the experience, and how you can be of greater assistance.

Stay available and accountable.

Establish a regular schedule for meetings so that you both can plan your time accordingly and hold each other accountable. Set the tone for these sessions, and have specific objectives. These expectations also serve as boundaries so that you can both tend to the other important aspects of your lives.

Remain objective and fair.

Perhaps one of the hardest parts about being a mentor is attempting to be an active observer. Mentorship is not friendship (think more LinkedIn and less Facebook); you are their advocate, but you do not owe them any favors, nor do they owe you any allegiance. For a mentorship to work, the mentor must feel comfortable conveying honest assessments and constructive feedback, and the mentee must feel comfortable approaching you for advice and guidance, even if one of their challenges is working with you or your field. Your role is to guide. Their role is to learn. There should be no hidden agenda or ulterior motives.

Mentorships can have a profound effect on education, careers, and personal lives. If you have a moment, we’d love to hear your stories about what being a mentor (or being mentored) meant to you. 

16 Hashtags Worth Following (and Tagging!)

We do a lot of Twitter outreach at Arey Jones because we love to be in on the educational technology conversation, and there is always something to new going on in our industry. Whether you want to contribute to the discussion or learn something new every day, these hashtags will put you--and your followers--in the know.

By Platform

• #OneNoteEDU

• #MinecraftEDU

• #Skype2Learn

By Software

• #GoogleSheets

• #GoogleSlides

• #GSuiteEDU

By Company

• #MicrosoftEDU

• #GoogleEDU

• #AcerEDU

By Broad Reach

• #edtech

• #education

• #digcit 

By Teams

• #GTT

• #MIEE

• #GoogleEI

• #edtechteam

Obviously, this isn’t an extensive list, but it is a great start to learning just how connected educational technology is to how we work, learn, and share advancements. The next time you share a cool teaching-with-technology moment, add these hashtags to your post. You could inspire others with your ideas, and you also may learn a thing or two in the process.

Ready to learn more? Follow us @AreyJones, or feel free to contact us traditionally.

Show Your Chromebook Some Love

Your Chromebook was built to last, and so is your friendship with it, especially if you take this tried-and-true advice from Arey Jones, your technology relationship expert.

Give your Chromebook some space.

While Chromebooks won’t get overheated like traditional laptops, it’s a good idea to avoid blocking airflow around the device while it’s on. Also, don’t get overly touchy; Chromebooks’ screens don’t work well under pressure, so keep your hands off.

Also, since Chromebooks are pretty literal, it’s a good idea to give your Chromebook some more space by cleaning up and organizing your files.

Keep it clean.

Friends don’t play dirty, and your Chromebook won’t either. The keys to every great relationship include clear communication, including a clean screen and freely moving keys. If a lightly dampened cloth doesn’t help you two see eye to eye, it may be time to take it in for professional help.

Handle with care.

Even the toughest Chromebooks still have delicate centers. You won’t hurt its feelings, but its hard drive may put you two on a permanent break. This goes for power plays, too. Chromebooks are only as good as their power cords and ports are, so protect them at all times.

Don’t leave your Chromebook out in the cold.

And don’t let it take the heat either. Chromebooks shouldn’t be exposed to temps under 32 degrees or over 100 degrees, which means they should never be left in your car.

It’s okay to do your own things once in a while.

Every once in awhile, your Chromebook may need to take a moment to process a few things. This doesn’t mean it has a virus (although you may want to check if it’s misbehaving by extension), but it could mean it needs a Powerwash.

You, on the other hand, shouldn’t feel guilty about not taking your Chromebook out to eat or letting it try your coffee or soda. It won’t take it personally; it pretty much grabs bytes without you all the time.

Create a secret language.

The more time you and your Chromebook spend together, the more efficient you can be at communicating. Start by learning our favorite Chromebook quick keys or press Ctrl + Alt + ? to see a pop-up map with all the available keyboard shortcuts.

Want more ways to create a lasting relationship with your Chromebook? Follow us on Facebook, keep reading our blog, and never stop learning.

18 Excel Formulas and Functions for 2018

You already geek out over Excel’s amazing functionality and its features in Windows. Maybe you’ve already used it to create a calendar template. Maybe you color code your personal budget targets. Maybe you already use it to track student progress, grades, test scores, attendance, and days until your next school holiday. We’re not here to judge. We’re here to help you make the most of what this powerful spreadsheet application has to offer.

Basic Conditional Formatting

When you’re dealing with a mountain of data, conditional formatting can help you find specific information quickly and visibly by color-coding cells that match specific criteria. For instance, you can highlight any student who has missed more than three days of class or any test scores that fall below passing. Learn more here.

Formula-based Conditional Formatting

And sometimes, just a basic highlight isn’t enough. Sometimes you want your spreadsheet to help you identify the next step in your process, like setting up a conference with parents or an email to the student. Formula-based conditional formatting can help with that. Here’s how.

=SUM(): The first function you learn really adds up.

You already know how to add up cells in Excel, but did you know you can hit CTRL + [Cells you want to add] to instantly add them to an equation? This is a fast way to add across random columns or rows.

=SUMIF(): For more selective sums

Sometimes you want to add and gather data in a different way. The =SUMIF equation will look for certain data in a table and add similar items together. This could be helpful if you track attendance by day of the week and want to learn which days most kids come to class.  Learn more here.

=COUNTIF(): Add up occurrences of a value.

=COUNTIFS(): Add up occurrences of multiple values.

The COUNTIF() function allows you to count how many times a certain criterion occurs in your specified range. For example, if you add a letter value grade to each assignment, you can use the COUNTIF() equation to count how many As, Bs, Cs, Ds, and Fs a particular class or a particular student has. Use =COUNTIF(Where do you want to look?, What do you want to look for?).

More information on COUNTIFs here.

=AVG(): The average formula for above-average teachers

The average function works similarly to =SUM in that it allows you to grab the data within a column or throughout a sheet. If you use average test or homework scores to finalize grades, the =AVG function adds up (and divides evenly).

=MIN(): Find the lowest number in a range

=MAX(): Find the highest number in a range
This is a great way to find the range of cells quickly and accurately, especially if you are grading on a curve, or want to quickly obtain the range of test scores for a given exam.

=LEN(): Count characters in a single cell.
Never misjudge your Twitter character count again. This function will count the number of characters in a specific cell. Great for writing assignments with text limits.

=RANDBETWEEN: Generate a Random Number

Need help picking which student goes first with a presentation? Enter the RANDBETWEEN equation. Simply type =RANDBETWEEN(1,100) and it will return a completely unbiased whole number between 1 and 100  just like that.

=ROMAN: Convert to Roman Numerals

Perhaps not the most useful of formulas, but when C, V, L, and I are Greek to you, it can be a useful tool. Use =ROMAN(Destination cell with number you want to convert).

=ROUND(): Do a one-handed round-off

The =ROUND function allows you to round off numbers to a specific digit. Use =ROUND(number, digit) as the equation, keeping in mind that “0” digit will return a whole number, “1” returns to the tenths, and so on. =ROUNDUP() and =ROUNDDOWN() are equally fun, and further explained here.

=YEARFRAC(): Compare a date range to the entire year.

=DAYS(): Count the number of days in between two dates.

=NETWORKDAYS()

Still counting down to the end of the year? Excel can take the work out of that, too. Use =YEARFRAC(start_date, end_date, [basis]). For example, =YEARFRAC(1/1/2018,5/31/2018, 1).  Learn more about the calendar basis here. For the number of days or actual work days, use =DAYS(start date,end date) or =NETWORKDAYS(start,end) respectively. Place your date values in cells for increased flexibility and celebrate further with conditional formatting. 

These are our favorite Excel equations so far in 2018. Which ones did we miss of yours? We'd love to know and talk more about education tech, especially when it comes to Microsoft.

How To Prevent Tech Injuries

Technology has moved us forward in many ways, but it can also have us curled up in pain if we’re not careful. Here are four common tech-related injuries that are as easy to get as they are to prevent (thank goodness).

Computer Vision Syndrome (CVS)

If you use a computer for more than two hours a day, you could be at risk for computer vision syndrome, a condition characterized by eye strain, headaches, blurred vision, and dry eyes. While the condition is temporary, it can be frustrating, especially for people who must focus on computer screens for a large part of their days (and this adds up to about 70% of us, according to the American Optometric Association).

If you suffer from CVS, add frequent breaks to your daily routine, adjust the distance between your computer and your eyes, and keep your doctor apprised of any symptoms that don’t go away.

Tinnitus

Avid cellphone users--those who actually use their phones as phones--may be at a higher risk of developing tinnitus, a consistent ringing in the ear. While the connection is up for debate, some studies found that people who talk on cellphones for more than four hours a day were at an increased risk of developing tinnitus, which is difficult to treat.

Tech Neck

Tech neck is the catchy name for a condition that refers to degenerative neck changes due to poor posture, namely the shape we take while we are pouring over our smart phones and laptops. Maintaining this posture for long periods of time can lead to disc injury, muscle strain, nerve impingement, and ongoing related pain over the shoulders, down the back, and along the length of both arms.

Carpal Tunnel Syndrome

Carpal Tunnel Syndrome is one of the reasons why repetitive motion injuries rank ninth for most common work-related injuries. The more time you spend hunched over your keyboard, the more likely you are to irritate the median nerve in your wrist, causing numbness, tingling, weakness, and pain in your fingers and hand.

Preventing carpal tunnel, and all of these tech-related injuries, is as easy as maintaining good posture at the keyboard, elevating your wrists while typing to avoid nerve compression, and taking frequent breaks to stretch, focus, and move your body in a variety of ways. Make it a habit to remind yourself and your students to sit up straight, pull shoulders back and down, and place both feet flat on the floor.

Arey Jones is here to make educational technology a comfortable experience for all, which is why we’ve been an industry leader for more than 30 years. Learn more about Arey Jones.

Setting SMART Goals For Your Classroom

While the New Year for the rest of the country started on January first, most teachers would agree their “new year” started last fall--and so did all of their goals for the school year. That said, January is the perfect time to review those goals, establish new parameters, and determine if they need to be adjusted.  

And using technology is a great way to do it.

We at Arey Jones are a big fan of the S.M.A.R.T. method of goal setting, a way of setting Specific, Measurable, Achievable, Relevant, Time-bound goals. And when it comes to tracking and tackling targets, we dream big--and we dream in spreadsheets, calendar reminders, forms, and fonts - all in Google Drive.

Specific: Write Down Your Goals in Google Docs
On top of being portable and flexible, Google Docs allows you to share your goals with relevant people in your life, and they can leave comments of support, hold you accountable,  or add resources to help you along. How you phrase your goals is an important part of the process, and it’s important to keep these things in mind:

• What do I want to accomplish?

• Why is it important?

• Where must I focus my energy and time?

• Who is involved in its success?

• Which resources will help me succeed and which hurdles will make it more difficult?

Measurable: Using Google Forms to Track Progress

A SMART goal is a measurable one, and Google Forms is a relatively simple tool with many versatile uses. Simple set up the form to input all the metrics you want to track on a daily, weekly, or monthly basis. From charting how many pages your class has read at home to keeping track of how many cups of coffee you’ve had each day, Google Forms is a highly-customizable tool that streamlines, validates, and consolidates answers and translates them into visible charts and graphs. 

Achievable and Relevant: Using Google Sheets to Keep It Together

Some people have found additional success using Google Sheets to track goals. Unlike a software with a steep learning curve, Google Sheets is easy to use, personalize, and adapt to your goals. Use Conditional Formatting to help you stay on track and organize your goals by worksheet to keep your thoughts, relevant resources, and successes handy. 

Time-Bound: Use Google Calendar To Set Reminders 

If friends, forms, and spreadsheets don’t hold you accountable, a daily reminder in your Calendar feed will. Create a fresh Google Calendar for your goals and set up small, actionable deadlines for the goals you want to work on today, next week, next month, and so on. 

What are your goals for the next semester? We hope you're able to accomplish them, and if you need help, we're always happy to chat.

5 Ways to Strike the Right Keys (And Keyboard Shortcuts) This Semester

While we wish life outside technology offered this sort of efficiency, it’s nice to know that these quick keys are there when we need them. They won’t solve all of your woes this semester, but they may create a little more time to make them easier to handle.

Find what you are looking for, instantly.

Want to know when an internet article mentions a certain concept or name? Hit CTRL + F. This Find function will not only tell you how many times the word or name occurs, but it will also highlight them throughout the document. Use the F3 key to toggle in between mentions. Want to find something in your files? Use the WINDOWS + E quick key to search File Explorer.

Want to use this quick key to find something more valuable? Give it a whirl. Click CTRL + F and type “sanity” in the field. <--See? Win.

Go back in time.

I’m guessing you already know the ever-useful CTRL + Z quick key to recover previous material and undo the most recent change.

Add to the time traveling ability while also eliminating the minutes (hours?) you spend moving your hand down to the trackpad or mouse to hit the back button on your web browser by using the CTRL + LEFT ARROW instead. Use the time you’ve saved to close the 13 tabs you aren’t using (and CTRL + SHIFT + T to open them all again).

Improve your vocabulary.

We all want to keep our conversations and papers engrossing, succinct, and perspicacious, which is why it’s nice that a thesaurus is just a SHIFT + F7 away.

Be in two (or more) places at once.

When you want to output your screen to a projector, broadcast to a wireless display or connect to one or more external monitors, you can find all of your options with the WINDOWS + P command. It will bring up an interface screen that will provide you with display options, all at the click of a button.

Start over.

We all need a do-over button once in a while, and your Windows machine has several to choose from. CTRL + R will refresh your browser. CTRL + ALT + DELETE will restart your computer. There’s also the handy power button quick-key for when you really feel like shutting down.

Want to learn how to save time with your educational technology in other ways? We can help with that.

5 “Cool” Ways to Learn Something New Over Winter Break

As much as we love educational technology at Arey Jones (and you know we do), we also enjoy time spent completely unplugged. This winter break, take a moment to explore the many off-line experiences that are right outside your door or in your game closet--and learn something new about the world, your family, and yourself in the process.

Get some fresh air.

Created in 1916, the National Park Service manages over 84 million acres of parkland in 417 areas, all 50 states, and four territories. Chances are you have a national park, a historical monument, a national or regional battlefield, a historic site, lakeshore, seashore, riverbank or scenic trail near you that is worth exploring. Bundle up and bring your camera; you’ll want to document and share what you find! 

Explore a museum.

According to the Institute of Museum and Library Services, there are over 35,000 active museums in the United States alone. A vital part of American culture, history, and the educational landscape, these museums provide rich and real content for every age of learner. From spy museums to planetariums, from art museums to zoos, there is a museum for every interest, hobby, and day of the week (for the next 96.3 years). Explore them all here.

Read.

Nothing passes winter boredom like an adventure between actual pages. Put your nose in book and your feet in a library--one of the 119,487 libraries in the United States alone. Despite being chock full of fact and fiction, there is no single annual survey that provides real-time statistics for all types of libraries--but that is ok. All you need to know is where to find one, how to get a library card, and which sorts of books you can’t wait to read. 

Get your game on.

Nothing connects families together like some good ol’ fashioned competition. Dust off generational favorites like checkers, chess, cribbage, or even a game of war with two decks of cards. Stay home, make some hot chocolate, and brew up some fun right in your living room. You may not make history, but you will make memories, one move at a time.

Will you be unplugging over the holidays? How will you pass the time this winter break? If you're researching about educational solutions to provide to your classroom, be sure to get in touch with us.

Global Learning Opportunities with Classroom Technology

The Internet is a global marketplace--not just for the exchange of goods and services, but also the exchange of ideas and experiences. Communication, collaboration, and innovation are now operating on a worldwide workspace, and today’s students now have the chance to not only learn about the world but also immerse themselves in real conversations with the people who live in it--in real time.

Researchers are finding that there is a difference between the digital divide and what’s becoming known as the “participation gap;” it’s one challenge for students to not have access to the digital media experiences, and quite another to have those opportunities and not use them to access, participate, and create connections with information and people. 

How to Use Technology to Enhance Global Learning

Harness worldwide news to capture cross-cultural context and understanding.

As we’ve seen in our own country’s news sources, there are at least two sides to every story. Use this opportunity to help students learn how to uncover, identify, analyze and evaluate news sources, not just from the United States, but from around the world. Use these real-time sources to grow students’ awareness of how different countries, cultures, and peoples respond to events--and how those reactions are represented in global mass media.

Assignment idea: Take a recent global event and compare headlines from around the world.

Uncover personal opinions through research.

By widening students’ exposure to the opinions of others while also giving them access to factual commentary, resources, and collaboration, students are better equipped to discover their own opinions about global matters--all the while understanding the tools to form their own opinions about issues closer to home.

Assignment idea: Look for “citizen journalists” on the internet who find and report on breaking news as it happens in their countries. Ask students to analyze the difference between these reports and those broadcasted on the news and help them identify fact from personal opinion. Take it one step further and uncover the possible roots for those opinions and context.

Log into global knowledge networks.

Gathering our collective intelligence on a global scale is possible through the use of global learning networks where information is collected and analyzed. Reading and participating in these networks allows students to grow their cross-cultural understanding while actively and responsibly collaborating to build on existing knowledge. 

This is most evident in the world of science, where people can collect information and share it with people around the world for a common goal.

• Global Learning and Observations to Benefit the Environment (GLOBE) is operated by NASA and the National Science Foundation in 110 countries. It engages youth, educators, community members, and scientists in collecting and sharing data internationally about critical environmental issues.

• The National SEED Project (Seeking Educational Equity and Diversity) opens up conversations between communities.

• ePALS: Explore ways to connect students, classrooms and learning opportunities.

• iEARN invites students to “learn with the world, not just about it.”

There are many ways classrooms are reaching across oceans and borders to learn about each other. How are you incorporating technology into your quest for to learn and teach greater global understanding? If you aren't sure, be sure to reach out.

Five Onederful OneNote Tips for Teachers

Microsoft’s OneNote is basically today’s version of a Trapper Keeper; it organizes topics by subject, has a place to store the pictures, videos, and freeform ideas may otherwise fall through the folds, and, bonus, it can be duplicated, shared, locked, and loaded anywhere. For teachers, it means being able to pull every component of a lesson plan together, from quizzes and writing prompts to resources, reading lists, and class notes.

One thing is for certain, the more you learn about OneNote, the easier it becomes to teach. 

Make Note-taking a Team Sport

OneNote gives teachers the ability to frame out a lesson and let their students fill in the gaps with the note-taking. By sharing a note with the entire class, students can access, contribute, and collaborate in real time--and long after the class bell rings. Password protection for notes makes it all the more secure.

Go beyond typed notes.

OneNote allows you to “make a note” of something in almost any medium. Video, images, audio, digital ink--all of it can be noted, recorded, linked, saved, and shared in the OneNote platform. You aren’t limited to an 8.5” x 11” sheet, either; its infinite canvas ensures you’ll run out of ideas long before you’ll ever run out of room to put them on. Creating new sections is easy--and you can even color code them by subject, note type, or student.

Teach in the moment.

Have you ever had an “aha!” moment in class and wished you could share it more readily with your students? Enter OneNote. With its immediate syncing capability across devices, you can take a picture with your mobile phone and add it instantly to your presentation, allowing you to teach and collaborate with your students in real time, just in time.

Embrace your own teaching style.

One of most empowering aspects of OneNote is that it’s not just one thing, nor does it confine its use to one tool. “Learning is messy,” says Tom Grissom, the Director of the Instructional Technology Center at Eastern Illinois University and contributor to the Microsoft Education blog. “OneNote provides the free-from tools to help you--and your students--think through it.” he notes that OneNote excels at “gathering artifacts for learning” while also allowing the information to be redistributed and assimilated. 

Get it all down and get it all done.

OneNote is the perfect bucket in a brainstorm. It speaks Google tools as a first language; you can toggle between Google Docs, Google Sheets, and even Google Forms as part of your lesson planning and classroom management practices. And, since you can take it with you wherever you go, you never have to worry about losing a great idea or missing an opportunity to interact with a student because you aren’t at your desk. OneNote lets you check notes, grade papers, send assignment reminders, share videos, and inspire a new generation of learners with a few clicks. 

How do you use Microsoft OneNote in the classroom, along with other Microsoft technology? We've got a few ideas.