History 7 – The Islamic Story of Moses (Musa in Arabic)

The Islamic story of Moses states that he was born around in 1393 BCE in Egypt during a time when the Israelites were slaves of the Pharaoh (the Coptic culture is derived from Pharonic times). The Pharaoh didn’t let the Israelites worship God. They made the Israelites worship idols like them.

The Pharaoh at the time was told that a prophet would be born from the Israelites and that this prophet would be his downfall. Not wanting that to happen, the Pharaoh made a rule that every other year, all newborn Israelite boys would be killed.

Moses was born in a year where newborn Israelite boys were killed so his mother put him in a basket, and sent him down a river, praying that God would protect him. Ofcourse, Moses would always be protected by God, and was guided to the Egyptian queen who was bathing in the river. She picked up Moses and convinced the Pharaoh to let her raise Moses as her own.

Moses’s mother was in despair that she had lost her son but God would not let her stay in that state for long.  God made sure that Moses would not suckle on any other woman’s breast making the queen look for someone who could breastfeed him.  When Moses’s sister, Miriam, heard that her brother was safe and needed a wet nurse, she suggested a woman to the queen who happened to be her mother.   Baby Moses knew that this was his mother, and latched on.  The queen saw that Moses liked this “strange woman”, and made her his nanny.

Moses grew up in the palace with his mother as his caretaker. He learned  to read and write, everything a prince would need to know. By the time he was a young man, he was exceptionally strong and educated but he had a stutter which made him very self-conscious.

When Moses became a young man, he saw an Israelite in a fight with an Egyptian. The Israelite called on Moses for help. Moses went over and punched the Egyptian, killing him.  Moses was scared for his life, and fled Egypt.

Moses had no idea where he was going. He just ran away from Egypt.  His aimless escape led him to Madyan (or Midian in English). It is supposed to be located on the east shore of the Gulf of Aqaba on the Red Sea.  When he reached Madyan, he saw two women trying to lift a boulder that was blocking a well.  When Moses saw that, he offered to help lift the boulder and get water for them. The women expressed their gratitude to Moses, and then hurried home to tell their elderly father about him.  Their father told them to go find Moses and invite him to dinner.  Moses, who was tired and hungry, accepted the invitation and joined the women and their father for dinner.

At dinner, the women’s father told Moses that he planned to wed his daughters soon, and that if Moses worked for him for 8 years, he could marry one of his daughters. If he worked for 10 years, Moses could choose which daughter he wanted to marry. Moses, who wasn’t planning to go back to Egypt anytime soon, chose 10 years of work, and claimed one of the daughters, Zipporah, as his wife.

Moses started to miss his family, and since nothing stopped him from going to Egypt, he left with Zipporah.  On the way, they got lost in the middle of the night and saw a fire in the distance. Thinking that there would be people there to help them, they rode in the direction of the fire. The fire turned out to be God calling out to Moses. God told Moses to throw down his staff, and when Moses did, God turned the staff into a giant snake to prove that He was God.  Moses got scared and started to run away from the snake but God told him to come back, and not to be afraid of the snake.  Another miracle that God showed Moses to convince him that He was God was to turn his hand into a shining bright light when he touched his heart inside his shirt. God then told Moses to go talk to the Pharaoh, and convince him to free the Israelites, and remind him of the Sovereignty of God. Moses thought that this would never work because he had a stutter but God reassured him and said that he could ask his brother Aaron to help him.

When Moses arrived in Egypt, he called on Aaron to help him convince the Pharaoh to free the Israelites. Aaron agreed and headed to the palace with Moses.  Aaron told the Pharaoh to free the Israelites, and if he didn’t, he would be disobeying a command of God.  The Pharaoh was greatly angered with Moses.  The Pharaoh declared that he was god, and that he would never free the Israelites. To prove that God was more powerful than the Pharaoh, Moses challenged the Pharaoh and his court.  The Pharaoh declared that there would be a public duel between his magicians and Moses.

The Pharaoh’s magicians went first, casting down their staffs and ropes, and making it look like they were moving like snakes. When it was Moses’s turn, he threw down his staff which turned  into a snake larger than before and ate the magicians’ snakes on the items on the ground. The magicians, as well as all the onlookers, saw that God’s power was far superior. The magicians accepted Moses’s God as the One True God. The magicians repented, and God, being All Forgiving, forgave them.   The Pharaoh was infuriated that his magicians had been defeated in the duel in front of the public.

Moses and Aaron realized that the Pharaoh wasn’t going to free the Israelites anytime soon. So, they devised a plan to sneak the Israelites out of Egypt. In the dark of night, Aaron and Moses collected the Israelites and snuck out.

The next morning the guards discovered that the Israelites were gone and informed the Pharaoh. He was furious that Moses and Aaron had taken the Israelites. The Pharaoh created a search team, including himself, and set off in the direction the people went.

The Israelites were trapped at the edge of the Red Sea with the Pharaoh closing in behind them. God told Moses to hit his staff on the ground. When the staff hit the ground, the Red Sea parted in two, and Moses and the Israelites  were able to pass through.  The Pharaoh and his men also tried to pass through but the water closed on the Pharaoh and his men, drowning them.  It is said that the Pharaoh accepted Moses’s God before drowning.

