Microcomputer Applications

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. A microcomputer is another name for a personal computer, or PC. 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.)
Prerequisites:    None
Level: Undergraduate
Credits: 3
Format: Online  (This course is also offered in print.)
Program: Bachelor of Science in Business Administration
Bachelor of Science in Criminal Justice

Registration Instructions

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.

Additional Information

Learning Outcomes
Upon completion of this course, you should be able to

  • Define key terminology used in describing computer hardware, its components and peripherals, specific software applications, and the terms generally associated with those applications.
  • Operate Microsoft Windows 8 and the basic tools provided within it.
  • Create a PowerPoint 2013 presentation using a design template, clip art or images, tables, charts, video, sound, animation effects, and slide transitions.
  • Create a Word 2013 announcement using clip art, various font sizes, font types, and font styles; and formatting paragraphs;
  • Use Word 2013 to create a multiple-page report and use the Desktop Publishing and Mail Merge features.
  • Use a variety of the functions in Excel 2013 to create a spreadsheet using various functions. Use the fill handle, format a worksheet, use absolute references, and create a 3-D clustered column chart.
  • Create an Access 2013 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 Descriptions
Course Organization and Assignment Descriptions

Unit 1: Essential Computer Concepts and Microsoft Windows 8

It is very important for you to understand the basic computer terminology we will discuss and illustrate in this module. To use a computer effectively, you must understand the speed of the processor, the amount of memory, and the purpose of an operating system, as well as how it differs from application software.

You will use the Windows operating system software extensively--whether it be Windows XP, Vista, or Windows 7, or Windows 8--to run different applications and manage folders and files.

Upon completion of this unit, you should be able to

  • Identify the different parts of a computer.
  • Know the difference between memory, external storage and the terms used to measure the sizes, such as MB, GB, and TB.
  • Manage folders and files.
  • Find, place, copy, and move files effectively.
  • Recognize what the Windows operating system is used for.
  • Understand how to use Windows folders and files.
  • Identify the basic software used with the Windows operating system.
  • Recognize the many different types of slides available in PowerPoint and when to use them.
  • Understand the basic hardware of microcomputers.
  • Become comfortable with microcomputer hardware so that you may converse with others intelligently about computers, as well as get answers to your questions and be able to purchase a microcomputer system that will meet your needs.
  • Use websites, such as www.intel.com, to learn about microcomputer hardware and architecture.
  • Identify the main software that you will be using.
  • Use web sites, such as www.microsoft.com, to learn about the software you use.
  • Effectively use the Windows operating system.
  • Manage folders and files without losing any data.
  • Create basic presentations with PowerPoint.

Unit 2: PowerPoint 2013
Microsoft PowerPoint 2013 is a computer program you use to create a collection of slides that can contain text, charts, pictures, sounds, movies, multimedia, and so on.

Upon completion of this unit, you should be able to

  • Plan and create a new presentation.
  • Create a title slide and slides with bulleted lists.
  • Edit and format text, change the theme and theme variant, insert and crop photos, and create speaker notes.
  • Print slides, handouts, speaker notes, and an outline.
  • Apply a theme used in another presentation, insert online pictures, insert and format shapes, insert a table, apply and modify transitions and animations, add video and modify playback options, and add footers and headers.

Unit 3: Introduction to Microsoft Word 2013

In this module, you will be introduced to Microsoft Word. You will learn how you may use the computer to complete many kinds of typing--from letters to professional documents. You can also 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.

Upon completion of this unit, you should be able to

  • Create well-designed letters and other documents.
  • Use the Help feature to look up topics that may not be found in the textbook.
  • Format documents to look professional.
  • Use the many kinds of formatting features in Word.
  • Use basic functions in Word, such as find, replace, copy, cut, and paste.
  • Design a document properly, such as a business letter or report.
  • Create and use tables efficiently.
  • Create multiple-page reports.
  • Create desktop publishing documents, such as a newspaper with several columns and other advanced documents.

Unit 4: Microsoft Excel 2013

A spreadsheet is a grouping of text and numbers in a rectangular grid or table. Spreadsheets are oftem used in business for budgeting, inventory management, and financial reporting because they unite text, numbers, and charts within one document. The advantage of an electronic spreadsheet is that the content can be easily edited and updated to reflect changing financial conditions.

Upon completion of this unit, you should be able to

  • Navigate through a workbook and worksheet.
  • Plan and create a workbook.
  • Enter text, dates, and numbers.
  • Insert and delete rows, columns, and ranges.
  • Format a workbook by changing fonts, font style, and font color.
  • Create formulas to calculate sales and data, apply cell styles, copy and paste formats with the Formant Painter, highlight cells with conditional formats, set the print area, insert page breaks, add print titles, create headers and footers, and set margins.
  • Use formulas and functions, interpret error values, change cell references between relative and absolute, and use the AutoFill tool to enter formulas and data and complete a series.
  • Create charts, use the PMT function to calculate a loan payment, create a combination chart, and modify the chart’s data source.
  • Explain scenarios, named ranges, and a one-variable data table.

Unit 5: Microsoft Access 2013

As in the modules on Microsoft Word and Excel, there are four lessons in Module 5. 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 15, 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 16, you will create and save a table in design view, modify the table structure, and import data from an Excel spreadsheet. In Lesson 17, 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 18, 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 19 in Module 6 integrates the four applications.

Upon completion of this unit, you should be able to

  • Understand the correct ways to start, close, and stop Access.
  • Identify the major elements of Access windows.
  • Correct mistakes and use the Undo button.
  • View an Access table using a datasheet and a form.
  • Open and close Access objects.
  • Open and close an Access database.
  • Use Access help.
  • Use database terms.
  • Design and create a database.
  • Create an Access table using Table Wizard.
  • Create and define the fields and field properties in a table.
  • Use and understand relating tables.
  • Modify a table's structure.
  • Create, modify, and use an Access database.
  • Identify all of the main types of fields.
  • Create and run queries.
  • Join two or more related tables.
  • Use forms with related tables to pull data together.
  • Create and use forms and reports.

Unit 6: Integrating the Office Suite

In this lesson, you will learn how to integrate PowerPoint 2013, Word 2013, Excel 2013, and Access 2013.

Upon completion of this unit, you should be able to

  • Collect text and objects from Office documents and place them on the Office Clipboard.
  • Paste selections from the Office Clipboard into Word.
  • Perform a mail merge.
  • Learn about importing and exporting data.
  • Import an Excel list into an Access database.
  • Query an Access database.
  • Export an Access query to a Word document.

Grading Criteria for Activities

Assignment Possible Points
Exams (4 @ 100 pts. each) 400 points
Projects (4 @ 40 pts. each) 160 points
Discussions (4 @ 10 pts. each) 40 points
Total: 600 points

Grading Scale

A 552 - 600 points
A- 534 - 551 points
B+ 516 - 533 points
B 492 - 515 points
B- 474 - 491 points
C+ 456 - 473 points
C 432 - 455 points
C- 414 - 431 points
D+ 390 - 413 points
D 360 - 389 points
F 0 - 359 points


Footer Anchor