Category Archives: Open Source Education

11 Excel Tricks to Teach Your Students Today!

By Guest Blogger Minnia Feng, Microsoft minnia feng

Excel is one of the most useful tools out there, but some find it complex. Here are some simple tricks to help students excel at using this handy spreadsheet tool. If you don’t have Excel, find out if you and your students are eligible to download it free as part of the Office 365 Pro Plus Benefit— click here to see if you are eligible.

 

1. Never lose sight of row headers by freezing panes

hack1

 

Freezing Panes is one of the most useful tricks in Excel—with this you can always view your labels for different rows and columns, no matter how much you scroll.

  • If the pane you wish to freeze is the first row, simply go to View → Freeze Panes → select ‘Freeze Top Row.”
  • If it is not the top row, simply click on the cell below the pane you wish to freeze (if you want to freeze row 3 and up, select a cell in row 4), go to View → Freeze Panes → Freeze Panes.

 

2. Give your students the ability to keep track of their assessment through Self-Grade Computation

hack2

Simply click New, then search for “GPA Tracker” in templates —the GPA Tracker template allows students to input their own grades for different types of assignments in each class to get an idea of how they are doing. If your students are on tablets, here’s a tutorial on how to track GPA in Excel for iPad.

 

3. Move back and forth between spreadsheets quickly without clicking anything.

hack3

If you are working with multiple spreadsheets and need to move between them, press Ctrl+Tab to move back and forth between two spreadsheets, and Ctrl+Shift+Tab to move to the previous spreadsheet.

 

4. Use Flash Fill to make formatting tasks a breeze

hack4

Let’s say you have a row of numbers, for example “5554443333”, and you want to change the format to a phone number such as “(555) 444-3333.” Instead of manually typing it out, Flash Fill can do this for you automatically by detecting patterns in your formatting, and works best when your data has some consistency. Works as well with formatting names, dates, and postal codes.

 

5. Use Excel Survey to collect information directly into an organized spreadsheet

hack5a hack5b

Need to collect data from others and not have it be scattered when you receive it? Excel Survey (found in Excel Online) allows you to create a survey quickly and easily, then compiles the information in real time as it comes in. Great for group projects and surveys.

 

6. Move entire columns of data easily and quickly

hack6

Simply highlight the column you want to move and put your cursor over the border—it will change into a crossed arrow icon, allowing you to drag to move the column freely.

 

7. Select all with one click

hack7

Ever wonder what that little triangle is at the top left corner of your spreadsheet? You can click on it and quickly select all the cells with open simple click.

 

8. Ctrl + Arrow to move to different corners of the spreadsheet

hack8

Working with a particularly long and extensive set of data? No need to scroll—simply press “ctrl” + the arrow key in the direction you want to go. For example, “Ctrl+ →” will take you to the rightmost point of your data, and “ctrl+ ↓” will take you to the bottom line of the data.

 

9. Transpose Data in Rows to Data in Columns, and Vice Versa, with two clicks

hack9

Sometimes you realize the data you had displayed horizontally would make more sense displayed vertically. Instead of copying and pasting everything one by one, copy and paste all the data you’d like copied, then click Home→Paste→Transpose Icon, and the data will display in the new format.

 

10. Find out the average, count, and sum without any formulas or clicks

hack10

Did you know that if you select a set of numbers, the average, count, and sum automatically display without you doing anything? Excellent.

 

11. Combine two chart types by creating a combo chart and adding a second axis

hack11

What happens when you have two different types of data you want to show in a single chart? Excel makes it easy. Simply select the data you’d like for your chart, press the insert tab and click recommended charts, then click all charts tab and select the combo category. If the two sets of data have different scales, simply check the “secondary axis” box for the scale you’d like to add and click ok. Find out more in this in-depth tutorial.

World Leaders Discuss New Economy at NES 2015 Japan

nes banner

By Curriki CEO Kim Jones

Kim Jones

I just participated in the sold-out New Economy Summit (NES)  here in Tokyo. What a fantastic event! World renowned innovators who are leading the global economy gathered here and included Prime Minister Abe, CEOs from Lyft, Evernote, Houzz, Dropbox and Airbnb, as well as leaders from Kyoto University, U.S. Bureau of Economic and Business Affairs, Larry Ellison of Oracle, George Roberts of KKR, former U.S. Ambassador to Japan John Roos, and of course the host, CEO and Founder of Rakuten, Hiroshi Mikitani. Not to mention many entrepreneurs and the classical composer Yoshiki!

