HCMC UNIVERSITY OF TECHNOLOGY AND EDUCATION Program: Financial Accounting

FACULTY OF ECONOMICS Level: Undergraduate

Course Syllabus
1. Course Title: Applied Computing
2. Course Code: APCP220307
3. Credit Units: 2 units (1/1/4)(1 lecture periods, 1 laboratory period, 4 self-study period
per week)
Duration:15 weeks (1 hours of theory+ 2 hours of practice, and 3 hours of self-study
per week)
4. Course Instructors:
1/ Ph.D. Dang Quang Vang
2/ MSc. Nguyen Thanh Dong
5. Course Requirements:
Previous courses(s): None
Prerequisite course(s): None
6. Course description
This course covers all basic and advanced knowledge and skills of computing for
office such as: creating text, editing and processing spreadsheet and creating presentation
files. Learners can use this knowledge to master their Microsoft Office (specializing in
Excel, pivotable tool and VBA) skills so that they can design documents for studying,
researching and professional purpose. In addition, this course also helps students with
soft skills such as teamwork and advanced presentation skills.
7. Course Goals

Goals Goal description ELOs Trình độ

năng lực

G1 Expertise knowledge about office computing ELO 1, 3

(Excel microsoft) ELO 2
G2 Applying computer science to study, analyse and ELO3. 4
solve problems in the field of accounting.

G3 Good teamwork and efficient presentation ELO 9. 3

8. Course Learning Outcomes

CLOs CLO Description Outcome Trình

độ năng
lực

Present the basic and advanced concepts in ELO 1 3

G1.1 composing text, spreadsheet and presentation
files.

G1 Present the processes of creating text files, ELO 2 3

G1.2
spreadsheet and presentation files.

Master the Microsoft Office tools: Excel to design ELO 2 3

G1.3
the documents for themselves.

G2.1 Use Excel to collect and reserve accounting data. ELO3. 4

Use Excel’s formulas, functions and VBA to ELO3.

G2.2 analyze data, calculate and make statistics in the
G2
field of accounting.

Use Word tools to design professional documents ELO3. 4

G2.3
and makeresearch papers.

G2.4 Combine Word, Excel and PowerPoint to present ELO3. 4

system ideas, develop and manage accounting
 projects.

G3.1 Efficient teamwork ELO 9. 3

G3
G3.2 Present with modern tools: laptop, projector… ELO 9. 3

9. Learning resources

- Main Textbook:
[1] Beth Melton, Mark Dodge, Echo Swinford, Andrew Couch, Eric Legault,
Ben M. Schorr, Ciprian Adrian Rusen, Microsoft Office Professional 2013 Step
By Step, O‘Reilly, 2013.
- Supplementary Textbook:
[1] Lecture Slides.

3. Assessment:
- Grading scale: 10
- Examination plan:

Types Assessmen CLO Rate(%

of Timelin t s )
Content/ Topics
Exam e method
s

Short Test 50

Applying the basis funtion of Week 5 Computing G1.1 10

KT#1 Microsoft office to solve the G1.2
problem

Using the pivot table to analysis Week 10 Computing G32.2 20

KT#2 the payroll and personal income
tax
 Teamwork to set up a business Week 12 Computing G3.1 20
KT#3
project (self-nominated project).

Final Exam 50

Computing G1.1
G1.2
 Using VBA for solving the business problem
 Using pivot table .to analysis the information G3.1
business G4.1

11. Course Outline:

Wee
Content CLOs
k
1 – Chapter 1: Process Spreadsheet with Microsoft Excel
3 (3/3/12)

A/ Course contents and teaching method in class (16)

Microsoft Excel 2016 Introduction
 Start the program G1.1
 Microsoft Excel‘s Primary User Interface: Ribbon, Quick
Access, Title Bar...
 Workbook structure
Basic Editing
 Data types
 Cell and Range Address
G1.2
 Entering and Editing Basic Data in a Worksheet
  Search and Replace data
 Data filter
 Select, Add, Delete cell, row and column
 Insert objects into worksheet: Text, symbol, picture...
 Excel fuctions (financial fuctions, statatics fuctions)
