Monash University Calendar 2018 - 2022

5E Model of Instruction

Accounting Information Systems (Day 02)

1. What is considered a strong internal control structure?

In cases of employee fraud, weak internal controls are usually present.

Management frauds, however, are usually committed at a level above the one to which internal controls generally relate.

2. The Sarbanes-Oxley Act requires all audit committee members to be independent and requires the audit committee to hire and oversee the external auditors. This provision is consistent with many investors who consider the board composition to be a critical investment factor.

3. What is control risk?

It is an absence or weakness of an internal control.

4. What are non-auditing activities?

5. What are bookkeeping services?

Bookkeeping services include, but are not limited to, maintaining and evaluating financial transaction records in books of account such as sales, purchase, cash journals, ledgers or computerised accounting systems, preparing budget or income expenditure report, profit and loss statements and trial balances, and the making of statutory returns as permitted by law, not the making of any subjective decisions in relation thereto. Examples include:

payroll services
data entry of revenue and expenses
basic depreciation calculations.

6. What is financial planning?

Financial planning means providing advice in respect of a client’s personal financial affairs, specifically related to wealth management, retirement planning, estate planning, risk management and related product advice. This includes:

1. investment advice
2. superannuation advice
3. estate planning
4. insurance
5. financial counseling.

7. Differences between external auditing, internal auditing, and information technology auditing?

External auditing is often called independent auditing because certified public accounting (CPA) firms that are independent of the client organization’s management perform them.

External auditors represent the interests of third-party stakeholders in the organization, such as stockholders, creditors, and government agencies.

IT auditing is usually performed as part of a broader financial audit. The IT auditor attests to the effectiveness of a client’s IT controls to establish their degree of compliance with prescribed standards. Because many of the modern organization’s internal controls are computerized, the IT audit may be a large portion of the overall audit.

Internal auditing is an appraisal function housed within the organization. Internal auditors perform a

wide range of activities on behalf of the organization, including conducting financial statement audits, examining an operation’s compliance with organizational policies, reviewing the organization’s compliance with legal obligations, evaluating operational efficiency, detecting and pursuing fraud within the firm, and conducting IT audits. 

External auditors represent third-party outsiders, whereas internal auditors represent the interests

of management.

8. What is auditing?

Auditing is a form of independent attestation performed by an expert—the auditor—who expresses an opinion about the fairness of a company’s financial statements.

9. What are non-accounting activities?

They include actuarial services, internal audit outsourcing services, and consulting.

10.  Who are stakeholders?

Stakeholders are individuals inside or outside the firm who have an interest in the system but are not end users. They include management, internal auditors, and consultants who oversee systems development.

11. Who are systems professionals?

Systems professionals include systems analysts, database designers, and programmers who design and build the system. Systems professionals gather facts about the user’s problem, analyze the facts, and formulate a solution. The product of their efforts is a new information system.

12. Who are end-users?

End users are those for whom the system is built. They are the managers who receive reports from the system and the operations personnel who work directly with the system as part of their daily responsibilities.

13. Code of ethics

The company’s code of ethics should outline procedures for dealing with actual or apparent conflicts of interest between personal and professional relationships.

Whereas avoidance is the best policy, sometimes conflicts are unavoidable. Thus, one’s handling and full disclosure of the matter become the ethical concern.

References:
1. CPA Website, GUIDE TO PUBLIC ACCOUNTING SERVICES, https://www.cpaaustralia.com.au/professional-resources/public-practice/getting-started-in-public-practice/guide-to-public-accounting-services.

2. Hall, James A. (2014) Accounting Information Systems, 9th edition, South-western Cengage Learning.

Accounting Information Systems (Day 01)

1. What is a goal?

A goal is something that we want to achieve in the end.

E.g. The goal of Conceptual Data Modeling is to develop an entity-relationship model that represents
the information requirements of the business.

2. What is a system in the context of Accounting Information System?

3. What is an Accounting Information System (AIS)? What is it used for?

AIS is used to provide information for decision makers. Information including

• Financial statements
• Managerial reports
• Reports to meet compliance requirements
• Information required by many different groups

An AIS is a collection of resources, such as people and equipment, designed to transform financial and other data into information.

4. What is an enterprise?


5. What is Transaction Processing System (TPS)? What is it used for?

TPS is used to process transactions by grouping them into Accounting cycles such as

• Revenue
• Expenditure
• Human Resources/Payroll
• Production
• Financing

6. What is General Ledger/Financial Reporting System (GL/FRS)?

7. What is Management Reporting System (MRS)?

8. What is Accounting?

9. What are financial transactions and nonfinancial transactions?

