Syllabus for: Sosc 10 - 3 Fall 2003 TTh 9:30 - 10:45 Butte 207
Instructor: David Philhour Office: Butte 213 Phone: 898-4127
Office Hours: Tu Th 12:30-1:30; Email: dphilhour@csuchico.edu
TEXT: A Guide to MICROSOFT OFFICE XP PROFESSIONAL for Windows
AUTHORS: B. Presley, B. Brown, E. Malfas, and J. Marrelli
SUPPLIES: Five (5) 3.5" High Density (1.44mb) Disks formatted for IBM compatibles.
About $2-3 on your WildCat Card to pay for printing @ $.08/pg.
OTHER REQUIREMENTS: An Email account
OBJECTIVES: Social Science 10 is a hands-on course designed to familiarize the student with the basic hardware and software for microcomputers including the Windows2000 operating system, Web browsers, E-mail, and the MS Office XP Professional package which includes word-processing (Word), spreadsheets (Excel), database (Access), and presentation graphic (Powerpoint). Additional practice using SPSS (Statistical Package for the Social Sciences), and electronic information transfer skills will be undertaken. This class will teach students about current and emerging technologies which can act as a foundation for use in the K-12 classroom. The emphasis in this course is on practice and practical application of the basic computing skills needed to be a productive member of the teaching-force in the 21st century. The text includes step-by-step practices where skills are developed and exercises are undertaken to test the student's understanding and ability to use this skills. All practices for assigned chapters should be undertaken, but only selected exercises will be turned in for grading. Although this is primarily a skills based course, elementary understanding of computing fundamentals and vocabulary are an essential part of the curriculum. Prospective teachers will be introduced to some of the ethical and social issues regarding privacy and the use of the Internet and computer technology.
COURSE OUTLINE CHAPTERS TO BE READ
History of Computers 1
E-mail address sign up, folders 2-3 (optional)
Introduction to Windows2000 Win2k.pdf
Internet Use and Search Tools No Reading
Word Processing 4-7
Project = Annotated Bibliobraphy (20)
Spreadsheets 8-10
Project = Charts & Tables (20pt)
Integrating Word Processing and Spreadsheets 12
Database 13-14
Project = Simple Database (20pts)
Integrating Word Processing, Spreadsheets & Database 16
Using SPSS In class
http://www.csubak.edu/ssric/Modules/SPSS/SPSFirst.htx
Making Presentations 17
ASSIGNMENTS AND GRADES:
There will be in-class assignments comprised of specific exercises from the Presley text which are to be turned in electronically to your personal turn-in directory under the G:\TURNIN\PHILHOUR\ss10\lastname directory. A list of these assignments will be distributed in class. Each assignment will be worth a maximum 5 pts. Partial credit will be given for exercises with errors & a "redo" will be given to assignments that are unacceptable and can be re-submitted for full credit. Due date for assignments will be announced in class. Assignments handed in after the due date will have points deducted based on how late they are (-1pt for each class period late).
§ There will be 3 projects (20pts/ea) corresponding to each of the major components of the Office package. These projects are designed to demonstrate proficiency in these areas and will be due at 10 p.m. on the due-date
§ There will be 4 Quizzes (20pts/ea) covering major sections of the course material. The dates of these quizzes will be announced in class several days before the quiz.
§ There will be a final project (40pts) due at the normally scheduled final time (Tues. 12/16, 12-2 pm).
Grades will be assigned based on the formula total points/total points possible and distributed :
A = 90% and above; B = 80 - 89%; C = 70 - 79%; D = 60 - 69%; F = below 60%.
§ No assignments will be accepted after 5:00 on Tues. 12/16. Missing assignments receive a grade of ZERO.