Department of Mathematics and Computer Science

Adelphi University

Fall 2016

 

 

0145-170-003 & 004  

Introduction to Computers and Their Applications - 3 credits

ONLINE

Adjunct Professor Kristin Pepper

Science 409

(516) 297-5241

pepper@adelphi.edu

www.adelphi.edu/~pe16132

 

Office Hours

Friday 1:00 - 3:00  Online  (click the blue hangout button in your course and then call my cell 516-297-5241)

Post questions in the General Course Discussion Questions, which will email me and be available to all students for answers, plus feel free to email me directly with any private concerns.  

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. 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 and Excel projects to demonstrate proficiency with features such as table of contents, page numbering, headers and footers, relative vs absolute references, formulas, functions and charting. Students will find numerical data to support a thesis, present a graph built in Excel and discuss inferences from the data. 

 

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
Draw meaningful inferences from numerical data

IT Ethics - focus on social networking

Creating a web site and managing files

Information Literacy Topics:

  • Citing Your Work
  • Evaluating Sources
  • Information Resources

Major Assignments

Word: Picture Album 

Excel: Inventory Spreadsheet & Data Analysis Chart

Web: Greeting Card page and Final website

Computer Literacy: Hardware Comparison Spreadsheet

Ethics & Information Literacy: Social Network project

 

No software needs to be purchased, though you may prefer to purchase MS Office. Most assignments provide tutorials for Open Office, a free alternative to MS Office for both mac and windows. Adelphi Lab computers all have MS Office. 

 

Grading

20% will be dropped for anything 1 week late, and some assignments cannot be handed in 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 60. A+ is given at the professor's discretion.

The final grade will be a traditional letter grade (A-F).  

Grade Percentages:

Task(s)

Weight

Social Networking Project (including Data Analysis)

20

Final website

10

Excel Mastery: Inventory Spreadsheet  

10

Word Mastery: Picture Album 

5

Hardware Mastery: HW Comparison Spreadsheet

5

Hardware Quiz

5

Weekly Assignments

35

Discussions / Participation

10

 

 

Responsibility for Online Work

Students are responsible for handing in all assignments on time. Work is due by the Friday at 11:55 pm (just before midnight) unless otherwise stated.  Submit questions to the general course discussion questions 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; 

 

Attendance for an online course is measured by some participation during the week. Every week requires that you click at least a few Moodle links and do the activity it launches.

 

The participation grade will be based heavily upon discussions but will also be effected by submitting work every week and any extra effort made in helping classmates.

 

Exams have to be taken before the stated due date. The decision to allow a make-up exam later will be made in accordance with the policies of Adelphi University.

 

If the University is closed for any class session due to an emergency, check your Moodle News on snow closing days as due dates may be adjusted by the professor in very rare cases. Usually the schedule will remain the same.

 

Moodle

All course materials will be delivered through Moodle.  A Moodle tutorial can be found at http://fcpe.adelphi.edu/moodle/student/

 

 

Tentative Schedule (Subject to Change).

 

Date

Week #

Subject

Quizzes and Major Assignments due

8/29 – 9/2

1

Introduction to Online Week

Download software

Social Networking Discussion - Critical Thinking

Social Network Discussion

9/3 – 9/9

(holiday 9/3 – 9/5)

2

Word Week

Word  Table of Contents, Section Control

Social Networking Discussion – Probing Questions

Picture Album

9/10 – 9/16

3

Information Literacy Week

Find, cite and evaluate sources 

Online library how to start a paper course

Social Networking Discussion – Probing Questions

Draft Thesis and Bibliography

9/17 – 9/23

4

Annotation  and Intro to Excel

Thesis rework

Annotation Due

Excel Introduction: layout and basic calcs and functions

One Annotation

Excel Intro Exercise 

 9/24 – 9/30

9/26 – last day to drop a course

5

Excel Basics Week

Excel :  absolute reference,   % of one total; if statement

Excel Stats Workbook

 

10/1 – 10/7

6

Excel Inventory Week

Start Inventory spreadsheet

Charts

Excel Inventory sheet 1

 

Chart

10/8 – 10/14

7

Excel Advanced Week

More Excel: Fix broken workbooks

Final Thesis work

Good charting guidelines

Excel inventory - all 4 sheets

 

Final Thesis and Bibliography

10/14 – 10/21

8

Excel Mastery Week

Excel Macro, Mail Merge, Filters, Pivot, Lookup, Internet Data analysis, VBA

 

Cover letters

 

Internet Data Analysis

 

10/22 – 10/28

9

Literacy - Graphing numerical data

Find numerical data discussion

Social Networking Graph Analysis

10/29 – 11/4

11/2 – last withdraw date

10

Hardware Week

Computer hardware terminology and components

Protecting your computer

Comparing  advertised computers

 

 Hardware Comparison

 

Hardware quiz

11/5 – 11/11

11

Social Network Project Completion

Social Network Project Final Submission

11/12 – 11/18

12

Web Introduction Week

Web and Filezilla intro

Create a first web site on panther 

11/19 – 11/22

11/23 – 27 Thanksgiving break

13

Web Card Week

Picture, background and email link

Basic web design practice

Begin CodeAcademy if you choose that path

  

 

Web Card 

11/28 – 12/2

14

Web Project Week

Introduce Web Project

Power Point

 

12/3 – 12/9

15

Advanced Web Week
Web Project Work

 

12/10 – 12/16

Final

12/12 last day of classes

12/16 our final day

Online Web Project Due

 

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 significantly impact your ability to carry out assigned coursework, please contact the Student Access Office (SAO) at 516-877-3145 or send an email to sao@adelphi.edu.  The staff will review your concerns and determine, with you, appropriate and necessary accommodations.  Please allow for a reasonable time frame for requesting ASL Interpreters or Transcription Services.

 

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
The Code of Academic Honesty prohibits behavior that can broadly be described as lying, cheating, or stealing. Violations of the Code of Academic Honesty will include, but not be limited to, the following:

1.     Fabricating data or citations

2.     Collaborating in areas not approved by the professor

3.     Unauthorized multiple submission of one’s own work

4.     Sabotage of others' work, including library vandalism or manipulation

5.     Plagiarism

6.     The creation of unfair advantage

7.     The facilitation of dishonesty

8.     Tampering with or falsifying records

9.     Cheating

10.  Other forms of academic dishonesty”

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.