LA Comp Learning Log

View image | gettyimages.com

Our LA Comp class is keeping a weekly learning log this semester, and I'm sharing my learning here. The big categories we are focusing on are Knowledge, Skills/Strategies, and Habits/Attitudes.

I have been learning about spreadsheets, most recently about IMPORTRANGE. It is a formula that allows information to be imported from one source into another. For example, in my case, I have a spreadsheet that I use as a grade book. It contains a separate sheet or tab for each student in class. I would like students to see this grade book, but if I share the spreadsheet with Student A, then Student A can see the entire spreadsheet, including every other student's grades.

IMPORTRANGE allows me to create a new spreadsheet for Student A and then import only the assignments and grades for Student A from my grade book spreadsheet into Student A's personal spreadsheet. The best part is that once the formula is set up, any changes I make in my grade book are automatically updated in Student A's personal spreadsheet. Cool, huh!

If you're interested in the details, leave a comment and I'll send you a link to get you started.