XP and Spreadsheet Pacer: CPU Vlog 11-5

My class just finished up our 2nd unit and students are starting to have some clarification questions about the XP Grading System. I am going on year 5 and thankfully I have some answers! One of their biggest concerns is knowing their “grade”. I know that they mean their Final Average and the real answer is that they are still all around 30 or 40 on a 100 point scale. We have worked out a system for finding a rough pace but I wanted to make it a bit more simple for them to visualize – so I looked to MARIO KART!

In the 2nd half of the video I go through a simple spreadsheet that I have shared with students that allows them to plug in their current XP and compare it to a “PACER”. This should give them a decent idea of their overall Letter grade pace. In this screencast I also explain some of the formulas I am using including =image, =if, and =vlookup.

Links discussed in the VLOG

XP Grading Page

VLookup: Creating Battle Damage

More G.Sheets Magic: Nested IFs, and Random Numbers

More VLOOKUP Magic: A Half-Baked Random Generation G.Sheet Trick

The Magic of VLOOKUP: G.Sheets, Boss Fights, and Badges

1 Comment

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s