|Course Number:||COMPUTER 1830|
|Course Name:||Microcomputer Applications (Online)|
|Course Description:||A course recommended for all non-computer science majors that need to know how to use the microcomputer. The major emphasis will be on using microcomputers with the most popular kinds of computer software used in business and education today including word processing, spreadsheets and database management. (Not open to computer science majors.)|
|Format:||Online (This course is also offered in print.)|
Bachelor of Science in Business Administration
Bachelor of Science in Criminal Justice
NOTE: The information below is representative of the course and is subject to change. The specific details of the course will be available in the Desire2Learn course instance for the course in which a student registers.
Upon completion of this course, students should be able to
- Define key terminology used in describing computer hardware, its components and peripherals, the specific software applications and the terms generally associated with those applications.
- Operate Microsoft Windows 7 and the basic tools provided within it.
- Create a PowerPoint 2010 presentation using a design template, clip art or images, tables, charts, video, sound, animation effects, and slide transitions.
- Create a Word 2010 announcement using clip art, various font sizes, font types, and font styles, and formatting paragraphs; Use Word 2010 to create a Multiple-Page Report; Desktop Publishing and Mail Merge.
- Create an Excel 2010 spreadsheet using various functions; the fill handle; format a worksheet; create a 3-D Clustered column chart; and use the AutoCalculate area.
Create an Access 2010 database; create a table and add records; create and use a simply query; create and use a simple form; create and print a custom report; and design a database to eliminate redundancy.
Unit 1: Essential Computer Concepts, Microsoft Windows 7, and PowerPoint 2010
It is very important for you to understand the basic computer terminology that is discussed and illustrated in Unit 1. To use a computer effectively, you must understand the speed of the processor, the amount of memory, the purpose of an operating system, and how it differs from application software. You will use the Windows operating system software, whether it be Windows XP, Vista, or 7, extensively to run different applications and manage folders and files.
Unit 2: Introduction to Microsoft Word 2010
In Unit 2, you will learn how you may use the computer to complete many types of typing--from letters to professional documents. You can complete many kinds of tasks in Microsoft Word that you would expect to have to complete in a spreadsheet or database application. You should experiment with the Help feature as you progress through the sessions. Take the time to look up more advanced information. Any time you forget how to do something, you can quickly use Help to look it up.
Unit 4: Microsoft Access 2010
As in the units on Microsoft Word and Excel, there are four tutorials in Unit 4. Microsoft Access is a powerful relational database (DB) for microcomputers. The term relational is a formal and very common type of database. Relational databases, such as Oracle, are also used in large mainframes.
A database is much more powerful than a single file system. The DB consists of one or more related files (here called tables). Each table has rows called records. Finally, each record is broken into fields. An example record could be one row of information for one person, such as ID, Name, Address, City, State, ZIP, Phone, and Department. The fields are the individual items like Name and Phone.
In Lesson 16, an introduction to Microsoft Access, key terms and concepts about databases are described. Access is started and components of the program window are identified. You will learn to open, navigate, and print a table. An overview of how to create and print a simple query is presented. Forms and reports are described with simple examples. Instructions on how to use the Access Help files are introduced as well. In Lesson 17, you will create and save a table in design view, modify the table structure, and import data from an Excel spreadsheet. In Lesson 18, you will learn the basics on the Access query language. First, you will learn how to select and sort one table, and then more than one table. In Lesson 19, you will create a form and a report. Formatted data input screens and output reports enhance the usability of a database. The tutorial teaches simple data input form creation and output report design. Lesson 20 integrates the four applications.
Grades will be assigned according to the following point values earned:
|A||540 points or more|
|B||480 - 539 points|
|C||420 - 479 points|
|D||360 - 419 points|
|F||0 - 359 points|
All assignments are due at the beginning of class on the date due. Late submission of assignments will not be accepted. No exceptions are made except in extreme circumstances. You are allowed one late assignment per semester.
A student must notify the instructor of her/his conflict for exams prior to the test date.
Exams will be based on class notes, readings from the text, and assignments. All assignments, quizzes, exams, course notes, and grades will be posted at Desire2Learn.uwplatt.edu under Content.
Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog.
Religious Accommodations: Students have the right to miss class for religious observances. Students wishing time off for this reason should let their instructors know within first two weeks of class.
Disabilities: Reasonable accommodations will be provided for students with physical, sensory, cognitive, systemic, and psychiatric disabilities. Please contact the instructor to discuss accommodations for this course.
Illness: Sometimes absence from class is unavoidable because of illness. Such illness should be reported to the Student Health Services. Emergencies other than illness that cause absence from classes should be reported to the office of Student Affairs. Such students are expected to meet with their instructors as soon as possible after the crisis has passed and arrange to make up any missed work.
Incomplete Policy: Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed a significant portion of the course.