Tag Archives: Curriki

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

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

Increasing Student Engagement in the History Classroom

history

By Curriki Guest Blogger Amy Scheuer

Amy Scheuer, Social Studies Content Curator, Curriki

Amy Scheuer, Social Studies Content Curator, Curriki

Teachers are often faced with the challenge of making teaching and learning history more engaging. Here are some techniques to increase engagement in the history classroom, paired with resource suggestions from a newly curated American History collection on Curriki that is comprised of materials spanning from colonial America to the modern era!

1. Treat history as the opportunity to tell a greater story and convey a narrative, rather than the relaying of disjointed names, dates, and events. The use of media can be a great mechanism for accomplishing this goal, and the CrashCourse video collection provides an entertaining and educational method of exploring major topics in history. The videos sequentially focus on issues, events, or developments, considering causes, effects, and key players in relation to the greater American History narrative.

2. Allow students to become a part of the historical narrative by carrying out simulations, role-playing activities, and enacting historically accurate discussions or debates. The EDSITEment collection includes extremely detailed American History lessons, ranging from the colonial period to modern America.   Every lesson has a unique makeup, possibly including activities, primary source analysis, simulations, and discussion/debate topics, providing endless opportunities for students to jump into an historical time period for in depth exploration.

3. Utilize art and imagery to appeal to visual learners in your classroom and provide students with a snapshot of the past. The National Archives provides an excellent place for teachers to search for primary sources. Teachers can access thousands of images, photos, speeches, letters, and other primary sources, and can then build interactive activities while learning how to best utilize historical documents in the classroom!

4. Incorporate music to help students understand the cultural context of a certain time period. Throughout history, many musicians have composed songs that reflect conflicts, changing attitudes, or cultural developments around the world, and students can engage in historical analysis by listening to these songs and interpreting the lyrics. This comprehensive list of songs at Curriki can be used as a great guide for incorporating music into the classroom.

5. Differentiate instruction between teacher-facing, student-facing, group, and individual activities. The Digital History collection is a gold mine for teachers, as it allows one to search by era, topic, resource, or reference, with the ability to make use of the full textbook, online exhibitions, learning modules, and primary sources. Digital History is a great tool to aid teachers in planning creative lessons such as jigsaws, problem-based learning projects, webquests, visual or audio activities, or engaging lectures.

6. Leave ample time in the curriculum to delve into modern topics, allowing students to contemplate the varying and continually changing perspectives surrounding political, economic, religious, and cultural trends and occurrences of the era. This content is often particularly relevant and interesting to students, and can be a great opportunity for oral history or experiential projects, as students are able to ask parents, grandparents, and community members about their experiences living through a particular event or time period. The United States History: 1945 – Present curriculum guide provides a great outline of important topics of the last half-century in American History, and is segmented into units by decade, each with sample lessons.

For more lessons and supplemental materials be sure to visit Curriki and explore an entire collection of 11 American History units here!

Amy is a graduate of Vanderbilt’s Peabody School of Education and taught History and Psychology at the high school level before joining up with Curriki to promote educational access at the global level.

 

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!