Midterm - Machine Problem 6

Student Name: Date:

Learning Objective:

1. Develop and enhance understanding of computer algorithms, programming, and its

Problem:

Students will be creating a repair task log and task identifier using Google Sheet.
1. Create a sheet, name it “Task Log”, this sheet should have the following columns:
1. Task Code - this will be the identifier/key for repairs reported
2. Field of Issue - this will show what is the field of issue that was reported for
repair
3. Date Problem reported
4. Priority Level
5. Date of Service
6. Person in charge
7. Repair Status
2. The “Field of Issue” column should have a drop-down list with the following values:
1. Lighting
2. Electricity
3. A/C
4. Plumbing
5. Construction
3. The “Date Problem reported” column should use data validation, to validate the dates to
be entered. It should only accept dates between August 1, 2022 - September 30, 2023,
otherwise the invalid data should be rejected. Validation help text should also appear if
an invalid data is provided.
4. The “Priority Level” column should have a drop-down list containing high, mid,
low values.
5. The “Date of service” column should be in the Date data type, invalid data should be
rejected.
6. The “Person in charge” column should be in a drop-down list showing 5 different names.
You decide what names are included here. Name can just be initial format or first name
last name initial format (example: J.S, James S.)
7. The “Repair Status” column should be in checkboxes and it should be checked if the
repair is done and unchecked if not.
8. Provide sample data in the created “Task Log” sheet. It should have 25 records/rows. You
decide what details you will enter.
9. Create another sheet, name it “Task Identifier”.
10. Task identifier sheet should have the following column:
● Task code
● Field of issue
● Person in charge
● Repair Status
11. The “Task Identifier” sheet will show the Field of issue, Person in charge, and repair
status when the task code is provided.
12. “Task code” will be provided through the drop-down list. “Task code” data is obtained
from the “Task Log” sheet.
13. Protect/restrict the “Task Identifier” sheet to “only you” with the exception of the cell
containing the dropdown list for the task code. To protect, go to Data then select Protect
sheets and ranges. Specify in the sidebar the restriction settings.
14. Make your spreadsheet good-looking.
15. Turn in and attach your output to our Google classroom when you are done.

Rubrics Template

Criteria Rating (5) Rating (4) Rating (3) Rating (2) Rating (1)
All of the data
There are 3 There are 4 5 or more
in the There is 1 – 2
Data Entry incorrect incorrect data is
spreadsheet is incorrect data.
pieces of data. pieces of data. incorrect.
correct.
There are 5
The needed There is 1 There are 2 There are 3
Tool, or more
tool, functions incorrectly incorrectly incorrectly
Functions incorrectly
and formulas used tool, used tools, used tools,
and used tools,
were used function or functions or functions or
Formulas functions or
correctly formula. formulas. formulas.
formulas.
Error Free The output The output The output The output
Output has no error. has 1-2 errors. has 3-4 errors. has 5 errors.
The
The output The The
spreadsheet
turned in is spreadsheet spreadsheet
has more
Functionality functional and has 1-2 non- has 3 non-
than 3 non-
doing its functional functional
functional
purpose. tables. tables.
tables.
The
spreadsheet
layout created
The
has additional The
spreadsheet
Visual elements that spreadsheet
layout created
Appearance are pleasing layout is
is pleasing to
to the eyes as confusing.
the eyes.
well as easy
to read and
understand.
The output is
submitted
Punctuality
within the due
date.

Overall Rating: 25 points

__________________________ __________________________
Student Signature Instructor Signature