Microsoft Excel – Fundamentals

Course Syllabus and Lesson Planner

Course Info: Download PDF  

This course is written for grade levels 6-12. This course will introduce you to Microsoft Excel and show you some of the tools you have available. There will be videos where you follow along with the insturctor and then there will be quizzes to test the skills you have learned


In this course there are 5 modules that cover everything including: basic navigation, shortcuts, simple formulas, charts/graphs, and printing.

  • Module 1 covers the Basics
  • Module 2 covers Shortcuts
  • Module 3 covers Formulas
  • Module 4 covers Charts and Graphs
  • Module 5 covers Printing

Course Length:   

As an elective course, we recommend one or two modules / week. Therefore, we feel that this course should take approximately 5 weeks to complete all modules/quizzes, and leave time to study, and take, the final exam. (See Lesson Plan below)

Course Prerequisites (if applicable):


Course Requirements:    

    Computer– Students must have access to a computer with internet access and an internet browser.  Simply STEM has been successfully tested using Internet Explorer, Firefox, Chrome, and Safari.  In addition, we have tested many versions of smart phone/tablet browsers as well.

    Internet Access – Although results may vary, based on connection type and speeds, we have tested our online videos on DSL, Satellite, Cable, and cellular connections.  Our courses cannot be download and require internet access to view them.

Course Grading:  

Grading will be based on quizzes, project uploads, and teacher requirements.

Lesson Plan:
Module 1 – The Basics Week 1
Module 1 – Quiz   Week 1
Module 2 – Shortcuts   Week 2
Module 2 – Quiz   Week 2
Module 3 – Formulas   Week 3
Module 3 – Quiz   Week 3
Module 4 – Charts and Graphs   Week 4
Module 4 – Quiz   Week 5
Module 5 – Using Magic in Tux   Week 5
Module 5 – Printing   Week 5
Study for Final Exam   Week 6
Final Exam Week 6