Computational Thinking for Information Technology

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP STUDENT SCENARIO:database management systems You have been asked to join Quick-Help-Desk, Inc.’s database software development team to work on a help desk database management system focused on maintaining help desk records at Kippy College. David Andrews will be your virtual guide and supervisor for this scenario. Your instructor will act as your project manager.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Objectives This course will enable you to develop logical thinking skills, including: • Asking probing questions to uncover details of a problem • Clearly defining a problem • Defining clear success criteria for the project including measurable objectives • Making design decisions based on rational criteria • Seeing “the big picture” • Deconstructing the problem into its component parts

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Objectives (cont.) This course will enable you to develop logical thinking skills, including: • Correlating the relationships between components and prior knowledge • Identifying the steps required to solve a problem • Identifying the sequence of steps including possible decisions and alternatives • Identifying normal and exceptional behaviors of a solution • Identifying available resources

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Objectives (cont.) This course will enable you to develop logical thinking skills, including: • Developing a solution that uses only available resources • Measuring and adapting the solution to optimize resource utilization • Measuring and evaluating solutions against the success criteria • Adjusting the design and implementation as needed

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Project Assumptions Kippy College’s IT department wants the IT staff members to be able to pull up the help desk records of a computer at the college before they work on it. • Kippy has approximately 10 staff members, 10 faculty members and 200 students The help desk database management systems IS system will be a proof of concept – other features can be added later. • Assume each user has just one computer • One small office/department, or • Limited-number user population

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP User Requirements • The IT staff consists of two technicians. They will each have one computer so they can see the computer maintenance history which should be available for each computer in the campus building. • Each staff and faculty member has one computer. • The students will have access to 3 PC labs (16 computers per lab).

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP User Requirements (cont.) • Kippy’s IT Department identifies each computer by office or room number or name and a computer number, plus make, model and year, etc. • Need to have a maintenance history including work performed, date received and completed. • The system will need to track hours worked for each department (faculty/staff and students). There is no plan to have this system interface with billing in the future.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP User Requirements (cont.) Certain operations are performed regularly by Kippy’s IT Department. • Setup freeze and schedule for unfreezes to obtain: • Operating system updates/patches • Application software updates • Anti-virus, etc. • PC Technicians will need an opportunity to write notes about specifics. • Need to be able to list recommended work, if not performed, so they can check or address at a later visit. This can be in free form text.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Why you’re here You have been asked to work on a help desk database system focused on managing a local college PC maintenance records. By joining this development team for this project at Quick-Help-Desk, you have affiliated with a talented group. We pride ourselves in bringing the best and the brightest database programmers on board. This will be obvious to you when you participate in weekly tasks during development.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Expectations (cont.) Pay attention to my suggestions for succeeding at work. You will be working on individual projects and in teams throughout your affiliation with Quick-Help-Desk, so take the time to learn how to do it the “Quick-Help-Desk way.” The “Quick-Help-Desk way” includes teamwork, tasks, and professional-level presentation of results.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP Online Resources Questionnaires • How to Write a Questionnairehttp://www.ehow.com/how_16596_write-survey-questionnaire.html • Questionnaire Design http://www.cc.gatech.edu/classes/cs6751_97_winter/Topics/quest-design/ Proposal Writing • How to Write a Proposalhttp://www.ehow.com/how_2052820_write-proposal.html • Proposal Writinghttp://facstaff.gpc.edu/~ebrown/pracguid.htm

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP TASKS AND ASSIGNMENTS (continued) Our Research & Development assistant has gathered Resources for you to reference as you complete the Tasks assigned. If you have suggestions for additional resources, please post them to the Discussion area of your project website. After you have completed each task, review Debrief questions to confirm your learning and understanding of the task.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Tips for Success: • Get to know each other by posting a brief bio at your group’s discussion area. Use this as a means of identifying any special talents and getting your group organized. • When developing your questionnaire be sure to use compatible word processing software such as MSWord and save it in universal format such as .rtf. • In your proposal, be sure to use proper grammar and spell check.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • More Tips for Success: • You are encouraged to submit ONE draft of each deliverable for your manager's review. In order to receive feedback and incorporate it into your final submission, your draft must be submitted via email to your project manager at least 24-48 hours before the due date. You will submit your final draft at your group’s file exchange area by the due date as indicated. Be sure to include the names of each group member who helped in developing each of the deliverable’s final drafts.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Task 1 Overview • Marketing has set up a meeting so you can interview Kippy College’s office manager, who is also the IT manager. Interviewing a user will allow you to take the abstract concept for the PC maintenance records management system and generate a set of concrete functional specifications for it. • The office manager happens to be the person pushing to automate systems and knows the needs of users of the database management system you are developing. • Ask her any and all questions about how she • wants to use the system and derive your • proposal from her responses.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Deliverables: • Database Management System Proposal • Scope of Project & Hardware/Software System Requirements (1-2 pages) • Definition of Roles with Individual Tasks and Calendar Work Schedule • Introduce yourself at your Group's website discussion board • Divide responsibilities within your group/create a proposed schedule

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Notes: • Your team is under a tight schedule to produce these items. Work together as quickly and efficiently as possible to complete them. You will to post them by the due as indicated by your project manager at your group’s online file exchange area. • Please post questions well in advance, at least 48 hours before the due date, in the Discussion area of our project website since I will be traveling. • Good luck.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Action Plan (cont.): • Confer with your team and write a project proposal to include a description of your database and the software/hardware requirements. • Consider the expertise you have in your team members and submit a proposed schedule of work with division of team member responsibilities. Use the sample team schedule template spreadsheet.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Checklist for Submitting Your Work: • Before you submit your deliverables, check that you have attended to the following areas of the task: • Did you list the database website addresses, website names and software descriptions in your list of help desk database help examples? • Did you a common word processing format for your documents? • Did you write 5-6 client questions? • Did you create your proposal and document the hardware/software requirements? • Did you use proper grammar and spelling in • your documents? • Did you use the team schedule template? • (file teamschedule.xlsx)

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Debrief: • Reflect on what we've learned from this task by discussing the following questions with your colleagues and manager(s): • Did you find and learn about features in other help desk database software systems? • Does your questionnaire include enough thorough questions that you would need to ask your client to develop a help desk database? Is your proposal addressing the needs of the user? How did your team reach consensus on their job roles? Did you develop a schedule that would meet the request of this project?

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Deliverables: • Describe the tables and their relationships by creating an Entity Relationship Diagram • Show each table functional dependencies and determinants via a Bubble, Data Model or Functional Dependency Diagram • Identify and eliminate anomalies using normalization (3NF) and create a Data Dictionary Document after Third Normal Form (3NF) conversion

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Action Plan: • Create diagrams and a data dictionary for each table. • Use software that is compatible for all users. • Make sure to keep backups of all work. • You are encouraged to submit ONE draft for your manager's review. In order to receive feedback and incorporate it into your final submission, your draft must be submitted via email at least 24 hours before the due date.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Checklist for Submitting Your Work: • Submit all files: 1 entity relationship diagram, 1 functional dependency diagram and 1 database dictionary for each table. You can combine these into one document for each table if you wish. If you are using diagram software, you may want to copy and paste screen shots into MSWord then save in .rtf format. • Follow all Technical Guidelines listed in the Resource area.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Debrief: • Reflect on what we've learned from this task by discussing the following questions with your colleagues and manager(s): • What elements of other teams’ solutions did you particularly admire? Why? • What worked well within your team re project management and efficiency? What would you have changed? • How did your team divide up responsibilities? • How did your team communicate and share files? • Do you have a better understanding of relationship diagrams? • Do you think documentation is important to the planning process and good database design?

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Deliverables: • Create Tables • Two or more related tables • Populate with data • Design & Create Forms • Two or more individual table forms • One multiple table form with graphic & calculation • Design & Create Reports • Two or more individual reports • One multiple table form with graphic & calculation

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Action Plan: • Make sure to keep backups of all work. • You are encouraged to submit ONE draft for your manager's review. In order to receive feedback and incorporate it into your final submission, your draft must be submitted via email at least 48 hours before the due date. • The final and completed database should be posted at your group’s file exchange area.

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Debrief: • Reflect on what we've learned from this task by discussing the following questions with your colleagues and manager(s): • What elements of other teams’ solutions did you particularly admire? Why? • Why did your team make the choices you did? • How did your team communicate and share files? • What would you have done differently and why or why not?

HOME | OVERVIEW | WELCOME | RESOURCES | TASK 1 | TASK 2 | TASK 3 | TASK 4 | HELP • Action Plan: • Ensure all aspects of the database are working properly • Write the database management user manual • Make sure that you have a back-up of all your work • You are encouraged to submit ONE draft for your manager's review. In order to receive feedback and incorporate it into your final submission, your draft must be submitted via email at least 48 hours before the due date.

Computational Thinking for Information Technology