Earlier this week, we had a full house for the education panel I spoke on with nearly 2,000 people in attendance! The topic was Innovation in Educational Fields: The Change in School Education Scenes – What We Need Now and was moderated by Yuki Naito (President & CEO, Drecom Co., Ltd. / Executive Member, Japan Association of New Economy).

NES2015-3

NES 2015 Education Panel Speakers. (From top, clockwise: Kim Jones, Chairman and CEO, Curriki; Pille Parikas, Managing Director, eKool; Shihoko Urushi, Principal, Shinagawa Joshi Gakuin; Yuki Naito, President & CEO, Drecom Co., Ltd. / Executive Member, Japan Association of New Economy.)

 

I did a short TED-style presentation, and answered many excellent questions from both the moderator (who spoke Japanese with simultaneous translation) and the audience. The Japanese school, Shinagawa Joshi Gakuin, on our panel is quite interesting. As you may know, Japan is a very conservative country and has been traditionally slow to adopt new ways of doing things. But that is changing with the influence of companies like Rakuten and SoftBank, whose CEOs are the most successful and well-known entrepreneurs in Japan. Shinagawa Joshi Gakuin is an all-girls, private school that gives every student a tablet and the majority of work is done online. This prestigious private school is led by Principal Shihoko Urushi and is among several educational institutions at the forefront of reforming education and moving education into the digital world. Of course, any change will take time, but at least things are starting to move.

NES2015-2

There were two big takeaways for me from NES 2015. First, we are all part of a sharing economy. And secondly, Japan is becoming the new “hot spot” for entrepreneurs and start-up companies. The environment is quickly changing to make Japan much more welcoming and productive for starting new businesses! This is a big plus for our recently-launched Curriki Japan,  which offers free learning resources to students, teachers and educators. I encourage you to check it out.

CurrikiJapan2015

8 Ways OneNote Makes Lesson-Planning a Breeze

By Guest Blogger Minnia Feng, Microsoft minnia feng

OneNote, which you can download for free, is a teacher’s best friend. Find out how OneNote can help make digital lesson-planning easier, faster, and more effective!

  1. Use any type of content – text, pictures, audio, video, ink, embedded files, printed digital paper.

blog1There’s no limit to the mediums you can use to plan your lesson as OneNote supports learning and planning across multiple modalities, allowing you to add a fun, interactive multimedia dimension and create a more dynamic, effective lesson.

  1. Arrange any content type on the page any way you want, just like paper

blog2Drag and drop with ease—no more formatting hassles. OneNote is a digital version of paper, except it saves everything in one place, allows for more types of content, and no pencils or erasers required!

  1. Use Tags to highlight important points, questions, or create your own custom tag

blog3Instead of rifling through pages, whether paper or digital, find exactly what you need right away and remember what needs to be followed up on with tags.

  1. Collaborate with other teachers in a shared notebook as you build your lesson plans.

blog4Collaboration is a key priority nowadays and the sharing of ideas and experiences results in even better lesson plans– work with other teachers to improve and innovate easily!

  1. Use OneNote to record and embed audio to guide the lesson.

blog5Students learn in different ways — the option of adding audio can help increase focus and add an important personal element to the lesson so students have access to your audio instruction at any time.

  1. Use OneNote drawing tools to add visual elements to your lesson plan.

blog6Draw with touch or pen in OneNote to add your own sketches and diagrams — very helpful for science and math teachers who need to make annotations that may go beyond typing.

  1. Use digital ink to enhance, annotate and be creative with your lesson plans.

blog7Effortlessly make important aspects of your lesson plans stand out with digital ink, giving you the flexibility to write/draw anywhere on your notes or pictures.

  1. Change the digital paper type of OneNote to college-ruled, graph, or a custom page template background.

blog8Different subjects require different backdrops—we’ve got you covered so you can switch easily between and even customize the color and width of the lines/grids.

Want to see OneNote in action for more inspiration? Here are some awesome examples of lesson plans utilizing these tips from our Microsoft Innovative Educators:

  • Food For Life, by Ruby Huang (New Zealand), Science Teacher, Howick College
  • Count of Monte Cristo Mock Trial, by Kelli Etheredge (USA), Director of Teaching & Learning Resources, St. Paul’s Episcopal School
  • Walk in My Shoes, by Lynette Barker (Australia), Teacher Librarian, St. Therese’s Primary School