After crossing the Red Sea, the Israelites continued on to their Promised Land with Moses and Aaron.  They hadn’t brought much food when they escaped so God made sure that every morning when they woke up, there would be food on the ground for them. God also provided fresh springs of water for them to drinks.

But the Israelites were not grateful. Aaron and Moses kept trying to remind the people how much God had given them but were unsuccessful.  When the time came to take their Promised Land from the disbelievers, they refused.  The Israelites insisted that it was impossible. They claimed they wouldn’t succeed  because the disbelievers had a larger army.   Moses and Aaron reminded them that they would be protected by God like always. But they still refused.

As punishment for not obeying Him, God “cursed” the Israelites to wander the desert for forty years without a determined home.

While travelling across the desert, Moses saw a burning bush at the top of a hill called Mount Toor (now known as Mount Sinai). Moses recognized it as God wanting to talk to him, and left the Israelites with Aaron.  When Moses got to the top of the hill, God told him to write down what He dictated, which was the Torah (i.e. The Law). Moses finished inscribing the Torah on tablets after forty days and nights.

Moses was very happy that he had the Torah for the people. When he reached the bottom of the hill, he saw what the people were doing while he was away.  They had melted gold and constructed a golden calf to worship.  Moses was greatly angered that the people had slipped back into idol worship, and that Aaron had let them do this.  Aaron claimed that the people threatened him if he didn’t let them make the calf.

After wandering across the Sinai desert (in the Sinai Peninsula)for forty years with the Israelites, Moses finally died at the age of 120 years-old.  Before his death, he asked God if he could live for a little longer to lead the Israelites but God said no, and that it was his time.  Who can argue with God?

As you can see, Moses spent almost all of his life leading and helping the Israelites. In my opinion his biggest achievement in life was delivering the Torah, or the Law, to the Israelites. The fact that Moses asked God for more years to live to lead the Israelites just shows how dedicated he was to them.

History 7 – Islamic History After the Death of Prophet Muhammad

After the death of Prophet Muhammad, there were several Islamic Dynasties.  In this essay I am going to briefly explain each of these dynasties.

The Rightly Guided Caliphs

The first dynasty after the Prophet, the Ummah (the community) elected four of the closest Companions to the Prophet.  Abu Bakr, Umar, Uthman, and Ali were chosen to be the successors or Caliphs.  They were known as the Rightly Guided Caliphs.  You can think of them as the most able apprentices.  They ruled the Islamic state of Medina and defended it.  Abu Bakr was a caliph for only two years before his death in 634 CE.  He was then succeeded by Umar who created a Council of six senior Companions to elect the next Caliph in 644 CE, which was fitting as he was assassinated that year.  The Council then elected Uthman to be the next Caliph.  Uthman was a Caliph for 12 years before being assassinated as a result of a conspiracy.  The Council then elected Ali to be the next Caliph.  Ali was then assassinated five years later.

All four Caliphs spread the message of Islam and defended Islamic communities, sometimes through war, and expanded the reach of Islam from northern Africa to the Middle East to Persia (modern day Iran).  It was during the reign of Umar that Jerusalem was captured by the Muslims in 638 CE.  For the first time in over 500 years, the Jews were allowed to return to Jerusalem.  Jews had been expelled by the Romans in 70 CE.

The Umayyads

The Umayyad dynasty was founded by Mu’awiyah, a Companion of the Prophet.  After the death of Mu’awiyah, his son was appointed to succeed him, effectively replacing the governance by principle of consultation to a dynastic (monarchy) rule.  The Umayyads lasted for 89 years before being succeeded by the Abbasids.

In 732 CE, the Umayyads were defeated at the Battle of Tours by the Franks in modern day France; this is regarded as a decisive battle.  If the Muslims had won, they would have continued to conquer the rest of Europe.

In that time, the Umayyads were known for their military skills, architecture, and the minting of the earliest silver and gold Islamic coins.  They also introduced Arabic as the main language in Iraq, Syria, Egypt, and Persia.  They had expanded the Islamic empire, in the west from North Africa to modern day Spain and Portugal (then called Al Andalusia), and in the east to modern day Afghanistan and Pakistan.

Umar ibn Abd al-Aziz was the great-grandson of Umar ibn al-Khattab, the second Rightly Guided Caliph.  Umar was one of the best Umayyads and was known as the Fifth Rightly Guided Caliph because of his fairness and kindness.

In 750 CE, the last Umayyad Caliph, Marwan II, was killed by the Abbasids marking the end of the Umayyad dynasty and the start of the Abbasids.

The Abbasids

The Abbasid dynasty took over the Umayyads in 750 AD.  It lasted 508 years.

Under the Abbasid caliph, Abdallah al-Ma’mun, mathematics, medicine, astronomy, algebra, geometry, trigonometry and optics were developed.

Harun al-Rashid ruled for 23 years (786 CE – 809 CE).  Those years were known as the golden age of the Abbasid dynasty.  In his reign he worked to establish political stability and economic success.

