How to Get Started with Nested IF Statements in Google Sheets

We got this email from Dan Stitzel today:

Good morning!

Dan Frost asked me a great question, but I didn’t have a quick answer, but I know there has to be a way. The question is below:

Is there a way in conditional formatting or data validation that a color or text will automatically enter text into a separate cell? For example, 3-5 is low, 6-8 is average, ad 9-10 is above. Is there a way to type “3” in cell b8 and the word “low” appears in cell c9?

If this does not make sense, let me know!

Thanks!
Dan

Solution

Doing this kind of work is pretty easy with a nested IF statement in Google Sheets, but you have to mind your ps and qs so the statement doesn’t get super crazy…

Essentially, IF this is TRUE, then do THAT…

Works like this:

=IF(A1=3,"THREE",IF(A1=5,"FIVE",IF(A1=8,"EIGHT","TRY ANOTHER NUMBER")))

Using < for ranges, would look something like this, structuring the formula from low to high:

=IF(A6<5,"LOW",IF(A6<8,"MEDIUM","HIGH"))

You can of course make use of > or < symbols as well… The last argument “TRY ANOTHER…” is the error, or ELSE, as in if none of the nested IF statements are true, then what? Remember, all text needs to be in double quotes…

Then, you could always conditionally format on the words, if needed…

Here’s the sheet above: https://docs.google.com/spreadsheets/d/13jokc_BOaehnhQgiCWAaNz0ARBQrnEH8dTQ2AvC79Mo/copy

Want more? Head here: https://support.google.com/docs/answer/3093364?hl=en

Empowering Our Students with the New Ohio Strategic Plan

via Ohio Department of Education, written by Jonathan Juravich.

Ohio’s Strategic Plan for Education, Each Child, Our Future, specifically speaks to what teachers already know — that each and every student in our classrooms is important and valuable. Their individual success is our priority. It is our role as educators to be sure they are continually challenged, prepared and empowered. This is what encourages me about the new strategic plan — a plan that supports and highlights the excellent work already happening in countless classrooms throughout our state. Continue reading “Empowering Our Students with the New Ohio Strategic Plan”

How to Filter Emails from Google Classroom

Email overload from Google Classroom?

If you’re anything like us, you’re using Google Classroom for any and all student assignments, and likely, your inbox gets flooded with emails telling you that Susie turned in her essay, or Johnny answered a question.

But do you really need all those emails? The short answer is yes, but not in your inbox… So let’s clean them up, make a filter, and send the email notifications from Classroom to its own folder. So easy! Here’s how… Continue reading “How to Filter Emails from Google Classroom”

Z Drive & Network Storage Update (August 2018)

Hello everyone!

THE BAD NEWS 🙁

The Z drive network storage disk died this summer and became unusable mid-July. We were unable to access (from our end) any of the data, and all the tricks we had up our sleeves didn’t work (which included techniques like putting the drive in the freezer to cool off for a bit…)

THE GOOD NEWS 🙂

We contracted with an outside vendor (more on that later, in a separate email, because we setup a partnership with them should you ever need data recovery services yourself) and they were able to recover 99% of the data for us! Continue reading “Z Drive & Network Storage Update (August 2018)”

Cultural Connections – Learn About Fika, a Swedish Tradition

Standards Connection

Ohio’s Social Studies Standards, grade 2

  • CS 8: Cultures develop in unique ways, in part through the influence of the physical environment.
  • CS 9: Interactions among cultures lead to sharing ways of life.

What is fika?

via http://www.swedishfood.com/fika

Fika is often translated as “a coffee and cake break”, which is kind of correct, but really it is much more than that.

Fika is a concept, a state of mind, an attitude and an important part of Swedish culture. Many Swedes consider that it is almost essential to make time for fika every day. It means making time for friends and colleagues to share a cup of coffee (or tea) and a little something to eat. Continue reading “Cultural Connections – Learn About Fika, a Swedish Tradition”

New Theme Options to Help Brand & Customize Your Google Forms

To help Google Forms users create more personalized surveys, feedback forms, quizzes, and more, Google is introducing new theme customization options.

Specifically, you can now choose colors and fonts to theme your form. This has been a top feature request from Google’s users, who have asked for more options to create forms that match their organization or team branding. They hope these options help you build forms that look and feel just right.

Continue reading “New Theme Options to Help Brand & Customize Your Google Forms”

About the General Data Protection Regulation

You’re likely getting a lot of email from various vendors about the GDPR. It only applies to companies that do or want to do business in the European Union, but some companies in the United States are following suit and matching requirements here regarding data protection for individuals.
 
It does not necessarily impact how we handle data protection here at Streetsboro Schools since we are not in the business of aggregating, collecting, and selling user data to others. In fact, we take several measures to protect both student and staff data and only disclose the legal minimum to vendors and other partners – enough data to create a username, for example.
 
Regardless, your personal data in accounts like Twitter, Facebook, and other online services are likely impacted by the now enforceable regulation in the EU, and you will be able to make choices about your data with some of those vendors. It’s important to fully understand how it impacts you as a private citizen, and how you may take steps to protect your data, and yourself. 
 

So, what is the GDPR?

 
The General Data Protection Regulation (GDPR) (EU) 2016/679 is a regulation in EU law on data protection and privacy for all individuals within the European Union and the European Economic Area. It also addresses the export of personal data outside the EU and EEA. 
 
The GDPR aims primarily to give control to citizens and residents over their personal data and to simplify the regulatory environment for international business by unifying the regulation within the EU.
 
Superseding the Data Protection Directive, the regulation contains provisions and requirements pertaining to the processing of personally identifiable information of data subjects inside the European Union. 
 
Business processes that handle personal data must be built with data protection by design and by default*, meaning that personal data must be stored using pseudonymisation or full anonymisation, and use the highest-possible privacy settings by default, so that the data is not available publicly without explicit consent, and cannot be used to identify a subject without additional information stored separately. 
 
*Apps like Facebook and Twitter operate quite the opposite, with the intent of collecting and selling your information – it’s how they make money.
 
No personal data may be processed unless it is done on a lawful basis specified by the regulation, or if the data controller or processor has received explicit, opt-in consent from the data’s owner. The data owner has the right to revoke this permission at any time.
 
A processor of personal data must clearly disclose any data collection, declare the lawful basis and purpose for data processing, how long data is being retained, and if it is being shared with any third-parties or outside of the EU. Users have the right to request a portable copy of the data collected by a processor in a common format, and the right to have their data erased under certain circumstances. 
 
Public authorities and businesses whose core activities center around the regular or systematic processing of personal data are required to employ a data protection officer (DPO), who is responsible for managing compliance with the GDPR. Businesses must report any data breaches within 72 hours if they have an adverse effect on user privacy.
 
It was adopted on 14 April 2016, and after a two-year transition period, became enforceable today, 25 May 2018. 
 
Because the GDPR is a regulation, not a directive, it does not require national governments to pass any enabling legislation and is directly binding and applicable.
 
For the complete text of the GDPR, visit https://gdpr-info.eu/