And for more in-depth interactive guides on how to make the most of OneNote in the classroom, be sure to check out http://www.onenoteforteachers.com.

10 Most Popular Curriki Learning Resources

By Janet Pinto, Chief Academic Officer, Curriki janetpic_preferred_cropped

We’re already a quarter into the new calendar year, so we’d like to kick it off with a collection of our most popular learning resources this school year. As always, these high quality resources are free to use, share and customize, so you definitely should take a look at! Counting down from number 10…

10) Tuck Everlasting Novel Study

This resource provides an excellent 25 day unit on the tucknovel Tuck Everlasting. With an emphasis on questioning, particularly question-answer relationships, the novel study materials guide students to develop critical thinking skills. All materials like question cards, game instructions, graphic organizers, rubrics, templates for character development, vocabulary development, etc., are included in this thorough, comprehensive, highly usable resource.

Tuck Everlasting Novel Study

9) Curriki Geometry Teacher View

mathA Collection of various lesson plans including: Selling Geometry, Designing a Winner, What is your angle, Pythagoras?, TED Talk: House of the Future, The Art of Triangles, How random is my life?

All of the lesson plans provide detailed instructions on how to run the lesson making it a great resource for teachers and instructors.

Curriki Geometry Teacher View

8) Differentiating Between Different Types of Conflict Collection

Lange-MigrantMother02This lesson is part of a larger unit on the Great Depression. In this unit, students will be focusing on determining importance; summarizing; making predictions; recognizing plot structure; and identifying flashbacks, foreshadowing and setting. Wherever possible, mini-lesson texts relate to American life in the 1930s, and all students will be reading literature circle novels set during this time period in American history.

In today’s lesson, students will practice differentiating between different kinds of conflict.

Inside, you will find a detailed lesson plan, a student worksheet, two overhead transparencies for use with the lesson, and exit slips to asses student mastery of today’s objective.

This resource is part of the Great Depression Unit collection.

Differentiating Between Different Types of Conflict Collection

7) Word Search Games & Other Fun English Language Activities

This web site is for people studying English as a Second Language (ESL) or English as a Foreign Language (EFL). There are grammar2quizzes, word games, word puzzles, proverbs, slang expressions, anagrams, a random-sentence generator and other computer assisted language learning activities.

Word Search Games & Other Fun English Language Activities

6) Oracle Academy Java Using Alice

This workshop engages students with little or no aliceprogramming experience to learn basic Java programming concepts. Participants use Carnegie Mellon’s Alice* platform to do something fun – create animated stories, movies and games.

Getting Started with Java Using Alice

5) Teaching Fractions Collection

fractionsThis highly-rated collection of resources includes videos and lessons for teaching fractions.

Teaching Fractions Collection

4) Free High School Science Texts Collection

This 154-page document contains Earth Science course curriculum for grades 9 – 10. The collection has been prepared from resources contributed by teachers and partner educational organizations on Curriki, an online community for creating and sharing open source curricula.

Free High School Science Texts Collection

3) Rob Lucas Developing Biology

biologyThis collection contains a wide variety of activities, labs, slide shows and worksheets on the topics of Cells, Cellular Transport, DNA, Photosynthesis & Respiration, Mitosis & Meiosis, Genetics, Evolution, and Classification. Much of the material is suitable for both middle school and high school students, although some of the pieces (such as the Photosynthesis PowerPoint presentation) have complex material better suited for more advanced biology classes.

Rob Lucas Developing Biology

2) Khan Academy Science – Physics

This collection contains about 100 videos, physicscovering all topics in a complete high school or college course in Physics. Many of the videos demonstrate solutions to sample problems. This is excellent primary material for long distance learning, or rich supplementary material for any physics course.

Khan Academy Science – Physics

1) Rob Lucas Grammar Collection

grammarAlways in our top 10 resources, this grammar collection is an extremely rich resource offering a complete unit on teaching grammar in a fun way. The content is correct, thorough and appropriate. Inclusion of a version of Mad Libs and a collaborative group project/presentation offers as much creativity for teaching grammar as possible. A humorous poem in worksheet form makes the lesson engaging and interesting. A scoring guide for the presentation makes the unit meaningful and understandable to students. The unit uses many various strategies to enhance the content.

Rob Lucas Grammar Collection

If you have a favorite Curriki resouce, please let us know. We’d love to hear from you

 

 

 

 

 

