Please look at the attachment for directions, there are four assignments and no Plagiarism.
Database – Practical Connection
Provide a reflection of at least 750 words (or 2.5 pages double spaced) of how the knowledge, skills, or theories of this course have been applied or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories, and knowledge could be applied to an employment opportunity in your field of study.
Requirements:
• Provide a 750 word (or 2.5 pages double spaced) minimum reflection.• Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited. Must have all required APA components: cover sheet, references as needed, and others.• Share a personal connection that identifies specific knowledge and theories from this course.• Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. • You should not provide an overview of the assignments assigned in the course. The assignment asks that you reflect on how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.
Total: 200 Points Possible
Discussion 250 -300 words
What are thick clients and thick servers, and what are the differences in philosophy of the two approaches? Suggest pros and cons for the thick client and thick server strategies. Provide an example of a thick client and a thick server.
homework
Please read Chapter 11: Group Decision making, collaborative systems and AI Support from the attached book and answer the following questions.
- Explain why it is useful to describe group work in terms of the time/place framework.
- Describe the kinds of support that groupware can pro- vide to decision makers.
- Explain why most groupware is deployed today over the Web.
- Explain in what ways physical meetings can be inefficient. Explain how technology can make meetings more effective.
5. Compare Simon’s four-phase decision-making model to the steps in using GDSS.
Answer these questions in APA 7th edition format and include atleast 4 references, including 2 scholarly references. All answers should be completed in total 4 to 5 pages. STRICTLY NO PLAGIARISM
Itcc 6
Freezing Panes & View Options – Challenge activity
- Follow the instruction given here
- Freeze First Column and use the horizontal scroll bar to look at sales from 2015.
- the first column.
- Select cell G17 and select Split to split the worksheet into multiple panes. Hint: This should split the worksheet between rows 16 and 17 and columns F and G.
- Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F.
- Open a new window for your workbook, and select the 2012-2013 Sales
- Move your windows so they are side by side. Now you’re able to compare data for similar months from several different years.
- Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_FreezingAndView.docx
30
Sorting Data – Challenge activity
- Follow the instruction given here
- Selecct Challenge in the bottom-left of the workbook.
- For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
- Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.
- Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as Sorting.docx
15
Filtering Data – Challenge activity
- Follow the instructions given here
- Select Challenge in the bottom-left of the workbook.
- Apply a filter to show only Electronics and Instruments.
- Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
- Clear the Item Description filter.
- Using a number filter, show loan amounts greater than or equal to $100.
- Filter to show only items that have deadlines in 2016.
- Put your name on the file and screen shot the document showing your name. Paste the screenshot into Word before saving as YourName_Filtering.pdf. (Be sure to save it as a PDF file.)
Computer. science research paper
Write the below topic as a research project paper
Topic -: Emerging Technologies for computer hardware, communication,and sensing
– Abstract
– Introduction (1 page)
– The Problem (1 page )
– Related work (2 pages)
– Your Idea or solution (1 page)
– The Details ( 5 to 8 pages)
– Conclusion and further work (1 page)
A Power point presentation as well
Section 26.3 – CS 112: Programming
Except where otherwise noted, this and all course materials for CS 112 are licensed under Attribution-NonCommercial-ShareAlike CC BY-NC-SA held by the Trustees of the University of Illinois (University of Illinois at Chicago).
Learning objectives:
- Working with strings.
- Slicing strings.
- Basic functions.
- Working with GenBank.
- Understanding connection between DNA, mRNA, and proteins
Sequences in GenBank
On your computer, use a web browser to access GenBank: http://www.ncbi.nlm.nih.gov/genbank. Once there, find a nucleotide sequence for the human coagulation factor IX, sometimes called the “Christmas factor” (F9) gene. In other words, find a DNA sequence for the gene that encodes the coagulation factor IX protein. This is found by using the search area at the top of the GenBank web page. You are looking for a specific “accession”—a sequence submission record—with the accession ID: NG_007994
.
To summarize, we need to find the nucleotide sequence for the human coagulation factor IX, sometimes called the “Christmas factor” (F9) gene. To do this we:
- Use a web browser to access GenBank: http://www.ncbi.nlm.nih.gov/genbank
- Use the search area at the top of the GenBank web page
- Make sure we are searching for a Nucleotide (select Nucleotide using the drop down menu).
- Enter the accession ID:
NG_007994
in the search field - Click search
- Verify the page we go to specifies NCBI Reference Sequence: NG_007994.1 just under the main title.
Structure of Eukaryotic Genes
Eukaryotic genes (like F9) are composed of messenger RNA (mRNA)-coding sequences called exons (expressed portions of DNA sequence) and intervening sequences called introns (the name emphasizes their intervening role). Intron sequences in pre-mRNA are non-coding and are removed before transcription to mRNA. The exons are then joined together (concatenated) and comprise mature mRNA. The process of removing introns and reconnecting exons is called ‘splicing.’ Mature mRNA is comprised of coding sequence (CDS) and untranslated regions (UTR) at 5′ and 3′ ends. Coding sequence is made up of codons—the portion of mRNA that codes for amino acids.
The amino acid coding portions (CDS), along with other gene features, are annotated on the left side of the description in GenBank records. For example, you will see something similar to this in the annotations for the F9 gene:
CDS join(5030..5117,11275..11438)
The actual line on the GenBank page will be much longer (i.e. containing more than just the ranges for two exons) but the first two ranges match exactly what is given above.
The word join
in a GenBank record is analogous to a function in Python. It is an instruction to slice out and join (concatenate) the segments separated by commas within parentheses. The resulting string represents the amino acid coding sequence (CDS). Assuming we have the entire F9 gene sequence stored in a variable F9
, the example above could be written in Python as:
cds = F9[5029:5117] + F9[11274:11438]
Caution: Python indexes start at 0, but GenBank annotations start at 1. Notice how the coordinates differ between the GenBank record example and the Python code above. Failure to adjust indexes correctly is a common situation in computer science and the bugs related to this are known as off-by-one errors. While seemingly trivial, these errors may have serious consequences.
Assignment Description
- Write a function named
extract_f9_cds
which has one parameter is to take the argument of F9, the F9 gene sequence. The goal of this function is to extract the coding regions from the F9 gene sequence (provided in the template), concatenate them, and return the resulting string. Hint: You can confirm your program is functioning correctly by clicking on the CDS annotation in GenBank. This will highlight the relevant parts of the sequence, it should match your output. - Write a function named
get_max_possible_codons
which has one parameterseq
and returns the maximum number of codons this DNA sequence would contain if it was wholly composed of coding regions. Remember that each codon is made up of 3 nucleotide bases. - Write a function named
get_gc_percent
which has one parameterseq
. The goal of this function is to compute the proportion ofG
andC
bases (characters) inseq
to the total number of bases (characters) inseq
. The returned value should be of typefloat
in the range between 0.0 and 100.0 (as a percentage, not a fraction). To do this, use the string method count( ) to determine the number of ‘G’ bases and the number of ‘C’ bases. - Write a function named
get_coding_ratio
which has two parametersseq
andcds
. The goal of this function is to calculate the proportion of coding nucleotides to total nucleotides in the entire sequence. In other words: of the total number of nucleotides in the gene (seq
), what is the proportion that codes for amino acids (cds
)? Remember that a ratio will a value of type ‘float’ in the range between 0.0 and 1.0. - Write a function named
print_seq_info
which has two parametersseq
andcds
. This function should use the functions you wrote for problems 1 through 4 and print a correctly formatted summary:
Sequence length: ... Coding sequence length: ... Number of possible codons: ... Number of actual codons: ... First 4 codons of the coding sequence: ... Ratio of Coding NT to Total NT: ... GC percent of the entire sequence: ... GC percent of the coding sequence: ...
- The Sequence length: output should use the built-in len( ) function with the ‘seq’ parameter.
- The Coding sequence length: output should use the built-in len( ) function with the ‘cds’ parameter.
- The Number of possible codons: output should use your
get_max_possible_codons
( ) function with the ‘seq’ parameter. - The Number of actual codons: output should use your
get_max_possible_codons
( ) function with the ‘cds’ parameter. - The First 4 codons of the coding sequence: output should use slicing with the ‘cds’ parameter.
- The Ration of Coding NT to Total NT: output should use the
get_coding_ratio
( ) function with both the ‘seq’ and ‘cds’ parameters. - The GC percent of the entire sequence: output should use the
get_gc_percent
( ) function with the ‘seq’ parameter. - The GC percent of the coding sequence: output should use the
get_gc_percent
( ) function with the ‘cds’ parameter.
- Write a few sentences explaining what this gene is and what its protein does, state the name of a disease caused by a variant (mutation) at the F9 gene, and describe one such disease-causing variant. Hint: look in the right panel on GenBank, or use the web. (You can write your answer in the same file as your Python code by commenting out the text. The starter code for Lab 3 already has a place for this near the top of the file.)
- Make sure you are writing your code using Good Programming Style. Aspects of Good Program Style include (but are not limited to):
- File Header Comment/docstring at the beginning of the file to describe the purpose of the program
- File Header Comment/docstring at the beginning of the file to give information about the programmer/author of the program
- Function Comments/docstrings to describe the purpose of EACH function
- Using meaning variable names
- In-line comments/docstrings where needed
- Blank lines to separate sections of your code
- Proper use of indentation and consistent depth of indentation
Unit 2 DB: Responsive Website vs Native/Hybrid Mobile Applications
Once you are comfortable with the concepts of responsive design, share a link to a website that you believe has utilized responsive design, and explain how you confirmed the responsive design of this website.
- Did you confirm it by looking at the source code?
- Did you confirm it by testing the website on various devices and in various browsers?
- How does this responsive website compare to native mobile applications or hybrid applications?
- What features were lacking from the responsive website that could be implemented in a native or hybrid mobile application?
Easy Own words
This week we start looking at project Scope Management, and project Schedule Management. For some of this week’s tasks, you will need to use Microsoft Project.
If you have not started familiarizing yourself with MS Project, here is a very short, simple tutorial that you can start with. There are MANY others out there on the Internet, but this one isn’t as complex as a lot of them. You can view it here:
https://www.youtube.com/watch?v=pU4UzCfUDX4
If you do not have a copy of MS Project on your computer, you can run it from our Remote Server, by following the instructions in this .pdf document: VMWare Student Application Server Access Instructions Download VMWare Student Application Server Access Instructions
Your Assignment for This Week
Chapter 5 – Read the Running Case at the end of the chapter. Do tasks 1 through 4. Do NOT do task 5. On Task 1, ONLY do the requirements traceability matrix. You do NOT need to develop a list of questions for the project sponsor. .
Chapter 6 – Read the Running Case at the end of the chapter. Complete tasks 1 through 3.
Running Case Chapte-5:
You have been selected as the project manager for the Global Treps project. You helped to run
a local shark tank like event at your college last year as part of a class project, so you have a
general idea of what is involved. The schedule goal is six months, and the budget is $120,000.
Your favorite professor, Dr. K., and a few of her associates have agreed to fund the project. Your
strengths are your organizational and leadership skills.
You are a senior, live on-campus, and get free room and board by being a resident assistant
in your dorm. Bobby, a computer whiz who funded a lot of his college expenses by building
websites, will be your main technical guy on the project. He goes to your college and lives
off-campus. Three other people will form your core project team: Kim, a new college grad now
working for a non profit group in Vietnam; Ashok, a business student in India; and Alfreda, a
student in the United States planning to visit her home town in Ethiopia for two months in a few
months. You will hold most meetings virtually, but you can meet face-to-face with Bobby and
Dr. K. as needed. You have all known each other for at least a year and are excited to make this
project a success.
You and your team members will do the work part-time while you finish school or work at
other jobs, but you can use up to $50,000 total to pay yourselves. You estimate that you will need
another $30,000 for travel expenses, $20,000 for hardware and software, and the other $20,000
will go toward organizing events, consultants, legal/business fees, etc.
Your goal is to develop a fully functioning website and test it by holding four events in four
different countries. You’ll make improvements to the site after those events, develop plans to
scale it up, and recommend how to transition the project results into a successful business.
Recall from Chapter 4 that this system would include the following capabilities:
• Provide guidelines and templates for running a shark tank type event
• Accept donations from potential investors targeted toward specific schools or
organizations wishing to host an event (similar to the popular DonorsChoose.org site,
where people can fund teachers’ requests)
• Accept ideas for needed new products or services
• Provide the ability for organizations to create their own custom site to solicit local
participants and sharks, accept applications, and promote the winners as well as
losers.
Note that you decided not to include the idea of providing an online version of the event
as part of the initial project as your sponsor and team decided that physical events would be
most effective. You have also decided to limit the scope of this first project to provide the ability
for 20 organizations to create their own custom websites. Your team members will screen the
organizations and assist people in using the site to plan their events.
You plan to hold four shark tank like events within four months, using your team members
abroad to help organize and run those events, plus one at your college. Your semester has just
started, so you plan to hold your event at the end of the term. The project will fund refreshments
for the events and prizes for the winners, with a budget of $1,000 for each event. You don’t think
you’ll get any donations via the new website before these events, but you’ll try to have it set up to
accept donations by the last month.
You will create some short videos to show people how to use the site and provide
suggestions for holding the events.
After testing the site and getting customer feedback, you will make some changes and
document recommendations for a follow-on project. You will also create a business plan
recommending how to transition this project into a real business that can make a profit after two
years.
Assume that you would pay for a new website and account through an online provider.
Bobby would do most of the customization/programming for the site, but you would consider
outsourcing or purchasing services to provide some of the capabilities like accepting donations
and developing the short videos on the site. You would also buy a new laptop and Internet
access for your three team members abroad so that they could share information with their
contacts in those countries.
You and Dr. K. want to attend all of the events as part of the project, and you might include a
full face-to-face meeting with the whole team if possible.
Tasks
1. Document your approach for collecting requirements for the project. Include at least five
technical requirements and five non technical requirements in a requirements traceability
matrix. Also develop a list of at least five questions you would like to ask the project sponsor.
Let your instructor answer them for you, if applicable.
2. Develop a first version of a project scope statement for the project. Use the template
provided on the Companion website for this text and the example in Chapter 3 as guides.
Be as specific as possible in describing product characteristics and requirements, as well as
all of the project’s deliverables. Be sure to include the Global Treps website, four shark tank
like events, a business plan, and outsourced items (laptops, donation acceptance, video
creation, etc.) as part of the project scope.
3. Develop a work breakdown structure for the project. Break down the work to Level 3 or Level 4,
as appropriate. Use the template on the Companion website and samples in this text as
guides. Print the WBS in list form. Be sure the WBS is based on the project charter (created
for the Chapter 4 Running Case), the project scope statement created in Task 2 above, and
other relevant information.
4. Use the WBS you developed in Task 3 to begin creating a Gantt chart using your choice of
software. Do not enter any durations or dependencies. Print the resulting Gantt chart on one
page, and be sure to display the entire Task Name column.
5. **I removed no need to do**
Chapter 6 – Read the Running Case at the end of the chapter. Complete tasks 1 through 3.
Running Case Chapter-6:
You are the project manager for the Global Treps Project, sponsored by Dr. K. Team members
include Bobby, your IT guy; Kim, a new college grad now working for a non profit group in
Vietnam; Ashok, a business student in India; and Alfreda, a student in the United States originally
from Ethiopia. You plan to outsource some of the work (e.g., purchasing laptops, developing a
website feature for accepting donations, and creating videos for the website). Recall that your
schedule and cost goals are to complete the project in six months for under $120,000.
Tasks
1. Review the WBS and Gantt chart you created for Tasks 3 and 4 in Chapter 5. Propose three
to five additional activities that would help you estimate resources and durations. Write a
one-page paper describing these new activities.
2. Identify at least five milestones for the Global Treps Project. Write a short paper describing
each milestone using the SMART criteria. Discuss how determining the details of these
milestones might add activities or tasks to the Gantt chart. Remember that milestones
normally have no duration, so you must have tasks that will lead to completing them.
3. Using the Gantt chart you created for Task 4 in Chapter 5 and the new activities and
milestones you proposed in Tasks 1 and 2 above, create a new Gantt chart using Project
2016 or another tool. Estimate the task durations and enter dependencies as appropriate.
Remember that your schedule goal for the project is six months. Print the Gantt chart and
network diagram, each on one page.
***I attached text book for reference. Question is from Chapter-5 & Chapter-6*****
Need to complete given Tasks in both cases. Please take care of Plagiarism.
Database – Discussions
Create a discussion thread (with your name) and answer the following question(s):
Discussion 1 (Chapter 13): What are the differences between structured, semistructured, and unstructured data?
Instructions: Your response to the initial question should be 250-300 words. Next respond to two postings provided by your classmates. The first post should be made by Wednesday 11:59 p.m., EST. I am looking for active engagement in the discussion. Please engage early and often. You are require to create your initial thread in order to view and respond to the threads posted by other students. There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed. Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.