Assignment Directions In this assignment, you will use several functions in Exce

Assignment Directions
In this assignment, you will use several functions in Excel to handle text processing problems from basic ones to more complicated tasks. You will need to perform tasks such as text cleaning, text extraction, and solving real world questions by flexibly applying formulas introduced in this week as well as a few functions learned from previous weeks. By completing the processing work, you will present your results and customize the visualization in Excel.
Please follow the instructions provided
Purpose
Text analysis has become increasingly popular among researchers. Various visualizations are frequently seen in our daily life, e.g., word cloud. Contrary to conventional wisdoms, Excel can handle quite a few different text handling tasks and provide a spreadsheet environment for non-coding users with a familiar workplace to hand text data.
Requirements:
For the assignment, students are required to:
Complete a number of data tasks in the attached document.
Transcribe your answer (or the image of your chart) to the Answer tab.

I NEED TO TALK WITH THE EXPERT, i want to implement a settings page for a social

I NEED TO TALK WITH THE EXPERT, i want to implement a settings page for a social media website project im doing
Comments from Customer
i want to create a settings page for a social media website
if you see the file i sent, you will realise it’s a social media website, i’m trying to implement the settings function with a seetings.html, that’s what i need your help in, implementing the seetings function of the website
The user on the website should be able to change their password , update their details be it email, name
I used loaded a pic for f how it should look
Also I would need like a page explaining how you implemented the function

This is a Digital Marketing Project. In it we have to create a website for any r

This is a Digital Marketing Project. In it we have to create a website for any random business using Dreamweaver. The site should have basics like attractive landing page with functional buttons and related images and info. To create a website using dreamweaver according to the framework. I need a website built for a college project. I have attached screenshots of the framework in the instructions docx. The phase 2 rubric also has the requirements. I have also attached another past project for reference. Connect with me for any queries. If you can create a website based on the topic in the blueprint screenshots in instructions word doc that would be great. I would need files of the website, as well as a blueprint ppt. I have also attached a zip file named something sweet website. That is past students project to be taken as an example.

A6c. Course Information Approaching Competence Approaching Competence: The mobil

A6c. Course Information
Approaching Competence
Approaching Competence: The mobile application only allows the user to enter, or edit, or delete parts of each course’s information.
EVALUATOR COMMENTS: ATTEMPT 2
The functionality to update and delete existing course notes was not evident. The course notes do not appear to save. Tested using Pixel series emulators / APIs 29, 30
A6f. Alerts for Courses
Approaching Competence
Approaching Competence: The mobile application allows the user to set alerts for either the start or the end date of each course, or the alerts do not trigger when the application is not running.
EVALUATOR COMMENTS: ATTEMPT 2
The ability to set alerts for courses was not observed. Tested using Pixel series emulators / APIs 29, 30
A7a. Assessments for each Course
Approaching Competence
Approaching Competence: The mobile application allows the user to add performance and objective assessments for each course, but cannot include the title of the assessment and the end date for each assessment.
EVALUATOR COMMENTS: ATTEMPT 2
An indicator that identifies a field as ‘assessment type’ was not evident.
A7c. Alerts for Goal Dates
Approaching Competence
Approaching Competence: The mobile application allows the user to set alerts for either the start or the end dates for each assessment.
EVALUATOR COMMENTS: ATTEMPT 2
The ability to set alerts for assessments was not observed. Tested using Pixel series emulators / APIs 29, 30
C. Student Scheduler and Progress Tracking Application
Approaching Competence
Approaching Competence: The mobile application includes a scheduler but does not include the 11 given implementation requirements.
C1. Interface Requirements
Approaching Competence
Approaching Competence: The mobile application includes up to 4 of the given interface requirements.

This assignment assesses the following module learning outcomes:  Demonstrate k

This assignment assesses the following module learning outcomes:
 Demonstrate knowledge of the object oriented (OO) paradigm by producing software
solutions to simple problems.
 Design a simple OO system using UML class diagram (without using a formal tool)
 Implement and test a simple OO software system using a suitable Integrated
Development Environment (VS code)
 Comprehend and explain object oriented programming concepts
 Code re-use, apply good practice in code design/testing
requires you to review the ideas of superclass and
subclass relationship and provide opportunities to examine your level of knowledge in basic
hierarchical class design and object-oriented programming using Python.

Create: Query 1: Contact ID (All contacts), Type of contact, Last Name, First Na

Create:
Query 1: Contact ID (All contacts), Type of contact, Last Name, First Name, Company Name, (Query Name – ContList)
Query 2: Contact ID (All contacts), Type of Contact, Last Name, First Name, Type of Phone, Phone # (Query Name – ContPhone)
Query 3: Contact ID (Business contacts), Business or Service Provider Organization Name, Business or Service Provider type, Business Contact Person, Phone # (Query Name – BsnsContacts)
Query 4: Contact ID (Individuals only), Last Name, First Name, City of Residency, State of Residency, Type of Phone, Phone Number, Email Address (Query Name – IndivContacts)
Query 5: Contract ID (All Contacts), Last Name or Business Name, Phone Number, Email Address
You will be using each of these queries to create a report with all data elements included in the Query. Add a title to each Report, using an expansion of the Query name. So the title for Report 1 would be an expansion of ContList, or Contact List Report. Insert page numbers in the footer of each page of each report.
Report 1. Construct one report from the entire database. Save this report as “2016Business”
Report 2: Construct a report using Query 1 save this as Report “ContList”
Report 3: Construct a report using Query 2 save this as Report “ContPhone”
Report 4: Construct a report using Query 3 save this as Report “BsnsConacts”
Report 5: Construct a report using Query 4 save this as Report “IndivContacts”
Report 6: Construct a report using Query 5 save this as Report “ContactEmail”