The Abbasids had a golden age of learning from 750 CE to 945 CE.  Until the twenty-third Abbasid caliph, al-Mustakfi, was forced to abdicate in favor of the effective ruler of Iraq, Buyid ruler Mu’izz al-Dawla Ahmad.  Mu’izz kept the Abbasids as mere figureheads.

From 945 CE to 1258 CE, the Abbasids struggled to get their power back but never reached the height they once held.  In 1258 CE, they fell to the Mongol invasion lead by Genghis Khan’s grandson Hulegu Khan.  Hulegu then established the Ilkhanid Dynasty that favored Buddhism and Nestorian Christianity for about 40 years.

The Mamluks

The Mamluk dynasty was originated from a Turkish military household.  In 1250 CE, they gained power by taking control of Egypt and Syria from the Ayyubids.  The Mamluks lasted 267 years (1250-1517).

Unlike the Abbasid dynasty, the Mamluks were a warring dynasty.  They never had a golden age of education or learning.

The most notable battle that the Mamluks fought was The Battle of Ayn Jalut (in modern day Palestine) in 1260 CE.  They defeated the Mongols who had wiped out the Abbasid dynasty.  This battle is marked as one of the great turning points in history.  If the Mongols had won they might have continued to conquer all of North Africa and Europe.

In 1517 CE, the Ottoman conquest through Syria and Egypt put an end to Mamluk dynasty.

The Ottomans, the Safavids, and the Mughals

The Ottoman Empire lasted 641 years (1281 CE – 1922 CE).  They emerged from what is modern day Turkey and started to gain power in 1357 CE as they started to expand into Europe.

The Ottomans also created a force within their army called the Janissaries (like the modern day Marines).  These were forcefully-recruited young Christian boys (from the ages of 10 – 12), converted them to Islam, and then trained them for battle.  For some poor families of conquered lands, it was a road out of poverty for their children.

In 1453 CE, the Ottoman Turks conquered Constantinople (modern day Istanbul) in their defeat of the Byzantine Empire.  They continued the expansion of their Empire into Europe.  In 1683 CE, the Ottomans Turks lost to the Holy Roman Empire in The Battle of Vienna.  Since then, they never could regain their power and in 1922 CE, the Ottomans finally collapsed due to the expansion of European powers post-World War I.

Meanwhile, The Safavid Empire had been established in the east in modern day Iran and Afghanistan.  The Safavid Empire lasted 221 years (1501 CE – 1722 CE).  They were a Turkic dynasty and they were supporters of the arts.  During their time paintings, carpets, textiles, ceramics, and architecture were considered great accomplishments.

Another Muslim Empire at about the same time, the Mughal Empire (descendants of the Mongol invasions), the Mughals lasted 332 years (1526 CE – 1858 CE).  They ruled most of modern day India and Pakistan.

During the height of the Mughal Empire, a man named Shah Jahan ruled.  He loved his wife Mumtaz Mahal more than anything in the world.  When she passed, he built the Taj Mahal as a tomb for her.  When Shan Jahan died he was also buried there.

In 1857 CE, British Indian soldiers revolted against the British rule in India (the Sepoy Uprising).  The British then attacked Delhi and ended the Mughal Empire.

The Start of a New Empire

By 1900 CE, nine European empires and Chinese empires ruled over 80% of the once great Muslim Empires.  Only 20% of the Muslims lived in the remaining Muslim states: the Ottoman Empire, Persia, the Arabian Peninsula, Morocco, and Afghanistan.  During World War 1, the British and the French signed a treaty agreeing to split the lands that the Ottoman Empire once owned.

In 1924 CE, the 600-year old Ottoman dynasty was exiled from Turkey, marking the end of all Muslim Empires.

Conclusion

In this essay, you can see how Islam grew and spread from a small community in the Arabian desert to multiple empires that spread from Spain to Indonesia, and contributed to science, arts and trade.  By the end of World War I, all Muslim empires had disintegrated.  From them emerged, many Muslim majority nations none of which are leading powers in the world.  Indeed, many Muslim majority nations are among the poorest in the world in 2020.   The golden age of Islam is long past.

Muslims now look forward to the Second Coming of Jesus to a world governed by God’s commandments.

English 7 – My Term Paper: A Review of Literature

In 7th Grade English, I learned about three types works of Literature:  Genres, Stories, and Poetry.  In this essay, I am going to talk about what I have learned in each, how they are developed in Fiction and Non-fiction works, and how Voices play a part in each.  Additionally, I will also share a section on Worldviews which is a special kind of non-fiction.

In Literature, there are two categories: fiction and non-fiction.  Fiction is from the author’s imagination, and non-fiction, which is based on actual events and is real.

Genres

Many genres like mystery, history, fantasy, and many more are found in fiction.  The term genre is not very specific as there is quite a bit of overlap.  For example, realistic fictions (going on in the real world) happen in a setting of historical significance.

In fiction, there are also different types of writings like novels, novellas, poetry, and short stories.  Non-fiction can also include short stories and poetry.

Stories

Short stories are quick and simple.  Usually, they contain one or more morals but can also just be for fun.  Novels are longer stories, like Harry Potter or Lord of the Rings.  Then, there are novellas which are stories whose length in between short stories and novels.

