Business Information Management 1A

Course Description

In this course, students will develop skills that will help them make a successful transition to the workforce and post-secondary education. They will learn key aspects of software programs in the Microsoft® Office suite. In addition, they will learn how businesses manage vast amounts of information with a variety of emerging technologies. When students have completed this course, they will recognize how businesses identify information requirements and information management systems. Students will have also gained practical skills for succeeding in today’s business environment, including the ability to create effective word processing documents, spreadsheets, databases, and multimedia presentations.

Required Course Materials

Microsoft® Office Suite including Word, Excel, Access, and PowerPoint

Course Organization

Objectives. The objectives for each lesson will help you focus your efforts. They indicate the concepts and skills you must understand or master when you complete the lesson.
Reading Assignments. Each lesson specifies the selections that must be read.
Instructor’s Comments. The Instructor’s Comments of each lesson provides key terms and concepts that give you background for the lesson.
Self-Assessment Activities. These activities help to build your knowledge and skills and to identify your specific strengths and weaknesses. Some activities direct you to Internet sites with supplemental material for the lesson. All activities prepare you for the graded assignments and for mastering course materials.
Graded Assignments. Each assignment provides information about how your work will be assessed and how credit will be given for your responses. Most assignments will be submitted online and graded by your instructor. Some assignments will be computer-graded. The average of your assignments counts as 75 percent of your course grade. The Final Examination counts as the other 25 percent. You can apply to take the Final Exam after 100 percent of your graded assignments have been submitted, and at least 70 percent have been graded and returned to you.

Final Examination

The final examination is comprehensive; it covers the material from all of the lessons. To pass the course, you must receive a grade of 70 percent or better.
Format: Multiple-choice, short answer, and essay questions testing literary terms, characterization, fact and opinion, cause and effect, knowledge of grammar, and vocabulary.
Time Allowed: 3 hours
Materials Allowed: #2 pencil

Course Outline

Total Number of Lessons: 10
Total Number of Activities: 21
Total Number of Graded Assignments: 19
Instructor Graded (Online submission): 11
Computer Graded: 8

Lesson 1: Computer Information Management
Graded Assignment 1

Lesson 2: Information System Components and Management
Activity 1: Computer Equipment and Supplies
Activity 2: Computer Terminology Matching
Graded Assignment 2
Graded Assignment 3

Lesson 3: Word Processing Basics
Activity 1: Effective Business Writing
Activity 2: How Well Do You Know Word?
Activity 3: Tracking Lizards
Graded Assignment 4
Graded Assignment 5

Lesson 4: Word: Beyond the Basics
Activity 1: Defining Word
Activity 2: One Million Homes!
Graded Assignment 6
Graded Assignment 7

Lesson 5: PowerPoint Nuts and Bolts
Activity 1: Defining PowerPoint
Activity 2: Three Slides
Graded Assignment 8
Graded Assignment 9

Lesson 6: Effective Business Presentations
Activity 1: Bells and Whistles
Activity 2: Drum Roll, Please
Activity 3: Evaluating Presentations
Graded Assignment 10

Lesson 7: Using Excel in a Business Environment
Activity 1: Describing Excel
Activity 2: Stacked Bar Chart
Activity 3: A Helpful Tool
Graded Assignment 11

Lesson 8: Excel: Beyond the Basics
Activity 1: Task Master
Activity 2: Using Fills and Styles
Graded Assignment 13
Graded Assignment 14

Lesson 9: Using Access in a Business Environment
Activity 1: Essential Features
Activity 2: Create a Form
Graded Assignment 15
Graded Assignment 16
Graded Assignment 17

Lesson 10: Access: Using Database Records
Activity 1: Access Details
Activity 2: Building a Form and Manipulating Data
Graded Assignment 18
Graded Assignment 19