Access levels

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

Access levels

Name:
Date:
Class:

Quick Questions

Shade in the A or B circle for each question.

1. A student needs to look at the school timetable but must not change it. Which access level fits best?
A Read only
B Read/write
2. A student's files must stay private from other students. What access level should other students have on them?
A Read only
B No access
3. Which statement about access levels is correct?
A They give different users different rights to the same data
B They give every user the same rights to all data
4. A teacher needs to open a mark sheet and update the marks. Which access level is needed?
A Read/write
B Read only
5. Who normally has full control, such as creating accounts and changing other users' access levels?
A An ordinary user
B An administrator

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left columnRight column
1Student: Read only AGiving all users full control ignores the idea of access levels. Rights should be set per file or folder to match each role.
2Teacher: Read/Write BStudents can edit their own marks, which harms integrity. They should only have read only access, or no access.
3No access stops a user from even seeing a folder, which protects confidentiality. CPayroll folder -> Student: No access
4An administrator has full control, while an ordinary user has fewer rights. DThe user can open and view the file but cannot change, delete or save edits to it.
5Marks file -> Student: Read/Write EAdmin: Full control, User: Read only
6Everyone: Full control on every file FThe user can open the file and also edit, add or delete its contents.

Definitions

access levels

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
SET Marks.xls FOR Student TO ________
2.
SET Marks.xls FOR Teacher TO _________
3.
SET Payroll FOR Visitor TO ________
4.
SET Settings FOR _____ TO FULLCONTROL
5.
IF level = ________ THEN OUTPUT "Cannot edit file" ENDIF

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A level ← "read"
B IF level = "none" THEN
C OUTPUT "Access denied"
D ELSE IF level = "full" THEN
E OUTPUT "View only"
Question 2
A staffLevel ← none
B IF staffLevel = "none" THEN
C OUTPUT "Access denied"
D ENDIF
Question 3
A file ← "Marks.xlsx"
B pupilLevel ← "full"
C IF pupilLevel = "read" THEN
D OUTPUT "Cannot edit marks"
Question 4
A IF role = "admin"
B level ← "full"
C ELSE
D level ← "read"
E ENDIF
Question 5
A folder ← "Reports"
B level ← "read/write
C IF level = "read/write" THEN
D OUTPUT "Can view and edit"
E ENDIF

Answer Key

Access levels
Section A: Quick Questions
Q1
A — Read only
Q2
B — No access
Q3
A — They give different users different rights to the same data
Q4
A — Read/write
Q5
B — An administrator
Section B: Match the Pairs
Q1
Student: Read only → The user can open and view the file but cannot change, delete or save edits to it.
Q2
Teacher: Read/Write → The user can open the file and also edit, add or delete its contents.
Q3
No access stops a user from even seeing a folder, which protects confidentiality. → Payroll folder -> Student: No access
Q4
An administrator has full control, while an ordinary user has fewer rights. → Admin: Full control, User: Read only
Q5
Marks file -> Student: Read/Write → Students can edit their own marks, which harms integrity. They should only have read only access, or no access.
Q6
Everyone: Full control on every file → Giving all users full control ignores the idea of access levels. Rights should be set per file or folder to match each role.
Section C: Definitions
Q1
access levels — Settings that give each user different rights to data: no access, read only, read/write or full control. Users only see and change what their role needs, protecting confidentiality and integrity.
Section D: Fill in the Blanks
Q1
SET Marks.xls FOR Student TO READONLY
Q2
SET Marks.xls FOR Teacher TO READWRITE
Q3
SET Payroll FOR Visitor TO NOACCESS
Q4
SET Settings FOR Admin TO FULLCONTROL
Q5
IF level = READONLY THEN OUTPUT "Cannot edit file" ENDIF
Section E: Spot the Error
Q1
D — The branch prints "View only", so it must test for the read-only level. It should be ELSE IF level = "read" THEN. "full" is the administrator level, which can do much more than view.
Q2
A — The access level is a text value, so it needs quote marks. It should be staffLevel ← "none". Without quotes, none looks like a variable name.
Q3
B — A pupil should only have read-only access to the marks file. Full control would let them change their marks, which breaks integrity. It should be pupilLevel ← "read".
Q4
A — An IF statement must end with THEN. The line should be IF role = "admin" THEN. Administrators get full control and ordinary users get read-only access.
Q5
B — The string is missing its closing quote mark. It should be level ← "read/write". Every text value must start and end with a quote.