Poetry

Poetry is a little more complex.  Usually, people think that poetry has to rhyme, but it does not have to; there just needs to be a certain rhythm to it.  There are many types of poetry or lines of poetry: trimeters, tetrameters, pentameters, hexameters, heptameters, octameters, and many more.  These are made up of metrical feet.

How do feet come into poetry?  In poetry, “foot” means a group of syllable that forms a metrical unit.   English poetry consists of stressed and unstressed syllables.  Unlike classical poetry, it consists of long and short syllables.

As I stated earlier, poetry does not have to rhyme.  But when it does rhyme, there are different types, like masculine and feminine, exact and approximate rhymes, and many more.  Masculine rhymes are rhymes of the finale stressed syllables.  For example, collect and direct.  Feminine rhymes are rhymes between stressed syllables followed by one or more unstressed syllables.  For example, jogging and logging.  Exact rhymes are when words rhyme exactly.  For example, dog and bog.  Approximate rhymes are when words rhyme approximately.  For example, dusk and must.

Construct of a Fictional Work

I learned there are five constructs that make fiction work:  plot, setting, character development, author’s style, and theme.

In the plot, there are five parts: exposition, rising action, climax, falling action, and resolution.

  • The exposition is the beginning. The characters get introduced and we learn the background of some of these characters.
  • The rising action is when the problem arises and when the story begins to come together.
  • The climax is when something important happens, someone dies, the enemy is defeated, etc.
  • The falling action is after the climax, usually when the story is coming to an end.
  • In the resolution, everything is solved, the problem is over and the story is competed.

The second thing that makes fiction work is the setting.  It is comprised of six parts:  the juxtaposition, milieu, tone, mood, visualization, and customs.

  • Juxtaposition is when two objects are placed together for contrast to make it easier for the reader to grasp what is going on.
  • Milieu is the personality of a character. How they would react in a situation, how they talk, or even how they walk.
  • Tone is how the story is told; it could be whimsical or grim or mysterious. It is however the author wants to portray the story.
  • Mood is similar to the tone. It is the atmosphere of the story.
  • Visualization is what the reader sees in his or her mind. The author would put time into describing things so you could understand how the character looks, or how the place around them looks.
  • Finally, customs, is the culture of the people in the story.

The third part of fiction is character development.  It is just like what the name says.  How the character evolves or matures throughout the story.  If you have ever read Harry Potter, you can really see how the character Snape evolved through the series.  There are two types of characters:  the protagonists and the antagonists.  The protagonists are the “good guys” and the antagonists are the “bad guys”.  Back to my example of Snape:  when the series started he was the antagonist, whereas, at the end of the series, he was the protagonist.

The fourth part of fiction is the author’s style.  It is like the tone of the story.  Author’s style is however the author likes to right their books.  They could put in a lot of dialogue or describe every detail.

The fifth, and final, part of fiction is theme.  It is the message, or messages, that the author meant to put into the story.  There is no wrong or right answer since no one can know what the author thinks.  Sometimes the theme can be very obvious, while at other times, it can be more subtle.

Construct of a Non-fictional Work

There are two different types of non-fiction:  biographies and autobiographies.  Biographies are when someone writes a book about another person’s life.  Autobiographies are basically the same, except this time the subject is the one writing the book.

Voices

In Literature, there are two types of voices:  active and passive.

Active voice is when the subject does the action.  Active voice sounds like this:  I ate all of the ice cream.

Passive voice is when the subject is acted upon.  Passive voice sounds like this:  All of the ice cream was eaten by me.

Most authors prefer to use active voice.  It is easier to use and sounds better.

Worldviews

Let’s discuss worldviews now.  A worldview is how the author views the world or what they believe in.  I learned about fifteen different worldviews this year: theism, atheism, rationalism, transcendentalism, naturalism, pragmatism, nihilism, existentialism, postmodernism, deism, materialism, new age pantheism, humanism, hedonism, and socialism.

  • Theism is the belief of a higher entity that made the whole world.
  • Atheism is the exact opposite of theism. It is the belief that there is no god in the universe and that the world just came to be.
  • Rationalism is the belief that logic and reason is the answer for everything.
  • Transcendentalism is the belief that men and women should have knowledge about themselves and the world around them that “transcends” or goes beyond what they can see, hear, taste, touch or feel.
  • Naturalism is the belief that nature is the only explanation for anything.
  • Pragmatism is the belief that any practical ideas or theories are accepted. While unpractical ideas are to be rejected.
  • Nihilism is the belief that nothing in this world is real. Anyone who follows this worldview would feel like he or she have no purpose and they probably will not anything with their life.
  • Existentialism is the belief that everyone’s actions or beliefs is of their free will.
  • Postmodernism is the belief of living by your own rules and nobody else’s. This sounds like a good belief, but if the whole world followed this there would be crime.  If someone thinks that murder is not bad, no one can interfere.
  • Deism is the belief of One Supreme Being.
  • Materialism is the belief that everything is real; matter is the only substance.
  • New age pantheism is the belief that everything is just a part of something bigger.
  • Humanism is the belief that man is the center of everything.
  • Hedonism is the belief that all actions can be measured by how high the pleasure is and how low the pain is.
  • The last worldview, Socialism, is the belief of status quo. If you do not have wealth, you are less than others who do have wealth.

