Lower Elementary3 more
Cross-Curricular1 more

Essential Spreadsheet Skills

A spreadsheet is a tool that is used to organize large amounts of data. Practical applications of spreadsheets for teaching include: recording and calculating grades, turning student data into graphs, and finding the mean, mode, and median of classroom assessments. This collection will present some of the spreadsheet skills that are important for teachers to have.
G
Micro-credentials Available
View aligned micro-credentials
A Collection By Jeffrey Sack
  • 8 Collection Items
  • 8 Collection Items
  • Discussion
Essential Spreadsheet Skills
  • Jeffrey Sack says:
    Once you have mastered the basics, it is time to move into more advanced spreadsheet topics. This listing gives a great review of some of the more complicated things Microsoft Excel can do (transferable to other applications). I think this would be a great follow up for teachers who want to know more about using spreadsheets in their classrooms.
  • Jeffrey Sack says:
    Excel is probably one of the most common spreadsheet applications a teacher will encounter (Google spreadsheets being another). This video tutorial provides great advice for the beginner and the advanced spreadsheet user. While it focuses on Excel, the skills presented can be transferred to other applications. I highly recommend all spreadsheet users watch this video.
  • Jeffrey Sack says:
    If you are more of a visual learner, then this video is for you. The speaker explains basic spreadsheet terminology and how to enter and manipulate data. I would suggest that teachers view this video to get a basic idea of what a spreadsheet can do.
  • Jeffrey Sack says:
    This collection of Excel tests will evaluate every skill possible one can attain with the software. I like how comprehensive it is, but wish it were a bit more up to date (all these tests assess an older version of Excel). I highly recommend taking one or more of these to see what the gaps in your knowledge are.
  • Jeffrey Sack says:
    Once you have learned the basics of using a spreadsheet it is a good idea to test your knowledge. This free online test does just that. While it is based on an older version of the Excel software, the skills it assesses are still applicable today. I recommend everyone take this test to see how much they know (I got a few wrong).
  • ubershare.wikispaces.com
    ubershare.wikispaces.com

    Essential Spreadsheet Skills

    60 minute read
    Jeffrey Sack says:
    When using spreadsheets, there are several things that all users should know how to do. This handout not only provides a listing of these skills, but also gives directions as to how to complete them. It is a tutorial. I really like this set of activities. I think it does a really good job of getting "hands on" and should be read by all teachers.
  • Jeffrey Sack says:
    Microsoft Excel is probably the most common spreadsheet application to which teachers will come in contact. This listing outlines the top ten things users of this software should know how to do. I agree with what this article has to say. I think all of the skills presented are essential for teachers to know how to do.
  • Jeffrey Sack says:
    Preparing students for the future is one of the roles of a teacher. Using spreadsheets is something that many students probably do not do regularly. Therefore, they need to learn some basic skills in order to be successful. As the teacher, you should be sure to have mastered these skills prior to trying to teach them to students. Being proficient yourself will only help you in the long run.
Raquel ElizondoMiddle School Math
Raquel Asks:I'm having problems on the "if" statements on Task 8 of the Microcredential section. I understand the basic "if" function, but I don't understand what the "true / false" options are on the possible points earned since the points are given.
Micro-credentials aligned to this collection