ITX203 – End of Year Assessment Review and MS Database Project (Trinity 4th to 18th June 2021)

End of Year Assessment (2021)

Assignment #1: June 4th – 7th

• Read textbook chapters 1 and 3 
• Answer end of chapter questions. Upload assignment here.

Review Quizzes Assignment #1

• IT Midterm Practice Quiz (Term 1 2020 – 2021) Computer Fundamentals (Year End Review)
• IT Midterm Practice Quiz (Term 1 2020 – 2021) – Intro to Problem-solving (Year End Review)
• IT Midterm Practice Quiz (Term 1 2020 – 2021) – Hardware (Year End Review)
• IT Midterm Practice Quiz (Term 1 2020 – 2021) – Software and Networking (Year End Review)
• IT Midterm Assessment (Term 1 2020 – 2021) – All Levels (Year End Review)
• http://quizizz.com/join?gc=35304506

Assignment #2: June 8th – 12th

• total = 0
• count = 0
• average = 0
• OUTPUT ‘Enter Mark’
• INPUT mark
  • WHILE (mark is not equal to -1)
  • total = total + mark
  • count = count + 1
  • OUTPUT ‘Enter Mark’
  • INPUT mark
  • ENDWHILE
• IF count equal 0 THEN
• OUTPUT ‘No Marks Entered’
• ELSE
• average = total/count
• DISPLAY average
• END IF
• Convert the above pseudocode to a program using the SmallBasic web environment. (10 total point)Hints:

  Text OUTPUT is written as:

  TextWindow.WriteLine(“Text”)

  Variable OUTPUT is written as: TextWindow.WriteLine(variable name)

  INPUT of a variables count and name are written as the following examples:

  count = TextWindow.Read()

  name = TextWindow.Read()

• SmallBasic Online Environment
• ITX202 Midterm Assessment (Year End Review 2020 – 2021)
• Quizizz Quiz (Link is not currently enabled)

MS Access Database Project – due by Friday 18th, June 2021.

Complete Exercise 19 and do the following in your “bookshop” database:

• Create a PopUp form named “frmMain”
• Change your customer, order and product forms to PopUp forms
• Add 3 buttons to “frmMain” that will open your customer, order and product forms, using Macros
• Copy frmMain and save as frmMainMacro
• Convert Macros on frmMain to Visual Basic
• Set frmMain to open when the database is opened.
• Convert database to a zip file and upload (Recommended)
• Or email zip file to: apurcell@stgeorgesinstitute.org

Final Submission Due by Friday 18th, June 2021. Upload assignment here.