Skip available courses

Available courses

Welcome to "Excelling with Microsoft Excel".  The syllabus with deadlines is found at the end of this message.

There are ten main topics and 15 specific lessons.  Each lesson has an assignment for you to complete.  Most assignments involve submission of work 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 yo 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 lease 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.

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: Introduction: All work for this topic is due by February 10, 11:59 p.m.

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

---Lesson 2: Basic Data Manipulation

Topic 2: Setting up a Simple Record Book for Routine Adminsitrative Tasks: All work for this topic is due by February 10, 11:59 p.m.

---Lesson 3: Basic Formulas

Topic 3: Creating and Working with Templates: All work for this topic is due by February 17, 11:59 p.m.

---Lesson 4: Using Templates for Greater Efficiency

Topic 4: Setting up a Gradebook in Excel: All work for this topic is due by February 24, 11:59 p.m.

---Lesson 5: Creating the Gradebook You Want

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

Topic 5: Practice with Simple Charts: All work for this topic is due by March 3, 11:59 p.m.

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

Topic 6: Everything You Ever Need to Understand Better about Pie Charts: All work for this topic is due by March 10, 11:59 p.m.

---Lesson 8: Pie Chart Creation and Formatting

Topic 7: Creating More Chart Types: All work for this topic is due by March 17, 11:59 p.m.

---Lesson 9: Advanced Charting and Chart Formatting

Topic 8: Advanced Functions and Formulas: All work for this topic is due by March 24, 11:59 p.m.

---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 9: Advanced Features: All work for this topic is due by April 4, 11:59 p.m.

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

---Lesson 14: Sharing Data Between Workbooks

Topic 10: Final Work: All work for this topic is due by April 4, 11:59 p.m.

---Lesson 15: Final Exam and Timesheet Submission

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

The Progressive Era (1890’s-1920) was a reform movement in the United States in response to the social, political and economic problems caused by industrialization. Unlike the farmers that made up the Populist party, progressive reformers were middle-class, professional, urban dwellers that believed government should abandon its laissez-faire policies and begin to protect the rights of the consumer. The following tasks are designed to provide you with an in-depth look at this time period and with activities you can incorporate into the classroom.