Uncategorized

8 Basic Google Sheets Tips Every Teacher Should Know About

Google provides a lot of useful programs for teachers, but not everyone understands just how to use them. There are a lot of hidden features available for teachers, particularly when it comes to Google Sheets. Understanding how to use these features and apply them in the classroom is essential to help you create better documents in less time.

To get you started, here are eight of the most basic Google Sheets tips that every teacher should know about.

Add a Line Break

While editing a cell, you can insert a line break to help organize your text better. All you have to do is make sure that your cursor is in the cell, ready to type. Press Ctrl+Enter to move to the next line without changing cells.

Merge Cells

Do you need to combine cells in the spreadsheet? You can merge cells both vertically and horizontally. Simply highlight all of the cells you plan to combine and then click merge on the toolbar. There should be a drop-down menu that will give you additional options.

Freeze or Unfreeze Columns and Rows

If you want to see a certain row or column while you scroll, you need to freeze it in place. Highlight the row or column that you would like to freeze. Click “view” and then “freeze or unfreeze.” It might also give you an option to select how many rows or columns you want to freeze in place.

Add a Chart

You can customize your own chart or graph to add to the document with the data you added on the spreadsheet. Highlight all of the data you want to be included in your chart. Under the “insert” tab, you will find a separate option for “chart.” Teachers can choose the type of chart they want under the recommendations tab. Edit the display and the chart itself under the customization chart before you click “insert.”

Use a Formula

Do you want to avoid doing all of the math with your data? You can enter a formula to keep you from pulling out the calculator. In a cell, you can type in the equal sign with the function you want to use. This should prompt a separate help box to pop up that gives you the list of available functions, the wording for each function, and an example of how to use it.

Wrap Text 

If you want to wrap the text in your spreadsheet, select the cell. You can click on the format tab to bring up a list of options. Select text wrapping and then click “wrap.” Follow the same steps to turn it off but select a different final option. 

Protect a Sheet or Range 

Are you afraid someone will edit your spreadsheet? Protect it with this nifty tip. Open up your spreadsheet and head to the data tab. You should see an option for protected sheets and ranges. A separate box will appear after you click here, asking if you want to add a sheet or range to your protection. Select the appropriate options and finish by following the prompts to set permissions or change permissions. Click save or done when you are finished. 

Add a Custom Date or Time 

Start by highlighting the data you want to convert to a specific date or time formula. Then, you will need to head to the format tab and click on “number.” There will be another option for “more formats” and then “more date and time formats.” Find the option that you want or set your own custom date and time format into the search box. Click apply to make it stick.

What Does a Future Ready University Administrator Look Like?

The goal of the future ready movement is increasing digital learning opportunities for all students. While the movement itself is focused on K-12 students, the effort has a logical counterpart in the higher education population, where university administrators are uniquely positioned to advocate for their students by becoming future ready themselves. So what does a future ready administrator look like?

First, the key characteristic of the future ready university administrator is that he or she is always improving their practice by incorporating the latest edtech and other tools to maximize student engagement and learning. An easy way to do this is to follow the official future ready account on Twitter. But regardless of the method chosen, a tech-focused administrator will need to keep current and be aware of the latest in edtech.

Second, a future ready administrator can model collaborative learning and increase their knowledge of the future ready movement by attending one of the free regional events sponsored by the future ready movement.

Third, they model best practices through their use of digital tools. They carefully ensure that their digital footprint and social media presence are in line with their institution’s values and norms. They, obviously, do not engage in cyberbullying, but they also show how to be an “upstander” instead of a “bystander” when they become aware that someone is being mistreated in a digital space. In other words, they show by example what it means to use digital tools responsibly.

Fourth, they model and advocate for best practices in data management and privacy. This is no easy task in a world where even major corporations seem to have a catastrophic data breach nearly every week, but the wise administrator does what is within their sphere of influence to ensure that the university keeps student data safe and also teaches students how to protect their own data. They also teach students how to evaluate digital media—and ensure that they model best practices by never, for example, sharing “fake news” themselves.

