		Michael L'Estrange Computer Information Science

CISC 300: Computer Familiarization

Instructor:	Michael L'Estrange
Instructor Email:	lestram@arc.losrios.edu
Instructor Web Page:	http://ic.arc.losrios.edu/~lestram
Instructor Phone:	(916)-484-8147
CSIT Area FAX:	916-484-8673 (always include a cover sheet)
Instructor Office:	ARC main campus, Liberal Arts Bldg. Room 133, Office # 17
Office hours:	Mon Wed 5-6pm in room Liberal Arts 125 Tues Thur 10am-Noon
Course Code #:	11806
Class Location:	Liberal Arts Room 126
Meeting Times:	MW 12noon-12:55pm
Semester:	Fall 2010
Term:	Second Eight Weeks, Oct 16, 2010 - Dec 10, 2010
First meeting:	18 October 2010
Final Examination:	8 December 2010, Wednesday, 12noon-12:55am
Prerequisite:	None.
Advisory:	ENGRD 116 or ESLR 320 and the ability to type 20 wpm.
Accepted for credit:	CSU
Hours:	18 hours lecture.
Units:	1

Course Description

This course provides a general non-technical introduction to how computers work in addition to basic computer terminology and concepts. The focus is hands-on instruction using an operating system, word processing, spreadsheet, and Internet software. The course may be taken twice for credit on different hardware platforms.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

Employ the mouse as a navigational tool to select menus, text and screen options.
Manage stored files using file management software.
Evaluate basic operating system commands and select command necessary to format disks, list, copy, move and erase files, create subdirectories, and change default drives.
Create, save, and print word processing documents using basic editing and formatting techniques.
Investigate information on the Internet using a search engine and browser.
Analyze basic business topics and business applications.
Design, create, preview, save, and print spreadsheets using basic data entry, editing, and formatting techniques.
Analyze data organized into columns and rows, evaluate calculations, and create a visual presentation of the data in the form of charts.
Examine basic database and database management systems concepts.

Textbook and Supplies

Microsoft Office Word 2007-Illustrated Brief
Jennifer Duffy
Course Technology, © 2008
ISBN 13: 978-1-4239-0525-7
ISBN 10: 1-4239-0525-3

Book Cover

Microsoft Office Excel 2007-Illustrated Brief
Elizabeth Eisner Reding
Course Technology, © 2008
ISBN 13: 978-1-4239-0520-2
ISBN 10: 1-4239-0520-2

Required:

All students are required to obtain and maintain an ARC Los Rios iMail email account.
All students are required to have some form of portable electronic storage media or device to save homework files to.
All students are required to obtain and maintain a leaning management system shell account.

Presentation of Class Materials:
Course information will be introduced by means of lecture and classroom demonstrations. Students will be given assignments to be completed both in class as well as on their own time. Due to the fact that there is no lab associated with the class, there will not be as many assignments as in most CIS classes. This makes all the assignments that much more important for grading purposes. Printing is NOT to be done during lecture times. You may NOT work on class assignments, or surf the web while the lectures are being conducted.

Moodle learning management system (LMS)

This class will be using the Moodle LMS, NOT D2L.
http://www.someprofs.org/moodle/
Moodle will be used to access most class materials, assignments, activities, quizzes, examinations, and grades.

Special note on contacting the instructor

The instructor is an offline resource, and he will probably not return any messages over the weekend or college vacation days.
Whenever sending an email, use the format specified in the online orientation page.
Emails that are undecipherable will be ignored. Use standard English in all messages sent to the instructor.
Emails that do not contain a question may not be replied to. A question should be denoted with a question mark, i.e.?!
Messages with long or complex questions may take time to answer, as in several days.
The instructor will not open emails or attachments he cannot identify, i.e. use your ARC Los Rios iMail email account.
No student emails are deleted.
A logbook of phone calls and faxes is maintained for each class.

Course Policies:

This class will adhere to as closely as possible all ARC and Los Rios guidelines set forth in the catalog and/or the schedule of classes.

A document of general course policies for all my classes can be found on the instructor's web site.

Labs

Almost all CIS classes require labs. It is the online student's responsibility to complete labs. Students may complete lab assignments in CSIT Area Computer Labs, room 152, or at another ARC computer lab facility if allowed.

Lab assignments must be completed by the assigned date. Under no circumstances will network, system, hardware, or any other problems of such nature be considered an excuse for turning in late work.

Lab hours/Assistance:

Students may utilize lab time and assistance on campus in the CSIT area computer lab room 152. Check with the CSIT area lab personnel in room 152 for lab hours and availability. Lab assistance is not tutoring. Tutoring is available on campus; contact the instructor directly regarding tutoring. Please have your book with you when seeking help from tutors or lab personnel.

Accommodations

It is critical that every student be provided an environment which is conducive to learning. Please contact the professor if you have any physical or learning disability or other need which might require a special accommodation.

Online Discussions

