January, February, March

Computer Class Offerings

 COURSE SCHEDULE

COURSE DESCRIPTIONS

101 Word - Beginning       1/28,2/4    2 2-hour sessions    4-6 WHS

This course is designed for beginners.  The skills covered will include: creating, saving editing and printing a documents; formatting text, cutting and pasting and working with more than one document at a time.

102 Excel - Beginning        2/18,2/25    2 2-hour sessions    4-6 WHS

This course is designed for beginners.  You will create a file, name individual sheets, format cells, create borders, enter simple formulas, manipulate data and sort data.

103 Power Point - Beginning    2/5     1 2-hour session    4-6 WHS

This course is for beginners.  You will create, save, edit  and print a simple slide show using a design template.

104 Front Page – Beginning   2/3, 2/10   2 2-hour sessions    4-6 WHS

The participant will be introduced to basic web development, design and deployment concepts and issues.  Participant will design/develop web pages.

201 Word – Intermediate   1/27, 2/4, 2/11   3 2-hour sessions    4-6 WHS

For those who have some experience with word.  The skills practiced will be Changing margins and tabs, Creating and working with tables, using word art, using templates and inserting a graphic.

202 Excel – Intermediate    2/20, 2/27  2 2-hour sessions     4-6 WHS

For those who already know the basics of Excel.  Skills covered will include Filling down formulas; Use built in formulas (AVG, COUNT, MEDIAN, MEAN, MIN, MAX).  Create graphs, Adding subtotals and freezing and unfreezing panes.

203  Power Point – Intermediate  2/12, 2/19  2 2-hour sessions   4-6 WHS

For those who know the basic functions of Power Point.  You will create a slide show that includes graphics, animation, transition and hyperlinks.

301 Word – Advanced      1/30, 2/6, 2/13   3 2-hour sessions     4-6 WHS

Skills learned in this course will include:  Mail merge, document merge, create a newsletter, create a brochure, create linked pages.

302   Excel Advanced        3/3, 3/10    2 2-hour sessions   4-6 WHS

Skills learned in this course will include:  Inserting graphics, advanced formulas, creating IF statements, conditional formatting, hyperlinks, filters

303   Power Point – Advanced     2/26, 3/5    2 2-hour sessions    4-6 WHS

Side shows which include all items in intermediate as well as sound  and video.

 304  Front Page – Intermediate   2/24, 3/3   3 2-hour sessions   4-6 WHS

Participants will increase their ability to manage sites that have more than one or two pages.  They will develop more skills for creating effective and user friendly web sites.

401   Using go.grolier    1/27 3-5 WHS    or   1/29 4-6 WHS   1 2-hour session

go.grolier is an on-line subscription for research in which Somerset County participates.  It contains various level encyclopedias, maps, and specialized information.  It is a great place so start students in research.  Students and teachers can also enroll and have home access for free.

402   Using Marco Polo         2/5 CHS 4-6  or  3/12 WHS 4-6     1 2-hour session

A free on-line resource which has lessons and resources sorted by grade-level and state standards.  Much of the leg work has been done.  You will  learn how to take a topic and search the various components for things that you can use.

403  On-line Quizzes    1/29 CHS 4-6 or 2/11 WHS 4-6 or 2/12 WHS 4-6  1 2-hr session

A free on-line service which allows teachers to create classes and create quizzes that students can take on line.  When the students submit their answers the quiz is immediately graded and they can see the results and also the correct answers for questions answered incorrectly. 

404  Inspirations     2/6   4-6 WHS  or 2/13    4-6 CHS   1 2-hour session

A graphic organizer which allows students to gather information and organize before writing.  Good for brainstorming with a class.  There are many templates already designed for activities you do with your students.

404   Kisdpirations    1/30      4-6 WHS      1 2-hour session  (PreK-2 )

405   Creating a Web Quest   3/6, 3/13,3/20  3 2-hour sessions   4-6 WHS

A web quest is a long-term project which has students assume a role, work collaboratively, solve a problem, with a major portion of the research being done on the web, and present a final project.  It can be applied to most any subject matter.  The course is designed to have you work on the planning and design of a webquest that you would use with your students.