If you read how the author writes, you may be able to tell what worldview they have.

Conclusion

This year has been a very fun year with all the readings and short videos.  I learned many things that I did not know before like the six parts of setting and how there can be different ways how poetry flows.  My favorite part of the year was all the readings.   I specifically like “Little Men” by Louisa May Alcott the most.  I had been meaning to read the book but never got the time.  If 8th Grade English is like this year I can’t wait!

Grade 7 Science: Coding Project 16 – App Impersonator

This project is from the SQL section on Khan Academy.

The objective of this project is to make your own app.

https://www.khanacademy.org/computer-programming/spin-off-of-project-app-impersonator/6188009854681088

CREATE TABLE diary_app (id INTEGER PRIMARY KEY AUTOINCREMENT,
entry_date TEXT,
emotions TEXT,
entry TEXT);

INSERT INTO diary_app VALUES (1, “2020-05-25”, “happy”, “I did a project in coding today!”);
INSERT INTO diary_app VALUES (2, “2020-05-26”, “happy”, “I finished SQL in Khan Academy today!”);
INSERT INTO diary_app VALUES (3, “2020-05-27”, “crappy”, “I had a Math exam today!”);
UPDATE diary_app SET entry = “I did great in Math today!”, emotions = “bored” WHERE id = 3;

DELETE FROM diary_app WHERE id = 3;

SELECT * FROM diary_app;

Grade 7 Science: Coding Project 15 – Famous People

This project is from the SQL section on Khan Academy.

The objective of this project is make your own table from multiple given tables.

https://www.khanacademy.org/computer-programming/spin-off-of-project-famous-people/6507415377690624

 

CREATE TABLE Harry_Potter_Characters (id INTEGER PRIMARY KEY AUTOINCREMENT,
fullname TEXT,
gender TEXT,
skill_id1 INTEGER,
skill_id2 INTEGER,
house_id INTEGER)
;

CREATE TABLE Skill_Sets (id INTEGER PRIMARY KEY AUTOINCREMENT,
skill TEXT,
skill_id INTEGER)
;

CREATE TABLE house (id INTEGER PRIMARY KEY AUTOINCREMENT,
house_name TEXT,
house_id INTEGER)
;

INSERT INTO Harry_Potter_Characters VALUES(1, “Harry Potter”, “Male”, 1,5 ,1);
INSERT INTO Harry_Potter_Characters VALUES(2, “Ron Weasley”, “Male”,1,5,1);
INSERT INTO Harry_Potter_Characters VALUES(3, “Hermione Granger”, “Female”,2,3,1);
INSERT INTO Harry_Potter_Characters VALUES(4, “Ginny Weasley”, “Female”,1,5,1);
INSERT INTO Harry_Potter_Characters VALUES(5, “Neville Longbottom”, “Male”,4,5,1);
INSERT INTO Harry_Potter_Characters VALUES(6, “Luna Lovegood”, “Female”,3,5,4);
INSERT INTO Skill_Sets VALUES(1, “Defense Against the Dark Arts”, 1);
INSERT INTO Skill_Sets VALUES(2, “Spells”, 2);
INSERT INTO Skill_Sets VALUES(3, “Potions”, 3);
INSERT INTO Skill_Sets VALUES(4, “Botany”, 4);
INSERT INTO Skill_Sets VALUES(5, ” “, 5);

INSERT INTO house VALUES (1, “Gryffindor”, 1);
INSERT INTO house VALUES (2, “Slytherin”, 2);
INSERT INTO house VALUES (3, “Hufflepuff”, 3);
INSERT INTO house VALUES (4, “Ravenclaw”, 4);

SELECT Harry_Potter_Characters.fullname, Harry_Potter_Characters.gender, A.skill AS “skill one”, B.skill AS “skill two”, House.house_name
FROM Harry_Potter_Characters
LEFT OUTER JOIN Skill_Sets A
ON Harry_Potter_Characters.skill_id1 = A.skill_id
LEFT OUTER JOIN Skill_Sets B
ON Harry_Potter_Characters.skill_id2 = B.skill_id
LEFT OUTER JOIN house
ON Harry_Potter_Characters.house_id = house.house_id
ORDER BY house.house_name
;

Grade 7 Science: Coding Project 14 – Data Dig

This project is from the SQL section on Khan Academy.

The objective of this project is to make your own table based of a given table.

https://www.khanacademy.org/computer-programming/spin-off-of-project-data-dig/5081659215855616

 

CREATE TABLE marvels (ID INTEGER PRIMARY KEY,
name TEXT,
popularity INTEGER,
alignment TEXT,
gender TEXT,
height_m NUMERIC,
weight_kg NUMERIC,
hometown TEXT,
intelligence INTEGER,
strength INTEGER,
speed INTEGER,
durability INTEGER,
energy_Projection INTEGER,
fighting_Skills INTEGER);