Fifth, wise administrators are keenly attuned to issues of digital equity. They know that, contrary to the public perception of students as perpetually plugged in, some students struggle to maintain access to the tools and devices that they need to complete their coursework. They are aware that some students will be hesitant to reach out for help, so they ensure that there are nonetheless ways to be sure that these students’ needs are met.

Using Amazon Alexa for the English Classroom

Apart from reading great literature, some educators struggle to come up with new ways to make English class engaging. Edtech has a lot to offer teachers who want to foster a deep love of language in their students. One of the most affordable pieces of edtech, Amazon’s Alexa, can be a simple way for students to engage in reading and writing at a deeper level. Most students love the silly games and interesting stories that are available to captivate their attention on this playful device.

If you have been trying to figure to how to use Alexa to make English class more engaging, here are five of the top programs your students will enjoy.

Reading Books Aloud

Did you think that reading aloud was just for elementary school? Older children can benefit from hearing their books read aloud on Alexa, particularly if they are auditory learners. Alexa can read any book from your Kindle collection for free, but the robotic voice might be distracting to you and your students. Alternatively, you could pay for an Audible subscription that would allow you to play professionally recorded audiobooks while students followed along in their own individual copies.

Spelling

Forget the days when you had to grade papers riddled with spelling errors. Your students can now ask Alexa how to spell anything and everything. This is a great way to improve their vocabulary before important standardized tests like the SAT and ACT. It also prevents them from getting distracted when searching for the spelling online.

Definition

Maybe your students have a difficult time with the elevated vocabulary in a particular novel. They can ask Alexa to define any word they come across. This is particularly great for students who have English as a second language and may not have the fluency required for your reading list.

Daily Dose by Innovative Language

Do you have students who struggle because English isn’t their first language? Alexa can help to sharpen their skills and increase their fluency with the Daily Dose by Innovative Language. This program will provide you with a new word of the day, as well as conversation practices that last ten to twenty minutes. One of the best parts of this app is that it doesn’t require anyone to help a student who simply needs more practice with conversational English.

Grammar Tool

Give your students a hand when it comes to studying for their SAT and ACT with Grammar Tool. When this app is activated, Alexa will give you a word, the part of speech, its definition, and an example of how to use it. Repeating the word back will begin a short interactive vocabulary game with Alexa. With continued usage, you should be well prepared to take their standardized tests with confidence!

 

10 Amazing Hackathon Ideas

You have probably heard the term “hackathon,” but you may not be sure of what it means. A hackathon is most commonly associated with hackers or computer programmers. However, while hacking typically involves computers, hackathons are primarily events where groups of people gather to “hack” an idea. At these major events, people come together to take an idea and turn it into something real using technology.

As schools are focusing on STEM education, it is only natural for educators to consider adding hackathons to their lesson plans. Why? In addition to encouraging creativity, critical thinking, and collaboration, hackathons are fun! Students will learn how to take an idea and bring it to reality in a competitive (but collaborative) atmosphere.

If you are new to hackathons, you may not even know where to begin. Traditionally, hackathons come from identifying a problem and then considering different ways to solve it. For instance, how can a new tool or app make life easier?  To help you get started, here is a list of possible hackathon topics to get your students thinking.

  1. Education

Education is open-ended. Have students consider how they can use technology to make lessons more engaging, entertaining, or easier to understand. This can be anything from gamification to study tools.

  1. Cyberbullying

A major concern for today’s students is cyberbullying. Encourage your students to think of ways they can use technology to combat cyberbullying.

  1. City Planning

Map apps make our lives easier, but even more so when the maps are designed around the places we go. Since students have their own favorite places to visit, have them design a tool that helps students get where they need.

  1. Environmental Issues

For students drawn to environmental causes, allow them to look for ways to address environmental problems. Considering our last suggestion, they may want to develop an app that helps users know where, what, and how to recycle.

  1. Hack for Good

