USD Division of Continuing Education Scenes of USD
Page name Scenes of USD

Microsoft Office for the Educator - Level II - EDU 581CC Course Syllabus

Instructor – Joe Herz, MA
E-mail: usdnet@usd-online.org

Course Description

This course is designed for the classroom teacher who uses a computer for educational purposes. To be successful in this class, the participant needs to know how to operate a computer, have access to Microsoft Office software (Word, Excel and PowerPoint) and connect to the Internet.  Assistance with hardware components cannot be given due to the wide variety available.

Course Objectives

By the end of the course, the participant will have had opportunity to create numerous intermediate and advanced Microsoft Office documents, including word processing, spreadsheet and presentation documents. Using the required textbook, students in this course will be taken through a series of lessons, tutorials and exercises to learn computer and Microsoft Office software terminology, and intermediate and advanced Word, Excel and PowerPoint skills. Students will learn how to apply those skills as cognitive tools to produce a variety of beginning level documents and lessons that can be adapted to K-12 teacher tools and classroom curriculum.

Rationale

"The widespread reliance of contemporary society upon computer-based technologies reflects the increasing importance of electronic information management and communication tools. Technology, in its many forms, has become a powerful tool to enhance curriculum and instruction. Productivity, communication, research, and learning are dramatically enhanced through the appropriate use of technology thereby allowing educators to accomplish tasks that were not previously possible"(CCTC, 1998).

Relevant Professional Standards

The tutorials contained in the required textbook are aligned with the International Society for Technology in Education (ISTE) and Standards for Teachers (NET-T). These standards focus on teacher technology education and define the fundamental concepts, knowledge, skills, and attitudes for applying technology in educational settings. They include:

    1. Technology operations and concepts.
    2. Planning and designing learning environments and experiences.
    3. Teaching, learning, and the curriculum.
    4. Assessment and evaluation.
    5. Productivity and professional practice.

Required Course Materials and Supplies:

 

  • Microsoft Office (Word, Excel and PowerPoint installed on your PC or Mac computer)
  • Required Course textbook: Technology Tools for Teachers, A Microsoft Office Tutorial, Second Edition, Steven C. Mills, M.D. Roblyer. ISBN: 0131187279. Available at bookstores and online including www.amazon.com.
  • An email account
  • Internet access

Emailing files

A5 – How to Submit Work by Email

You will be sending three separate emails when finished with ALL three sections to the instructor at usdnet@usd-online.org

·     Be aware that some email providers may limit the size of files you can send at any one time.

·     If you are going to email assignments, it is suggested you do a trial email to yourself or a friend to insure files arrive and work, otherwise you could be asked to submit the files on a CD if there are problems.

·     You will also need to include in the first email along with your Word Processing files the following information in lieu of mailing the Affidavit. (The remaining two emails only need your name)

o   Full Name

o   Address

o   Phone Number

o   Last 4 digits of your SS#

o   School District

o   School Name

o   Grade/Subject(s) taught

o   The following statement:
I verify that I have completed all required work for 581CC. All work submitted is my own.

·         Files should be placed in three separate emails to the instructor. Use the following Subject lines for the related content:

o   EDU 581CC WP files

o   EDU 581CC SS files

o   EDU 581CC PP files

§  The WP email will include 7 files

§  The SS email will include 5 files

§  The PP email will include 5 files

·     DO NOT EMAIL ANY ASSIGNMENTS UNTIL YOU ARE FINISHED WITH THE ENTIRE COURSE. WHEN FINISHED, EMAIL ASSIGNMENTS IN THREE SEPARATE EMAILS AS INSTRUCTED ABOVE.

·      WITHIN 3 DAYS THE INSTRUCTOR WILL SEND VERIFICATION THAT THE EMAILS WERE RECEIVED.

MAKE SURE YOUR EMAIL CLIENT WILL ACCEPT EMAILS FROM USDNET@USD-ONLINE.ORG. SCHOOL DISTRICTS AND YAHOO ACCOUNTS ARE AMONG THOSE THAT WILL OFTEN REJECT THE ADDRESS UNLESS YOU HAVE DESIGNATED IT AS ACCEPTABLE.

System Requirements

OPERATING SYSTEMS: Any PC or Mac operating system that will run Office software. Users of Office 2007 should take the Office 2007 course.

Class Assignments

Assignments are broken into the three areas of word processing, spreadsheets and presentations. All assignments are detailed in the required text. Each assignment will teach knowledge and application of the following Microsoft Office terms and features:

 

  • Word
    AutoShapes; Callout; Clip Art; Draw Tools; Groupings; Images; Rotate; Text Box; Watermark; WordArt; Bookmark; Form; Form Control; Form Field; HTML; Hyperlink; Template; Web Form; Wizard

  • Excel
    Absolute Reference; Autofill; Combo Box; Comments; Dependent Cell; Formula; Function; Logical Functions; Precedents; R1C1 Reference Style; Reference; Reference Style; Relative Reference; Syntax

  • PowerPoint
    Action Button; Action Settings; Animation; Animation Scheme; Effect; Hyperlink; Publish; Self-Running Presentation; Timing; Transition

Using Office 2007 to complete the course will present minor problems. Solutions to those are addressed in the USD online course Resource page.

Course Assessment

Student work will be evaluated based on accuracy and creativity as detailed in each assignment. The Rubric found in section A2 of this coursework will be used for grading of assignments. Gross deficiencies in any assignment will need revising and re-submission for approval.

Completion Dates

You will have 9 months at time of registration to complete the course.

 

DEBUG: 31