During the semester you may be required to participate in online discussions or forums. The purpose of these discussions is to stimulate your thinking about the material covered in the course. Points will be given based upon your level of participation in a discussion. Students must provide their own ideas, reactions, opinions, or answers related to the discussion topic or question or to the responses provided by other students. The more thoughtful and detailed the student's responses, the grater number of points he or she will earn. Abusive remarks or attacks against others will not be tolerated and will result in lost points. Online discussions must be completed by the assigned date. No make-ups of discussions will be allowed.

Attendance Policy

Attendance will be monitored.

Students are required to self report attendance in class by using the attendance web page. The instructor will show student how to use this web page on the first day of class. Each student is required to self report his or her attendance for each class period.

http://power.arc.losrios.edu/~labtba/

Attendance Requirements: ARC attendance policy: "A student may be dropped from any class when that student's absences exceed (6%) of the total hours of class time." For Online and Hybrid courses the submission of weekly assignments and communications with the instructor will be used as the measurement of attendance. Students that fail to submit assignments (or any communication, e.g., email or voice mail) for two (2) consecutive weeks, may be dropped from the class.

Once a student has been dropped form the class (for whatever reason), he or she will not be reinstated.

Drops: Students unable to complete the course are responsible for notifying the Records Office of their withdrawal. Failure to formally drop the course will result in a final grade of 'F'.

If you have extenuating circumstances which prevent you from participating in the class or submitting your assignments, CONTACT THE PROFESSOR IMMEDIATELY!

Online Schedule (Special note for online students)

This online class is not self-paced.

Students must complete readings and assignments based upon the class schedule listed within the course. Success in this online class is dependent upon reading the text, regular participation in discussions and completion of the assigned work. Information will be presented in supplemental materials and during discussions that is not included in the text. Students will be tested on the material presented in the text. Usually all assignments must be completed by the end of the week, and it is up to the students discretion when to complete the assignments that week.

If you have extenuating circumstances which prevent you from participating in the class or submitting your assignments, CONTACT THE PROFESSOR IMMEDIATELY!

Course Lesson Plan / Schedule of Topics

This course will follow the book essentially in chapter order. The schedule of topics, chapters to be covered, and assignments due each week shall be listed in the Moodle LMS. Students may certainly read ahead, but completion of assignments early may not be allowed or even be possible. Changes to the details of this course schedule will not be reflected on this web page. For online classes, please refer to the Learning Management System, Moodle, for all current updates. For in person classes, the instructor will make announcements during lecture.