Societal causes are wonderful ideas for hackathons because they identify genuine problems, so students are invested in developing solutions.

  1. Exercise

With the myriad of apps and tools for tracing heartrate and steps, point students in the direction of exercise.

  1. Health

As childhood obesity continues to be a problem in the US, have your students think of ways to encourage kids to make healthy food choices.

  1. Music

For the musicians in the classroom, encourage them to see how they can creatively combine technology and musicality.

  1. Science and Human Anatomy

Consider a science lesson and think about the ways your students can make it more understandable and relatable.

  1. Robotics

Do we even need to explain why your students will love this idea?

Before we go, your first hackathon may feel overwhelming. Fortunately, there are excellent resources to help you plan and prepare for the big event. For instance, Wolfram Cloud has a Hackathon Project Generator; Hack Dash is a site dedicated to hackathon ideas; and, The Hackathon Handbook has a wealth of resources.

Using Digital Learning to Promote Lifelong Learning

It’s easy to focus on the immense potential that edtech brings to K12 classrooms, but the use of digital learning to promote lifelong learning has received less attention. And yet digital learning is just as powerful of a tool—if not moreso–for adults who want to expand their horizons. Here four ways that lifelong learners can use digital tools:

First, while massive open online courses have been of only limited success so far, they may hold promise for motivated adult learners. It seems that one of the biggest problems with MOOCs is that students do not complete the classes, but a lifelong learner is less likely to have this problem. And the proliferation of MOOCs means that lifelong learners have access to learning opportunities that would have cost them thousands of dollars—even if they were locally available—only a few decades ago, but that can now be enjoyed for free, from home, on one’s own schedule.

Second, it used to be rather difficult for a lifelong learner to find opportunities to learn a foreign language. But a multiplicity of language learning apps make it possible to learn—for free—nearly any language. Given the increased globalization of the marketplace, the ability to speak a new language can often make a profound difference in the job prospects of adults, so learning another language may be one of the best strategies to improve one’s employability.

Third, accessing scientific laboratories is not something that the lifelong learner has traditionally been able to do. But many universities and other organizations have created simulations that make it possible for lifelong leaners to continue to learn about scientific concepts that have been digitally simulated. The best of these simulations allow learners to “play around” with the lab equipment and, in effect, conduct their own experiments.

Fourth, while it might seem to be a relatively low-tech option in the second decade of the twenty-first century, the power of digital library books and audiobooks should not be overlooked. Most lifelong learners will have access to these digital resources through their local public library, and thus will be able to access the latest books with an ease and variety unknown to previous generations. Wise students will take advantage of this option to improve their minds. Further, they can listen to podcasts or read articles by those who critically engage what they are reading in order to further broaden their horizons.

7 Gamification Strategies for Corporate Training

When you think of corporate training, the term “fun” probably doesn’t come to mind. But with gamification, even the most mundane learning experience becomes more engaging.

And the benefits don’t stop there. Gamifying corporate training:

  • Motivates employees with recognition and rewards
  • Stimulates collaboration
  • Makes important information more memorable
  • Provides a way to measure progress toward learning objectives

In most cases, companies gamify training using custom built learning games, which can be expensive. You can also use free tools like Kahoot, which allows you to create competition-based assessments.

However you decide to gamify your corporate training, follow these seven strategies to ensure you do so effectively!

Establish specific learning outcomes.

Gamification is fun, but it shouldn’t only be fun. You also need to consider exactly what you’re trying to achieve. Ask yourself questions like:

  • What do I want my employees to learn?
  • How will gamification enhance their learning?
  • How will I know that my employees have achieved mastery?

Knowing your goals and how you’ll measure them ensures that your participants aren’t just having fun—they’re also learning.

Design reward systems related to the real world.

Once your learners have mastered the desired content, you want this knowledge to translate into job performance.

One way to aid this translation is to implement in-game reward systems that are tangible, recognizable, and relatable. For instance, your training might involve participants selling a certain amount of products/services in order to win points.

