- Teacher: Julia Lang-Shapiro
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.
- Teacher: Stephen Wefer
- Teacher: Cecile Wren
Welcome to this course. You will be learning a lot of things you did not know about PowerPoint and definitely improve your skills in classroom presentations.
Each topic has one or more lessons and a forum. All work for each topic is due in the deadlines provided below.
---Lesson 1: Display Devices and When is PowerPoint Best Utilized
---Lesson 2: Creating a simple slide show with no bells and whistles
Topic 2: First Presentation from this Course which You Will Use.
---Lesson 3: Creating a slide show for "Welcome Back to School" Night
Topic 3: Making Presentations More Graphically Pleasing
Lesson 4: Adding image files: Photos and Other Graphics
Topic 4: Beginning Special Effects
---Lesson 5: Inserting Images into PowerPoint, Part II
---Lesson 6: More formatting and Beginning Special Effects
Topic 5: Running Slide Shows Manually and Automatically
---Lesson 7: Practicing Timing an Automatic Slide Show and Not Using Automatic Timing, as Needed
---Lesson 8: Custom Animation
Topic 6: Everything You Ever Need to Understand Charts
---Lesson 9: Assignment 9: Creating Charts
---Lesson 10: Assignment 10: Presentation for the Classroom Using a Chart
Topic 7: Creating More Chart Types and More Presentations
---Lesson 11: Another Presentation for the Classroom
Topic 8: Advanced Features
---Lesson 12: Another Classroom Presentation
Topic 9: More Advanced Features and Formatting
---Lesson 13: Formatting Charts and Electronic Chalk
---Lesson 14: Adding Sound, Creating Hyperlinks, and Saving for the Web
---Lesson 15: Adding Video, Creating Hyperlinks, and Saving for the Web
Topic 10: Final Work
---Final Exam and Timesheet Submission
- Teacher: Thomas Jeffery
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 firstname.lastname@example.org.
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 for "Excelling with Microsoft Excel"
Topic 1: Introduction: All work for this topic is due by July 7, 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
---Lesson 3: Basic Formulas
Topic 3: Creating and Working with Templates
---Lesson 4: Using Templates for Greater Efficiency
Topic 4: Setting up a Gradebook in Excel
---Lesson 5: Creating the Gradebook You Want
---Lesson 6: Formatting the Gradebook, and Accessing Statistical Results Quickly
Topic 5: Practice with Simple Charts
---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
---Lesson 8: Pie Chart Creation and Formatting
Topic 7: Creating More Chart Types
---Lesson 9: Advanced Charting and Chart Formatting
Topic 8: 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 9: Advanced Features
---Lesson 13: Mail Merging Between Word and Excel
---Lesson 14: Sharing Data Between Workbooks
Topic 10: Final Work
--Lesson 15: Submission of timesheet and course evaluation
- Teacher: Thomas Jeffery
- Teacher: Rachel Kench
- Teacher: Chris Visco
- Teacher: Anthony Auciello