Work with Excel worksheet
 Select worksheet
 Insert, Delete, Edit worksheet
 Insert hyperlinks to link all sheets together
Create charts
 Classify kinds of chart
 Create chart
 Format chart G1.3

Formulas and Functions in Excel

 Perform calculation with simple formulas
 Use Microsoft Excel‘s available functions
 Calulation and Statistics Function: Count, Sum,
Avgerage, Max, Min
 Logical Function: Not, And, Or, If
 Text Function: Len, Left, Right, Mid
 Math and Trig Function: Abs, Squrt, Round
 Date and Time Function: Now, Today, Month, Year.
 Lookup and Reference Function: Vlookup, Hlookup,
Index, Match
 Financial Function: Rate, FV, PV
Database in Excel
 Use form to enter data
  Restrict data input with Data Validation
 Sort data
 Filter data
 Database function: Dcount, DcountA, Dsum, Dmax,
Dmin
 Collect data in different sheets
 Use Pivot Table to analyze data

G2.1

B/ Self-study content: () G2.1

Review the teaching slides
Do homework #2
4-6
Chapter 2: Creating Pivot table (1/2/6)
A/ Course contents and teaching method in class (12)
Create and edit Presentation file
 Creating a Presentation from a Template
 Adding, Deleting, and Organizing Slides G2.2
 Apply formatting and styles to text
 Adding pictures, audio files and video clips
 Creating the pivot table
 Pivot table chart
 Using the macro code to solve the economics proplems
Working with Slide Master
 Arrange and Format Placeholder on SlideMaster
 Add and Delete Place holder
 Apply theme and background for place holder
 Using Animation and Multimedia G2.3
Animating Slide Content
 Apply animations to objects.
 Apply animations to text.
 Set animation effect options.
 Reorder animations on a slide.
 Set animation paths.
 Setting Up Slide Transitions
Linking to web pages and other programs
 Adding a Text Hyperlink
 Add a Graphical Hyperlink
Tips for preparing presentation files
 Text and table
 Picture and animation
 Number of slides
 Main idea for presentation

B/ Self-study content: (6) G2.3

Review the teaching slides
Do assigmnent #1

7 Midterm test

Chapter 3: Using Pivottable for solving the problem (3/3/12)

1. Preparing the payment planning

2. Preparing the payment planning
3. Preparing the inventory planning
4. Analyisng the personal income payment
5. Payroll through bank
 8
- 6. Personal income payment report via email meger
9

Chapter 4: Visual Basic (2/1/6)

A/ Course contents and teaching method in class (3)
- Introduction VBA
- Some concept about VBA
 Sub
 Function G1.1
 Event
 Object
 Property
 Loop
 Debug
- Writing VBA code
10-11  Macro Sub
 Macro Function
 Record macro geneates Sub
- Objects in VBA
 Excel (Range, Cells)
 Sheets
G2.1
 File Excel (Workbooks)
 Rows, Columns
 MessageBox và InputBox G2.3
- Event in VBA
 Event in Application
 Event in Sheets
 Event in Workbooks

Chương 5: Function, Loop and ActiveX Control (3/0/6)

12, A/ Course contents and teaching method in class (3)
13 - Functions in VBA
 If
  Select Case
 Time
- Loop in VBA
 For Next
 For Each
 Do While
 Do Until
- ActiveX Control
 Button
 ListBox
 ComboBox
 CheckBox
 Option Button

Chương 6: Working with Userform (3/3/12)

Course contents and teaching method in class (3

- Introduction Userform
 Adding Userform in the window
 Making Sub Userform from Excel
 Some Toolboxes of Userform
- Some Tools in Userform
 Command Button
 Label
14,
 Textbox
15  Combobox
 Listbox
 Checkbox
 Tab
- Các sự kiện trên Userform
 Click
 RightClick
 DoubleClick

12. Scientific ethics:

Exercises must be done by the students themselves. If copied, the relevant students will
be handled in the form of an assessment of 0 (zero) score for mid-term and final
examination.

13. First Date of Approval: June 15th, 2019

14. Approved by:

Dean Head of Department Instructor

15. Date and Up-to-date content

1st time: Instructor:

Head of Department
nd
2 time: Instructor:

Head of Department