Home > Syllabus > Print

Site Map

| Home | Course Information |  Syllabus | Calendar | Assignments |

Syllabus

This course will cover computer and networking concepts, computer applications, and productivity software (word processing, spreadsheet, database, and presentation).

One USB drive to be used for student data files and assignments.

III. SCIENTIFIC AND MATHEMATICAL LITERACY: students will apply an understanding of mathematical, natural and behavioral scientific principles and to solve abstract and practical problems.

• A. Engage in problem solving using various strategies that require presentation of questions, organization of information, performance of computations or estimation, drawing diagrams, analyzing situations, graphing and modeling, drawing conclusions, verifying and interpreting the results.
• B. Apply knowledge and understanding of principles of mathematical and scientific inquiry to real world situations using a modeling process to include identifying the problem, interpreting the problem, employing the theory and tools to determine a solution, testing and interpreting the solution within the problem, and refining the solution if necessary.
• D. Use appropriate technology to enhance mathematical and scientific thinking and understanding.

IV. INFORMATION MANAGEMENT: students will use effective strategies to collect, verify, document and manage information from a variety of sources.

• A. Use information-seeking strategies necessary to access information efficiently and effectively using a variety of sources and techniques.
• B. Understand how information is organized, including cataloging and indexing systems in Web and traditional locator tools and their biases and limitations.
• D. Identify and use appropriate technology, including computer and multimedia resources and visual symbols, to address a variety of tasks and problems.

V. CULTURAL LITERACY: students will develop an appreciation of human culture and its diversity and the role of the creative arts in society.

• B. Assess mass media messages, derive important news and other essential information from a variety of sources, and thoughtfully use this knowledge as a responsible citizen.

VI. SOCIAL SKILLS: students will develop and use skills and attitudes that integrate the individual into society.

• C. Recognize unethical behavior such as plagiarism and its implications. Embody honesty, respectability, and integrity.

VII. PERSONAL MANAGEMENT: students will develop habits of conduct that result in fulfilling personal and occupational accomplishments.

• A. Engage in lifelong learning and intellectual curiosity.
• B. Apply knowledge, skills, and attitudes to occupational pursuits.

Major Learning Outcome: Upon completion of this course the student will

1. Understand fundamentals of information systems with a basic vocabulary and knowledge of computers and related devices.
2. Be able to use the Internet to access information.
3. Understand the operating system and be able to use it to perform basic tasks needed to store/retrieve data and access applications.
4. Use productivity software to create documents, spreadsheets, databases, and presentations.

1. Load and exit windows; use mouse and keyboard; identify the components of the windows desktop; organize screen based desktop; switch tasks in a multi-tasking environment.
2. Start and exit Microsoft Word 2007; open and close a document; delete and inset text and blank lines; select blocks of text; change justification and line spacing; save and print a document.
3. Spell-check a document; open and display two documents; cut, copy, and move text; enter date codes; set margins and tabs; bold and italicize text; search and replace text.
4. Start and exit Microsoft Excel 2007; design a worksheet; enter labels and values; edit worksheet entries; open and close files; copy data, enter formulas, and align entries; save and print a worksheet.
5. Copy formulas, enter @functions, and clear cell contents; format values and use absolute references; change column widths, insert and delete rows and columns; move entries, change fonts and attributes; insert and use multiple worksheets.
6. Create bar, line, mixed, and pie charts; enter chart titles and axis titles; add tick marks, grid lines, and patterns; add test blocks and arrows; add legends and data labels; save and print a worksheet with charts.
7. Start and exit Microsoft PowerPoint 2007; create a multi-level bulleted list presentation; select a design template; change font style; decrease font size; save a presentation; display slides in an electronic slide show; print copies of the slides to make overhead transparencies.
8. Use outline view and clip art to create an electronic slide show; change slide layouts; insert clip art; add slide transition effects; add text animation effects; animate clip art; run an animated slide show; and print audience handouts from an outline.
9. Start and exit Microsoft Access 2007; create a database using design and datasheet views; create, save and close a table; add records to a table; preview and print the content of a table; use a form to view data; create a report; query a database using the select query window; create a new query; enter criteria; use compound criteria; sort data in a query; join tables; use calculated fields in a query.
10. Maintain a database using the design and update features of Access; add, change, and delete records; search for a record; filter records. change the structure; use a update query; use a delete query; create validation rules; specify referential integrity; order records on multiple fields; create and use indexes.
11. Define terms and concepts related to the Internet.
12. Use the Internet browser to access Web pages. Use search engines to locate information.
13. Set up an e-mail account. Send and receive e-mail.