Assignment 7 Working with Forms Outcomes addressed in this activity: Unit Outcom

Assignment 7
Working with Forms
Outcomes addressed in this activity:
Unit Outcomes:
Discuss HTML form elements for Web pages.
Create HTML form for the website.
Course Outcome:
IT117-4: Develop HTML forms with form field validation.
Purpose
For this assignment, you will demonstrate effective use of forms on Web pages. You will create a contactus.html webpage that includes an HTML5 contact form. You will then format the Web form using CSS.
Assignment Instructions
Part 1 – Create a Contact Us Page and Web Form
Open template.html in Notepad to edit. Save file as contactus.html.
Place your restaurant name and the text “Contact Us” in the title tag.
Add a level 1 (h1) heading inside the header of the page. Text should be appropriate for a contact page.
Example: Contact Joe’s Grill
Between and tags, code an HTML form with the following elements:
Text field for user’s first name.
Text field for user’s last name.
Text field for user’s email address.
Text field for user’s phone number.
A textarea for user comments.
Submit button.
The form tag must include the following attributes:
The action attribute with empty quotes: action=“ ”
The method attribute with the post value: method=“post”
The autocomplete attribute with the on value: autocomplete=“on”
The textarea should include the following attributes:
The name attribute
The rows attribute
The cols attribute
The form should have autocomplete turned on.
The email address field should have autocomplete turned off.
Each input field must have a name using the name attribute.
Each input field must have an appropriate label.
Add a level 2 (h2) heading above the form telling the user the purpose of the form. For example: Tell Us What You Think
Save the contactus.html page.
Part 2 – Format the Web Form Using CSS
Add an internal CSS stylesheet to the head of the contactus.html document.
Use around your style rules.
Add at least two style rules to format the form. Choose at least two from the following:
Background color of form.
Background color of input tags.
Border color of input tags.
Font type for text in form.
Font color for text in form.
Style rules must include all required symbols:
{ and }
Colon : and semi-colon ;
Required quotes as applicable.
Style rules must use hex color codes, no color names.
Save contactus.html and close.
Upload contactus.html to the server.
Directions for Submitting Your Assignment
Post the valid working URL to contactus.html page to the Dropbox.
Written work should be free of spelling, grammar, and APA errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion.
Review the rubric before beginning this activity.

Assignment – Format a Web page using CSS Outcomes addressed in this activity: Un

Assignment – Format a Web page using CSS
Outcomes addressed in this activity:
Unit Outcomes:
Create a table for data using HTML.
Apply advanced CSS to Web pages.
Course Outcome:
IT117-3: Integrate CSS with HTML to create a visually appealing website.
Purpose
This week you will continue to work with CSS by adding additional style rules to your external stylesheet, styles.css. You will also develop your Menu page. You will add a table to your page as well as the Menu page content. You will write a class and an ID in your CSS that will be used to format your Menu page table. Demonstrating your ability to develop these more advanced HTML and CSS elements will add depth and interest to your Web pages and give you the opportunity to showcase some of your creativity.
Assignment Instructions
Complete the Menu page for your restaurant website and customize CSS formatting for History and Menu pages.
Open menu.html in Notepad to edit it.
Type the name of the restaurant as well as the word “Menu” inside the title tag.
Add a level 1 (h1) heading to the page that is appropriate for the page.
Add a table to the Menu page.
Code your table between and tags.
Table must be at least three (3) columns and three (3) rows.
Table must include at least one merged cell using either colspan or rowspan attributes and must use the tag pair at least once.
Add content to the table cells. Table must include at least two (2) menu items with descriptions.
Throughout the rest of the page, you may add appropriate subheadings (h2, h3, etc.), a second table, paragraph text, and/or list code as needed to complete the remaining page content. Content should be appropriate for the Menu page and must include at least 50 words.
Format menu page using CSS. Open styles.css to edit in Notepad. Apply the following style rules to styles.css to format the page columns:
Set a width for the table using a percent value
Add a background color to the table
Write an ID to apply to the table tag.
Your ID can format any element of the table, such as font-family or alignment.
Name your ID something logical according to the function. (Remember an ID can only be used once on a page.)
Write a class to change one element within the table.
Name your class something logical according to the function, (i.e., .rowcolor or.boldtext).
Your class can change the background color of a cell or row, change the text color for one table cell or row, align the content of one table cell or row, or emphasize the text in one table cell or row by applying bold or italics.
The class can be called in one or more tag, tag, or tags. For example:
or
Keep in mind the tag pair automatically displays text centered and bold.
Save.
Apply two (2) additional changes to CSS.
Using your knowledge of CSS, make two (2) changes to your CSS stylesheet code.
At least one change must be made to the navigation formatting.
The second change can be to the navigation or another element.
Save and close styles.css.
Upload the menu.html and updated styles.css pages to the Web server.
Directions for Submitting Your Assignment
Post the URL to the menu.html page to the Dropbox.
Written work should be free of spelling, grammar, and APA errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion.
Review the grading rubric before beginning this Activity.
I will tip also if you can help me fix me index.html file I must’ve coded it wrong