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

MIT Collection: OpenCourseWare

janetpic_preferred_croppedBy Janet Pinto, Chief Academic Officer, Curriki

The MIT Collection on Curriki (available here) contains 49 relevant topics in Calculus, Physics, Chemistry and Biology. Most of the material is selected to support the College Board Advanced Placement Program offering college-level examinations to high school students.

The content has been selected from freshman-level courses at MIT specifically to support the needs of high school students interested in the Advanced Placement exams for Calculus, Physics and Biology. There are 21 calculus topics, 18 physics subject areas, 9 areas of biology and 1 chemistry lab section.

Examples of topics included are:

  • Calculus – Computation of Derivatives
  • Physics – Waves
  • Biology – Heredity

ocw_mast

“The idea is simple: to publish all of our course materials online and make them widely available to everyone.”
Dick K.P. Yue, Professor, MIT School of Engineering

MIT OpenCourseWare has been offered since 2002, and covers an extensive range of topics, primarily in science and engineering. These are free and open materials that span across the complete MIT curriculum. As of 2014, according to the MIT OpenCourseWare web site:

“2250 courses published

1 billion page views and 170 million visits.

100 courses have complete video lectures.

900 older versions of courses have been updated.”

Check out the MIT Collection at Curriki, particularly for your more advanced students. And for yourself and for your really advanced students, browse the MIT OpenCourseWare content!

Girls and Women in STEM in Asia: UNESCO Report

janetpic_preferred_croppedBy Janet Pinto, Chief Academic Officer, Curriki 

Curriki was very pleased to be in attendance on March 9th when UNESCO’s Asia and Pacific Regional Bureau for Education unveiled their report on girls and women in STEM fields, at the Bangkok Science Center for Education in Thailand.

Titled “A Complex Formula: Girls and Women in Science, Technology, Engineering and Mathematics in Asia”, the report examines the status of girls studying math, science and engineering subjects in primary, secondary, and post-secondary education, and the current state of employment for women in STEM fields. The report was based on in-depth country studies from Cambodia, Indonesia, Malaysia, Mongolia, Nepal, the Republic of Korea and Viet Nam, in conjunction with other statistics from the region. The full 122-page report is freely available here on the UNESCO Bangkok web site.

Key Findings 

AComplexFormula

The highest level message of the report is that “early and targeted intervention through education can greatly facilitate girls’ and women’s increased participation in STEM fields”.

While there are a number of interesting variations among the 7 countries studied, substantial consistency was found across a number of key findings.

  • Overall there is a shortage of talent on STEM fields in the Asia-Pacific region.
  • Globally, fewer than 30% of STEM researchers are women.
  • Gender differences in STEM topics become especially apparent around age 15, during secondary school education.
  • The gender gap at the secondary level correlates with under-representation of women in STEM during higher education and in the workforce.
  • Within the STEM fields, both in higher education and in the workforce, women tend to be found primarily in biology, chemistry and medicine.
  • Women are very lightly represented in physics, engineering and computer science/IT.
  • These latter fields are more math-intensive, and in school girls report more anxiety around, and lower interest levels in, mathematics.
  • There are fewer female teachers in STEM, implying fewer role models for girls.
  • Gender stereotypes are widespread in teaching and learning materials for STEM subjects.

Recommendations

A few of the recommendations from the report are:

“Teacher education and policies on recruitment must ensure a fair representation of both male and female teachers in all subjects, including mathematics and science, at all levels if education.

  • Teacher education… should be transformed to ensure that teachers are trained in gender-responsive teaching strategies.
  • Promoting more female role models in STEM, whether female teachers…female students and faculty members in higher education, and more broadly more women working in STEM fields, is an important strategy.

Curricula and learning materials should undergo further rigorous review from a gender perspective to ensure that they do not perpetuate gender stereotypes.”

Curriki is particularly interested in the last of these recommendations. We have tens of thousands of STEM materials at www.curriki.org, available for free, to support STEM education for girls and boys in Asia and around the world. We encourage you to upload STEM materials onto the Curriki web site, especially those that show equal participation of girls and boys in STEM learning roles, across the various disciplines, and that reflect both men and women as role models, equally. If you have such materials to upload, Curriki and our large, global educator and learner community will be most appreciative.

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

 

 

 

 

 

Open Source Textbook Study: Students Save Substantial Sums

janetpic_preferred

By Janet Pinto, Chief Academic Officer, Curriki

A study from Student PIRGS (Student Public Interest Research Groups) across the nation has found that college and university students could save over $1000 per year if all textbooks were provided open source materials.

The report is based on pilot programs at 5 different university campuses, and is available here. It notes that “According to the College Board, the average undergraduate student should budget between $1,200 and $1,300 for textbooks and supplies each year. That’s as much as 40% of tuition at a two-year community college and 13% at a four-year public institution.” The report notes that the college textbook market is artificial, since there is no direct consumer – producer link, as indicated in the figure below. A handful of academic publishers dominate the traditional textbook market.

Textbookmarket

Image from “Open Textbooks: The Billion Dollar Solution”, Ethan Senack, The Student PIRGS, February 2015

Open textbooks are high quality, faculty-written and peer-reviewed materials. They are available online and for electronic distribution in .pdf or other formats. The cost to students for open source materials is minimal.

The findings are based on 21,697 students enrolled in OER courses at Kansas State University, the University of Maryland, the University of Massachusetts (Amherst), the University of Minnesota, and Tacoma Community College. The aggregate results indicate that students could save on average about $128 per course. Extrapolated to an academic year this is over $1000 per student per year. If all the 11 million full-time undergraduates in the U.S. were using only open textbooks, the aggregate savings would be well over $1 billion per year.

As the growth of open textbooks spreads at the university level, we at Curriki expect increasing activity in the K-12 space as well. State and local authorities could save substantial amounts from their education budgets by moving to open textbooks. Curriki is a repository for a wide variety of open source educational materials, including full courses and textbooks. We’d like to call your attention to several high school level mathematics courses:

Curriki Algebra 1 – http://www.curriki.org/xwiki/bin/view/Coll_kathyduhl/Algebra1?bc=&viewer=info

Curriki Geometry – http://www.currikigeometry.org

Curriki Calculus – http://www.curriki.org/xwiki/bin/view/Coll_Group_CurrikiCalculusCollection/CurrikiCalculusIntegralCalculus?bc=&viewer=info

There are also many full textbook resources on Curriki. A search for high school math level textbooks alone reveals over 200 resources. We encourage you to search at Curriki for core or supplementary textbook resources that you can use in your classroom!