Even better, the points your participants earn in the game might represent the amount of commission they would receive for these sales in real life. This cements the idea that the knowledge your participants are learning translates to real revenue for the company, plus dollars in their pockets.

Make gamification social.

Collaboration is one of the greatest benefits of gamification, so be sure to take advantage!

Make the experience as social as possible for your learners, whether this means forming teams, competing, displaying and discussing the leaderboard, etc. Some companies even integrate existing social media, like Facebook, into the game.

Harness the power of gamification to help your employees collaborate, enjoy a sense of camaraderie, and build relationships.

Make gamification challenging.

Ensure that your gamification is challenging enough to push your learners to the next level. Training that’s too easy will be ineffective and dull.

A challenging game is not only more effective, but it’s also more engaging.

Gamify induction and onboarding.

Induction and onboarding is notoriously boring, so this is one type of training you may want to gamify. Many companies now have new employees create a virtual identity and complete missions, each related to some element of induction and onboarding training.

You may even incorporate a dashboard with progress, achievements, a leaderboard, and so on.

Gamify skills training.

You can take a similar approach to gamifying skills training. Learners face virtual challenges, receive learning support, and gain badges or points at each level.

Of course, creating these custom built games is pricey. If you want to save money, you can also apply game mechanics to non-game activities. For instance, your learners can earn “XP” or “points” for completing certain tasks or mastering specific skills. You can have an in-office leaderboard to track progress and add a competitive aspect.

Gamify instructor led training (ILT).

The easiest way to gamify ILT is through gamified assessments, such as Kahoot! Kahoot! allows you to create your own quiz based on the key information that you want your learners to know.

Questions are displayed for a set amount of time (such as 20 seconds) while participants answer on their own devices. Points are awarded for both accuracy and speed, and a leaderboard is displayed after each question.

This basic service is free, but you can also upgrade to Kahoot! Pro, a new tool developed specifically for businesses.

Final Thought

If you want to make your next corporate training more engaging, motivational, collaborative, and memorable, try implementing the gamification strategies described here.

You’ll still reach your learning outcomes, but you’ll have much more fun in the process!

Which Country Is Leading the Edtech Movement?

Technology has the potential to enhance global education, but which country is leading the edtech movement?

Let’s look at a few contenders.

The United States

Currently, many would say that the United States is the leader in edtech. According to the Software and Information Industry Association (SIIA), the U.S. edtech market is worth over $8.38 billion dollars. And in 2015, 60% of the money invested in edtech was invested in the United States.

The country’s population size, large economy, and tech and innovation hubs such as Silicon Valley contribute to edtech’s success in the United States. The U.S. has pioneered advances in edtech and its implementation, spearheading active—rather than passive—use of technology in the classroom.

The United Kingdom

In other developed nations, such as the United Kingdom, edtech also has tremendous growth potential.

A report by EdTech UK suggests that there are now over 1000 edtech companies in the UK, with at least 200 based in London. The UK is also home to a strong education sector and Europe’s largest tech cluster, indicating that there’s still much room for growth in the edtech industry.

Asia

Although the United States might be leading the edtech movement currently, Asia has become the fastest growing e-learning market in the world.

In 2016, according to Goldman Sachs, global investments in Chinese edtech companies increased to $1.2 billion. In the future, China’s edtech industry is expected to grow 20% annually.

Meanwhile, in India, the online education market is set to quadruple over the next four years, ultimately rising to more than $1.96 billion.

Future valuations suggest that the entire Asia-Pacific region will represent 54 percent of the global edtech market by 2020.

Here’s why:

  • More than 600 million students are enrolled in K-12 schools in Asia, and Asia has more young people than anywhere else in the world.
  • Asia’s population is education-fixated, and families are willing to invest substantial amounts of money in their children’s education. (Tutoring in China is poised to grow to a $90 billion industry, and parents in Singapore spend $70,939 annually on their children’s education, roughly double the global average.)
  • The government’s 13th Five-Year Plan aims to modernize China’s education system, investing $1.07 billion in edtech startups in 2015 alone.
  • Key foreign investors are funneling large amounts of capital into supporting edtech in the region, along with Chinese tech giants.

