AIS160 - FUNDAMENTALS OF INFORMATION TECHNOLOGY

Important Announcement

Carry marks - AC1102E | AC1102F

Lesson plan 

Weekly Lesson Plan

Online test Oct23|May23|Dec22| May22|Dec21|Feb21| 

FINAL EXAM Question Feb24|

FINAL EXAM Self Test Feb24|

How to download Windows, Ms Project, Ms Visio, Visual Studio, and other software in Microsoft Azure Education

Text book

Jennifer T. Campbell, Mark Ciampa, Steven M. Freund, Mark Frydenberg, Susan Sebok, Misty E. Vermaat, Barbara Clemens (2022). Discovering Computers: Digital Technology, Data, and Devices, 17th Edition, Course Technology, ISBN: 9780357675472.

Assessment 

1. Test - 50 marks (15%) - Week 5 | Results 2E | Results 2F |
2.  Lab Test - 15 marks (15%) - Week 9 | Results 2E | Results 2F |
3. Group Project - 20 marks  (20%) - Week 11-14
4. Carry Marks - | AC1102E | AC1102F |
5. Final Examination - 100 marks (50%) - Final Examination Week

Week 1 - An Overview of Today’s Technologies, Computer, Devices and The Web (Test)

Lecture notes - click here

Lecture video - whatapps group

Videos - 1 | 2 | 3 | 4 | 5 |

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Introduction on OBE-SCL 
2. Entrance survey - 25 Mac 2024 
3. Assessment plan 
4. SLT 
5. Ice breaking - Google form 
6. Tick attendance - ufuture 
7. Inform Grouping 
8. Today's technologies 
9. Computer and mobile devices 
10. Data and information 
11. Digital safety and security 
12. Programs and applications 
13. Communications and networks 

Week 2-3 - Computing Components - (Test)

Lecture notes - click here
(Others) T3 | T6 | T7 |

Lecture video - whatapps group

Videos - 1 | 2 | 3 | 4 | 5 |

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Grouping - fill it up and upload at whatsapp group 
2. Entrance survey - Check 
3. SLT - Re-explain for 
4. Do some excersices 
5. Processors - video 
6. Memory - video 1 | video 2 
7. The Cloud - video 1 | video 2 
8. Input - video 
9. Output - video 
10. Digital storage - video 

Week 4-5 - Computer operating systems, programs and applications

(Final Examination)

Week 5 - Test (Cover Week 1 & 2)

Combine notes : Click here

Lecture notes - T3 | T4 | T8 | 

Lecture video - whatapps group

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Entrance survey - Check 
2. Grouping - Check
3. Types of operating systems - Video 1 | Video 2
4. Operating system functions - Video 1 | Video 2 
5. Introduction to Window Operating system - Video
6. Overview of programs and apps - Video
7. Productivity applications - Video
8. Graphic and media software - Video
9. Other applications

Week 6 - Lab: Spreadsheet Software (Lab Test)

Instructions 

1. Bring you own device
2. With installed MS Excel
3. Note book to jot down instructions and notes

Coverage

Spreadsheet’s interface

Entering and correcting data

Using formulas and functions (min, max, median, average, sum)

Editing and formatting a worksheet

Creating chart

Week 7-8 - Lab: Database Software (Lab test)

Instructions 

1. Bring you own device
2. With installed MS Access
3. Note book to jot down instructions and notes

Lecture Notes

File to download (Exercise)

1. Introduction to Microsoft Access - Video 1
2. Overview of data, databases and information -  Video 1
3. File processing systems and databases - Video 1
4. Database Management system - Video 1
5. Application Development Languages and tools

Mirosoft Access

1. Introduction to Database
2. Introduction to Objects
3. Getting Started
4. Working with Database
5. Working with Tables
6. Customizing Tables
7. Working with Forms
8. Sorting and Filtering Records
9. Designing a simple Query
10. Multi-table Queries Part 1
11. Multi-table Queries Part 2
12. Modifying Queries
13. Create a Totals Query
14. Creating Reports
15. Printing Reports
16. Use the Reports Wizards
17. Formatting Reports
18. Modifying Tables
19. Creating Form
20. Customizing Forms settings
21. Formatting Forms
22. Others - How To Change Currency Microsoft Access 

File to download (Exercise)

Student Ms Access - sample Q for excercise

1. Step 1: Create and Rename a File
2. Step 2: Create and Format the Manufacturers Table
3. Step 3: Create and Format the Customers Table
4. Step 4: Create and Format the Manufacturers Form
5. Step 5: Create and Format the Customers Form
6. Step 6: Enter data into a form for the Manufacturers 
7. Step 7: Enter data into a form for the Customers
8. Step 8: Create Queries - Sorting the customer’s record
9. Step 9: Create Queries - Customers from MRAN
10. Step 10: Create Queries - Manufacturers discount of => 5%
11. Step 11: Create Queries - Customers Purchase
12. Step 12: Create Queries - City Jengka
13. Step 13: Create Report - Customers Purchase

