ÿþ<HTML><HEAD><TITLE>Syllabus</TITLE></HEAD> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: center" align=center><B><SPAN style="FONT-SIZE: 16pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">ITSW 2334<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></B></P> <H5 style="MARGIN: 0in 0in 0pt" align=center><SPAN style="FONT-SIZE: 16pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Advanced Spreadsheets<o:p></o:p></SPAN></H5> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P> <P class=Preformatted style="MARGIN: 0in 0in 0pt; tab-stops: .5in; mso-list: skip"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">INSTRUCTORS:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">R. Craig Collins</SPAN></P> <P class=Preformatted style="MARGIN: 0in 0in 0pt; tab-stops: .5in; mso-list: skip"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">OFFICE LOCATION:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Room 507</SPAN></P> <P class=Preformatted style="MARGIN: 0in 0in 0pt; tab-stops: .5in; mso-list: skip"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">OFFICE PHONE:</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(254) 298-8461</SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">E-MAIL:</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;</SPAN><A href="mailto:craig.collins@templejc.edu"><FONT size=3>craig.collins@templejc.edu</FONT></A> <o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">WEB ADDRESS:<SPAN style="mso-spacerun: yes">&nbsp;&nbsp;<A href="http://www.templejc.edu/dept/cis/CCollins/collins.htm">http://www.templejc.edu/dept/cis/CCollins/collins.htm</A></SPAN></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">PREREQUISITE:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">None, but a working knowledge of MS Office XP is expected.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">TEXTBOOK USED:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><I><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">Microsoft Office Excel 2003 Second Edition </SPAN></I><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic">by Parsons, Oja, Ageloff, and Carey</SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Published by Course Technology.</SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">OTHER MATERIALS:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">a computer with Internet access and a CD-ROM drive (the college computer labs are available), pen drive or CDs for storing work.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">HOURS:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Three semester hours of college credit is given.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Two lecture hours.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Two lab hours.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto; mso-layout-grid-align: none"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">COURSE DESCRIPTION:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; COLOR: #231f20; FONT-FAMILY: Arial">Designed to provide an understanding of advanced functionality of electronic spreadsheets</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: #231f20; FONT-FAMILY: Arial">.</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">This class is not intended for transfer to a four-year institution.<o:p></o:p></SPAN></B></P> <P style="MARGIN: 5pt 0in 6pt 0.5in; TEXT-INDENT: -0.5in"><FONT size=3><B style="mso-bidi-font-weight: normal"><SPAN lang=EN style="COLOR: black; FONT-FAMILY: Arial; mso-ansi-language: EN">LEARNING OUTCOMES</SPAN></B><SPAN lang=EN style="COLOR: black; FONT-FAMILY: Arial; mso-ansi-language: EN">:&nbsp; Use spreadsheet applications to create and design macros; use database and data analysis features; and devise solutions using linked worksheets. <o:p></o:p></SPAN></FONT></P> <P style="MARGIN-LEFT: 0.5in; TEXT-INDENT: -0.5in"><FONT size=3><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-FAMILY: Arial">ATTENDENDANCE:</SPAN></B><SPAN style="FONT-FAMILY: Arial"><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Students are expected log on to the Desire 2 Learn site at least once a week to check due dates, discussions, chats, or turn in work (see "ATTENDANCE" in the student handbook for <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:place w:st="on"><st1:PlaceType w:st="on">Temple</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place>).<o:p></o:p></SPAN></FONT></P> <P style="MARGIN: 5pt 0in 6pt 0.5in; TEXT-INDENT: -0.5in"><FONT size=3><B><SPAN style="FONT-FAMILY: Arial">EXPECTATIONS:</SPAN></B><SPAN style="FONT-FAMILY: Arial"><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>If you must miss a due date, notify me BEFORE that date to make arrangements for turning in assignments. If you do not notify me in advance, <B>no late work will be accepted</B>. Homework due dates are posted in D2L. <B style="mso-bidi-font-weight: normal">No makeup test</B>. Test dates are also posted on D2L.</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">EVALUATION:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Final grades will be made up of Tests, Labs, and Homework as follows:<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 40.3pt; TEXT-INDENT: -0.5in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: 0.2pt; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Online Test Average<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= 40% of Final Grade<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: 0.2pt; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Hands-on Test<SPAN style="mso-tab-count: 2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= 20% of Final Grade<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: 0.2pt; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Case Problems<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= 20% of Final Grade<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: 0.2pt; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Review Questions<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= 20% of Final Grade<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></P><B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-ansi-language: EN-US; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><BR style="PAGE-BREAK-BEFORE: always" clear=all></SPAN></B> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; TEXT-INDENT: 0.2pt"><B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">GRADING SCALE</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Final grades will be assigned as follows:<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">90 and above<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= A<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">80 to 89<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= B<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">70 to 79<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= C<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">60 to 69<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= D<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; tab-stops: 2.0in"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Below 60<SPAN style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>= F<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">SCHOLASTIC INTEGRITY</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Please refer to <I style="mso-bidi-font-style: normal">Scholastic Integrity</I> in the Student Handbook, page 10.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Your work <B style="mso-bidi-font-weight: normal">MUST</B> be your own and <B style="mso-bidi-font-weight: normal">MUST NOT</B> be copied or shared with other students.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Scholastic dishonest will not be tolerated.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>If you are caught cheating on any work, you will receive an  F for the entire course.<o:p></o:p></SPAN></P> <P style="MARGIN: 5pt 0in 6pt 0.5in; TEXT-INDENT: -0.5in"><FONT size=3><B><SPAN style="FONT-FAMILY: Arial">DISRUPTIVE BEHAVIOR:</SPAN></B><SPAN style="FONT-FAMILY: Arial"><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Please refer to Disruptive Behavior in the Student Handbook, page 32. Any student who engages in such behavior will be asked to leave the lab/classroom and may be subject to removal from this course.<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">DEPARTMENT POLICY</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>It is the policy of the Computer Information Systems department that no unauthorized personnel are allowed in any of the computer rooms (such as a child of a student taking a class).<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>An authorized person is a student enrolled in a computer information systems class.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Violation of this policy could result in you losing your lab privileges.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 0.5in; TEXT-INDENT: -0.5in; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial">LAB ETIQUETTE</SPAN></B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial">:<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>Pagers and cell phones will be turned off in <st1:place w:st="on"><st1:PlaceType w:st="on">Temple</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place> labs. Please show courtesy to others by restricting conversation to course topics, and raise your hand to gain attention when asking a question or need help of the lab assistant.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 6pt 4.5pt; mso-margin-top-alt: auto"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Instructor reserves the right to modify course requirements at any time based on the professional judgment of the instructor.</SPAN></B><SPAN style="FONT-FAMILY: Arial"> </SPAN><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"><o:p></o:p></SPAN></B></P></HTML>