Department of
Mathematics and Computer Science
Adelphi University
Spring 2014
|
0145-170-002 |
Introduction to
Computers and Their Applications - 3 credits TR 10:50am-12:05pm in SCB 227 Some Thursdays, but
not all, will be online Adjunct
Professor Kristin Pepper 102
/ 103 Post Hall (516)
297-5241 |
|
Office Hours |
Tuesday
and Thursday 12:15 – 1:15 |
|
Course Description
and Purpose |
Learn
to use common computer applications (e.g. word processing, presentation,
spreadsheets, databases, Web authoring, search engines), and also discuss
social and ethical issues related to computing and telecommunications. |
|
Gen Ed Learning Goals and
Distribution Requirements |
Information
Literacy Quantitative
Reasoning |
|
Course Learning
Goals |
Students
will engage in online learning in this blended course. Students will interpret
technical specifications in computer advertisements as demonstrated by
specifying a new computer and defending their choices. Students will design
and publish a cohesive web site using free web design, graphics and ftp
tools. Students will apply basic information literacy skills of locating,
evaluating and citing scholarly sources when writing an annotated
bibliography on an information technology topic. Students will implement
Word, Excel and PowerPoint projects to demonstrate proficiency with features
such as table of contents, page numbering, headers and footers, master pages,
relative vs absolute references, formulas, functions and charting. |
|
Prerequisite |
None |
|
Recommended Texts |
A
flash drive is recommended. There
is no required text for this course. Required materials are freely available
online through Moodle. The following books will be placed on reserve at the
Adelphi library. Please choose the version that matches the software you use
at home: Parsons, June Jamrich
and Dan Oja. Computer
Concepts, 2014 : Comprehensive Boston,
Massachusetts: Course Technology, 2013. (ISBN: 978-1285096926) Shaffer, Ann. New Perspectives on Microsoft Office 2007,
First Course, Windows XP Edition. . Boston, Massachusetts: Course Technology,
2008. (ISBN 978-1-4239-0577-6) LC CALL:
HF5548.4.M525 N4885 2008 Beskeen, David W. Microsoft Office 2007:
illustrated, Windows vista edition. Boston, Massachusetts:
Course Technology, 2008 (ISBN: 9781423905592) LC CALL: HF5548.4.M525 M524988
2008 Shaffer, Ann. New Perspectives on Microsoft Office 2010, First Course. Boston,
Massachusetts: Course Technology, 2010. (ISBN 978-0538746533 ) LC CALL: TBA
on order Shaffer, Ann. New Perspectives on Microsoft Office 2013. Boston, Massachusetts:
Course Technology, 2013. (ISBN 978-1285167640) LC CALL: TBA on
order |
|
Topics |
Word
and graphics Excel
Specifying
your computer system Interoperation
of products with Mail/Merge Access
as an extension of Excel IT
Ethics - focus on social networking Creating
a web site and managing files Information
Literacy Topics:
|
|
Major Assignments |
Word:
Picture Album Excel:
Inventory Spreadsheet & chart Web:
Greeting card page and Final website Computer
Literacy: Hardware Configuration Spreadsheet Ethics
& Information Literacy: Research Annotation report on Ethics relating to
social networking or other information technology ethical issue No
software needs to be purchased. Assignments can be done on any computer
version of either MS Office or the free Open Office. Adelphi Lab computers
can be used as well. |
|
Grading |
The
midterm must be completed as a minimum for credit. Each exam must be taken at
the time scheduled. 10% will be dropped for anything 1 week late. Be sure to back up your classwork
frequently so that you do not lose work. The
course grading scale is: A 93-100, A- 90-92, B+ 87-89, B 83-86, B- 80-82, C+
77-79, C 73-76, C- 70-72, D 60-69, and F is below 59. A+ is given at the
professor's discretion. The
final grade will be a traditional letter grade (A-F). Excessive absences,
lateness, and any activities which run counter to the best interests of the
class will be deducted at the end of the semester from the final grade as a
percentage to be determined by the professor. Grade
Percentages: Midterm Exam - 20% Quizzes - 10% Assignments - 45% Web, Access and Data Exam - 15% Final project - 10% |
|
Responsibility for
Online Work |
Students
are responsible for checking Moodle announcements on each on-line day. Work is due by
the on-line day unless otherwise stated. (Extra help arrangements can be made
easily and often the help can be given online.) Submit questions to the help
discussion board. You can also call 877-3340 for Adelphi Customer Service, or
call my number above and leave a message with your phone number. |
|
Attendance |
The
following is the Adelphi University General Attendance Policy: Only students who are registered for courses, and whose
name appears on the Official Class Roster may attend courses at the
University. Adelphi students make a commitment to be active participants in
their educational program; class attendance is an integral part of this
commitment. Attendance requirements for each course will be announced by the
faculty member at the beginning of each term. Students are expected to be
present promptly at the beginning of each class period, unless prevented by
illness or by other compelling cause. In the event of such absence, students
may request that faculty members be notified by the Office of Academic
Services and Retention. Students are responsible for completing course work
missed through absences. Students should wait a reasonable length of time for
an instructor in the event that the instructor is delayed. Additionally,
you are also responsible for whatever work is covered in class whether or not
you are there. Absence from the final exam will be excused only for a good
and well-documented reason. The decision to allow a make-up exam will be made
in accordance with the policies of Adelphi University. If the University is closed for more than two
days due to an emergency, log onto this course site under the MOODLE tab in eCampus each day for instructions and assignments. All snow closing days will become online
days, with instructions given on Moodle. |
|
Moodle |
All
course materials will be delivered through Moodle. The All Assignments task
will describe all assignments and due dates. Use Moodle to hand in all
assignments. A Moodle tutorial can be found at http://fcpe.adelphi.edu/moodle/student/
|
Tentative Schedule (Subject to Change). "ONLINE"
means the date is an online day so you should not come to the classroom unless
you arrange it with the professor.
|
Date |
Day |
Subject |
Tests, Quizzes and
Assignments due |
|
1/23 |
R |
Introduction, windows explorer,
Moodle, discussion help board, email forwarding, adobe connect, participant
photo, word (Tables, Styles), Irfanview |
|
|
1/28 |
T |
Word
(Table of Contents, Pagination); macro; track changes; prep for first online
day; Adelphi DB, pagination; Start Word day |
|
|
1/30 |
R@ |
Online
Starter Day & Word Day Verify
environment; download software; PC health Word and Picture practice |
Starter survey and
activities; Picture Album |
|
2/4 |
T |
Hardware: Word system information;
relation of hard disk to windows explorer; Configuration solutions exercises;
computer protection; Introduce online day |
|
|
2/6 |
R@ |
Online
Hardware Day Hardware
Intro Survey Hardware
Q&A HW comparison using Excel |
1)
HW intro survey 2) HW comparison 3) SN Discussion |
|
2/11 |
T |
Social Networking Discussion Review HW comparison spreadsheet; |
|
|
2/13 |
R |
Excel
Intro (layout and basic calcs and functions and
concatenation and some absolute reference) Hardware & Word Quiz |
HW
& Word quiz |
|
2/18 |
T |
absolute reference dealing % of one
total; if statement |
|
|
2/20 |
R@ |
Online
Excel Inventory Day Start
Inventory spreadsheet Last
Day to drop a course is 2/21 - see Adelphi calendar |
Excel
Inventory sheet 1 |
|
2/25 |
T |
More
Excel: Review (Absolute Reference; If statement); making a web site;
hyperlinks; graphs; mail/merge |
|
|
2/27 |
R@ |
Online
Excel Advanced Day Finish
Inventory Spreadsheet (graph and absolute reference) One
spreadsheet that is helpful to you Excel Practice Survey |
Excel inventory 4
sheets |
|
3/4 |
T |
Macro
Excel
quiz |
Excel
quiz |
|
3/6 |
R |
Access as extension of Excel |
|
|
3/11 |
T |
Midterm preparation |
|
|
3/13 |
R |
Midterm |
Midterm |
|
3/18 |
T |
Vacation |
|
|
3/20 |
R |
Vacation |
|
|
3/25 |
T |
Assign Ethics Report Information Literacy & source
annotations |
|
|
3/27 |
R@ |
Online Information
Literacy |
Citations ex Evaluate Source Find Article ex |
|
4/1 |
T |
Web
and Filezilla intro |
|
|
4/3 |
R@ |
Online
Web Intro Survey Change web from home |
Web
Survey Web
Change from Home |
|
4/8 |
T |
Web Skills - Picture, background and
email link and filesize of pictures and graphics; |
|
|
4/10 |
R |
NO CLASSES AT ADELPHI - Research Day |
|
|
4/15 |
T |
Web Skills needed for project :
explore HTML,
embedding
code; fixing background; adding spaces; meta tags; navigation bar; Start Web
Card |
|
|
4/17 |
R@ |
Online
Web Card Basic web design practice |
Ethics Report Annotations Online Web Card |
|
4/22 |
T |
Power Point Web Quiz |
Web Quiz |
|
4/24 |
R@ |
Online
Day CSS Menu |
|
|
4/29 |
T |
Review for Web, Power Point and Info
Literacy test Introduce Web Project |
|
|
5/1 |
R@ |
Online Web Project
Work Day |
|
|
5/6 |
T |
Web, Power Point and Info Literacy
test |
Web, PPT and Info Literacy Test |
|
5/8 |
R |
Advanced
Web concepts (advertise your site, Web Project Work) |
|
|
5/13
or 15 |
T or R |
Final Workshop: date and time TBA |
|
|
Turnitin |
Adelphi
University has a license agreement with Turnitin.com, a service that helps
prevent plagiarism from Internet resources. I reserve the right to request an
electronic copy of any written assignment submitted in this course for review
through Turnitin.com. Please see Adelphi's tips for students on preventing
plagiarism and student instructions for Turnitin.com for more information. |
|
Students With
Disabilities |
If you have a disability that may impact your
ability to carry out assigned course work, and are not enrolled in the
Learning Disabilities Program, it is important that you contact the staff in
the Disability Support Services Office (DSS), University Center, Room 310,
(516) 877 3145. DSS@adelphi.edu. DSS will review your concerns and determine,
with you, appropriate and necessary accommodations. All information and
documentation of disability is confidential. |
|
Honor Code |
Students
enrolled in this course are expected to abide by the Adelphi University
Honor Code. The purpose of the Honor Code is to protect the academic
integrity of the University by encouraging consistent ethical behavior in
assigned coursework by students. Following is excerpted from the Student
Honor Code: The code of academic honesty prohibits
behavior, which can broadly be described as lying, cheating, or stealing.
Violations of the code of academic honesty will include, but are not limited
to, the following: 1.
Fabricating data or citations 2.
Collaborating in areas prohibited by the professor 3.
Unauthorized multiple submission of work 4.
Sabotage of others' work, including library vandalism
or manipulation 5.
Plagiarism: presenting any work as one's own that is
not one's own 6.
The creation of unfair advantage 7.
The facilitation of dishonesty 8.
Tampering with or falsifying records 9.
Cheating on examinations through the use of written
materials or giving or receiving help in any form during the exam, including
talking, signals, electronic devices, etc. |
|
Student Course Evaluations |
During
the last two weeks of the class, you will receive notification, via mail
and eCampus, that the course evaluation is
available for your input electronically. Availability will
end at the start of the final examination period. Your feedback is valuable
and I encourage you to respond. Please be assured that your responses are
anonymous and the results will not be available to the instructor until after
the end of the semester and therefore after course grades have been
submitted. |