 |
|
|
The ExpertRating Online Teaching Course (Microsoft Excel 2003)
(leading to ExpertRating Teaching
Certification-Microsoft Excel 2003).
Taught by a
10-year veteran of both the classroom and the school computer lab,
Microsoft Excel 2003 in the Classroom is a unique online workshop
packed full of tips, shortcuts, and lesson plan ideas just for
teachers who want to bring the power of Excel into their classrooms,
both as an organizational tool and as a teaching aid.
You'll learn all
the important Excel basics: Using the toolbars, formatting cells and
worksheets, inserting formulas for addition, subtraction,
multiplication, and division, and creating colorful charts and
graphs. Then you'll move on to some more advanced Excel features:
Sorting and analyzing student test data, writing powerful
mathematical formulas, and using the Function Wizard to
automatically calculate student averages and other statistics.
You'll finish up the course by creating a fully customizable grade
book that you use in your own classroom.
Throughout the course, you'll explore standards-based lesson plans
and activities that will allow you to pass your Excel knowledge on
to your students, no matter what grade level you teach. By the end
of this course, you'll have a solid understanding of the basic
functions of Excel, and a wealth of ideas for integrating this
powerful technology into your lesson plans across your curriculum.
This course includes a knowledgeable and
caring instructor who will guide you through your lessons,
facilitate discussions, and answer your questions. The instructor
for this course will be Robin Sellers.
Robin Sellers
 About
the
ExpertRating Online Teaching Course (Microsoft Excel 2003) instructor :
Robin Sellers holds a current teaching license. She has a Master
of Arts degree in English with a concentration in technical and
professional communication and a Bachelor of Arts degree in English
with a certification in secondary education. Since 1995, she has
taught at the secondary and post-secondary level. She encourages
creativity in her classroom, teaches traditional curriculum classes
in a computer lab, and incorporates technology including the
Internet in her lessons. She also develops and teaches online
curriculum courses. In 2003, she began teaching continuing education
courses for teachers.
Teaching Microsoft Excel 2003 in the Classroom Course requirements:
For taking this instructor led ExpertRating Online Teaching Course (Microsoft Excel 2003) you need
Microsoft Windows XP or 2000,
Microsoft Excel 2003 or Microsoft Office 2003 (Student
and Teacher Edition
Standard Edition,
Small Business Edition, or
Professional Edition are all acceptable - please be sure
to install the software on your computer before the course begins),
Internet access, e-mail, and the Microsoft Internet Explorer or
Mozilla Firefox Web browser. This course is not suitable for
Macintosh users, nor for users of any of the 2007 versions of
Microsoft Excel. Testimonials:
The ExpertRating Online Teaching Course (Microsoft Excel 2003) has received overwhelming positive
feedback and reviews from students around the world. Here are a few:
 "Although
