Skip to main content

Search This Blog

Teaching Ahead of the Curve

Innovating Teaching and Learning in the Digital Age!

Pages

News
Workshops
Contact

Posts

Showing posts with the label Formulas

Use Named Ranges and Countif for Amazing Data Collation

Get link
Facebook
X
Pinterest
Email
Other Apps

Older Posts Home

Powered by Blogger

Theme images by Mae Burke

Gary Johnston: Gary is a 20 year educator who has worked in International Schools in Thailand, Vietnam, South Korea and now Peru. While in Asia, he was a frequent presenter at regional conferences such as the Vietnam Tech Conference, 21st Century Learning, Learning 2.0 and the Google Apps events. Now in South America, Gary serves as an innovation coach and design teacher at Colegio Franklin Delano Roosevelt International School. He also serves as a coach for school site mentors in the South American AMISA conference and regional liaison for the 'World Virtual Schools Project' supported by the US state department.

Total Pageviews

Follow by Subscribing!

Posts

Posts

All Comments

All Comments

Twitter

Tweets by @GaryJohnston1

I'm Following

Always Learning

School’s Closed, But Learning Doesn’t Have to Stop
Diane Ravitch's blog

Charlie Kirk, Political Violence, and Gun Control
Education Rethink

Ten Things That Happen When Kids Become Makers
Education Week: American Education's News Site of Record

Rutland City students to return to in-person classes
Free Technology for Teachers

Seven Mind Mapping Tools to Try This Year
Intrepid Teacher

Women of Influence
Middle School Matters

MSM 675: Personality vs. AI
Schools Matter

Where Are Media Investigative Teams? Victims of Pedophiles Want to Know
The Answer Sheet
The Thinking Stick

Followers

Labels

Formative Assessment21 Google Forms20 Google Apps19 Rock Star Productions19 Connectivism12 GAFE12 Google12 Google Docs12 Assessment11 Twitter10

