 |
 |
|
The ExpertRating Online Teaching Course (Microsoft Excel 2007) (leading to ExpertRating Microsoft Excel 2007 in the Classroom Skills
Certification).
Learn the basics
of Microsoft Excel 2007 in this professional development course for
teachers, and get the training every teacher needs for using and
teaching this powerful program effectively in the classroom. This
unique online workshop is packed full of tips, shortcuts, and lesson
plan ideas.

First, we'll
cover all the important Excel fundamentals: Using tabs, formatting
cells and worksheets, inserting formulas for addition, subtraction,
multiplication, and division, and creating colorful charts and
graphs. Then we'll move on to more advanced Excel features such as
sorting and analyzing student test data for differentiated
instruction, writing powerful mathematical formulas, and using Excel
to automatically calculate student averages and other statistics.
You'll finish the course by creating a customizable grade book that
you can use in your own classroom.

Throughout the
course, we'll explore standards-based lesson plans and activities
that allow you to pass your Excel knowledge on to your students, no
matter what grade level you teach. By the end, you'll have a solid
understanding of Excel, and a wealth of ideas for integrating this
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 2007) 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.
Microsoft Excel 2007 in the Classroom requirements:
For taking this instructor led ExpertRating Online Teaching Course (Microsoft Excel 2007) you need
Microsoft Windows Vista or XP,
Microsoft Excel 2007 or
Microsoft Excel Home and Student 2007 or Microsoft Office
2007 (the
Home and Student Edition, of Microsoft Office 2007 are
also acceptable). A free trial version may also be available at
Microsoft's Web site. 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.
Testimonials:
The ExpertRating Online Teaching Course (Microsoft Excel 2007) has received overwhelming positive
feedback and reviews from students around the world. Here are a few:
"I
was pleasantly surprised by this course. I have been using Excel for years and
was having trouble transitioning to the new layout, but in addition to learning
the new layout, I have learned to do things in Excel I knew it did but had never
spent the time to learn myself (for example using conditional formulas and
formatting) and most of the new things I will use in my grade books at work!
Thank you!"
"Ms.
Sellers is an excellent instructor. Her courses are very thorough and
informative as well as engaging. I would highly recommend both Microsoft Word
2007 in the Classroom and Microsoft Excel 2007 in the Classroom to other
teachers. Both courses are well worth your time."

|
|
|
 |
 |
|
ExpertRating Online Teaching Course (Microsoft Excel 2007)
(leading to
ExpertRating Teaching Certification)
ExpertRating
is one of the world's only ISO 9001:2015
Certified companies (from
TUV America) offering an Online Teaching (Microsoft Excel 2007) Course (leading to ExpertRating Teaching (Microsoft Excel 2007) Skills Certification).
Over 5 million people from 120 countries have benefited from ExpertRating Online Tests and Certifications. 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:2015
certified company, it is also HackerSafe approved.
ExpertRating upholds the highest privacy standards and complies with
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 2007) 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 2007) Courseware which has
been developed by experienced Soft Skills Teaching Experts.
The ExpertRating Teaching Certification is by far the best value for money instructor led
Teaching Program at $129.99.
Some Popular questions and answers about
this ExpertRating Online Teaching Course (Microsoft Excel 2007) and Certification:
How much does the
Teaching Certification cost and what does it include?
You can buy this ExpertRating Online Teaching Course (Microsoft Excel 2007)
leading to
Teaching certification at a special offer price of only $129.99 which
includes the in-depth ExpertRating Online Teaching Course (Microsoft Excel 2007) 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 2007) 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 2007) for $129.99. Log in to the instructor led course using your password. Go through the
ExpertRating Online Teaching Course (Microsoft Excel 2007) 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 2007) 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 2007) 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 2007) 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 2007) 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 2007 in the Classroom makes you well versed with shortcuts and
macros, improves employee productivity and empowers you to access,
organize and examine important business data.
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 2007)
Coverage (6 weeks program)
Week One |
Wednesday - Lesson 01 |
Before you teach
your students to use Excel, you'll need to learn
the basics of this great program. 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'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. |
|
|
Week Four |
Wednesday - Lesson 07 |
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. |
|
|
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. |
|
|
Friday - Lesson 12 |
|
|
|