CGS 1060 – COLLEGE COMPUTING
Instructor: Suzanne Ensmann Office: C124
Term: 01/08/14 - 04/28/14 | 6:35P - 9:00P | Wednesdays Office Phone: 772-462-7408
E-Mail: Use Angel | In case of emergency: Toll-Free: 866-792-IRSC 7408
Cell Phone: 772-528-1500 (For text messages use, unless urgent) Office Hours: By appointment
Stay Connected: http://www.facebook.com/suzanneensmann
Web-based syllabus: www.SuzanneEnsmann.wordPress.com
Course Objective: This course is designed to introduce students to microcomputer applications for academic purposes. Major topics include the Windows® operating system, word processing, electronic spreadsheets, electronic databases, and presentation graphics. Successful completion of this course with a letter grade of "C" or better meets the state computer literacy requirement for award of A.A., A.S., or A.A.S degrees at this institution.
Assessed Degree Program Learning Outcome: Make use of technology to organize, acquire, and convey information.
Assessment of Degree Program Learning Outcome: Completion of a project that integrates Microsoft Word, Excel, Access, and PowerPoint.
Course Learning Outcomes:
· Understand Microsoft Windows® basic skills: start and shut down Windows, identify operating system functions, use desktop apps, use Windows Store apps, start programs and open files, personalize the Windows Start screen. Use Windows File Explorer to display folders and files, create and customize folders, rename and delete folders and files, copy and move files, save files, and use the Recycle Bin.
· Create a new document using Microsoft Word and insert and format text, graphics, text boxes, shapes, and SmartArt graphics. Preview and print a document. Change document and paragraph layout, create and modify lists, and set and modify tab stops. Create and format tables, present a document online, correct and reorganize text, use proofing options, create a custom Word template, and create documents using predefined templates. Create a research paper, insert footnotes, and create citations and a bibliography. Format a multiple-column newsletter, use special character and paragraph formatting, and create mailing labels using mail merge.
· Create, save, enter and edit data, and navigate in a Microsoft Excel workbook. Format worksheets, use cell styles and themes, and apply conditional formatting. Construct and copy formulas, display formulas, and print worksheets. Create column charts, pie charts, line charts and sparklines. Use Flash Fill, and the SUM, AVERAGE, MEDIAN, MIN, MAX, COUNTIF, and IF functions. Create, sort, and filter a table. View, format, and print a large worksheet and workbooks with multiple worksheets. Use Goal Seek and perform what-if analysis.
· Use Microsoft Access to plan and create a database, create tables, define fields, and change table structures. Use templates to create tables and databases. Organize objects in the navigation pane. Create relationships between tables, and sort records in tables. Create queries, sort query results, specify criteria in a query, and create calculated fields and parameters in a query. Create and use a form to add and delete records, and modify form layout. Create a report and modify the layout.
· Create, edit, format, view, and print Microsoft PowerPoint presentations. Add and format text and pictures. Use slide sorter view, and apply slide transitions. Insert and format text boxes, shapes, and SmartArt graphics. Customize slide backgrounds and themes, animate slide shows, and insert videos. Create and modify numbered and bulleted lists, tables, and charts.
Assessment of Learning Outcomes: Learning outcomes are determined by measuring the ability of each student to accomplish the learning objectives of the course as measured against industry standards, job descriptions, and state curriculum frameworks. The assessment tools used for this course include observation of mastery of critical skills and performance-based methods, such as completion of learning events and assigned projects, and written tests consisting of either essay, multiple-choice, true/false or fill-in-the-blank questions.
You must also take two REQUIRED exams in class and the final on the last day of class (4/23/14).
Prerequisites: None
Required Text: Go! With Microsoft Office 2013, Volume 1, Gaskin ISBN 978-0-13-314266-2; http://www.bookstore.irsc.edu/default.asp
Attendance & Class Policies: It is imperative that you attend every class session to receive the most benefit for this course. Attendance is required except for designated lab sessions as scheduled by the instructor. An absence may be excused with appropriate written evidence. Be sure to attend your course during the first week of classes. IRSC courses have a "drop for non-attendance" policy. Failure to attend the course during the first week of classes may result in your being administratively withdrawn from the course.
YOU MUST INPUT the ATTENDANCE PIN IN THE ANGEL LMS EVERY WEEK to reflect your attendance! This is how your attendance will be recorded.
Students who are deemed as "at Risk Students" may be assigned required lab hours by their instructor. You will be considered an "at Risk Student" if your overall grade point average falls below a 76%. If you are on a campus that does not have a designated computer lab, you will be able to access the computer lab online. Lab hours will be posted each semester (Please check with your instructor). It is your responsibility to sign-in when you go to a computer lab to record your lab hours. Students who do not complete their assigned lab hours will receive an Incomplete for the course.
This class uses the River Support/Reach Out system. I will notify your Academic Advisor if you have struggled with academic concerns, excessive absences, incomplete work, difficulty with the course content, or other issues affecting your coursework. This warning is not an official grade, yet it indicates concerns about your progress that need to be addressed immediately. Since the Reach Out provides essential notices by email, a course requirement is that you check your RiverMail account frequently and respond quickly if you receive an email message regarding a Reach Out from River Support. If you are contacted from an Advisor regarding a Reach Out, please respond to those individuals and also visit me during my office hours so we may talk about strategies for how you can be successful in this class.
No disruptions, disrespectful behavior, or violation of the student code will be tolerated. IRSC and your instructor are committed to maintaining standards of academic honesty; integrity is a shared responsibility. All students are expected to know and comply with the IRSC Academic Integrity Policy which prohibits dishonesty in any form, including, but not limited to cheating, plagiarism, fabrication, and other forms of misconduct.
No food or open drinks are permitted in the classroom. No cell phone use is allowed in the classroom and should be turned off during lectures and presentations.
Grading Procedures: 50% - Exercises & Projects
40% - Unit Exams
10% - Cumulative Final Exam
A - Excellent 90% – 100% D - Below average 60% - 69%
B - Above average 80% – 89% F - Failure 0% – 59%
C - Average 70% – 79%
Withdrawal: Students are encouraged to contact the instructor anytime they are not achieving their intended level of success prior to taking any other action. Students may withdraw from the course and receive a grade of “W” prior to Thursday, November 7, 2013. Students who simply do not attend class and who do not officially withdraw from the course will receive a failing grade. Withdrawal requires that you submit an official IRSC form through an Educational Services office on any campus or through online submission at https://esweb.irsc.edu/Mariner/navigate/student.jsp.
Labs: You are welcome to use the IRSC Computer Labs (in V214 and 3rd floor of library on the Main Campus, Room J211 in St. Lucie West, Room 19 in Stuart, and Room V114 in Vero Beach) at times as noted on the lab doors. The employees who supervise the labs are there to provide general guidance in using lab equipment, but are not expected to be familiar with all software used in each course. See your instructor during office hours for help on software and other class topics.
Additional information: The maintenance and security of your textbook and storage media is your responsibility. The loss of these items does not exempt a student from his or her class/homework responsibilities.
The American workplace has come to greatly value formal credentials. Degrees, certificates and licenses of all sorts have been widely embraced in many industries as a "ticket to upward mobility", and their significance will no doubt grow in the future. This course is a requirement of one or more degree or certificate programs at IRSC. You are strongly encouraged to consider the advantages of completing a technical certificate and an Associate of Science (A.S.), Associate of Applied Science (A.A.S.) or Associate of Arts (A.A.) degree.
Please note: Access on Indian River State College computer equipment of materials of a sexually or ethnically derogatory nature is in violation of the college policy on harassment, which assures a positive learning environment. Violation may result in disciplinary action.
Last updated: 1/8/14
3