Web 2.010 Data9 Science9 Youtube9 21st Century Learning8 Authentic Assessment8 Experimental Design8 Google Spreadsheets8 Blended Learning7 Collaboration7 Flubaroo7 Project Based Learning7 SAMR7 Summative Assessment7 COETAIL6 Content creation6 Creative Commons6 Doctopus6 Flipped Learning6 Genius Hour6 digital footprint6 grade inflation6 statistics6 Apple5 Explain Everything5 Google Maps5 Google Sheets5 Graphic Organizers5 IPad5 PLN5 blogging5 20% time4 21st Century Skills4 Autocrat4 Blooms Taxonomy4 COETAILS4 Connected Classrooms4 Essential Questions4 Feedback4 Flipped Assignments4 Gary Johnston4 Google Drawings4 Grading4 IPads4 Math4 Professional Development4 STEM4 Scientific Method4 Socrative4 Understanding4 Wallwisher4 Andrew Stillman3 Apps3 CIESE3 Compacting3 Creativity3 Curriculum3 Descriptive Feedback3 Diane Ravitch3 Diigo3 Engineering3 Entry Interview3 Exit Interview3 Facebook3 Flipped Classroom3 Genius Hour Projects3 Google Chrome3 Google Research3 Google Sketchup3 Infuse Learning3 Khan Academy3 Literacy3 MAP3 MAP Scores3 MOOCs3 Networking3 PBL3 Presentations3 Quizzes3 SAMR Model3 Student response3 Today's Meet3 Tom Schimmer3 UBD3 Video3 Visual Literacy3 coding3 flipped lessons3 gamification3 retesting3 20%Time2 AR2 Academic Literacy2 Acceptable Use2 Action Research2 Alfie Kohn2 Algebra2 Argumentative Literacies2 Augmented Reality2 Authentic Tasks2 Avatars2 Biology2 Blubbr2 Challenge by choice2 Chemistry2 Chrome Extensions2 Classroom blogs2 Content Curation2 Cooperative Learning2 Coursera2 Cyberbullying2 David Suarez2 Discussion2 Doceri2 Drones2 Edmodo2 Educreations2 Edutopia2 Evaluation2 Failure2 File management2 Filtering2 Fractus Learning2 Free Use2 G class folders2 GIF2 Geometry2 Google Classroom2 Google Sites2 Google presentation2 Homework2 Hour of Code2 IB2 Javascript2 Kaizena2 Learning2 Learning Journeys2 Legos2 Lori Uemura2 Math Stations2 Media2 Microblogging2 NXT2 NewsELA2 Notetaking2 Piracy2 Plagerism2 Portfolios2 Presentation2 Presentation Tools2 Problem Solving Skills2 Professional Learning Network2 Professional goals2 Query2 RIT Scores2 Reading2 Richard Poth2 Robert Appino2 Scaffolding2 Science Fair2 Science Skills2 Scott McLeod2 Screencastify2 Screencasts2 Service Learning2 Silk Slides2 Site Maestro2 SiteMaestro2 Snapguide2 Social Media2 Socrative Teacher2 Splitscreen2 Spreadsheets2 Standardized Tests2 Student Blogging2 Student Centered Learning2 Student Growth2 Summative Labs2 Superquiz2 TED Ed2 Technology2 Testing Out2 VideoNot.es2 Videopad2 Visible Thinking2 Voice Thread2 Voki2 Web 3.02 Xtranormal2 Zaption2 accurate assessment2 assessing homework2 brainstorming2 content2 copyright2 creative problem solving2 fair use2 inquiry2 instaGrok2 mindmapping2 rational numbers2 self-esteem problems2 technology integration2 test preparation2 #eduwin1 1:11 2.0 tools1 20 percent time1 21st Century1 3-2-11 AMISA1 APA1 Absolute Value1 Acheive the Core1 Adam Renfro1 Adam Sadowsky1 Adam Sandowsky1 Add Ons1 Additive Inverse1 Advisory1 Advocacy1 Agenda1 Air Server1 Alex Gunther1 Algebra Touch1 Algebraic Expressions1 Algebraic Phrases1 Allison Mollica1 Alternative Assessment1 Andrea Coffee1 Ann Coulter1 Annotations1 Annoucify1 Apply1 Argumentation1 Array Formula1 Assessment Blueprint1 Atlas Rubicon1 Audience Participation1 Aurasma1 Autograph Math1 Automation1 Awarenss1 Backchannel1 Balancing Equations1 Banksy1 Barrack Obama1 Barry Ritholtz1 Bias1 Bill Gates1 Blog Posts1 Blogger1 Blogs1 Bob Marzano1 Boomerang for Gmail1 Brainstorming Tools1 Bread Mold Experiment1 Brett MacRury1 Browsing1 Bullying1 CC1 CFG1 CK-121 CSI1 CUE1 Caine Monroy1 Calvin Harris1 Can the US improve it's education1 Challenges1 Charlie Mahoney1 Check for Understanding1 Chemio1 China1 Chris Liang Vergara1 Citation1 Class Dojo1 Classification1 Classroom Management1 Climate Change1 Code.org1 Collaborative Discussion1 Collaborative literacy1 Comment Trolls1 Commenting1 Comments1 Common Core1 Comparison Matrix1 Competence1 Conclusions1 Concordia International School1 Conditional Formatting1 Conferencing1 Connectedness1 Connecting1 Construction1 Content Amalgamation1 Continental Drift1 Control Group1 Cooking1 Cooperation1 Countif1 Crash Course1 Creator Studio1 Critical Friends Groups1 Cross-disciplinary work1 Current Events1 Curriculum Alignment1 Curriculum Design1 Curriculum Guides1 Dan Bowdoin1 Dan Taylor1 Daniel Kilback1 Daniel Pink1 Danielle Richert1 Darwinism1 Data Analysis1 Data Charts1 Data Validation1 Data import1 Day in the Life1 Decoding Words1 Deeper Understanding1 Demonstrating Mastery1 Design Thinking1 Didn't Read It1 Differentiated instruction1 Digestive System1 Digital Citizenry1 Digital Etiquette1 Digital Media1 Digital Stories1 Digital Story Telling1 Digital Technology Management1 Digital Tools1 Digital World1 Digital story1 Dividing Fractions1 Do Ink1 DocAppender1 Doctopus Add on1 Doctopus Differentiated1 Doctopus Project Groupings1 Dr. Derrick Gay1 Draft Back1 Dragon teaching Dragon parenting1 Drones in Education1 E readers1 ESL Students1 Easy Bib1 Edcanvas1 Edistorm1 Editing1 Edpuzzle1 Edtech1 Education1 Education Data1 Education Nation1 Education Reform1 Edumodo1 Edx1 Ego Casting1 Eli Pariser1 Email merge1 Engagement1 Equate1 Escape Room1 Evolution1 Ewan MacIntosh1 Experimental Group1 Experimentation1 Experiments1 Explain it to me1 Extensions1 Facing the Future1 Feedback. Student Learning1 Feedly1 Field Trips1 Fill Color1 Filter1 Final Cut1 Finances1 Financial literacy1 Finland1 Flight 241 Flipboard1 Flipped lectures1 Formmule1 Formulas1 Fossils1 Fox news1 Frayer Model Template1 Freeze1 Funding1 Furniture1 GCT1 GRASPS1 Game Based Learning1 Gapminder1 Garageband1 Garr Reynolds1 Garrison Keillor1 Gary Rubenstein1 Geeking Out1 Genius time1 Geography1 Giphy1 Gmail1 Gmail Sender Icon1 Google Apps for Educators1 Google Breakout EDU1 Google Cardboard1 Google Certified Teacher1 Google Chrome Apps1 Google Chrome Web Store1 Google Dictionary1 Google Education Summit1 Google Educator1 Google Expeditions1 Google Reader1 Google Slides1 Google Teacher Academy1 Google Timelapse1 Google Tour Builder1 Google Translate1 Google spreadsheet1 Google+1 Grade Configuration1 Grade Mean Referencing1 Gradebook1 Graphing1 Green Screen1 Greenscreen1 Haiku Deck1 Hangouts on Air1 Hank Moody1 Hatnote1 History1 Homework completion1 Hopscotch1 Horizon Report1 Hypothesis1 I Pads1 IEP1 ISTE1 Imovie1 Import Range1 Improving Standardized Test Scores1 Improving Test Scores1 Independent Study1 Infographics1 Innovative Literacy1 Inspiration1 Integers1 Integrated Unit1 International Baccalaureate1 International Boiling Point Project1 International School Teaching1 Internet Trolls1 Investments1 Ipad summit1 James Sanders1 Jay Atwood1 Jay Cargan1 Jeff Nesmith1 Jeff Utecht1 Jeff Zwiers1 Jesse Desjardin1 Joanne Jacobs1 Johnston1 Jungle Time1 Justin Bieber1 Kahoot1 Karin Morrison1 Ken O Conner1 Ken Robinson1 Kidpicker1 Kim Cofino1 Knowledge1 Laptops1 Learner Profiles1 Learning Communities1 Learning Portfolios1 Lego NXT1 Lexile Range1 Lexile Score1 Linda Darling Hammond1 LinkedIn1 Lisa Featherstone1 Lucidchart1 Lure of the Labrynth1 MAP Testing1 MLA1 Mac1 MacArthur Foundation1 Malcom Gladwell1 Mapping1 Marc Prensky1 Mark Church1 Mary Miller1 Mastery Learning1 Math Apps1 Math Games1 Math Motion Wings1 Math activities1 Math success1 Mathematics1 Mathematics Achievement1 Matthew Peterson1 Media Studies1 Merge Fields1 Middle School Life1 Milton Chen1 Mindstorms1 Minecraft1 Mishra Koehler1 Mitt Romney1 Mixed Ability Classrooms1 Mixed Media1 Morfo1 Motion1 Movie making1 Multimedia1 NGSS1 NWEA1 Named Ranges1 Negative Growth1 Next Generation Science Standards1 Next Generation Standards1 Nick Grantham1 Ning1 Nirvan Mullick1 Number Pieces Basic1 Number Rack1 Nutrition1 Oliver Trussell1 Online1 Online Content1 Online Privacy1 Online Universities.com1 Open Content1 Opposite1 Oral communications1 Oral presentation1 Organization1 Outliers1 Padlet1 Parent involvement1 Passion Projects1 Passion time1 Paul Barnwell1 Paul Tough1 Paula Ginto1 Pear Deck1 PearlTrees1 Pearson1 Peer Assessment1 Peer Review1 Performance Based Assessment1 Personalized Feedback1 Persuall1 Petcha Kutcha1 Photospheres1 Pinterest1 Pivot Table1 Plague Inc1 Plate Tectonics1 Podcasts1 Popplet1 Powerpoint1 Powerpoints1 Powerschool1 Practice Tests1 Present.me1 Presentation Skills1 Privacy1 Privacy Settings1 Problem Solving1 Procedures1 Programming1 Project Groupings1 Pythagorean Theorum1 QSI1 Quality content1 Quicktime1 Quiz1 Quizizz1 RIT1 RSS1 Rapportive1 Re-pet1 Readers1 Repet1 ReputationDefender1 ReputationHawk1 Resources1 Revision History1 Rich Tasks1 Rick Santorum1 Rihanna1 Robotics1 Ron Ritchhart1 Rosters1 Rube Goldberg Machines1 Rubric1 Rubrics1 SSIS1 STandardized Testing1 School Equity1 School Reform Initiative1 Schoology1 Science fairs1 Scratch Junior1 Screencasting1 Screenchomp1 Sean Thompson1 Search Associates1 See1 Seesaw1 Select and Speak1 Self assessment1 Self-grading quiz1 Shane Koyczan1 Sherry Turkle1 Sign Ups1 Silkslides1 Simon Woodhead1 Singpore1 Sites1 Skeptical Science1 Sliderocket1 Slideshare1 Slideshows1 Social Studies1 South Korea1 Speech1 SpicyNodes1 Splashtop1 Spreadsheet Formulas1 Standardization1 Statisitcs1 Steve Denning1 Steve Jobs1 Stop Highlighting1 Student Blogging1 Student Blogs1 Student Portfolios1 Student learning communities1 Study Guides1 Subscribing1 Subtracting Integers1 Super Quiz1 Surface Area1 Sustainability1 Swift Playground1 Swimming1 Syste1 Systems management1 Tags1 Tagxedo1 Taxonomic Keys1 Teacher Evaluation1 Teachers1 Teaching1 Teaching Meaning1 Tell a friend1 Testing1 Text Books1 Text Wrapping1 Textbooks1 The Amazing Race1 The Big Picture1 The Intelligent Channel1 The Kids Should See This1 The Teaching Channel1 The Text Project1 Think1 Think Pair Share1 To This Day1 Too Long1 Trello1 Tumblebooks1 Tweetdeck1 Tweetping1 Twenty Percent Time1 Tynker1 US Election1 Udacity1 VR1 VTC 20131 Valerie Strauss1 Vertical Alignment1 Vicki Davis1 Video Games1 Video Manager Descriptive Feedback1 Videoediting1 Virtual Manipulatives1 Virtual Reality1 Virtual World1 Visual Display1 Vocabulary Slam1 Voice Comments1 Voicethread1 Volume1 WIDA1 Watersheds1 Webcam1 Wesley Przybylski1 White Boards1 Wildlife Trade1 Wildlife at Risk1 Will Richardson1 Wonder1 Workflow Efficiency1 Worksheets1 Write About1 Writing1 Writing Assessment1 Yet Another Email Merge1 Zen Presentations1 Zin Obelisk1 Zone of proximal development1 advertising1 around the world1 best homework practices1 branding1 building your own brand1 buzz1 challenge by choicd1 circuitry1 code academy1 common assessments1 constructivism1 copyright infringement1 creativity in mathematics1 crowsourcing1 differentiation1 digital portfolios1 discussing1 electricity1 experiment1 flipped lesson debriefing1 flipped math homework1 gifted learners1 grading homework1 how to grade math homework1 importHTML1 innovation1 is dragon parenting better1 knowledge webs1 math help1 math reasoning1 math remediation1 math review1 money1 multiple choice testing.1 multiplication race smack down1 open ended questioning1 parental involvement1 parenting1 parenting styles1 pedagogy1 percent return1 percents1 plagiarism1 prior knowledge1 problem based learning1 problem solving strategies1 project management1 quality assessment1 readiness1 remediation1 research1 research tools1 reviewing1 should we fail students1 should we offer students a re-test1 shoulder buddies1 sorting1 spezify1 spreadsheet1 student blogging student blogging to support ISTE standards student blogging to support Common Core Blogging in Common Core1 student failure1 student skills1 students1 study habits1 teacher accountability1 tests1 time1 using homework1 videos1 visual maps1 volunteer service1 websearch1 welcome wagon1 what is the best assessment practice?1

Show more Show less

Archive

2022 3
- November 1
  - Rethinking Professional Development at Your School...
- March 2

2019 1
- March 1
2018 6
2017 13
2016 21
- December 2
- November 2
- October 1
- September 3
- August 3
- April 1
- March 3
- February 2
- January 4
2015 26
- December 2
- November 2
- October 3
- September 2
- August 4
- May 1
- April 4
- March 2
- February 1
- January 5
2014 38
- December 3
- November 3
- October 3
- September 4
- August 5
- June 2
- May 4
- April 4
- March 6
- February 2
- January 2
2013 87
- December 7
- November 5
- October 3
- September 9
- August 7
- July 2
- June 3
- May 10
- April 14
- March 7
- February 9
- January 11
2012 72
- December 4
- November 17
- October 14
- September 11
- August 8
- July 3
- June 4
- May 3
- April 2
- March 2
- February 4

Show more Show less

Licensing

This work is licensed under a Creative Commons Attribution-NonCommercial 3.0 Unported License.