Suggested Surfing: Microsoft Office Web Site
COURSE DESCRIPTION: An overview of the computing
field and its typical applications. Covers key terminology components of computer
hardware, software, and operating systems. Other topics include system development
methods, management information systems, programming languages, communications,
networks, application software, the Internet and career opportunities. Microcomputer
applications include word processing, spreadsheet, database, and presentation
software in a Windows environment.
RULES: Students are expected to be on time and attend every class (unless prior arrangements have been made). Class attendance can affect your final grade, as every two unexcused absences may result in the reduction of your final grade by one letter grade. Being five or more minutes late constitutes being absent. Once the door to the classroom has been closed, you will not be permitted to enter the classroom. Missing 4 classes or 2 assignments will result in non pursuit of course objectives and automatic withdrawal.
No assignment will be accepted after class has begun on the due date. Note: This course relies heavily on access to computers, specific software, and the Internet. At some point during the term you will have a technology problem: your laptop will crash, a file will become corrupted, a server will go down, or something else will occur. These are facts of life, not emergencies. Technology problems will not normally be accepted as excuses for unfinished work. Count on "stuff" happening and protect yourself by doing the following:
Cheating will result in the pursuit of disciplinary action and may include a grade of 'F' for this course. More importantly, you will deny yourself an opportunity to learn something. Cheating includes copying labs, reports, projects, tests, exams, and plagiarism, as well as helping another student cheat by giving them answers, files, or doing the work for them.
Running electronic devices is not allowed in the classroom/lab. Food/drink
is not allowed in the lab. In addition to the rules outlined in this
syllabus and presented in class, it is the student's responsibility to understand
and abide by all COD academic policies as stated in the current catalog.
GRADING: LearnSmarts (LS), Simbooks (SB), quizzes, and examinations illustrate your knowledge of the course material. LS are worth 195 points (13 worth 15 points each). SB are worth 75 points (15 worth 5 points each). Quizzes are worth 320 points (13 LS quizzes worth 20 points each; 5 SB quizzes worth 12 points each). The Final Examinations are worth 100 points (LS is worth 70 points; SB is worth 30 points). There is one report designed to have you consider ethical issues that is worth 15 points. Software labs reinforce particular concepts covered during class and are worth 95 points (5 labs worth differing amounts). Projects provide you the opportunity to demonstrate your ability to use applications to apply concepts learned from class and are worth 200 points (4 projects worth 50 points each). Changes to the grading scale, number of assignments, or relative weight are the instructor's prerogative.
A = 900 - 1000 Points
B = 830 - 899 Points
C = 760 - 829 Points
D = 690 - 759 Points
F = below 690 Points
Incompletes will not be given.
For S/F evaluations, you must obtain the appropriate form and submit it to me for
approval. A minimum of 760 points are required to earn a grade of 'S'.
Note: Some institutions transfer a `S' grade as a `D'. If you
decide not to complete the course, you must go to Registration and formally withdraw.
Failure to do so will result in a grade of 'F' for the course.
PROJECTS: Projects must be submitted via Blackboard on the due date prior to the start of class. No assignment will be accepted after class has begun on the due date. Resubmitting projects is not allowed. Extra credit is not offered. Changes to the projects are the instructor's prerogative.
WP Project (Word Processing using Word) - Due Thursday, June 26: Part 1 - Research how to write resumès and create a resumè. The resumè should contain a graphic that relates to the profession you are interested in. Make up previous employment, if necessary. The resumè should be at least a full page but no more than two pages. Part 2 - Write a cover letter, expounding on the data-oriented facts of your resumè. The cover letter should complement, not duplicate your resumè and add a personal touch. This letter should be between half a page and one page. Content and style will be assessed. Here is an instruction sheet with an example of what your cover letter and resumè could look like and the grading rubric for this project.
SS Project (Spreadsheet using Excel) - Due Tuesday, July 8: Part 1 - Create a spreadsheet that tracks your expenses for a week. Use a column for each day of the week and include at least 7 items (rows). Using functions, compute the total expense for each day of the week. Using functions, compute the weekly total and daily average expense for each item. Be sure to label the rows and columns, include a title, and name the sheet Expense. Content and style will be assessed. Part 2 - On a separate sheet titled Column, create a clustered column chart based on the total expenses per item. Create a second chart on a separate sheet called Pie based on the total expenses per day, using a 3-D pie chart, and pull out the day with the most expenses. Be sure there are appropriate titles and labels for each chart. Here is an instruction sheet with an example of what your worksheets could look like and the grading rubric for this project.
Report - Due Tuesday, July 15: Write a reaction paper (minimum 500 words) to "The Dash" presentation. Details will be provided during class. Submit through Blackboard.
PR Project (Presentation using PowerPoint) - Due Tuesday, July 15: You are a director of a research and development department making a presentation to your upper management. Your department has developed a new virtual reality application, that, to your knowledge, does not yet exist. Develop a presentation (minimum six slides) that illustrates your new virtual reality application and the benefits it offers. Make sure you use a logo for your company and include animation. Your presentation will be assessed on creativity, legibility, simplicity, clarity, and visual appeal. Here is an instruction sheet for your presentation and the grading rubric for this project.
DB Project (Database using Access) - Due Thursday, July 24:
Create a database for InPerson Fitness, a company that provides in-home personal training
and fitness consultation. Based on data you will be provided, the database should consist
of two related tables with the least amount of redundancy. Each table should have a primary
key. Fields should have meaningful names, appropriate data types, and sizes. Part 2 - Create
a report based on criteria you will be provided. All tables, queries, and/or reports should
have appropriate names/titles. Here is an instruction sheet
with the data for your database and the grading rubric for this
CLASS NOTES: Class notes are available as Microsoft PowerPoint presentations. If you do not have Microsoft PowerPoint, you will need the PowerPoint Viewer (which is free) to view and/or print the presentations. The PowerPoint Viewer is available on Microsoft's site here where you can read the instructions to download and install the viewer. Click on the links below to access the PowerPoint presentations used in class.