CISC 300 Computer Familiarization Course Lesson Plan
Date	Topics	Assignment
Monday, October 18	Syllabus Overview Logging on to ARC student lab computers Take Self Attendance Using ARC Los Rios iMail e-mail Proper logout of the PC	Instruction begins for 2nd Eight week classes: October 16 Login and log out Assignment Send Instructor iMail email Assignment Take Self Attendance Assignment Purchase Book
Wednesday, October 20	Introduction to the concepts of a personal Computer. How the operating system works. Use of Microsoft Windows operating system software. Using desktop icons and the Taskbar Organizing and managing data Resize, move, and scroll windows Maximize, restore, minimize, and close a window Create a new folder Copy, move, rename, and delete files Find files and folders Compress files	Last day to add: October 30; or, to drop this class to qualify for enrollment fee refund: October 22 Readings and videos assigned by instructor Assignment: Windows File Management. Quiz on Windows Assignment Access Moodle
Monday, October 25	Microsoft Windows operating system continued. Introduction to the World Wide Web and the Internet using Microsoft Internet Explorer web browser software. Navigate the Internet Work with Favorites Electronic Mail: web based e-mail programs; sending and receiving messages; attachments	Readings and videos assigned by instructor Quiz on Internet Explorer Assignment Due: Email; Email attachments Assignment Send Attachment: screen shot
Wednesday, October 27	Netscape Navigator and Mozilla Search the Internet Download files Print web pages Introduction to OnlineExpert Download Office compatibility pack Download data files for word and excel Send an attachment to yourself	Last day to drop this class without notation on record: October 31 Quiz: Internet Explorer Assignment Login and Access the ARC Online Expert Site Assignment ARC Online Expert Pretest test Assignment ARC Online Expert Labs Assignment ARC Online Expert Posttest test
Monday, November 1	Understanding the Office 2007 Suite Starting and Exiting an Office Program Viewing the Office 2007 User Interface Creating and Saving a File Opening a File and Saving it with a New Name Viewing and Printing Your Work Getting Help and Closing a File Using Notepad and WordPad Introduction to word processing software and applications using Microsoft Word software. Understanding Word Processing Software Exploring the Word Program Window Starting a Document Saving a Document Selecting Text Formatting Text Using the Mini Toolbar Creating a Document Using a Template Viewing and Navigating a Document	Read Unit A: Getting Started with Microsoft Office 2007 Read Unit A: Creating Documents with Word 2007 Quiz: Unit A: Getting Started with Microsoft Office 2007 Concept Review Quiz: Unit A: Creating Documents with Word 2007 Concept Review
Wednesday, November 3	Cutting and Pasting Text Copying and Pasting Text Using the Office Clipboard Finding and Replacing Text Checking Spelling and Grammar Researching Information Adding Hyperlinks Preparing a Document for Distribution	Quiz on E-mail, Office 2007 Assignment: Word Unit A: given in class Read Unit B: Editing Documents Quiz: Unit B: Editing Documents Concept Review Assignment: Word Unit B: given in class
Monday, November 8	Formatting with Fonts Copying Formats Using the Format Painter Changing Line and Paragraph Spacing Aligning Paragraphs	Read Unit C: Formatting Text and Paragraphs Quiz on finding files Read Unit C: Formatting Text and Paragraphs Assignment Word Unit C: given in class
Wednesday, November 10	Setting Document Margins (pp 78-79) Inserting Clip Art (94-95)	Read Unit D: Formatting Documents Quiz: Unit D: Formatting Documents Concept Review Assignment Word Unit D: given in class Midterm Exam (covers Win XP, IE and Word)
Monday, November 15	Introduction to spread sheet software and applications using Microsoft Excel software. Understanding Spreadsheet Software Touring the Excel 2007 Window Understanding Formulas Entering Labels and Values and Using AutoSum Editing Cell Entries Entering and Editing a Simple Formula Switching Worksheet Views Choosing Print Options	Read Unit A: Excel Quiz: Unit A: Excel Concept Review Assignment: Excel Unit A: given in class
Wednesday, November 17	Creating a Complex Formula Inserting a Function Typing a Function Copying and Moving Cell Entries Understanding Relative and Absolute Cell References Copying Formulas with Relative Cell References Copying Formulas with Absolute Cell References Rounding a Value with a Function	Read Unit B: Working with Formulas and Functions Quiz: Unit B: Excel Concept Review Assignment: Excel Unit B: given in class
Monday, November 22	Formatting Values Changing Font and Font Size Changing Attributes and Alignment Adjusting Column Width Inserting and Deleting Rows and Columns Applying Colors, Patterns, and Borders Applying Conditional Formatting Naming and Moving a Sheet Checking Spelling	Read Unit C: Formatting a Worksheet Quiz: Unit C: Excel Concept Review Assignment: Excel Unit C: given in class
Wednesday, November 24	Plan a chart Create a Chart Move and resize a chart Change a chart design Change a chart layout Format a chart Annotate and draw on a chart create a pie chart	Read Unit D: Excel Quiz: Unit D: Excel Concept Review Assignment: Excel Unit D: given in class
Monday, November 29	Catch-up	Last day to drop this class with W grade: November 276 Catch-up
Wednesday, December 1	Catch-up	Catch-up
Tuesday, December 6	Demonstrate of database concepts using Microsoft Access. Over View of IT field and ARC CIS Majors Review for final	Catch-up
Wednesday, December 8, 12noon-12:55pm	Final Exam	Instruction ends for 2nd eight week classes: December 10; Grades posted in about 10 business days No Assignments Accepted After the Final

After the start of class, use only the schedule in the learning managment system. Current Homework/Projects/Lab Assignments and Discussion assignments and due dates will be specified in the learning management system.

Documents turned-in:
When turning in work in hard copy or electronic form, please include a header on the top of the page with the following information:

Your Name Assignment #
CISC 300 Page # of #

Also, when contacting the instructor via email, be sure to include the class number in the subject line, i.e. CISC 300.

Evaluation and Grading

The grade in this course will be determined by student performance in each of the following areas, and weighted as described in the following charts.

Grade Assessment Weighting

Attendance
1 point per class session (16 points) 3.2%

Quizzes
(80 points) 16%

Homework Assignments
(256 points) 51.2%

Midterm Examination (80 points) 16%

Final Examination (80 points) 16%

Grade Assignment by Total Points

Points Obtained Total % Grade
Assigned

450+ 90% A

400+ 80% B

350+ 70% C

300+ 60% D

less than 300 below 60% F

Grade Assessment Weighting
Attendance 1 point per class session	(16 points) 3.2%
Quizzes	(80 points) 16%
Homework Assignments	(256 points) 51.2%
Midterm Examination	(80 points) 16%
Final Examination	(80 points) 16%

Grade Assignment by Total Points
Points Obtained	Total %	Grade Assigned
450+	90%	A
400+	80%	B
350+	70%	C
300+	60%	D
less than 300	below 60%	F

Extra Credit Work:

There will be no extra credit work given in this class. Your grade is based solely upon the regularly assigned work in the class: attendance, participation, lab assignments, projects, quizzes, and examinations.s.

Grades Available Online:

Grades will be available during the entire semester through the Moodle LMS. Final grades will be accessible through the ARC eServices system.

Policy on Late Work and Makeup Exams

No late work will be accepted.
No make up quizzes or exams will be given.
NO Assignments accepted after the final

Caveat

The professor reserves the right to change any of the details of this course syllabus or the course schedule with a minimum of advance notice

Passing the Course

Students must take the Final exam to pass.
Students must pass the Final exam with a D grade or better.
Students must take the Final exam on the scheduled date and time of the Final. (You have 8 weeks to clear you schedule - make it so.)

Last Updated: 24 July 2010