Available courses

In this class, you will learn how to use several, simple 3D design programs (free and online). You will also learn all about 3D printers and how to print. You’ll have the option to order a print, if you choose. No prior computer experience is necessary. If you can turn on a computer, you can do this course. 


Students too often are required to sit, listen and reiterate in the classroom. Outside the classroom, socialization has decreased, as technology has increased. In today’s world, students need more than ever to learn socialization, cooperation and collaboration. Learn how to use the cooperative learning method to teach students how to help each other work together to reach a common goal.

This course will explore how integrating the arts between subjects (specifically Mathematics and Science Curriculum) would help teachers and students make connections between those subjects with use of higher analytical thinking, reasoning and ultimately student voice. The ideology that learning through Socratic-like/multidimensional lessons would lead to revelations and progress across the curriculum and help foster an individual who possesses the life skills needed for a more creative economy.

Does science get put on the back burner?  Do you feel like there is not enough time in the day to teach science with the Common Core curriculum for math and language arts?  Do you feel like you can’t motivate yourself to teach fun science lessons?  This class will help teachers to make science fun and interesting through incorporating literature and technology into your science curriculum.  Participants will explore articles, multimedia and Internet resources.

This course, taught by an authorized Google Education Trainer, will be focus on the integration of Google Classroom and Google+ Communities into the curriculum.  Participants will collaborate and complete assignments in Google Classroom, and will have the opportunity to set up their own online classrooms to experiment and learn how it works.  The newest features of Google Classroom will be highlighted.  In addition, the class will review how to create a Google+ community.  Teachers can use Google+ communities to collaborate with peers as well as a private forum where students can collaborate, display work, and comment.  Lastly, the class will analyze the following apps: Piktochart, Thinglink, Animoto, EduCanon, and Powtoon.  Reviews of the apps will be shared via Google Classroom and Google+ Communities.

The use of technology in education provides incredible opportunities to engage students in authentic learning, as well as collaborate with peers like never before.  This course, taught by an authorized Google Education Trainer, will cover fundamental knowledge and skills needed by teachers who wish to use the latest technology in the classroom.  This class will focus on Google Apps for Education, as well as many other Web 2.0 applications and websites useful for teachers and students alike.  The course will include hands-on development of websites and educational computer applications for use by teachers, administrators and students.  This course will better prepare educators to attain their Youtube Digital Citizenship certification, as well as help them prepare to attain their Google Educator certification.  

Have you ever wondered what a QR code was, or how you can transform your current lessons into self-teaching documents in the digital age? This online course will help you leverage your current lessons, notes worksheets, homework assignments into the hands of your students. Your students will be empowered to easily use their smartphones, tablets, and mobile devices
to bring your course material to life.

Welcome to "Excelling with Microsoft Excel" from July 25 to August 15, 2018.  The syllabus is found at the end of this message. Please note that whatever position you  may have in education or in business, this course will teach you a great deal about Excel, including the features people really need to learn.  The lessons using an Excel gradebook are helpful as most school management systems now allow for downloads into Excel and uploads from Excel into the gradebook school management system. This can be done smoothly, nut it cannot be done smoothly with Google Docs (Google Sheets) yet.  We will be also discussing some of the differences between Excel and Google Sheets.  So far, the students who have given me feedback about this have unanimously preferred Excel over Google Sheets.

There are ten main topics and 15 specific lessons  Most topics have two lessons (assignments).  Each lesson has an assignment for you to complete.  Think of "lesson" and "assignment" as the same thing.  Most assignments involve submission of work completed in Excel.  When Word is utilized as well, it is typically utilized for you to send feedback or answers through the Word document format.  In one of our lessons, Word is used in coordination with Excel to produce a multi-page document which brings data from Excel into Word. Therefore, you need to have Word and Excel, and since almost everyone who has Excel has a Microsoft Office suite that includes Word, this should present no issue. 

Please let me know through "messaging" which version of Excel you have.  This can be seen when the first screen displays as Excel is loading.  If you are not sure, let me know that as well, and I will help you figure it out.

The instructions are for all versions including very old versions that still exist in some schools.  I work painstakingly to try to have as much clarification as possible in the instructions, but please do not hesitate to send me a message if you are confused.  You could also e-mail me at scopeinstructor@optonline.net.

The first two lessons are posted under Topic 1.  Submission of the work is done through a submission tool found at the bottom of the lesson/assignment description.

Files needed for this course are e-mailed to you in the first week.  Hence, send me an e-mail in the first week of this course so that I ahve the correct e-mail address you would like to use for this course, when needed. Once I receive your e-mail, I will send you the files. Utilize them by name when the lesson in a specific topic asks for you to use that file by name.

I wish you the best throughout the course.

Syllabus:

Syllabus for "Excelling with Microsoft Excel"

Topic 1 Due June 29 : Introduction:

---Lesson 1: Navigating spreadsheets and Often-Used Terminology

---Lesson 2: Basic Data Manipulation

Topic 2 Due July 2: Setting up a Simple Record Book for Routine Adminsitrative Tasks

---Lesson 3: Basic Formulas

---Lesson 4: Using Templates for Greater Efficiency

Topic 3 Due July 9: Setting up a Gradebook in Excel

---Lesson 5: Creating the Gradebook You Want

---Lesson 6: Formatting the Gradebook, and Accessing Statistical Results Quickly

Topic 4 Due July 16: Practice with Simple Charts

---Lesson 7: Deciding on the Correect Charts for Your Data, and Creating Them

Topic 5 Due July 23: Everything You Ever Need to Understand Better about Pie Charts

---Lesson 8: Pie Chart Creation and Formatting

---Lesson 9: Advanced Charting and Chart Formatting

Topic 6 Due July 30: Advanced Functions and Formulas

---Lesson 10: Using Excel for Minutia, Including Rational Numbers

---Lesson 11: Advanced Charting

---Lesson 12: Explaining the Charts as a Teacher Would Need to Do

Topic 7 Due August 15: Advanced Features

---Lesson 13: Mail Merging Between Word and Excel

Topic 8 Due August 15: More Advanced Features

---Lesson 14: Sharing Data Between Workbooks

Topics 9,10 Due August 15: Final Work

--Lesson 15: Submission of timesheet, quiz, and course evaluation


This is an introductory course for SCOPE users on Moodle.  Moodle is a course management system.