A financial transaction is an economic event that affects the assets and equities of the organization, is reflected in its accounts, and is measured in monetary terms. For examples, sales of products to customers, purchases of inventory from vendors, and cash disbursements and receipts are examples of financial transactions.

Nonfinancial transactions are events that do not meet the narrow definition of a financial transaction. For example, adding a new supplier of raw materials to the list of valid suppliers is an event that may be processed by the enterprise’s information system as a transaction. Important as this information obviously is, it is not a financial transaction, and the firm has no legal obligation to process it correctly or at all.

10. Do you need an ACN if you are a sole trader?

ASIC issues an Australian Company Number (ACN) for use in all business transactions. You need this before applying for an ABN. Additionally, partnerships, trusts and companies need a separate tax file number (TFN) to do business. (Sole traders use their personal TFN when dealing with any business tax matters).

11. What is the difference between a private limited company and a sole trader?
A limited company is its own legal identity, so as a shareholder your liability is limited (hence the name 'limited by shares'). As a sole trader, there is little distinction between you and the business. Any business debts become your debts and your personal assets - including your house - are not protected.

12. Is there a difference between sole trader and self-employed?

A sole trader is personally responsible for any losses that the business makes and responsible for paying tax on profits. A sole trader is a self-employed person who is the sole owner of their business. Sole traders do not have to have a director or register with companies' house.

13. What is an ERP?

Enterprise resource planning (ERP) system: a system that integrates all aspects of an organization’s activities—such as accounting, finance, marketing, human resources, manufacturing, inventory management—into one system. An ERP system is modularized; companies can purchase the individual modules that meet their specific needs. An ERP facilitates information flow among the company’s various business functions and manages communications with outside stakeholders.

14. What is EUS?

End-user system (EUS): a system developed by users, rather than information systems professionals, to meet their information needs. An EUS often draws upon the information in existing corporate databases to meet users’ information needs.

References:
1. Hall, James A. (2014) Accounting Information Systems, 9th edition, South-western Cengage Learning.
2. Romney, M.B. & Steinbart, P.J. (2009) Accounting Information Systems, 11th edition, Prentice Hall.

UNIX/Linux/Ubuntu system administration DAY 09

1. Linux/Unix commands

1. syslogd: logging capability

2. /etc/syslog.conf

3. /etc/rc.d/syslogd

1. vmstat 3: 

2. iostat 3

3. uname -r: linux version

1. mount

2. /etc/fstab

3. du

4. df

5. clear

Hardware and kernels

1. dmesg: hardware and kernel

2. lspci -k: basic information about the devices and modules

3. lsusb -t: usb devices are connected

4. dmidecode: look at CPU, RAM, Motherboard

5. dmidecode -t processor

6. x86info: overview of CPU

lsmode|less: find kernel module

modinfo sr_mod: to find out cd-rom drive info

modprobe -r -v sr_mode: unload the cd-rom drive

modprobe sr_mod: load cd-rom drive module

1. ls /proc

2. cat /proc/cpuinfo

The boot process

1. BIOS initilizes

2. The bootloader is called by the BIOS

3. The bootloader loads the first kernel image

4. The kernel then mounts filesystems and starts the appropriate system services

5. The system services finish starting up, and a login screen is presented.

1. arp 

2. ping

3. dig: DNS lookup utility

4. mtr: combines Ping and Traceroute into 1 program

5. netstat

6. nbstat

7. route

8. hostname

SSHD

1. scp (secure copy): secure transfer of files between two computers, operates on port 22

2. rcp (remote copy)

3. scp is replaced by SFTP protocol

4. sftp: ssh file transfer protocol

5. SFTP Simple File Transfer Protocol is no longer widely used

Network management using command line

1. sudo ifup -av: activate the network 

2. sudo ifdown -av: deactivate networking for all devices

3. sudo nm-tool: status of local network devices, driver, hardware address, wireless capabilities

4. ifconfig

5. iwconfig: wireless network configuration, detects wireless cards

6. iwlist: finds access points

7. route -n: displays routing table

8. sudo iwlist etho scan: find wireless hardware address

9. cat /etc/resolv.conf: looks at configuration file

or cat /etc/hosts

10. network-admin: GUI for network configuration

11. sudo route add default gw 192.168.0.1: add the default route via gateway

12. /etc/dhcp3/dhclient.conf: IP address of gateways, LAN domain name, DNS IP address, host-name, NTP server IP address

13. netstat -abn

14. cat /var/log/auth.log: look at all previous sudo-related commands

Network configuration files

1. /etc/hosts: hostname/IP address database

2. /etc/resolv.conf: DNS server IP address (nameserver)

3. /etc/network: folder storing configuration files

4. less /etc/network/interfaces

