Question

11. Using your school's student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the class room number. Use Figure P1.11 as a template to complete the following actions. FIGURE P1.11 STUDENT SCHEDULE DATA FORMAT STU_ID STU_NAME CLASS_CODE CLASS_NAME CLASS_CREDHRS INSTR_NAME CLASS_DAYS CLASS_TIMES ROOM a. Create a spreadsheet using the template shown in Figure P1.11 and enter your current class schedule. b. Enter the class schedule of two of your classmates into the same spreadsheet. c. Discuss the redundancies and anomalies caused by this design.

          11. Using your school's student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the class room number. Use Figure P1.11 as a template to complete the following actions.
FIGURE P1.11 STUDENT SCHEDULE DATA FORMAT
STU_ID
STU_NAME
CLASS_CODE
CLASS_NAME
CLASS_CREDHRS
INSTR_NAME
CLASS_DAYS
CLASS_TIMES
ROOM
a. Create a spreadsheet using the template shown in Figure P1.11 and enter your current class schedule.
b. Enter the class schedule of two of your classmates into the same spreadsheet.
c. Discuss the redundancies and anomalies caused by this design.

Show more…

11. Using your school's student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the class room number. Use Figure P1.11 as a template to complete the following actions.
FIGURE P1.11 STUDENT SCHEDULE DATA FORMAT
STUID
STUNAME
CLASSCODE
CLASSNAME
CLASSCREDHRS
INSTRNAME
CLASSDAYS
CLASSTIMES
ROOM
a. Create a spreadsheet using the template shown in Figure P1.11 and enter your current class schedule.
b. Enter the class schedule of two of your classmates into the same spreadsheet.
c. Discuss the redundancies and anomalies caused by this design.

Added by Scott W.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

10/05/2023

Step 1

To create a spreadsheet using the template shown in Figure P1.11, you can open a new Excel file and create column headers for each of the data fields mentioned in the template: STU_ID, STU NAME, CLASS CODE, CLASS NAME, CLASS INSTRUCTOR NAME, CLASS CREDHRS, CLASS Show more…

Show all steps

lock

Thanks for your feedback!

Play audio

Feedback

Powered by NumerAI

Akash M and 81 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

00:01 So, here the question is in parts.

00:03 So, for this for making this spreadsheet part a for making a spreadsheet, we can provide you a form and you can enter your current class schedule on the given format.

00:25 Student name, then class code, then class name, after that class instructor name.

00:45 Okay, it is like the long process class instructor name.

00:52 First, we can write this, after then we can continue, after that we can continue.

01:02 So, first student id will be 1 2 3 4 5, 4 3 2 1, 9 8 7 6 5.

01:13 This is john joy, this is jane smith and alice lee.

01:24 Class code will be cs 101, eng 201, maths 301.

01:35 Now, class name will be introduction to computer science, intro to computer science, english composition and calculus 1.

01:50 Class instructor name will be professor smith, professor johnson and professor brown.

02:03 Now, we continue this table.

02:07 So, here it is class credit hours, class days, class time and room.

02:27 So, here it is we have to put the values.

02:32 So, this is the format for the particular table.

02:35 You can put your exact date on this.

02:38 So, class credit hours is 3 4 4, class days mwf, tth mwf, class time is 10 am to 11 .30 am.

03:00 1 pm to 2 .30 pm, 2 pm to 3 .30 pm.

03:11 Rooms are 101, 202, 303...

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later