Your assignment will not be assessed without this. After you’ve completed the front page with your information, the plagiarism pledge and section A, save the document as a PDF.
computer science
Description
Module ICT3715
Year 2020
INFORMATION AND
COMMUNICATION TECHNOLOGY
ASSIGNMENT 2
DUE DATE: 30 APRIL 2020
STUDENT
NUMBER (Student completes)
|
|||||||||
|
|
|
|
|
|
|
|
|
|
|
|
IDENTITY NUMBER (Student completes) |
||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No handwritten assignments
will be accepted.
INSTRUCTIONS:
Instructions
for the student:
Complete this front page (page 1).
Complete the Plagiarism Pledge (page
3). Your assignment will not be assessed
without this.
After you’ve
completed the front page with your information, the plagiarism pledge and
section A, save the document as a PDF.
Keep a copy of the original should there be problem with the upload.
Instructions for the marker:
Marker indicate the marks obtained by the student for
each component of the assignment on page 2. Refer to the Criteria Document that
you’ve received for the detailed description and requirement for each
component. Comments are made in the
document itself and/or page 2.
System component
(Marker completes) |
Marks
|
|||
Markers
|
||||
|
Comments From Marker |
||||
|
|
Max |
Stud |
|
|
|
SECTION A Exporting and importing of data [20 marks] |
||||
|
Exporting and
importing of data from spreadsheets to tables. (Refer to Section
A in the Assignment and follow the process.
You are required to export the database, tables and imported data to a
SQL file. Combine the SQL file with
this document (in PDF) format and ZIP it together as one file) |
20 |
|
|
|
|
SECTION
B – Creating of Reports [30 marks] |
||||
|
Day-to-day Report
1 Unpaid Invoices |
5 |
|
|
|
|
Day-to-day Report
2 Birthdays |
5 |
|
|
|
|
Day-to-day Report
3 Supplements below
stock level |
5 |
|
|
|
|
MIS Report 1 Top 10 clients
(frequency) |
5 |
|
|
|
|
MIS Report 2 Month report |
5 |
|
|
|
|
MIS Report 3 Client Contact
report |
5 |
|
|
|
|
MARKER
(SIGNATURE) |
|
|
|
|
