AIN3701

This document provides a detailed breakdown of the AIN3701 final examination for Oct/Nov 2024, including instructions, exam rules, submission procedures, and the use of the Invigilator App. It covers essential guidance for students, outlines allowed materials (e.g., Pre-seen info and VBA Coding Sheet 2024), and provides sample multiple-choice questions with correct answers and explanations. This resource is aligned with UNISA’s exam standards and requirements. What role does automation play i...

This document provides a complete solution for AIN3701 Assignment 2 (2024), including both the VBA coding task and the written theoretical responses. The VBA code calculates the income tax payable based on an employee’s annual salary and age, using SARS 2024 tax brackets and rebates. The theoretical sections address the benefits of functions in VBA, advantages of task automation, and potential risks in VBA

This document provides a summary of an AIN3701 discussion class on coding fundamentals, focusing on Visual Basic for Applications (VBA) in Microsoft Excel. It introduces VBA’s role in automating repetitive tasks and improving data analysis. Key topics include the benefits and risks of using VBA, practical applications in Excel, and considerations regarding software compatibility and cybersecurity. The session also includes safety notices and class interaction guidelines.

This document covers the Big Data study unit from AIN3701, part of the Advanced Information Systems module at UNISA. It discusses the transition to Big Data, its benefits and challenges, and the nature of data analysis in this context. The summary includes both structured and unstructured data types, with real-world examples from various digital sources.

1.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 1.2 WHAT IS COMPUTATIONAL THINKING? 1.3 THE PILLARS OF COMPUTATIONAL THINKING 1.4 CLOSING REMARKS 1.5 REFERENCES

2.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 2.2 WHAT IS AUTOMATION? 2.3 WHAT PROCESSES CAN BE AUTOMATED? 2.4 BENEFITS AND RISKS ASSOCIATED WITH AUTOMATION 2.5 COGNITIVE COMPUTING SYSTEMS IN THE AUTOMATION PROCESS 2.6 CLOSING REMARKS 2.7 REFERENCES

5.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 5.2 THE WORLD OF DATA 5.3 DATA ANALYTICS FOR ACCOUNTING AND RELATED SERVICES 5.4 THE DATA ANALYTICS PROCESS 5.5 STEP 1: IDENTIFY THE QUESTIONS (I) 5.6 STEP 2: MASTER THE DATA (M) 5.7 STEP 3: PERFORM TEST PLAN (P) 5.8 STEP 4: ADDRESS AND REFINE RESULTS (A) 5.9 STEP 5: COMMUNICATE INSIGHTS (C) 5.10 STEP 6: TRACK OUTCOMES (T) 5.11 CLOSING REMARKS 5.12 REFERENCES

INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA) 3.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 3.2 WHY PROGRAMMING LANGUAGES? 3.3 TYPES OF PROGRAMMING STRUCTURES 3.4 THE MACRO RECORDER VS MANUALLY GENERATING VBA CODE 3.5 VALUABLE CODING ADVICE 3.6 ASSIGNING VALUES BY USING VBA 3.7 CHANGING CELL/RANGE FORMATTING PROPERTIES 3.8 EXPLORING MORE PROPERTIES AND ACTIONS IN THE EXCEL OBJECT 3.9 ADDING COMMENTS TO YOUR VBA CODE 3.10 COPYING AND PASTING ACTIONS IN VBA 3.11 ASSIGNING VBA ...

4.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 4.2 VARIABLES 4.3 DETERMINING THE LAST ROW BY USING VBA 4.4 SELECTION OF PROGRAMMING STRUCTURES 4.5 LOOP PROGRAMMING STRUCTURES 4.6 FUNCTION PROCEDURES 4.7 BRINGING IT ALL TOGETHER 4.8 CLOSING REMARKS 4.9 REFERENCES

Performance Assessment: Manage Windows Users, Groups, and Access Control Lists (ACLs) In this Performance Assessment, you will perform the tasks you have been taught in the Guided Practices. You may use the book, and any notes you have, along with the Linux man pages and Windows Server help utilities. You may look at your prior output. You may not give or receive help from other students. You may ask your instructor for assistance, but it is likely to cost points. Resources Needed ⦁ Wind...

Introduction In the United States, health policy is based on political, ideological, and socioeconomic environments, with major private institutions and public entities shaping the American healthcare system. Patel and Rushefsky (2020) point out issues faced with the American health system, such as the increasing healthcare cost, analysis on quality and access of Medicare, Veterans Health Administration, Medicaid, and impacts related to healthcare technology advances. This essay discusses ...