INSERT INTO marvels VALUES(1, “Spider Man”, 1, “Good”, “Male”, 1.78, 75.75, “USA”, 4, 4, 3, 3, 1, 4);
INSERT INTO marvels VALUES(2, “Iron Man”, 20, “Neutral”, “Male”, 1.98, 102.58, “USA”, 6, 6, 5, 6, 6, 4);
INSERT INTO marvels VALUES(3, “Hulk”, 18, “Neutral”, “Male”, 2.44, 635.29, “USA”, 1, 7, 3, 7, 5, 4);
INSERT INTO marvels VALUES(4, “Wolverine”, 3, “Good”, “Male”, 1.6, 88.46, “Canada”, 2, 4, 2, 4, 1, 7);
INSERT INTO marvels VALUES(5, “Thor”, 5, “Good”, “Male”, 1.98, 290.3, “Asgard”, 2, 7, 7, 6, 6, 4);
INSERT INTO marvels VALUES(6, “Green Goblin”, 91, “Bad”, “Male”, 1.93, 174.63, “USA”, 4, 4, 3, 4, 3, 3);
INSERT INTO marvels VALUES(7, “Magneto”, 11, “Neutral”, “Male”, 1.88, 86.18, “Germany”, 6, 3, 5, 4, 6, 4);
INSERT INTO marvels VALUES(8, “Thanos”, 47, “Bad”, “Male”, 2.01, 446.79, “Titan”, 6, 7, 7, 6, 6, 4);
INSERT INTO marvels VALUES(9, “Loki”, 32, “Bad”, “Male”, 1.93, 238.14, “Jotunheim”, 5, 5, 7, 6, 6, 3);
INSERT INTO marvels VALUES(10, “Doctor Doom”, 19, “Bad”, “Male”, 2.01, 188.24, “Latveria”, 6, 4, 5, 6, 6, 4);
INSERT INTO marvels VALUES(11, “Jean Grey”, 8, “Good”, “Female”, 1.68, 52.16, “USA”, 3, 2, 7, 7, 7, 4);
INSERT INTO marvels VALUES(12, “Rogue”, 4, “Good”, “Female”, 1.73, 54.43, “USA”, 7, 7, 7, 7, 7, 7);
INSERT INTO Marvels VALUES(13, “Storm”, 2, “Good”, “Female”, 1.80, 66, “Kenya”, 2, 2, 3, 2, 5, 4);
INSERT INTO Marvels VALUES(14, “Nightcrawler”, 6, “Good”, “Male”, 1.75, 73, “Germany”, 3, 2, 7, 2, 1, 3);
INSERT INTO Marvels VALUES(15, “Gambit”, 7, “Good”, “Male”, 1.88, 81, “EUA”, 2, 2, 2, 2, 2, 4);
INSERT INTO Marvels VALUES(16, “Captain America”, 9, “Good”, “Male”, 1.88, 108, “EUA”, 3, 3, 2, 3, 1, 6);
INSERT INTO Marvels VALUES(17, “Cyclops”, 10, “Good”, “Male”, 1.90, 88, “EUA”, 3, 2, 2, 2, 5, 4);
INSERT INTO Marvels VALUES(18, “Emma Frost”, 12, “Neutral”, “Female”, 1.78, 65, “EUA”, 4, 4, 2, 5, 5, 3);
INSERT INTO Marvels VALUES(19, “Kitty Pryde”, 13, “Good”, “Female”, 1.68, 50, “EUA”, 4, 2, 2, 3, 1, 5);
INSERT INTO Marvels VALUES(20, “Daredevil”, 14, “Good”, “Male”, 1.83, 91, “EUA”, 3, 3, 2, 2, 4, 5);
INSERT INTO Marvels VALUES(21, “Punisher”, 50, “Neutral”, “Male”, 1.85, 91, “EUA”, 3, 3, 2, 2, 1, 6);
INSERT INTO Marvels VALUES(22, “Silver Surfer”, 33, “Good”, “Male”, 1.93, 102, “Zenn-La”, 3, 7, 7, 6, 7, 2);
INSERT INTO Marvels VALUES(23, “Ghost Rider”, 86, “Good”, “Male”, 1.88, 99, “EUA”, 2, 4, 3, 5, 4, 2);
INSERT INTO Marvels VALUES(24, “Venon”, 78, “Neutral”, “Male”, 1.90, 118, “EUA”, 3, 4, 2, 6, 1, 4);
INSERT INTO Marvels VALUES(25, “Juggernaut”, 76, “Neutral”, “Male”, 2.87, 862, “EUA”, 2, 7, 2, 7, 1, 4);
INSERT INTO Marvels VALUES(26, “Professor X”, 58, “Good”, “Male”, 1.83, 86, “EUA”, 5, 2, 2, 2, 5, 3);

SELECT gender, AVG(height_m)
FROM marvels GROUP BY gender;

SELECT gender, COUNT(*)
FROM marvels GROUP BY gender;

SELECT gender, MIN(height_m)
FROM marvels GROUP BY gender;

SELECT gender, MAX(height_m)
FROM marvels GROUP BY gender;

