MDC Mission Statement:

“The mission of Miami Dade College is to provide accessible, affordable high quality education by keeping the learner's needs at the center of decision-making and working in partnership with its dynamic, multicultural community.” 	

INRODUCTION TO MICROCOMPUTERS

Instructor: Enrique Hernández MA	Term: SPRING 2007-2
Course Id: CGS 1060	Credits: 4 Credits
E-mail: enrique.hernandez@mdc.edu	Reference #: 439361
Phone: 305-237-6240	Location: ROOM 1216
Office: Room 1217-L	Days: Thursday
Time: 5:40-9:00pm	Last Revised: 01-08-08
Webpage: http://geocities.com/cgs1060.geo
Network location: Drive I:\Ehernan2\cgs1060

Office hours: 2:30-3:30 pm (Mon-Th.)

Course Description:
The course is composed of five different sections: INTRODUCTION AND WINDOWS XP OPERATING SYSTEM, POWERPOINT 2007, WORD 2007, EXCEL 2007, and ACCESS 2007.

Prerequisite: Though it is an introductory course, students are supposed to have some typing skills.

Course Requirements:
Textbook: Office 2007. Introductory Concepts and Techniques , Windows XP Edition (INTRODUCTORY) of the Shelly-Cashman Series.ISBN 13: 978-1-4188-4327-4.
All students should visit our bookstore before buying the textbook to avoid buying the wrong book. All students are supposed to buy the textbook and bring it to all classes and to the lab. 
Students are supposed to keep a website to upload all assignments. All assignments are to be displayed through a web page.
Though it is not absolutely necessary, students may have a diskette to save their activity in case there is no access to the Internet when working on assigned materials.

CLASS POLICIES
Tests
You may take a test, if, and only if, you have done all required class activities and lab assignments. Therefore you have to plan to fulfill all assignments before each test date.

LAB HOURS AND ASSIGNMENTS

The student should register in the Computer Courtyard (room 1217) in order to use the lab. The Lab Assignments is an independent document that describes which assignments should be done, either in the lab or at home, and how to upload them to the student’s Web site. The Schedule of Activities is at the end of this document. 
The Computer Courtyard will be opened with this schedule: 
Monday-Friday: 7:30 am-9:00 pm
Saturday: 9:30 am-2:30 pm

CLASS ACTIVITIES

Each class will have a lecture part where students should take notes and ask questions in order to have a full understanding of the lecture. After this introductory part, students are supposed to follow instructions from a handout (Class Activities) that will be provided for all classes of how to use the book while in the classroom. Each student will have a Web site using the free service of www.Geocities.com. Students must upload all class assignments to this Web site, so no printing will be done during the term. The instructor will assist each student by providing handouts and direct advice on creating and updating this Web site. Students are responsible for the content, but if you need help, you should ask by any means: in class, or using email. 

Grading Policies

Participation: 10 points of the final grade for class activities.
Exams: There are five tests with a value of twelve point of the final grade. (8 points for the practical part, and 4 point for the theory)
Lab. Assignments: 20 points for all lab assignments, one point per lab hour. It is linked to the lab. assignments. The lab will have a test in order to be valid. On the test date, you will have to take the lab test together with the course test.
Web site: 10 points.

Grading Scale:
A	=100%- 90%
B	=89- 80%
C	=79- 70%
D	=69- 60%
F	=Less than 60%

Academic Dishonesty:
Academic dishonesty is defined as an action inconsistent with the ethical standards of Miami Dade College. Academic dishonesty includes the following actions, as well as other similar conduct aimed at making false representation with respect to a student’s academic performance.
A.	Cheating on an examination 
B.	Collaborating with others in work to be presented, if contrary to the stated rules of the course
C.	Plagiarizing, including the submission of other’s ideas or papers (whether purchased, borrowed, or otherwise  obtained) as one’s own
D.	Submitting, if contrary to the rules of a course, work previously presented in another course
E.	Knowingly and intentionally assisting another student in any of the above actions, including assistance in an arrangement whereby any work, classroom performance, examination, or other activity is submitted or performed by a person other than the student under whose name the work is submitted or performed. Some actions of academic dishonesty, such as stealing examinations or course material and falsifying records, may be processed through the Student Disciplinary Procedure.
The Student Disciplinary Procedure may be found on the Student’s Rights & Responsibilities Guide (page 20).