10 Time-Saving (and Free) Math Worksheets for Grades 6-8

wroksheet multiplying-decimals-worksheet-horizontal

By Janet Pinto, Chief Academic Officer, Curriki

As teachers, we never have enough time for everything we need to accomplish in janetpic_preferred_croppeda day, whether it be lesson planning or grading. Here’s a secret you can share with other teachers: Curriki offers more than 59,000 free, high quality resources that you can download, customize and share.

Why not take a short cut and try out a few of these classroom-tested math worksheets? Here are just a few of the many worksheets available for middle school math students.

(Similarly, you can use the Curriki Advanced Search feature to find games, videos, webquests, lesson plans and much more on any subject and any grade level.)

If you know a math teacher (or interested parent or student), please share this with them!

  1. Solve the questions about Probability Problems in this worksheet.
  2. Math worksheet on Supplementary Angles.
  3. Exponents Worksheet Generator – customizable and printable! math
  4. Multiplying Decimals Worksheet – customizable and printable!
  5. Pythagorean Theorem discovery worksheet.
  6. Worksheet on Factoring Quadratic equations and difference of squares.
  7. Use this worksheet for practice with Volume Formulas.
  8. This Characteristics of Quadratics worksheet gives practice problems for finding the vertex and the y-intercept of a quadratic function.
  9. Worksheet: Converting Fractions to Decimals to Percents help students remember how to convert a fraction into a decimal and then into a percent.
  10. Calculator Lesson Homework Worksheet. math-80x80

Do I HAVE to Read a Book?

A young boy sits sad and lonely

By Janet Pinto, Chief Academic Officer, Curriki

Why aren’t kids reading more today? Are they too busy with their electronic gadgets and games? National Reading Day (Friday, January 23) is an annual event which encourages reading by younger children and is celebrated in thousands of schools all around the United States.

Brenda St. John Brown, author of Swimming to Tokyo,  writes engaging stories that she hopes will inspire young adults to read! She recently wrote a great post with some practical tips and advice on getting reluctant readers to read. Definitely worth checking out!

Here are some ideas to encourage reading (we’ve included books for all age groups here):

  • Great book suggestions for all ages, interests, and genders from StorySnoops
StorySnoops allows you to search by age, gender and interests.

StorySnoops allows you to search by age, gender and interests.

Good Reads 2015

Good Reads 2015

So many books, so little time! If you have a book suggestion, please share it with our community.

Curriki’s Most Popular Teaching Resources in 2014

favorites

By Janet Pinto, Chief Academic Officer, Curriki janetpic_preferred_cropped

Here is a list of the most popular Curriki resources and collections in 2014. A few of these keep popping up on our top lists (timeless appeal), so it’s worth a quick read. (If you do, your job will be much easier and you’ll save hours on prep and research!)

Drum roll, please…

trophy

Most downloaded resource in 2014: The Art of Triangles TE and SE from Curriki Geometry

Most Popular collection: English 10 Full Course Contributed by Sarah Lornston

Hottest eTextbook: Mathematics etextbook by Free High School Science Texts

 

Top STEM Resources

Top STEM resource: Math Simulations Collection

Best Science Video Collection: AP Chemistry Video Collection

Top Computer Science Resource: Oracle Academy’s Getting Started with Java Using Alice

Special Collection Selection: One Million Lights Solar Energy Curriculum- High School

Most Interactive Resources for AHA Moments: The Concord Consortium Interactives

Top Science Resource: Open Source CA Textbook – Earth Science Grades 9-10

Top Mathematics Resource: Curriki Geometry Project Based Learning

 

Top English Language Arts and Social Sciences Resources

Top Social Studies Resource: High School American History Curated Collections

Top English Language Arts Game: Word Search Games and other Fun English Language Activities

Top Literature Study Unit: Tuck Everlasting Novel Study contributed by Holly Mercado and consistently ranked in our Top 10 resources!

 

TOP Health, Art and World Languages Resources

Top Health Resource: Fitness for Life contributed by Kathy Furka

Top Art resource: New Media for Social Commentary contributed by Adam Kenner

Top World Languages Resource: Spanish Verbs with Spelling Changes Worksheet

Bonus

Newest Collection: Our Lives, Our Words: Improving Student Writing through Digital Photography – First Grade Projects

This is a handy list that everyone can benefit from – teachers, students, parents, educators, or anyone who’s interested in learning. Please pass this on to your friends and colleagues.  Thank you!