How to Keep a Timecard in Excel

One of the most popular applications of math is through spreadsheets (like Excel) that make those numbers relevant to everyday life. We’re going to provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

1. #74: Mastering Excel (for Beginners)
2. #71: Beginning Graphs in MS Excel
3. #70: Create a Timecard in Excel for Grade Two and Up
4. #73: How to Graph in Excel
5. #12: Create Simple Shapes in Excel
6. #75: Tessellations in Excel
7. #72: How to Check Your Math in Excel
8. How to Use Excel to Teach Math Arrays
9. #62: Email from Word (Or PowerPoint or Excel)
10. #79: Excel Turns Data Into Information

Today:

This project (#70 in the collection of #110) hides a spreadsheet’s power behind a template you create and students fill out at home. If they’re older and more familiar with spreadsheets, involve them in creating the template. If the lesson plans are blurry, click on them for a full size alternative.

Note: The example uses Excel, but it works just as well with Google Spreadsheets.

–from 55 Technology Projects for the Digital Classroom

–there may be an update at the link above, but it will require purchase of the book

Copyright © 2023 AskaTechTeacher.com – All rights reserved.

Here’s the sign-up link if the image above doesn’t work:

http://eepurl.com/chNlYb

Jacqui Murray has been teaching K-18 technology for 30 years. She is the editor/author of over a hundred tech ed resources including a K-12 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, Master Teacher, webmaster for four blogs, an Amazon Vine Voice, CSTA presentation reviewer, freelance journalist on tech ed topics, and author of the tech thrillers, To Hunt a Sub and Twenty-four Days. You can find her resources at Structured Learning.