I have some Excel knowledge, I found this course extremely useful. You taught me
many tricks and shortcuts that will make it much easier to use Excel to lighten
my load. I passed along our lesson plan examples to our technology teacher, and
she thought they were great. I will happily recommend this course to all of my
colleagues!"
"I
found this class to be extremely helpful. I use Excel on a daily basis, but I
learned about many options that I didn't know about before. I am looking forward
to putting many of them to good use."
"I
really enjoyed Robin's approach to the course. She mixed humor with information
and was always very positive in the discussion areas!"
"I
so much enjoyed this class and know it will help me in my classroom. Your
lessons were so enlightening and your explanations easy to follow. Thank you for
making this format possible for people who prefer online to driving to a
campus."
"I
taught school for over 30 years. This is an update for me to renew my
certification. I have taken many courses in my lifetime, but the ones created by
this instructor are the best I have ever taken, and I have a certification in
computer data processing and a master’s degree in this area. Robin Sellers is an
excellent instructor and far surpasses anyone I have learned under, and I want
to praise you, Robin. Thanks, I have taken your other courses, and I will always
look for your courses."
"It's
been a fantastic class, the best I have taken in many years. I learned so many
techniques I can actually use now. You have been the most responsive on-line
instructor I've had the pleasure to work with, and I appreciate it."
"Robin
did an awesome job conveying the content and making it easy to follow and
applicable to a range of uses in the classroom and in my professional life."
"Robin,
it has been a pleasure and also very rewarding taking this class with you. You
have a real passion for teaching and have demonstrated how organized,
resourceful and committed you are to educating others. I will refer back to all
of the materials you have included in your lesson plans as a wonderful guide for
continuous learning and look forward to taking another class with you in the
near future. Thank you again for sharing your knowledge with others."
"The
instructor for this course was outstanding. Having been away from the classroom
for 12 years, and not having computers in the classroom when I was in school, I
was nervous about taking this course. I was so wrong. I learned so much needed
information. It was amazing! Thank you for being so specific and organized."
"This
is a great course that I would recommend to others. The instructor is wonderful
and I've learned a lot!! Thanks"
"This
is the first online course that I have taken and have come away very impressed.
Robin is a very good instructor and from a scale of 1 to 10, I give Robin a 10.
I am looking forward to taking another class with her."
"This
was one of the best computer classes I've ever taken and I've taken a lot of
them. I look forward to taking other classes from Robin."
|
|
|
|
|
|
ExpertRating Online Teaching Course (Microsoft Excel 2003)
(leading to
ExpertRating Teaching Certification)
 ExpertRating