Attendance Policy:
Students are expected to attend all classes, except when precluded by emergencies. Attendance will be taken at the beginning of the class; students will be marked absent if they are late more than 10 minutes.

Withdrawal (DROP):
A student not completing the course for any reason is required to submit an official drop notice to the Registrar’s office prior to the deadline. If you do not comply with this procedure, a grade of “F” will be given.

Make Ups:
If you miss a test, you may take it on the same date of other scheduled test, so, you need to be well prepared to answer both tests in the time allocated for one.

Incomplete “I” Grade:
When a student has failed to complete the requirements of a course, the student may be given an “Incomplete” or “I” grade. To be awarded this grade the student must present, to the instructor, valid reasons for not having completed the course requirements. A change of a work-schedule is not a valid reason to request it. The instructor and the student then complete an Agreement for Grade of Incomplete form. This agreement will determine the requirements for a course grade which must be completed by the end of the next major term or failing grade may be assigned. In this class an “Incomplete” or “I” grade is not usually given. The “I” grade applies to students that cannot take the final test because of extreme circumstances. If by the last day to WITHDRAW with a grade of W you know that you will not be able to complete the course, please go to the Registrar’s Office and drop the class.

No Eating and Drinking:
Food and beverages will not be allowed in the classroom.

Beepers and Cellular Phones:
Please, try not to use cell phones in the classroom.

COURSE SCHEDULE

The course schedule can be changed at the sole discretion of the instructor. Coverage of topics mentioned could vary depending on how students find the pace of the course. 
MONTH	DAY	ACTIVITIES	HW	
JANUARY	10	GENERAL INTRODUCTION/
WEB PAGE CREATION
OUTLOOK	COM 1-39	
	17	WINDOWS XP, FTP EXPLORER	WIN 1-65	
	24	POWER POINT 2007	PPT 69-80	
	31	TEST I	PPT 136-144	
FEBRUARY	7	TEST II/WORD 2007	WD 67-72	
	14		WD 138-144	
	21		WD 209-214	
	28	TEST III/ EXCEL 2007	EX 74-80	
MARCH	6	COLLEGE HOLIDAY 		
	13		EX 149-159	
	20		EX 233-248	
	27	TEST IV/ACCESS 2007	AC 67-72	
APRIL	3		AC 131-136	
	10		AC 199-204	
	17	Sharing Data Among Applications	AC 205-232	
	24	TEST V		

TEST	DATE	CONTENT	
TEST I	JAN. 31ST.  	INTRODUCTION/ WINDOWS XP	
TEST II	FEB. 7TH. 	POWERPOINT 2007	
TEST III	FEB. 28TH	WORD 2007	
TEST IV	MAR. 27TH. 	EXCEL  2007	
TEST V	APR. 24TH.  	ACCESS 2007	

Miami-Dade Community College
CGS 1060:  Introduction to microcomputer usage

Course Description
Introduces information processing, the operation of a microcomputer and usage of an operating system.  Applications in word-processing, integrated electronic spreadsheets, and electronic filing systems are presented.  

Four (4) credits: 3-hour lecture and 2 hour lab		

Course Competencies
Competency 1 - Hardware: 
The student will demonstrate the ability to identify and describe the key features and the function of the following components of a computer system:
1.1.	Input Devices
o	Keyboard
o	Pointing Devices 
o	Scanners 
o	Digital cameras 
o	Microphone
1.2.	Output Devices
o	CRT and LCD Monitors 
o	Printers 
o	Speakers 
1.3.	System Unit
o	CPU 
o	RAM 
1.4.	Storage
o	Hard disk 
o	CD-ROM, CD-R, and CD-RW
o	DVD
o	Removable media 

Competency 2 – System Software: 
The student will be able to define and/or use the key features of system software including:

