SRJC Course Outlines

4/29/2024 7:23:03 AMBAD 53 Course Outline as of Spring 1992

New Course (First Version)
CATALOG INFORMATION

Discipline and Nbr:  BAD 53Title:  BUS PROB/SPRDSHEETS  
Full Title:  Introduction to Solving Business Problems with Spreadsheets
Last Reviewed:9/14/2020

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum1.50Lecture Scheduled2.0017 max.Lecture Scheduled34.00
Minimum1.50Lab Scheduled02 min.Lab Scheduled0
 Contact DHR3.50 Contact DHR59.50
 Contact Total5.50 Contact Total93.50
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  68.00Total Student Learning Hours: 161.50 

Title 5 Category:  AA Degree Applicable
Grading:  Grade or P/NP
Repeatability:  00 - Two Repeats if Grade was D, F, NC, or NP
Also Listed As: 
Formerly: 

Catalog Description:
Untitled document
This course provides students with a broad, practical applications approach to solving business problems, using a computer spreadsheet. Topics covered include applications in the functional areas of Finance and Accounting, Supervisory Management, and Sales & Marketing.  Hands on practice with real world business problems; course does not require computer experience with a spreadsheet program.

Prerequisites/Corequisites:


Recommended Preparation:
Course Eligibility for ENGL 100A

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
This course provides students with a broad, practical applications approach to solving business problems. Topics covered include applications in the functional areas of Finance & Accounting, Supervisory Management, and Sales & Marketing. Hands-on practice with real-world business problems; course does not require computer experience with a spreadsheet program.
(Grade or P/NP)

Prerequisites:
Recommended:Course Eligibility for ENGL 100A
Limits on Enrollment:
Transfer Credit:CSU;
Repeatability:00 - Two Repeats if Grade was D, F, NC, or NP

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

Associate Degree:Effective:Inactive:
 Area:
 
CSU GE:Transfer Area Effective:Inactive:
 
IGETC:Transfer Area Effective:Inactive:
 
CSU Transfer:TransferableEffective:Spring 1992Inactive:
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Certificate Applicable Course



COURSE CONTENT

Outcomes and Objectives:
At the conclusion of this course, the student should be able to:
Untitled document
Students will learn:
1.  Business problem solving strategies;
2.  Spreadsheet basic and model development;
3.  Spreadsheet applications in selected business areas.

Topics and Scope
Untitled document
1.  Business Problem Solving - Strategy Considerations
2.  Getting Started on Spreadsheets
   a.  Lotus 1-2-3 basics
   b.  Model and template development
3.  Spreadsheet features training using a common business model
4.  Selected business applications in problem-solving in the areas of
   finance and accounting, management and marketing and sales.  Models
   and formulas, graphing, databases and macros.

Assignments:
Untitled document
Reading and written assignments.  Creation of spreadsheets.

Methods of Evaluation/Basis of Grade.
Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing.Writing
0 - 0%
None
This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments are more appropriate for this course.
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.Problem Solving
40 - 60%
COMPUTER-BASED PROBLEM DEMONS.
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
0 - 50%
CREATION OF SPREADSHEETS
Exams: All forms of formal testing, other than skill performance exams.Exams
0 - 30%
Multiple choice, True/false
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
0 - 10%
ATTENDANCE AND PARTICIPATION.


Representative Textbooks and Materials:
Untitled document
Laudon & Laudon, SOLVING CLASSIC BUSINESS PROBLEMS:  AN INTRODUCTION
TO LOTUS 1-2-3, RELEASE 2.3; Addison Wesley Publishing Co.
R. Ageloff, LOTUS 1-2-3 FOR BUSINESS, RELEASE 2.2; Course Technology.

Print PDF