is one of the world's only ISO 9001:2008 Certified companies (from
TUV America) offering an Online Teaching (Microsoft Excel 2003) Course (leading to ExpertRating Teaching (Microsoft Excel 2003) Skills Certification).
ExpertRating is a trusted name in online testing and certification
with over 200,000 certified professionals in over 60 countries in
more than 200 skill areas. ExpertRating offers its testing services
to the world's best companies such as Convergys Corp, UPS, GAP,
Sony, Coke, Citrix, Deltek Corp, IKEA Systems and Ericsson to name a
few. See
where ExpertRating Certified Professionals are working.
It is very safe to buy from
ExpertRating. Apart from being an ISO 9001:2008 certified company, it is a member of the TRUSTe and HackerSafe approved.
ExpertRating Solutions has been reviewed by TRUSTe for compliance of their strict program requirements ensuring that your information is always safe.
ExpertRating has certified Several thousand individuals who are working with leading companies across the US and
other countries.
View list.
When you choose the
ExpertRating Online Teaching Course (Microsoft Excel 2003) you can be sure that you are buying a
premium International certification that is recognized by hundreds
of employers and Government bodies in the US and other countries.  With ExpertRating you get certified
quickly online and you are equipped with a store house of
information through the in-depth ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware which has
been developed by experienced Soft Skills Experts.
The ExpertRating Teaching Certification is by far the best value for money instructor led
Teaching Microsoft 2003 Excel Skills Program at $129.99.
Some Popular questions and answers about
this ExpertRating Online Teaching Course (Microsoft Excel 2003) and Certification:
How much does the
Teaching Certification cost and what does it include?
You can buy this ExpertRating Online Teaching Course (Microsoft Excel 2003)
leading to
Teaching certification at a special offer price of only $129.99 which
includes the in-depth ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware and exam fee. This is
the best value for money Teaching Program available till date. You
get the following services within the USD $129.99 fee.
In-depth ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware including scenarios and case studies.
An instructor to guide you through the
course and to whom you can direct your questions.
World wide airmail delivery of the hard
copy Teaching Certificate. The Teaching Certificate can be used
to prove your certified status and does not mention the words
"online".
An online transcript that can be used to
prove your certified credentials on the internet at any time.
How do I get certified?
The process of getting yourself certified is very simple. All you have to do is buy the
ExpertRating Online Teaching Course (Microsoft Excel 2003) for $129.99. Log in to the instructor led course using your password. Go through the
ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware (which would take you 6 weeks) and complete the final
Teaching Certification exam at your convenience. You can complete the exam within 2 months of buying the
Teaching Certification. The result of the exam appears as soon as it is completed, and your
Teaching Certificate is mailed immediately.
What learning aids will I get?
The
ExpertRating Online Teaching Course (Microsoft Excel 2003) includes the following learning aids:
24 x 7 hour access to the courseware. A printer friendly version of the
ExpertRating Online Teaching Course (Microsoft Excel 2003) is also provided
A friendly instructor to answer your questions online
A discussion area to have your questions answered
Chapter end quizzes to ensure that you are learning important aspects of every chapter
Chapter assignments to help you practically use the
Teaching that you will learn during the Teaching Course.
What is the final exam like?
The final exam is fully based upon the
ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware that is provided along with the
Teaching Certification. If you have gone through the courseware properly you should not have a problem clearing the exam. The exam consists of multiple choice questions from all chapters of the
ExpertRating Online Teaching Course (Microsoft Excel 2003) Courseware.
What are the course start dates?
ExpertRating instructor led courses commence
every month, you can always choose a suitable date for your course
commencement in any month. To see available course start dates,
please click on the "Enroll now" button.
All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when the lesson is released, but you must complete each lesson within two weeks of its release.
A new section of each course starts on the second or third Wednesday of each month. If enrolling in a series of two or more courses please be sure to space the start date for each course at least two months apart.
|
|
|
|
|
|
Microsoft
Excel helps you customize charts, helps to test values and automate
actions based on those results.
Microsoft Excel
is an electronic spreadsheet which can be used to arrange data in
rows and columns. Microsoft Excel includes features to use advanced
filters, data validation and security features such as protection,
digital signatures and passwords. This application helps to speed up
the process of analysis of data using single or multiple variations
or conditions.
Anyone who can use formulas and charts
with ease will be comfortable with Microsoft Excel as well. This
application is popular with accountants as it helps them to report,
sort and summarize data independent of the original data layout. The
ExpertRating Microsoft Excel in the Classroom Certification will
make you adept with this application by making you understand its
nuances and making you confident to use this tool.
ExpertRating Online Teaching Course (Microsoft Excel 2003)
Coverage (6 weeks program)
Week One |
Wednesday - Lesson 01 |
|
The first lesson
will start off by going over some of the terms
most commonly used in Excel, and then it will
take a tour through the various features of an
Excel workbook to get you acquainted with the
look and feel of the application. You'll learn
easy ways to move your cell pointer around
within the Excel workspace, as well as a few
keyboard shortcuts that will help you move to
where the action is a little more quickly. At
the end of this first lesson, you'll get to try
your hand at creating your first Excel formula.
|
|
|
Friday - Lesson 02 |
|
In this lesson,
you're going to create your first worksheet!
This lesson will start by going over the five
steps you'll need to follow to create a
worksheet in Excel: Stating your objective,
adding labels, adding numbers, adding formulas,
and changing the overall look of the worksheet
using pre-designed templates. This lesson will
also begin its ongoing discussion about ways you
can use Excel in your classroom to improve
student learning across your curriculum. |
|
|
Week Two |
Wednesday - Lesson 03 |
|
In this lesson
you'll learn some valuable techniques that will
help you save a lot of time while using Excel.
The first and the best technique is called Auto
Fill, and will be of a great use to you! Excel's
Auto Fill allows you to enter a series of
numbers, dates, or other values into your
worksheets as quickly as you can click and drag
your mouse. You'll practice using it to enter
some of Excel's standard lists (months of the
year, days of the week), and then this lesson
will go over how to create custom Auto Fill
lists to help you enter text that you need to
enter often—like the names of your students.
After that, this lesson will go over some of
Excel's advanced formatting options to make your
numbers appear as currency, percents, or carried
out to various decimal places. |
|
|
Friday - Lesson 04 |
|
A picture is
worth a thousand words! And when it comes to
worksheets full of complex data calculations,
that old saying is even more true. In this
lesson, you'll learn how to use Excel's handy
Chart Wizard to display the data you've entered
in colorful charts that give meaning to your
numbers. After taking a look at a few of Excel's
many chart styles, you'll practice adding
defining information to your charts, such as
titles, data labels, and legends. Then this
lesson will go over how to customize the colors
of your chart. This lesson will finish with a
discussion on the many ways you can use charting
and graphing tools across your curriculum.
|
|
|
Week Three |
Wednesday - Lesson 05- |
|
In this lesson,
continuing the two-part discussion on Excel's
Chart Wizard, you'll go over advanced charting
techniques. You'll learn how to use the wizard
to change chart types, add text, add shapes, and
even add your own pictures to your charts. Then
this lesson will take a tour of the Drawing
toolbar, where you'll find the tools you need to
add lines, arrows, and other helpful graphic
features to your charts. And, as with most
lessons in this course, this lesson will give
you more lesson plan ideas that you can use to
bring these Excel techniques into your own
classroom. |
|
|
Friday - Lesson 06 |
|
In this lesson,
you'll find out how to turn any old worksheet
into a database. Because once you're working
with a database, you'll gain access to one of
Excel's most helpful features: The Data menu.
Through this menu, you'll be able to easily
locate, organize, and summarize the information
you need. You'll practice using it with a sample
database, and then this lesson will explore
Excel's AutoFilter, AutoSum, and Sort features.
With these tools, you'll be able to quickly sort
and group your students for differentiated
instruction. |
|
|
Week Four |
Wednesday - Lesson 07 |
|
In this lesson
you're going to take a break from the
step-by-step Excel instruction to visualize how
it will look when you begin using this valuable
program in your own classroom, no matter what
grade level you teach. This lesson is going to
review three teacher-created lesson plans for
grades 1-4, 5-8, and 9-12 and then it will talk
about ways you can adjust these lesson plans for
different age groups, different content areas,
and different learning styles and needs. |
|
|
Friday - Lesson 08 |
|
In this lesson,
you'll learn about the three different types of
cell references that you can incorporate into a
formula, and this lesson will explain when you
should use each one. This is great information
if you plan to use Excel to help you maintain a
budget for your classroom, or if you're teaching
a lesson on money and budgets! |
|
|
Week Five |
Wednesday - Lesson 09 |
|
Now that you know
all the ins and outs of creating one worksheet,
it's time to increase the difficulty factor, and
really organize your classroom! In this lesson,
you're going to learn how to use sheet
references to create three-dimensional
workbooks, linking different worksheets so that
the linked information updates automatically.
This can be really helpful if you want to create
monthly or quarterly grade books, and then
compile all that information into one
end-of-year grade summary for each of your
students. This lesson will also discuss ways you
can use linked workbooks in cooperative learning
projects with your students. |
|
|
Friday - Lesson 10 |
|
Remember
statistics class in high school? It wasn't the
easiest class, but now that you're a teacher,
you know how important statistics are when
you're trying to evaluate your students'
assessment scores. Excel to the rescue! This
lesson is going to go over the basics of
statistics in Excel. You'll learn how to use
functions to simplify the process of calculating
averages, deviations, minimums, maximums, modes,
and more. This lesson will also discuss how
these tools can help you target your students'
strengths and areas of need. |
|
|
Week Six |
Wednesday - Lesson 11 |
|
This lesson is
all about saving you time. It will go over how
to use macros to automate all your tedious tasks
in Excel, and then this lesson will show you how
to build a macro of your very own. You'll also
learn how to add time-saving buttons to the
toolbars at the top of your screen. And this
lesson will talk about ways you can customize
those toolbars to better meet your needs. At the
end this lesson will show you one feature that
won't save you any time at all, but will allow
you to have some fun customizing the images and
colors of the icons on your toolbars. But a word
of warning: Don't share this one with your
students if you want to keep their full
attention in the computer lab! |
|
|
Friday - Lesson 12 |
|
|
|
.gif)
This site is US friendly - Hosted in the US - Payments in US
Dollars - Payments received in the US through a US based payment
processor. 