And although Internet access has been an obstacle, about 53.1 percent of China’s population is now online, and this number will continue to grow in coming years.

Latin America

In Latin America, the e-learning market has grown by over 14 percent annually since 2013, and this development is likely to continue.

As in Asia, investors are taking notice and spending capital to support edtech. The region has also adopted numerous educational policies that encourage digitalization.

Latin America is now the fourth largest edtech market in the world, behind North America, Western Europe, and Asia in terms of revenue.

Israel

When it comes to the edtech market, Israel deserves an honorable mention as well. Although it’s a smaller country, it does boast a very strong tech sector.

Israel also hosts the “EdTech Israel Summit,” and the country has potential to be an innovator in the increasingly global edtech market.

Final Thoughts

While the edtech movement is growing rapidly in developed countries, other nations are falling behind.

In Africa, for instance, millions of children don’t receive a basic education due to poor educational policies and child labor. Additionally, only 29 percent of the continent has permanent access to the Internet.

On the plus side, access to mobile broadband is increasing around the world, providing educational opportunities to even undeveloped or remote areas. Already, Africa is one of the fastest growing markets for mobile phones, and mobile edtech is becoming an innovative way to get an education.

Over the next several years, the global edtech market will continue to grow, ideally benefiting schools and students around the world.

 

What Does a Future Ready Technology Coach Look Like?

The future ready initiative strives to increase access to digital learning for American students. Its principles and resources are a great boon for technology coaches, who are already probably aligned with the mission and approach of future ready instruction.

In fact, the initiative has a wide variety of resources specifically designed to help technology coaches improve student learning outcomes. One key principle is the idea of personalized learning. While most technology coaches are very familiar with this concept, there is still room to increase the personalization of most instructional materials on school campuses. The technology coach is ideally positioned to help classroom teachers learn about and implement edtech tools that make it possible for them to meet the unique learning needs of each student.

The wise technology coach can help teachers understand that personalization might require some substantive set-up time but will ultimately result in a reduction of the teacher’s workload—not to mention in improved student learning. Tech coaches can help teachers navigate what can seem like an overwhelming task of providing instruction designed for the unique needs of each student.

A future ready technology coach understands the crucial importance of equity—not just in education in general, but in the adoption of edtech in particular. Tech coaches will want to be sure that teachers have access to resources such as mobile hot spots to ensure that students without access to broadband at home are able to complete assignments. Many students may be embarrassed to announce their lack of access, so the technology coach will need to work closely with teachers in order to be sure that the needs of every student are met.

A future ready technology coach is also aware of the limits of edtech. As the old saying goes, if the only tool that you have is a hammer, then every problem starts to look like a nail. But the awareness of the dangers of excess screen time, especially when combined with what we know about how a variety of learning activities benefits student achievement, means that technology coaches may sometimes need to coach teachers away from edtech, no matter how counterintuitive that seems. But the technology coach is ideally positioned to know what a student is experiencing in all of her classes and to make suggestions that permit a balanced—instead of overwhelming—use of edtech.

Creating future ready students requires not just layering on new edtech on top of what a school is already doing but rather a fundamental reinvention of instructional practices. The future ready technology leader can guide teachers through this transition and provide the coaching needed to ensure that all students benefit from edtech tools.

Why Edupreneurship May Be Perfect for You

Do you have a background in education and a desire to run your own business? Many people are interested in a new category of business, commonly referred to as edupreneurship. It’s a play on words and combines two of the most important terms: education and entrepreneurship. This creates a unique category and content for potential candidates who are interested in a new way of teaching.

You may be wondering if this path is the right one for you to pursue, and it very well might be. To make a decision, here are a few reasons why edupreneurship may be perfect for you.

Edupreneurship is extremely flexible.

