Important Notice: Read all the requirements below. This is the second part of the project, building off Project #1. Each part of the project will be equally weighted. NOTE: Make sure to zip all your files (i.e. 3 HTML files, 1 CSS file, all image files) in a folder. Do not submit individual files to D2L or else it will mess up the formatting. ● Link to instructions on how to zip and unzip your files: Mac vs. Windows MAKE SURE YOU READ ALL OF THE INSTRUCTIONS CAREFULLY BEFORE STARTING, ESPECIALLY THE NOTES AT THE END OF THE PROJECT. Overview For Project Part #2, you will be creating one new HTML page. All of the Javascript will go on the new HTML page. This HTML page will link to the other two pages from part #1 through the “navigation bar” in the 2 nd row of the table. You must use an IDE for this assignment. You may use Sublime Text, the IDE you should have downloaded from the lecture. Alternatively, if you have another preferred IDE, you may use that. You are not allowed to use any code generators for this part of the project. You must hand-type all of the HTML and CSS. Do not use tags beyond what is in your HTML, CSS, and JavaScript handouts (though you are allowed to use CSS properties/values not in the notes). Other tags and attributes are off-limits. DO NOT use the style attribute with any tag. Also, you may see examples online of people embedding their CSS in their HTML files with the use of a tag. Do not do this. All your CSS needs to be in its own file. You are only allowed to use tools and techniques I have shown you in the handouts or during class lectures. Use of any feature not covered in handouts or lectures will result in a zero for that portion of the project. For example, I did not show you how to change text color with JavaScript, but I did show you how to do it with HTML and CSS. Goal Reference image attached below. Please note that your page might look slightly different based on your chosen country and their corresponding temperatures. For a good chunk of your assignment, you will need to use Javascript to display the correct items on your webpage. If you use HTML, you will not receive credit. Please read the directions carefully to figure out which sections allow HTML and which require you to use Javascript. Culture Page: TIP: Save your file and check your web page periodically to ensure your changes are being correctly reflected. ——————————————————————————————————————— ● You will be adding on to the first part of the project. You will be creating a page with the subject of “The historic culture of the country”. ● When adding your own information, the subject material should be clean. ● No additional downloads for this project. You will create everything from scratch. Culture Page 1. Save the file as TheCulture.html in the text editor. 2. The table structure of the page will be identical to the first two pages you created including the link to the CSS file. The easiest thing to do would be to copy and paste one of those pages into TheCulture.html and change the third row’s contents. ● Change the tab title in the <head> tags to say Culture. ● Change the text in the first row to the name of the country followed by a hyphen and then the word Culture. So, in my example, it would be Peru – Culture. ● In Row #2, make the word Home link back to the home page. ● In Row #2, make the word Cities link to the Cities page. ● In Row #2 cell #3, put the word Culture in the cell, but don’t make it a hyperlink. ● Keep the 4 th row of the table the same. 3. Go back to your homepage and your cities pages and add a hyperlink to this new page in the third cell of the 2 nd row. The text should say Culture and it should link to the TheCulture.html page. 4. For the body of your page in row #3, I want you to replace all the text (and any pictures) with a total of 200 words of text about the historic culture of the country you have chosen. ● For example: My country of Peru’s culture originates with the Incas. I might talk about the way they lived, the food they ate, and the traditions they had that have carried over to modern-day Peru. 5. Ensure that you are using at least one <p> tag in the Row #3 text to ensure that your CSS is working on this page too. 6. After the 200 words, but still in row #3, I want you to add one simple horizontal rule tag. Javascript Tasks Note: The following tasks should be completed using JavaScript instead of HTML. 1. Do some research and look up the average Fahrenheit temperature for your country in your birth month and also the average Fahrenheit temperature for your country 3 months after your birth month. ● For example, I was born in July and the average temperature in Peru in July is 66 degrees Fahrenheit the average temperature 3 months later in October is 68. ● Utilizing the keyword var, create 3 variables in your javascript file with the following names: current_temperature, future_temperature, and temperature_difference. ● Now assign the numeric value to the first two variables. In my case, I would assign the number 66 to current_temperature and the number 68 to future_temperature. 2. In a separate programming statement, subtract the current_temperature from the future_temperature and save the results in temperature_difference. ● In my case, the value in temperature_difference would be 2 (because of the math: 68-66). 3. After the <HR> tag from step 6 in the Culture Page section, put the following text with a document.write programming statement: The average temperature for countryname in birthmonth is current_temperature degrees. ● Replace the word countryname with the country you are using, replace the birthmonth with the month you were born, and then concatenate the value stored in the current_temperature variable (you do not need to italicize or bold this text). ● For example, I would have used the text: The average temperature for Peru in July is 66 degrees. 4. Using a separate document.write statement, add a line break after step 3’s text. 5. Create a while loop that: ● Will print the following: oo- to the screen every time through the loop (if you are wondering that is two lowercase letter “oh’s” with a hyphen after them). Otherwise known as the letter that follows the letter “n” in the alphabet. ● Add this after step 4’s line break. ● The loop will repeat based on the absolute value of the number stored in temperature_difference. ○In my case, the absolute value of 2 is 2. As a result of the math, my loop would repeat 2 times and print oo-oo- ○ You may find the abs method described here useful: https://www.w3schools.com/jsref/jsref_obj_math.asp ● Note: If there is no temperature difference between your 3 months, then your code will skip over your loop, and that is okay. It is not okay to not have the loop there though aka you must have a working while loop. 6. Using a separate document.write statement, add a line break after step 5’s oo- text. If Statements Note: The following tasks should be completed using JavaScript instead of HTML. 1. Utilizing the data you collected and stored in your variables create a single if statement that will do the following: ● If the temperature_difference value is less than zero, use a document.write statement to print the following text in a blue italicized font color: The weather is getting colder. ● Else if the temperature_difference is equal to 0 or 1 (you must use a logical and or logical or), use a document.write statement to print the text in a green italicized font color: The weather is pretty much staying the same. ● Else if the temperature_difference is greater than 1 but less than or equal to 4 (you must use a logical and or logical or), use a document.write statement to print the following text in a red italicized font color: The weather is heating up a little bit. ● Otherwise, print the following text in a purple italicized font color: The weather is getting really hot. ● Note: Make sure you are getting the correct results. Test your code for all four scenarios to make sure every branch of the if is working correctly. ● Common mistakes: ○Make sure all numeric values are saved and compared as numbers and not Strings. For example, assigning a numeric value to a variable called my_answer would be something like 20 not “20”. Also, when comparing values, you would check if(my_answer>15) not if(my_answer>”15”) as the latter would be comparing a numeric value against a String value. ○When utilizing AND or OR operators, make sure each condition is complete. For example, if(my_answer==24 || 36) would be incorrect, but if(my_answer==24 || my_answer==36) is correct. ○Make sure when using the <font> tag inside the document.write statement, you use a corresponding </font> tag for each color change. 2. Using a separate document.write statement, add a line break after step 1’s text. 3. Inside the <head></head> tags, create a section of <script> tags, and inside those script tags, add a single javascript function: ● Name the function determineMonth that takes a single parameter. ● Name the parameter in the function header theMonth. This parameter will hold a numeric value representing the month of the year passed to it. ● In the body of the function, use a single if statement with many else if statements to determine which of 13 possible values to return. ● The function will return a single String value representing a month spelled out. For example, if the function is passed the number 4, the function will return the String “April”. If on the other hand, the function is passed the number 12, it will return the String “December”. ● If the function is passed a value outside of a 1-12, it will return the String “Undetermined”. ● Note: The function does not print anything. It simply returns a String value. 4. Back in the main body of your page, after step 2, print the following: I prefer the weather during birthmonth over the temperatures of 3monthslater. ● Replace the text birthmonth with the value returned from the function determineMonth when you pass it the numeric month that you were born. So in my case, I would utilize the value passed back from the following function call since I was born in July: determineMonth(7). ● Replace the text 3monthslater with the value returned from the function determineMonth when you pass it the numeric month that occurs 3 months after you were born. Note: Be careful here. The maximum month is December. If you were born in October, 3 months later would be January. So in my case, I would utilize the value passed back from the following function call: determineMonth(10). ● Note: Be careful as your function should react to any numeric value passed to it. ○ Have you tested it with values below 1 and above 12? Is it properly returning the value “undetermined”? ○Is it returning the correct value for the number passed into it? For example: if you pass the function a value of 3, does it return the word “March”? Does it work for the other 11 months? ● Did you spell all the months correctly? You will lose points for spelling errors. Watch out for… ● Your final submission should include all picture files, 3 HTML files, and 1 CSS file. I know the picture files and CSS haven’t changed since Project #1, but I want all the project files in the submission. ● Have you added space around where your variables are concatenated with other text? For example, I prefer the weather duringAprilover the…. (this text should include a space on both sides of “April”). ● Did you update the Project #1 HTML files to link to the new HTML page created in Project #2? ● Little mistakes in JavaScript will cause the whole JavaScript section to fail. This can cause the part or all of the page to load blank. Watch out for little mistakes like missing brackets, quotation marks, or plus signs. ● Comment out sections to track down a bug. ● Make sure you have completely read all the instructions. The details matter and can be the difference between an A and a C. ● I do not go back to regrade Project #1, but you should try to fix any mistakes that may affect Part #2. ● Note: It is better to turn in an incomplete project than not to turn one in at all. ● Note: It is better to turn in a project that loads correctly with broken code commented out than to leave the errors running in your program. ● The file you are submitting to D2L should have an extension of .zip, not .html When you finish, you should submit a zipped folder with the 3 HTML files, the 1 CSS file, and all the pictures as a zip file (supplemental instructions on creating zip files are provided at the very beginning of the assignment). Failure to submit the correct zipped format will result in a 0, so email me if you are confused or do not know how.
CSCI 1250 – Excel Assignment #2
Important Notice: Read all the requirements below.
The first 8 calculations from columns H to O only require 8 initial calculations that you will need to copy down to the other cells in the column. If done correctly, you shouldn’t need to modify any of the calculations once copied. Know when and where to use absolute cell references. Absolute Cell References will not be as common as the first assignment but you will need to use them in a handful of functions.
Note: Anyone caught copying or cheating from anyone or any website/app such as Discord or ChatGPT, will have paperwork filed for academic dishonesty with the university. I do NOT recommend going online to search for solutions. You will usually find the wrong way to solve the problem.
● This assignment must be completed and returned to me via D2L
● You must use MS-Excel to complete all 12 steps of the assignment.
● Use only functions unless instructed to use a formula. There is only 1 place in the assignment that it is specified that it is okay to use a formula.
● Do not use literal numbers or literal character strings in calculations unless instructed.
● Always complete the calculations inside a single cell unless otherwise instructed. Also leave cells where they are unless otherwise instructed. For instance, do not copy/move values from one sheet to another.
———————————————————————————————————————
● Download the file SalesIncentives.xlsx from D2L. Make sure when you submit your file later that you submit the modified file and not a copy of the unmodified file you downloaded.
Setup
1. On row 44, add your name and choose 1 of the 4 territories for yourself (Central, Eastern, Southern, or Western).
2. For the 2023 Sales cell in your row, type in the number 100 _ _ _ where the last three digits are the last three digits of your 900 student number at school.
● For example, if my 900 number was 900180994, then I would enter 100994 into cell C44.
3. In Cells D44 through G44, enter the numbers 13,001 13,001 13,001 12,345.
Goals
1. For column H, compute the Total 2024 Actual amount by adding the 4 quarters of 2023 together for each employee. Use a function for your calculation. If your Excel worksheet displays a tiny green wedge in the upper left corner-it is a warning that does not apply here if you are doing the calculation correctly. You can ignore the warning.
2. Now calculate the column 2024 Goal by taking the value in the 2023 Sales column and multiplying it by the Goal % Increase. You can find the Goal Percent Increase on the Values worksheet. Do not move or copy the Goal Percent Increase value.
3. In the range C49:E49, compute the total number of employees that have met the requirement labels in cell C48:E48 based on their Total 2024 Actual earnings. Use the Countif function to do this.
● Because of the nature of this function, you are allowed to use literal text criteria for the 2nd parameter. For example, “>50” would find things that exceeded 50.
4. Calculate the % Goal Met column by taking the Total 2024 Actual and dividing it by the 2024 Goal. Use a formula to do this as the quotient function will not work properly in this scenario.
Bonuses
1. In column K, use a function to rank which employees had a higher % Goal Met. You may find the use of the Insert Function button, next to the Formula Bar, useful here.
● If created correctly, the first employee is ranked to have the 18th ranking and the second employee has the 7th ranking.
● If you have more than one employee with the same rank, you may need to use an absolute value somewhere. Also, if you aren’t getting the rank 18 and 7 for the first two employees, it may mean you made a mistake in a previous calculation.
2. In column L, use a function to determine if an employee is ranked in the top ten. If an employee ranks in the top ten, then put the text “Top 10” in column L next to their rank value. If the employee is not in the top ten, put a blank space in this column next to their rank.
● Hint: If it says “False”, you will want to replace that with a blank string of text. You may use the literal number 10 in this calculation.
3. In column M, determine how much bonus a particular sales associate should be getting. This is based on their performance. Using their rank value, determine their bonus using the percentages on the Values worksheet along with the Total 2024 Actual value.
● If someone has a rank in the top ten, then you would multiply their value from column H with the value in B5 of the Values worksheet.
● If they were ranked between 11 and 22, you would multiply their value from column H with the value in B6 of the Values page.
● If they were ranked above 22, then they would just receive the flat rate value stored in B7 of the Values page.
● You may use literal number values in this calculation to determine which bonus category someone falls into.
● Remember that you are not allowed to use a formula for multiplication here. ● If you get stuck on this calculation move on and come back to it.
String Manipulation
1. In column N, with one calculation, use the Search and Left functions together to extract the last name from each of the employee names from column B and display them in column N. Do not use the Find function.
● Be aware that the first word in column B is the last name and that a comma is what separates the last name from the first name.
● Search for the comma not a blank as some of the employees have two word last names.
● Be aware that there are many different length last names. ● Extra Credit: You may keep the comma in the result, but you are also allowed to
use a subtraction of one in the calculation to eliminate the comma. Use a function if you do this. Do not use a formula.
2. In column O, use the following functions: Lower, Replace and Find to take the Territory from column A and replace the word “Territory” with the word “USA” and then output the final result all in lowercase letters.
● For example, cell O8 would contain the words western usa as a result. ● You may use both the literal words “Territory” and “USA” and also the literal
number 9 in your functions. ● I know there are alternate ways to solve this with other functions, but I want you
to only use the Replace and Find functions.
When submitting your file, make sure you submit the updated version of the file.
,
__MACOSX/._Project #1
Project #1/Cities.html
| |
||
| Home | Cities | Culture |
|
Buenos Aires, which is the vibrant capital of Argentina, is known for its rich cultural scene, tango music, and diverse neighborhoods. The city boasts iconic landmarks like the historic Plaza de Mayo, and the colorful La Boca district. With a population of over three million people, it is a bustling metropolis that blends European influences with Latin American spirit. Argentina's second-largest city, Córdoba, is renowned for its colonial architecture, and university with it being one of the oldest in the Americas. Surrounded by picturesque mountains, it offers a youthful atmosphere with a vibrant arts scene and numerous cultural festivals, and makes it a captivating destination in its own right. |
||
| Copyright 2024 – Alexa Freeman Productions |
__MACOSX/Project #1/._Cities.html
Project #1/Page 2 Reference Image.png
__MACOSX/Project #1/._Page 2 Reference Image.png
Project #1/JavaScriptFile.js
Project #1/Page 1 Reference Image.png
__MACOSX/Project #1/._Page 1 Reference Image.png
Project #1/.DS_Store
__MACOSX/Project #1/._.DS_Store
Project #1/city2.jpg
__MACOSX/Project #1/._city2.jpg
Project #1/city3.jpg
__MACOSX/Project #1/._city3.jpg
Project #1/city1.png
__MACOSX/Project #1/._city1.png
Project #1/Argentina.html
| |
||
| Home | Cities | Culture |
Description of ArgentinaArgentina is located in the southern part of South America. It is the eighth largest country in the world, and second largest in South America after Brazil. The country stretches from the northern subtropics to the southernmost tip of South America. It encompasses a diverse range of landscapes which is divided into four regions, including the Andes mountains, Pampas grasslands, and the Patagonian desert. The Andes mountains create a 3,195 mile border with Chile. The county is also known for its rich cultural heritage. Argentina is famous for things such as tango music and dance, as well as its culinary delights, particularly beef and wine. The capital city of Argentina is Buenos Aires, it is a vibrant metropolis that reflects the country’s European influences and Latin American roots. HistoryArgentina is also known for its history. The country is shaped by indigenous cultures, European colonization, and subsequent independence. The land was originally inhabited by indigenous peoples such as the Mapuche and Guarani. The Spanish explorers arrived in Argentina in the early 16th century, and the city of Buenos Aires was founded in 1536. The area became part of the Spanish Empire, but after a series of several revolts, Argentina eventually declared its independence on May 25, 1810. The 19th century for the country was marked by civil wars and conflicts between federalists and unitarians and in the late 19th and early 20th centuries Argentina experienced significant immigration, which contributed to the country's cultural diversity. WeatherArgentina's climate varies widely due to its vast size and diverse geography. The northern regions have a subtropical climate with hot summers and mild winters. While the central Pampas region experiences temperate weather. The southern part of Argentina, including Patagonia, is characterized by cold temperatures and strong winds, particularly in winter months. The Andes mountains region creates microclimates, influencing weather patterns in the west. The country experiences distinct seasons: spring which is September to November, summer which is December to February, autumn which is March to May, and winter which is June to August. However, rainfall is more abundant in the north regions and less frequent in the southern regions. PopulationAs of Friday November 1, 2024, the current population of Argentina is 45,748,377. The country is equivalent to 0.56% of the total world population. However, the country faces various challenges, including economic instability and inflation, which have impacted its social and political landscape. Despite these challenges, Argentina remains a culturally rich and diverse nation, known for its artistic contributions and passionate spirit. |
||
| Copyright 2024 – Alexa Freeman Productions |
__MACOSX/Project #1/._Argentina.html
Project #1/TheCulture.html
| |
||
| Home | Cities | Culture |
|
Argentina's history is very rich and diverse, it is shaped by indigenous cultures, colonial influence, and waves of immigration. Before Spanish colonization in the 16th century, Argentina was home to a various number of indigenous groups such as the Mapuche, Guaraní, and Quechua. Each of these groups have their own distinct languages, traditions, and social structures.In 1516 the Spanish arrived in Argentina, and by 1580, Buenos Aires had become a key port in the Spanish Viceroyalty of the Río de la Plata. Over the next few centuries, Argentina's culture developed a blend of European and indigenous influences. This is visible in Argentina's language, food, and traditions. The country gained independence from Spain in 1816, which set the stage for a new national identity.Throughout the 19th and 20th centuries, Argentina's culture was deeply impacted by waves of European immigrants, particularly Italians and Spaniards who contributed to the nation's architecture, art, and cuisine.Tango music and dance was born in Buenos Aires in the late 19th century, and became an iconic cultural export, which is symbolic to Argentina's blend of European and African heritage. Today, Argentina is known for its rich literary traditions, a passion for soccer, its world-renowned wine production, and a deep-rooted sense of national pride shaped by its complex and dynamic history. |
||
| Copyright 2024 – Alexa Freeman Productions |
__MACOSX/Project #1/._TheCulture.html
Project #1/PageStructure.css
p { font-size: 18px; color: orange; background-color: aliceblue; padding: 7px; border-radius: 20px; } img { max-width: 100%; border: 5px solid #ccc; border-color: orange; } .img123{ border: 6px solid #ccc; border-color: orange; }
__MACOSX/Project #1/._PageStructure.css
Project #1/aflag.png
__MACOSX/Project #1/._aflag.png