Week 9-10 - Communication and Network - (Final Examination)

Combine notes : Click here

Lecture notes - T2 | T9 | 

Self test - Test 1 | Test 2 | Test 3 | 💥

1. The internet - Video 
2. Websites - Video 
3. Media 
4. Wired and wireless networks - Video 
5. Communication and network devices - Video 1 | Video 2 
6. Netiquette - Video 

Week 11 - Lab: Word Processing Software - (Group Project)

1. Working with graphics
2. Creating tables
3. Working with long documents (research paper)

Week 12 - Lab: Presentation Software - (Group Project)

File to download (Exercise)

Task

1. Refine/summarize into 5 slides only
2. Improve the first page
3. Include - Graphics
4. Include - animations 
5. Add - sound effect 
6. Add - slide transition
7. Add - Hyperlink (any files)
8. Add - a video

Topic content

1. Working with graphics / clip art / import from internet / hyperlink
2. Applying with animation schemes
3. Viewing the slides in a presentation
4. Annotations slides in a presentation

Week 13 - Digital Security, Ethics and Privacy - (Final Examination)

Lecture notes - Click here

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Digital security risks video 1 | 
2. Internet and network attacks video 1 | video 2 | Video 3 
3. Unauthorized access and use video 1 |
4. Software and information theft video 1 | 
5. Hardware theft, vandalism and failure video 1 | Video 2 
6. Wireless security video 1 | video 2 | 
7. Ethics and society video 1 | 
8. Information privacy video 1 | 

Week 14 - Emerging Trends in IT - (Final Examination)

AI - Lecture notes 💥

1. Overview of Artificial Intelligence | ST1 | ST2 | ST3 | 
2. The Role of AI | ST1 | ST2 | ST3 | 

Important Announcement

💖 CARRY MARKS

Lesson plan ✅✔☑ ❕

Grouping : AC1102A, AC1102B, AC1102C/5A & AC1102D, 

Online test Oct23|May23|Dec22| May22|Dec21|Feb21| 

FINAL EXAM Question Feb24|

FINAL EXAM Self Test Feb24|

How to download Windows, Ms Project, Ms Visio, Visual Studio, and other software in Microsoft Azure Education

Text book - Click here to purchase ✅✔☑❕

Jennifer T. Campbell, Mark Ciampa, Steven M. Freund, Mark Frydenberg, Susan Sebok, Misty E. Vermaat, Barbara Clemens (2022). Discovering Computers: Digital Technology, Data, and Devices, 17th Edition, Course Technology, ISBN: 9780357675472.

Assessment 

1. Online Quiz 15% ✅
2. Group Project 20% | Results
3. Lab Test 15% | Results
4. Final Examination 50%

☑5A 28 ❕5B 30 ✅5C 29+1 ✔5D 29

Week 1 - An Overview of Today’s Technologies, Computer, Devices and The Web

(Final Examination)

Lecture notes - click here

Lecture video - whatapps group

Videos - 1 | 2 | 3 | 4 | 5 |

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Introduction on OBE-SCL ✅✔☑❕
2. Entrance survey - 25 Mac 2024 ✅✔☑❕
3. Assessment plan ✅✔☑❕
4. SLT ✅✔☑❕
5. Ice breaking - Google form ✅✔☑❕
6. Tick attendance - ufuture ✅✔☑❕
7. Inform Grouping ✅✔☑❕
8. Today's technologies ✔☑ ❕✅
9. Computer and mobile devices ✔☑ ❕✅
10. Data and information ✔☑ ❕✅
11. Digital safety and security ✔☑ ❕✅
12. Programs and applications ✔☑ ❕✅
13. Communications and networks ✔☑ ❕✅

Week 2 - Computing Components

(Quiz/Final Examination)

Lecture notes - T3 | T6 | T7 |

Lecture video - whatapps group

Videos - 1 | 2 | 3 | 4 | 5 |

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Grouping - Download, fill it up and upload at whatsapp group ✅✔
2. Entrance survey - Check ✅✔
3. SLT - Re-explain for ✅✔
4. Do some excersices ✅✔
5. Processors - video ✅✔
6. Memory - video 1 | video 2 ✅✔
7. The Cloud - video 1 | video 2 ✅✔
8. Input - video ✅✔
9. Output - video ✅✔
10. Digital storage - video ✅✔

Week 3-4 - Computer operating systems, programs and applications

(Quiz/Final Examination)

Combine notes : Click here

Lecture notes - T3 | T4 | T8 | 

Lecture video - whatapps group

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Entrance survey - Check ✅✔
2. Grouping - Check - None from 2C ✔
3. Types of operating systems - Video 1 | Video 2✅✔☑❕
4. Operating system functions - Video 1 | Video 2 ✅✔☑❕
5. Introduction to Window Operating system - Video✅✔☑❕
6. Overview of programs and apps - Video✅✔☑❕
7. Productivity applications - Video✅✔☑❕
8. Graphic and media software - Video✅✔☑❕
9. Other applications✅✔☑❕

