Department of Mathematics and Computer Science

Adelphi University

Fall 2020

 

 

0145-170-001

Introduction to Computers and Their Applications - 3 credits

ONLINE

Adjunct Professor Kristin Pepper

Science 415

(516) 297-5241

pepper@adelphi.edu

www.adelphi.edu/~pe16132

 

Office Hours

Thursday 8-9 am  (call or text my cell 516-297-5241 and  go into zoom  https://adelphiuniversity.zoom.us/j/92141572979 You will go into the waiting room, but need to call me to let you in. )

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 crafting a web site with a bibliography on an information technology issue. 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

Computer with Windows, Mac or Linux operating system, not Chrome OS. Also need the ability to download software on that computer. You don’t need a microphone or camera.

Recommended Texts

A flash drive is recommended.

There is no required text for this course. Required materials are freely available online through Moodle. 

 

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 because all is free or provided by Adelphi. Adelphi provides Office 365 free to students at https://it.adelphi.edu/catalog/microsoft-office-download/ though you can use an earlier Office version for most assignments.  Chrome OS is not sufficient because it cannot use full versions of MS office.  Adelphi Lab computers all have MS Office.

 

Grading

10% 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)

17

Discussions / Participation

10

 

Weekly Assignments

37

 

Mastery Projects

 

  • Excel Mastery: Inventory Spreadsheet  

6

  • Word Mastery: Picture Album 

6

  • Hardware Mastery: HW Comparison Spreadsheet

6

Quizzes

 

  • Hardware Quiz

5

  • Word and Excel Quiz

5

Final website

8

 

 

Responsibility for Online Work

Students are responsible for handing in all assignments on time. Work is due by Saturday at 11:55 pm (just before midnight) unless otherwise stated. (The introduction and first week are due on different days.)  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 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.  Student tutorials for using MOODLE can be found at http://fcpe.adelphi.edu/moodle/student/

 

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).

 

Due Date

Week #

Subject

Quizzes and Major Assignments due

8/31/20

Pre

Getting Started Short Setup

First discussion posting 

9/4/20

1

Introduction to Online Week

Download software

Social Networking Discussion 

Social Network Discussion

9/12/20

2

Word Week

Word Table of Contents, Section Control

Social Networking Discussion

Photo Album

 

9/19/2020

3

Web Introduction Week

Web and Filezilla intro

Social Networking Powerpoint

 

Create a first web site on panther

Social Networking

      PowerPoint

9/26/20

4

Web Card Week

Picture, background and email link

Basic web design practice

Begin CodeAcademy if you choose that path

  

 

Web Card 

10/3/20

5

Information Literacy Week

Find, cite and evaluate sources 

Bibliography

10/10/20

6

Pro/Con Web Pages 

Identify supporting information and develop arguments

Cement ability to link and post web pages

Pro/Con Web Site

10/17/20

7

Excel Basics Week

Excel Introduction: layout and basic calcs and functions

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

Good charting guidelines

Excel Stats Workbook

 

 

10/24/20

8

Excel Inventory Week

Inventory spreadsheet

SN Chart

Excel Inventory

SN Chart

 

10/31/20

9

Excel Graph Questions and Quiz Week

More Excel: Fix broken workbooks

 

Excel and Word Quiz

11/7/20

10

Excel Mastery Week

Excel Macro, Mail Merge,   Pivot, Lookup, Internet Data analysis, Filter

 

Data Analysis

 

11/14/20

11

Literacy - Graphing numerical data

Excel pivot and graph analysis

Social Networking Graph Analysis

11/21/20

12

Hardware Week

Computer hardware terminology and components

Comparing  advertised computers

 

 Hardware Comparison

 

 

11/28/20

 

Thanksgiving break – nothing due

 

12/5/20

13

Web Project Week

Introduce Web Project

Hardware Quiz

12/12/20

14

Advanced Web Week
Web Project Work

 

12/19/20

Final

Web Project Due

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.

 

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”

Recording/Sharing of Video Course Content

Students are prohibited from recording or sharing in any way video content from in-person or online classes with others, pursuant to The Family Educational Rights and Privacy Act (FERPA) (20 U.S.C. § 1232g; 34 CFR Part 99), a Federal law [link] that protects student privacy.  Sharing of content is defined as discussing or disclosing any and all information about a student in the presence of others, electronically, in person, or otherwise.  See also, the Adelphi University Code of Conduct.

 

Student Course

Evaluations

During the last two weeks of the class, you will receive notification, via email 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.

 

 

Student Access Office (SAO)

 

If you have a disability that may significantly impact your ability to carry out assigned coursework, please contact the Student Access Office (SAO) located in Post Hall 107 at 516-877-3806 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.

 

 

Student Counseling Center (SCC)

 

The Student Counseling Center (SCC) provides confidential and professional mental health counseling services, resources, and referrals to support the academic and personal success, health, and well-being of Adelphi students without additional charge. Counselors are available to help students cope with a variety of stressors and personal issues that may interfere with their academic and personal experiences. The Center also supports students who may be feeling suicidal or in crisis. To schedule an appointment, please call (516) 877-3646, email scc@adelphi.edu or stop by the SCC. If you need immediate assistance, walk-in services are available during the fall and spring semesters Monday-Thursday, 8:30am-7:00pm; Friday 8:30am-4:00pm. Additional information can also be found by visiting https://scc.adelphi.edu.

Need support when the SCC is not available? For 24/7 emergency counseling, referral, or assistance, please contact:

Long Island Crisis Center (516) 679-1111

National Suicide Prevention Lifeline (800) 273-TALK (8255)

Crisis Text Line: Text 741741

Adelphi Office of Public Safety:

Off campus: (516) 877-3511

On campus: Extension 5 on any campus phone

911 (for immediate health-related emergency)

 

Learning and Writing Centers (LWC)

 

The Learning and Writing Centers assist students in all disciplines to become more effective and confident writers and scholars. Peer tutors are available for free for students of all levels. Appointments are recommended, and can be reserved online at https://adelphi.mywconline.com/index.php, accessible through our E-campus service tab. The most timely information for students is available through the LWC Instagram account: https://www.instagram.com/au_lwc/ . More information is available on Youtube.
If you are interested in learning more about the services available at the Learning and Writing Centers, visit
https://writing.adelphi.edu/ or https://learning.adelphi.edu. Call 516.877.3200 or stop by our locations any time.