The concept of edupreneurship is extremely flexible, and that doesn’t simply refer to your office hours. The definition of edupreneurship is highly subjective depending on who you may be talking with and the subject matter at hand. However, there are a few basic elements that are the same all the time. A good edupreneur strives to:

  • Effect change in the education system
  • Develop new products or programs to deepen or improve the learning experience
  • Produce measurable results for academic standards

The methods you can use to approach these standards vary wildly. Your creativity and a unique approach to business are highly encouraged. While teachers may feel stifled by the classroom experience, edupreneurship gives them an opportunity to teach and design tools for doing so creatively.

You have a genuine passion for learning and teaching.

Can you think of anything better than teaching an important concept to a large crowd? Edupreneurship gives teachers an opportunity to expand their business and follow their greatest passion. If teaching has always been your dream job but you don’t love the classroom, edupreneurship could be a viable alternative.

Entrepreneurship, in general, requires a lot of dedicated hard work to make a business successful. Your passion and drive to create the perfect program or product are clearly seen in the final results. When passion tends to wane, you may come up with a less effective or less successful final product. In edupreneurship, a lack of passion could determine the efficiency of your teaching and learning platform.

You are very motivated to succeed.

One of the biggest indicators of success in edupreneurship is the drive to succeed. If you have a strong and overwhelming desire to achieve a certain success, this is likely to result in a brighter future. Motivation is a key factor for all entrepreneurs, as you will be required to work extremely hard to make your program or product work for your target audience. A motivation to succeed, alongside a business mindset and a stable business model, is said to be one of the most significant aspects of this sector.

Common teaching techniques are becoming a thing of the past as online and blended learning become more popular. Education is far from being a major business, but there are definitely some business opportunities for passionate educators who are motivated to succeed. Edupreneurship may be the ideal profession for you if you have what it takes.

 

 

 

 

To Succeed in Edtech, Become a Voracious Learner

Edtech companies are opening their doors around the world, but not all of them will experience true success in this sector. The most successful companies know they have to stay abreast of all the changes in today’s school system, as well as the latest technology updates. The face of technology is constantly changing as new products and devices are invented. All of this can make it difficult to succeed as an edtech company.

However, there is one thing you can do to improve your odds of success. Becoming a voracious learner is the key to developing a sustainable company. Learners with an insatiable thirst for knowledge will always manage to stay at the forefront of their respective fields. They can open their mind up to new possibilities, asking questions about everything they learn. All of this new information can be incorporated into an existing platform or a new idea that could revolutionize the education industry.

What types of things should you study in order to have a successful edtech company? Consider starting in one of these areas.

Current Education Trends

Over the course of the past year, schools have been increasing the number of devices in the classroom. Teachers are more apt to assign homework using online tools or to teach concepts using virtual games. These trends are essential for edtech entrepreneurs to take note of because they influence future designs. You have to know what teachers are being faced with and their current struggles in the classroom to develop edtech that truly works.

Emerging Technology

Do you know what the latest research from the technology field shows? You should be able to clearly identify emerging technology, trends, and ideas that are taking over your industry. The advances in technology happen rapidly, and it is easy to get left behind if you aren’t paying attention. Be sure to keep your eyes open for new products hitting the market. You should check in regularly with the major players in your field to see what they are working on.

Learn New Tech Skills

In addition to emerging technology, you should also stop to learn new skills. Read everything you can on coding, developing software, marketing, and other topics that specifically relate to your business. These are equally important if you want to be the best at what you do. When you learn new skills, you actually become a better problem-solver. This simple move could help you to develop better products that fill more pressing needs in the school system. Sharpening your skills will require a serious time investment, but it could help you to refine and streamline your next edtech product without any outside help.

Succeeding in a tech-based field will require constant learning to stay ahead of the current trends. You will need to focus on learning as much as you can so that you can offer unique ideas to the workspace. If you aren’t sure where to get started, some of these general guidelines should put on your way to becoming a voracious edtech learner.