Department of Mathematics and Computer Science, Lincoln University
Microsoft Office 2003 (Plus Edition), Author: Robert T. Grauer and Maryann Barber
Instructor handouts for C++ and HTML
***To be provided for each section***
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 098 (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.
COURSE GOALS- STUDENT LEARNER OUTCOMES
The student will
TENTATIVE SCHEDULE OF WEEKLY ASSIGNMENTS:
WEEK 1-5 --Creating Worksheets with MS Excel
. Excel menus and toolbars
. Formatting data
. Shading/ Borders
. Using formulas
. Pointing and blocking techniques
. 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)
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
. 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
Final exam (100 points, cumulative and written), during the official final exam period.
COURSE ASSESSMENT- LEARNING OPPORTUNITIES*
GRADING STANDARDS- ASSESSMENT TOOLS
The grades will be evaluated based on the practical and written tests/ quizzes as follows.
The grading scale guideline: **
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:
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.
* 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 11/20/2007.