iface etho inet dhcp: use dhcp for assigning IP addresses

Search order

1. /etc/host.conf: order hosts, bind

2. /etc/nsswitch.conf: hosts: files dns

2. Red Hat Certified System Administrator (RHCSA)

Network interface

1. cd /etc/sysconfig/network-scripts

2. cat ifcfg-lo

3. cat ifcfg-eth0

Network manager handles the device.

1. system-config-network is replaced by network manager

2. system-config-network tool

Turn off NetworkManager in order to use system-config-network tool

1. service NetworkManager stop

2. chkconfig NetworkManager off

3. system-config-network

II. Network commands

1. ifconfig

2. ifconfig -a

3. ifconfig eth1 172.166.10.52 netmask 255.255.255.0

4. ifdown eth1: to shut the interface eth1 down

5. ifdown eth1 boot: 

6. ifup eth1

7. ifup eth1 boot

8. route

9. route add default gw 192.168.75.2 dev eth0

10. ip addr show : output like ifconfig command

11. ip route : view current routing table

12. ip -s link check if there is any drop packet

13. dhclient eth1: get DHCP ip address

14. ip addr show eth1

15. cd /etc/sysconfig

16. cat iptables: all firewall rules in the system

17. system-config-firewall

18. cat /etc/resolv.conf

19. cat /etc/hosts: resolve name

System logs

1. /var/log/messages: sys

2. /var/log

3. /var/log/dmes

4. /var/log/secure

5. /var/log/audit/audit.log

6. /var/log/yum.log

7. /var/log/boot

Display and understand system logs

1. tail /var/log/messages  

Database Day 08: Subquery

1. Simple subquery

Simple subquery doesn't use values from the outer query and is being calculated only once [1]:

SELECT StuID, StuFName, StuLName
FROM Student
WHERE StuID IN
(SELECT StuID
FROM Unit
WHERE UnitName= 'Database');

2. Derived Table/Inline-View subquery


3. Correlated subquery

"Correlated Subquery is a sub-query that uses values from the outer query. In this case, the inner query has to be executed for every row of the outer query." [1]

e.g.  Retrieve one instance of each employee's first and last name for which the bonus in the SalesPerson table is 5000 and for which the employee identification numbers match in the Employee and SalesPerson tables [2].

SELECT DISTINCT c.LastName, c.FirstName, e.BusinessEntityID
FROM Person.Person AS c JOIN HumanResources.Employee AS e
ON e.BusinessEntityID = c.BusinessEntityID
WHERE 5000.00 IN
    (SELECT Bonus
    FROM Sales.SalesPerson sp
    WHERE e.BusinessEntityID = sp.BusinessEntityID) ;

or

e.g. Find the Nth max salary by Co-related Sub-query [1].

SELECT Salary
FROM Employee E1
WHERE N-1 = (SELECT COUNT(*)
             FROM Employee E2
             WHERE E1.salary <E2.Salary)

References
[1] http://stackoverflow.com/questions/17268848/difference-between-subquery-and-correlated-subquery
[2] https://technet.microsoft.com/en-us/library/ms187638(v=sql.105).aspx

Data communications Day 03

1. What is bit?

• The bit is a basic unit of information in computing and digital communications. A bit can have only one of two values, and may therefore be physically implemented with a two-state device [1].

2. What is byte?

• The byte is a unit of information that consists of eight bits.

3. What is digital information?

• Digital information is a type of information stored using a series of ones and zeros, according to TechTerms.com. It is the most commonly used method of storing and reading data, as it can be copied, edited and moved without losing any quality.

4. What is bit rate?

• The number of bits per second that can be transmitted along a digital network.

5. What is bandwidth?

• The maximum bit rate that information can be transferred (commonly measured in bits/second)
• A range of frequencies within a given band, in particular that used for transmitting a signal.
• Bandwidth refers to the amount of information that something, like a connection to the Internet, can handle in a given time.
• Bandwidth is also defined as the amount of data that can be transmitted in a fixed amount of time.

6. What is transmission rate?

• The transmission rate is the rate in bits per second (or kilobits, megabits or gigabits per second) that data can be transmitted.

7. What is latency?

• The delay between the sender and the receiver that receives the decoded message (data), it is the function of the signals travel time, and the processing time at any nodes between them.
• Network latency refers to the time it takes for a packet of data to get from one point to another. In some cases, latency is measured by sending a packet that is returned to the sender; the round-trip time is considered the latency.

8. What is throughput?

• The actual rate that information (data) is transferred.

9. What is error rate?

• The number of corrupted bits expressed as a percentage or fraction of the total sent.

References
1. https://en.wikipedia.org/wiki/Bit