Course Syllabus -- Course Revision Proposal
Department of Mathematics and Computer Science, Lincoln University





COURSE ID: CSC-151
COURSE NAME: Computer Applications
CREDITS: 3

TEXT BOOK:

    Microsoft Office 2000, Timothy J. O'Leary and Linda I. O'Leary
    Instructor handouts for C++ and HTML

INSTRUCTOR INFORMATION:

***To be provided for each section***

COURSE DESCRIPTION:

    This course is designed to give the students an introduction to applications of computers in the area of spreadsheets, database management, presentation, structured programming, and web programming. Desktop software such as Microsoft office as well as a programming language compiler will be utilized in this course.

PREREQUISITE:         MAT 103 (Algebra I) or Placement

Please note: Most students have some previous word processing skills; if not, the students should inform their instructor to get additional help/ tutoring.

STUDENT LEARNER OUTCOMES:

    The student will
  • Demonstrate skills in utilizing modern windows-based desktop software in terms of the set of available command menus and toolbars (Assessed through class work, projects, and practical tests).
  • Exhibit skills in designing useful/ efficient spreadsheets in general; and budgeting, statistical, and presentation type spreadsheets in particular, with an emphasis on accurate mathematical calculations (Assessed through projects, and written tests).
  • Organize and manage data using database software and demonstrate introductory knowledge in database design (Assessed through projects and a practical test).
  • Apply HTML tags to create and design web pages.
  • Demonstrate introductory skills in application of a structured programming language such as C++ to problem solving (Assessed through test and project).
  • Design presentation slides using presentation software such as PowerPoint (Assessed by portfolio presentation).
      Note: Typing skills are not part of this course and are not taught in this course.


TENTATIVE SCHEDULE:

    WEEK 1-5    --Creating Worksheets with MS Excel
    . Excel menus and toolbars
    . Formatting data
    . Shading/ Borders
    . Using formulas
    . Pointing and blocking techniques
    . Sorting
    . Math functions
    . Business functions
    . Data Base Functions
    . Text Functions
    . Lookup functions
    . Logical Function
    . Misc. Function
    . Creating graphs and charts
    . Applications of Spreadsheets
    Test #1 (100 points, practical)
    Spreadsheet projects

    WEEK 6-7    --HTML programming and Web-related Topics and the use of FrontPage
    . Basic HTML tags
    . Creating links
    . Managing Images
    . FrontPage menus and toolbars
    . Test #2 (100 points, Written)
    . HTML project (s) due

    WEEK 8-11    --Introduction to C++ Programming
    . IO streams; cin/ cout statements
    . Selection statements; if, if-else statements
    . Looping; while and for statements
    . Applications of structured programming (Problem solving)
    . Test #3 (100 points, Written)
    . C++ project (s) due

    WEEK 12-16    --Data Base Management with MS Access
    . Access menus and toolbars
    . Designing a database
    . Designing tables
    . Linking tables
    . Creating Queries
    . Form design
    . Report generation
    . Sorting
    . Functions
    . Application of Data Base Management Systems
    . Test #4 (100 points, Practical)
    . Database projects Due


    WEEK 1-16 (combined with the first three parts)
    
    --Introduction to Presentation Packages using PowerPoint
           Note: Some of spreadsheets and database assignments are presented as slides created with PowerPoint.

    . PowerPoint menus and toolbars
    . Designing and creating a presentation
    . Working within a presentation
    . Slides
    . Animation

Final exam (100 points, cumulative and written), during the official final exam period.


ASSESSMENT:*

The grades will be evaluated based on the practical and written tests/ quizzes as follows.

Tests (written and practical including final): 80%
Assignments: 15%
In-class computer work: 5%


The grading scale guideline: **
A       92-100%
A-       88-91%
B+      85-87%
B      82-84%
B-      78-81%
C+       75-77%
C       72-74%
C-      68-71%
D+      65-67%
D      58-64%
F      0-57%

University Policies:

1) Attendance:

Lincoln University uses the class method of teaching, which assumes that each student has something to contribute and something to gain by attending class. It further assumes that there is much more instruction absorbed in the classroom than can be tested on examinations. Therefore, students are expected to attend all regularly scheduled class meetings and should exhibit good faith in this regard. For the control of absences, the faculty adopted the following regulations:

  • Four absences may result in an automatic failure in the course.
  • Three tardy arrivals may be counted as one absence.
  • Absences will be counted starting with whatever day is specified by the instructor but not later than the deadline for adding or dropping courses.
  • In case of illness, death in the family, or other extenuating circumstances, the student must present documented evidence of inability to attend classes to the Vice President for Student Affairs and Enrollment Management. However, in such cases the student is responsible for all work missed during those absences.
  • Students representing the University in athletic events or other University sanctioned activities will be excused from class (es) with the responsibility of making up all work and examinations. The Registrar will issue the excused format to the faculty member in charge of the off- or on-campus activity for delivery by the student(s) to their instructors.
2) Statement on Academic Integrity:

Students are responsible for proper conduct and integrity in all of their scholastic work. They must follow a professor's instructions when completing tests, homework, and laboratory reports, and must ask for clarification if the instructions are not clear. In general, students should not give or receive aid when taking exams, or exceed the time limitations specified by the professor. In seeking the truth, in learning to think critically, and in preparing for a life of constructive service, honesty is imperative. Honesty in the classroom and in the preparation of papers is therefore expected of all students. Each student has the responsibility to submit work that is uniquely his or her own. All of this work must be done in accordance with established principles of academic integrity.

An act of academic dishonesty or plagiarism may result in failure for a project or in a course. Plagiarism involves representing another person's ideas or scholarship, including material from the Internet, as your own. Cheating or acts of academic dishonesty include (but are not limited to) fabricating data, tampering with grades, copying, and offering or receiving unauthorized assistance or information.

3) The Student Conduct Code:

Students will be held to the rules and regulations of the Student Conduct Code as described in the Lincoln University Student Handbook. In particular, excessive talking, leaving and reentering class, phones or pagers, or other means of disrupting the class will not be tolerated and students may be asked to leave. Students who constantly disrupt class may be asked to leave permanently and will receive an F.

4) The Core Curriculum Learner Competencies:

All courses offered through the Department of Mathematics and Computer Science require students to meet at least the following out of the 8 Core Curriculum Learner Competencies:

(1) Listen and effectively communicate ideas through written, spoken, and visual means;
(2) Think critically via classifying, analyzing, comparing, contrasting, hypothesizing, synthesizing, extrapolating, and evaluating ideas;

(6) Apply and evaluate quantitative reasoning through the disciplines of mathematics, computational science, laboratory science, selected social sciences and other like-minded approaches that require precision of thought;

(8) Demonstrate positive interpersonal skills by adhering to the principles of freedom, justice, equality, fairness, tolerance, open dialogue and concern for the common good.



Note:

* The instructor of a given section of the course may make some modifications to the evaluation as well as to the rest of the syllabi including but not limited to; the grade weights, number of tests, and test total points.

**The grading scale guideline includes a 2-point flexibility.

Please consult with the department chairperson for any program updates or corrections which may not be yet reflected on this page _ last updated 10/30/2007.

Lincoln University of the Commonwealth of Pennsylvania
1570 Baltimore Pike, P.O. Box 179, Lincoln University, PA 19352 \ (610) 932-8300 \
Internet Privacy Policy, © Copyright, Lincoln University.