School of Mathematics & Computer Science

Adelphi University

 

Course#: CSC (0145) 170 003 Introduction to Computers and their Applications

 

Class Time:

TR 10:50am to 12:05pm SCB*227

Some Tuesdays (but not all) will be online

 

Instructor: Professor Pepper

Office: POST 103 1rst Floor or Post 217 2nd Floor

Telephone: 516-297-5241

Office Hours: Thursday: 8:40 to 10:40

E-mail: pepper@adelphi.edu

http://www.adelphi.edu/~pe16132

 

Moodle: https://ecampus.adelphi.edu/

 

Starter Day Address: http://home.adelphi.edu/~pe16132/csc170/csc170hybrid/starterday.htm

Text:

There is no required text for this course. The following books will be placed on reserve at the Adelphi library:

Parsons, June Jamrich and Dan Oja. Computer Concepts, 2010 : Comprehensive Boston, Massachusetts: Course Technology, 2010. (ISBN: 9780324780840 ) LC CALL: QA76 .P372 2010

Shelly, Gary B. Microsoft Office 2003 : Introductory Concepts and Techniques : course one. Boston, Massachusetts: Course Technology, 2006 (ISBN 0619254858) LC CALL: HF5548.4.M525 S535 2006

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

Catalog Description

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.

Objectives:

  • Understand basic computer hardware and software concepts and terminology
  • Be able to use a spreadsheet, word processor, presentation tool, database tool (MS Office) and web development tool
  • Investigate IT ethical issues
  • Understand web concepts and be able to post your own web site
  • Understand the structure of the data you will encounter in at least one industry

 

Major Assignments:

    • Word: Picture Album
    • Excel: Inventory Spreadsheet & chart
    • Web: Greeting card page and Final website
    • Ethics & Information Literacy: Research report on Ethics relating to social networking

 

Grading System

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

15%

Assignments

38%

Web, Access and Data Exam

15%

Final project

12%

Course Requirements

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.

Defective or lost floppy disks or flash drives, printer malfunctions, hard drive crashes, and computer meltdowns are not valid excuses for late or incomplete assignments. Be sure to backup, and use another computer if yours becomes disabled. When a particular assignment hand-in path is down, use another path: e-mail, ftp to panther, Moodle submission, hand in to my mailbox in the math department.

Students will be expected to minimize grammatical errors, develop presentation skills, use logic, and create effective strategies to communicate clearly. Moodle Discussion Guidelines - Use proper English (not IM English). "I agree" and similar replies will not be counted as entries.

Responsibility for Online Work

Students are responsible for checking Moodle announcements on each on-line day. Work is due by the end of 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.

Students are expected to follow Adelphi's honesty policies, including never "presenting any work as one's own that is not one's own." See http://academics.adelphi.edu/policies/honesty.phphttp://academics.adelphi.edu/policies/honesty.php

Attendance Requirements

It is expected that students will attend class on a regular basis, and will attend class if the online schedule changes. Sometimes online days become optional when students need extra help. It is expected that students will make use of these days for extra help and making up tests, so it is best to not commit to other activities during online class hours.

Absences for legitimate reasons are permissible; however, students are responsible for all material missed during their absence. Out of consideration for the instructor and the rest of the class, you are expected to arrive on time for class and stay until the class is over. Ask questions so that all present can hear; private conversations are not permitted.

Policy on Incomplete

Refer to the Under-graduate Bulletin. If you do not have a bulletin, please obtain one from the Dean's Office. It contains a significant amount of important and useful information such as prerequisites, waiver policy, rules and regulations, payment plans and schedules.

Last Date to Drop Course

The last date to drop this course will be the last date specified by the University for students to drop the course without the professor's permission. If the student wishes to drop the class after that time because of poor grades, it will be necessary to first obtain written permission from the Dean of Academic Attainment or the Dean of the School of Business. Permission to withdraw late because of other reasons may be presented to me or the Deans.

Disabilities

If you have a physical, medical or learning disability and require accommodations, please contact the Office of Disability Support Services (DSS) to discuss these accommodations. DSS is located in the University Center Room 310 at 516-877-3145.

Schedule

"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/24

T

Introduction, windows explorer, Moodle, discussion help board, email forwarding, adobe connect, participant photo, word (Tables, Styles), Irfanview

 

1/26

R

Word (Table of Contents, Pagination); macro; track changes; prep for first online day; Adelphi DB, pagination;

Start Word day

 

1/31

T@

Online Starter Day & Word Day

Verify environment; download software; PC health

Word and Picture practice

 Starter survey and activities; Picture Album

2/2

R

Word/ Windows Quiz;

Hardware: Word system information; relation of hard disk to windows explorer; Configuration solutions exercises; computer protection; Introduce online day

Word / Windows Quiz

2/7

T@

Online Hardware Day

Hardware Intro Survey

Hardware Q&A

HW comparison using Excel

1) Hardware intro survey

2) Excel HW comparison due

 

2/9

R

Review HW comparison spreadsheet;

 

2/14

T

Excel Intro (layout and basic calcs and functions and concatenation and some absolute reference)

Excel quick intro

Excel reading

Excel Q&A

Hardware Quiz

HW quiz

2/16

R

absolute reference dealing % of one total; if statement

 

2/21

T@

Online Excel Inventory Day

Start Inventory spreadsheet

Last Day to drop a course is 2/21 - see Adelphi calendar

Excel Inventory sheet 1

2/23

R

More Excel: Review (Absolute Reference; If statement); making a web site; hyperlinks; multiple sheets, graphs

Excel mail/merge; problem sheets

 

2/28

T@

Online Excel Advanced Day

Finish Inventory Spreadsheet (graph and absolute reference)

One spreadsheet that is helpful to you

Excel Practice Survey

Excel 3 inventory sheets due. plus one sheet that helps you

3/1

R

Excel quiz

Mail Merge & Macro

Excel quiz

3/6

T

Midterm preparation

 

3/8

R

Midterm

 Midterm

3/13, 3/15 - break

 

 

 

3/20

T

Access as extension of Excel

 

3/22

R

Information Literacy 1 & 2

 

3/27

T

Information Literacy 3

Assign Ethics Report

Last Day to withdraw from a course is 3/27 - see Adelphi calendar

Citations ex

Evaluate Source ex

3/29

R

Web and Filezilla intro

Information Literacy Quiz

Info Literacy Quiz

Find Article ex

4/3

T@

Online Web Intro

Survey

Change web from home

Web Survey

Change from Home Try

4/5

R

Web Skills - Picture, background and email link and filesize of pictures and graphics; Start Web Card

 

4/10

T@

Online Web Card

Basic web design practice

Online Web Card

4/12

R

Web Skills needed for project : explore HTML,  embedding code; fixing background; adding spaces; meta tags; navigation bar

Web quiz

4/17

T@

Online Final Project Layout

Ethics Report

4/19

R

Web Quiz

 

4/24

T

Review for Web, PPT and Info Literacy test

 

4/26

R

Web, PPT and Info Literacy test

Web, PPT and Info Literacy Test

5/1

T@

Online Web Project Day

Begin project with at least 1 page complete

 

5/3

R

Advanced Web concepts (advertise your site, CSS menu, Web Project Work)

 

5/8, 5/10 - makeup

T

 

 

5/15

T

Final Workshop: Tuesday 5/15 10:30 am to 12:30 pm in your classroom