SELECT gender,
COUNT(*),
MAX(height_m),
MIN(height_m),
AVG(height_m)
FROM marvels
GROUP BY gender;
SELECT * FROM marvels;
SELECT alignment, COUNT(*) FROM marvels
GROUP BY alignment;

SELECT name FROM marvels
WHERE alignment = “Good”;

SELECT * FROM marvels ORDER BY name;

SELECT MIN(popularity) FROM marvels;
SELECT MAX(popularity) FROM marvels;
SELECT * FROM marvels WHERE popularity <= 50 AND gender = “Male”
ORDER BY popularity;

SELECT * FROM marvels WHERE height_m = 1.6 AND popularity <= 46;
SELECT name, fighting_skills, gender,
CASE
WHEN intelligence >= 1 AND intelligence < 3 THEN “Dumb”
WHEN intelligence >= 3 AND intelligence < 5 THEN “Average”
WHEN intelligence >= 5 AND intelligence <= 7 THEN “Smart”
ELSE “Missing”

END “Brainpower”
FROM marvels
GROUP BY name;

Grade 7 Science: Coding Project 13 – Design a Store Database

This project is from the SQL section in Khan Academy.

The objective of this project is to design a store’s database.

https://www.khanacademy.org/computer-programming/spin-off-of-project-design-a-store-database/4839932328558592

 

CREATE TABLE Sophia_Candy_Store(id INTEGER PRIMARY KEY, name TEXT, price INTEGER, weight INTEGER, aisle TEXT);

