Course ID: | MIST 7810. 1.5 hours. |
Course Title: | Advanced Business Applications |
Course Description: | The effective use of spreadsheet software. Electronic spreadsheet
software is a powerful application program. It includes
management tools for many applications, especially in accounting,
finance, forecasting, budgeting, cash flow projections, and
others. Hands-on learning is emphasized. |
Oasis Title: | ADV BUSINESS APPS |
Semester Course Offered: | Offered fall and spring semester every year. |
Grading System: | A-F (Traditional) |
|
Course Objectives: | Upon successfully completing this course the student will
master:
1. Fast data entry and navigation
2. Printing the spreadsheet
3. Creating simple formulas (calculations)
4. Using functions effectively
5. Copying and moving text and formulas to save time
6. Manipulating the professional appearance of the worksheet for
maximum effect
7. Creating and manipulating charts to display data in a more
involving and direct manner
8. Creating and using lists and pivot tables effectively
9. Effective worksheet design and development
10. Solving complex decision-making problems with Excel add-ins
11. Importing data into worksheets and linking to external data
12. Creating programs (a.k.a. macros) directly in the worksheet
to enhance their use effectively |
Topical Outline: | Ranges, editing, and spell checking
Basic functions including date and time
Financial functions
Formatting the worksheet
Charts
Lists
Pivot tables
Optimization with trial-and-error and GoalSeek, Solver and
Analysis Tool Pack
External data use
Web queries and XML
VB Macros/Programming |
Honor Code Reference: | We strive to have a culture of complete academic honesty. Thus,
The University's Academic Honesty Policy is in effect (available
at www.uga.edu/ovpi/). It is each student's responsibility to be
informed and aware of The University's official academic honesty
and dishonesty policies. Technically, this means that each
student must read the policy and comply with it. Infractions
cannot effectively be defended with statements such as "I didn't
know that was prohibited." If an alleged incident occurs, the
situation will immediately be documented and sent to the Office
of the Vice-President for Academic Affairs for processing, and
your grade in this course will be an NR (Not Reported) until the
matter has run through due process. Officials in that Office
will
directly contact all parties involved. If you have any
questions,
refer to The University's Academic Honesty Guidelines in The
University of Georgia Publications for more details on the rules
and procedures). If you have questions about specific acts and
whether they are academically honest or not, please contact the
instructor or the Office of the Vice President for Academic
Affairs. In general, if you think it might be dishonest, it
probably is. Some specifics relating to this course are:
You may not use email or cell phones during an exam or quiz.
You may not surf the Web during an exam or quiz, unless you are
accessing a permitted Web site.
The Academic Honesty Policy does not apply to helping someone
understand basic concepts, explaining to someone the
interpretation of an assignment, or clarifying how to use
software. It applies to direct intervention in producing
materials turned in for grading (exams, quizzes, assignments,
etc.). Please do help each other. This can save valuable time
and
aggravation, and really reenforce your own learning. If you have
any questions, just ask. |