2.1.	Types of Operating Systems
o	Windows
o	Mac O/S
o	Other O/S
2.2.	Operating System Functions 
o	GUI Interface
o	Desktop

2.3.	Windows Fundamentals
o	Managing the desktop (icons, clicking, moving & sizing windows)
o	Using My Computer
•	Formatting floppy disk
•	Locating drives
o	Locating, starting, closing applications
o	File Management
•	Files/Folder Hierarchy
•	Creating files and folders
•	Copying, Moving files / folders
•	Deleting Files and folders
•	Using Windows Explorer
2.4.	Utility Programs
o	Virus Checkers
o	Other Utilities

Competency 3 – Networks and the Internet 
The student will be able to explain the function of and/or use the key features of networks including
3.1.	Network Basics
o	LAN
o	WAN
o	Server
o	Resource Sharing
o	Connectivity (communication media)
3.2.	The Internet
o	History
o	Connecting to the Net 
•	Connecting from Campus 
•	Connecting from Home 
•	Alternatives 
o	Internet services
•	E-Mail
•	Other Services
3.3.	World Wide Web Basics
o	Web Sites / Web pages
o	Hyperlinks
o	Domain Names and URLs
o	Browsers
o	Multimedia 
o	Uploading/Downloading

Competency 4 – Application Software - Word: 
The student will be able to explain and use the key features of Word including:
4.1.	Word Fundamentals
o	Starting Word
o	Opening / closing documents
o	Creating a document
o	Editing a document
o	Saving a document
o	Using Help
4.2.	Formatting text
o	Selecting text
o	Formatting 
o	Creating and editing bulleted/numbered lists
o	Setting tabs
o	Using Find/Replace
4.3.	Finishing
o	Spell and grammar checking
o	Creating / editing headers and footers
o	Inserting / editing page numbers
o	Changing page set-up
o	Previewing a document
o	Printing 

Competency 5 – Application Software - Excel: 
The student will be able to explain and use the key features of Excel including:
5.1.	Excel Fundamentals
o	Starting Excel
o	Opening / closing worksheets
o	Creating a workbook and worksheets
o	Entering data
o	Editing an existing worksheets
o	Saving a worksheet to disk
o	Using Help
5.2.	Worksheet Basics
o	Selecting cell(s)
o	Editing / formatting a range of cells
o	Inserting rows and columns
o	Deleting rows and columns
o	Modifying row/column height and width
o	Naming Worksheets
5.3.	Formulas and Functions
o	Entering simple formulas
o	Entering functions
o	Using AutoSum
o	Using AutoFill
5.4.	Formatting, Finishing, and Printing
o	Formatting numbers
o	Formatting text
o	Using Page Setup
o	Previewing a worksheet
o	Using formula view (“formulas Version”)
o	Printing a Worksheet
5.5.	Charting
o	Creating charts from worksheet data
o	Changing chart types
o	Modifying a chart 
o	Inserting charts in worksheets 

Competency 6 – Application Software - Access: 
The student will be able to explain and use the key features of Access including:
6.1.	Access Fundamentals
o	Starting Access
o	Creating a database 
•	Planning
•	Creating a table in design view
o	Entering data
o	Opening an existing database
o	Selecting views
o	Using Help
6.2.	Editing a database
o	Editing a database file
o	Modifying data
o	Modifying field attributes
o	Sorting
6.3.	Using Forms
o	Creating a form
o	Modifying text and layout
o	Saving a form
6.4.	Using Reports
o	Create a report
o	Print / Print Preview
o	Saving a report
6.5.	Using Queries
o	Creating a query 
o	Adding fields to a query
o	Finding a record based on a criteria
o	Using multiple criteria in a query
o	Saving a query

Competency 7 – Application Software – PowerPoint: 
The student will be able to explain and use the key features of PowerPoint including:
7.1.	PowerPoint Fundamentals
o	Starting PowerPoint
o	Opening a PowerPoint presentation
o	Opening a new presentation
•	Creating a slide
•	Selecting layout
•	Entering data
•	Saving a presentation
o	Inserting additional slides
o	Selecting views
o	Using help
o	Showing a Slide Show
o	Printing