Week 5 - Communication and Network

(Quiz/Final Examination)

Combine notes : Click here

Lecture notes - T2 | T9 | 

Self test - Test 1 | Test 2 | Test 3 | 💥

1. The internet - Video ✅✔☑❕
2. Websites - Video ✅✔☑❕
3. Media ✅✔☑❕
4. Wired and wireless networks - Video ✅✔☑❕
5. Communication and network devices - Video 1 | Video 2 ✅✔☑❕
6. Netiquette - Video ✅✔☑❕

Week 6-7 - Digital Security, Ethics and Privacy

(Group Project/Final Examination)

Lecture notes - T5

Self test - Test 1 | Test 2 | Test 3 | 💥

1. Digital security risks video 1 | ✅✔☑❕
2. Internet and network attacks video 1 | video 2 | Video 3 ✅✔☑❕
3. Unauthorized access and use video 1 |✅✔☑❕
4. Software and information theft video 1 | ✅✔☑❕
5. Hardware theft, vandalism and failure video 1 | Video 2 ✅✔☑❕
6. Wireless security video 1 | video 2 | ✅✔☑❕
7. Ethics and society video 1 | ✅✔☑❕
8. Information privacy video 1 | ✅✔☑❕

Week 8 - Emerging Trends in IT

(Final Examination)

Cloud Computing - Lecture notes

Self test T/F     : Test 1 | Test 2 | 

Self test MCQ  : Test 3 | Test 4 | 💥

1. Introduction to Cloud Computing video 1✅✔☑❕
2. Cloud Computing Models Video 1✅✔☑❕
3. Public and private clouds Video 1✅✔☑❕
4. Cloud computing benefits Video 1✅✔☑❕
5. Cloud computing challenges Video 1✅✔☑❕

Financial Technology (FinTech) - Lecture notes

Self test T/F       : Test 1 | Test 2 | 

Self test MCQ    : Test 3 | Test 4 | 💥

1. What is FinTech? Video 1✅✔☑❕
2. Major areas in FinTech Video 1✅✔☑❕
3. Prospects and potential issues with FinTech Video 1✅✔☑❕

Week 9 - Lab: Word Processing Software

(Group Project)

1. Working with graphics
2. Creating tables
3. Working with long documents (research paper)

Week 10-11 - Lab: Spreadsheet Software

(Group Project)

1. Spreadsheet’s interface
2. Entering and correcting data
3. Using formulas and functions (min, max, median, average, sum)
4. Editing and formatting a worksheet
5. Creating chart

Week 12 - Lab: Presentation Software

(Group Project)

File to download (Exercise)

Task

1. Refine/summarize into 5 slides only
2. Improve the first page
3. Include - Graphics 
4. Include - animations 
5. Add - sound effect 
6. Add - slide transition
7. Add - Hyperlink (any files)
8. Add - a video

Topic content

1. Working with graphics / clip art / import from internet / hyperlink
2. Applying with animation schemes
3. Viewing the slides in a presentation
4. Annotations slides in a presentation

Week 13-14 - Lab: Database Software

(Lab test)

Instructions 

1. Bring you own device
2. With installed MS Access
3. Note book to jot down instructions and notes

Lecture Notes

File to download (Exercise)

1. Introduction to Microsoft Access - Video 1
2. Overview of data, databases and information -  Video 1
3. File processing systems and databases - Video 1
4. Database Management system - Video 1
5. Application Development Languages and tools

Mirosoft Access

1. Introduction to Database
2. Introduction to Objects
3. Getting Started
4. Working with Database
5. Working with Tables
6. Customizing Tables
7. Working with Forms
8. Sorting and Filtering Records
9. Designing a simple Query
10. Multi-table Queries Part 1
11. Multi-table Queries Part 2
12. Modifying Queries
13. Create a Totals Query
14. Creating Reports
15. Printing Reports
16. Use the Reports Wizards
17. Formatting Reports
18. Modifying Tables
19. Creating Form
20. Customizing Forms settings
21. Formatting Forms
22. Others - How To Change Currency Microsoft Access 

File to download (Exercise)

Student Ms Access - sample Q for excercise

1. Step 1: Create and Rename a File
2. Step 2: Create and Format the Manufacturers Table
3. Step 3: Create and Format the Customers Table
4. Step 4: Create and Format the Manufacturers Form
5. Step 5: Create and Format the Customers Table
6. Step 6: Enter data into a form for the Manufacturers 
7. Step 7: Enter data into a form for the Customers
8. Step 8: Create Queries - Sorting the customer’s record
9. Step 9: Create Queries - Customers from MRAN
10. Step 10: Create Queries - Manufacturers discount of => 5%
11. Step 11: Create Queries - Customers Purchase
12. Step 12: Create Queries - City Jengka
13. Step 13: Create Report - Customers Purchase