INSERT INTO Sophia_Candy_Store VALUES(1, “M&M”, 1, 10, “Chocolate Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(2, “Hershey”, 2, 50, “Chocolate Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(3, “Almond Joy”, 1, 10, “Chocolate Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(4, “Reese’s Pieces”, 3, 30, “Chocolate Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(5, “Bounty”, 2, 70, “Chocolate Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(6, “Werthers”, 5, 100, “Hard Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(7, “Altoids”, 3, 200, “Hard Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(8, “Jolly Ranchers”, 6, 300, “Hard Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(9, “Runts”, 2, 100, “Hard Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(10, “Giant Jawbreakers”, 5, 300, “Hard Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(11, “Jelly Beans”, 2, 200, “Chewy Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(12, “Mentos”, 5, 100, “Chewy Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(13, “Atomic Fireballs”, 6, 300, “Chewy Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(14, “Skittles”, 4, 100, “Chewy Candy Aisle”);
INSERT INTO Sophia_Candy_Store VALUES(15, “Starburst”, 5, 200, “Chewy Candy Aisle”);
SELECT * FROM Sophia_Candy_Store;

SELECT * FROM Sophia_Candy_Store GROUP BY name;

Grade 7 Science: Coding Project 11 – Blog

This project came from the HTML and CSS section on Khan Academy.

The objective of this project is to make your own blog.

https://www.khanacademy.org/computer-programming/project-blog/4580152491524096

 

<!DOCTYPE html>
<html>
<head>
<meta charset=”utf-8″>
<title>Project: Blog</title>
<style>
body {
background-color:rgb(245, 179, 196);
}

#FP {
background-color:rgb(255, 0, 0);
font-weight:lighter;
font-size:33.9px;
}

#SP {
background-color:rgb(245, 112, 10);
font-weight:lighter;
font-family:sans-serif;
}

#TP {
background-color:rgb(245, 245, 0);
font-weight:lighter;
}

#FFP {
background-color:rgb(25, 232, 39);
font-weight:lighter;
}

#Fri {
background-color:rgb(0, 176, 240);
font-weight:lighter;
}

#Bye {
background-color:rgb(247, 8, 247);
font-weight:lighter;
font-style:italic;
}
</style>
</head>
<body>

<h1>Sophia’s blog</h1>

<h3>Contents</h3>
<ul>
<li><a href= “#FP”>First Post!</a></li>
<li><a href= “#SP”>Online Birthday Party, Part 1</a></li>
<li><a href= “#TP”>Online Birthday Party, Part 2</a></li>
<li><a href= “#FFP”>Boredom</a></li>
<li><a href= “#Fri”>Friday!</a></li>
<li><a href=”#Bye”>Goodbye HTML and CSS!</a></li>
</ul>

<h2 id=”FP”>First post</h2>
<h6>Posted on April 27 2020</h6>

<p>Today in school I have to start writing my History essay about Prophet Jesus, do a lesson of Math, start reading my English book, and plan my English lessons.<br><br>Tomorrow is one of my BFF’s birthday party! But since we’re on lockdown her party is going to be on Zoom.<br><br>After school I plan to play Roblox with one of my new friends!</p>

<h2 id=”SP”>Online Birthday Party<br>Part 1</h2>
<h6>Posted on April 28 2020</h6>

<p>Today in school…I basically have to do what I did yesterday. One lesson of Math, History essay, and English reading.<br><br>In one hour my friend’s online birthday pary is starting! I can’t wait! She invited me and five other friends, during the call we’re going to play Brawlstars! If you don’t know what that is, it’s a game where you’re a certain character and battle others. It’s like a PG version of COD (call of duty).<br><br>I’m going to play Roblox with my friend again today! We always play together, but when lockdown is over she can’t play on the weekdays anymore,I probably can’t either.</p>

<h2 id=”TP”>Online Birthday Party<br>Part 2</h2>
<h6>Posted on April 28 2020</h6>

<p>I just finished the online birthday party with my friend! It was a lot of fun! We played Brawlstars and Skrible (that’s how you spell it). Skrible is a game where one person draws something and the other people have to guess. I’m not good at that game, but the birthday girl had fun! That’s what matters, right?</p>
<h2 id= “FFP”> Boredom</h2>
<h6>Posted on April 30 2020</h6>

<p>Today is the last day of April! Just one more month of quarintine! I can’t wait to see my friends again, all of us are going crazy. Everyone seems to have lost motivation to do anything, even reading now isn’t that fun or exciting.</p>

<h2 id= “Fri”>Friday!</h2>
<h6>Posted on May 1 2020</h6>

<p>It’s finally Friday! It’s also the first day of May! Not like it means anything…can’t go out.<br><br>After school I’m planning to play Roblox with my friend again. On Wednesday my Mom found an old book of mine that I’ve never read before. Now I have a new book that I can read over the weekend!</p>

<h2 id= “Bye”>Goodbye HTML and CSS!</h2>
<h6>Posted on May 1 2020</h6>

<p>I showed my Mom all the projects that I have been working on in the HTML and CSS course! She’s really proud of me! I’m going to show my Dad later.<br><br>Going through the lessons I realized that I’m almost done with the course! I reallly love HTML and I’ll be quite sad to leave it. But I can’t wait for the next lessons!</p>
</body>
</html>

Grade 7 Science: Coding Project 10 – Recipe Book

This project is from the HTML and CSS section on Khan Academy.

The objective of this project is to make your own recipe book.

https://www.khanacademy.org/computer-programming/project-recipe-book/4522164228866048

 

<!DOCTYPE html>
<html>
<head>
<title>Project: Recipe book</title>
<meta charset=”utf-8″>
<style>
body {
background-color:rgb(199, 216, 255);
}
h1 {
background-color:rgb(255, 163, 200);
}

#B {
background-color:rgb(135, 64, 64);
}

#C {
background-color:rgb(240, 8, 73);
}

#BB {
background-color:rgb(245, 218, 46);
}

</style>
</head>
<body>

<h1>Sophia’s Recipe Book</h1>

<h2>Contents:</h2>

<ol>
<li><a href=”#B”>Brownies</a></li>
<li><a href=”#C”>Cupcakes</a></li>
<li><a href=”#BB”>Breakfast Burrito</a></li>
</ol>

<h2 id=”B”>Brownies</h2>

<ul>
<li>Time: 1 hour</li>
<li>Serves: 3</li>
</ul>

<table>
<thead>
<tr>
<th>Ingredients</th>
</tr>
</thead>
<tbody>
</tbody>
</table>

<ol>
<li>3 Eggs</li>
<li>Brownie Mix</li>
<li>1/2 cup of water</li>
</ol>
<h3>Steps</h3>
<p><strong>Step 1:</strong> Gather all ingredients</p>
<p><strong>Step 2:</strong> Pour brownie mix into a bowl</p>
<p><strong>Step 3:</strong> Crack eggs into bowl</p>
<p><strong>Step 4:</strong> Mix and slowly add water into the mix</p>
<p><strong>Step 5:</strong> Pour batter into pan and leave it in oven for 45 min at 45 degrees F</p>

<h2 id=”C”>Cupcakes</h2>

<ul>
<li>Time: 45 mintues</li>
<li>Serves: 4</li>
</ul>

<table>
<thead>
<tr>
<th>Ingredients</th>
</tr>
</thead>
<tbody>
</tbody>
</table>

<ol>
<li>2 Eggs</li>
<li>1 cup of water</li>
<li>Cupcake mix</li>
</ol>

<h3>Steps</h3>
<p><strong>Step 1:</strong> Gather all ingredients</p>
<p><strong>Step 2:</strong> Pour mix into a big bowl</p>
<p><strong>Step 3:</strong> Crack eggs into bowl and add water</p>
<p><strong>Step 4:</strong> Mix until a thick batter</p>
<p><strong>Step 5:</strong> Pour batter into a pan and put in the oven for 30 min at 100 degrees F</p>

<h2 id=”BB”>Breakfast Burrito</h2>

<ul>
<li>Time: 15 mintues</li>
<li>Serves: 1</li>
</ul>

<table>
<thead>
<tr>
<th>Ingredients</th>
</tr>
</thead>
<tbody>
</tbody>
</table>

<ol>
<li>1 Egg</li>
<li>1 Wraps</li>
<li>Salsa(optional)</li>
<li>Sour cream(optional)</li>
<li>Cheese(optional</li>
</ol>

<h3>Steps</h3>

<p><strong>Step 1:</strong>Make scrambled eggs</p>
<p><strong>Step 2:</strong>Heat up wrap on stove top</p>
<p><strong>Step 3:</strong>Put eggs into wrap and add salsa, sour cream, and/or cheese (optional).</p>

</body>
</html>