Week 12 Teaching Tips

Hello Faculty,

Welcome to to week 11.  Fall textbook orders are due April 15, so this week we will continue to explore ways to save our students money on textbooks and why this is important.  Also, remember to submit your summer and fall software requests with your textbook submissions.

How can I decrease the cost of the textbook I am currently using?  

There are pros and cons to each of the options listed below, and Dawn Master in the Bookstore can help you work through what is best for you.  See Textbook Options for more information on each of these topics (these were handouts from the 2/27 all-college open houses).  Also, see the 3/30 email from Lauren Potempa-Giamarese about important information about summer books.

  • Allow students to use older editions of your book.  If you are providing page numbers to your students then the next time there is a new edition, keep the old page numbers and add the new page numbers.
  • Adopt your textbook for the long haul so that more used copies can purchased (for example, let Dawn Master know that you intend to use your current book until the next edition comes out)
  • Order a custom book if you are not using the whole book, or if you want to combine more than one book
  • Order a loose-leaf book
  • Order an eBook
  • Discuss whether bundling is the best option for your book
  • Consider making your book optional or recommended
  • Create a course packet
  • Think about your course learning outcomes – what is the best way to provide content to help students develop the skills in your outcomes
  • See the Week 9 Teaching Tips for free textbook options and ideas

How can print individual grade reports from my Excel grade book?  (Thanks to Yolanda Williams for sharing this tip!)

For students who shy away from the D2L gradebook, or can’t seem to understand it, this works really well. I found and would like to share a great macro that does just that. This macro when run through excel will print out individual reports by name from your excel gradebook. This can then be handed out in class or attached to an assignment. It provides students with an update on which assignments have been graded and are logged in; as well as in point grading how many points they have compared to the total. Just thought I’d share.

Sub PrintGradesbyName()
Dim LastRow As Long
Dim i As Long

LastRow = Cells(Rows.Count, 1).End(xlUp).Row

With ActiveSheet
.PageSetup.PrintTitleRows = “$1:$1”
For i = 2 To LastRow
.Rows(i).PrintOut Copies:=1, Collate:=True
Next i
End With

End Sub

Advertisements
This entry was posted in Teaching & Learning Tips. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s